Marion McKelvie [EMAIL PROTECTED] writes:
Many thanks - you're right, the references are stored (by the application
using the database) in a column of type text.
Yuck :-(. A possible solution is to dump the schema and data separately
(schema in a plain text dump, data in an -Fc or -Ft dump
PROTECTED]
Subject: Re: [ADMIN] restoring large objects
Marion McKelvie [EMAIL PROTECTED] writes:
Many thanks - you're right, the references are stored (by the application
using the database) in a column of type text.
Yuck :-(. A possible solution is to dump the schema and data separately
(schema
PROTECTED] Behalf Of Marion McKelvie
Sent: 07 April 2004 08:44
To: [EMAIL PROTECTED]
Subject: Re: [ADMIN] restoring large objects
Good idea but I'm not sure if the application will then handle the changed
column type correctly. I'll give it a go and let you know...
-Original Message-
From
Please can anyone confirm (or otherwise) the situation with restoring large
objects?
I am running with 7.1.2 (I know it's old, but I don't have a lot of choice
given the application running on it), and have dumped the database with
the -b option. However, the restoration process generates new
Marion McKelvie [EMAIL PROTECTED] writes:
I am running with 7.1.2 (I know it's old, but I don't have a lot of choice
given the application running on it), and have dumped the database with
the -b option. However, the restoration process generates new ids for the
large objects which means the
... or
something which somehow tracks the old and new ids... an interesting
challenge!
Regards,
Marion
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: 06 April 2004 16:33
To: Marion McKelvie
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] restoring large objects
Marion McKelvie