Thread: problem with pgAdmin 7.4 & PosgreSQL 10.23

Hello trying to run a query like this 

Select * from measures ORDER by id desc limit 100

I get the following error message:

entrée manquante de la clause FROM pour la table « rel » LINE 8: ...ER JOIN pg_catalog.pg_constraint con ON con.conrelid=rel.oid

(which translates to

Missing entry in FROM clause for table < rel >

This happens regardless of the database and table on the same server.

Note The same query runs fine with PostGreSQL 15

I am running Linux Mint 21.1  

Any idea ?

Hello!

Same problem here.

Thanks

dd

Didier Gasser-Morlay <didiergm@gmail.com> ezt írta (időpont: 2023. júl. 20., Cs, 17:35):

Hello trying to run a query like this 

Select * from measures ORDER by id desc limit 100

I get the following error message:

entrée manquante de la clause FROM pour la table « rel » LINE 8: ...ER JOIN pg_catalog.pg_constraint con ON con.conrelid=rel.oid

(which translates to

Missing entry in FROM clause for table < rel >

This happens regardless of the database and table on the same server.

Note The same query runs fine with PostGreSQL 15

I am running Linux Mint 21.1  

Any idea ?