Re: History

On Sunday 02 February 2003 06:41, Oliver Elphick wrote:
> On Sun, 2003-02-02 at 05:07, will trillich wrote:

> > but -- is there some way to tell which offspring table the delta
> > record came from? now THAT would be useful.

There is no good way.

> junk=# select c.relname, d.* from delta as d, pg_class as c where
> d.tableoid = c.oid;

See what I mean?

>  relname | id |  created
> ---------+----+------------
>  delta   |  2 | 2002-05-18
>  loc     |  1 | 2003-02-02
>  loc     |  3 | 2003-02-02
> (3 rows)

--
Alan Gutierrez - ajglist@izzy.net
http://khtml-win32.sourceforge.net/ - KHTML on Windows