× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ivangron reported 2012-12-18T23:14:49Z  · tariqrahiman last modified 2012-12-21T18:56:24Z

greenplum -> datatypes -> multiselect script


Dev
Fun Fun
funfun
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component App - General
Version 13.0
On the tree node for greenplum datatypes you can multiselect datatypes and script create/drop.  If we can't script the objects one at a time, guessing we shouldn't script them with multiselect, plus the script create is not proper DDL syntax but the drop is, so the object will drop and then wont recreate from the generated ddls.  example:  CREATE TYPE "ivan"."ivanbox" AS (f1 int, f2 text);
  select 2 objects and script drop/create and you get this for "ivan"."ivanbox"
DROP TYPE "ivan"."ivanbox"
GO
CREATE TYPE "ivan"."ivanbox" ( INPUT=record_in, OUTPUT=record_out, 
    INTERNALLENGTH=VARIABLE, EXTERNALLENGTH=VARIABLE, 
    DELIMITER=',', 
    ALIGNMENT=double, STORAGE=extended )
GO
  The drop will correctly drop the object but the create will fail...

Issue #8098

Closed
Fixed
Resolved 2012-12-20T02:32:57Z
 
 
Completion
No due date
Fixed Build trunk/30688
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017