From: "Good, Thomas" <TGood@svwsjmc.org>
To: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Date: Thu, 17 Mar 2011 12:26:34 -0400
Subject: Bizarreness at A2 Hosting
Thread-Topic: Bizarreness at A2 Hosting
Thread-Index: AQHL5MAUuCMMwW1JR0WL52kEnqt3tg==
Message-ID: <C3FA421FEED237488E9820D1ED668F330AB5ABC7@SVWEMAIL>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

I realize this is not the right list for this question but I am just flabbe=
rgasted, am only on one list, and, know Tom Lane is here so, please excuse.=
..

Here is the deal:

On a2 hosting I do the following:

1) create a new database in cpanel
2) login via psql
3) run \d=20

AND - there is ALREADY a table belonging to another user (not a privileged =
user, another account owner)
I can see this guy's schema but can't access the data. (I guess that's a po=
sitive)

I have repeated this three times so far...after I created a db, populated i=
t and found a table that wasn't mine I created a test db that should have b=
een empty.

4) try to run pg_dump - it fails as it is unable to lock this other guy's t=
able

tech suppt argues with me that their template is not hosed, "that is the na=
ture of postgre," he said (not a typo, he omitted the trailing s)

These guys are recommended by postgresql.org so I figured I'd try em...
I have another account (for a client whom I support pro bono) and they do n=
ot have this problem. New databases are empty as one would expect.

Can someone tell me what exactly the problem is - I am waiting for a superv=
isor to call me back and I'd like to lead him to the answer so he can fix t=
he problem.

thanks much
--
Thomas A. Good, Senior Database Administrator
Saint Vincent's Hospital Westchester
A Division of Saint Joseph's Medical Center
Residential Services
75 Vanderbilt Avenue, Room 5-47
Staten Island, NY 10304
718.818.5528=