From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | FW: FW: Delete PostgreSQL Database |
Date: | 2002-07-24 20:46:35 |
Message-ID: | D85C66DA59BA044EB96AB9683819CF61137FA0@dogbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
[Forwarded to the list because our ISP seems to be on the blacklist
Larry is using :-( ]
-----Original Message-----
From: Dave Page
Sent: 24 July 2002 21:45
To: 'Larry Reagor'
Subject: RE: [pgadmin-support] FW: Delete PostgreSQL Database
Hi Larry,
Try:
SELECT * FROM "People" WHERE "NameType" = 2 ORDER BY
"LastName","FirstName","MiddleName"
Mixed case names must be quoted in PostgreSQL. The other easy
way around it is to create (or rename) all your objects with lower case
names.
Regards, Dave.
-----Original Message-----
From: Larry Reagor [mailto:lreagor(at)macomb(dot)com]
Sent: 24 July 2002 21:15
To: Dave Page
Subject: RE: [pgadmin-support] FW: Delete PostgreSQL
Database
Thank you Dave, we figured it out using dropdb.
Another question: what is the proper .Provider string or
.ConnectionString to connect to a PostgreSQL db from VB6 using ADO?
Here is what I tried:
.ConnectionString =
"driver={PostgreSQL};server=ABCDATA;uid=lreagor;pwd=test123;database=Bod
yBuilder"
My SQL string to open the recordset is:
"SELECT * FROM People WHERE NameType = 2 ORDER BY
LastName,FirstName,MiddleName"
It seems I get an error once I try to connect and open a
recordset:
"Error while executing the query; ERROR: relation
'People' does not exist." (error -2147467259)
Larry
-----Original Message-----
From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org]On Behalf Of Dave Page
Sent: Tuesday, July 23, 2002 3:06 PM
To: pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] FW: Delete
PostgreSQL Database
The code that *should* work was written was left
in. I suppose it should be commented out though. If you're interested,
the reason you can't drop the database is because Microsoft ADO
helpfully keeps the connection open for reuse should we need it (a
technique called pooling).
Regards, Dave.
-----Original Message-----
From: Larry Reagor
[mailto:lreagor(at)macomb(dot)com]
Sent: 23 July 2002 04:51
To: Dave Page
Subject: RE: [pgadmin-support] FW:
Delete PostgreSQL Database
I was able to drop an unwanted one
earlier from pgAdmin (pgAdmin II) when I was just testing the Access
migration plug in. Why is there a drop command available for databases
if I can't do it from pgAdmin?
Larry
-----Original Message-----
From:
pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org]On Behalf Of Dave Page
Sent: Monday, July 22, 2002 2:06 PM
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] FW: Delete
PostgreSQL Database
-----Original Message-----
From: Larry Reagor
[mailto:lreagor(at)macomb(dot)com]
Sent: 22 July 2002 19:23
Cc: pgadmin-support-owner(at)postgresql(dot)org
Subject: Delete PostgreSQL Database
I attempt to delete (drop) a database
and get the following message.
I am the only user. What do I have to do
to delete an unwanted database?
Unfortunately you can't using pgAdmin
(see http://www.pgadmin.org/pgadmin2.php?ContentID=9) The best way is
to close pgAdmin and use psql on the server.
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2002-07-24 20:51:26 | Re: "Runtime Error 55 File Already Open" after clicking the Databases in the tree |
Previous Message | Serkan Bektaþ | 2002-07-24 20:43:17 | Re: "Runtime Error 55 File Already Open" after clicking the Databases in the tree |