469,572 Members | 1,339 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,572 developers. It's quick & easy.

Restoring a table with blobs - Without doing a full restore - Is it even possible ?

Hello !

I have a table that is created as follows

Create Table file_200 (Record_number integer, Customer_Image OID;
CREATE UNIQUE INDEX file_200_Record_Number_Key ON file_200
(record_number);

I store pictures using (In Delphi 7)

PSQLImageQuery.Edit;
PSQLImageQuerycustomer_image.LoadFromFile('c:\tmp. jpg');
PSQLImageQuery.Post;

Everything works just wonderfully, even a full dump and restore works
like a charm (Using pg_dump, pg_restore).

Now, of course thats not good enough..hehe. I need to be able to make
a partial restore of the picture table only (there are about 30
diffrent tables, it is not a huge database, 30MB compressed tar.gz). I
tried using the pg_restore -t flag and it runs threw with no errors.
The problem is that the pictures are simply not there and I can not
even overwrite them with new ones. Also, the index is not restored.
When I load the pictures I simply do a "where record_number=##" query
and then the DBImage component does the rest.

I am using PSQL 7.2

Any ideas ?

Thanks a lot

/otto blomqvist
Nov 23 '05 #1
0 872

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Edwinah63 | last post: by
1 post views Thread by Luc Le Blanc | last post: by
5 posts views Thread by Mike Nolan | last post: by
1 post views Thread by Robbert van Geldrop | last post: by
5 posts views Thread by Troels Arvin | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.