On 17 Apr 2012, at 14:45, Moh Ilhami wrote:
> Saya mau menambah lebar column di postgresql, misal dari varchar(20)
> menjadi varchar(30), atau numeric(2,0) menjadi numeric(5,0).
> Perintah yang saya gunakan adalah:
>
> alter table customer_order alter column total_order type numeric(5,0);
>
> Tapi selalu muncul pesan:
> ERROR: cannot alter type of a column used by a view or rule
> DETAIL: rule _RETURN on view v_customer_order depends on column "total_order"
>
> Apa ada cara lain alter table column, tanpa harus drop view dan re-create
> view ?
View semestinya di drop dan di recreate secara otomatis setelah
expired, supaya isi viewnya mengikuti data real.
Drop saja viewnya, alter table, lalu create ulang viewnya.
--
Donny Kurnia
Apple ID: donnykur...@gmail.com
Twitter: @donnykurnia
Skype: donnykurnia
My online profile:
http://www.linkedin.com/in/donnykurnia
http://careers.stackoverflow.com/donnykurnia
http://re.vu/donnykurnia
http://hantulab.blogspot.com
---
At times the world can seem an unfriendly and sinister place. But
believe us when we say there is much more good in it than bad. And
what might seem to be a series of unfortunate events, may in fact, be
the first steps of a journey.
-- A Series of Unfortunate Events
--
FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab
Unsubscribe: kirim email ke tanya-jawab-unsubscr...@linux.or.id
Arsip dan info milis selengkapnya di http://linux.or.id/milis
