I don't think a semicolon is a comment. It causes the execution of the
previous statement.
Christopher Kings-Lynne wrote:
>Hi,
>
>In postgresql 7.3.1, if I do pg_dumpall -c, at the top of the dump file is
>this:
>
>DROP DATABASE au_shipping
>;CREATE DATABASE au_shipping WITH OWNER = auadmin TEMPLATE = template0
>ENCODING = 'SQL_ASCII';
>DROP DATABASE au_test
>;CREATE DATABASE au_test WITH OWNER = chriskl TEMPLATE = template0 ENCODING
>= 'SQL_ASCII';
>DROP DATABASE australia
>;CREATE DATABASE australia WITH OWNER = auadmin TEMPLATE = template0
>ENCODING = 'SQL_ASCII';
>DROP DATABASE geeklog
>;CREATE DATABASE geeklog WITH OWNER = chriskl TEMPLATE = template0 ENCODING
>= 'SQL_ASCII';
>DROP DATABASE keystone
>;CREATE DATABASE keystone WITH OWNER = chriskl TEMPLATE = template0 ENCODING
>= 'SQL_ASCII';
>
>Why are all the CREATE DATABASE statements commented out? Surely that will
>make the restore fail?
>
>Chris
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
>
>
>