[Fwd: Help with Postgres] - Mailing list pgsql-general

From Edmund Mergl
Subject [Fwd: Help with Postgres]
Date
Msg-id 36CC73AD.6B7CAD55@bawue.de
Whole thread Raw
List pgsql-general
 Hi,

I know I should not be bothering you with this, but I do not know as yet
any help groups, IRC channels, etc for postgres stuff.

1.  Firstly, how would I implement a composite key in postgres?

I tried the following :

create table temp (
i int PRIMARY KEY,
j int PRIMARY KEY);

but it didn't work.

2.  This question concerns referential integrity.  I have noticed that
when I include clauses like REFERENCES table, nothing of the sort
happens.  I can still insert any gibberish into these fields.  How would
I implement referential integrity, and cascading of deletions and
updates?

Thanks, your help is much appreciated!

MANIK SURTANI




pgsql-general by date:

Previous
From: "Bryan White"
Date:
Subject: Rename a database
Next
From: Gregory Maxwell
Date:
Subject: Re: [GENERAL] GIS/GPS Experiences with pgsql?