From: | Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | REASSIGN OWNED doesn't for all objects, ALTER FUNCTION seems to fix it |
Date: | 2011-04-18 14:37:16 |
Message-ID: | 201104181637.17605.ftm.van.vugt@foxi.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
L.S.
# select version();
version
---------------------------------------------------------------------------------------
PostgreSQL 8.4.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
4.4.4, 64-bit
(1 row)
In a production database we experienced the following:
* the database contains a number of tables and functions owned by user A
* one is logged in as postgres
* upon issuing 'REASSIGN OWNED BY A TO postgres', all tables and _most_
functions changed ownership, but not all.... a number of functions stay marked
as owned by A, nothing weird in the logs, the reassign looked like it
completed successfully
* there doesn't seem to be anything 'special' about the functions that did not
change ownership
* changing ownership for one of these functions by using 'alter function'
succeeds without any problem
Mind you, we tested the reassign in a trial database first, a freshly restored
dump, and there the reassign worked properly / completely.
Any hints as to what could cause this? We left the production db as-is, so we
still have a number of these functions 'still owned by A' for which we could
check things in pg_* tables or something.
--
Best,
Frank.
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GÜNDÜZ | 2011-04-18 14:43:31 | Re: stymied on postgresql upgrade |
Previous Message | Phoenix Kiula | 2011-04-18 14:23:47 | Re: Help - corruption issue? |