From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | "Devrim GUNDUZ" <devrim(at)tr(dot)net> |
Cc: | "PostgreSQL - Hackers" <pgsql-hackers(at)postgresql(dot)org>, "Patches" <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: |
Date: | 2003-01-16 08:43:12 |
Message-ID: | GNELIHDDFBOCMGBFGEFOEEAPCFAA.chriskl@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers 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 | Content-Type | Size |
---|---|---|
pg_dumpall.txt | text/plain | 942 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian 'Dagurashibanipal' von Bidder | 2003-01-16 10:07:03 | Re: Oracle rant |
Previous Message | Devrim GUNDUZ | 2003-01-16 08:15:27 | Re: |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-01-16 15:39:57 | Re: |
Previous Message | Devrim GUNDUZ | 2003-01-16 08:15:27 | Re: |