Revision 14228
Added by Aaron Marcuse-Kubitza over 10 years ago
| util.sql | ||
|---|---|---|
| 6062 | 6062 |
ROW(ROW(s.table_, (s.name)::text), s.def)::check_constraint_def AS constraint_ |
| 6063 | 6063 |
FROM ( SELECT (pg_constraint.conrelid)::regclass AS table_, |
| 6064 | 6064 |
pg_constraint.conname AS name, |
| 6065 |
pg_get_expr(pg_constraint.conbin, pg_constraint.conrelid, true) AS def
|
|
| 6065 |
pg_constraint.consrc AS def
|
|
| 6066 | 6066 |
FROM pg_constraint |
| 6067 | 6067 |
WHERE (pg_constraint.contype = 'c'::"char")) s; |
| 6068 | 6068 |
|
| ... | ... | |
| 6072 | 6072 |
-- |
| 6073 | 6073 |
|
| 6074 | 6074 |
COMMENT ON VIEW check_constraint IS ' |
| 6075 |
pg_get_expr(): pg_get_expr(__, /*pretty-print, to avoid extra () :*/true) |
|
| 6075 |
consrc: *don''t* use `pg_get_expr(conbin, conrelid, /*pretty-print:*/true)`, |
|
| 6076 |
because this format does not match util.canon_sql() |
|
| 6076 | 6077 |
'; |
| 6077 | 6078 |
|
| 6078 | 6079 |
|
Also available in: Unified diff
fix: schemas/util.sql: check_constraint view: don't use pretty-print mode, because this format does not match util.canon_sql()