On 19/02/10 10:58, Gordon Ross wrote:
On 19/02/2010 10:36, "Richard Huxton" wrote:
Works here - are you sure you don't have any triggers interfering?
Doh ! *blush*
Yes, I did, to stop anyone tampering with the audit table ;-)
There you go - it worked :-)
--
Richard Huxton
Archonet Lt
On 19/02/2010 10:36, "Richard Huxton" wrote:
> Works here - are you sure you don't have any triggers interfering?
Doh ! *blush*
Yes, I did, to stop anyone tampering with the audit table ;-)
Thanks for that.
GTG
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes t
On 19/02/10 09:25, Gordon Ross wrote:
UPDATE audit SET key = extension.number FROM extension WHERE audit.record_id
= extension.number;
But that returns saying "UPDATE 0"
Works here - are you sure you don't have any triggers interfering?
BEGIN;
CREATE TEMP TABLE audit (
idint,
update audit set key = (select extension.number from extension where
audit.record_id = extension_id)
On 19.02.2010, at 11:25, Gordon Ross wrote:
> I have two tables:
>
> Table "public.audit"
> Column |Type | Modifiers
> +--+-
On 19/02/2010 10:28, "zkn" wrote:
> update audit set key = (select extension.number from extension where
> audit.record_id = extension_id)
No joy, I still get "UPDATE 0"
:-(
GTG
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.pos
I have two tables:
Table "public.audit"
Column |Type | Modifiers
+--+---
id | integer | (serial)
record_id | integer | not null
key| character varying|
(...)
Table
