postbird: Error: column "relhasoids" does not exist

I’m using postgres 12 and this is the error:

Error: column “relhasoids” does not exist Query: SELECT relhasoids FROM pg_catalog.pg_class, pg_catalog.pg_namespace n WHERE n.oid = pg_class.relnamespace AND nspname = ‘public’ AND relname = ‘users’`

Screenshot from 2019-10-07 10-03-41

About this issue

  • Original URL
  • State: closed
  • Created 5 years ago
  • Reactions: 4
  • Comments: 15 (4 by maintainers)

Most upvoted comments

According postgres documentation, in version 12 the OID was removed and Postbird not was updated with this feature still. So if you using Postbird, you can use just until postgres 11

Same here, apparently this error only happens on postgres 12, i’ve installed postgres 11 and worked fine

Same here ;/

@tassiorego That issue because app is not signed by developer certificate For first time:

  1. Open “Applications”
  2. use right click on Postbird.app -> Open Screen Shot 2019-11-20 at 14 13 17