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: | 2006-06-09 14:26:39 |
Message-ID: | 9780.1149863199@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-bugs pgsql-general |
Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Dirk Lutzebck 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
From | Date | Subject | |
---|---|---|---|
Next Message | Dirk Lutzebäck | 2006-06-09 14:41:01 | Re: How to set the global OID counter? COPY WITH OIDS does |
Previous Message | Chris Browne | 2006-06-09 14:22:40 | Re: Database port changing issue |
From | Date | Subject | |
---|---|---|---|
Next Message | Dirk Lutzebäck | 2006-06-09 14:41:01 | Re: How to set the global OID counter? COPY WITH OIDS does |
Previous Message | Alvaro Herrera | 2006-06-09 14:00:15 | Re: How to set the global OID counter? COPY WITH OIDS does not set global OID counter? |
From | Date | Subject | |
---|---|---|---|
Next Message | Greg | 2006-06-09 14:33:46 | Problem with silent install of PgSQL on Windows |
Previous Message | Nis Jorgensen | 2006-06-09 14:07:17 | Re: Fabian Pascal and RDBMS deficiencies in fully implementing |