Ynt: [GENERAL] How to drop user if objects depend on it

2015-10-07 Thread Neslisah Demirci
Hi , REASSIGN OWNED -- change the ownership of database objects owned by a database role. REASSIGN OWNED BY old_role [, ...] TO new_role You can create a new role then you just assign database objects depend on old role. REASSIGN owned by old_role to new_role; Then DROP old_role; Is this

[GENERAL] postgresql : could not serialize access due to read/write dependencies among transactions

2017-01-17 Thread Neslisah Demirci
Hi , I have problem about this issue ; could not serialize access due to read/write dependencies among transactions A message app like whatsapp i decided to use isolation level serializable if i use other transaction levels many conversations started with same number (think about whatsapp

Ynt:[GENERAL] postgresql : could not serialize access due to read/write dependencies among transactions

2017-01-17 Thread Neslisah Demirci
Gönderen: Neslisah Demirci Gönderildi: 18 Ocak 2017 Çarşamba 08:36 Kime: John R Pierce Konu: Ynt: [GENERAL] postgresql : could not serialize access due to read/write dependencies among transactions We use ORM sequelize.js . My transactions are here ; First I

Ynt: [GENERAL] column "waiting" does not exist

2017-03-02 Thread Neslisah Demirci
Hi , Your monitoring program is trying to use pg_stat_activity's old version. In 9.6 pg_stat_activity has new columns named wait_event , wait_event_type . Which monitoring programme? Neslişah Demirci | Veritabanı Yöneticisi Ayazağa cad. No:4 Uniq İstanbul Plaza B2 /Kat:3 34396 Ayazağa-SARIY