~ubuntu-branches/ubuntu/vivid/apgdiff/vivid

« back to all changes in this revision

Viewing changes to src/test/resources/cz/startnet/utils/pgdiff/modify_inherits_diff.sql

  • Committer: Bazaar Package Importer
  • Author(s): Christoph Berg
  • Date: 2010-10-02 19:35:17 UTC
  • mfrom: (1.1.3 upstream)
  • Revision ID: james.westby@ubuntu.com-20101002193517-9wesve8sksxcktkc
Tags: 2.2-1
* New upstream version.
* Update homepage location.
* Finally enable test suite, yay!

Show diffs side-by-side

added added

removed removed

Lines of Context:
7
7
        DROP COLUMN id,
8
8
        ADD COLUMN field3 information_schema.cardinal_number;
9
9
 
10
 
Modified INHERITS on TABLE testtable: original table uses INHERITS (parenttable) but new table uses INHERITS (parenttable2)
 
10
ALTER TABLE testtable
 
11
        NO INHERIT parenttable;
 
12
 
 
13
ALTER TABLE testtable
 
14
        INHERIT parenttable2;