ogr2ogr: PostgreSQL support creating UNLOGGED tables

[andrewharvey]

Similar to changeset r19702 which introduced creation of TEMPORARY tables, I would like to be able to created UNLOGGED tables with a similar UNLOGGED layer creation option.

According to the PostgreSQL documentation you can't have both a TEMPORARY and UNLOGGED table so a patch would need to take that into account.

The patch would also need to take into account unlogged GiST indexes are currently not supported and cannot be created on an unlogged table, meaning this option is only usable with the lco SPATIAL_INDEX=OFF.

The latter restriction probably means it wouldn't be very useful for most situations, but there are still some instances where you could want UNLOGGED with no GIST spatial index.

Unless someone else is willing to give this a shot, and assuming the idea isn't shot down I will have a go at creating a patch after I get some comments/thoughts on this ticket.

[warmerdam]

I see no problem with adding this. Note it isn't critical that you validate that it isn't used in combination with TEMPORARY since postgres will enforce this and error out.

[Even Rouault]

trunk r28908 "PG/PGDump: add UNLOGGED=YES/NO layer creation option to create unlogged tables (improved version of patch by Javier Santana, #4708)"

[Even Rouault]

Milestone renamed