Ok so I still am having issues with it creating random entries as my primary
key even after creating a new metadata table and referencing that in my
GeoServer store. Here is what I did:
Created gt_pk_metadata_table using the script on the website you linked:
CREATE TABLE gt_pk_metadata_table (
table_schema VARCHAR(32) NOT NULL,
table_name VARCHAR(32) NOT NULL,
pk_column VARCHAR(32) NOT NULL,
pk_column_idx INTEGER,
pk_policy VARCHAR(32),
pk_sequence VARCHAR(64),
unique (table_schema, table_name, pk_column),
check (pk_policy in ('sequence', 'assigned', 'autoincrement'))
)
I then inserted a row inside that table as follows:
INSERT INTO gt_pk_metadata_table (table_schema, table_name, pk_column,
pk_column_idx, pk_policy)
values
('WSM',
'points',
'uid',
null,
'assigned')
My Database is called WSM, the table I want to add is points, and the
primary key in points is called uid. I will not need pk_column_idx since the
primary key is only one column. Also, since I am using assigned as my
pk_policy, I will not need pk_sequence, right? Am I correct on those two
assumptions?
I then went back to where I loaded my PostGIS store on GeoServer and added
the metadata table as gt_pk_metadata_table. Then trying another WFS-T insert
statement (using the GML from my first post), I still get the randomly
generated primary key.
Still a little confused, any help would be greatly appreciated. Thanks
--
View this message in context:
http://osgeo-org.1803224.n2.nabble.com/PostGIS-WFS-T-Insert-Primary-Key-is-being-stored-as-hex-value-tp7040973p7044728.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
