| From: | Dirk Lutzebäck <lutzeb(at)aeccom(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org |
| Cc: | tgl(at)sss(dot)pgh(dot)pa(dot)us |
| Subject: | How to set the global OID counter? COPY WITH OIDS does not set global OID counter? |
| Date: | 2006-06-09 13:25:55 |
| Message-ID: | 448976E3.50209@aeccom.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-bugs pgsql-general |
Hi,
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.
We have the problem that we made a dump using 'pg_dump -o' in 8.0.X,
created a new database in 8.1.X and read back in but the global OID
counter stayed at 40.000 so OIDs will be allocated again!
Thanks for help,
Dirk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mohamed Fazil | 2006-06-09 13:30:51 | Database port changing issue |
| Previous Message | Thomas LeBlanc | 2006-06-08 19:19:17 | remove |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rojas, Fernando (CIAT) | 2006-06-09 13:48:58 | Error Starting Back END |
| Previous Message | kah_hang_ang | 2006-06-09 09:29:08 | Re: statement stuck when the connection grew up to 45 or more |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roman Neuhauser | 2006-06-09 13:33:31 | Re: Fabian Pascal and RDBMS deficiencies in fully implementing |
| Previous Message | pobox@verysmall.org | 2006-06-09 13:19:38 | Re: 010.pgsql.sh does not react |