Re: [SQL] Problems with a Query between 7.3 and 8.2

2008-06-05 Thread Holm Tiffe
sathiya moorthy wrote: > add_missing_from = on > > Simple, just turn on the above option in postgresql.conf > > and restart postgres service. :-) This fixes all my Problems... Aregardless of this I've fixed all queries in the meantime. Thanks guys, Holm -- Technik Service u. Hande

Re: [SQL] Problems with a Query between 7.3 and 8.2

2008-06-04 Thread sathiya moorthy
add_missing_from = on Simple, just turn on the above option in postgresql.conf and restart postgres service. On Wed, Jun 4, 2008 at 5:35 PM, Holm Tiffe <[EMAIL PROTECTED]> wrote: > A. Kretschmer wrote: > > > am Wed, dem 04.06.2008, um 12:47:41 +0200 mailte Holm Tiffe folgendes: > > > > >

Re: [SQL] Problems with a Query between 7.3 and 8.2

2008-06-04 Thread Holm Tiffe
A. Kretschmer wrote: > am Wed, dem 04.06.2008, um 12:47:41 +0200 mailte Holm Tiffe folgendes: > > > > Hi, > > > > I have to migrate an existing System from PostgreSQL 7 and 8.2. > > There is a query that I'm not fully understand. It is running with > > 7.3.21 generating two notices about missin

Re: [SQL] Problems with a Query between 7.3 and 8.2

2008-06-04 Thread A. Kretschmer
am Wed, dem 04.06.2008, um 12:47:41 +0200 mailte Holm Tiffe folgendes: > > Hi, > > I have to migrate an existing System from PostgreSQL 7 and 8.2. > There is a query that I'm not fully understand. It is running with > 7.3.21 generating two notices about missing FROM's: > > select poid,prodort.b