Re: [GENERAL] You are really hosed.

From: Nikos Mouat <nikm(at)cyberflunk(dot)com>
To: Mike Mascari <mascarim(at)yahoo(dot)com>
Cc: Michael Plump <plumpy(at)skylab(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] You are really hosed.
Date: 1999-10-10 10:32:45
Message-ID: Pine.LNX.4.10.9910100331280.11323-100000@rapture.cyberflunk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> SELECT oid from pg_database where datname =
> 'template1'
>

it turns out there was multiple template1's in the pg_database table:

template1=> select * from pg_database;l
datname |datdba|encoding|datpath
---------+------+--------+---------
template1| 100| 0|template1
template1| 100| 0|template1
darwin | 100| 0|darwin
template1| 100| 0|template1
(4 rows)

pg_dump works fine now (I deleted two of the three template1's)

nm

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message amy cheng 1999-10-10 12:18:30 Re: [GENERAL] stored procedure revisited
Previous Message Yin-So Chen 1999-10-10 07:33:33 stored procedure revisited