[gdal-dev] Postgresql driver ability to add constraints

Matthieu Rigal rigal at rapideye.de
Wed Nov 3 09:53:09 EDT 2010

Hi Frank,

This is actually what I am doing, so no problems here ;-)

It was rather a suggestion in case it was not discussed, because it may have 
been useful differently, but it is fine for me so.

Best Regards,

On Wednesday 03 November 2010 14:30:07 Frank Warmerdam wrote:
> On Wed, Nov 3, 2010 at 9:23 AM, Matthieu Rigal <rigal at rapideye.de> wrote:
> > Hi guys,
> > 
> > I was checking and I did not found a proper way for now to add a unique
> > or not null constraints to columns of a layer created/edited by OGR.
> > 
> > If I am wrong, please correct me.
> > Else, as I saw that a big refactoring of the PgSQL/PostGIS is
> > planned/done for the 1.8 version, this may be added, as it is quite
> > widely used properties...
> Matthieu,
> Why not add such constraints via ExecuteSQL() after creating the layer?
> I'm not keen on making constraints a first-class OGR data model concept
> for a variety of reasons.
> Best regards,

RapidEye AG
Molkenmarkt 30
14776 Brandenburg an der Havel
Follow us on Twitter! www.twitter.com/rapideye_ag
Head Office/Sitz der Gesellschaft: Brandenburg an der Havel
Management Board/Vorstand: Wolfgang G. Biedermann
Chairman of Supervisory Board/Vorsitzender des Aufsichtsrates: 
Juergen Breitkopf 
Commercial Register/Handelsregister Potsdam HRB 17 796
Tax Number/Steuernummer: 048/100/00053
VAT-Ident-Number/Ust.-ID: DE 199331235
DIN EN ISO 9001 certified
Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese
E-Mail irrtuemlich erhalten haben, informieren Sie bitte sofort den
Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie
die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.
The information in this e-mail is intended for the named recipients
only. It may contain privileged and confidential information. If you
have received this communication in error, any use, copying or
dissemination of its contents is strictly prohibited. Please erase all
copies of the message along with any included attachments and notify
RapidEye AG or the sender immediately by telephone at the number
indicated on this page.

More information about the gdal-dev mailing list