I found out I can use CQL's IN clause to filter fids. So if I want fid 3, I can do 'IN (3)'. It is just a regular IN, but with no attribute name.
Thanks, Alex -----Original Message----- From: Rahkonen Jukka [mailto:jukka.rahko...@mmmtike.fi] Sent: Monday, March 28, 2011 3:45 PM To: alex_bar...@qat.com; geoserver-users@lists.sourceforge.net Subject: Re: [Geoserver-users] serial data type and geoserver Hi, Normally primary keys are consumed as fids and they are not published as normal attributes. It would not make sense to let people edit fids with WFS-T. A workaround is to create a view and select the primary key column twice to the view (or columns in case of combined primary key). -Jukka Rahkonen Alex Barros wrote: > I have several tables in Postgres/Postgis that have serial fields as primary keys. When I create layers in geoserver for those tables, none of the ids show up as feature types (all other fields from the tables show ok). I was trying to use CQL to filter by the id when I realized I don't have it in geoserver. I am using 2.1-RC3 > Is there a workaround for that? Is this behavior by design? > Thanks, Alex ---------------------------------------------------------------------------- -- Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users ------------------------------------------------------------------------------ Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
