Re: Regclass and quoted table names

From: Emmanuel Cecchet <manu(at)asterdata(dot)com>
To: marcin mank <marcin(dot)mank(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Greg Stark <stark(at)enterprisedb(dot)com>, Emmanuel Cecchet <Emmanuel(dot)Cecchet(at)asterdata(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Regclass and quoted table names
Date: 2009-03-04 20:31:39
Message-ID: 49AEE52B.2040405@asterdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

marcin mank wrote:
>> Use plain oids or regclass values, not a text column, if you are trying
>> to store table identities.
>>
> wouldn`t oids change on dump/reload?
>
I don't know. I'd also be interested to know if there is a difference if
we use pg_restore with a binary format or sql dump, or if that does not
influence at all the way oids are created.

manu

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dann Corbit 2009-03-04 20:32:38 Re: Is there an official log reader for PostgreSQL?
Previous Message Dimitri Fontaine 2009-03-04 20:28:11 Re: Is there an official log reader for PostgreSQL?