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