VACUUM in spatial_ref_sys.sql throws error

[kneufeld]

Loading the spatial_ref_sys.sql file manually in PgAdmin? III throws the error:

ERROR:  VACUUM cannot be executed from a function or multi-command string

********** Error **********

ERROR: VACUUM cannot be executed from a function or multi-command string
SQL state: 25001

I recommend the two offending lines (1719 and 15142)

VACUUM ANALYZE spatial_ref_sys;

be replaced with

ANALYZE spatial_ref_sys;

VACUUM is not needed anyway since no DELETEs or UPDATEs have taken place, only INSERTs - there's no need to reclaim space.

[kneufeld]

Also, is there a reason the file is broken into two transaction blocks?

When loading in PgAdmin?, the first transaction succeeds, but then the VACUUM breaks the script. The data is partly loaded. I can't rerun the script, I have to truncate the table first, then attempt a reload.

This kinda defeats the purpose of having a single transaction block, no?

[pramsey]

Feel free to fix. P.

[kneufeld]

Removed unnecessary VACUUM.

Turned file into a single transaction.

Fixed at r4987