On Thu, 2 Oct 2003, Tom Lane wrote:
Howard Lowndes [EMAIL PROTECTED] writes:
On Wed, 1 Oct 2003, Tom Lane wrote:
No, because pg_restore has logic to adjust the references to match the
new BLOB OIDs. If you have a test case where this fails to work, let's
see it ...
No, I don't have
Howard Lowndes [EMAIL PROTECTED] writes:
OK, I'm convinced, except for one small, but not insignificant hiccup.
When you dump a database with the BLOBs, even with the -c option, and then
restore that database again with the -c option, you get double the BLOBs.
The original BLOBs are there
On 2 Oct 2003, Doug McNaught wrote:
Howard Lowndes [EMAIL PROTECTED] writes:
OK, I'm convinced, except for one small, but not insignificant hiccup.
When you dump a database with the BLOBs, even with the -c option, and then
restore that database again with the -c option, you get double
My situation is that I am interacting PHP 4.1.2 to PostgreSQL 7.2.2
I have no difficulty inserting and managing BLOBs into the Large Object
system table, and I have a user table called images which maintains the
relationship between the BLOB loid and the identity that relates to it in
my user
On Wed, 1 Oct 2003, Joshua D. Drake wrote:
Hello,
We usually have a table called something like file_objects that
contains information like the loid, content-type, filesize etc...
that we reference.
Yes, that's what I also have got:
test= \d images
Table images
Howard Lowndes [EMAIL PROTECTED] writes:
Now, my concern is that if I use pg_dump with the --clean or --create, and
the --blobs options, and then try a pg_restore from the resulting archive
file, I believe the BLOBs will take up a different loid to the one they
came from, and hence the
On Wed, 1 Oct 2003, Tom Lane wrote:
Howard Lowndes [EMAIL PROTECTED] writes:
Now, my concern is that if I use pg_dump with the --clean or --create, and
the --blobs options, and then try a pg_restore from the resulting archive
file, I believe the BLOBs will take up a different loid to the
Howard Lowndes [EMAIL PROTECTED] writes:
On Wed, 1 Oct 2003, Tom Lane wrote:
No, because pg_restore has logic to adjust the references to match the
new BLOB OIDs. If you have a test case where this fails to work, let's
see it ...
No, I don't have any example, it is an enquiry. What I am