Re: [BUGS] Segmentation fault when changing view

2001-04-16 Thread Tom Lane
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

Re: [BUGS] Segmentation fault when changing view

2001-04-16 Thread Tom Lane
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"

Re: [BUGS] Segmentation fault when changing view

2001-04-16 Thread Tom Lane
[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

[BUGS] Segmentation fault when changing view

2001-04-16 Thread pgsql-bugs
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