DB Link returning Partial data rows

[AJ Rao]

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