[fdo-users] PostGIS and Map 3D 2010 autoincrement problems

Thu Jul 16 09:40:53 EDT 2009

Hi Astrid,

Bruno Scott has been working recently on the PostGIS provider and has fixed some problems with using it with Map 2010. Bruno, have you hit this problem with autoincrement columns? If you view your table in the Map Schema Editor, does it show the gid column as both auto-generated and read-only?

Thanks,
Orest.

-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Astrid Emde
Sent: Thursday, July 16, 2009 9:31 AM
To: FDO Users Mail List
Cc: GBERGRATH-EBW at wesseling.de
Subject: RE: [fdo-users] PostGIS and Map 3D 2010 autoincrement problems

Hello list,

I have the same problem like Mike and Dave.

My wish would be to use AutoCAD Map 3D without the use of TRIGGER which
controls my gid.

Is there a discussion about this in the FDO team or the AutoCAD team
already going on?

David:
It would be nice if you could send me more information about your TRIGGER
solution.

best regards astrid

On Tue, June 23, 2009 11:37 pm, David Anderson wrote:
> Mike:
>
> I finally figured out a workaround.  In a nutshell:
>
> 	Create TRIGGER and FUNCTION to set NEW.gid to
> nextval('some_sequence'::regclass)
> 	TRIGGER should be on BEFORE INSERT event.
> 	Default value of the gid column should be set to 1 (it will be
> changed by the TRIGGER).
>
> If you would like more detailed steps, including the SQL statements, let
> me know.
> Map 3D adds the features appropriately by sending a 1 as the gid.  The
> data table will still show a 1 until the layer is refreshed.
> I don't know if this is an FDO issue or an AutoCAD issue.  Any comments
> from some more knowledgeable users would be appreciated.
>
> Thanks,
>
> David
>
> -----Original Message-----
> From: fdo-users-bounces at lists.osgeo.org
> [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Mike Toews
> Sent: Monday, June 22, 2009 5:53 PM
> To: FDO Users Mail List
> Subject: Re: [fdo-users] PostGIS and Map 3D 2010 autoincrement problems
>
> David,
>
> Yikes. I've been demoing Map3D 2010 for the past few weeks to see if we
> want to upgrade from 2008, and I can reproduce the same behavior you
> describe in 2010. This behavior is new to me, since it is not an issue
> with 2008 (the serial appears as 0 in the table, as you described, until
>
> it is checked-in and refreshed).
>
> To add details, the error response from 2010 when trying to check-in a
> new feature:
>
> <Error code="200" type="5" dispensation="3" sId="2"
> occurrence="1">Feature was not saved in the target feature
> source.<Parameters>
> <Parameter classId="0" position="0">
> <Message>2=Invalid property value name 'gid'.
> </Message>
> <SQL></SQL>
> </Parameter>
> <Parameter classId="0" position="0">
> <Message>1=Failed to execute Fdo command.
> </Message>
> <SQL></SQL>
> </Parameter>
> <Parameter classId="0" position="0">
> <Message>Failed to insert feature.</Message>
> <SQL></SQL>
> </Parameter>
> <Parameter classId="0" position="0">
> <Message>FdoPostGIS:mytable (), Rev# &lt;0&gt;</Message>
> <SQL></SQL>
> </Parameter></Parameters>
> <Entry code="1" type="15" sId="3" occurrence="1">Failed to save some
> features.</Entry>
> <Entry code="1" type="15" sId="4" occurrence="1">Failed to save edit
> set.</Entry>
> </Error>
>
> In QGIS and other programs, the default value for a serial (integer)
> that is shown in the property before insert/commit is
> "nextval('mytable_gid_seq'::regclass)", which might explain the error
> message "Invalid property value name 'gid'", since it appears as a
> string, not an integer in this form.
>
> I tried fixing this with some trigger functions within the database, but
>
> whatever I've tried I can't seem to make a workaround. The best I can do
>
> is raise some exception in a before trigger, which shows up in the error
>
> message in AutoCAD, but making a trigger that sets "NEW.gid :=
> nextval('mytable_gid_seq'::regclass);" still throws the error shown
> above.
>
> Is this an issue with FDO or with AutoCAD Map3D 2010?
>
> -Mike
>
> David Anderson wrote:
>>
>> I have been trying to setup Map 3D 2010 to access a PostGIS database
>> that has a feature set to auto increment the primary key. When trying
>> to create a new feature, Map 3D complains about the gid being invalid
>> because it tries to add it as 0. Map 3D won't let me change the value
>> because it is controlling it. If I check in the feature, close the
>> drawing, reopen the drawing Map 3D shows the feature even though it
>> was saying it couldn't be added. I have tried with various
>> combinations of PostgreSQL 8.2 & 8.3 and PostGIS 1.3.4-1.3.6 with the
>> same results.
>>
>> Is anybody successfully using Map 3D with the auto increment setting?
>> Does this only work with a certain data type? Any help would be
>> greatly appreciated.
>>
>> QGIS and uDig both access the database properly and can add features
>> so the database is working in that respect.
>>
>> Thanks,
>>
>> David
>>
>>
> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> fdo-users mailing list
>> fdo-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/fdo-users
>>
>
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>

Mit freundlichen Grüßen

Astrid Emde
----------------------------------

Aufwind durch Wissen!

Qualifizierte OpenSource-Schulungen
bei der www.foss-academy.eu

----------------------------------

 Astrid Emde
 WhereGroup GmbH & Co.KG
 Siemensstraße 8
 53121 Bonn
 Germany

 Fon: +49(0)228 90 90 38 - 19
 Fax: +49(0)228 90 90 38 - 11

 astrid.emde at wheregroup.com
 www.wheregroup.com

 Amtsgericht Bonn, HRA 6788
 -------------------------------
 Komplementärin:
 WhereGroup Verwaltungs GmbH
 vertreten durch:
 Arnulf Christl, Olaf Knopp, Peter Stamm
 ---------------------------------------

_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users