~ubuntu-branches/ubuntu/raring/apgdiff/raring

« 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-11 09:08:18 UTC
  • mfrom: (2.1.7 sid)
  • Revision ID: james.westby@ubuntu.com-20101011090818-sdw8yfemrnxo328k
Tags: 2.2.2-1
* New upstream version.
* Using changelog included in zipfile, thanks Miroslav for providing this.
* Update manpage.

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;