Postgres Pro
Downloads
Home   >   mailing lists

Rename constraint? - Mailing list pgsql-admin

From Jeff Boes
Subject Rename constraint?
Date
Msg-id 25bfef68697eea9481a313c943621a72@TeraNews
Whole thread Raw
Responses Re: Rename constraint?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
I have tables which were created with unnamed constraints:

# \d <table>
...

Check constraints: "bad_job_time" fn_validate_cron(job_time)
                   "$3" (arguments <> ''::text)
                   "$2" (job_time <> ''::text)
                   "periodic_jobs_job_length_bad" (job_length > 0)

How can I identify and rename the "$2" and "$3" constraints?

--
Jeff Boes                                      vox 269.226.9550 ext 24
Database Engineer                                     fax 269.349.9076
Nexcerpt, Inc.                                 http://www.nexcerpt.com
           ...Nexcerpt... Extend your Expertise

pgsql-admin by date:

Previous
From: "Mario Alberto Soto Cordones"
Date:
Subject: MAX CONNECTIONS PROBLEM
Next
From: "dlangschied"
Date:
Subject: Creating schema for multiple tables/fields/indices.