Hi,
In Postgres, all non-quoted identifiers are converted to lower-case, unless they
are quoted.
e.g. SELECT * FROM MY_DATA_0;
Error: my_date_0 does not exist
try SELECT * FROM "MY_DATA_0";
or probably better, in future, use lowercase names, e.g. SELECT * FROM my_data_0;
Rich.
-----Original Message-----
From: jdavis [mailto:[EMAIL PROTECTED]
Sent: 02 April 2003 02:11
To: perl
Subject: use Pg;
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?
--
jd
[EMAIL PROTECTED]
Bad spellers of the world untie!
"I can't tell if I have worked all my life or
if I have never worked a single day of my life"
Miguel de Icaza
**********************************************************************
The information contained in this email is confidential and is intended for the
recipient only. If you have received it in error, please notify us immediately by
reply email and then delete it from your system. Please do not copy it or use it for
any purposes, or disclose its contents to any other person or store or copy this
information in any medium. The views contained in this email are those of the author
and not necessarily those of Lorien plc.
Thank you for your co-operation.
**********************************************************************
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
