[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:
> Hi,
>                 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 mailing list