INSERT 0 1 "problems"

Started by Stefan Schwarzerover 19 years ago2 messagesgeneral
Jump to latest
#1Stefan Schwarzer
stefan.schwarzer@grid.unep.ch

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!!

#2Florian Weimer
fweimer@bfk.de
In reply to: Stefan Schwarzer (#1)
Re: INSERT 0 1 "problems"

* 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