Fwd: SQL

Jacek,

In answer to your question "sequences are the same and causing problems. Maybe there is a way to change them ?

Like newCreatedSchemaName_CopiedSequance?" The function already is coded to do that. 

See the code                                                                vvvv

    EXECUTE 'CREATE SEQUENCE ' || quote_ident(dest_schema) || '.' || quote_ident(object)
         || ' AS ' || sq_typname
         || ' INCREMENT ' ||  sq_increment_by
         || ' MINVALUE ' || sq_min_value
         || ' MAXVALUE ' || sq_max_value
         || ' START WITH ' || sq_start_value
         || ' CACHE ' || sq_cache_value
         || seq_cycled;

The problem is caused by the following statement:

CREATE TABLE melvin.t_audittrail (LIKE test.t_audittrail INCLUDING ALL);

which fails with:

ERROR: MINVALUE (1) must be less than MAXVALUE (-1) 

However, that SHOULD NOT happen because the table does NOT reference any sequence.

So the problem is a PostgreSQL 10 bug!

Please report this bug and include the table structure, as I will be going on vacation for a week.

On Fri, Jul 13, 2018 at 3:12 AM, Łukasz Jarych <jaryszek@gmail.com> wrote:

Hi Melvin,

i dumped test database. 

Your function is working but sequences are the same and causing problems. Maybe there is a way to change them ?

Like newCreatedSchemaName_CopiedSequance?

Thank you very much for help!

Best,

Jacek 

czw., 12 lip 2018 o 16:36 Łukasz Jarych <jaryszek@gmail.com> napisał(a):

Hi Melvin,

i will change data to show you. 

Another problem is that constraints in one schema are the same in the second schema - i was trying to delete record from public table but constraint was on test schema table and i got the error: 

"you can not delete because you are violating constraints"

Best,

Jacek 

czw., 12 lip 2018 o 15:49 Melvin Davidson <melvin6925@gmail.com> napisał(a):

>so this is working fine. But after runing function sequances in new schema are not working...

Jacek,

In that case, in order to fix the problem, I will need you to send me the data as below.

pg_dump -U postgres -F p -n your_source_schema  yourdb > schema_dump.sql

--

Melvin Davidson
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!

--

Melvin Davidson
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!