Re: [HACKERS] Adding a field to each tuple - Mailing list pgsql-hackers

From Maurice Gittens
Subject Re: [HACKERS] Adding a field to each tuple
Date
Msg-id 00b401bd42c4$cb91dfc0$fcf3b2c2@caleb..gits.nl
Whole thread Raw
List pgsql-hackers
-----Original Message-----
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: Maurice Gittens <mgittens@gits.nl>
Cc: hackers@postgreSQL.org <hackers@postgreSQL.org>
Date: donderdag 26 februari 1998 21:36
Subject: Re: [HACKERS] Adding a field to each tuple


>
>Yes, this is a natural use for a trigger.  Create the column in the base
>table, and have it stuff the value on insert.  You have to make the
>trigger on each derived table, but you may be able to use the same
>trigger on all tables.  This is how we are implementing time travel.
>


Agreed. This was my first try. But doesn't solve the general problem, of
mapping an arbitrary valid (within the system) OID to the OID of it's class
does it ?!.

So I've started hacking and I'm now encountering my first problems -:).
(I do realize that I going to run into more trouble for large objects.)

Learning new stuff is so much fun -:).

Thanks,
Maurice (who's enjoying himself today.)





pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Adding a field to each tuple
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] MergeJoin and Mark/Restr scan positions (Re: [PORTS] Port Bug Report)