php doctrine postgresql An exception occurred while executing 'SELECT NEXTVAL Ошибка решение

Primary tabs

vedro-compota's picture
Submitted by vedro-compota on Mon, 06/17/2019 - 14:22

Forums:

An exception occurred while executing 'SELECT NEXTVAL('"user_id_seq"')':

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "user_id_seq" does not
exist
LINE 1: SELECT NEXTVAL('"user_id_seq"')
^

Причина и возможное решение

Причина было в том что действительно для таблицы не была создана последовательность user_id_seq.

В доктрине это можно сделать так (php, миграция симфони):

$this->addSql('CREATE SEQUENCE user_id_seq INCREMENT BY 1 MINVALUE 1 START 1');

Key Words for FKN + antitotal forum (CS VSU):

  • Log in to post comments
  • 3601 reads
vedro-compota's picture

vedro-compota

Mon, 06/17/2019 - 14:37

In AbstractPostgreSQLDriver.php line 63:

An exception occurred while executing 'SELECT NEXTVAL('"user_id_seq"')':

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "user_id_seq" does not
exist
LINE 1: SELECT NEXTVAL('"user_id_seq"')
^

In PDOConnection.php line 90:

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "user_id_seq" does not
exist
LINE 1: SELECT NEXTVAL('"user_id_seq"')
^

In PDOConnection.php line 88:

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "user_id_seq" does not
exist
LINE 1: SELECT NEXTVAL('"user_id_seq"')
^

_____________
матфак вгу и остальная классика =)