Re: [GENERAL] You are really hosed. - Mailing list pgsql-general

From Nikos Mouat
Subject Re: [GENERAL] You are really hosed.
Date
Msg-id Pine.LNX.4.10.9910100331280.11323-100000@rapture.cyberflunk.com
Whole thread Raw
In response to Re: [GENERAL] You are really hosed.  (Mike Mascari <mascarim@yahoo.com>)
Responses Re: [GENERAL] You are really hosed.
List 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


pgsql-general by date:

Previous
From: Yin-So Chen
Date:
Subject: stored procedure revisited
Next
From: Jeroen van Vianen
Date:
Subject: pgxml 1.0 released