Thread: INSERT 0 1 "problems"

Hi there,

how comes that sometimes, when I use something like this:

          psql name_of_my_database < inserts.sql

Postgres displays

         INSERT 0 1
         INSERT 0 1
         INSERT 0 1

but sometimes it counts

        INSERT 48593 1
        INSERT 48594 1
        INSERT 48595 1

???

Although all data are being inserted, I would like to do a "clean"
job and see the counting for all inserts...

Any hints are very much appreciated!!

* Stefan Schwarzer:

>         INSERT 0 1

>        INSERT 48593 1

The former is printed if the table hasn't got an OID column (new
default), the latter is used when OIDs are available (old default,
nowadays it's CREATE TABLE ... WITH OIDS).

--
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Durlacher Allee 47            tel: +49-721-96201-1
D-76131 Karlsruhe             fax: +49-721-96201-99