From: | "Valter" <pgsql(at)intersic(dot)com(dot)br> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Relation "xxxxx" does not exist - more info |
Date: | 2004-03-17 18:12:03 |
Message-ID: | 003701c40c4b$5942b140$01ff020a@intersic.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
What I didn't perceived before is DTS and pgAdmin create tables using quoted names like:
CREATE TABLE "XYZ" ....
while I create tables using non-quoted names like CREATE TABLE ABC.
It happens that altough invisible to \dt am I unable to use these tables either in psql or DTS.
In sum, DTS creates the table but doesn't transfer data.
Is quoted names a matter of postgre config?
Thanks,
Valter
----- Original Message -----
From: Valter
To: pgsql-general(at)postgresql(dot)org
Sent: Wednesday, March 17, 2004 2:52 PM
Subject: [GENERAL] Relation "xxxxx" does not exist
When I create tables thru DTS (mssqlserver) or pgAdmin, I get the following message when I try select/insert row from/into this tables:
Relation "table-name" does not exist
Command \dt lists all the tables, but \dt PATTERN doesn't.
Could it be charset/sort order or something like that?
All client softwares but pgsql are running on windows2k
Valter
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-03-17 18:38:08 | Re: Data Corruption in case of abrupt failure |
Previous Message | Richard Huxton | 2004-03-17 18:09:08 | Re: Check constraint |