Renaming a schema - Mailing list pgsql-general

From Jeffrey Melloy
Subject Renaming a schema
Date
Msg-id 40DB1C12.9010100@visualdistortion.org
Whole thread Raw
Responses Re: Renaming a schema  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Recently, I decided to rename one of my schemas from "adium" to "im".

Then, all inserts started failing.

I recreated a couple functions, changed the search path, and all inserts
are still failing due to referential integrity checks going against
"adium" still.  Is there any way I can fix this, short of manually
dropping every constraint and recreating them?

Jeff

pgsql-general by date:

Previous
From: Jeff Boes
Date:
Subject: Ranking values within a query (pseudo-ROWNUM)
Next
From: Dennis Gearon
Date:
Subject: hackers dudes