#7992: Generate Template Script on 2 Vertica tables - only writes 2 GO lines to query window

swissarmyknife(*) reported 2012-11-30T20:45:51Z · last modified 2012-11-30T21:33:40Z

Dev	ivangron
QA	SachinPrakash

Priority	Low
Complexity	Unknown

Component	App - General
Version	13.0

Version: 13.0-dev-37

Build #: 30377

Build Date: 2012-Nov-29 06:07:41 PM

Operating Environment: Windows XP (5.2, amd64) / Cp1252 / en / US / Sun Microsystems Inc. 1.6.0_35-b10

Memory: Max=891,092,992; Total=391,839,744; Free=223,837,096; CPUs=8

1. left click to select 2 tables ( in my example I chose 2 that were not in the public schema)

2. right click on one of the 2 selected tables and choose "Generate Template Script"

3. in the dialog you should see the two tables, click OK

4. a new query analyzer window opens, but it only contains a GO for each table

see attached

All Comments (2) Change History

swissarmyknife(*) 2012-11-30T20:47:31Z

turns out it doesn't matter if the tables you select are in public schema or not, same result.

swissarmyknife(*) 2012-11-30T21:33:40Z

I didn't know I had to pick from the Explain Format and paste in the edit area. My mistake.