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) ?
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

On Feb 27, 2006, at 17:07 , mariateresa.ll@bresciaonline.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




---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

> BTW, what is the correct way to completely remove PG
> from the XP box, (DB and engine) ?

you should find those intstructions in the postgresql
PDF file here:

http://www.geocities.com/operationsengineer1/


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly