Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009
    Posts
    1

    Unanswered: Alter column size issue..

    Hi All,

    I am new to postgresql. I am using PostgrePlus Advanced server 8.3 version.
    I found an issue with alter column size.
    I want to alter a table's column size and that column has been used in a view.
    So it is throwing an exception. How can we alter this column size??
    Drop view.. alter column.. create view?? Is there any other way to do this??
    Please help me guys.

    Thanks in advance.

  2. #2
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    Drop view.. alter column.. create view?? Is there any other way to do this??
    Nope. That's what you've got to do.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •