Re: Re: Postgresql table reloading - Mailing list pgsql-general

From David Wall
Subject Re: Re: Postgresql table reloading
Date
Msg-id 003901c0d581$15b736c0$5a2b7ad8@expertrade.com
Whole thread Raw
In response to Re: Postgresql table reloading  (Joel Burton <jburton@scw.org>)
List pgsql-general
> In the table, you're storing the OID of the large object itself, so if you
> copy all the contents of the table, so far as I can see, yes, you'd still
> have the reference to your large object.

Thanks.  I did see this in a quick test, but I wasn't sure if the data would
be removed when I dropped the original table (does the DB keep a reference
count for rows pointing to the blob?).  Yes, I'll give it a test first!

Thanks,
David


pgsql-general by date:

Previous
From: Joel Burton
Date:
Subject: Re: a primer on trigger?
Next
From: Ashley Clark
Date:
Subject: Strange notices, should I worry?