Re:

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

In response to

  • Re: at 2003-01-16 08:15:27 from Devrim GUNDUZ

Responses

  • Re: at 2003-01-16 15:39:57 from Tom Lane

Browse pgsql-hackers by date

  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:

Browse pgsql-patches by date

  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: