Currval question and confusion

From: Kumar S <ps_postgres(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Currval question and confusion
Date: 2005-03-05 19:40:47
Message-ID: 20050305194047.71539.qmail@web51402.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Dear Group,
my question:

I am using python scripts to create insert statements
for populating my tables.

First I fill table 1 and the primary key of table1 is
a FK in table2. Table2 PK is FK in Table3

I am filling in the following order:
Table 1

Take currval(table1_pk_seq) of ta table1 and write in
table2

Take currval in table2 and fill in the table3.

Now 3 people have simultaneously issued insert
statements. After some time while the second process
is still filling table 1 and enters table2 the currval
position has been changed. Then will I be assigning a
wrong FK in table2 and table3.

In this case Do i have to write any triggers.?

Please suggest some ideas.

thank you
k



__________________________________
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.yahoo.com/netrospective/

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2005-03-05 20:05:23 Re: Currval question and confusion
Previous Message Bruno Wolff III 2005-03-05 06:50:04 Re: Form Design Advice