pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: James Wilford <jwilford@mistral.net>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: More than one pg_database entry for database
Date: Fri, 06 Jul 2007 12:39:28 -0400
Message-ID: <6176.1183739968@sss.pgh.pa.us> (raw)
In-Reply-To: <BA2CC7B7A60EF64B968B268B500397CB11B321@migsexch01.miint.mistral.net>
References: <BA2CC7B7A60EF64B968B268B500397CB11B2FC@migsexch01.miint.mistral.net>
	<11565.1183647202@sss.pgh.pa.us>
	<BA2CC7B7A60EF64B968B268B500397CB11B31E@migsexch01.miint.mistral.net>
	<18569.1183652804@sss.pgh.pa.us>
	<BA2CC7B7A60EF64B968B268B500397CB11B320@migsexch01.miint.mistral.net>
	<19238.1183657129@sss.pgh.pa.us>
	<20070705175304.GL5500@alvh.no-ip.org>
	<19714.1183659436@sss.pgh.pa.us>
	<BA2CC7B7A60EF64B968B268B500397CB11B321@migsexch01.miint.mistral.net>

"James Wilford" <jwilford@mistral.net> writes:
> I'd like to try the dump and reload - the only problem is that I can't
> use pg_dump because of the error. And I can't rename the entry in
> pg_database because my update statement won't match any rows.

You can't change the dead entry, but it should work to rename the live
one.

BTW, you have one of the most annoying quoting styles I have ever seen:
it's impossible to tell your words from those of the message you are
replying to, and not trimming the overhead from that message wastes
still more of your readers' time.  Please change your habits, or you
are likely to find that people stop reading your mail.

			regards, tom lane



view thread (10+ messages)

Message-ID: <6176.1183739968@sss.pgh.pa.us>
Permalink:  ../6176.1183739968@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/6176.1183739968@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, jwilford@mistral.net, alvherre@commandprompt.com
  Subject: Re: More than one pg_database entry for database
  In-Reply-To: <6176.1183739968@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox