Re: [GENERAL] How to exclude blobs (large objects) from being loaded by pg_restore?

2015-05-02 Thread Alanoly Andrews
t " column. Alanoly. Sent from my iPhone > On May 2, 2015, at 9:39 AM, Vincent Veyron wrote: > > On Fri, 1 May 2015 14:12:08 + > Alanoly Andrews wrote: > >> Hello, >> >> We have a database that has been unloaded using pg_dump. This database has a >> t

[GENERAL] How to exclude blobs (large objects) from being loaded by pg_restore?

2015-05-01 Thread Alanoly Andrews
hly basis. We do not want to exclude the blobs from the dump itself (since the whole database is to be preserved as a monthly record), but only from the restore. Postgres 9.1.4 on AIX. Thanks. Alanoly Andrews. Invera Inc. Montreal, Canada. If you no l

Re: [GENERAL] Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization.

2014-09-05 Thread Alanoly Andrews
SQLLEN *0x003CE284 DIAG [S1000] Error reading from large object. (1) -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Thursday, September 04, 2014 4:43 PM To: Alanoly Andrews; 'Craig James' Cc: pgsql-ad...@postgresql.org; pgsq

Re: [GENERAL] Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization.

2014-09-04 Thread Alanoly Andrews
ain text! [cid:image001.png@01CFC82F.D8DB69F0] [cid:image002.png@01CFC82F.D8DB69F0] [cid:image003.png@01CFC82F.D8DB69F0] Alanoly. -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Thursday, September 04, 2014 9:39 AM To: Alanoly Andre

Re: [GENERAL] Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization.

2014-09-04 Thread Alanoly Andrews
an Klaver [mailto:adrian.kla...@aklaver.com] Sent: Wednesday, September 03, 2014 3:10 PM To: Alanoly Andrews; 'Craig James' Cc: pgsql-ad...@postgresql.org; pgsql-general@postgresql.org Subject: Re: [GENERAL] Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorg

[GENERAL] Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization.

2014-09-03 Thread Alanoly Andrews
short, as long as the newly inserted rows are not “re-written” in some way, they can be retrieved through VB/ODBC. Alanoly. From: Craig James [mailto:cja...@emolecules.com] Sent: Wednesday, September 03, 2014 12:13 PM To: Alanoly Andrews Cc: pgsql-ad...@postgresql.org; pgsql-general@postgresql.org

[GENERAL] Cannot retrieve images inserted through VB and odbc, after a table reorganization.

2014-09-03 Thread Alanoly Andrews
is on an AIX server (version 6.1). Postgres version is 9.1.4. I'd welcome any input towards the resolution of this problem. Thanks. Alanoly Andrews alano...@invera.com If you no longer wish to receive any of our emails, click on UNSUBSCRIBE.<mailto:un