Re: Cloning schemas

Поиск
Список
Период
Сортировка
От Łukasz Jarych
Тема Re: Cloning schemas
Дата
Msg-id CAGv31ofj0556_RKt+NcbM5R0WJrrD-=hMZ9C_bYDctg8WEdkqQ@mail.gmail.com
обсуждение исходный текст
Ответ на Cloning schemas  (Łukasz Jarych <jaryszek@gmail.com>)
Список pgsql-general
Дерево обсуждения
Hi ,

thank you !

You have right:

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@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 <jaryszek@gmail.com> wrote:

Hi,

i am trying to use postgresql clone schema function:


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



Вложения

В списке pgsql-general по дате отправления: