From: | "Ryan Riehle" <rkr(at)buildways(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | ARE JOINS ALLOWED IN UPDATE STATEMENTS? |
Date: | 2004-11-30 18:56:36 |
Message-ID: | 000801c4d70e$55338410$7d01a8c0@buildways |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: Monday, November 29, 2004 11:48 PM
To: Evert Meulie
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] What causes 'FATAL: invalid cache id: 30' in my
postgresql log?
Evert Meulie <evert(at)witelcom(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Ted Kaczmarek | 2004-12-01 03:08:28 | The slony1 Project FC3 rpm build fun |
Previous Message | Thomas Hermann(Software) | 2004-11-30 17:55:32 | Re: views with parameters |