pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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!



Message-ID: <372EAF88.49FB@bluewin.ch>
Permalink:  ../372EAF88.49FB@bluewin.ch/
Also on:    postgresql.org/message-id/372EAF88.49FB@bluewin.ch

 · 

reply

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