[Postgres-xl-developers] Question about currval
Joshua D. Drake
jd at commandprompt.com
Wed Aug 3 08:48:17 PDT 2016
On 08/03/2016 08:35 AM, Gustavo Rincon wrote:
> I’m trying to retrieve the sequence id assigned to a row
> after inserting using SELECT currval statement, but the following error
> is returned:
> ERROR: currval of sequence "content_type_seq" is not yet defined in
> this session
> Does the postgres-xl does not support any more currval
I can't answer your specific question but I can make your life easier:
INSERT into content_type (name) values ('image/jpeg') RETURNING id;
Command Prompt, Inc. http://the.postgres.company/
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
Unless otherwise stated, opinions are my own.
More information about the Postgres-xl-developers