pg-clone-schema

pg-clone-schema copied to clipboard

COPY Error for PostGIS column table

4

@Brent-Wood : With this error: ERROR: Action: Copy Rows Diagnostics: line=COPY t_stratum_defn, line 19: "545,1,\N,\N,lhr1001,IQCH,\N,0106000020E61000000100000001030000000200000098060000B6B4CE57D5C16540B2B..." SQL statement "COPY trawl_dev2.t_stratum_defn FROM '/tmp/cloneschema.tmp' (DELIMITER ',', NULL '\N', FORMAT CSV);" PL/pgSQL function clone_schema(text,text,boolean,boolean,boolean)...

MichaelDBA

Dependency Problems

1

Currently, there is no dependency checking. For example, if a view is dependent on another view, they may not be created in the correct order during the clone operation resulting...

MichaelDBA

Owner with special characters

1

**Issue: Cloning a schema from an owner with special characters causes the clone_schema to fail.** **Description:** Some statements are executed without quotation marks around the owner. I quoted the owner...

gunnareilers

Question about 'DATA' copy performace

1

Hi, I tested pg-clone-schema on my database (localhost). I have another way of 'cloning' the schema. I apply all the migrations to create a fresh schema, remove all FK constraints,...

samodadela

Multiple issues cloning views

20

Hi, Found some problems when running `pg-clone-schema` on my project: - it does not handle the case where a normal view depends on a materialized view or vice-versa - views...

samodadela