It also doesn't matter whether I have MDAC version 2.5 OR 2.6 installed.
Calvin
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
I've run across a consistent problem with M$oft Access, psqlodbc.dll,
and Postgres.
If I try to do an insert query from an Access table to a Postgres table,
Access 97 crashes IF that insert includes any memo fields (appending to
a varchar field, in my case). Access 2000 doesn't crash, but it does
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
