Postgresql Lastinserted ID issue

Wappler General Bugs
#1

Hi @George ,
The Database Insert Server Action is not returning anymore the ID of the inserted element although the output flag is selected and the entry is inserted correctly in the database .

result

My Temp Solution :
Custom insert query

 INSERT INTO messages(message_type,sender_id,message,date)
 VALUES
('1',:P1,:P2,:P3) RETURNING message_id;
  • INSERT INTO .............. RETURNING id ( Returns id’s for newly created rows.)
  • INSERT INTO .............. RETURNING id , xyx ( Returns id and xyx fields in newly created rows)
  • INSERT INTO .............. RETURNING * ( Returns all fields in newly created rows.)

RETURNING usage is really usefull !!!
and usable with INSERT , UPDATE , DELETE

#2
#3
#4
#5