CommandStatus from insert returning when using a portal.
| От | Dave Cramer |
|---|---|
| Тема | CommandStatus from insert returning when using a portal. |
| Дата | |
| Msg-id | CADK3HHKn-7wghU7GzY3pSBuQsyXv2=w2_g7KKYm9cGRLfL=JtA@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: CommandStatus from insert returning when using a portal.
Re: CommandStatus from insert returning when using a portal. Re: CommandStatus from insert returning when using a portal. |
| Список | pgsql-hackers |
Greetings,
With a simple insert such as
INSERT INTO test_table (cnt) VALUES (1), (2) RETURNING id
if a portal is used to get the results then the CommandStatus is not returned on the execute only when the portal is closed. After looking at this more it is really after all of the data is read which is consistent if you don't use a portal, however it would be much more useful if we received the CommandStatus after the insert was completed and before the data
Obviously I am biased by the JDBC API which would like to have
PreparedStatement.execute() return the number of rows inserted without having to wait to read all of the rows returned
Dave Cramer
В списке pgsql-hackers по дате отправления: