From: Richard Chrenko <rchrenko@bluewin.ch>
To: pgsql-sql@postgreSQL.org
Subject: how to get "autonumber" when using INSERT INTO
Date: Tue, 04 May 1999 10:27:52 +0200
Message-ID: <372EAF88.49FB@bluewin.ch> (raw)
I'm trying what seems to me a trivial SQL task using Microsoft ADO to
write an Access table. I have several default tables containing the same
20 fields (but different data). I want to append the contents of these
tables into a "master" table which contains the same 20 fields in
addition to an autonumber field such that each appended record has a
unique identifier.
The following SQL queries succeed when run directly from Access
INSERT INTO mastertbl SELECT * FROM default1;
INSERT INTO mastertbl SELECT * FROM default2;
where mastertbl contains the same fields as default1 and default2 in
addition to an autonumber field. However, when these queries are
submitted via ADO from another application I get an error message that
the number of fields are unequal.
Please help me to get this to work using ADO!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: rchrenko@bluewin.ch
Subject: Re: how to get "autonumber" when using INSERT INTO
In-Reply-To: <372EAF88.49FB@bluewin.ch>
References: <372EAF88.49FB@bluewin.ch>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox