Re: #postgresql report - Mailing list pgsql-hackers

From Marc G. Fournier
Subject Re: #postgresql report
Date
Msg-id 20040615142005.H1028@ganymede.hub.org
Whole thread Raw
In response to Re: #postgresql report  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On Tue, 15 Jun 2004, Peter Eisentraut wrote:

> Christopher Kings-Lynne wrote:
>> * We have a request for how to change database encoding every other
>> day
>
> This is pretty much impossible.  It's analogous to changing, say, the
> endianness of all integers.  You would need to rewrite the entire
> database.  But pg_dump & restore already does that.

Just a thought here ... but, how about some sort of CREATE DATABASE 
extension that would transparently do the dump/restore, with the restore 
based on the new encoding?

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664


pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: 7.4.3 running a bit late ...
Next
From: Josh Berkus
Date:
Subject: Re: #postgresql report