Re: [GENERAL] row oids as "foreign keys" in other tables ?

1998-07-29 Thread Matt McClure
On Wed, 29 Jul 1998, Vadim Mikheev wrote: > Matt McClure wrote: > > > > You say that vacuum "re-writes" the database. Does it alter row oids??? > ^^ > No. > > > If so, my scheme compl

[GENERAL] row oids as "foreign keys" in other tables ?

1998-07-28 Thread Matt McClure
I'm relatively new to postgres and I've had a couple of questions for a while now. This post made me worry about them again: > 2. the server currently doesn't "reuse" deleted rows, but just keeps >appending them to the end. running a straight VACUUM will perform a >de-fragmentation by e

Re: [GENERAL] Nested tables

1998-07-24 Thread Matt McClure
On Fri, 24 Jul 1998, Ferruccio Zamuner wrote: > CREATE TABLE foo ( > x int2 > ); > > CREATE TABLE bar ( > y foo, > z int > ); > > I read on some Postgres mailing digest that I had to put the OID of instance > of foo into y field of bar. > > So I tried. > > The problem is that when I sub

Re: [GENERAL] returning oid of last insert?

1998-07-22 Thread Matt McClure
Thanks for the help. I checked libpq, and just to follow up, it is quite easy to get the oid of the last insert using the routine oidStatus. On Sun, 19 Jul 1998, Peter T Mount wrote: > On Sat, 18 Jul 1998, Matt McClure wrote: > > > Is there a way to return the oid of the last in