Re: [GENERAL] TUPLES <> HEAP

1999-04-20 Thread Karl DeBisschop
Not sure that you can drop/create system indexes (I didn't notice that when I posted earlier - sorry). But the the same idea may apply - can you dump and recreate the database tables. $ pg_dump existing > existing.dump $ psql -e secondtry < exidting.dump BTW, do you need to cross-post to all t

[GENERAL] TUPLES <> HEAP

1999-04-20 Thread JT Kirkpatrick
Hi all. Head hanging a little low, even though system still seems to work fine. Here is what I did: - update pg_class set relname = lower(relname); - update pg_attribute set attname = lower(attname); - (why did I do that? Following something I read, not really having problems in the first pl