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

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 (view raw or flat)
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

pgsql-novice by date

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

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