Postgres Pro
Downloads
Home   >   mailing lists

Re: implicit tables syntax disappeared from 8.0->8.1 - Mailing list pgsql-general

From A. Kretschmer
Subject Re: implicit tables syntax disappeared from 8.0->8.1
Date
Msg-id 20060228151002.GD13740@webserv.wug-glas.de
Whole thread Raw
In response to implicit tables syntax disappeared from 8.0->8.1  (pg@os10000.net)
Responses Re: implicit tables syntax disappeared from 8.0->8.1  (Tino Wildenhain <tino@wildenhain.de>)
List pgsql-general
Tree view 
am  28.02.2006, um 14:01:44 +0100 mailte pg@os10000.net folgendes:
> update   t1
> set  t1f1='test'
> where  t1.t1f2=t2.t2f2
> and  t1.t1f3=t2.t2f3;
>
> unfortunately, now I get the error that t2 is not in the FROM clause.

You can set

add_missing_from

in yout postgresql.conf, but please read
http://www.postgresql.org/docs/8.1/interactive/runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-general by date:

Previous
From: pg@os10000.net
Date:
Subject: implicit tables syntax disappeared from 8.0->8.1
Next
From: "Ets ROLLAND"
Date:
Subject: Problem with PostgreSQL 8.1.3 on Windows XP Pro