Skip site navigation (1) Skip section navigation (2)

Re: FW: Delete PostgreSQL Database

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: FW: Delete PostgreSQL Database
Date: 2002-07-25 07:06:12
Message-ID: D85C66DA59BA044EB96AB9683819CF6101514D@dogbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
If you leave your identifiers as they are (i.e. mixed case, unquoted)
then use your existing mixed case names in Access, and lower case names
in PostgreSQL, everything should be OK.
 
Regards, Dave.

	-----Original Message-----
	From: Larry Reagor [mailto:lreagor(at)macomb(dot)com] 
	Sent: 25 July 2002 07:37
	To: Dave Page
	Subject: RE: [pgadmin-support] FW: Delete PostgreSQL Database
	
	
	Wow.
	Ok, since I started on this particular project using an Access
database for the backend with the idea now of migrating to PostgreSQL,
if I change my syntax as you suggest for mixed case, will the Access db
choke on it? If I were to switch to SQL Server or Oracle, etc after
changing the syntax, would they accept the quoted syntax?
	Thanks.
	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: Wednesday, July 24, 2002 3:47 PM
		To: pgadmin-support(at)postgresql(dot)org
		Subject: FW: [pgadmin-support] FW: Delete PostgreSQL
Database
		
		
		[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.

pgadmin-support by date

Next:From: Dave PageDate: 2002-07-25 09:14:16
Subject: Re: "Runtime Error 55 File Already Open" after clicking the Databases in the tree
Previous:From: LitelWangDate: 2002-07-25 04:49:42
Subject: when can I find template1 in pgadmin II?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group