Re: [HACKERS] - Mailing list pgsql-patches

From Christopher Kings-Lynne
Subject Re: [HACKERS]
Date
Msg-id GNELIHDDFBOCMGBFGEFOEEAPCFAA.chriskl@familyhealth.com.au
Whole thread Raw
Responses Re: [HACKERS]  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
You're right.  It's a type in pg_dumpall.c

I have attached a fix for it.

Chris

> > ;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?
>
> Just guessing:
>
> The first line does not have a ; at the end; so the first semicolon (at
> the beginning of second line) will end the first line; will not comment
> the CREATE DATABASE line...
>
> I mean, it might work as below:
> DROP DATABASE au_shipping;
>
> CREATE DATABASE au_shipping WITH OWNER = auadmin TEMPLATE = template0
> ENCODING = 'SQL_ASCII';


Attachment

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: replace oidrand() with random_sample()
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS]