Postgres Pro
Downloads
Home   >   mailing lists

Re: Subselect query for a multi table insert single query - Mailing list pgsql-novice

From norman@khine.net
Subject Re: Subselect query for a multi table insert single query
Date
Msg-id 1032774990.30699@o-a-l.net
Whole thread Raw
In response to Subselect query for a multi table insert single query  ("Norman Khine" <norman@khine.net>)
List pgsql-novice
Tree view 
Hi Tom,
I tried this on the command prompt but got the following error:

admin=> INSERT INTO business_address (street_name, town, county, postcode, county_id, business_name_id) values
('xcasc','ascasc', 'ascasc', 'acasc', 2, currval('business_name_business_name_seq')); 
ERROR:  business_name_business_name_seq.currval is not yet defined in this session

Any ideas as to what is going on.

Cheers

Norm

pgsql-novice by date:

Previous
From: "Norman Khine"
Date:
Subject: Re: Subselect query for a multi table insert single query
Next
From: "Joachim Smit"
Date:
Subject: Disk space