On Wednesday, September 30, 2015 at 1:43:46 PM UTC-6, Michael Bayer wrote:
>
> there's no known bugs in fetching unique constraints.  PG 8.4 is a pretty 
> old version but should be working.
>
> note that a unique index and a unique constraint aren't listed as the same 
> thing, however.    you might just have unique indexes.
>

This was quite informative! 

Just one last item:  I'm having trouble getting at the Check Constraints...

You advised:

 there's no listing of CHECK constraints right now.

they are also available on the Table as fully constructed constraint 
objects:

table = Table('mytable', somemetadata, autoload=True)
for constraint in table.constraints:
    #   ...

I am assuming when you said "they are also available" that the "they" was 
referring
to Foreign, and primary key constraints, etc, and that 
CHECK constraints were not available at all, neither by reflection nor 
inspection.
Am I correct?

murf


-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Reply via email to