I've used PostgreSQL for pretty much any project I've required an RDBMS in
for the past 4+ years now ... VIEWs haven't figured very prominently in
that, but I can't really say that I've noticed any major problems with
unexpected crashes in the past 2 years or so ...
In the below, the user was doing a VIEW of a VIEW (jcombo_query is a
VIEW) ... I tried what he was thinking of myself, on my machine, but
withoutu the VIEW of a VIEW, and it didn't cause any lockups on my machine
...
the problem with what is below is that he doesn't explain hat "go away
permanently" means ... did the query just never end? did the postmaster
crash and he couldn't restart it? etc, etc ...
On Fri, 8 Sep 2000, Tony Bazeley wrote:
> Hi all,
>
> I've just subscribed to the list this morning, as we are considering
> installing Postgres for a particular project.
>
> I guess I'm a little apprehensive, as perhaps coincidentally, this is the
> second reference to unexpected crashes that I have heard in as many days .
>
> Does this occur often?
>
> Cheers
> Tony Bazeley
>
> >As my own side note, on Postgres 7.0.2, I at one point tried creating
> >a view which said
> >CREATE VIEW silver_view AS
> >SELECT * from jcombo_query WHERE metal_uid = 1 ;
> >and so on for elec, gold, plat. And then used these to simplify the
> >main query. This caused Postgres to go away permanently, and I had
> >to manually delete the database.
>
>
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
