Postgres Pro
Downloads
Home   >   mailing lists

perform setval() fails? - Mailing list pgsql-sql

From Sebastien FLAESCH
Subject perform setval() fails?
Date
Msg-id 7f3fc08f-b65d-402c-bc29-9bdb19c2526c@4js.com
Whole thread Raw
Responses Re: perform setval() fails?  (Christophe Pettus <xof@thebuild.com>)
List pgsql-sql
Tree view 
Hello!

What I am missing here?


test1=> perform setval('mytab1_pkey_seq',5000,false);
ERROR:  syntax error at or near "perform"
LINE 1: perform setval('mytab1_pkey_seq',5000,false);
         ^



test1=> select setval('mytab1_pkey_seq',5000,false);
  setval
--------
    5000
(1 row)



Seb

pgsql-sql by date:

Previous
From: Sebastien FLAESCH
Date:
Subject: Re: Get last generated serial sequence and set it up when explicit value is used
Next
From: Christophe Pettus
Date:
Subject: Re: perform setval() fails?