Skip to content

Recompile fails in some cases #4

@m7onov

Description

@m7onov

Recompile fails in some cases if previous compilation end up with errors. Example:

remote node:

create or replace
function mvs_plx_test(aname text)
returns text as $$
declare
begin
  return format('Hello %s!', aname);
end;
$$ language plpgsql;

CREATE FUNCTION

local node 1st compilation (with syntax error):

create or replace
function mvs_plx_test(aname text) 
returns text as $$
cluster billing;
run mvs_plx_test(aname || 'dgfd') on 0;
$$ language plexor;

ERROR: Plexor function public.mvs_plx_test(): Compile error at line 3: syntax error

local node 2nd compilation (valid syntax):

create or replace
function mvs_plx_test(aname text) 
returns text as $$
cluster billing;
run mvs_plx_test(aname) on 0;
$$ language plexor;

ERROR: Plexor function public.mvs_plx_test(): Compile error at line 2: syntax error

Further compilation attempts fails. To work around the issue reconnect then recompile valid plexor-function and you succeed.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions