On Friday 25 July 2003 02:37 am, Thomas Kellerer wrote:
> Terence Chang schrieb:
> > I am still getting the error. would this matter with 7.3.3 on windows
> > with cygwin?
>
> From my experience I'd never user quotes at any place (neither during
> creation of the table nor in the SELECT, UPDATE statements). All DBMS I
> know behave like Postgres. So if you never quote your object names, then
> you won't have problems.
FWIW:
I ran into this problem before. I used to develop using Oracle, where column
name fold to UPPER case. So in my habits, I created table using pgaccess and
type them in UPPER case for both column name and table name
Then I could not access from psql. After banging my head to the wall for
couple days, I then realize I have to use the double quotes. So somehow
pgaccess write the create table statements using doble quotes.
RDB
--
Reuben D. Budiardja
Department of Physics and Astronomy
The University of Tennessee, Knoxville, TN
-------------------------------------------------
/"\ ASCII Ribbon Campaign against HTML
\ / email and proprietary format
X attachments.
/ \
-------------------------------------------------
Have you been used by Microsoft today?
Choose your life. Choose freedom.
Choose LINUX.
-------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
