Re: OID wraparound (was Re: pg_depend) - Mailing list pgsql-hackers

From J-P Guy
Subject Re: OID wraparound (was Re: pg_depend)
Date
Msg-id 20010719151911.98049.qmail@web20101.mail.yahoo.com
Whole thread Raw
In response to OID wraparound (was Re: pg_depend)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
J-P wrote:
> > I need to create a new system table like pg_log to
> > implement a replication scheme. The big problem is
> how
> > I could get an OID for it, a unique OID that is
> > reserved for that table???

Hiroshi Inoue wrote:
>
> 
> Do you need the following ?
> 
> visco=# select oid from pg_class where relname =
> 'pg_log';
>  oid
> ------
>  1269
> (1 row)
> 
> I'm afraid of misunderstanding.

Sorry my question was wrongly asked.
What I need is a unique OID for my new system table
that is reserved for that table?
A new Id that is not used by anything else, and that
will never be used.
(The reference to pg_log was just to show the
similarity of what I need).

N.B. I can't just 
#select oid from pg_class 
and take one that is not there, since I don't know if
the oid I choose will be used by something else in the
system??

Thanks for your help,
J-P 



_______________________________________________________
Do You Yahoo!?
Get your free @yahoo.ca address at http://mail.yahoo.ca


pgsql-hackers by date:

Previous
From: Adrian Phillips
Date:
Subject: Re: MySQL Gemini code
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: OID wraparound (was Re: pg_depend)