Revision 785

Date:
2020/02/13 19:48:34
Author:
ahitrov
Revision Log:
ON CONFLICT for INNSERT

Files:

Legend:

 
Added
 
Removed
 
Modified

  • utf8/core/lib/Contenido/Object.pm

     
    621 621 $values_string = join(', ', @default_values) if (@default_values);
    622 622 }
    623 623 my $sql='INSERT INTO '.$self->class_table->db_table.' ('.join(', ', (@fields, @default_fields)).') VALUES ('.$values_string.')';
    624 if ( exists $params->{insert_ignore} && $params->{insert_ignore} ) {
    625 ### Can be of use only with PostgreSQL 9.5 or higher!!!
    626 $sql .= ' ON CONFLICT ('.$params->{insert_ignore}.') DO NOTHING';
    627 }
    624 628 warn "$sql\n" if $DEBUG;
    625 629
    626 630 my $sth=$self->keeper->TSQL->prepare_cached($sql, {}, 1) || return $self->t_abort();