[pgsqlclient-checkins] pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema PgAggregatesSchema
Status: Inactive
Brought to you by:
carlosga_fb
Menu
▾
▴
[pgsqlclient-checkins] pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema PgAggregatesSchema.cs,1.1.1.1,1.2 PgCastsSchema.cs,1.1.1.1,1.2 PgCheckConstraints.cs,1.1.1.1,1.2 PgCheckConstraintsByTable.cs,1.1.1.1,1.2 PgColumnsSchema.cs,1.1.1.1,1.2 PgDatabaseSchema.cs,1.1.1.1,1.2 PgDomainsSchema.cs,1.1.1.1,1.2 PgForeignKeysSchema.cs,1.1.1.1,1.2 PgFunctionPrivilegesSchema.cs,1.1.1.1,1.2 PgFunctionsSchema.cs,1.1.1.1,1.2 PgGroupsSchema.cs,1.1.1.1,1.2 PgIndexesSchema.cs,1.1.1.1,1.2 PgPrimaryKeysSchema.cs,1.1.1.1,1.2 PgProviderTypesSchema.cs,1.1.1.1,1.2 PgSchemataSchema.cs,1.1.1.1,1.2 PgSqlLanguagesSchema.cs,1.1.1.1,1.2 PgTableConstraintsSchema.cs,1.1.1.1,1.2 PgTablePrivilegesSchema.cs,1.1.1.1,1.2 PgTablesSchema.cs,1.1.1.1,1.2 PgTableStatisticsSchema.cs,1.1.1.1,1.2 PgTriggersSchema.cs,1.1.1.1,1.2 PgUsersSchema.cs,1.1.1.1,1.2 PgViewPrivilegesSchema.cs,1.1.1.1,1.2 PgViewsSchema.cs,1.1.1.1,1.2
Update of /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema
In directory sc8-pr-cvs1:/tmp/cvs-serv19578
Modified Files:
PgAggregatesSchema.cs PgCastsSchema.cs PgCheckConstraints.cs
PgCheckConstraintsByTable.cs PgColumnsSchema.cs
PgDatabaseSchema.cs PgDomainsSchema.cs PgForeignKeysSchema.cs
PgFunctionPrivilegesSchema.cs PgFunctionsSchema.cs
PgGroupsSchema.cs PgIndexesSchema.cs PgPrimaryKeysSchema.cs
PgProviderTypesSchema.cs PgSchemataSchema.cs
PgSqlLanguagesSchema.cs PgTableConstraintsSchema.cs
PgTablePrivilegesSchema.cs PgTablesSchema.cs
PgTableStatisticsSchema.cs PgTriggersSchema.cs
PgUsersSchema.cs PgViewPrivilegesSchema.cs PgViewsSchema.cs
Log Message:
Fixed catalog table names
Index: PgAggregatesSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgAggregatesSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgAggregatesSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgAggregatesSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,64 ****
public override void AddTables()
{
! AddTable("Pg_aggregate");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_aggregate.aggfnoid", "AGGREGATE_FUNCTION", null);
}
public override void AddDataColumns()
{
! AddDataColumn("Pg_aggregate.aggtransfn" , "TRANSITION_FUNCTION");
! AddDataColumn("Pg_aggregate.aggfinalfn" , "FINAL_FUNCTION");
! AddDataColumn("Pg_aggregate.agginitval" , "INITIAL_VALUE");
! AddDataColumn("Pg_type.typname" , "BASE_TYPE");
}
public override void AddJoins()
{
! AddJoin("left join", "Pg_type", "Pg_aggregate.aggtranstype = Pg_type.oid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_aggregate.aggfnoid");
}
--- 37,64 ----
public override void AddTables()
{
! AddTable("pg_aggregate");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_aggregate.aggfnoid", "AGGREGATE_FUNCTION", null);
}
public override void AddDataColumns()
{
! AddDataColumn("pg_aggregate.aggtransfn" , "TRANSITION_FUNCTION");
! AddDataColumn("pg_aggregate.aggfinalfn" , "FINAL_FUNCTION");
! AddDataColumn("pg_aggregate.agginitval" , "INITIAL_VALUE");
! AddDataColumn("pg_type.typname" , "BASE_TYPE");
}
public override void AddJoins()
{
! AddJoin("left join", "pg_type", "pg_aggregate.aggtranstype = pg_type.oid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("pg_aggregate.aggfnoid");
}
Index: PgCastsSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgCastsSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgCastsSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgCastsSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,41 ****
public override void AddTables()
{
! AddTable("Pg_cast");
}
--- 37,41 ----
public override void AddTables()
{
! AddTable("pg_cast");
}
***************
*** 46,67 ****
public override void AddDataColumns()
{
! AddDataColumn("Pg_typesrc.typname" , "SOURCE_TYPE");
! AddDataColumn("Pg_typetgt.typname" , "TARGET_TYPE");
! AddDataColumn("Pg_namespace.nspname", "FUNCTION_SCHEMA");
! AddDataColumn("Pg_proc.proname" , "FUNCTION_NAME");
! AddDataColumn(getContextExpression("Pg_cast.castcontext"), "CAST_CONTEXT");
}
public override void AddJoins()
{
! AddJoin("left join", "Pg_type as Pg_typesrc", "Pg_cast.castsource = Pg_typesrc.oid");
! AddJoin("left join", "Pg_type as Pg_typetgt", "Pg_cast.casttarget = Pg_typetgt.oid");
! AddJoin("left join", "Pg_proc" , "Pg_cast.castfunc = Pg_proc.oid");
! AddJoin("left join", "Pg_namespace" , "Pg_proc.pronamespace = Pg_namespace.oid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_proc.proname");
}
--- 46,67 ----
public override void AddDataColumns()
{
! AddDataColumn("pg_typesrc.typname" , "SOURCE_TYPE");
! AddDataColumn("pg_typetgt.typname" , "TARGET_TYPE");
! AddDataColumn("pg_namespace.nspname", "FUNCTION_SCHEMA");
! AddDataColumn("pg_proc.proname" , "FUNCTION_NAME");
! AddDataColumn(getContextExpression("pg_cast.castcontext"), "CAST_CONTEXT");
}
public override void AddJoins()
{
! AddJoin("left join", "pg_type as pg_typesrc", "pg_cast.castsource = pg_typesrc.oid");
! AddJoin("left join", "pg_type as pg_typetgt", "pg_cast.casttarget = pg_typetgt.oid");
! AddJoin("left join", "pg_proc" , "pg_cast.castfunc = pg_proc.oid");
! AddJoin("left join", "pg_namespace" , "pg_proc.pronamespace = pg_namespace.oid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("pg_proc.proname");
}
Index: PgCheckConstraints.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgCheckConstraints.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgCheckConstraints.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgCheckConstraints.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,70 ****
public override void AddTables()
{
! AddTable("Pg_constraint");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_namespace.nspname", "CONSTRAINT_SCHEMA", null);
! AddRestrictionColumn("Pg_constraint.conname", "CONSTRAINT_NAME", null);
}
public override void AddDataColumns()
{
! AddDataColumn("Pg_get_constraintdef(Pg_constraint.oid)", "CHECK_CLAUSULE");
! AddDataColumn("Pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "Pg_namespace" , "Pg_constraint.connamespace = Pg_namespace.oid");
! AddJoin("left join", "Pg_description" , "Pg_constraint.oid = Pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_namespace.nspname");
! AddOrderBy("Pg_constraint.conname");
}
public override void AddWhereFilters()
{
! AddWhereFilter("Pg_constraint.contype = 'c'");
}
--- 37,70 ----
public override void AddTables()
{
! AddTable("pg_constraint");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_namespace.nspname", "CONSTRAINT_SCHEMA", null);
! AddRestrictionColumn("pg_constraint.conname", "CONSTRAINT_NAME", null);
}
public override void AddDataColumns()
{
! AddDataColumn("pg_get_constraintdef(pg_constraint.oid)", "CHECK_CLAUSULE");
! AddDataColumn("pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "pg_namespace" , "pg_constraint.connamespace = pg_namespace.oid");
! AddJoin("left join", "pg_description" , "pg_constraint.oid = pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("pg_namespace.nspname");
! AddOrderBy("pg_constraint.conname");
}
public override void AddWhereFilters()
{
! AddWhereFilter("pg_constraint.contype = 'c'");
}
Index: PgCheckConstraintsByTable.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgCheckConstraintsByTable.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgCheckConstraintsByTable.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgCheckConstraintsByTable.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,76 ****
public override void AddTables()
{
! AddTable("Pg_constraint");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_namespace.nspname" , "CONSTRAINT_SCHEMA" , null);
! AddRestrictionColumn("Pg_constraint.conname", "CONSTRAINT_NAME" , null);
AddRestrictionColumn("tbn.nspname" , "TABLE_SCHEMA" , null);
! AddRestrictionColumn("Pg_class.relname" , "TABLE_NAME" , null);
}
public override void AddDataColumns()
{
! AddDataColumn("Pg_get_constraintdef(Pg_constraint.oid)", "CHECK_CLAUSULE");
! AddDataColumn("Pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "Pg_class" , "Pg_class.oid = Pg_constraint.conrelid");
! AddJoin("left join", "Pg_namespace tbn" , "Pg_class.relnamespace = tbn.oid");
! AddJoin("left join", "Pg_namespace" , "Pg_constraint.connamespace = Pg_namespace.oid");
! AddJoin("left join", "Pg_description" , "Pg_constraint.oid = Pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_namespace.nspname");
! AddOrderBy("Pg_class.relname");
! AddOrderBy("Pg_constraint.conname");
}
public override void AddWhereFilters()
{
! AddWhereFilter("Pg_constraint.contype = 'c'");
! AddWhereFilter("Pg_class.relkind = 'r'");
}
--- 37,76 ----
public override void AddTables()
{
! AddTable("pg_constraint");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_namespace.nspname" , "CONSTRAINT_SCHEMA" , null);
! AddRestrictionColumn("pg_constraint.conname", "CONSTRAINT_NAME" , null);
AddRestrictionColumn("tbn.nspname" , "TABLE_SCHEMA" , null);
! AddRestrictionColumn("pg_class.relname" , "TABLE_NAME" , null);
}
public override void AddDataColumns()
{
! AddDataColumn("pg_get_constraintdef(pg_constraint.oid)", "CHECK_CLAUSULE");
! AddDataColumn("pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "pg_class" , "pg_class.oid = pg_constraint.conrelid");
! AddJoin("left join", "pg_namespace tbn" , "pg_class.relnamespace = tbn.oid");
! AddJoin("left join", "pg_namespace" , "pg_constraint.connamespace = pg_namespace.oid");
! AddJoin("left join", "pg_description" , "pg_constraint.oid = pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("pg_namespace.nspname");
! AddOrderBy("pg_class.relname");
! AddOrderBy("pg_constraint.conname");
}
public override void AddWhereFilters()
{
! AddWhereFilter("pg_constraint.contype = 'c'");
! AddWhereFilter("pg_class.relkind = 'r'");
}
Index: PgColumnsSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgColumnsSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgColumnsSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgColumnsSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,76 ****
public override void AddTables()
{
! AddTable("Pg_attribute");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_namespace.nspname" , "TABLE_SCHEMA", null);
! AddRestrictionColumn("Pg_class.relname" , "TABLE_NAME", null);
! AddRestrictionColumn("Pg_attribute.attname" , "COLUMN_NAME", null);
}
public override void AddDataColumns()
{
! AddDataColumn("Pg_attribute.atttypid" , "DATA_TYPE");
! AddDataColumn("Pg_attribute.attlen" , "COLUMN_SIZE");
! AddDataColumn("Pg_attribute.attndims" , "COLUMN_DIMENSIONS");
! AddDataColumn("Pg_attribute.attnum" , "ORDINAL_POSITION");
! AddDataColumn("Pg_attribute.atthasdef" , "HAS_DEFAULT");
! AddDataColumn("Pg_attrdef.adsrc" , "COLUMN_DEFAULT");
! AddDataColumn("Pg_attribute.attnotnull" , "IS_NOT_NULL");
! AddDataColumn(getStorageExpression("Pg_attribute.attstorage"), "STORAGE");
! AddDataColumn("Pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "Pg_class" , "Pg_attribute.attrelid = Pg_class.oid");
! AddJoin("left join", "Pg_namespace" , "Pg_class.relnamespace = Pg_namespace.oid");
! AddJoin("left join", "Pg_attrdef" , "Pg_class.oid = Pg_attrdef.adrelid AND Pg_attribute.attnum = Pg_attrdef.adnum");
! AddJoin("left join", "Pg_description", "Pg_attribute.attrelid = Pg_description.objoid AND Pg_attribute.attnum = Pg_description.objsubid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_namespace.nspname");
! AddOrderBy("Pg_class.relname");
! AddOrderBy("Pg_attribute.attnum");
}
--- 37,76 ----
public override void AddTables()
{
! AddTable("pg_attribute");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_namespace.nspname" , "TABLE_SCHEMA", null);
! AddRestrictionColumn("pg_class.relname" , "TABLE_NAME", null);
! AddRestrictionColumn("pg_attribute.attname" , "COLUMN_NAME", null);
}
public override void AddDataColumns()
{
! AddDataColumn("pg_attribute.atttypid" , "DATA_TYPE");
! AddDataColumn("pg_attribute.attlen" , "COLUMN_SIZE");
! AddDataColumn("pg_attribute.attndims" , "COLUMN_DIMENSIONS");
! AddDataColumn("pg_attribute.attnum" , "ORDINAL_POSITION");
! AddDataColumn("pg_attribute.atthasdef" , "HAS_DEFAULT");
! AddDataColumn("pg_attrdef.adsrc" , "COLUMN_DEFAULT");
! AddDataColumn("pg_attribute.attnotnull" , "IS_NOT_NULL");
! AddDataColumn(getStorageExpression("pg_attribute.attstorage"), "STORAGE");
! AddDataColumn("pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "pg_class" , "pg_attribute.attrelid = pg_class.oid");
! AddJoin("left join", "pg_namespace" , "pg_class.relnamespace = pg_namespace.oid");
! AddJoin("left join", "pg_attrdef" , "pg_class.oid = pg_attrdef.adrelid AND pg_attribute.attnum = pg_attrdef.adnum");
! AddJoin("left join", "pg_description", "pg_attribute.attrelid = pg_description.objoid AND pg_attribute.attnum = pg_description.objsubid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("pg_namespace.nspname");
! AddOrderBy("pg_class.relname");
! AddOrderBy("pg_attribute.attnum");
}
***************
*** 78,84 ****
{
// Do not get dropped columns
! AddWhereFilter("Pg_attribute.attisdropped = false");
// Get only columns with a number > 0
! AddWhereFilter("Pg_attribute.attnum > 0");
}
--- 78,84 ----
{
// Do not get dropped columns
! AddWhereFilter("pg_attribute.attisdropped = false");
// Get only columns with a number > 0
! AddWhereFilter("pg_attribute.attnum > 0");
}
Index: PgDatabaseSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgDatabaseSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgDatabaseSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgDatabaseSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,53 ****
public override void AddTables()
{
! AddTable("Pg_database");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_database.datname", "DATABASE_NAME", null);
}
public override void AddDataColumns()
{
! AddDataColumn("Pg_database.datistemplate" , "IS_TEMPLATE");
! AddDataColumn("Pg_database.datallowconn" , "ALLOW_CONNECTION");
! AddDataColumn("Pg_database.datconfig" , "DATABASE_CONFIG");
}
--- 37,53 ----
public override void AddTables()
{
! AddTable("pg_database");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_database.datname", "DATABASE_NAME", null);
}
public override void AddDataColumns()
{
! AddDataColumn("pg_database.datistemplate" , "IS_TEMPLATE");
! AddDataColumn("pg_database.datallowconn" , "ALLOW_CONNECTION");
! AddDataColumn("pg_database.datconfig" , "DATABASE_CONFIG");
}
Index: PgDomainsSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgDomainsSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgDomainsSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgDomainsSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,76 ****
public override void AddTables()
{
! AddTable("Pg_type");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_namespace.nspname" , "DOMAIN_SCHEMA", null);
! AddRestrictionColumn("Pg_type.typname" , "DOMAIN_NAME", null);
! AddRestrictionColumn("Pg_type.oid" , "DATA_TYPE", null);
}
public override void AddDataColumns()
{
! AddDataColumn("Pg_type.typlen" , "COLUMN_SIZE");
! AddDataColumn("Pg_type.typnotnull" , "IS_NOT_NULL");
! AddDataColumn("Pg_type.typndims" , "ARRAY_DIMENSIONS");
! AddDataColumn("Pg_type.typelem" , "ELEMENT_TYPE");
! AddDataColumn("Pg_type.typbasetype" , "BASE_TYPE");
! AddDataColumn("Pg_type.typtypmod" , "BASE_TYPE_MODIFIER");
! AddDataColumn("Pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "Pg_namespace" , "Pg_type.typnamespace = Pg_namespace.oid");
! AddJoin("left join", "Pg_description" , "Pg_type.oid = Pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_namespace.nspname");
! AddOrderBy("Pg_type.typname");
}
public override void AddWhereFilters()
{
! AddWhereFilter("Pg_type.typtype = 'd'");
}
--- 37,76 ----
public override void AddTables()
{
! AddTable("pg_type");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_namespace.nspname" , "DOMAIN_SCHEMA", null);
! AddRestrictionColumn("pg_type.typname" , "DOMAIN_NAME", null);
! AddRestrictionColumn("pg_type.oid" , "DATA_TYPE", null);
}
public override void AddDataColumns()
{
! AddDataColumn("pg_type.typlen" , "COLUMN_SIZE");
! AddDataColumn("pg_type.typnotnull" , "IS_NOT_NULL");
! AddDataColumn("pg_type.typndims" , "ARRAY_DIMENSIONS");
! AddDataColumn("pg_type.typelem" , "ELEMENT_TYPE");
! AddDataColumn("pg_type.typbasetype" , "BASE_TYPE");
! AddDataColumn("pg_type.typtypmod" , "BASE_TYPE_MODIFIER");
! AddDataColumn("pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "pg_namespace" , "pg_type.typnamespace = pg_namespace.oid");
! AddJoin("left join", "pg_description" , "pg_type.oid = pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("pg_namespace.nspname");
! AddOrderBy("pg_type.typname");
}
public override void AddWhereFilters()
{
! AddWhereFilter("pg_type.typtype = 'd'");
}
Index: PgForeignKeysSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgForeignKeysSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgForeignKeysSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgForeignKeysSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,48 ****
public override void AddTables()
{
! AddTable("Pg_constraint");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_namespace.nspname" , "PK_TABLE_SCHEMA", null);
AddRestrictionColumn("pk_table.relname" , "PK_TABLE_NAME", null);
! AddRestrictionColumn("Pg_namespace.nspname" , "FK_TABLE_SCHEMA", null);
AddRestrictionColumn("fk_table.relname" , "FK_TABLE_NAME", null);
}
--- 37,48 ----
public override void AddTables()
{
! AddTable("pg_constraint");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_namespace.nspname" , "PK_TABLE_SCHEMA", null);
AddRestrictionColumn("pk_table.relname" , "PK_TABLE_NAME", null);
! AddRestrictionColumn("pg_namespace.nspname" , "FK_TABLE_SCHEMA", null);
AddRestrictionColumn("fk_table.relname" , "FK_TABLE_NAME", null);
}
***************
*** 50,76 ****
public override void AddDataColumns()
{
! AddDataColumn("Pg_constraint.conkey" , "PK_COLUMNS");
! AddDataColumn("Pg_constraint.confkey" , "FK_COLUMNS");
! AddDataColumn(getRuleExpression("Pg_constraint.confupdtype"), "UPDATE_RULE");
! AddDataColumn(getRuleExpression("Pg_constraint.confdeltype"), "DELETE_RULE");
! AddDataColumn("Pg_constraint.conname" , "FK_NAME");
! AddDataColumn("Pg_constraint.condeferrable" , "DEFERRABILITY");
! AddDataColumn("Pg_constraint.condeferred" , "IS_DEFERRED");
! AddDataColumn("Pg_description.description" , "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join" , "Pg_namespace", "Pg_constraint.connamespace = Pg_namespace.oid");
! AddJoin("left join" , "Pg_class as pk_table", "Pg_constraint.conrelid = pk_table.oid");
! AddJoin("right join", "Pg_class as fk_table", "Pg_constraint.confrelid = fk_table.oid");
! AddJoin("left join" , "Pg_description", "Pg_constraint.oid = Pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_namespace.nspname");
AddOrderBy("pk_table.relname");
! AddOrderBy("Pg_constraint.conname");
}
--- 50,76 ----
public override void AddDataColumns()
{
! AddDataColumn("pg_constraint.conkey" , "PK_COLUMNS");
! AddDataColumn("pg_constraint.confkey" , "FK_COLUMNS");
! AddDataColumn(getRuleExpression("pg_constraint.confupdtype"), "UPDATE_RULE");
! AddDataColumn(getRuleExpression("pg_constraint.confdeltype"), "DELETE_RULE");
! AddDataColumn("pg_constraint.conname" , "FK_NAME");
! AddDataColumn("pg_constraint.condeferrable" , "DEFERRABILITY");
! AddDataColumn("pg_constraint.condeferred" , "IS_DEFERRED");
! AddDataColumn("pg_description.description" , "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join" , "pg_namespace", "pg_constraint.connamespace = pg_namespace.oid");
! AddJoin("left join" , "pg_class as pk_table", "pg_constraint.conrelid = pk_table.oid");
! AddJoin("right join", "pg_class as fk_table", "pg_constraint.confrelid = fk_table.oid");
! AddJoin("left join" , "pg_description", "pg_constraint.oid = pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("pg_namespace.nspname");
AddOrderBy("pk_table.relname");
! AddOrderBy("pg_constraint.conname");
}
***************
*** 78,82 ****
{
// Get Only Primary Key information
! AddWhereFilter("Pg_constraint.contype = 'f'");
}
--- 78,82 ----
{
// Get Only Primary Key information
! AddWhereFilter("pg_constraint.contype = 'f'");
}
Index: PgFunctionPrivilegesSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgFunctionPrivilegesSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgFunctionPrivilegesSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgFunctionPrivilegesSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,63 ****
public override void AddTables()
{
! AddTable("Pg_proc");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_namespace.nspname" , "FUNCTION_SCHEMA", null);
! AddRestrictionColumn("Pg_proc.proname" , "FUNCTION_NAME", null);
}
public override void AddDataColumns()
{
! AddDataColumn("Pg_proc.proacl", "PRIVILEGES");
}
public override void AddJoins()
{
! AddJoin("left join", "Pg_namespace" , "Pg_proc.pronamespace = Pg_namespace.oid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_namespace.nspname");
! AddOrderBy("Pg_proc.proname");
}
--- 37,63 ----
public override void AddTables()
{
! AddTable("pg_proc");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_namespace.nspname" , "FUNCTION_SCHEMA", null);
! AddRestrictionColumn("pg_proc.proname" , "FUNCTION_NAME", null);
}
public override void AddDataColumns()
{
! AddDataColumn("pg_proc.proacl", "PRIVILEGES");
}
public override void AddJoins()
{
! AddJoin("left join", "pg_namespace" , "pg_proc.pronamespace = pg_namespace.oid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("pg_namespace.nspname");
! AddOrderBy("pg_proc.proname");
}
Index: PgFunctionsSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgFunctionsSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgFunctionsSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgFunctionsSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,75 ****
public override void AddTables()
{
! AddTable("Pg_proc");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_namespace.nspname" , "FUNCTION_SCHEMA", null);
! AddRestrictionColumn("Pg_proc.proname" , "FUNCTION_NAME", null);
}
public override void AddDataColumns()
{
! AddDataColumn("Pg_language.lanname" , "PROCEDURE_LANGUAGE");
! AddDataColumn("Pg_proc.proisagg" , "IS_AGGREGATE");
! AddDataColumn("Pg_proc.prosecdef" , "IS_SECURITY_DEFINER");
! AddDataColumn("Pg_proc.proisstrict" , "IS_STRICT");
! AddDataColumn(getVolatileExpression("Pg_proc.provolatile") , "VOLATILE");
! AddDataColumn("Pg_proc.proretset" , "RETURNS_SET");
! AddDataColumn("Pg_proc.prorettype" , "RETURN_TYPE");
! AddDataColumn("Pg_proc.pronargs" , "ARGUMENT_NUMBER");
! AddDataColumn("Pg_proc.proargtypes" , "ARGUMENTS");
! AddDataColumn("Pg_proc.prosrc" , "SOURCE");
! AddDataColumn("Pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "Pg_namespace" , "Pg_proc.pronamespace = Pg_namespace.oid");
! AddJoin("left join", "Pg_language" , "Pg_proc.prolang = Pg_language.oid");
! AddJoin("left join", "Pg_description", "Pg_proc.oid = Pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_namespace.nspname");
! AddOrderBy("Pg_proc.proname");
}
--- 37,75 ----
public override void AddTables()
{
! AddTable("pg_proc");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_namespace.nspname" , "FUNCTION_SCHEMA", null);
! AddRestrictionColumn("pg_proc.proname" , "FUNCTION_NAME", null);
}
public override void AddDataColumns()
{
! AddDataColumn("pg_language.lanname" , "PROCEDURE_LANGUAGE");
! AddDataColumn("pg_proc.proisagg" , "IS_AGGREGATE");
! AddDataColumn("pg_proc.prosecdef" , "IS_SECURITY_DEFINER");
! AddDataColumn("pg_proc.proisstrict" , "IS_STRICT");
! AddDataColumn(getVolatileExpression("pg_proc.provolatile") , "VOLATILE");
! AddDataColumn("pg_proc.proretset" , "RETURNS_SET");
! AddDataColumn("pg_proc.prorettype" , "RETURN_TYPE");
! AddDataColumn("pg_proc.pronargs" , "ARGUMENT_NUMBER");
! AddDataColumn("pg_proc.proargtypes" , "ARGUMENTS");
! AddDataColumn("pg_proc.prosrc" , "SOURCE");
! AddDataColumn("pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "pg_namespace" , "pg_proc.pronamespace = pg_namespace.oid");
! AddJoin("left join", "pg_language" , "pg_proc.prolang = pg_language.oid");
! AddJoin("left join", "pg_description", "pg_proc.oid = pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("pg_namespace.nspname");
! AddOrderBy("pg_proc.proname");
}
Index: PgGroupsSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgGroupsSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgGroupsSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgGroupsSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,51 ****
public override void AddTables()
{
! AddTable("Pg_group");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_group.groname", "GROUP_NAME", null);
}
public override void AddDataColumns()
{
! AddRestrictionColumn("Pg_group.grolist", "GROUP_USERS", null);
}
--- 37,51 ----
public override void AddTables()
{
! AddTable("pg_group");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_group.groname", "GROUP_NAME", null);
}
public override void AddDataColumns()
{
! AddRestrictionColumn("pg_group.grolist", "GROUP_USERS", null);
}
***************
*** 56,60 ****
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_group.groname");
}
--- 56,60 ----
public override void AddOrderByColumns()
{
! AddOrderBy("pg_group.groname");
}
Index: PgIndexesSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgIndexesSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgIndexesSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgIndexesSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,48 ****
public override void AddTables()
{
! AddTable("Pg_index");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_namespace.nspname" , "TABLE_SCHEMA", null);
! AddRestrictionColumn("Pg_class.relname" , "TABLE_NAME", null);
! AddRestrictionColumn("Pg_classidx.relname" , "INDEX_NAME", null);
}
--- 37,48 ----
public override void AddTables()
{
! AddTable("pg_index");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_namespace.nspname" , "TABLE_SCHEMA", null);
! AddRestrictionColumn("pg_class.relname" , "TABLE_NAME", null);
! AddRestrictionColumn("pg_classidx.relname" , "INDEX_NAME", null);
}
***************
*** 50,79 ****
{
AddDataColumn("Pgnamespidx.nspname" , "INDEX_SCHEMA");
! AddDataColumn("Pg_am.amname" , "TYPE");
! AddDataColumn("Pg_index.indkey" , "INDEX_KEY");
! AddDataColumn("Pg_index.indisclustered" , "CLUSTERED");
! AddDataColumn("Pg_index.indisunique" , "UNIQUE");
! AddDataColumn("Pg_index.indisprimary" , "PRIMARY");
! AddDataColumn("Pg_am.amindexnulls" , "ALLOW_NULLS");
! AddDataColumn("Pg_am.amcanmulticol" , "MULTICOLUMN");
! AddDataColumn("Pg_am.amconcurrent" , "CONCURRENT");
! AddDataColumn("Pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "Pg_class", "Pg_index.indrelid = Pg_class.oid");
! AddJoin("left join", "Pg_class as Pg_classidx", "Pg_index.indexrelid = Pg_classidx.oid");
! AddJoin("left join", "Pg_namespace", "Pg_classidx.relnamespace = Pg_namespace.oid");
! AddJoin("left join", "Pg_namespace as Pgnamespidx", "Pg_classidx.relnamespace = Pgnamespidx.oid");
! AddJoin("left join", "Pg_am", "Pg_classidx.relam = Pg_am.oid");
! AddJoin("left join", "Pg_description", "Pg_index.indexrelid = Pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_namespace.nspname");
! AddOrderBy("Pg_class.relname");
! AddOrderBy("Pg_classidx.relname");
}
--- 50,79 ----
{
AddDataColumn("Pgnamespidx.nspname" , "INDEX_SCHEMA");
! AddDataColumn("pg_am.amname" , "TYPE");
! AddDataColumn("pg_index.indkey" , "INDEX_KEY");
! AddDataColumn("pg_index.indisclustered" , "CLUSTERED");
! AddDataColumn("pg_index.indisunique" , "UNIQUE");
! AddDataColumn("pg_index.indisprimary" , "PRIMARY");
! AddDataColumn("pg_am.amindexnulls" , "ALLOW_NULLS");
! AddDataColumn("pg_am.amcanmulticol" , "MULTICOLUMN");
! AddDataColumn("pg_am.amconcurrent" , "CONCURRENT");
! AddDataColumn("pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "pg_class", "pg_index.indrelid = pg_class.oid");
! AddJoin("left join", "pg_class as pg_classidx", "pg_index.indexrelid = pg_classidx.oid");
! AddJoin("left join", "pg_namespace", "pg_classidx.relnamespace = pg_namespace.oid");
! AddJoin("left join", "pg_namespace as Pgnamespidx", "pg_classidx.relnamespace = Pgnamespidx.oid");
! AddJoin("left join", "pg_am", "pg_classidx.relam = pg_am.oid");
! AddJoin("left join", "pg_description", "pg_index.indexrelid = pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("pg_namespace.nspname");
! AddOrderBy("pg_class.relname");
! AddOrderBy("pg_classidx.relname");
}
Index: PgPrimaryKeysSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgPrimaryKeysSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgPrimaryKeysSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgPrimaryKeysSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,68 ****
public override void AddTables()
{
! AddTable("Pg_constraint");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_namespace.nspname" , "TABLE_SCHEMA", null);
! AddRestrictionColumn("Pg_class.relname" , "TABLE_NAME", null);
}
public override void AddDataColumns()
{
! AddDataColumn("Pg_constraint.conname" , "PK_NAME");
! AddDataColumn("Pg_constraint.conkey" , "PK_COLUMNS");
! AddDataColumn("Pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "Pg_class", "Pg_constraint.conrelid = Pg_class.oid");
! AddJoin("left join", "Pg_namespace", "Pg_constraint.connamespace = Pg_namespace.oid");
! AddJoin("left join", "Pg_description", "Pg_constraint.oid = Pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_namespace.nspname");
! AddOrderBy("Pg_class.relname");
! AddOrderBy("Pg_constraint.conname");
}
--- 37,68 ----
public override void AddTables()
{
! AddTable("pg_constraint");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_namespace.nspname" , "TABLE_SCHEMA", null);
! AddRestrictionColumn("pg_class.relname" , "TABLE_NAME", null);
}
public override void AddDataColumns()
{
! AddDataColumn("pg_constraint.conname" , "PK_NAME");
! AddDataColumn("pg_constraint.conkey" , "PK_COLUMNS");
! AddDataColumn("pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "pg_class", "pg_constraint.conrelid = pg_class.oid");
! AddJoin("left join", "pg_namespace", "pg_constraint.connamespace = pg_namespace.oid");
! AddJoin("left join", "pg_description", "pg_constraint.oid = pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("pg_namespace.nspname");
! AddOrderBy("pg_class.relname");
! AddOrderBy("pg_constraint.conname");
}
***************
*** 70,74 ****
{
// Get Only Primary Key information
! AddWhereFilter("Pg_constraint.contype = 'p'");
}
--- 70,74 ----
{
// Get Only Primary Key information
! AddWhereFilter("pg_constraint.contype = 'p'");
}
Index: PgProviderTypesSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgProviderTypesSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgProviderTypesSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgProviderTypesSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,70 ****
public override void AddTables()
{
! AddTable("Pg_type");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_namespace.nspname", "TYPE_SCHEMA", null);
! AddRestrictionColumn("Pg_type.typname", "TYPE_NAME", null);
! AddRestrictionColumn("Pg_type.oid", "DATA_TYPE", null);
}
public override void AddDataColumns()
{
! AddDataColumn("Pg_type.typlen", "COLUMN_SIZE");
! AddDataColumn("Pg_type.typnotnull", "IS_NOT_NULL");
! AddDataColumn("Pg_type.typndims", "ARRAY_DIMENSIONS");
! AddDataColumn("Pg_type.typelem", "ELEMENT_TYPE");
! AddDataColumn("Pg_type.typbasetype", "BASE_TYPE");
! AddDataColumn("Pg_type.typtypmod", "BASE_TYPE_MODIFIER");
! AddDataColumn("Pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "Pg_namespace", "Pg_type.typnamespace = Pg_namespace.oid");
! AddJoin("left join", "Pg_description", "Pg_type.oid = Pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_type.typname");
}
--- 37,70 ----
public override void AddTables()
{
! AddTable("pg_type");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_namespace.nspname", "TYPE_SCHEMA", null);
! AddRestrictionColumn("pg_type.typname", "TYPE_NAME", null);
! AddRestrictionColumn("pg_type.oid", "DATA_TYPE", null);
}
public override void AddDataColumns()
{
! AddDataColumn("pg_type.typlen", "COLUMN_SIZE");
! AddDataColumn("pg_type.typnotnull", "IS_NOT_NULL");
! AddDataColumn("pg_type.typndims", "ARRAY_DIMENSIONS");
! AddDataColumn("pg_type.typelem", "ELEMENT_TYPE");
! AddDataColumn("pg_type.typbasetype", "BASE_TYPE");
! AddDataColumn("pg_type.typtypmod", "BASE_TYPE_MODIFIER");
! AddDataColumn("pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "pg_namespace", "pg_type.typnamespace = pg_namespace.oid");
! AddJoin("left join", "pg_description", "pg_type.oid = pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("pg_type.typname");
}
Index: PgSchemataSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgSchemataSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgSchemataSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgSchemataSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,64 ****
public override void AddTables()
{
! AddTable("Pg_namespace");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_namespace.nspname", "SCHEMA_NAME", null);
! AddRestrictionColumn("Pg_shadow.usename", "SCHEMA_OWNER", null);
}
public override void AddDataColumns()
{
! AddDataColumn("Pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "Pg_shadow", "Pg_namespace.nspowner = Pg_shadow.usesysid");
! AddJoin("left join", "Pg_description", "Pg_namespace.oid = Pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_namespace.nspname");
! AddOrderBy("Pg_shadow.usename");
}
--- 37,64 ----
public override void AddTables()
{
! AddTable("pg_namespace");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_namespace.nspname", "SCHEMA_NAME", null);
! AddRestrictionColumn("pg_shadow.usename", "SCHEMA_OWNER", null);
}
public override void AddDataColumns()
{
! AddDataColumn("pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "pg_shadow", "pg_namespace.nspowner = pg_shadow.usesysid");
! AddJoin("left join", "pg_description", "pg_namespace.oid = pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("pg_namespace.nspname");
! AddOrderBy("pg_shadow.usename");
}
Index: PgSqlLanguagesSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgSqlLanguagesSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgSqlLanguagesSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgSqlLanguagesSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,41 ****
public override void AddTables()
{
! AddTable("Pg_language");
}
--- 37,41 ----
public override void AddTables()
{
! AddTable("pg_language");
}
***************
*** 46,66 ****
public override void AddDataColumns()
{
! AddDataColumn("Pg_language.lanname", "LANGUAGE_NAME");
! AddDataColumn("Pg_language.lanispl", "IS_USER_DEFINED");
! AddDataColumn("Pg_proc.proname", "CALL_FUNCTION");
! AddDataColumn("Pg_procv.proname", "VALIDATOR");
! AddDataColumn("Pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "Pg_proc", "Pg_language.lanplcallfoid = Pg_proc.oid");
! AddJoin("left join", "Pg_proc as Pg_procv", "Pg_language.lanvalidator = Pg_procv.oid");
! AddJoin("left join", "Pg_description", "Pg_language.oid = Pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_language.lanname");
}
--- 46,66 ----
public override void AddDataColumns()
{
! AddDataColumn("pg_language.lanname", "LANGUAGE_NAME");
! AddDataColumn("pg_language.lanispl", "IS_USER_DEFINED");
! AddDataColumn("pg_proc.proname", "CALL_FUNCTION");
! AddDataColumn("pg_procv.proname", "VALIDATOR");
! AddDataColumn("pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "pg_proc", "pg_language.lanplcallfoid = pg_proc.oid");
! AddJoin("left join", "pg_proc as pg_procv", "pg_language.lanvalidator = pg_procv.oid");
! AddJoin("left join", "pg_description", "pg_language.oid = pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("pg_language.lanname");
}
Index: PgTableConstraintsSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgTableConstraintsSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgTableConstraintsSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgTableConstraintsSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,72 ****
public override void AddTables()
{
! AddTable("Pg_constraint");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_schemacon.nspname", "CONSTRAINT_SCHEMA", null);
! AddRestrictionColumn("Pg_constraint.conname", "CONSTRAINT_NAME", null);
! AddRestrictionColumn("Pg_namespace.nspname", "TABLE_SCHEMA", null);
! AddRestrictionColumn("Pg_class.relname", "TABLE_NAME", null);
! AddRestrictionColumn(getConstraintTypeExpression("Pg_constraint.contype"), "CONSTRAINT_TYPE", "Pg_constraint.contype");
}
public override void AddDataColumns()
{
! AddDataColumn("Pg_constraint.condeferrable", "IS_DEFERRABLE");
! AddDataColumn("Pg_constraint.condeferred", "INITIALLY_DEFERRED");
! AddDataColumn("Pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "Pg_class", "Pg_class.oid = Pg_constraint.conrelid");
! AddJoin("left join", "Pg_namespace", "Pg_class.relnamespace = Pg_namespace.oid");
! AddJoin("left join", "Pg_namespace as Pg_schemacon", "Pg_constraint.connamespace = Pg_schemacon.oid");
! AddJoin("left join", "Pg_description", "Pg_constraint.oid = Pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_schemacon.nspname");
! AddOrderBy("Pg_class.relname");
! AddOrderBy("Pg_constraint.conname");
}
--- 37,72 ----
public override void AddTables()
{
! AddTable("pg_constraint");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_schemacon.nspname", "CONSTRAINT_SCHEMA", null);
! AddRestrictionColumn("pg_constraint.conname", "CONSTRAINT_NAME", null);
! AddRestrictionColumn("pg_namespace.nspname", "TABLE_SCHEMA", null);
! AddRestrictionColumn("pg_class.relname", "TABLE_NAME", null);
! AddRestrictionColumn(getConstraintTypeExpression("pg_constraint.contype"), "CONSTRAINT_TYPE", "pg_constraint.contype");
}
public override void AddDataColumns()
{
! AddDataColumn("pg_constraint.condeferrable", "IS_DEFERRABLE");
! AddDataColumn("pg_constraint.condeferred", "INITIALLY_DEFERRED");
! AddDataColumn("pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "pg_class", "pg_class.oid = pg_constraint.conrelid");
! AddJoin("left join", "pg_namespace", "pg_class.relnamespace = pg_namespace.oid");
! AddJoin("left join", "pg_namespace as pg_schemacon", "pg_constraint.connamespace = pg_schemacon.oid");
! AddJoin("left join", "pg_description", "pg_constraint.oid = pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("pg_schemacon.nspname");
! AddOrderBy("pg_class.relname");
! AddOrderBy("pg_constraint.conname");
}
Index: PgTablePrivilegesSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgTablePrivilegesSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgTablePrivilegesSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgTablePrivilegesSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 38,69 ****
public override void AddTables()
{
! AddTable("Pg_class");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_namespace.nspname" , "TABLE_SCHEMA", null);
! AddRestrictionColumn("Pg_class.relname" , "TABLE_NAME", null);
}
public override void AddDataColumns()
{
! AddDataColumn("Pg_class.relacl", "PRIVILEGES");
}
public override void AddJoins()
{
! AddJoin("left join", "Pg_namespace", "Pg_class.relnamespace = Pg_namespace.oid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_namespace.nspname");
! AddOrderBy("Pg_class.relname");
}
public override void AddWhereFilters()
{
! AddWhereFilter("Pg_class.relkind = 'r'");
}
--- 38,69 ----
public override void AddTables()
{
! AddTable("pg_class");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_namespace.nspname" , "TABLE_SCHEMA", null);
! AddRestrictionColumn("pg_class.relname" , "TABLE_NAME", null);
}
public override void AddDataColumns()
{
! AddDataColumn("pg_class.relacl", "PRIVILEGES");
}
public override void AddJoins()
{
! AddJoin("left join", "pg_namespace", "pg_class.relnamespace = pg_namespace.oid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("pg_namespace.nspname");
! AddOrderBy("pg_class.relname");
}
public override void AddWhereFilters()
{
! AddWhereFilter("pg_class.relkind = 'r'");
}
Index: PgTablesSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgTablesSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgTablesSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgTablesSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,78 ****
public override void AddTables()
{
! AddTable("Pg_class");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_namespace.nspname" , "TABLE_SCHEMA", null);
! AddRestrictionColumn("Pg_class.relname" , "TABLE_NAME", null);
! AddRestrictionColumn(getTableTypeExpression("Pg_class.relkind"), "TABLE_TYPE", "Pg_class.relkind");
}
public override void AddDataColumns()
{
! AddDataColumn("Pg_class.relhasindex" , "HAS_INDEXES");
! AddDataColumn("Pg_class.relisshared" , "IS_SHARED");
! AddDataColumn("Pg_class.relchecks" , "CONSTRAINT_COUNT");
! AddDataColumn("Pg_class.reltriggers" , "TRIGGER_COUNT");
! AddDataColumn("Pg_class.relhaspkey" , "HAS_PRIMARY");
! AddDataColumn("Pg_class.relhasrules" , "HAS_RULES");
! AddDataColumn("Pg_class.relhassubclass" , "HAS_SUBCLASS");
! AddDataColumn("Pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "Pg_namespace" , "Pg_class.relnamespace = Pg_namespace.oid");
! AddJoin("left join", "Pg_description" , "Pg_class.oid = Pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_class.relkind");
! AddOrderBy("Pg_namespace.nspname");
! AddOrderBy("Pg_class.relname");
}
public override void AddWhereFilters()
{
! AddWhereFilter("Pg_class.relkind = 'r'");
}
--- 37,78 ----
public override void AddTables()
{
! AddTable("pg_class");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_namespace.nspname" , "TABLE_SCHEMA", null);
! AddRestrictionColumn("pg_class.relname" , "TABLE_NAME", null);
! AddRestrictionColumn(getTableTypeExpression("pg_class.relkind"), "TABLE_TYPE", "pg_class.relkind");
}
public override void AddDataColumns()
{
! AddDataColumn("pg_class.relhasindex" , "HAS_INDEXES");
! AddDataColumn("pg_class.relisshared" , "IS_SHARED");
! AddDataColumn("pg_class.relchecks" , "CONSTRAINT_COUNT");
! AddDataColumn("pg_class.reltriggers" , "TRIGGER_COUNT");
! AddDataColumn("pg_class.relhaspkey" , "HAS_PRIMARY");
! AddDataColumn("pg_class.relhasrules" , "HAS_RULES");
! AddDataColumn("pg_class.relhassubclass" , "HAS_SUBCLASS");
! AddDataColumn("pg_description.description", "DESCRIPTION");
}
public override void AddJoins()
{
! AddJoin("left join", "pg_namespace" , "pg_class.relnamespace = pg_namespace.oid");
! AddJoin("left join", "pg_description" , "pg_class.oid = pg_description.objoid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("pg_class.relkind");
! AddOrderBy("pg_namespace.nspname");
! AddOrderBy("pg_class.relname");
}
public override void AddWhereFilters()
{
! AddWhereFilter("pg_class.relkind = 'r'");
}
Index: PgTableStatisticsSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgTableStatisticsSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgTableStatisticsSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgTableStatisticsSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 38,74 ****
public override void AddTables()
{
! AddTable("Pg_class");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_namespace.nspname" , "TABLE_SCHEMA", null);
! AddRestrictionColumn("Pg_class.relname" , "TABLE_NAME", null);
! AddRestrictionColumn("Pg_namespace.staattnum", "ORDINAL_POSITION", null);
}
public override void AddDataColumns()
{
! AddDataColumn("Pg_statistic.stanullfrac", "FRACTION");
! AddDataColumn("Pg_statistic.stawidth" , "WIDTH");
! AddDataColumn("Pg_statistic.stadistinc" , "DISTINCT");
! AddDataColumn("Pg_statistic.stakind" , "KIND");
! AddDataColumn("Pg_statistic.stanumbers" , "NUMERICAL_STATISTICS");
}
public override void AddJoins()
{
! AddJoin("left join", "Pg_statistic", "Pg_class.oid = Pgstatistic.starelid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_namespace.nspname");
! AddOrderBy("Pg_class.relname");
}
public override void AddWhereFilters()
{
! AddWhereFilter("Pg_class.relkind = 'r'");
}
--- 38,74 ----
public override void AddTables()
{
! AddTable("pg_class");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_namespace.nspname" , "TABLE_SCHEMA", null);
! AddRestrictionColumn("pg_class.relname" , "TABLE_NAME", null);
! AddRestrictionColumn("pg_namespace.staattnum", "ORDINAL_POSITION", null);
}
public override void AddDataColumns()
{
! AddDataColumn("pg_statistic.stanullfrac", "FRACTION");
! AddDataColumn("pg_statistic.stawidth" , "WIDTH");
! AddDataColumn("pg_statistic.stadistinc" , "DISTINCT");
! AddDataColumn("pg_statistic.stakind" , "KIND");
! AddDataColumn("pg_statistic.stanumbers" , "NUMERICAL_STATISTICS");
}
public override void AddJoins()
{
! AddJoin("left join", "pg_statistic", "pg_class.oid = Pgstatistic.starelid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("pg_namespace.nspname");
! AddOrderBy("pg_class.relname");
}
public override void AddWhereFilters()
{
! AddWhereFilter("pg_class.relkind = 'r'");
}
Index: PgTriggersSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgTriggersSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgTriggersSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgTriggersSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,68 ****
public override void AddTables()
{
! AddTable("Pg_trigger");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_namespace.nspname", "PROCEDURE_SCHEMA", null);
! AddRestrictionColumn("Pg_proc.proname", "PROCEDURE_NAME", null);
}
public override void AddDataColumns()
{
! AddDataColumn("Pg_language.lanname", "PROCEDURE_LANGUAGE");
! AddDataColumn("Pg_proc.proisagg", "IS_AGGREGATE");
! AddDataColumn("Pg_proc.prosecdef", "IS_SECURITY_DEFINER");
! AddDataColumn("Pg_proc.proisstrict", "IS_STRICT");
! AddDataColumn("Pg_proc.proretset", "RETURNS_SET");
}
public override void AddJoins()
{
! AddJoin("left join", "Pg_namespace", "Pg_proc.pronamespace = Pg_namespace.oid");
! AddJoin("left join", "Pg_language", "Pg_proc.prolang = Pg_language.oid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_namespace.nspname");
! AddOrderBy("Pg_proc.proname");
}
--- 37,68 ----
public override void AddTables()
{
! AddTable("pg_trigger");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_namespace.nspname", "PROCEDURE_SCHEMA", null);
! AddRestrictionColumn("pg_proc.proname", "PROCEDURE_NAME", null);
}
public override void AddDataColumns()
{
! AddDataColumn("pg_language.lanname", "PROCEDURE_LANGUAGE");
! AddDataColumn("pg_proc.proisagg", "IS_AGGREGATE");
! AddDataColumn("pg_proc.prosecdef", "IS_SECURITY_DEFINER");
! AddDataColumn("pg_proc.proisstrict", "IS_STRICT");
! AddDataColumn("pg_proc.proretset", "RETURNS_SET");
}
public override void AddJoins()
{
! AddJoin("left join", "pg_namespace", "pg_proc.pronamespace = pg_namespace.oid");
! AddJoin("left join", "pg_language", "pg_proc.prolang = pg_language.oid");
}
public override void AddOrderByColumns()
{
! AddOrderBy("pg_namespace.nspname");
! AddOrderBy("pg_proc.proname");
}
Index: PgUsersSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgUsersSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgUsersSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgUsersSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,55 ****
public override void AddTables()
{
! AddTable("Pg_shadow");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_shadow.usename", "USER_NAME", null);
}
public override void AddDataColumns()
{
! AddDataColumn("Pg_shadow.usecreatedb", "CREATE_DATABASE");
! AddDataColumn("Pg_shadow.usesuper", "IS_SUPERUSER");
! AddDataColumn("Pg_shadow.usecatupd", "UPDATE_SYSCATALOGS");
! AddDataColumn("Pg_shadow.passwd", "PASSWORD");
! AddDataColumn("Pg_shadow.useconfig", "CONFIGURATION");
}
--- 37,55 ----
public override void AddTables()
{
! AddTable("pg_shadow");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("pg_shadow.usename", "USER_NAME", null);
}
public override void AddDataColumns()
{
! AddDataColumn("pg_shadow.usecreatedb", "CREATE_DATABASE");
! AddDataColumn("pg_shadow.usesuper", "IS_SUPERUSER");
! AddDataColumn("pg_shadow.usecatupd", "UPDATE_SYSCATALOGS");
! AddDataColumn("pg_shadow.passwd", "PASSWORD");
! AddDataColumn("pg_shadow.useconfig", "CONFIGURATION");
}
***************
*** 60,64 ****
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_shadow.usename");
}
--- 60,64 ----
public override void AddOrderByColumns()
{
! AddOrderBy("pg_shadow.usename");
}
Index: PgViewPrivilegesSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/DbSchema/PgViewPrivilegesSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PgViewPrivilegesSchema.cs 2 Aug 2003 19:43:01 -0000 1.1.1.1
--- PgViewPrivilegesSchema.cs 2 Aug 2003 21:11:37 -0000 1.2
***************
*** 37,69 ****
public override void AddTables()
{
! AddTable("Pg_class");
}
public override void AddRestrictionColumns()
{
! AddRestrictionColumn("Pg_namespace.nspname", "VIEW_SCHEMA", null);
! AddRestrictionColumn("Pg_class.relname", "VIEW_NAME", null);
}
public override void AddDataColumns()
{
! AddDataColumn("Pg_class.relacl", "PRIVILEGES");
}
public override void AddJoins()
{
! AddJoin("left join", "Pg_namespace", "Pg_class.relnamespace = Pg_namespace.oid");
! AddJoin("left join", "Pg_rewrite", "Pg_class.oid = Pg_rewrite.ev_class");
}
public override void AddOrderByColumns()
{
! AddOrderBy("Pg_namespace.nspname");
! AddOrderBy("Pg_class.relname");
}
public override void AddWhereFilters()
{
! AddWhereFilter("Pg_class.relkind = 'v'");
}
--- 37,69 ----
pu...
[truncated message content] |
