You probably used CAPITALS - I also had this problem - it's not a bug, it's
a feature ;)
I would appreciate PgAdmin using the non-quoted mode for creating objects -
or at least be user configurable, because this non SQL conformant feature
confuses many users (I think).
Best regards,
Maxx
-----Ursprüngliche Nachricht-----
Von: pgadmin-support-owner@postgresql.org
[mailto:pgadmin-support-owner@postgresql.org]Im Auftrag von ROUWEZ
Stephane
Gesendet: Donnerstag, 25. Juli 2002 13:42
An: 'pgadmin-support@postgresql.org'
Cc: LESNE Philippe
Betreff: [pgadmin-support] Problem with pgadmin II and psql
Hi,
First I create a database in psql, not in PgAdmin.
After, when I create a table in PgAdmin it's not accessible in psql but if I
create it in psql, it works, it's accessible in PgAdmin but not modifiable
(I can't change the column name or drop the column).
When I create a table or a column with PGAdmin, I must always use the quoted
delimiters to access it the table and the columns.
I don't find an option who can be changed to say to PgAdmin that it don't
use the double-quote.
Does anybody have an idea ?
Stef
------------------------------
http://www.ecolo.be
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org