[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;

JD


-- 
Command Prompt, Inc.                  http://the.postgres.company/
                         +1-503-667-4564
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