| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: backup tableoids (pg_class.oid) ? |
| Date: | 2008-02-04 17:23:19 |
| Message-ID: | 20080204172319.GB16380@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
fkater(at)googlemail(dot)com wrote:
> Hi,
>
> my db structure relays on the OIDs of tables (stored as OIDs of
> pg_class).
Probably it would be a better idea to store that as type regclass
instead of OIDs. I think that will take care of the dump part of the
problem, at least. It's likely that there will be an additional hurdle
when trying to restore, because the referenced table would not have been
created in the first place.
That said, IMHO the idea of storing metadata as part of data is a bad
idea.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2008-02-04 17:24:28 | Re: PGSQL ERROR: FATAL: terminating connection due to administrator command |
| Previous Message | Hans-Juergen Schoenig | 2008-02-04 17:15:03 | Re: [Cert] Re: PostgreSQL Certification |