Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: How to set the global OID counter? COPY WITH OIDS does not set global OID counter?
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- Cc: Dirk Lutzebäck <lutzeb(at)aeccom(dot)com>, pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
- Subject: Re: How to set the global OID counter? COPY WITH OIDS does not set global OID counter?
- Date: Fri, 09 Jun 2006 10:26:39 -0400
Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes: > Dirk Lutzebäck wrote: >> how can one set the global OID counter in 8.1.X? We think it would work >> in 8.0.X using the COPY WITH OIDS command but this does not work in >> 8.1.X anymore. > pg_resetxlog -o > (Postmaster stopped of course) Possibly more to the point: why do you think you need to mess with the counter? 8.1 is smart enough not to assign conflicting OIDs to large objects. regards, tom lane
- Follow-Ups:
- Re: How to set the global OID counter? COPY WITH OIDS does
- From: Dirk Lutzebäck
- Re: How to set the global OID counter? COPY WITH OIDS does
- References:
- How to set the global OID counter? COPY WITH OIDS does not set global OID counter?
- From: Dirk Lutzebäck
- Re: How to set the global OID counter? COPY WITH OIDS does not set global OID counter?
- From: Alvaro Herrera
- How to set the global OID counter? COPY WITH OIDS does not set global OID counter?
- Prev by Date: Re: How to set the global OID counter? COPY WITH OIDS does not set global OID counter?
- Next by Date: Re: How to set the global OID counter? COPY WITH OIDS does
- Previous by thread: Re: How to set the global OID counter? COPY WITH OIDS does not set global OID counter?
- Next by thread: Re: How to set the global OID counter? COPY WITH OIDS does
- Indexes: