[BUGS] BUG #7748: drop owned by fails with error message: unrecognized object class: 1262

2012-12-09 Thread spam_eater
The following bug has been logged on the website: Bug reference: 7748 Logged by: Thomas Kellerer Email address: spam_ea...@gmx.net PostgreSQL version: 9.2.2 Operating system: Windows XP, 32bit Description: Using drop owned by someuser in 9.2.2 fails with the error

Re: [BUGS] BUG #7748: drop owned by fails with error message: unrecognized object class: 1262

2012-12-09 Thread Tom Lane
spam_ea...@gmx.net writes: postgres=# create user testuser with password 'secret'; CREATE ROLE postgres=# create database testdb owner testuser; CREATE DATABASE testdb= drop owned by testuser; ERROR: unrecognized object class: 1262 I can reproduce this in all versions back to 8.3. In 8.2,

[BUGS] Re: BUG #7748: drop owned by fails with error message: unrecognized object class: 1262

2012-12-09 Thread Thomas Kellerer
Tom Lane wrote on 09.12.2012 17:43: spam_ea...@gmx.net writes: postgres=# create user testuser with password 'secret'; CREATE ROLE postgres=# create database testdb owner testuser; CREATE DATABASE testdb= drop owned by testuser; ERROR: unrecognized object class: 1262 I can reproduce this in

[BUGS] init_htab causes SIGFPE (or worse) due to miscalculation for large nbuckets

2012-12-09 Thread Jeff Davis
If nbuckets is around 2^30+1, which can happen if work_mem is very high, then: nbuckets = 1 my_log2(lnbuckets); ends up as 1 31, which is negative, leading to a SIGFPE on my machine, but I think it can also lead to an infinite loop or a crash (after corrupting the HASHHDR). The only

[BUGS] Re: BUG #7748: drop owned by fails with error message: unrecognized object class: 1262

2012-12-09 Thread Thomas Kellerer
Tom Lane wrote on 09.12.2012 17:43: spam_ea...@gmx.net writes: postgres=# create user testuser with password 'secret'; CREATE ROLE postgres=# create database testdb owner testuser; CREATE DATABASE testdb= drop owned by testuser; ERROR: unrecognized object class: 1262 I can reproduce this in

Re: [BUGS] init_htab causes SIGFPE (or worse) due to miscalculation for large nbuckets

2012-12-09 Thread Tom Lane
Jeff Davis pg...@j-davis.com writes: If nbuckets is around 2^30+1, which can happen if work_mem is very high, then: nbuckets = 1 my_log2(lnbuckets); ends up as 1 31, which is negative, leading to a SIGFPE on my machine, but I think it can also lead to an infinite loop or a crash (after

Re: [BUGS] BUG #7748: drop owned by fails with error message: unrecognized object class: 1262

2012-12-09 Thread Alvaro Herrera
Tom Lane wrote: spam_ea...@gmx.net writes: postgres=# create user testuser with password 'secret'; CREATE ROLE postgres=# create database testdb owner testuser; CREATE DATABASE testdb= drop owned by testuser; ERROR: unrecognized object class: 1262 I can reproduce this in all

Re: [BUGS] BUG #7748: drop owned by fails with error message: unrecognized object class: 1262

2012-12-09 Thread Jaime Casanova
On Sun, Dec 9, 2012 at 11:13 PM, Alvaro Herrera alvhe...@2ndquadrant.com wrote: Tom Lane wrote: spam_ea...@gmx.net writes: postgres=# create user testuser with password 'secret'; CREATE ROLE postgres=# create database testdb owner testuser; CREATE DATABASE testdb= drop owned by

Re: [BUGS] BUG #7740: Installation cannot fine msi file

2012-12-09 Thread Sandeep Thakkar
Hi Do you see this on Win7 32bit or 64bit? Can you please send the installation logs from your temp folder? On Sat, Dec 8, 2012 at 4:35 AM, al_chir...@hotmail.com wrote: The following bug has been logged on the website: Bug reference: 7740 Logged by: Al Chirico Email address: