ion ]
[ [ NOT ] DEFERRABLE ]
[ INITIALLY checktime ]
=]
So perhaps you could try:
CREATE TABLE people
(
id INT4 PRIMARY KEY,
fullname TEXT
);
CREATE TABLE USERS
(
id INT4,
person_id INT4 REFERENCES people(id) ON DELETE CASCADE ON UPDATE
CASCADE
);
I think =[ I
equire identd or password authentication for the
127.0.0.1
or
your.local.machine.ip.address
;-)
HTH
Cheers,
John Clark
--
/) John Clark Naldoza y Lopez (\
/ )Software Design Engineer III ( \
_( (__ Web-Application Development_) )_
(((\ \> /_>Cable Modem Network Management System <_\
are also
> issues) so we can't simply modify the function attached to the comparison
> operators. Is there some means of modifying the behaviour of PostgreSQL so
> that it is case insensitive?
--
/) John Clark Naldoza y Lopez (\
/ )Software Desi
Anatole Varin wrote:
>
> Hi,
> Thanks for your advice. I set my password as you advised below, however I'm
> still having some problems connecting. When I try to connect I get the
> following error message:
>
> Unable to connect to PostgreSQL server: FATAL 1: SetUserId: user 'password='
> is not
Hi,
You could use the following...;-)
psql -U postgres template1
UPDATE pg_shadow SET passwd='whatever' WHERE usename='postgres';
You could also use GRANT or create other users as well... kindly check
the administrative section of your documentation...;-)
Cheers,
John Clark
