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
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,
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
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
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
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
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
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
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: