Thread: Refine Form of My querry
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
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
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
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
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