| From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
|---|---|
| To: | Marko Kreen <markokr(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, David Fetter <david(at)fetter(dot)org>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS |
| Date: | 2009-02-09 16:43:17 |
| Message-ID: | 49905D25.5050108@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Marko Kreen wrote:
> We've set default_with_oids = false, for quite a long time. But there
> are still tables remaining with oids. And this discussion showed it
> now easy to get rid of them.
Do you still need the oids? If not, run ALTER TABLE WITHOUT OIDS before
upgrading to 8.4, while it's still fast. If yes, you couldn't use the
option to remove them at pg_dump anyway because you still need them
after the upgrade.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-02-09 16:44:08 | Re: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS |
| Previous Message | Marko Kreen | 2009-02-09 16:43:02 | Re: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS |