Re: Kindly Please Help Me - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Kindly Please Help Me
Date
Msg-id CAHyXU0zQuwvWCk8VTYa+p2mQmMeoo5BsjXmdJ2UyzJPXOyBYyA@mail.gmail.com
Whole thread Raw
In response to Kindly Please Help Me  (saqib11@igis.nust.edu.pk)
List pgsql-general
On Tue, Dec 27, 2011 at 5:11 PM,  <saqib11@igis.nust.edu.pk> wrote:
> Hi every1 how are u all??? Members i am new in postgres and want to work on
> pgrouting but i am facing some issue will u please help me???
> I have loaded my line shapefile in pgadmin environment but when i made a
> query at it it will show that ur table (Route dont have relation)..wht is
> this???

you created the table with an upper case letter in the name ("Route").
 This means all queries that touch the table must also double case the
name because postgres folds all identifiers to lower case if you don't
do that.  Advise changing the table name from Route to route.

merlin

pgsql-general by date:

Previous
From: saqib11@igis.nust.edu.pk
Date:
Subject: Kindly Please Help Me
Next
From: Tom Lane
Date:
Subject: Re: Detecting uncommitted changes