Postgresql table ownership mystified

, posted: 25-May-2007 12:59

So, i'm moving a database from an old server to a new server -- easy migration but apon pg_restore, there's dozens of tables owned by users (humans). I don't want to create accounts for these, so i try out the following:
1. createuser
2. create table owned by user
3. drop user

=== table owned by null
doesn't seem to do any harm.. I'll clean up and change ownership to postgres... i'm not sure about those languages.. plpgsql is owned by a human in this.. i guess it wasn't in template1. back to work now. p.s. down with Smartquotes!!! learn to unicode!

Other related posts:
Google Code Jam
ANZ's Internet banking goes to insane lengths to be more insecure..
microsoft supporting old edition of ODF

Add a comment

Please note: comments that are inappropriate or promotional in nature will be deleted. E-mail addresses are not displayed, but you must enter a valid e-mail address to confirm your comments.

Are you a registered Geekzone user? Login to have the fields below automatically filled in for you and to enable links in comments. If you have (or qualify to have) a Geekzone Blog then your comment will be automatically confirmed and shown in this blog post.

Your name:

Your e-mail:

Your webpage:

taniwha's profile

Wally (Brenda) 
Te Whanganui O Tara
New Zealand