Yes I look at that, but based upon this posting:
http://stackoverflow.com/questions/16959764/reassign-owned-by-for-1-specified-database
which talks about this error being returnedhttp://stackoverflow.com/questions/16959764/reassign-owned-by-for-1-specified-database
ERROR: cannot reassign ownership of objects owned by role postgres because they are required by the database system
I thought it was dead end.
But thanks for the suggestion.
KD
On Thu, Feb 9, 2017 at 12:13 PM, Jorge Torralba <jorge.torralba@xxxxxxxxx> wrote:
REASSIGN OWNED BYOn Wed, Feb 8, 2017 at 6:33 PM, Kevin Duffy <kevind0718@xxxxxxxxx> wrote:KBDMany thanks for your attention to this matter.Is there a way I can shoot myself in the foot here.Is there an order I should do the changes in?Question: the database and schema ownership needs to be changed also?I have created the role: xxx-db-owner.I have a bunch of tables , functions and user defined types.Now I need to get this changed to a log-on role say xxx-db-owner.I created a database and did some amount of development as postgres.Hello all:I made a mistake. Maybe I was lazy.And most important I have db backups and have a copy of the db on the server under a different name.And I have written the sql to to the changes for the tables, functions and user defined types.
--Thanks,
Jorge Torralba
----------------------------
Note: This communication may contain privileged or other confidential information. If you are not the intended recipient, please do not print, copy, retransmit, disseminate or otherwise use the information. Please indicate to the sender that you have received this email in error and delete the copy you received. Thank You.
