Check constraint metadata

From: Roy Smith <roy(dot)smith(at)primetext(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Check constraint metadata
Date: 2008-01-05 07:59:45
Message-ID: 477F38F1.2090303@primetext.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi all

I've written an ant task which reverse engineers a postgresql database
into JPA Annotated Entity classes for Hibernate/TopLink etc. So far so good.

For my next trick I want to reverse engineer null/not null and check
constraints into Spring Validator classes so I can do validation in the
web tier (and potentially as downloaded JavaScript in the browser). The
reason I want to have validation based on check constraints is that the
database will potentially be updated from other legacy applications.

I can't see any custom extensions to extract check constraints - are
there any?

If I'm barking up the wrong tree, or if there is a better approach
please feel free.

many thankis
Roy

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2008-01-07 02:52:12 Re: Missing fields in getColumns() result
Previous Message Oliver Jowett 2008-01-04 10:30:22 Re: Timestamp problem