Re: [BUGS] [HACKERS] 0x1A in control file on Windows

2008-09-23 Thread Magnus Hagander
Andrew Dunstan wrote: > > > Tom Lane wrote: >> Bruce Momjian <[EMAIL PROTECTED]> writes: >> >>> Tom Lane wrote: >>> Well, why is that a bug? If the platform is so silly as to define text files that way, who are we to argue? >> >> >>> The problem is that our pg_contr

Re: [BUGS] BUG #4434: Error inserting into view - unrecognized node type: 313

2008-09-23 Thread Tom Lane
"Dean Rasheed" <[EMAIL PROTECTED]> writes: > CREATE TABLE foo(a int, b int); > CREATE VIEW foo_v AS SELECT * FROM foo; > CREATE RULE foo_r AS ON INSERT TO foo_v DO INSTEAD INSERT INTO foo > VALUES(NEW.a, NEW.b); > INSERT INTO foo_v VALUES ((SELECT 1), (SELECT 2)), ((SELECT 3), (SELECT 4)); > ERROR

Re: [BUGS] BUG #4435: pg_ctl start doesn't detach when run via SSH

2008-09-23 Thread Tom Lane
Steve Clark <[EMAIL PROTECTED]> writes: > Hal Black wrote: >> When I run "pg_ctl start" via SSH, the database service starts, but it never >> returns control to the shell. If I run the same command from an interactive >> shell, it works as expected. >> >> This is with or without the -w option. H

Re: [BUGS] [HACKERS] 0x1A in control file on Windows

2008-09-23 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> pg_controldata is certainly already being read as binary. > Umm, no, it is in the backend I believe but not in the utilities. Hence > the original bug report. We need to add the binary flag in > pg_controldata.c and pg_resetxlog.c.

Re: [BUGS] [HACKERS] 0x1A in control file on Windows

2008-09-23 Thread Andrew Dunstan
Tom Lane wrote: Bruce Momjian <[EMAIL PROTECTED]> writes: Tom Lane wrote: Well, why is that a bug? If the platform is so silly as to define text files that way, who are we to argue? The problem is that our pg_controldata might have binary values that contain 0x1a that wi

Re: [BUGS] [HACKERS] 0x1A in control file on Windows

2008-09-23 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Well, why is that a bug? If the platform is so silly as to define text >> files that way, who are we to argue? > The problem is that our pg_controldata might have binary values that > contain 0x1a that will be confused by the operatin

Re: [BUGS] BUG #4433: entries like "host all all 10.0.50.31/0 ..." should not be allowed or trigger a warning

2008-09-23 Thread toruvinn
On Tue, 23 Sep 2008 11:44:24 +0200, security improvement proposal: pg_hba.conf and CIDR mask <[EMAIL PROTECTED]> wrote: Description:entries like "hostall all 10.0.50.31/0 ..." should not be allowed or trigger a warning A CIDR mask length of 0 will allow to connect from

Re: [BUGS] [HACKERS] 0x1A in control file on Windows

2008-09-23 Thread Bruce Momjian
Tom Lane wrote: > ITAGAKI Takahiro <[EMAIL PROTECTED]> writes: > > I found a bug that pg_controldata ends with error if control files > > contain 0x1A (Ctrl+Z) on Windows. > > > We probably need to add PG_BINARY when we open control files > > because 0x1A is an end-of-file marker on Windows. > >

Re: [BUGS] BUG #4435: pg_ctl start doesn't detach when run via SSH

2008-09-23 Thread Hal Black
That works, but interestingly, I still get a SIGHUP reload sometimes: LOG: received SIGHUP, reloading configuration files On Tue, Sep 23, 2008 at 1:54 PM, Steve Clark <[EMAIL PROTECTED]> wrote: > Hal Black wrote: > >> The following bug has been logged online: >> >> Bug reference: 4435 >> Lo

Re: [BUGS] BUG #4435: pg_ctl start doesn't detach when run via SSH

2008-09-23 Thread Steve Clark
Hal Black wrote: The following bug has been logged online: Bug reference: 4435 Logged by: Hal Black Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Ubuntu Hardy 8.04.1 LTS Description:pg_ctl start doesn't detach when run via SSH Details:

[BUGS] BUG #4435: pg_ctl start doesn't detach when run via SSH

2008-09-23 Thread Hal Black
The following bug has been logged online: Bug reference: 4435 Logged by: Hal Black Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Ubuntu Hardy 8.04.1 LTS Description:pg_ctl start doesn't detach when run via SSH Details: When I run "pg_c

[BUGS] BUG #4434: Error inserting into view - unrecognized node type: 313

2008-09-23 Thread Dean Rasheed
The following bug has been logged online: Bug reference: 4434 Logged by: Dean Rasheed Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: SuSE 10.3 64-bit Description:Error inserting into view - unrecognized node type: 313 Details: I'm getting

Re: [BUGS] BUG #4433: entries like "host all all 10.0.50.31/0 ..." should not be allowed or trigger a warning

2008-09-23 Thread Craig Ringer
security improvement proposal: pg_hba.conf and CIDR mask wrote: > The following bug has been logged online: > > Bug reference: 4433 > Logged by: security improvement proposal: pg_hba.conf and CIDR > mask > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2.4 > Operating

[BUGS] BUG #4433: entries like "host all all 10.0.50.31/0 ..." should not be allowed or trigger a warning

2008-09-23 Thread security improvement proposal: pg_hba.conf and CIDR mask
The following bug has been logged online: Bug reference: 4433 Logged by: security improvement proposal: pg_hba.conf and CIDR mask Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Linux Description:entries like "hostall all 10.0