[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: rebuild tables with OIDS
- Subject: Re: rebuild tables with OIDS
- From: Joseph <..hidden..>
- Date: Wed, 23 Sep 2009 21:00:37 -0600
On 09/23/09 22:08, Michael Richardson wrote:
The only way I was able to do this was, for each table, create a new
table with a new name, insert into newtable from oldtable, and then
rename. I can't write the SQL from the top of my head, but if you like
I'll look it up.
If you can gid out a link or recall anything it would give me a start, thanks in advance.
Maybe someone else has a better solution.
You could also restore a backup, I think.
I'm upgrading from an older database so I don't have a backup.