From: Jeff Eckermann <jeckermann@verio.net>
To: Horst Herb <hherb@malleenet.net.au>
To: pgsql-novice@postgresql.org
To: pgsql-sql@postgresql.org
Subject: Re: how to use record type
Date: Fri, 17 Aug 2001 09:18:10 -0500
Message-ID: <009401c12727$71b3a150$279c10ac@INTERNAL> (raw)
References: <0108170824511W.01835@munin.gnumed.dhs.org>
I have encountered this problem (in a different context), and could not find
a way to insert entire rows/records in the way that you appear to want. But
it worked fine if I INSERTed explicitly, like:
INSERT INTO table VALUES (OLD.field1, OLD.field2, ..., OLD.fieldn);
That should work fine inside a plpgsql function.
----- Original Message -----
From: "Horst Herb" <hherb@malleenet.net.au>
To: <pgsql-novice@postgresql.org>; <pgsql-sql@postgresql.org>
Sent: Thursday, August 16, 2001 5:24 PM
Subject: Fwd: how to use record type
> I have difficulties understanding how to use variable of "record" or "row"
> type. How do I actually insert the variables OLD or NEW or a record type
into
> a table from within a trigger?
>
> Like doing the following:
>
> drop table th1;
> create table th1(
> id serial,
> text text );
>
> drop table th_audit;
> create table th1_audit(
> ts timestamp default now()
> ) inherits(th1);
>
> drop function thaudit();
> create function thaudit() returns opaque as '
> begin
> -- I want to insert OLD into th_audit - how do I do this???
> return NEW;
> end; ' language 'plpgsql';
>
> drop trigger ta on th1;
> create trigger ta before delete or update on th1
> for each row execute procedure thaudit();
>
> Reagrds,
> Horst
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jeckermann@verio.net, hherb@malleenet.net.au, pgsql-novice@postgresql.org
Subject: Re: how to use record type
In-Reply-To: <009401c12727$71b3a150$279c10ac@INTERNAL>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox