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

Search Discussions

  • Florian Weimer at Jul 17, 2006 at 9:10 am

    * 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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedJul 17, '06 at 9:05a
activeJul 17, '06 at 9:10a
posts2
users2
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase