From: | mariateresa(dot)ll(at)bresciaonline(dot)it |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Uppercase initials in Win XP |
Date: | 2006-02-27 08:07:58 |
Message-ID: | 81971.1141027678137.JavaMail.tomcat4@mail.bresciaonline.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello everyone,
I'm a novice, so could be that this has been already debated; in case, link me to the correct thread.
I've created my first DB with PGadminIII locally on a XP SP1 box and I declared its name, and enclosed tablenames also, with Uppercase initials.
Any effort to populate my tables in pgsql failed, witn "relation ... inexistent" error, and creates a crash in View data of PGadminIII.
After some random checks, I resolved to force lowercase the tablenames and, voila' !, everything started to work smoothly.
Is it a known "feature", a bug or mine own stupidity ?
Regards, Fabio
BTW, what is the correct way to completely remove PG from the XP box, (DB and engine) ?
>From pgsql-novice-owner(at)postgresql(dot)org Mon Feb 27 04:14:25 2006
X-Original-To: pgsql-novice-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (av.hub.org [200.46.204.144])
by postgresql.org (Postfix) with ESMTP id 0A4359DC805
for <pgsql-novice-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Mon, 27 Feb 2006 04:14:25 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 75799-01
for <pgsql-novice-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Mon, 27 Feb 2006 04:14:25 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [151.155.5.143])
by postgresql.org (Postfix) with ESMTP id C33A49DCA28
for <pgsql-novice(at)postgresql(dot)org>; Mon, 27 Feb 2006 04:14:22 -0400 (AST)
Received: from [172.16.1.187] grzm [61.197.227.146]
by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 1.6 $ on Linux;
Mon, 27 Feb 2006 01:14:20 -0700
In-Reply-To: <81971(dot)1141027678137(dot)JavaMail(dot)tomcat4(at)mail(dot)bresciaonline(dot)it>
References: <81971(dot)1141027678137(dot)JavaMail(dot)tomcat4(at)mail(dot)bresciaonline(dot)it>
Mime-Version: 1.0 (Apple Message framework v746.2)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <5784177C-AEC9-43C3-AE04-B7CD08B9B6F0(at)myrealbox(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Content-Transfer-Encoding: 7bit
From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
Subject: Re: Uppercase initials in Win XP
Date: Mon, 27 Feb 2006 17:14:17 +0900
To: mariateresa(dot)ll(at)bresciaonline(dot)it
X-Mailer: Apple Mail (2.746.2)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=1.09 required=5 tests=[AWL=-0.242,
RCVD_IN_BL_SPAMCOP_NET=1.332]
X-Spam-Score: 1.09
X-Spam-Level: *
X-Archive-Number: 200602/250
X-Sequence-Number: 15928
On Feb 27, 2006, at 17:07 , mariateresa(dot)ll(at)bresciaonline(dot)it wrote:
> After some random checks, I resolved to force lowercase the
> tablenames and, voila' !, everything started to work smoothly.
>
> Is it a known "feature", a bug or mine own stupidity ?
It's a FAQ:
http://www.postgresql.org/docs/faqs.FAQ.html#item4.21
Michael Glaesemann
grzm myrealbox com
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Walmsley | 2006-02-27 13:42:48 | How do you backup functions only? |
Previous Message | Michael Fuhr | 2006-02-27 05:20:13 | Re: Regarding PL/SQL with C |