[pgrouting-users] ERROR: relation with OID 156906 does not exist

[Anton Patrushev]

Hi Steve,

It should be enough just to exit PostreSQL console and enter again
(which means to start a new session). It is quite known issue with
temporary tables in PostgreSQL (see
http://www.postgresql.org/docs/faqs.FAQ.html#item4.19).

Anton.

On 9/18/08, Stephen Woodbridge <woodbri at swoodbridge.com> wrote:
> Hi all,
>
>  I have run into a really annoying issue. When I want to rebuild the
>  vertices_tmp table. I do something like:
>
>  drop index source_idx;
>  drop index target_idx;
>  update st set source=null, target=null;
>  delete from geometry_columns where f_table_name='vertices_tmp';
>  vacuum analyze;
>
>  select assign_vertex_id('st', 0.0000005, 'the_geom', 'gid');
>  create unique index vertices_tmp_id_idx on vertices_tmp using btree(id);
>  create index source_idx on st using btree(source);
>  create index target_idx on st using btree(target);
>  vacuum analyze;
>
>  But I get this error:
>
>  routing=# select assign_vertex_id('st', 0.0000005, 'the_geom', 'gid');
>  NOTICE:  CREATE TABLE will create implicit sequence
>  "vertices_tmp_id_seq" for serial column "vertices_tmp.id"
>  CONTEXT:  SQL statement "CREATE TABLE vertices_tmp (id serial)"
>  PL/pgSQL function "assign_vertex_id" line 21 at execute statement
>  ERROR:  relation with OID 156906 does not exist
>  CONTEXT:  SQL statement "SELECT id, the_geom FROM vertices_tmp WHERE
>  expand( $1 ,  $2 ) && the_geom and distance(the_geom,  $1 ) <  $2 "
>  PL/pgSQL function "point_to_id" line 7 at SQL statement
>  PL/pgSQL function "assign_vertex_id" line 61 at assignment
>
>  The only way I have found to clear this error and get things to run
>  again, is to reload function assign_vertex_id().
>
>  What is causing it? and how can I avoid it in the future?
>
>  Thanks,
>    -Steve
>  _______________________________________________
>  Pgrouting-users mailing list
>  Pgrouting-users at lists.postlbs.org
>  http://lists.postlbs.org/mailman/listinfo/pgrouting-users
>