Re: COPY with no WAL, in certain circumstances
От | Joshua D. Drake |
---|---|
Тема | Re: COPY with no WAL, in certain circumstances |
Дата | |
Msg-id | 1168106043.20486.4.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: COPY with no WAL, in certain circumstances (Bruce Momjian <bruce@momjian.us>) |
Ответы |
Re: COPY with no WAL, in certain circumstances
|
Список | pgsql-patches |
> > BEGIN; > > CREATE TABLE foo... > > INSERT INTO foo VALUES ('1'); > > COPY foo... > > > > COMMIT; > > On ABORT, the entire table disappears, as well as the INSERT, so I don't > see any problem. I assume the INSERT is WAL logged. No I don't see any problems, I am just trying to understand the boundaries. E.g., is there some weird limitation where if I have any values in the table before the copy (like the example above) that copy will go through WAL. Or in other words, does this patch mean that all COPY execution that is within a transaction will ignore WAL? Joshua D. Drake > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
В списке pgsql-patches по дате отправления: