> > 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings