ARE JOINS ALLOWED IN UPDATE STATEMENTS? - Mailing list pgsql-novice

From Ryan Riehle
Subject ARE JOINS ALLOWED IN UPDATE STATEMENTS?
Date
Msg-id 000801c4d70e$55338410$7d01a8c0@buildways
Whole thread Raw
In response to Re: What causes 'FATAL: invalid cache id: 30' in my postgresql log?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Whether they are or not, could you please give me a syntax I can use to
update FROM multiple tables (>2)? I prefer to use a syntax that includes
'join'.


-RYAN


-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Tom Lane
Sent: Monday, November 29, 2004 11:48 PM
To: Evert Meulie
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] What causes 'FATAL: invalid cache id: 30' in my
postgresql log?


Evert Meulie <evert@witelcom.com> writes:
> Strange... I'm using the Gentoo-version of PostgreSQL 7.4.6 and since
> it's a fresh install of PostgreSQL, all components are of the same
> version...

But are you sure there wasn't a previous version of PG already on the
machine?  It sure looks to me like you have some code that's out of step
about the syscache numbers, and as I said the most likely theory for that is
an out-of-date plpgsql.so getting picked up from someplace.

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: sequence newbie question
Next
From: "Thomas Hermann(Software)"
Date:
Subject: Re: views with parameters