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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html