[BUGS] BUG #1921: NULL<>NULL ?!?!?!?!?!?!?

2005-09-29 Thread BogDan Vatra
The following bug has been logged online: Bug reference: 1921 Logged by: BogDan Vatra Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: win xp pro Description:NULL<>NULL ?!?!?!?!?!?!? Details: Please execute this query: create table test

Re: [BUGS] Postgresql problem in AIX 5.3

2005-09-29 Thread Chris Browne
[EMAIL PROTECTED] ("Kelvin Lau") writes: > I have a question regarding Postgresql on AIX 5.3's compatibility, since > there are reported problems for this combination in newsgroup. I have also > tried to install it also. The installation was successful and there was a > message indicating that.

[BUGS] BUG #1920: Installer no WIN1252 & UTF8 selection

2005-09-29 Thread Andrew
The following bug has been logged online: Bug reference: 1920 Logged by: Andrew Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1-B2 (win32) Operating system: XP Professional Description:Installer no WIN1252 & UTF8 selection Details: I can't select those 2 op

Re: [BUGS] BUG #1920: Installer no WIN1252 & UTF8 selection

2005-09-29 Thread Magnus Hagander
> The following bug has been logged online: > > Bug reference: 1920 > Logged by: Andrew > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1-B2 (win32) > Operating system: XP Professional > Description:Installer no WIN1252 & UTF8 selection > Details: > > I ca

Re: [BUGS] BUG #1921: NULL<>NULL ?!?!?!?!?!?!?

2005-09-29 Thread Gaetano Mendola
BogDan Vatra wrote: > The following bug has been logged online: > > Bug reference: 1921 > Logged by: BogDan Vatra > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.3 > Operating system: win xp pro > Description:NULL<>NULL ?!?!?!?!?!?!? > Details: > > Pleas

Re: [BUGS] BUG #1921: NULL<>NULL ?!?!?!?!?!?!?

2005-09-29 Thread j6m
Hi, The SQL standard requires that null values do not equate any value, including themselves. Corrected syntax of your queries is shown below. If I recall it correctly, this nehaviour was enforced in the 7.2->7.3 or 7.1->7.2 evolution. If for instance a char(1) field called 'myfield' admits sev

Re: [BUGS] BUG #1920: Installer no WIN1252 & UTF8 selection

2005-09-29 Thread Magnus Hagander
> > I can't select those 2 options for database encoding when > initializing > > cluster from the Win32 installer. This is in the list of > new features > > for 8.1. > > > > Most likely just a minor oversight on the installer and not the > > database itself. > > > > Please correct me if I'm

Re: [BUGS] BUG #1921: NULL<>NULL ?!?!?!?!?!?!?

2005-09-29 Thread David Fetter
On Thu, Sep 29, 2005 at 09:38:54AM +0100, BogDan Vatra wrote: > > The following bug has been logged online: > > Bug reference: 1921 > Logged by: BogDan Vatra > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.3 > Operating system: win xp pro > Description:NU

[BUGS] horology regression test failure

2005-09-29 Thread Martin Pitt
Hi! On almost all Debian platforms the horology test for 8.0.3 fails. Sometimes it works on a platform, sometimes not, I did not yet find a pattern, but most often it fails with something like *** ./expected/horology.out Sun Jul 11 04:57:20 2004 --- ./results/horology.out Thu Sep 29 20:4

Re: [BUGS] horology regression test failure

2005-09-29 Thread Alvaro Herrera
On Thu, Sep 29, 2005 at 11:08:22PM +0200, Martin Pitt wrote: > On almost all Debian platforms the horology test for 8.0.3 fails. > Sometimes it works on a platform, sometimes not, I did not yet find a > pattern, but most often it fails with something like I think this test is supposed to fail whe

Re: [BUGS] horology regression test failure

2005-09-29 Thread Tom Lane
Martin Pitt <[EMAIL PROTECTED]> writes: > On almost all Debian platforms the horology test for 8.0.3 fails. Before PG 8.0, I'd have said you were running with a timezone library that didn't understand about DST before 1970. It shouldn't be happening in 8.0 though. regards

Re: [BUGS] horology regression test failure

2005-09-29 Thread Martin Pitt
Hi Tom! Tom Lane [2005-09-29 17:50 -0400]: > Martin Pitt <[EMAIL PROTECTED]> writes: > > On almost all Debian platforms the horology test for 8.0.3 fails. > > Before PG 8.0, I'd have said you were running with a timezone library > that didn't understand about DST before 1970. It shouldn't be hap

[BUGS] [patch] krb5 authentication on multihomed server hosts

2005-09-29 Thread Martin Pitt
Hi! I recently got a Debian bug report [1] that says: "It is not always possible to use krb5 authentication to a server that is listening on multiple interfaces other than to the 'primary' interface. More specifically: src/backend/libpq/auth.c pg_krb5_init() fills in the pg_krb5_server

Re: [BUGS] Column Name parameter problem

2005-09-29 Thread vishal saberwal
hi tomas, The solution you sent worked, but i have another rissue related to this. I am trying to create a stored procedure that can accept TableName, ColumnName as parameter and return teh records pertaining to them. This way, i will not need to make the procedures for every table. But the proble

Re: [BUGS] [patch] krb5 authentication on multihomed server hosts

2005-09-29 Thread Bruce Momjian
I think this is fixed in CVS and will be in 8.1. We now have in postgresql.conf: # Kerberos #krb_server_keyfile = '' #krb_srvname = 'postgres' #krb_server_hostname = '(any)' # if not set, matches any keytab entry #krb_caseins_users = off