Search Postgresql Archives

Re: backup tableoids (pg_class.oid) ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



fkater@xxxxxxxxxxxxxx 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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux