pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedChange definition of a view
2+ messages / 2 participants
[nested] [flat]
* Change definition of a view
@ 2006-02-09 17:11 Andreas Roth <aroth@arsoft-online.com>
2006-02-09 18:09 ` Re: Change definition of a view Keith Worthington <keithw@narrowpathinc.com>
0 siblings, 1 reply; 2+ messages in thread
From: Andreas Roth @ 2006-02-09 17:11 UTC (permalink / raw)
To: pgsql-sql
Hello,
one question: Is it possible to add or remove a column from a view without
drop the view and recreate it?
If one or more rules depend on a view, it's very hard to extend a view.
I use the following procedure to extend a view:
- drop depending rules
- drop view
- recreate view with additional column
- recreate all rules
Any help is welcomed!
Thanks,
Andreas Roth
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Change definition of a view
2006-02-09 17:11 Change definition of a view Andreas Roth <aroth@arsoft-online.com>
@ 2006-02-09 18:09 ` Keith Worthington <keithw@narrowpathinc.com>
0 siblings, 0 replies; 2+ messages in thread
From: Keith Worthington @ 2006-02-09 18:09 UTC (permalink / raw)
To: Andreas Roth <aroth@arsoft-online.com>; pgsql-sql
On Thu, 9 Feb 2006 18:11:24 +0100, Andreas Roth wrote
> Hello,
>
> one question: Is it possible to add or remove a column from a view
> without drop the view and recreate it?
>
> If one or more rules depend on a view, it's very hard to extend a
> view. I use the following procedure to extend a view: - drop depending
> rules - drop view - recreate view with additional column - recreate
> all rules
>
> Any help is welcomed!
>
> Thanks,
> Andreas Roth
Andreas,
I believe that is exactly what you have to do.
Kind Regards,
Keith
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-02-09 18:09 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-09 17:11 Change definition of a view Andreas Roth <aroth@arsoft-online.com>
2006-02-09 18:09 ` Keith Worthington <keithw@narrowpathinc.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox