~ubuntu-branches/ubuntu/karmic/apgdiff/karmic

« back to all changes in this revision

Viewing changes to src/test/resources/cz/startnet/utils/pgdiff/loader/schema_5.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/loader/schema_5.sql

CREATE FUNCTION gtsq_in(cstring) RETURNS gtsq

AS '$libdir/tsearch2', 'gtsq_in'

LANGUAGE c STRICT;

CREATE FUNCTION multiply_numbers(number1 integer, number2 integer) RETURNS integer

AS $$

begin

return number1 * number2;

end;

LANGUAGE plpgsql STRICT;

CREATE FUNCTION select_something(number1 integer, number2 integer) RETURNS integer

AS $_$SELECT number1 * number2$_$ LANGUAGE plpgsql;

CREATE FUNCTION select_something2(number1 integer, number2 integer) RETURNS integer

AS 'SELECT number1 * number2 || \'text\'' LANGUAGE plpgsql;

CREATE FUNCTION select_something3(number1 integer, number2 integer) RETURNS integer

AS '

SELECT number1 * number2 || \'text\'

' LANGUAGE plpgsql;

Older »