Alvaro Herrera <[EMAIL PROTECTED]> writes:
On Tue, Aug 09, 2005 at 04:01:33PM -0400, Tom Lane wrote:
Yeah, you can store the pg_class OID of the table,
Maybe it is possible to use a column of type regclass to store it. Not
sure exactly what advantage that would give, but it's an idea.
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Tue, Aug 09, 2005 at 04:01:33PM -0400, Tom Lane wrote:
>> Yeah, you can store the pg_class OID of the table,
> Maybe it is possible to use a column of type regclass to store it. Not
> sure exactly what advantage that would give, but it's an idea.
H
On Tue, Aug 09, 2005 at 04:01:33PM -0400, Tom Lane wrote:
> "TJ O'Donnell" <[EMAIL PROTECTED]> writes:
> > I guess what I'm asking is: Is there a better way to keep track of a
> > table once it's registered in my master table than just to put its
> > name in my master table? Some system oid type t
"TJ O'Donnell" <[EMAIL PROTECTED]> writes:
> I guess what I'm asking is: Is there a better way to keep track of a
> table once it's registered in my master table than just to put its
> name in my master table? Some system oid type thing that stays fixed
> in spite of renames or other tables mods?
> TJ O'Donnell wrote:
>> I have many different tables that I want to keep track of.
>> So, I thought of a master table with those table names in it.
>> But, to maintain this (suppose a table changes
>> its name, gets dropped) I want to have some kind of referential
>> integrity - the way foreign ke
TJ O'Donnell wrote:
I have many different tables that I want to keep track of.
So, I thought of a master table with those table names in it.
But, to maintain this (suppose a table changes
its name, gets dropped) I want to have some kind of referential
integrity - the way foreign keys and constrai
On 8/9/05 10:31 AM, "TJ O'Donnell" <[EMAIL PROTECTED]> wrote:
> I have many different tables that I want to keep track of.
> So, I thought of a master table with those table names in it.
> But, to maintain this (suppose a table changes
> its name, gets dropped) I want to have some kind of referent
