Re: [BUGS] BUG #4785: Installation fails

2009-05-05 Thread Krimstock, Roger I (Roger)
The one click from downloads on www.postgres.org. Both the 8.3.7 and 8.4 versions. The error message: --- Warning --- Problem running post-install step. Installation may not complete correctly Error reading file C:/Program Files/PostgreSQL/8.4/

Re: [BUGS] BUG #4793: Segmentation fault when doing vacuum analyze

2009-05-05 Thread Tom Lane
I wrote: > Dennis Noordsij writes: >> What happens is [ integer overflow ] > Doh ... so the increase in the maximum histogram size *is* related. > Thanks, will fix. Patch is here if you need it right away: http://archives.postgresql.org/message-id/20090505180211.b2a59754...@cvs.postgresql.org

Re: [BUGS] BUG #4792: odd behavior revoking perms on an owned table

2009-05-05 Thread Toni García Marí
Ok, thanks for the explanation. The SELECT FOR SHARE future solution sounds neat; I've solved the actual problem in my application with a workaround. -- Toni >> CREATE DATABASE test_db; >> CREATE USER test_user; >> \c test_db test_user >> CREATE TABLE test (id integer primary key); >> CREATE TA

Re: [BUGS] BUG #4793: Segmentation fault when doing vacuum analyze

2009-05-05 Thread Tom Lane
Dennis Noordsij writes: > What happens is [ integer overflow ] Doh ... so the increase in the maximum histogram size *is* related. Thanks, will fix. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: h

Re: [BUGS] BUG #4793: Segmentation fault when doing vacuum analyze

2009-05-05 Thread Dennis Noordsij
On Tuesday 05 May 2009 17:16:03 Tom Lane wrote: > "Dennis Noordsij" writes: > > (gdb) bt > > #0 0x004eecf7 in compute_scalar_stats (stats=0x1abd878, > > fetchfunc=0x4f0f30 , samplerows= > out>, totalrows=4154315) > > at analyze.c:2321 > > #1 0x004efbf5 in analyze_rel (rel

Re: [BUGS] BUG #4793: Segmentation fault when doing vacuum analyze

2009-05-05 Thread Stefan Kaltenbrunner
Tom Lane wrote: "Dennis Noordsij" writes: (gdb) bt #0 0x004eecf7 in compute_scalar_stats (stats=0x1abd878, fetchfunc=0x4f0f30 , samplerows=, totalrows=4154315) at analyze.c:2321 #1 0x004efbf5 in analyze_rel (relid=16484, vacstmt=0x1aaf140, bstrategy=, update_reltup

Re: [BUGS] BUG #4793: Segmentation fault when doing vacuum analyze

2009-05-05 Thread Tom Lane
"Dennis Noordsij" writes: > (gdb) bt > #0 0x004eecf7 in compute_scalar_stats (stats=0x1abd878, > fetchfunc=0x4f0f30 , samplerows=, > totalrows=4154315) > at analyze.c:2321 > #1 0x004efbf5 in analyze_rel (relid=16484, vacstmt=0x1aaf140, > bstrategy=, update_reltuples=1

Re: [BUGS] BUG #4792: odd behavior revoking perms on an owned table

2009-05-05 Thread Tom Lane
"toni garcia" writes: > CREATE DATABASE test_db; > CREATE USER test_user; > \c test_db test_user > CREATE TABLE test (id integer primary key); > CREATE TABLE test_fk (id integer primary key, testid integer, constraint fk1 > foreign key (testid) references test(id)); > REVOKE UPDATE ON test FROM

[BUGS] BUG #4793: Segmentation fault when doing vacuum analyze

2009-05-05 Thread Dennis Noordsij
The following bug has been logged online: Bug reference: 4793 Logged by: Dennis Noordsij Email address: dennis.noord...@helsinki.fi PostgreSQL version: snapshot/beta1 Operating system: 64bit arch Linux Description:Segmentation fault when doing vacuum analyze Details:

[BUGS] Re: BUG #4791: NULL value in function causes reproducible segmentation fault

2009-05-05 Thread Jasen Betts
On 2009-05-05, Sikkerhed.org ApS wrote: > > The following bug has been logged online: > > Bug reference: 4791 > Logged by: Sikkerhed.org ApS > Email address: supp...@sikkerhed.org > PostgreSQL version: 8.3.7-0lenny1 > Operating system: Debian GNU/Linux 5.0.1 stable (fully upda

Re: [BUGS] BUG #4791: NULL value in function causes reproducible segmentation fault

2009-05-05 Thread Christian Iversen
Magnus Hagander wrote: Sikkerhed.org ApS wrote: The following bug has been logged online: Bug reference: 4791 Logged by: Sikkerhed.org ApS Email address: supp...@sikkerhed.org PostgreSQL version: 8.3.7-0lenny1 Operating system: Debian GNU/Linux 5.0.1 stable (fully updated)

[BUGS] BUG #4792: odd behavior revoking perms on an owned table

2009-05-05 Thread toni garcia
The following bug has been logged online: Bug reference: 4792 Logged by: toni garcia Email address: agar...@at4.net PostgreSQL version: 8.2.7 Operating system: gentoo linux Description:odd behavior revoking perms on an owned table Details: Sorry, I cannot test on 8.

Re: [BUGS] BUG #4791: NULL value in function causes reproducible segmentation fault

2009-05-05 Thread Magnus Hagander
Sikkerhed.org ApS wrote: > The following bug has been logged online: > > Bug reference: 4791 > Logged by: Sikkerhed.org ApS > Email address: supp...@sikkerhed.org > PostgreSQL version: 8.3.7-0lenny1 > Operating system: Debian GNU/Linux 5.0.1 stable (fully updated) > Descriptio

[BUGS] BUG #4791: NULL value in function causes reproducible segmentation fault

2009-05-05 Thread Sikkerhed.org ApS
The following bug has been logged online: Bug reference: 4791 Logged by: Sikkerhed.org ApS Email address: supp...@sikkerhed.org PostgreSQL version: 8.3.7-0lenny1 Operating system: Debian GNU/Linux 5.0.1 stable (fully updated) Description:NULL value in function causes