| From: | "Gellert, Andre" <AGellert(at)ElectronicPartner(dot)de> | 
|---|---|
| To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> | 
| Subject: | Reset oid , starting value=1 | 
| Date: | 2003-12-09 10:22:15 | 
| Message-ID: | 2740724BDE77EC4CB3CF41EA2227845730AE87@NT-VISEXCH | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
Hello, 
i have a bug in a php application based on postgres 7.2.2 , which cannot
handle oid's greater than
2147483647 . 
So I have to reset the used oids to start from 1 again, so that we have more
time to correct this bug, I tried to delete dropdb, createdb and read back
the data, but the oids are not reseted , they start at the high values.
How can i reset this oid-starting from value ?
Are OIDs used once per postgres-installation (so they are unique over all
databases, seem to be that way) , or are they only counted up in the current
database ?
There must be a global value which sets the last oid, i need to set this to
"1" or to fill up from 1 , so i have no oids >= 2147483647 for the near
future.. how can i do this ? Fixing the mentioned above will take more time.
What i am looking for is a vacuumdb -a --forgetthoseoids ;-) , but I cannot
find infos about that.
bye, 
Andre Gellert
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2003-12-09 10:32:58 | Re: Shell access & send email from PLPGSQL? | 
| Previous Message | John Sidney-Woollett | 2003-12-09 10:16:37 | Re: Shell access & send email from PLPGSQL? |