Hey, I'm using a singer tap to fetch some data from an api and load it into a postgres db using the

target-postgres

loader. But its missing some of the records. These records are showing up fine when loaded into a csv file. The tap is also fetching the records right but it simply doesn't show up when loaded into postgres. It looks like the issue is with the postgres loader but I'm not sure how to go about fixing it. Any ideas?

I'd try an approach like the one listed here https://gitlab.com/meltano/meltano/-/issues/2958 Create a file from your source, find the records of concern, run the target with just those records. See if you can find the issue. I've never seen target-postgres miss records myself