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
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
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
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