| From: | "Paul Laub" <plaub(at)incyte(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Modifying table ownership |
| Date: | 2001-12-03 23:58:04 |
| Message-ID: | 002a01c17c56$590c3b10$ec02520a@incyte.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dear all,
When altering table ownership with
ALTER TABLE table OWNER TO new owner
is there any way to have PostgreSQL 7.1.3 (the version I use) recursively
change
ownership of all indexes, triggers, and metadata related to or implicitly
created by
the renamed table? If not, then what is the solution? What I do now is (1) drop
indexes, (2) rename the table to table_old, (3) create a new table with desired
owner, (4) insert into table select * from table_old, and finally (5) drop
table table_old.
There has got to be an easier way.
Paul
Paul B. Laub http://astatine.incyte.com/laub (650) 845-5411 (voice)
Incyte Genomics, Inc. 3160 Porter Dr. Palo Alto, CA 94304 plaub(at)incyte(dot)com
*** Incite genomics! ***
| Attachment | Content-Type | Size |
|---|---|---|
| Paul B Laub.vcf | text/x-vcard | 205 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Brett | 2001-12-04 00:07:41 | Re: When do I Vacuum ? |
| Previous Message | ag20 | 2001-12-03 22:39:57 | DBD::ODBC and infinity timestamp |