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
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
--
Your pg_hba.conf listing does not include a password FILE - the format
is:
hostallowedDB's IPaddys maskAUTHTYPEPASSWORDFILE
(such as(such as
"password", "mypassw
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),
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->
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
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