From: Dino Cherian K <inimss@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: [INIMSS] How to foreign key
Date: Wed, 13 Mar 2002 11:37:56 +0530
Message-ID: <02031311263300.01381@dino> (raw)
Hi
Is there any way that I can manage the relation between two tables in some
what automatic way?
I have two tables A and B with primary keys pka and pkb respectively, of type
serial. the pka is refered in the table B as foreign key. Its somewhat like
the one given below.
Table A
-------------
pka | serial
name | varchar(20)
status | int4
Table B
-------------
pka | serial
pkb | int4
child | varchar(20)
status | int4
Now the operator enters information to both the table from the same GUI
window, so that the data relevant to table A is inserted and we take the
newly got pka value by selecting ths MAX(A.pka). Then we insert the data
relevant to the table B along with the new pka value. Here both the tables
are exclusively locked before starting the data insertions, and later
unlocked.
This was the method I used in my program. Is there any other method by which
we can make it in a better way?
Thanks
Dino Cherian K
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: inimss@yahoo.com
Subject: Re: [INIMSS] How to foreign key
In-Reply-To: <02031311263300.01381@dino>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox