~ubuntu-branches/ubuntu/oneiric/apgdiff/oneiric

« back to all changes in this revision

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

Committer: Bazaar Package Importer
Author(s): Christoph Berg
Date: 2008-09-09 15:42:54 UTC
Revision ID: james.westby@ubuntu.com-20080909154254-458sv7ew1rczdal1

Tags: upstream-1.2

Import upstream version 1.2

files added:

build.xml

license.txt

nbactions.xml

pom.xml

profiles.xml

src/main

src/main/assemblies

src/main/assemblies/netbeans-run.xml

src/main/java

src/main/java/cz

src/main/java/cz/startnet

src/main/java/cz/startnet/utils

src/main/java/cz/startnet/utils/pgdiff

src/main/java/cz/startnet/utils/pgdiff/Main.java

src/main/java/cz/startnet/utils/pgdiff/PgDiff.java

src/main/java/cz/startnet/utils/pgdiff/PgDiffArguments.java

src/main/java/cz/startnet/utils/pgdiff/PgDiffConstraints.java

src/main/java/cz/startnet/utils/pgdiff/PgDiffFunctions.java

src/main/java/cz/startnet/utils/pgdiff/PgDiffIndexes.java

src/main/java/cz/startnet/utils/pgdiff/PgDiffSequences.java

src/main/java/cz/startnet/utils/pgdiff/PgDiffTables.java

src/main/java/cz/startnet/utils/pgdiff/PgDiffTriggers.java

src/main/java/cz/startnet/utils/pgdiff/PgDiffUtils.java

src/main/java/cz/startnet/utils/pgdiff/PgDiffViews.java

src/main/java/cz/startnet/utils/pgdiff/loader

src/main/java/cz/startnet/utils/pgdiff/loader/FileException.java

src/main/java/cz/startnet/utils/pgdiff/loader/PgDumpLoader.java

src/main/java/cz/startnet/utils/pgdiff/loader/package-info.java

src/main/java/cz/startnet/utils/pgdiff/package-info.java

src/main/java/cz/startnet/utils/pgdiff/parsers

src/main/java/cz/startnet/utils/pgdiff/parsers/AlterTableParser.java

src/main/java/cz/startnet/utils/pgdiff/parsers/CreateFunctionParser.java

src/main/java/cz/startnet/utils/pgdiff/parsers/CreateIndexParser.java

src/main/java/cz/startnet/utils/pgdiff/parsers/CreateSchemaParser.java

src/main/java/cz/startnet/utils/pgdiff/parsers/CreateSequenceParser.java

src/main/java/cz/startnet/utils/pgdiff/parsers/CreateTableParser.java

src/main/java/cz/startnet/utils/pgdiff/parsers/CreateTriggerParser.java

src/main/java/cz/startnet/utils/pgdiff/parsers/CreateViewParser.java

src/main/java/cz/startnet/utils/pgdiff/parsers/ParserException.java

src/main/java/cz/startnet/utils/pgdiff/parsers/ParserUtils.java

src/main/java/cz/startnet/utils/pgdiff/parsers/package-info.java

src/main/java/cz/startnet/utils/pgdiff/schema

src/main/java/cz/startnet/utils/pgdiff/schema/PgColumn.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgColumnUtils.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgConstraint.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgDatabase.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgFunction.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgIndex.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgSchema.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgSequence.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgTable.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgTrigger.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgView.java

src/main/java/cz/startnet/utils/pgdiff/schema/package-info.java

src/main/resources

src/main/resources/cz

src/main/resources/cz/startnet

src/main/resources/cz/startnet/utils

src/main/resources/cz/startnet/utils/pgdiff

src/main/resources/cz/startnet/utils/pgdiff/build_info

src/main/resources/cz/startnet/utils/pgdiff/usage.txt

src/site

src/site/apt

src/site/site.xml

src/site/xdoc

src/site/xdoc/index.xml

src/test

src/test/java

src/test/java/cz

src/test/java/cz/startnet

src/test/java/cz/startnet/utils

src/test/java/cz/startnet/utils/pgdiff

src/test/java/cz/startnet/utils/pgdiff/PgDiffTest.java

src/test/java/cz/startnet/utils/pgdiff/loader

src/test/java/cz/startnet/utils/pgdiff/loader/PgDumpLoaderTest.java

src/test/resources

src/test/resources/cz

src/test/resources/cz/startnet

src/test/resources/cz/startnet/utils

src/test/resources/cz/startnet/utils/pgdiff

src/test/resources/cz/startnet/utils/pgdiff/add_cluster_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_cluster_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_cluster_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_column_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_column_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_column_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_constraint_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_constraint_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_constraint_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_default_value_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_default_value_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_default_value_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_defaults_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_defaults_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_defaults_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_args2_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_args2_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_args2_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_args_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_args_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_args_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_noargs_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_noargs_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_noargs_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_similar_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_similar_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_similar_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_index_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_index_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_index_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_inherits_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_inherits_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_inherits_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_not_null_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_not_null_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_not_null_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_sequence_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_sequence_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_sequence_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_statistics_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_statistics_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_statistics_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_table_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_table_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_table_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_transaction_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_transaction_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_transaction_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_trigger_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_trigger_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_trigger_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_unique_constraint_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_unique_constraint_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_unique_constraint_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_view_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_view_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_view_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_cluster_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_cluster_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_cluster_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_column_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_column_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_column_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_constraint_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_constraint_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_constraint_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_default_value_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_default_value_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_default_value_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_args2_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_args2_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_args2_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_args_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_args_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_args_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_noargs_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_noargs_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_noargs_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_similar_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_similar_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_similar_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_index_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_index_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_index_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_index_with_cluster_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_index_with_cluster_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_index_with_cluster_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_not_null_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_not_null_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_not_null_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_sequence_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_sequence_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_sequence_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_statistics_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_statistics_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_statistics_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_table_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_table_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_table_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_trigger_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_trigger_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_trigger_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_view_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_view_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_view_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_with_oids_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_with_oids_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_with_oids_original.sql

src/test/resources/cz/startnet/utils/pgdiff/function_equal_whitespace_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/function_equal_whitespace_new.sql

src/test/resources/cz/startnet/utils/pgdiff/function_equal_whitespace_original.sql

src/test/resources/cz/startnet/utils/pgdiff/inherited_tables_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/loader

src/test/resources/cz/startnet/utils/pgdiff/loader/schema_1.sql

src/test/resources/cz/startnet/utils/pgdiff/loader/schema_2.sql

src/test/resources/cz/startnet/utils/pgdiff/loader/schema_3.sql

src/test/resources/cz/startnet/utils/pgdiff/loader/schema_4.sql

src/test/resources/cz/startnet/utils/pgdiff/loader/schema_5.sql

src/test/resources/cz/startnet/utils/pgdiff/loader/schema_6.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_cluster_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_cluster_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_cluster_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_column_type_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_column_type_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_column_type_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_constraint_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_constraint_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_constraint_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_default_value_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_default_value_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_default_value_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_args2_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_args2_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_args2_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_args_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_args_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_args_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_noargs_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_noargs_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_noargs_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_similar_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_similar_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_similar_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_index_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_index_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_index_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_inherits_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_inherits_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_inherits_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_cache_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_cache_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_cache_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_cycle_off_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_cycle_off_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_cycle_off_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_cycle_on_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_cycle_on_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_cycle_on_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_increment_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_increment_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_increment_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_maxvalue_set_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_maxvalue_set_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_maxvalue_set_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_maxvalue_unset_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_maxvalue_unset_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_maxvalue_unset_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_minvalue_set_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_minvalue_set_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_minvalue_set_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_minvalue_unset_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_minvalue_unset_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_minvalue_unset_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_start_ignore_off_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_start_ignore_off_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_start_ignore_off_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_start_ignore_on_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_start_ignore_on_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_start_ignore_on_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_statistics_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_statistics_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_statistics_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_trigger_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_trigger_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_trigger_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_view_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_view_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_view_original.sql

src/test/resources/cz/startnet/utils/pgdiff/multiple_schemas_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/multiple_schemas_new.sql

src/test/resources/cz/startnet/utils/pgdiff/multiple_schemas_original.sql

src/test/resources/cz/startnet/utils/pgdiff/read_inherits_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/read_inherits_new.sql

src/test/resources/cz/startnet/utils/pgdiff/read_inherits_original.sql

Show diffs side-by-side

added added

removed removed

src/test/resources/cz/startnet/utils/pgdiff/add_constraint_original.sql

-- PostgreSQL database dump

SET client_encoding = 'UTF8';

SET check_function_bodies = false;

SET client_min_messages = warning;

-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres

COMMENT ON SCHEMA public IS 'Standard public schema';

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

-- Name: testtable; Type: TABLE; Schema: public; Owner: fordfrog; Tablespace:

CREATE TABLE testtable (

field1 integer,

field2 integer,

field3 character varying(150) DEFAULT 'none'::character varying,

field4 double precision,

"full" timestamp with time zone DEFAULT '2006-11-10 00:00:00+01'::timestamp with time zone NOT NULL

);

ALTER TABLE ONLY testtable ALTER COLUMN "full" SET STATISTICS 200;

ALTER TABLE public.testtable OWNER TO fordfrog;

-- Name: testindex; Type: INDEX; Schema: public; Owner: fordfrog; Tablespace:

CREATE INDEX testindex ON testtable USING btree (field3);

-- Name: public; Type: ACL; Schema: -; Owner: postgres

REVOKE ALL ON SCHEMA public FROM PUBLIC;

REVOKE ALL ON SCHEMA public FROM postgres;

GRANT ALL ON SCHEMA public TO postgres;

GRANT ALL ON SCHEMA public TO PUBLIC;

-- PostgreSQL database dump complete

Older »