Opened 17 years ago

Closed 17 years ago

Last modified 15 years ago

#837 closed defect (fixed)

Saving edited PostGIS layer reports PostgreSQL error

Reported by: horst.duester Owned by: nobody
Priority: major: does not work as expected Milestone:
Component: Vectors Version: Trunk
Keywords: PostGIS Cc:
Must Fix for Release: No Platform: Debian
Platform Version: Awaiting user input: no


Take a look at the attached SQL Script. This script creates 2 Tables test and test2.

  1. Edit Table test and add a polygon.
  2. When you save this table PostgrSQL reports the error: ERROR: invalid input syntax for integer: "now()"

When you try the same procedure with test2 PostgreSQL is able to save the created polygon.

The problem seems to be the order of the geometry column. In test the geometry column is the second column of the table. All later tables seemed to be shifted.Take a look at the warning displayed in the terminal window.

In table test2 the geometry column is the last column of the table and it doesn't influence the order of the columns. => Save works fine.

Attachments (1)

layer_test.sql (443 bytes ) - added by horst.duester 17 years ago.

Download all attachments as: .zip

Change History (5)

by horst.duester, 17 years ago

Attachment: layer_test.sql added

comment:1 by horst.duester, 17 years ago

I made a typo in my ticket:

I wrote: ... All later tables seemed to be shifted ...

Of course I ment ... All later columns seemed to be shifted.

comment:2 by jef, 17 years ago

Resolution: fixed
Status: newclosed

fixed in r7659

in reply to:  2 comment:3 by horst.duester, 17 years ago

Replying to jef:

fixed in r7659

Thank you very very much for your fast response!!!!

comment:4 by (none), 15 years ago

Milestone: Version 0.9.1

Milestone Version 0.9.1 deleted

Note: See TracTickets for help on using tickets.