jdavis wrote:
> Hello,
> I created 25 postgres databases by hand. Each with one small table.
> All the databases are named like so...
>
> MY_DATA_0
> MT_DATA_1 etc..
>
> When i use this code....
>
> use Pg;
> $conn = Pg::connectdb("dbname=MY_DATA_0");
> if ($conn->status != PGRES_CONNECTION_OK){
> $errorMessage = $conn->errorMessage;
> print " $errorMessage\n";
> }
>
> I see by looking at the error message that
> MY_DATA_0 is being sent as my_data_0 , and therfor
> not finding the database it needs to connect to.
> Is there a way I can keep the uppercase. Or do
> I need to drop all my DBs and recreate with lowercase
> names?
or it could just mean you would be better off using DBI. Using a DB-specific module
is likely to limit the portability of your code. DBI is likely to be better
maintained, also, as its popularity justifies the investment.of energy required.
Joseph
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
