[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient/source/DbSchema PGDomainsSchema.cs,1.
Status: Inactive
Brought to you by:
carlosga_fb
Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/DbSchema
In directory sc8-pr-cvs1:/tmp/cvs-serv22809
Modified Files:
PGDomainsSchema.cs PGForeignKeysSchema.cs PGFunctionsSchema.cs
PGIndexesSchema.cs PGPrimaryKeysSchema.cs
Log Message:
Minor changes to db schema support
Index: PGDomainsSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/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 12 Jul 2003 08:11:22 -0000 1.1.1.1
--- PGDomainsSchema.cs 21 Jul 2003 19:53:35 -0000 1.2
***************
*** 42,58 ****
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");
}
--- 42,58 ----
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");
}
***************
*** 60,65 ****
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");
}
--- 60,65 ----
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");
}
Index: PGForeignKeysSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/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 12 Jul 2003 08:11:22 -0000 1.1.1.1
--- PGForeignKeysSchema.cs 21 Jul 2003 19:53:35 -0000 1.2
***************
*** 42,69 ****
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);
}
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");
}
--- 42,69 ----
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);
}
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");
}
Index: PGFunctionsSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/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 12 Jul 2003 08:11:22 -0000 1.1.1.1
--- PGFunctionsSchema.cs 21 Jul 2003 19:53:35 -0000 1.2
***************
*** 42,56 ****
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");
AddDataColumn("pg_description.description", "DESCRIPTION");
}
--- 42,56 ----
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");
AddDataColumn("pg_description.description", "DESCRIPTION");
}
***************
*** 58,63 ****
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");
}
--- 58,63 ----
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");
}
Index: PGIndexesSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/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 12 Jul 2003 08:11:22 -0000 1.1.1.1
--- PGIndexesSchema.cs 21 Jul 2003 19:53:35 -0000 1.2
***************
*** 42,61 ****
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);
}
public override void AddDataColumns()
{
! 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");
}
--- 42,61 ----
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);
}
public override void AddDataColumns()
{
! 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");
}
Index: PGPrimaryKeysSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/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 12 Jul 2003 08:11:22 -0000 1.1.1.1
--- PGPrimaryKeysSchema.cs 21 Jul 2003 19:53:35 -0000 1.2
***************
*** 42,53 ****
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");
}
--- 42,53 ----
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");
}
|