Re: Cloning schemas

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 <vnoagbodji(at)amplify-nation(dot)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 <jaryszek(at)gmail(dot)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
>
>
>
>