Skip site navigation (1) Skip section navigation (2)

Multi table insert

From: norman <norman_khine(at)yahoo(dot)co(dot)uk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Multi table insert
Date: 2006-10-27 12:07:34
Message-ID: 20061027120734.89562.qmail@web26511.mail.ukl.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hello,
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">);

<dtml-var sql_delimiter>

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">,
business_name_business_name_seq.last_value);

#########

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.

Many thanks

Norman

 		
---------------------------------
 All new Yahoo! Mail "The new Interface is stunning in its simplicity and ease of use." - PC Magazine

Responses

pgsql-novice by date

Next:From: A. KretschmerDate: 2006-10-27 12:17:02
Subject: Re: Multi table insert
Previous:From: Jim C. NasbyDate: 2006-10-27 03:47:04
Subject: Re: Migrating database from Unix to Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group