Hi , thank you !
You have right: [image: image.png] Hmm i thought that i am creating this table " audit_sq " within clone schema and this function is complete. How can i fix this? Best, Jacek pon., 2 lip 2018 o 13:51 Victor Noagbodji <vnoagbo...@amplify-nation.com> napisał(a): > Hello, > > Can you check if the table "audit_sq" has the column "max_value"? > > On Jul 2, 2018, at 7:30 AM, Łukasz Jarych <jarys...@gmail.com> wrote: > > Hi, > > i am trying to use postgresql clone schema function: > > > https://www.postgresql.org/message-id/CANu8FiwiBiAjYgdehYBkJcSRFd6ZFFnN5kDJE7TG4rad5BNXZQ%40mail.gmail.com > > I created function clone_schema in public schema: > > <image.png> > > > I am trying to use : > > "select * from clone_schema('public','Version8',true) but i am getting > error: > > "Column "max_value" does not exist. > LINE 1: SELECT last_value, max_value, start_value, increment_by, min... > HINT: Maybe you wanted to point to column " "audit_sq.last_value"? > QUERY: SELECT last_value, max_value, start_value, increment_by, min_value, > cache_value, log_cnt, is_cycled, is_called FROM public.audit_sq; > > CONTEXT: function PL/pgSQL clone_schema(text,text,boolean), row 66 in > EXECUTE > SQL state: 42703 > Can anyone help? > > Best, > Jacek > > > >
