Query in PGNP returns different results than PGadmin?

More
3 years 11 months ago #14543 by LEA_NY
Hi: I'm evaluating PGNP trial version. I have a connection to a remote PostgreSQL server that works in PGAdmin, and is also working to set up a linked server is SSMS. In SSMS linked server I'm using the "Intellisoft OLE DB Provider for PostgreSQL" with the same server, port, dB and username as in PGAdmin.

When I query a db table in PGAdmin, I get the expected results, but when I execute the same query using the [server].[db].[schema]. in SSMS, I am seeing different data...what looks like older data. How is this possible?

Is it possible that the schema is different between the two applications?

Please Log in or Create an account to join the conversation.

More
3 years 11 months ago #14544 by admin
This could be caused by the Trial limitations, specifically - the Trial returns upto 100 rows. To check if that is the case, please add ORDER BY and LIMIT 100 clauses to the query. Then result should be the same as from the pgAdmin.

Please Log in or Create an account to join the conversation.

More
3 years 11 months ago #14545 by LEA_NY
Thank you...this was indeed the issue. My query had a number of joins on tables with > 100 rows, so I was not finding the data I needed because each join only queried the first 100 rows of each table. I was able to use CTEs to narrow the result sets and join the relevant data.

Please Log in or Create an account to join the conversation.

Time to create page: 0.162 seconds
Powered by Kunena Forum