Re: implicit tables syntax disappeared from 8.0->8.1

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: implicit tables syntax disappeared from 8.0->8.1
Date: 2006-02-28 15:10:02
Message-ID: 20060228151002.GD13740@webserv.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

am 28.02.2006, um 14:01:44 +0100 mailte pg(at)os10000(dot)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 ===

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ets ROLLAND 2006-02-28 15:12:12 Problem with PostgreSQL 8.1.3 on Windows XP Pro
Previous Message Martijn van Oosterhout 2006-02-28 14:59:54 Re: indexes