Hi - I setup dblink in my PostgreSQL 9.6.14 db and reading data from PostgreSQL 9.6.11 db. My query returns 3600 rows when I run it in the Source Db, but returns only 2365 rows when I run it from the Target db through dblink. Is there a setting that I need to update or is there a limitation with dblink? Your help will be greatly appreciated. Summary: 1. SourceDB = PostgreSQL 9.6.11 2. TargetDB = PostgreSQL 9.6.14 3. Source Query = 15 columns with 3600 rows 4. Target Query via dblink: return 2365 rows only Thanks, AJ |
