From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | Change owner of function in 7.2.4? |
Date: | 2003-06-02 22:49:33 |
Message-ID: | 200306021549.33228.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Folks,
I have a 7.2.4 database where I accidentally replaced a bunch of functions
while logged in as the superuser. Now the normal applicaiton user can't
modify them. While I can fix them by dropping the functions as the superuser
and re-creating them as the regular user, I can't see how to do this in a
transaction to avoid disrupting the database users.
Are there any dangers I don't know about in either of the options below?
1) updating "proowner" in pg_proc
2) making the regular user a superuser temporarily, replacing the functions,
and then switching them back.
Thoughts?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | David Pradier | 2003-06-04 14:59:02 | How to make a IN without a table... ? |
Previous Message | Samuel Tardieu | 2003-06-02 18:29:28 | Re: Maintaining a counter up-to-date |