Re: Best way to create a sequence generator at run time? - Mailing list pgsql-novice

From Tom Lane
Subject Re: Best way to create a sequence generator at run time?
Date
Msg-id 10253.1285106218@sss.pgh.pa.us
Whole thread Raw
In response to Best way to create a sequence generator at run time?  (Leon Starr <leon_starr@modelint.com>)
Responses Re: Best way to create a sequence generator at run time?
List pgsql-novice
Leon Starr <leon_starr@modelint.com> writes:
> I presume that the create sequence expression wants to see literals instead of variables, right?  I knew I was going
torun into this situation sooner or later.  What should I be doing here? 

You need to construct the CREATE SEQUENCE command as a string then
EXECUTE it.  CREATE SEQUENCE, like most other utility commands, doesn't
handle parameters well.

            regards, tom lane

pgsql-novice by date:

Previous
From: Leon Starr
Date:
Subject: Best way to create a sequence generator at run time?
Next
From: Leon Starr
Date:
Subject: Re: Best way to create a sequence generator at run time?