From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Alanoly Andrews <alanolya(at)invera(dot)com>, 'Craig James' <cjames(at)emolecules(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization. |
Date: | 2014-09-03 19:25:43 |
Message-ID: | 54076B37.7000603@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
On 09/03/2014 09:26 AM, Alanoly Andrews wrote:
> *Hi Craig,*
>
> **
>
> *I’m reloading into the very same database. *
>
> *If I insert a new row into the table (through VB/ODBC), I’m able to
> retrieve it (again from VB). But if after inserting the new row, I do a
> reorg of the table (eg. with a “cluster table”), I’m no longer able to
> retrieve that same row. In short, as long as the newly inserted rows are
> not “re-written” in some way, they can be retrieved through VB/ODBC. *
This:
Note the OID for the table stays the same but the relfilenode changes.
This also happens with the other situations you describe(unless you use
--oids with pg_dump).
should be:
Note the OID for the table stays the same but the relfilenode changes.
This also happens with the other situations you describe(if you use
--oids with pg_dump).
>
> **
>
> *Alanoly.*
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Alanoly Andrews | 2014-09-04 12:56:14 | Re: [GENERAL] Re: Cannot retrieve images inserted through VB and odbc, after a table reorganization. |
Previous Message | Adrian Klaver | 2014-09-03 19:10:19 | Re: [GENERAL] Re: Cannot retrieve images inserted through VB and odbc, after a table reorganization. |
From | Date | Subject | |
---|---|---|---|
Next Message | Eric Fleming | 2014-09-03 23:35:50 | GiST index question |
Previous Message | Adrian Klaver | 2014-09-03 19:17:48 | Re: drop/create/alter amongst difference schemas as non-super user |