| 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: | Whole Thread | Raw Message | 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 |