Vlad Seryakov <[EMAIL PROTECTED]> writes:
> i just created new database and ran this script.
> First time the query ran okay, then i removed ps.quantity
> and re-created package_tree_view.
> After this the query crashed the server.
Hmm, I see: there's not a defense against references to
no-longer
Vlad Seryakov <[EMAIL PROTECTED]> writes:
> Is it possible to get core file, i couldn't find how to setup this.
A crashed backend should leave a core file in $PGDATA/base/YOURDB/core
If you don't see a core file in that directory, it's possible that
the postmaster was started with "ulimit -c 0"
[EMAIL PROTECTED] writes:
> Segmentation fault when changing view
I ran this script and didn't see any problem ...
In general though, whenever you drop/recreate a view you are going to
have to drop/recreate views that refer to it, too.
regards, tom lane
Vlad Seryakov ([EMAIL PROTECTED]) reports a bug with a severity of 1
The lower the number the more severe it is.
Short Description
Segmentation fault when changing view
Long Description
When i dropped column quantity in view package_tree_view, recreated this view, but
didn't recreated the view