Re: Error on the query

2025-03-04 Thread Igor Korot
Hi, Pavel, On Tue, Mar 4, 2025 at 11:36 AM Pavel Stehule wrote: > > Hi > > út 4. 3. 2025 v 18:30 odesílatel Igor Korot 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

Re: Error on the query

2025-03-04 Thread David G. Johnston
On Tuesday, March 4, 2025, Igor Korot wrote: > > [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 \"abcatco

Re: Error on the query

2025-03-04 Thread Pavel Stehule
Hi út 4. 3. 2025 v 18:30 odesílatel Igor Korot 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 = \'pub

Error on the query

2025-03-04 Thread Igor Korot
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_tna