Re: Rename constraint?

Поиск
Список
Период
Сортировка
Искать

Re: Rename constraint?

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Jeff Boes  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

Rename constraint?

От:
Jeff Boes <jboes@nexcerpt.com>
Дата:
I have tables which were created with unnamed constraints:

# \d 
...

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
FAQ