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. I
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 si
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 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 corrupt
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
On Sun, Dec 9, 2012 at 11:13 PM, Alvaro Herrera
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 testuser;
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, wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7740
> Logged by: Al Chirico
> Email address: al_chir...@h
