Re: [BUGS] BUG #1191: odd usage of port 512 on localhost

2004-07-12 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > Since I've installed postgres on debian-testing I'm getting firewall logs > of: > RELATED PACKET: > SRC=localhost DST=localhost PROTO=ICMP CODE=3,3 > PROTO=UDP SPT=1030 DPT=512 > My logs show it happens every time postgres postmaster sends ma

[BUGS] BUG #1191: odd usage of port 512 on localhost

2004-07-12 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1191 Logged by: John D. Hendrickson Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Debian testing Description:odd usage of port 512 on localhost Details: Hi, Since I've instal

[BUGS] SSL failure, v7.3.6

2004-07-12 Thread John Madden
Your name : John Madden Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : Intel Xeon Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.26 (Debian 3.0) PostgreSQL version (example: Po

Re: [BUGS] UNIQUE not honoured for NULL

2004-07-12 Thread Andreas Pflug
Gaetano Mendola wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bruno Wolff III wrote: | On Mon, Jul 12, 2004 at 14:47:34 +0200, | Gaetano Mendola <[EMAIL PROTECTED]> wrote: | |>As someone says NULL = NULL is false | | | As someone else pointed out, NULL = NULL is NULL which is not TRUE. Yes

Re: [BUGS] UNIQUE not honoured for NULL

2004-07-12 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bruno Wolff III wrote: | On Mon, Jul 12, 2004 at 14:47:34 +0200, | Gaetano Mendola <[EMAIL PROTECTED]> wrote: | |>As someone says NULL = NULL is false | | | As someone else pointed out, NULL = NULL is NULL which is not TRUE. Yes, that it's better. Reg

Re: [BUGS] UNIQUE not honoured for NULL

2004-07-12 Thread Bruno Wolff III
On Mon, Jul 12, 2004 at 14:47:34 +0200, Gaetano Mendola <[EMAIL PROTECTED]> wrote: > > As someone says NULL = NULL is false As someone else pointed out, NULL = NULL is NULL which is not TRUE. ---(end of broadcast)--- TIP 8: explain analyze is you

Re: [BUGS] BUG #1190: Postgres/Jboss Synchronization

2004-07-12 Thread Stephan Szabo
On Mon, 12 Jul 2004, PostgreSQL Bugs List wrote: > we are stuck at a very crucial point,we are using postgres as our db server > and jboss as our applicaton server,our business logic has been coded in > stored proceudres and when we deploy our webapplicatoin on windows it works > fine,but as we de

Re: [BUGS] UNIQUE not honoured for NULL

2004-07-12 Thread Gaetano Mendola
David Newall wrote: PostgreSQL version: 7.4.3 (RPMs from ftp.au.postgresql.org) Operating Sysem: Fedora Core 1 CREATE TABLE t(i integer UNIQUE); INSERT INTO t VALUES (null); INSERT INTO t VALUES (null); SELECT coalesce(i,-999) FROM t; coalesce -- -999 -999 (2 rows) As someone sa

[BUGS] BUG #1190: Postgres/Jboss Synchronization

2004-07-12 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1190 Logged by: hemal shah Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.4 Operating system: Linux Red Hat 9.0 Description:Postgres/Jboss Synchronization Details: hi, we are stuck at a very cr

Re: [BUGS] Bug related with permissions - VIEWS and RULES

2004-07-12 Thread Luis Sousa
Tom Lane wrote: Alvaro Herrera <[EMAIL PROTECTED]> writes: On Tue, Jul 06, 2004 at 09:33:17AM +0100, Luis Sousa wrote: Can anyone tell me if the bug reported on http://www.mail-archive.com/[EMAIL PROTECTED]/msg07755.html is already fixed?