[BUGS] BUG #3266: SSL broken pipes kill the machine and fill the disk

2007-05-10 Thread Peter Koczan
The following bug has been logged online: Bug reference: 3266 Logged by: Peter Koczan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: CentOS Linux 4.4 (RHEL 4) running on Pentium 4 Description:SSL broken pipes kill the machine and fill the

Re: [BUGS] INSTALL appnote for Solaris 10...

2007-05-10 Thread Zdenek Kotala
John R Pierce wrote: I just built a version of postgres 8.2.4 on Solaris 10 x86 ... a few things that could be mentioned in INSTALL, and or in the Solaris notes Solaris.FAQ is best place for it. http://www.postgresql.org/docs/faqs.FAQ_Solaris.html Solaris has a `crle` command that perfo

Re: [BUGS] pg_dump + serial + sequence problem

2007-05-10 Thread Luiz K. Matsumura
Hi, Tom Thanks for reply I understood, that this isn't so critical, but may causes surprises, so I reported for someone pay atention that this can occur. By the way I try to drop the sequence, but I can't because they still owned by the column. So I can't be able to remove this reference with

Re: [BUGS] pg_dump + serial + sequence problem

2007-05-10 Thread Tom Lane
"Luiz K. Matsumura" <[EMAIL PROTECTED]> writes: > CREATE TABLE teste > ( >id serial, >... > ALTER TABLE teste ALTER COLUMN id DROP DEFAULT; This isn't supported before 8.2, since as you found out pg_dump is unable to reproduce the situation in the database --- the sequence is still marked

[BUGS] pg_dump + serial + sequence problem

2007-05-10 Thread Luiz K. Matsumura
Hi, I found a problem with pg_dump in pg 8.0 and 8.1 ( Postgres 8.2 works fine) Scenario 1: CREATE TABLE teste ( id serial, campo character(10), CONSTRAINT pk_teste PRIMARY KEY (id) ) WITHOUT OIDS; CREATE TABLE will create implicit sequence "teste_id_seq" for serial column "teste.i

[BUGS] INSTALL appnote for Solaris 10...

2007-05-10 Thread John R Pierce
I just built a version of postgres 8.2.4 on Solaris 10 x86 ... a few things that could be mentioned in INSTALL, and or in the Solaris notes There is a Sun supplied version of gnu readline is on the Solaris "Companion" DVD as package SFWrline ... cd /mnt/Solaris_Software_Companion/Solar

Re: [BUGS] BUG #3265: 8.1 -> 8.2 behviour change: View owner must have access to underlying tables

2007-05-10 Thread Tom Lane
Russell Smith <[EMAIL PROTECTED]> writes: > But this also means that a super user is not really a super user > anymore. Are we comfortable with this redefinition? Hm? It has never been the case that a view would act differently for a superuser than it would when invoked by someone else. The bu

Re: [BUGS] BUG #3265: 8.1 -> 8.2 behviour change: View owner must have access to underlying tables

2007-05-10 Thread Russell Smith
Tom Lane wrote: "Russell Smith" <[EMAIL PROTECTED]> writes: CREATE view v1 as select * from t1; ALTER TABLE v1 OWNER TO "USER"; See thread here: http://archives.postgresql.org/pgsql-hackers/2006-04/msg01138.php and patch here: http://archives.postgresql.org/pgsql-committers/2006-09/msg

[BUGS] Is PostgresSQL supported in Windows Vista?

2007-05-10 Thread Jack Ho
Dear sir, Is PostgreSQL supported in Vista? If it is, what version is supported? Thanks & Regards, Jack