Thread: Rename constraint?

Rename constraint?

From
Jeff Boes
Date:
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

Re: Rename constraint?

From
Tom Lane
Date:
Jeff Boes <jboes@nexcerpt.com> writes:
> I have tables which were created with unnamed constraints:
> How can I identify and rename the "$2" and "$3" constraints?

Look in pg_relcheck or pg_constraint, depending on your PG version.
I think you should be able to get away with just updating the name
column.  (Not sure whether existing backend sessions will notice such
an update, but at worst starting a fresh session would make it take
effect.)

            regards, tom lane