Обсуждение: Kindly Please Help Me

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???


I am sending my problems with attachment please have a look at them..


With best regards

Saqib Kazmi

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.


-----
Attachments (Links will expire on 07/01/12)
http://webmail.igis.nust.edu.pk/imp/attachment.php?u=saqib11%40igis.nust.edu.pk&t=1325045506&f=Route+Table+Error.docx

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