[BUGS] BUG #3709: Changing Table Owner

2007-10-30 Thread Vishesh Jain
The following bug has been logged online: Bug reference: 3709 Logged by: Vishesh Jain Email address: [EMAIL PROTECTED] PostgreSQL version: 8 Operating system: Linux Description:Changing Table Owner Details: I need to change the owner of some tables from postgres to

[BUGS] BUG #3708: Ongoing transactin that involves the table containing foreign key blocks updates of referenced table

2007-10-30 Thread Maksym Sobolyev
The following bug has been logged online: Bug reference: 3708 Logged by: Maksym Sobolyev Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.14 Operating system: FreeBSD 6.2-RELEASE Description:Ongoing transactin that involves the table containing foreign key blo

Re: [BUGS] BUG #3709: Changing Table Owner

2007-10-30 Thread Moiz Kothari
Hi Vishesh, You can run a dynamic SQL to get all your table owner changed. Try doing this : login to your database with postgresql user and then select 'alter table '|| tablename ||' owner to ;' from pg_tables where schemaname = 'public'; copy the alter table statements and run it. Regards, Mo

Fw: [BUGS] BUG #3695: Pgsql does not report non existing function

2007-10-30 Thread Roger Moloney
See below, clarification of bug report. -- From: "Roger Moloney" <[EMAIL PROTECTED]> Sent: Friday, October 26, 2007 8:25 AM To: "Tom Lane" <[EMAIL PROTECTED]> Subject: Re: [BUGS] BUG #3695: Pgsql does not report non existing function Hi Tom, Than