Bill
|
| Posted: 12/25/2005, 6:40 PM |
|
Am building a PostgreSQL db, hosted on a remote server. Am able to connect to it via a remote GUI, phpPgAdmin, as well as with a local application called SQL Manager for PostgreSQL. I can create tables, fields etc.
But am having trouble with CodeCharge, 3.0.2.1.
It can connect, can see the table but cannot see any fields. Get error, Relation "table_name" does not exist.
Have done lots of reading re this and seems the the double-quotes around the table name might be an issue. The problem is that the table name does not have double quotes, seems that CodeCharge is reading it as having double quotes.
All help big-time appreciated
Thank you.
|
|
|
 |
mamboBROWN
Posts: 1713
|
| Posted: 12/25/2005, 8:29 PM |
|
Bill,
You might want to contact support and notify them about this possible issue.
http://support.yessoftware.com
|
 |
|
feha
Posts: 712
|
| Posted: 12/27/2005, 8:28 AM |
|
Bill do you have problem with "some" or all tables ?
Double quotes some time 'fieldname' example 'order' is reserved by system I see on MySQL (don't know PostgreSQL ), avoid using reserved names by DB if that is the case !?
_________________
Regards
feha
www.vision.to
feedpixel.com |
|
|
|
Bill
|
| Posted: 12/27/2005, 7:07 PM |
|
Hi Feha
It's a problem with all tables and the names are not reserved. Have sent a copy of the db and project files to Yes and they are taking a look.
|
|
|
|
Bill
|
| Posted: 12/31/2005, 6:03 AM |
|
Resolved by building new db. Not sure what problem was, but now workds
|
|
|
|
|
