Re: syntax error but command executes anyway? - Mailing list pgsql-general

Scott,

> > egenome_dev=# \i
> > /Users/murphy/cvs/egora/sql/data_port/port_identifiers.sql
> > INSERT 0 1672036
>
> This INSERT 0 part tells you it didn't actually insert anything.

Actually, that's not true.  I didn't know what this number was until just now,
but I looked it up: for a single-row insert, it's the OID of the new row;
otherwise, it's 0.  The 1672036, on the other hand, means that 1,672,036 rows
were inserted.

-Kevin Murphy