search

michaelsogos / pg-diff

PostgreSQL schema and data comparing tool
MIT License
170 stars 17 forks source link

error: column p.prokind does not exist #23

Closed JonathonCwik closed 4 years ago

JonathonCwik commented 4 years ago

error: column p.prokind does not exist

Sorry, don't have much here, and a little debugging shows that the issue is actually in the pg-diff-api node module but it's through this so I figured I'd make the issue here. I ended up fixing it by removing the AND p.prokind = 'f'

michaelsogos commented 4 years ago

Hi @SMASH1337,

This is related to #24. That "f" stand for function and "a" stand for aggregate function and "w" stand for window function. :smile:. So, probably i missed a Pgsql version specification. Can you tell me which pg version you use?

JonathonCwik commented 4 years ago

@michaelsogos 9.6.11.

That makes sense, in my pull request in the pg-diff-api, I added a check to ignore aggregate functions rather than using prokind.

michaelsogos commented 4 years ago

Hi @SMASH1337 ,

Bug fixed. Thanks for the issue!