I have created a multi-table insert script in python, the problem is that this worked fine on an older PostgreSQL db (7.2) but now I get an
Error, psycopg2.ProgrammingError: missing FROM-clause entry for table "business_name_business_name_seq"
Here is part of the script
It is a Z SQL Method for Zope.
INSERT INTO business_name (business_name, business_url, business_type_id)
values (<dtml-sqlvar business_name type="string" >, <dtml-sqlvar business_url type="string">, <dtml-sqlvar business_type_list_id type="int">);
INSERT INTO business_address (street_name, town, city, postcode, county_id, business_name_id) values
(<dtml-sqlvar street_name type="string">,
<dtml-sqlvar town type="string">,
<dtml-sqlvar city type="string">,
<dtml-sqlvar postcode type="string">,
<dtml-sqlvar county_list type="int">,
Here I want to take the last_value for the business_name_id that was generated in the first insert and put it as the related item in the next INSERT table.
Is there a better way to do this? I have 4 tables all related and one input form.
All new Yahoo! Mail "The new Interface is stunning in its simplicity and ease of use." - PC Magazine
pgsql-novice by date
|Next:||From: A. Kretschmer||Date: 2006-10-27 12:17:02|
|Subject: Re: Multi table insert|
|Previous:||From: Jim C. Nasby||Date: 2006-10-27 03:47:04|
|Subject: Re: Migrating database from Unix to Windows|