Re: Subselect query for a multi table insert single query

From: norman(at)khine(dot)net
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Subselect query for a multi table insert single query
Date: 2002-09-23 09:56:31
Message-ID: 1032774990.30699@o-a-l.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Browse pgsql-novice by date

  From Date Subject
Next Message Steinn E. Sigurdarson 2002-09-23 14:23:34 pgcrypto
Previous Message Norman Khine 2002-09-23 06:23:15 Re: Subselect query for a multi table insert single query