Synopsis: Query failed: ERROR: nodewords_mtid_seq dos not exists in /mnt/data/www/testsrv.metalica.org.ua/includes/database.pgsql.inc on line 139.
PostgreSQL Layer have an a function to obtain last_insert_id -- "select currval(".$table_name."_".$pkey_name."_seq)".
In update 6113 table nodewords_tmp is created with pkey mtid. This create pkey sequence nodewords_tmp_mtid_seq. When table renames to `nodewords' , primary key sequence stay nodewords_tmp_mtid_seq.

PS.
Sorry for my terrible english....

Comments

suvisor’s picture

suvisor commented
Title: Update filed from 6100 in nodewords_update_6113() under PGSQL » Update failed from 6100 in nodewords_update_6113() under PGSQL
avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Title: Update failed from 6100 in nodewords_update_6113() under PGSQL » Updating from 6100 to 6113 fails under PostgreSQL
avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Version: 6.x-1.3-beta5 » 6.x-1.x-dev
Component: Database schema » Code
Status: Active » Fixed

The code has been changed, and committed to CVS.

Thanks for the report.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

liam morland’s picture

liam morland
Primary language English
Location Ontario, CA 🇨🇦
commented
Issue tags: +PostgreSQL