[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] History
From:       Alan Gutierrez <ajglist () izzy ! net>
Date:       2003-02-03 0:55:25
[Download RAW message or body]

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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
[prev in list] [next in list] [prev in thread] [next in thread]