On Wednesday 02 December 2009 4:04:47 pm erobles wrote: > erobles wrote: > > Hi! > > > > In postgresql 7.2 i can use this kind of querys: > > > > select table.* ; > > > > select * from table1 where table1.key=othertable.key; > > > > > > but in postgresql 8.3 i have an error like this: > > ERROR: missing FROM-clause entry for table ... > > > > > > what should i do to solve this? :-) Short term see here for config setting in postgresql.conf that can revert the behavior. http://www.postgresql.org/docs/8.3/interactive/runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION Long term, change the queries :) -- Adrian Klaver aklaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general