is there a 'replace' for tables/views?
От | Michael Enke |
---|---|
Тема | is there a 'replace' for tables/views? |
Дата | |
Msg-id | 4CA2042E.8060703@wincor-nixdorf.com обсуждение исходный текст |
Список | pgsql-general |
Hello group, is there a functionality like 'create or REPLACE table/view' to circumvent drop with 'cascade' and recreation of depending objects? I have a table schema1.x (col1, col2) and a view schema1.v -> schema1.x(col1) Another table is schema2.x(col1, col2) with same structure as x in schema1. I have to drop the table schema1.x and create a view with same name: schema1.x (view) -> schema2.x (table) The drop will work only with "cascade", and after creation of view schema1.x I have to recreate the view schema1.v -> schema1.x(col1) If there is no way today, would it be a good idea for a future release? ;-) Michael WINCOR NIXDORF International GmbH Sitz der Gesellschaft: Paderborn Registergericht Paderborn HRB 3507 Geschäftsführer: Eckard Heidloff (Vorsitzender), Stefan Auerbach, Dr. Jürgen Wunram Vorsitzender des Aufsichtsrats: Karl-Heinz Stiller Steuernummer: 339/5884/0020 - Ust-ID Nr.: DE812927716 - WEEE-Reg.-Nr. DE44477193 Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet. This e-mail may contain confidential information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
В списке pgsql-general по дате отправления: