Thread: Refine Form of My querry

Refine Form of My querry

From
saqib11@igis.nust.edu.pk
Date:
Hi every1 how are u all??? Members i am new in postgres and want to
work on pgrouting but i am facing some issue with it. Will u please help me???
I have loaded my line shapefile in pgadmin environment, which creates
a table name 'Route', but when i made a query 'Create View' at it, it
will show an error that "Relation 'Route' doesn't exist". can any1
explains me what this error means?? and how can i remove this error??

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


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=1325171483&f=Route+Table+Error.docx



Re: Refine Form of My querry

From
John R Pierce
Date:
On 12/29/11 2:11 AM, saqib11@igis.nust.edu.pk wrote:
> I am sending my problems with attachment please have a look at this..

please don't send attachments to email lists.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


Re: Refine Form of My querry

From
Eduardo Morras
Date:
At 11:11 29/12/2011, you 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 with it. Will u please help me???
>I have loaded my line shapefile in pgadmin environment, which creates
>a table name 'Route', but when i made a query 'Create View' at it, it
>will show an error that "Relation 'Route' doesn't exist". can any1
>explains me what this error means?? and how can i remove this error??
>
>I am sending my problems with attachment please have a look at this..

You have to do 4 steps in the order i say:

1) Read the answer you get from Merlin Moncure.

2) Read the error message you get on page 2 of your attachment.

3) If you don't see why the error is happening, go to step 1.

4) Next time don't send attachments in .docx or any other
pay-per-view/pay-per-work format

>With best regards

No Problem ;)

>Saqib Kazmi

Re: Refine Form of My querry

From
David Salisbury
Date:

On 12/29/11 3:11 AM, 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 with it. Will u please help
> me???
> I have loaded my line shapefile in pgadmin environment, which creates a
> table name 'Route', but when i made a query 'Create View' at it, it will
> show an error that "Relation 'Route' doesn't exist". can any1 explains
> me what this error means?? and how can i remove this error??

I'm guessing you need double quotes around your table name.. e.g. "Routes"..
in your view definition as the table name may be case sensitive, in your case.

-ds

Re: Refine Form of My querry

From
Eduardo Morras
Date:
At 11:11 29/12/2011, you 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 with it. Will u please help me???
>I have loaded my line shapefile in pgadmin environment, which creates
>a table name 'Route', but when i made a query 'Create View' at it, it
>will show an error that "Relation 'Route' doesn't exist". can any1
>explains me what this error means?? and how can i remove this error??
>
>I am sending my problems with attachment please have a look at this..

You have to do 4 steps in the order i say:

1) Read the answer you get from Merlin Moncure.

2) Read the error message you get on page 2 of your attachment.

3) If you don't see why the error is happening, go to step 1.

4) Next time don't send attachments in .docx or any other
pay-per-view/pay-per-work format

>With best regards

No Problem ;)

>Saqib Kazmi