Re: pg_dump multi VALUES INSERT
От | David Rowley |
---|---|
Тема | Re: pg_dump multi VALUES INSERT |
Дата | |
Msg-id | CAKJS1f8=qKfNBFK5Y5DG_eoGaCD5SxuukQNpZPOOSeVPPPdemQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: pg_dump multi VALUES INSERT (Surafel Temesgen <surafel3000@gmail.com>) |
Ответы |
Re: pg_dump multi VALUES INSERT
|
Список | pgsql-hackers |
Just looking at the v5 patch, it seems not to handle 0 column tables correctly. For example: # create table t(); # insert into t default values; # insert into t default values; $ pg_dump --table t --inserts --insert-multi=100 postgres > dump.sql # \i dump.sql [...] INSERT 0 1 psql:dump.sql:35: ERROR: syntax error at or near ")" LINE 1: ); ^ I'm not aware of a valid way to insert multiple 0 column rows in a single INSERT statement, so not sure how you're going to handle that case. -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
В списке pgsql-hackers по дате отправления: