Re: Information Schema and constraint names not unique - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Information Schema and constraint names not unique
Date
Msg-id 200311072125.hA7LPLU27930@candle.pha.pa.us
Whole thread Raw
In response to Re: Information Schema and constraint names not unique  (Barry Lind <blind@xythos.com>)
List pgsql-hackers
Barry Lind wrote:
> 
> 
> Tom Lane wrote:
> > 
> >>Using tableoid instead of tablename avoids renaming problems, but makes 
> >>the names horribly opaque IMNSHO.
> > 
> > 
> > Agreed.  I think using the OIDs would be a horrible choice.
> > 
> 
> As a point of reference Oracle uses a naming convention of 'Cnnnn' where 
> nnnn is a sequence generated unique value.  So in Oracle system 
> generated names are very opaque.  I never saw this as a problem, since 
> if you wanted a non-opaque name you could always assign one yourself.

What, no dollar signs?  :-)

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: stats collector causes shared-memory-block leakage
Next
From: Bruce Momjian
Date:
Subject: Re: What do you want me to do?