Re: [HACKERS] Adding a field to each tuple

Поиск
Список
Период
Сортировка
От Maurice Gittens
Тема Re: [HACKERS] Adding a field to each tuple
Дата
Msg-id 00b401bd42c4$cb91dfc0$fcf3b2c2@caleb..gits.nl
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Adding a field to each tuple
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] MergeJoin and Mark/Restr scan positions (Re: [PORTS] Port Bug Report)