From: | Łukasz Jarych <jaryszek(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
Subject: | Cloning schemas |
Date: | 2018-07-02 11:30:43 |
Message-ID: | CAGv31ofHAE49iTQ4_Q_AiTduoVscQWXKfZanYU0yQP8HyxPJvQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
i am trying to use postgresql clone schema function:
I created function clone_schema in public schema:
[image: 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
From | Date | Subject | |
---|---|---|---|
Next Message | Łukasz Jarych | 2018-07-02 12:24:09 | Re: Cloning schemas |
Previous Message | Tatsuo Ishii | 2018-07-02 05:38:45 | Re: Call for Papers - PGConf.ASIA 2018 |