Re: - Mailing list pgsql-hackers

From mlw
Subject Re:
Date
Msg-id 3E26D563.10608@mohawksoft.com
Whole thread Raw
In response to  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
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
>
>  
>




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re:
Next
From: Jeff
Date:
Subject: Re: Oracle rant