Re: Error on the query

Hi

út 4. 3. 2025 v 18:30 odesílatel Igor Korot <ikorot01(at)gmail(dot)com> napsal:

> Hi, ALL,
> Trying to execute following query:
>
> [code]
> queries.push_back( L"DO $$ BEGIN IF NOT EXISTS( SELECT 1 FROM
> pg_class c, pg_namespace n WHERE n.oid = c.relnamespace AND c.relname
> = \'abcatc_x\' AND n.nspname = \'public\' ) THEN CREATE UNIQUE INDEX
> \"abcatc_x\" ON \"abcatcol\"(\"abc_tnam\" ASC, \"abc_ownr\" ASC,
> \"abc_cnam\" ASC); END IF; END;" );
> [/code]
>
> I got:
>
> [quote]
> $4 = L"ERROR: unterminated dollar-quoted string at or near \"$$ BEGIN
> IF NOT EXISTS( SELECT 1 FROM pg_class c, pg_namespace n WHERE n.oid =
> c.relnamespace AND c.relna
> me = 'abcatc_x' AND n.nspname = 'public' "...
>
> [/quote]
>
> What am I missing?
>

you miss ending string separator

DO $$ .... $$;

DO $$
BEGIN
IF ... THEN
END IF;
END;
$$;

Regards

Pavel

>
> Thank you.
>
>
>