Re: problem with insertion of serial id - Mailing list pgsql-admin

From Tom Lane
Subject Re: problem with insertion of serial id
Date
Msg-id 7966.1029004933@sss.pgh.pa.us
Whole thread Raw
In response to problem with insertion of serial id  (Michael Zouroudis <mzouroudis@idealcorp.com>)
List pgsql-admin
Michael Zouroudis <mzouroudis@idealcorp.com> writes:
> when i run this i get a parse error at or near "assets_asset_id_seq".

You need to double those quote marks, viz
    ... currval(''mom_mom_id_seq'') ...

Or you can backslash 'em (\').  The point is that the function body
begins life as a string literal, and so you have to get it through the
string-literal parser.

            regards, tom lane

pgsql-admin by date:

Previous
From: Michael Zouroudis
Date:
Subject: problem with insertion of serial id
Next
From: Brian McCane
Date:
Subject: Re: Postgres performance slowly gets worse over a month