Re: syntax error but command executes anyway?

From: Kevin Murphy <murphy(at)genome(dot)chop(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: syntax error but command executes anyway?
Date: 2004-06-19 23:06:06
Message-ID: 200406192306.06613.murphy@genome.chop.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Murphy 2004-06-19 23:34:36 Re: syntax error but command executes anyway?
Previous Message Tom Lane 2004-06-19 22:07:52 Re: File System Restore