Re: syntax error but command executes anyway?

Поиск
Список
Период
Сортировка
От Kevin Murphy
Тема Re: syntax error but command executes anyway?
Дата
Msg-id 200406192306.06613.murphy@genome.chop.edu
обсуждение исходный текст
Ответ на Re: syntax error but command executes anyway?  ("Scott Marlowe" <smarlowe@qwest.net>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: File System Restore
Следующее
От: Kevin Murphy
Дата:
Сообщение: Re: syntax error but command executes anyway?