[PgsqlPlatform] error generated select nextval() query

[nibsirahsieu]

i found another issue, propel generate $stmt = $con->query('SELECT nextval(edelivery.application_user_id_seq)'); (in the doInsert() function)

SQLSTATE[42P01]: Undefined table: 7 ERROR: missing FROM-clause entry for table "edelivery" LINE 1: SELECT nextval(edelivery.application_user_id_seq)

Expected : $stmt = $con->query("SELECT nextval('edelivery.application_user_id_seq')");

Quick fix:

$snippet = "
\$stmt = %s->query(\"SELECT nextval(%s)\");
\$row = \$stmt->fetch(PDO::FETCH_NUM);
%s = \$row[0];";
        $script = sprintf($snippet,
            $connectionVariableName,
            $this->quote($sequenceName),
            $columnValueMutator
        );

[fzaninotto]

See https://github.com/propelorm/Propel/pull/123 for a fix

[nibsirahsieu]

ok :). Thanks

[nibsirahsieu]

Great.. it work.. thank francoiz

[nibsirahsieu]

Should i close this issue?

[fzaninotto]

no, it's not in master yet

[willdurand]

Merged.