Re: Postgresql 12 Beta2 Crashes for any Insert/Update

2019-06-30 Thread Mohsen Bande
After Investigating deeper, I found the root cause. Actually, the problem exists in certain tables, which i have created a trigger on them calling a function from a custom dynamic extension. the extension needs to rebuild (make && make install) against new PG development header files. On Sun, Jun

Re: Postgresql 12 Beta2 Crashes for any Insert/Update

2019-06-30 Thread Mohsen Bande
I've created a new database, and started to copy current data into it. it seems to work. it seems that the problem relates to upgrade process of database catalogs from Beta1 to Beta2. if the problem persists, it will investigate the stacktrace. Thanks On Thu, Jun 27, 2019 at 9:40 PM Peter Geoghega

Re: Postgresql 12 Beta2 Crashes for any Insert/Update

2019-06-27 Thread Peter Geoghegan
On Thu, Jun 27, 2019 at 1:28 AM Mohsen Bande wrote: > i have a working database in PG 12 Beta 1. today i upgraded it to Beta 2. > everything goes fine and server is up and running. but trying to > INSERT/UPDATE anything, server crashes: Is it possible for you to send us a stacktrace? https://w

Postgresql 12 Beta2 Crashes for any Insert/Update

2019-06-27 Thread Mohsen Bande
i have a working database in PG 12 Beta 1. today i upgraded it to Beta 2. everything goes fine and server is up and running. but trying to INSERT/UPDATE anything, server crashes: =# select id from user where id=0; id 0(1 row)=# UPDATE user SET is_deleted = true WHERE id = 0; psql: server c