Excerpts from David Fetter's message of mar may 31 21:42:08 -0400 2011: > A colleague brought up an interesting idea that I think is worth > exploring for all NOT VALID constraints, to wit, is there some way > (via SQL) to find which rows violate which constraints? I'm picturing > some kind of function that could be aggregated into some structure for > each violating row...
Seems like a job for a plpgsql function with a bunch of exception handlers ... Some details like the violated constraint name would be hard to extract, probably, though. -- Álvaro Herrera <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
