Thread: [Fwd: Help with Postgres]

[Fwd: Help with Postgres]

From
Edmund Mergl
Date:
 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