Re: Updating Geometry

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Updating Geometry
Дата
Msg-id 16795.1320961100@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Updating Geometry  (Asli Akarsakarya <asliakar@yahoo.com>)
Список pgsql-general
Asli Akarsakarya <asliakar@yahoo.com> writes:
> I am having trouble when attempting to update an existing geometry on a spatial table. The table stores 2D Point
geometry,with the SRID 101. The update statement i am trying to use to update the geometry with the id 110 is as
follows:

> UPDATE <Table Name> SET <Geometry Column Name> = GeometryFromText('POINT(44 31)', 101) WHERE <id Column>=110

> But I get an error that says the statement violates the "enforce_srid_position" restriction. Though the SRID's are
thesame. 

You'll probably have better luck asking about this on the postgis
mailing lists ...

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: PostgreSQL uninstall fails
Следующее
От: Ondrej Ivanič
Дата:
Сообщение: Re: Learning to rephrase equivalent queries?