Re: My troubles with test PostgreSQL 8.1

Kevin Rosenberg <kevin-HJRc7zDS/[email protected]> Thu, 10 Nov 2005 15:09:52 -0700
Newsgroups gmane.lisp.clsql.devel
Message-ID <[email protected]>
John DeSoi wrote:
> The parameters to dropdb is similar to all PostgreSQL command line  
> utilities:

Hi John,

Thanks for the postgresql tips. Connecting to stdin for
dropdb and pass the password to dropdb's prompt would be secure. But,
I doubt that'd be very portable across lisp implementation or
operating systems. At this point, I think the current behavior is
preferred to passing the SQL password on the command-line to dropdb.

> But as far back as I remember, PostgreSQL has had a DROP DATABASE  
> command so I'm not sure why you would use the shell command other  
> than perhaps you don't have to specify a database to connect to.

That's a good tip. I think DROP / CREATE DATABASE SQL statements
would be preferable to the current behavior. 

Thanks for the thoughts,

Kevin