Re: Kindly Please Help Me

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: saqib11(at)igis(dot)nust(dot)edu(dot)pk
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Kindly Please Help Me
Date: 2011-12-27 23:20:20
Message-ID: CAHyXU0zQuwvWCk8VTYa+p2mQmMeoo5BsjXmdJ2UyzJPXOyBYyA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Dec 27, 2011 at 5:11 PM, <saqib11(at)igis(dot)nust(dot)edu(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-12-28 00:41:54 Re: Detecting uncommitted changes
Previous Message saqib11 2011-12-27 23:11:46 Kindly Please Help Me