Re: [GENERAL] User authentication blues

1998-07-30 Thread Maarten Boekhold
On Thu, 30 Jul 1998, Maarten Boekhold wrote: > Hi, > > I have a 6.3.2 server, and I want to use password authentication. > So, I gave the user 'postgres' and some other user a password, and I put this > in my pg_hba.conf: > > host all 127.0.0.1 255.255.255.255 password > h

Re: [GENERAL] Strange behaviour ?

1998-07-30 Thread Daniele Orlandi
James Boorn wrote: > > look up the differences between varchar and char data types. I know the difference between varchar and char, but I don't see why LOWER() is adding spaces. If this is the correct behaviour, could you kindly point me to the related docs ? Thanks. Bye! -- Daniele --

Re: [GENERAL] User authentication blues

1998-07-30 Thread Jeffrey Napolitano
Your pg_hba.conf listing does not include a password FILE - the format is: hostallowedDB's IPaddys maskAUTHTYPEPASSWORDFILE (such as(such as "password", "mypassw

Re: [GENERAL] Strange behaviour ?

1998-07-30 Thread James Boorn
look up the differences between varchar and char data types. On Thu, 30 Jul 1998, Daniele Orlandi wrote: > tacacs=> CREATE TABLE bugdb > tacacs-> ( > tacacs-> id int4 default nextval('bugdb_id_seq') primary key, > tacacs-> emailvarchar(50) NOT NULL, > tacacs-> sdescr varchar(80),

[GENERAL] Strange behaviour ?

1998-07-30 Thread Daniele Orlandi
tacacs=> CREATE TABLE bugdb tacacs-> ( tacacs-> id int4 default nextval('bugdb_id_seq') primary key, tacacs-> emailvarchar(50) NOT NULL, tacacs-> sdescr varchar(80), tacacs-> ldescr text, tacacs-> version char(16), tacacs-> status char(16), tacacs-> comments text, tacacs->

[GENERAL] User authentication blues

1998-07-30 Thread Maarten Boekhold
Hi, I have a 6.3.2 server, and I want to use password authentication. So, I gave the user 'postgres' and some other user a password, and I put this in my pg_hba.conf: host all 127.0.0.1 255.255.255.255 password host all 206.31.72.11 255.255.255.255 passwo

[GENERAL] btree bug found & fixed

1998-07-30 Thread Vadim Mikheev
We've discovered very old bug in btree indices. It's present in all PostgreSQL versions. This bug affects UPDATE and INSERT INTO _table_ SELECT FROM _table_ under some circumstances. Patch for 6.3.2 is available via ftp://ftp.postgresql.org/pub/patches/btree_adj-980730.gz. Thanks to Tom Lane fo