pgsqlclient-checkins Mailing List for PostgreSqlClient (Page 53)

Status: Inactive

Brought to you by: carlosga_fb

pgsqlclient-checkins — Mailing list for CVS commit messages.

You can subscribe to this list here.

2003	_Jan	_Feb	_Mar	_Apr	_May	_Jun	_Jul (120)	_Aug (95)	_Sep (95)	_Oct (213)	_Nov (114)	_Dec (64)
2004	_Jan (6)	_Feb (134)	_Mar (88)	_Apr (28)	_May (22)	_Jun (15)	_Jul (23)	_Aug (2)	_Sep (15)	_Oct (2)	_Nov (6)	_Dec
2005	_Jan (8)	_Feb (6)	_Mar	_Apr (42)	_May (3)	_Jun	_Jul	_Aug	_Sep (84)	_Oct	_Nov	_Dec
2006	_Jan	_Feb	_Mar (84)	_Apr (46)	_May (40)	_Jun (8)	_Jul	_Aug	_Sep	_Oct	_Nov	_Dec

Flat | Threaded

<< < 1 .. 51 52 53 54 55 > >> (Page 53 of 55)

[pgsqlclient-checkins] pgsqlclient PGSqlClient.build,1.3,1.4

From: <car...@us...> - 2003-07-22 09:35:15

Update of /cvsroot/pgsqlclient/pgsqlclient
In directory sc8-pr-cvs1:/tmp/cvs-serv19538

Modified Files:
	PGSqlClient.build 
Log Message:
Changed build file for use new NUnit v2.1.

Index: PGSqlClient.build
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PGSqlClient.build,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** PGSqlClient.build	19 Jul 2003 10:13:50 -0000	1.3
--- PGSqlClient.build	22 Jul 2003 09:35:10 -0000	1.4
***************
*** 36,40 ****
  		<ifnot propertyexists="nunit.framework.dll">
  			<sysinfo />
! 			<property name="nunit.framework.dll" value="${sys.os.folder.programfiles}\NUnit V2.0\bin\nunit.framework.dll"
  				readonly="false" />
  		</ifnot>
--- 36,40 ----
  		<ifnot propertyexists="nunit.framework.dll">
  			<sysinfo />
! 			<property name="nunit.framework.dll" value="${sys.os.folder.programfiles}\NUnit V2.1\bin\nunit.framework.dll"
  				readonly="false" />
  		</ifnot>

[pgsqlclient-checkins] pgsqlclient changelog.txt,1.19,1.20

From: <car...@us...> - 2003-07-21 19:56:04

Update of /cvsroot/pgsqlclient/pgsqlclient
In directory sc8-pr-cvs1:/tmp/cvs-serv23142

Modified Files:
	changelog.txt 
Log Message:
Minor changes to db schema support

Index: changelog.txt
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v
retrieving revision 1.19
retrieving revision 1.20
diff -C2 -d -r1.19 -r1.20
*** changelog.txt	20 Jul 2003 10:00:42 -0000	1.19
--- changelog.txt	21 Jul 2003 19:56:01 -0000	1.20
***************
*** 2,5 ****
--- 2,9 ----
  -------------------------------------------------------
  
+ 2003-07-21 Carlos Guzmán Álvarez  <car...@te...>
+ 
+ 		* Minor changes to db schema support
+ 
  
  2003-07-20 Carlos Guzmán Álvarez  <car...@te...>

[pgsqlclient-checkins] pgsqlclient/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 PGColumnsSchema.cs,1.1.1.1,1.2 PGDatabaseSchema.cs,1.1.1.1,1.2

From: <car...@us...> - 2003-07-21 19:54:26

Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/DbSchema
In directory sc8-pr-cvs1:/tmp/cvs-serv22922

Modified Files:
	PGAggregatesSchema.cs PGCastsSchema.cs PGCheckConstraints.cs 
	PGColumnsSchema.cs PGDatabaseSchema.cs 
Log Message:
Minor changes to db schema support

Index: PGAggregatesSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/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	12 Jul 2003 08:11:22 -0000	1.1.1.1
--- PGAggregatesSchema.cs	21 Jul 2003 19:54:22 -0000	1.2
***************
*** 47,54 ****
  		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");
  		}
  
--- 47,54 ----
  		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");
  		}
  

Index: PGCastsSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/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	12 Jul 2003 08:11:22 -0000	1.1.1.1
--- PGCastsSchema.cs	21 Jul 2003 19:54:22 -0000	1.2
***************
*** 46,53 ****
  		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");
  		}
--- 46,53 ----
  		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");
  		}
***************
*** 57,62 ****
  			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");			
  		}
  
--- 57,62 ----
  			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");			
  		}
  

Index: PGCheckConstraints.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/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	12 Jul 2003 08:11:22 -0000	1.1.1.1
--- PGCheckConstraints.cs	21 Jul 2003 19:54:22 -0000	1.2
***************
*** 44,52 ****
  			AddRestrictionColumn("pg_namespace.nspname", "CONSTRAINT_SCHEMA", null);
  			AddRestrictionColumn("pg_constraint.conname", "CONSTRAINT_NAME", null);
- 			AddRestrictionColumn("pg_get_constraintdef(pg_constraint.oid)", "CHECK_CLAUSULE", null);
  		}
  
  		public override void AddDataColumns()
  		{
  			AddDataColumn("pg_description.description", "DESCRIPTION");						
  		}
--- 44,52 ----
  			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");						
  		}
***************
*** 54,60 ****
  		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_description", "pg_constraint.oid = pg_description.objoid");
  		}
  
--- 54,60 ----
  		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_description"	, "pg_constraint.oid = pg_description.objoid");
  		}
  

Index: PGColumnsSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/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	12 Jul 2003 08:11:22 -0000	1.1.1.1
--- PGColumnsSchema.cs	21 Jul 2003 19:54:22 -0000	1.2
***************
*** 42,59 ****
  		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");
--- 42,59 ----
  		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");
***************
*** 62,68 ****
  		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");
  		}
--- 62,68 ----
  		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");
  		}

Index: PGDatabaseSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/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	12 Jul 2003 08:11:22 -0000	1.1.1.1
--- PGDatabaseSchema.cs	21 Jul 2003 19:54:22 -0000	1.2
***************
*** 47,53 ****
  		public override void AddDataColumns()
  		{
! 			AddDataColumn("pg_database.datistemplate", "IS_TEMPLATE");
! 			AddDataColumn("pg_database.datallowconn", "ALLOW_CONNECTION");
! 			AddDataColumn("pg_database.datconfig", "DATABASE_CONFIG");
  		}
  
--- 47,53 ----
  		public override void AddDataColumns()
  		{
! 			AddDataColumn("pg_database.datistemplate"	, "IS_TEMPLATE");
! 			AddDataColumn("pg_database.datallowconn"	, "ALLOW_CONNECTION");
! 			AddDataColumn("pg_database.datconfig"		, "DATABASE_CONFIG");
  		}

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient/source/DbSchema PGDomainsSchema.cs,1.1.1.1,1.2 PGForeignKeysSchema.cs,1.1.1.1,1.2 PGFunctionsSchema.cs,1.1.1.1,1.2 PGIndexesSchema.cs,1.1.1.1,1.2 PGPrimaryKeysSchema.cs,1.1.1.1,1.2

From: <car...@us...> - 2003-07-21 19:53:40

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");
  		}

[pgsqlclient-checkins] pgsqlclient changelog.txt,1.18,1.19

From: <car...@us...> - 2003-07-20 10:17:55

Update of /cvsroot/pgsqlclient/pgsqlclient
In directory sc8-pr-cvs1:/tmp/cvs-serv30551

Modified Files:
	changelog.txt 
Log Message:
Updated CHANGELOG.TXT

Index: changelog.txt
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v
retrieving revision 1.18
retrieving revision 1.19
diff -C2 -d -r1.18 -r1.19
*** changelog.txt	19 Jul 2003 10:13:50 -0000	1.18
--- changelog.txt	20 Jul 2003 10:00:42 -0000	1.19
***************
*** 3,6 ****
--- 3,13 ----
  
  
+ 2003-07-20 Carlos Guzmán Álvarez  <car...@te...>
+ 
+ 	* Added new test case for money fields.
+ 
+ 	* Fixed money datatype handling.
+ 
+ 
  2003-07-19 Carlos Guzmán Álvarez  <car...@te...>

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source PGBaseTest.cs,1.5,1.6 PGCommandTest.cs,1.5,1.6 PGDataAdapterTest.cs,1.3,1.4

From: <car...@us...> - 2003-07-20 10:01:22

Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source
In directory sc8-pr-cvs1:/tmp/cvs-serv30632

Modified Files:
	PGBaseTest.cs PGCommandTest.cs PGDataAdapterTest.cs 
Log Message:
* Added new test case for money fields.

* Fixed money datatype handling.

Index: PGBaseTest.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source/PGBaseTest.cs,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** PGBaseTest.cs	18 Jul 2003 22:46:04 -0000	1.5
--- PGBaseTest.cs	20 Jul 2003 10:01:19 -0000	1.6
***************
*** 130,134 ****
  
  			commandText.Append("CREATE TABLE public.test_table(");
! 			commandText.Append("int_field int4 NOT NULL,");
  			commandText.Append("char_field char(10),");
  			commandText.Append("varchar_field varchar(30),");
--- 130,134 ----
  
  			commandText.Append("CREATE TABLE public.test_table(");
! 			commandText.Append("int4_field int4 NOT NULL,");
  			commandText.Append("char_field char(10),");
  			commandText.Append("varchar_field varchar(30),");
***************
*** 141,149 ****
  			commandText.Append("blob_field bytea,");
  			commandText.Append("bool_field bool,");
! 			commandText.Append("bigint_field int8,");
! 			commandText.Append("decimal_field decimal(8,2),");
! 			commandText.Append("smallint_field int2,");
  			commandText.Append("array_int int2[],");
! 			commandText.Append("CONSTRAINT test_table_pkey PRIMARY KEY (int_field)");
  			commandText.Append(") WITH OIDS;");
              
--- 141,150 ----
  			commandText.Append("blob_field bytea,");
  			commandText.Append("bool_field bool,");
! 			commandText.Append("int2_field int2,");
! 			commandText.Append("int8_field int8,");
! 			commandText.Append("money_field money,");
! 			commandText.Append("numeric_field numeric(8,2),");			
  			commandText.Append("array_int int2[],");
! 			commandText.Append("CONSTRAINT test_table_pkey PRIMARY KEY (int4_field)");
  			commandText.Append(") WITH OIDS;");
              
***************
*** 157,161 ****
  		private void insertTestData()
  		{
! 			string commandText = "insert into public.test_table values(@int_field, @char_field, @varchar_field, @single_field, @double_field, @date_Field, @time_field, @timestamp_field)";
  
  			PGTransaction transaction = connection.BeginTransaction();
--- 158,162 ----
  		private void insertTestData()
  		{
! 			string commandText = "insert into public.test_table values(@int4_field, @char_field, @varchar_field, @single_field, @double_field, @date_Field, @time_field, @timestamp_field)";
  
  			PGTransaction transaction = connection.BeginTransaction();
***************
*** 165,169 ****
  			{
  				// Add command parameters
! 				command.Parameters.Add("@int_field", PGDbType.Int4);
  				command.Parameters.Add("@char_field", PGDbType.Char);
  				command.Parameters.Add("@varchar_field", PGDbType.VarChar);
--- 166,170 ----
  			{
  				// Add command parameters
! 				command.Parameters.Add("@int4_field", PGDbType.Int4);
  				command.Parameters.Add("@char_field", PGDbType.Char);
  				command.Parameters.Add("@varchar_field", PGDbType.VarChar);
***************
*** 176,180 ****
  				for (int i = 0; i < 100; i++)
  				{
! 					command.Parameters["@int_field"].Value		= i;
  					command.Parameters["@char_field"].Value		= "IRow " + i.ToString();
  					command.Parameters["@varchar_field"].Value	= "IRow Number" + i.ToString();
--- 177,181 ----
  				for (int i = 0; i < 100; i++)
  				{
! 					command.Parameters["@int4_field"].Value		= i;
  					command.Parameters["@char_field"].Value		= "IRow " + i.ToString();
  					command.Parameters["@varchar_field"].Value	= "IRow Number" + i.ToString();

Index: PGCommandTest.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source/PGCommandTest.cs,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** PGCommandTest.cs	19 Jul 2003 10:12:29 -0000	1.5
--- PGCommandTest.cs	20 Jul 2003 10:01:19 -0000	1.6
***************
*** 32,36 ****
  			Console.WriteLine("\r\nPGCommandTest.ExecuteNonQueryTest");
  
! 			string commandText = "update public.test_table set char_field = @char_field, varchar_field = @varchar_field where int_field = @int_field";
  
  			PGTransaction transaction = Connection.BeginTransaction();
--- 32,36 ----
  			Console.WriteLine("\r\nPGCommandTest.ExecuteNonQueryTest");
  
! 			string commandText = "update public.test_table set char_field = @char_field, varchar_field = @varchar_field where int4_field = @int4_field";
  
  			PGTransaction transaction = Connection.BeginTransaction();
***************
*** 42,46 ****
  				command.Parameters.Add("@char_field", PGDbType.Char);
  				command.Parameters.Add("@varchar_field", PGDbType.VarChar);
! 				command.Parameters.Add("@int_field", PGDbType.Int4);
  
  				for (int i = 0; i < 100; i++)
--- 42,46 ----
  				command.Parameters.Add("@char_field", PGDbType.Char);
  				command.Parameters.Add("@varchar_field", PGDbType.VarChar);
! 				command.Parameters.Add("@int4_field", PGDbType.Int4);
  
  				for (int i = 0; i < 100; i++)
***************
*** 101,105 ****
  			PGCommand command = Connection.CreateCommand();
  			
! 			command.CommandText = "SELECT char_field FROM public.test_table where int_field = @int_field";
  									
  			command.Parameters.Add("@int_Field", 2);
--- 101,105 ----
  			PGCommand command = Connection.CreateCommand();
  			
! 			command.CommandText = "SELECT char_field FROM public.test_table where int4_field = @int4_field";
  									
  			command.Parameters.Add("@int_Field", 2);
***************
*** 117,123 ****
  			PGCommand command = Connection.CreateCommand();
  			
! 			command.CommandText = "SELECT char_field FROM public.test_table where int_field = @int_field";
  									
! 			command.Parameters.Add("@int_field", 2);						
  			command.Prepare();
  			command.Dispose();
--- 117,123 ----
  			PGCommand command = Connection.CreateCommand();
  			
! 			command.CommandText = "SELECT char_field FROM public.test_table where int4_field = @int4_field";
  									
! 			command.Parameters.Add("@int4_field", 2);						
  			command.Prepare();
  			command.Dispose();
***************
*** 129,135 ****
  			PGCommand command = Connection.CreateCommand();
  			
! 			command.CommandText = "SELECT char_field FROM public.test_table where int_field = @int_field or char_field = @char_field";
  									
! 			command.Parameters.Add("@int_field", 2);
  			command.Parameters.Add("@char_field", "IRow 20");
  						
--- 129,135 ----
  			PGCommand command = Connection.CreateCommand();
  			
! 			command.CommandText = "SELECT char_field FROM public.test_table where int4_field = @int4_field or char_field = @char_field";
  									
! 			command.Parameters.Add("@int4_field", 2);
  			command.Parameters.Add("@char_field", "IRow 20");
  						
***************
*** 159,163 ****
  		{
  			// Execute a SELECT command
! 			PGCommand selectCommand = new PGCommand("SELECT * FROM public.test_table WHERE int_field = 100", Connection);
  			int recordsAffected = selectCommand.ExecuteNonQuery();
  			Console.WriteLine("\r\nRecords Affected by SELECT command: {0}", recordsAffected);
--- 159,163 ----
  		{
  			// Execute a SELECT command
! 			PGCommand selectCommand = new PGCommand("SELECT * FROM public.test_table WHERE int4_field = 100", Connection);
  			int recordsAffected = selectCommand.ExecuteNonQuery();
  			Console.WriteLine("\r\nRecords Affected by SELECT command: {0}", recordsAffected);
***************
*** 167,171 ****
  
  			// Execute a DELETE command
! 			PGCommand deleteCommand = new PGCommand("DELETE FROM public.test_table WHERE int_field = 45", Connection);
  			recordsAffected = deleteCommand.ExecuteNonQuery();
  			Console.WriteLine("\r\nRecords Affected by DELETE command: {0}", recordsAffected);			
--- 167,171 ----
  
  			// Execute a DELETE command
! 			PGCommand deleteCommand = new PGCommand("DELETE FROM public.test_table WHERE int4_field = 45", Connection);
  			recordsAffected = deleteCommand.ExecuteNonQuery();
  			Console.WriteLine("\r\nRecords Affected by DELETE command: {0}", recordsAffected);			

Index: PGDataAdapterTest.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source/PGDataAdapterTest.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** PGDataAdapterTest.cs	18 Jul 2003 22:46:04 -0000	1.3
--- PGDataAdapterTest.cs	20 Jul 2003 10:01:19 -0000	1.4
***************
*** 103,111 ****
  			DataRow newRow = ds.Tables["public.test_table"].NewRow();
  
! 			newRow["int_field"]			= 100;
  			newRow["char_field"]		= "PostgreSQL";
  			newRow["varchar_field"]		= "PostgreSQL CLient";
! 			newRow["bigint_field"]		= 100000;
! 			newRow["smallint_field"]	= 100;
  			newRow["double_field"]		= 100.01;			
  			newRow["date_field"]		= DateTime.Now;
--- 103,111 ----
  			DataRow newRow = ds.Tables["public.test_table"].NewRow();
  
! 			newRow["int4_field"]			= 100;
  			newRow["char_field"]		= "PostgreSQL";
  			newRow["varchar_field"]		= "PostgreSQL CLient";
! 			newRow["int8_field"]		= 100000;
! 			newRow["int2_field"]	= 100;
  			newRow["double_field"]		= 100.01;			
  			newRow["date_field"]		= DateTime.Now;
***************
*** 127,134 ****
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command		= new PGCommand("SELECT * FROM public.test_table WHERE int_field = @int_field", Connection, transaction);
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 1;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 127,134 ----
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command		= new PGCommand("SELECT * FROM public.test_table WHERE int4_field = @int4_field", Connection, transaction);
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 1;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 151,158 ****
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command		= new PGCommand("SELECT * FROM public.test_table WHERE int_field = @int_field", Connection, transaction);
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 10;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 151,158 ----
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command		= new PGCommand("SELECT * FROM public.test_table WHERE int4_field = @int4_field", Connection, transaction);
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 10;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 175,182 ****
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command		= new PGCommand("SELECT * FROM public.test_table WHERE int_field = @int_field", Connection, transaction);
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 40;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 175,182 ----
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command		= new PGCommand("SELECT * FROM public.test_table WHERE int4_field = @int4_field", Connection, transaction);
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 40;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 185,189 ****
  			adapter.Fill(ds, "public.test_table");
  
! 			ds.Tables["public.test_table"].Rows[0]["smallint_field"] = System.Int16.MaxValue;
  
  			adapter.Update(ds, "public.test_table");
--- 185,189 ----
  			adapter.Fill(ds, "public.test_table");
  
! 			ds.Tables["public.test_table"].Rows[0]["int2_field"] = System.Int16.MaxValue;
  
  			adapter.Update(ds, "public.test_table");
***************
*** 194,203 ****
  			transaction.Commit();
  
! 			command = new PGCommand("SELECT smallint_field FROM public.test_table WHERE int_field = @int_field", Connection);
! 			command.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 40;
  
  			short val = (short)command.ExecuteScalar();
  
! 			Assertion.AssertEquals("smallint_field has not correct value", System.Int16.MaxValue, val);
  		}
  
--- 194,203 ----
  			transaction.Commit();
  
! 			command = new PGCommand("SELECT int2_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 40;
  
  			short val = (short)command.ExecuteScalar();
  
! 			Assertion.AssertEquals("int2_field has not correct value", System.Int16.MaxValue, val);
  		}
  
***************
*** 206,213 ****
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command		= new PGCommand("SELECT * FROM public.test_table WHERE int_field = @int_field", Connection, transaction);
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 20;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 206,213 ----
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command		= new PGCommand("SELECT * FROM public.test_table WHERE int4_field = @int4_field", Connection, transaction);
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 20;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 216,220 ****
  			adapter.Fill(ds, "public.test_table");
  
! 			ds.Tables["public.test_table"].Rows[0]["bigint_field"]	= System.Int32.MaxValue;
  
  			adapter.Update(ds, "public.test_table");
--- 216,220 ----
  			adapter.Fill(ds, "public.test_table");
  
! 			ds.Tables["public.test_table"].Rows[0]["int8_field"]	= System.Int32.MaxValue;
  
  			adapter.Update(ds, "public.test_table");
***************
*** 225,234 ****
  			transaction.Commit();
  
! 			command = new PGCommand("SELECT bigint_field FROM public.test_table WHERE int_field = @int_field", Connection);
! 			command.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 20;
  
  			long val = (long)command.ExecuteScalar();
  
! 			Assertion.AssertEquals("bigint_field has not correct value", System.Int32.MaxValue, val);
  		}
  
--- 225,234 ----
  			transaction.Commit();
  
! 			command = new PGCommand("SELECT int8_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 20;
  
  			long val = (long)command.ExecuteScalar();
  
! 			Assertion.AssertEquals("int8_field has not correct value", System.Int32.MaxValue, val);
  		}
  
***************
*** 237,244 ****
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command		= new PGCommand("SELECT * FROM public.test_table WHERE int_field = @int_field", Connection, transaction);
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 50;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 237,244 ----
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command		= new PGCommand("SELECT * FROM public.test_table WHERE int4_field = @int4_field", Connection, transaction);
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 50;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 256,261 ****
  			transaction.Commit();
  
! 			command = new PGCommand("SELECT double_field FROM public.test_table WHERE int_field = @int_field", Connection);
! 			command.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 50;
  
  			double val = (double)command.ExecuteScalar();
--- 256,261 ----
  			transaction.Commit();
  
! 			command = new PGCommand("SELECT double_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 50;
  
  			double val = (double)command.ExecuteScalar();
***************
*** 265,275 ****
  
  		[Test]
! 		public void UpdateDecimalTest()
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command		= new PGCommand("SELECT * FROM public.test_table WHERE int_field = @int_field", Connection, transaction);
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 60;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 265,275 ----
  
  		[Test]
! 		public void UpdateMoneyField()
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command		= new PGCommand("SELECT * FROM public.test_table WHERE int4_field = @int4_field", Connection, transaction);
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 27;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 278,282 ****
  			adapter.Fill(ds, "public.test_table");
  
! 			ds.Tables["public.test_table"].Rows[0]["decimal_field"]	= System.Int16.MaxValue;
  			
  			adapter.Update(ds, "public.test_table");
--- 278,282 ----
  			adapter.Fill(ds, "public.test_table");
  
! 			ds.Tables["public.test_table"].Rows[0]["money_field"] = 200.20;
  			
  			adapter.Update(ds, "public.test_table");
***************
*** 287,296 ****
  			transaction.Commit();
  
! 			command = new PGCommand("SELECT decimal_field FROM public.test_table WHERE int_field = @int_field", Connection);
! 			command.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 60;
  
  			decimal val = (decimal)command.ExecuteScalar();
  
! 			Assertion.AssertEquals("decimal_field has not correct value", System.Int16.MaxValue, val);
  		}
  
--- 287,327 ----
  			transaction.Commit();
  
! 			command = new PGCommand("SELECT money_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 27;
! 
! 			float val = (float)command.ExecuteScalar();
! 
! 			Assertion.AssertEquals("money_field has not correct value", 200.20, val);
! 		}
! 
! 		[Test]
! 		public void UpdateNumericTest()
! 		{
! 			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command		= new PGCommand("SELECT * FROM public.test_table WHERE int4_field = @int4_field", Connection, transaction);
! 			PGDataAdapter	adapter		= new PGDataAdapter(command);
! 
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 60;
! 			
! 			PGCommandBuilder builder = new PGCommandBuilder(adapter);
! 
! 			DataSet ds = new DataSet();
! 			adapter.Fill(ds, "public.test_table");
! 
! 			ds.Tables["public.test_table"].Rows[0]["numeric_field"]	= System.Int16.MaxValue;
! 			
! 			adapter.Update(ds, "public.test_table");
! 
! 			adapter.Dispose();
! 			builder.Dispose();
! 			command.Dispose();
! 			transaction.Commit();
! 
! 			command = new PGCommand("SELECT numeric_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 60;
  
  			decimal val = (decimal)command.ExecuteScalar();
  
! 			Assertion.AssertEquals("numeric_field has not correct value", System.Int16.MaxValue, val);
  		}
  
***************
*** 299,306 ****
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command = new PGCommand("SELECT * FROM public.test_table WHERE int_field = @int_field", Connection, transaction);
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 70;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 330,337 ----
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command = new PGCommand("SELECT * FROM public.test_table WHERE int4_field = @int4_field", Connection, transaction);
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 70;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 320,325 ****
  			transaction.Commit();
  
! 			command = new PGCommand("SELECT date_field FROM public.test_table WHERE int_field = @int_field", Connection);
! 			command.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 70;
  
  			DateTime val = (DateTime)command.ExecuteScalar();
--- 351,356 ----
  			transaction.Commit();
  
! 			command = new PGCommand("SELECT date_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 70;
  
  			DateTime val = (DateTime)command.ExecuteScalar();
***************
*** 334,341 ****
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command		= new PGCommand("SELECT * FROM public.test_table WHERE int_field = @int_field", Connection, transaction);
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 80;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 365,372 ----
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command		= new PGCommand("SELECT * FROM public.test_table WHERE int4_field = @int4_field", Connection, transaction);
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 80;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 355,360 ****
  			transaction.Commit();
  
! 			command = new PGCommand("SELECT time_field FROM public.test_table WHERE int_field = @int_field", Connection);
! 			command.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 80;
  
  			DateTime val = (DateTime)command.ExecuteScalar();
--- 386,391 ----
  			transaction.Commit();
  
! 			command = new PGCommand("SELECT time_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 80;
  
  			DateTime val = (DateTime)command.ExecuteScalar();
***************
*** 369,376 ****
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command		= new PGCommand("SELECT * FROM public.test_table WHERE int_field = @int_field", Connection, transaction);
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 90;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 400,407 ----
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command		= new PGCommand("SELECT * FROM public.test_table WHERE int4_field = @int4_field", Connection, transaction);
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 90;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 390,395 ****
  			transaction.Commit();
  
! 			command = new PGCommand("SELECT timestamp_field FROM public.test_table WHERE int_field = @int_field", Connection);
! 			command.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 90;
  
  			DateTime val = (DateTime)command.ExecuteScalar();
--- 421,426 ----
  			transaction.Commit();
  
! 			command = new PGCommand("SELECT timestamp_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 90;
  
  			DateTime val = (DateTime)command.ExecuteScalar();
***************
*** 407,414 ****
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command = new PGCommand("SELECT * FROM public.test_table WHERE int_field = @int_field", Connection, transaction);
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 35;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 438,445 ----
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
! 			PGCommand		command = new PGCommand("SELECT * FROM public.test_table WHERE int4_field = @int4_field", Connection, transaction);
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 35;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient PGOutputPacket.cs,1.3,1.4 PGResponsePacket.cs,1.4,1.5

From: <car...@us...> - 2003-07-20 09:59:32

Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient
In directory sc8-pr-cvs1:/tmp/cvs-serv30290

Modified Files:
	PGOutputPacket.cs PGResponsePacket.cs 
Log Message:
* Added new test case for money fields.

* Fixed money datatype handling.

Index: PGOutputPacket.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient/PGOutputPacket.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** PGOutputPacket.cs	18 Jul 2003 22:46:22 -0000	1.3
--- PGOutputPacket.cs	20 Jul 2003 09:59:28 -0000	1.4
***************
*** 206,212 ****
  				
  					case DbType.Single:
- 					case DbType.Currency:
  						WriteInt(size);
  						WriteFloat(Convert.ToSingle(parameter.Value));
  						break;
  
--- 206,216 ----
  				
  					case DbType.Single:
  						WriteInt(size);
  						WriteFloat(Convert.ToSingle(parameter.Value));
+ 						break;
+ 
+ 					case DbType.Currency:
+ 						WriteInt(size);
+ 						WriteInt(Convert.ToInt32(Convert.ToSingle(parameter.Value)*100));
  						break;
  

Index: PGResponsePacket.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient/PGResponsePacket.cs,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** PGResponsePacket.cs	17 Jul 2003 21:13:05 -0000	1.4
--- PGResponsePacket.cs	20 Jul 2003 09:59:28 -0000	1.5
***************
*** 127,138 ****
  		}
  
! 		public decimal ReadMoney()
  		{
  			FloatLayout floatValue = new FloatLayout();
  
  			floatValue.f  = base.ReadSingle();
  			floatValue.i0 = IPAddress.HostToNetworkOrder(floatValue.i0);
  
! 			return Convert.ToDecimal(floatValue.i0)/100;
  		}
  		
--- 127,141 ----
  		}
  
! 		public float ReadMoney()
  		{
+ 			/*
  			FloatLayout floatValue = new FloatLayout();
  
  			floatValue.f  = base.ReadSingle();
  			floatValue.i0 = IPAddress.HostToNetworkOrder(floatValue.i0);
+ 			*/
+ 			float val = (float)ReadInt();
  
! 			return val/100;
  		}

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient/source PGConnectionPool.cs,1.1.1.1,1.2

From: <car...@us...> - 2003-07-20 09:59:00

Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source
In directory sc8-pr-cvs1:/tmp/cvs-serv30233

Modified Files:
	PGConnectionPool.cs 
Log Message:
Minor change

Index: PGConnectionPool.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/PGConnectionPool.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PGConnectionPool.cs	12 Jul 2003 08:11:21 -0000	1.1.1.1
--- PGConnectionPool.cs	20 Jul 2003 09:58:57 -0000	1.2
***************
*** 21,24 ****
--- 21,25 ----
  using System.Collections;
  using System.Threading;
+ using PostgreSql.Data.NPGClient;
  
  namespace PostgreSql.Data.PGSqlClient
***************
*** 173,177 ****
  				return connection;
  			}
! 			catch (Exception ex) 
  			{
  				throw ex;
--- 174,178 ----
  				return connection;
  			}
! 			catch (PGClientException ex)
  			{
  				throw ex;

[pgsqlclient-checkins] pgsqlclient readme.txt,1.1.1.1,1.2

From: <car...@us...> - 2003-07-19 10:20:34

Update of /cvsroot/pgsqlclient/pgsqlclient
In directory sc8-pr-cvs1:/tmp/cvs-serv31348

Modified Files:
	readme.txt 
Log Message:
Prepare for Alpha 1

Index: readme.txt
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/readme.txt,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** readme.txt	12 Jul 2003 08:11:20 -0000	1.1.1.1
--- readme.txt	19 Jul 2003 10:20:32 -0000	1.2
***************
*** 19,21 ****
  
  PGSqlClient - ADO.NET Data Provider for PostgreSQL 7.4+
! -------------------------------------------------------
\ No newline at end of file
--- 19,70 ----
  
  PGSqlClient - ADO.NET Data Provider for PostgreSQL 7.4+
! -------------------------------------------------------
! 
! 
! Developement list
! -----------------
! 
! You can subscribe to the developement list at:
! 
! 	http://lists.sourceforge.net/lists/listinfo/pgsqlclient-devel
! 
! 
! You can see the archives here:
! 
! 	http://sourceforge.net/mailarchive/forum.php?forum=pgsqlclient-devel
! 
! 
! Users support list
! -----------------
! 
! You can subscribe to the users support list at:
! 
! 	http://lists.sourceforge.net/lists/listinfo/pgsqlclient-users
! 
! 
! You can see the archives here:
! 
! 	http://sourceforge.net/mailarchive/forum.php?forum=pgsqlclient-users
! 
! 
! CVS access
! --- ------
! 
! You can see instructions for CVS access here:
! 
! 	https://sourceforge.net/cvs/?group_id=85397
! 
! 
! 
! Reporting Bugs
! --------------
! 
! For bug reporting you can:
! 
! 1. Send it to the developement list.
! 
! 2. Send it to the user support list.
! 
! 3. Using the project bug tracker ( You need a Sourceforge ID ).
! 
! 	https://sourceforge.net/tracker/?group_id=85397&atid=576060

[pgsqlclient-checkins] pgsqlclient changelog.txt,1.17,1.18 PGSqlClient.build,1.2,1.3

From: <car...@us...> - 2003-07-19 10:13:53

Update of /cvsroot/pgsqlclient/pgsqlclient
In directory sc8-pr-cvs1:/tmp/cvs-serv30439

Modified Files:
	changelog.txt PGSqlClient.build 
Log Message:
 Prepare for Alpha 1 release.

Index: changelog.txt
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v
retrieving revision 1.17
retrieving revision 1.18
diff -C2 -d -r1.17 -r1.18
*** changelog.txt	18 Jul 2003 22:47:13 -0000	1.17
--- changelog.txt	19 Jul 2003 10:13:50 -0000	1.18
***************
*** 5,8 ****
--- 5,10 ----
  2003-07-19 Carlos Guzmán Álvarez  <car...@te...>
  
+ 	* Prepare for Alpha 1 release.
+ 
  	* Improved NUnit test Suite.
  

Index: PGSqlClient.build
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PGSqlClient.build,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** PGSqlClient.build	15 Jul 2003 19:12:18 -0000	1.2
--- PGSqlClient.build	19 Jul 2003 10:13:50 -0000	1.3
***************
*** 1,4 ****
  <?xml version="1.0" ?>
! <project name="PGSqlClient" default="release" basedir="." xmlnds="http://tempuri.org/nant-vs.xsd">
  	<!-- Project properties -->
  	<property name="project.name" value="PGSqlClient" />
--- 1,4 ----
  <?xml version="1.0" ?>
! <project name="PGSqlClient" default="build-all" basedir="." xmlnds="http://tempuri.org/nant-vs.xsd">
  	<!-- Project properties -->
  	<property name="project.name" value="PGSqlClient" />
***************
*** 16,19 ****
--- 16,20 ----
  	<property name="nunit.test.dir" value="PostgreSql.Data.PGSqlClient.UnitTests\source"/>
  	<property name="resources.dir" value="${src.dir}\Resources" />
+ 	<property name="distribution.dir" value="${build.dir}\distribution" />
  
  	<!-- Check for Html Help Compiler -->
***************
*** 32,36 ****
  
  	<!-- Check for NUnit -->
! 	<target name="check-nunit-framework">
  		<ifnot propertyexists="nunit.framework.dll">
  			<sysinfo />
--- 33,37 ----
  
  	<!-- Check for NUnit -->
! 	<target name="check-nunit-framework" depends="check-htmlhelp-compiler">
  		<ifnot propertyexists="nunit.framework.dll">
  			<sysinfo />
***************
*** 40,47 ****
  	</target>
  	
  	<!-- Target for check build configuration -->
  	<target name="check-build-config" depends="clean">
! 		<call target="check-htmlhelp-compiler" />
! 		<call target="check-nunit-framework" />
  	</target>
  	
--- 41,116 ----
  	</target>
  	
+ 	<!-- Displays configuration info, usefull for working out why PGSqlClient doesn't build -->
+ 	<target name="display-setup" depends="check-nunit-framework">
+ 		<!-- .NET Framework 1.0 -->
+ 		<available type="Framework" resource="net-1.0" property="temp.framework.available" />
+ 		<ifnot propertytrue="temp.framework.available">
+ 			<echo message=".NET Framework 1.0 runtime is not available." />
+ 		</ifnot>
+ 		<if propertytrue="temp.framework.available">
+ 			<property name="nant.settings.currentframework" value="net-1.0" />
+ 			<call target="display-current-runtime" force="true" />
+ 		</if>
+ 		<!-- .NET Framework 1.1 -->
+ 		<available type="Framework" resource="net-1.1" property="temp.framework.available" />
+ 		<ifnot propertytrue="temp.framework.available">
+ 			<echo message=".NET Framework 1.1 runtime is not available." />
+ 		</ifnot>
+ 		<if propertytrue="temp.framework.available">
+ 			<property name="nant.settings.currentframework" value="net-1.1" />
+ 			<call target="display-current-runtime" force="true" />
+ 		</if>
+ 		<!-- Mono 1.0 -->
+ 		<available type="Framework" resource="mono-1.0" property="temp.framework.available" />
+ 		<ifnot propertytrue="temp.framework.available">
+ 			<echo message="Mono 1.0 runtime is not available." />
+ 		</ifnot>
+ 		<if propertytrue="temp.framework.available">
+ 			<property name="nant.settings.currentframework" value="mono-1.0" />
+ 			<call target="display-current-runtime" force="true" />
+ 		</if>
+ 		<!-- SSCLI 1.0 -->
+ 		<available type="Framework" resource="sscli-1.0" property="temp.framework.available" />
+ 		<ifnot propertytrue="temp.framework.available">
+ 			<echo message="SSCLI 1.0 runtime is not available." />
+ 		</ifnot>
+ 		<if propertytrue="temp.framework.available">
+ 			<property name="nant.settings.currentframework" value="sscli-1.0" />
+ 			<call target="display-current-runtime" force="true" />
+ 		</if>
+ 		<!-- HTML Help Compiler -->
+ 		<echo message="" />
+ 		<echo message="----------------------------------------------------------" />
+ 		<echo message="" />
+ 		<echo message="htmlhelp.compiler: ${htmlhelp.compiler}" />
+ 		<echo message="" />
+ 	</target>
+ 	
+ 	<target name="display-current-runtime">
+ 		<echo message="" />
+ 		<echo message="----------------------------------------------------------" />
+ 		<echo message=" ${nant.settings.currentframework.description}" />
+ 		<echo message="----------------------------------------------------------" />
+ 		<echo message="" />
+ 		<echo message="framework : ${nant.settings.currentframework}" />
+ 		<echo message="description : ${nant.settings.currentframework.description}" />
+ 		<if propertyexists="nant.settings.currentframework.sdkdirectory">
+ 			<echo message="sdk directory : ${nant.settings.currentframework.sdkdirectory}" />
+ 		</if>
+ 		<ifnot propertyexists="nant.settings.currentframework.sdkdirectory">
+ 			<echo message="sdk directory : &lt;not configured/available&gt;" />
+ 		</ifnot>
+ 		<echo message="framework directory : ${nant.settings.currentframework.frameworkdirectory}" />
+ 		<echo message="assembly directory : ${nant.settings.currentframework.frameworkassemblydirectory}" />
+ 		<if propertyexists="nant.settings.currentframework.runtimeengine">
+ 			<echo message="runtime engine : ${nant.settings.currentframework.runtimeengine}" />
+ 		</if>
+ 		<echo message="" />
+ 	</target>
+ 	
  	<!-- Target for check build configuration -->
  	<target name="check-build-config" depends="clean">
! 		<call target="display-setup" />
! 		<!-- ${nant.settings.currentframework} -->
  	</target>
  	
***************
*** 49,65 ****
  	<target name="clean" description="cleans build directory">
  		<delete dir="${build.dir}" failonerror="false" verbose="true" />
! 	</target>
! 
! 	<!-- Target for build in DEBUG mode -->
! 	<target name="debug" depends="clean">
! 		<property name="build.debug" value="true" />
! 		<call target="build-all" />
! 	</target>
! 
! 	<!-- Target for build in RELEASE mode -->
! 	<target name="release" depends="clean">
! 		<property name="build.debug" value="false" />
! 		<property name="build.define" value="_RELEASE" />
! 		<call target="build-all" />
  	</target>
  
--- 118,122 ----
  	<target name="clean" description="cleans build directory">
  		<delete dir="${build.dir}" failonerror="false" verbose="true" />
! 		<delete dir="${distribution.dir}" failonerror="false" verbose="true" />
  	</target>
  
***************
*** 70,80 ****
          	<call target="build-nunit-tests" />
          </if>
  	</target>
  
  	<!-- Taget for build PGSqlClient .NET Data Provider Assembly -->
  	<target name="build-pgsqlclient">
! 		<mkdir dir="${build.dir}" />
  		<!-- compile PostgreSql.Data.PGSqlClient -->
! 		<csc output="${build.dir}\${project.FormalName}.dll" target="library" debug="${build.debug}" define="${build.define}">
  			<sources>
  				<includes name="${src.dir}/**/*.cs" />
--- 127,139 ----
          	<call target="build-nunit-tests" />
          </if>
+         <call target="distribution" />
  	</target>
  
  	<!-- Taget for build PGSqlClient .NET Data Provider Assembly -->
  	<target name="build-pgsqlclient">
! 		<mkdir dir="${build.dir}" failonerror="false" />
! 
  		<!-- compile PostgreSql.Data.PGSqlClient -->
! 		<csc output="${build.dir}\${project.FormalName}.dll" target="library" define="${build.define}">
  			<sources>
  				<includes name="${src.dir}/**/*.cs" />
***************
*** 89,92 ****
--- 148,152 ----
  			<arg value="/resource:${resources.dir}\Toolbox\PGCommand.bmp,PostgreSql.Data.PGSqlClient.Resources.ToolboxBitmaps.PGCommand.bmp" />
  			<arg value="/resource:${resources.dir}\Toolbox\PGDataAdapter.bmp,PostgreSql.Data.PGSqlClient.Resources.ToolboxBitmaps.PGDataAdapter.bmp" />
+ 			<arg value="/optimize+" />
  		</csc>
  	</target>
***************
*** 111,115 ****
  				<includes name="${build.dir}/${project.FormalName}.dll" />
  			</references>
  		</csc>
! 	</target>	
  </project>
--- 171,193 ----
  				<includes name="${build.dir}/${project.FormalName}.dll" />
  			</references>
+ 			<arg value="/optimize+" />			
  		</csc>
! 	</target>
! 	
! 	<!-- Target for distribution -->
! 	<target name="distribution">
! 		<mkdir dir="${distribution.dir}" failonerror="false" />
! 		<!-- Copy needed files to distribution directory -->
! 		<copy todir="${distribution.dir}">
! 			<fileset basedir="${build.dir}">
! 				<includes name="*.dll" />
! 				<includes name="*.config" />
! 			</fileset>
! 		</copy>
! 		<copy todir="${distribution.dir}">
! 			<fileset basedir=".">
! 				<includes name="*.txt" />
! 			</fileset>
! 		</copy>
! 	</target>
  </project>

[pgsqlclient-checkins] pgsqlclient PGSqlClient_Mono.build.win32,1.1.1.1,1.2

From: <car...@us...> - 2003-07-19 10:13:18

Update of /cvsroot/pgsqlclient/pgsqlclient
In directory sc8-pr-cvs1:/tmp/cvs-serv30364

Modified Files:
	PGSqlClient_Mono.build.win32 
Log Message:
 Prepare for Alpha 1 release.

Index: PGSqlClient_Mono.build.win32
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PGSqlClient_Mono.build.win32,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PGSqlClient_Mono.build.win32	12 Jul 2003 08:11:20 -0000	1.1.1.1
--- PGSqlClient_Mono.build.win32	19 Jul 2003 10:13:15 -0000	1.2
***************
*** 5,11 ****
--- 5,13 ----
  	<property name="project.FormalName" value="PostgreSql.Data.PGSqlClient" />
  	<property name="project.version" value="1.0" />
+ 	
  	<!-- Build properties -->
  	<property name="build.debug" value="true" />
  	<property name="build.define" value="_DEBUG" />
+ 	
  	<!-- Paths properties -->
  	<property name="base.dir" value="." />
***************
*** 14,21 ****
--- 16,25 ----
  	<property name="resources.dir" value="${src.dir}\Resources" />
  	<property name="csunit.dir" value="C:\Archivos de programa\csunit.org\csUnit 1.8.8" />
+ 	
  	<!-- Target for clean destination directory -->
  	<target name="clean" description="cleans build directory">
  		<delete dir="${build.dir}" failonerror="false" verbose="true" />
  	</target>
+ 	
  	<!-- Target for build in DEBUG mode -->
  	<target name="debug" depends="clean">
***************
*** 23,26 ****
--- 27,31 ----
  		<call target="build-all" />
  	</target>
+ 	
  	<!-- Target for build in RELEASE mode -->
  	<target name="release" depends="clean">
***************
*** 29,32 ****
--- 34,38 ----
  		<call target="build-all" />
  	</target>
+ 	
  	<!-- Target for check build configuration -->
  	<target name="build-all">
***************
*** 36,42 ****
  		</if>
  	</target>
  	<!-- Taget for build PGSqlClient .NET Data Provider Assembly -->
  	<target name="build-pgsqlclient">
! 		<mkdir dir="${build.dir}" />
  		<!-- compile PostgreSql.Data.PGSqlClient -->
  		<csc output="${build.dir}\${project.FormalName}.dll" target="library" debug="${build.debug}" define="${build.define}">
--- 42,50 ----
  		</if>
  	</target>
+ 	
  	<!-- Taget for build PGSqlClient .NET Data Provider Assembly -->
  	<target name="build-pgsqlclient">
! 		<mkdir dir="${build.dir}" failonerror="false" />
! 		
  		<!-- compile PostgreSql.Data.PGSqlClient -->
  		<csc output="${build.dir}\${project.FormalName}.dll" target="library" debug="${build.debug}" define="${build.define}">
***************
*** 55,58 ****
--- 63,67 ----
  		</csc>
  	</target>
+ 	
  	<!-- Target for build csUnit Tests -->
  	<target name="build-csnit-tests">

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source PGCommandTest.cs,1.4,1.5

From: <car...@us...> - 2003-07-19 10:12:32

Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source
In directory sc8-pr-cvs1:/tmp/cvs-serv30246

Modified Files:
	PGCommandTest.cs 
Log Message:
 Prepare for Alpha 1 release.

Index: PGCommandTest.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source/PGCommandTest.cs,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** PGCommandTest.cs	15 Jul 2003 19:11:39 -0000	1.4
--- PGCommandTest.cs	19 Jul 2003 10:12:29 -0000	1.5
***************
*** 158,179 ****
  		public void RecordsAffectedTest()
  		{
  			PGCommand selectCommand = new PGCommand("SELECT * FROM public.test_table WHERE int_field = 100", Connection);
  			int recordsAffected = selectCommand.ExecuteNonQuery();
  			Console.WriteLine("\r\nRecords Affected by SELECT command: {0}", recordsAffected);
- 			if (recordsAffected != -1)
- 			{
- 				throw new EvaluateException("Invalid RecordsAffected value for SELECT command");
- 			}
  			selectCommand.Dispose();
  
  			PGCommand deleteCommand = new PGCommand("DELETE FROM public.test_table WHERE int_field = 45", Connection);
  			recordsAffected = deleteCommand.ExecuteNonQuery();
! 			Console.WriteLine("\r\nRecords Affected by DELETE command: {0}", recordsAffected);
! 			if (recordsAffected != 1)
! 			{
! 				throw new EvaluateException("Invalid RecordsAffected value for DELETE command");
! 			}
! 			// Assertion.Assert(recordsAffected == 1);
  			deleteCommand.Dispose();
  		}
  	}
--- 158,176 ----
  		public void RecordsAffectedTest()
  		{
+ 			// Execute a SELECT command
  			PGCommand selectCommand = new PGCommand("SELECT * FROM public.test_table WHERE int_field = 100", Connection);
  			int recordsAffected = selectCommand.ExecuteNonQuery();
  			Console.WriteLine("\r\nRecords Affected by SELECT command: {0}", recordsAffected);
  			selectCommand.Dispose();
+ 			
+ 			Assertion.Assert(recordsAffected == -1);
  
+ 			// Execute a DELETE command
  			PGCommand deleteCommand = new PGCommand("DELETE FROM public.test_table WHERE int_field = 45", Connection);
  			recordsAffected = deleteCommand.ExecuteNonQuery();
! 			Console.WriteLine("\r\nRecords Affected by DELETE command: {0}", recordsAffected);			
  			deleteCommand.Dispose();
+ 			
+ 			Assertion.Assert(recordsAffected == 1);
  		}
  	}

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient/source/DbSchema IDbSchema.cs,1.1.1.1,1.2

From: <car...@us...> - 2003-07-19 10:12:14

Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/DbSchema
In directory sc8-pr-cvs1:/tmp/cvs-serv30220

Modified Files:
	IDbSchema.cs 
Log Message:
 Prepare for Alpha 1 release.

Index: IDbSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/DbSchema/IDbSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** IDbSchema.cs	12 Jul 2003 08:11:22 -0000	1.1.1.1
--- IDbSchema.cs	19 Jul 2003 10:12:10 -0000	1.2
***************
*** 20,24 ****
  using System.Data;
  using System.Collections;
- 
  using PostgreSql.Data.PGSqlClient;
  
--- 20,23 ----

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient PGType.cs,1.3,1.4

From: <car...@us...> - 2003-07-19 10:11:41

Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient
In directory sc8-pr-cvs1:/tmp/cvs-serv30138

Modified Files:
	PGType.cs 
Log Message:
 Prepare for Alpha 1 release.

Index: PGType.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient/PGType.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** PGType.cs	14 Jul 2003 11:59:44 -0000	1.3
--- PGType.cs	19 Jul 2003 10:11:39 -0000	1.4
***************
*** 19,23 ****
  using System;
  using System.Data;
- 
  using PostgreSql.Data.PGSqlClient;
  
--- 19,22 ----

[pgsqlclient-checkins] pgsqlclient changelog.txt,1.16,1.17

From: <car...@us...> - 2003-07-18 22:47:16

Update of /cvsroot/pgsqlclient/pgsqlclient
In directory sc8-pr-cvs1:/tmp/cvs-serv11206

Modified Files:
	changelog.txt 
Log Message:
Updated CHANGELOG.TXT

Index: changelog.txt
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v
retrieving revision 1.16
retrieving revision 1.17
diff -C2 -d -r1.16 -r1.17
*** changelog.txt	17 Jul 2003 21:14:14 -0000	1.16
--- changelog.txt	18 Jul 2003 22:47:13 -0000	1.17
***************
*** 3,6 ****
--- 3,15 ----
  
  
+ 2003-07-19 Carlos Guzmán Álvarez  <car...@te...>
+ 
+ 	* Improved NUnit test Suite.
+ 
+ 	* source/NPGClient/PGOutputPacket.cs:
+ 
+ 		- Fixed decimal datatype write.
+ 
+ 
  2003-07-17 Carlos Guzmán Álvarez  <car...@te...>

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient PGOutputPacket.cs,1.2,1.3

From: <car...@us...> - 2003-07-18 22:46:25

Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient
In directory sc8-pr-cvs1:/tmp/cvs-serv11033

Modified Files:
	PGOutputPacket.cs 
Log Message:
 Fixed decimal datatype write.

Index: PGOutputPacket.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient/PGOutputPacket.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** PGOutputPacket.cs	17 Jul 2003 13:41:42 -0000	1.2
--- PGOutputPacket.cs	18 Jul 2003 22:46:22 -0000	1.3
***************
*** 195,200 ****
  						*/
  						string paramValue = parameter.Value.ToString();
! 						WriteInt(encoding.GetByteCount(paramValue + PGCodes.NULL_TERMINATOR));
! 						WriteString(paramValue);
  					}
  					break;
--- 195,200 ----
  						*/
  						string paramValue = parameter.Value.ToString();
! 						WriteInt(encoding.GetByteCount(paramValue));
! 						Write(paramValue.ToCharArray());
  					}
  					break;

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source PGBaseTest.cs,1.4,1.5 PGDataAdapterTest.cs,1.2,1.3

From: <car...@us...> - 2003-07-18 22:46:10

Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source
In directory sc8-pr-cvs1:/tmp/cvs-serv10961

Modified Files:
	PGBaseTest.cs PGDataAdapterTest.cs 
Log Message:
Improved NUnit test suite

Index: PGBaseTest.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source/PGBaseTest.cs,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** PGBaseTest.cs	15 Jul 2003 19:11:39 -0000	1.4
--- PGBaseTest.cs	18 Jul 2003 22:46:04 -0000	1.5
***************
*** 142,146 ****
  			commandText.Append("bool_field bool,");
  			commandText.Append("bigint_field int8,");
! 			// commandText.Append("decimal_field decimal(8,2),");
  			commandText.Append("smallint_field int2,");
  			commandText.Append("array_int int2[],");
--- 142,146 ----
  			commandText.Append("bool_field bool,");
  			commandText.Append("bigint_field int8,");
! 			commandText.Append("decimal_field decimal(8,2),");
  			commandText.Append("smallint_field int2,");
  			commandText.Append("array_int int2[],");

Index: PGDataAdapterTest.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source/PGDataAdapterTest.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** PGDataAdapterTest.cs	15 Jul 2003 19:11:39 -0000	1.2
--- PGDataAdapterTest.cs	18 Jul 2003 22:46:04 -0000	1.3
***************
*** 172,176 ****
  
  		[Test]
! 		public void UpdateBigIntTest()
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
--- 172,176 ----
  
  		[Test]
! 		public void UpdateInt2Test()
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
***************
*** 178,182 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 20;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 178,182 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 40;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 185,189 ****
  			adapter.Fill(ds, "public.test_table");
  
! 			ds.Tables["public.test_table"].Rows[0]["bigint_field"]	= System.Int32.MaxValue;
  
  			adapter.Update(ds, "public.test_table");
--- 185,189 ----
  			adapter.Fill(ds, "public.test_table");
  
! 			ds.Tables["public.test_table"].Rows[0]["smallint_field"] = System.Int16.MaxValue;
  
  			adapter.Update(ds, "public.test_table");
***************
*** 193,200 ****
  			command.Dispose();
  			transaction.Commit();
  		}
  
  		[Test]
! 		public void UpdateSmallIntTest()
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
--- 193,207 ----
  			command.Dispose();
  			transaction.Commit();
+ 
+ 			command = new PGCommand("SELECT smallint_field FROM public.test_table WHERE int_field = @int_field", Connection);
+ 			command.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 40;
+ 
+ 			short val = (short)command.ExecuteScalar();
+ 
+ 			Assertion.AssertEquals("smallint_field has not correct value", System.Int16.MaxValue, val);
  		}
  
  		[Test]
! 		public void UpdateInt8Test()
  		{
  			PGTransaction	transaction = Connection.BeginTransaction();
***************
*** 202,206 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 40;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 209,213 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 20;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 209,213 ****
  			adapter.Fill(ds, "public.test_table");
  
! 			ds.Tables["public.test_table"].Rows[0]["smallint_field"] = System.Int16.MaxValue;
  
  			adapter.Update(ds, "public.test_table");
--- 216,220 ----
  			adapter.Fill(ds, "public.test_table");
  
! 			ds.Tables["public.test_table"].Rows[0]["bigint_field"]	= System.Int32.MaxValue;
  
  			adapter.Update(ds, "public.test_table");
***************
*** 217,220 ****
--- 224,234 ----
  			command.Dispose();
  			transaction.Commit();
+ 
+ 			command = new PGCommand("SELECT bigint_field FROM public.test_table WHERE int_field = @int_field", Connection);
+ 			command.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 20;
+ 
+ 			long val = (long)command.ExecuteScalar();
+ 
+ 			Assertion.AssertEquals("bigint_field has not correct value", System.Int32.MaxValue, val);
  		}
  
***************
*** 233,237 ****
  			adapter.Fill(ds, "public.test_table");
  
! 			ds.Tables["public.test_table"].Rows[0]["double_field"]	= System.Decimal.MaxValue;
  
  			adapter.Update(ds, "public.test_table");
--- 247,251 ----
  			adapter.Fill(ds, "public.test_table");
  
! 			ds.Tables["public.test_table"].Rows[0]["double_field"]	= System.Int32.MaxValue;
  
  			adapter.Update(ds, "public.test_table");
***************
*** 241,248 ****
  			command.Dispose();
  			transaction.Commit();
  		}
  
  		[Test]
- 		[Ignore("Not implemented.")]
  		public void UpdateDecimalTest()
  		{
--- 255,268 ----
  			command.Dispose();
  			transaction.Commit();
+ 
+ 			command = new PGCommand("SELECT double_field FROM public.test_table WHERE int_field = @int_field", Connection);
+ 			command.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 50;
+ 
+ 			double val = (double)command.ExecuteScalar();
+ 
+ 			Assertion.AssertEquals("double_field has not correct value", System.Int32.MaxValue, val);
  		}
  
  		[Test]
  		public void UpdateDecimalTest()
  		{
***************
*** 258,262 ****
  			adapter.Fill(ds, "public.test_table");
  
! 			ds.Tables["public.test_table"].Rows[0]["decimal_field"]	= System.Int32.MaxValue;
  			
  			adapter.Update(ds, "public.test_table");
--- 278,282 ----
  			adapter.Fill(ds, "public.test_table");
  
! 			ds.Tables["public.test_table"].Rows[0]["decimal_field"]	= System.Int16.MaxValue;
  			
  			adapter.Update(ds, "public.test_table");
***************
*** 266,269 ****
--- 286,296 ----
  			command.Dispose();
  			transaction.Commit();
+ 
+ 			command = new PGCommand("SELECT decimal_field FROM public.test_table WHERE int_field = @int_field", Connection);
+ 			command.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 60;
+ 
+ 			decimal val = (decimal)command.ExecuteScalar();
+ 
+ 			Assertion.AssertEquals("decimal_field has not correct value", System.Int16.MaxValue, val);
  		}
  
***************
*** 282,286 ****
  			adapter.Fill(ds, "public.test_table");
  
! 			ds.Tables["public.test_table"].Rows[0]["date_field"] = DateTime.Now;
  
  			adapter.Update(ds, "public.test_table");
--- 309,315 ----
  			adapter.Fill(ds, "public.test_table");
  
! 			DateTime dt = DateTime.Now;
! 
! 			ds.Tables["public.test_table"].Rows[0]["date_field"] = dt;
  
  			adapter.Update(ds, "public.test_table");
***************
*** 288,293 ****
  			adapter.Dispose();
  			builder.Dispose();
! 			command.Dispose();
  			transaction.Commit();
  		}
  
--- 317,331 ----
  			adapter.Dispose();
  			builder.Dispose();
! 			command.Dispose();			
  			transaction.Commit();
+ 
+ 			command = new PGCommand("SELECT date_field FROM public.test_table WHERE int_field = @int_field", Connection);
+ 			command.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 70;
+ 
+ 			DateTime val = (DateTime)command.ExecuteScalar();
+ 
+ 			Assertion.AssertEquals("date_field has not correct day", dt.Day, val.Day);
+ 			Assertion.AssertEquals("date_field has not correct month", dt.Month, val.Month);
+ 			Assertion.AssertEquals("date_field has not correct year", dt.Year, val.Year);
  		}
  
***************
*** 306,310 ****
  			adapter.Fill(ds, "public.test_table");
  
! 			ds.Tables["public.test_table"].Rows[0]["time_field"] = DateTime.Now;
  
  			adapter.Update(ds, "public.test_table");
--- 344,350 ----
  			adapter.Fill(ds, "public.test_table");
  
! 			DateTime dt = DateTime.Now;
! 
! 			ds.Tables["public.test_table"].Rows[0]["time_field"] = dt;
  
  			adapter.Update(ds, "public.test_table");
***************
*** 314,317 ****
--- 354,366 ----
  			command.Dispose();
  			transaction.Commit();
+ 
+ 			command = new PGCommand("SELECT time_field FROM public.test_table WHERE int_field = @int_field", Connection);
+ 			command.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 80;
+ 
+ 			DateTime val = (DateTime)command.ExecuteScalar();
+ 
+ 			Assertion.AssertEquals("time_field has not correct hour", dt.Hour, val.Hour);
+ 			Assertion.AssertEquals("time_field has not correct minute", dt.Minute, val.Minute);
+ 			Assertion.AssertEquals("time_field has not correct second", dt.Second, val.Second);
  		}
  
***************
*** 330,334 ****
  			adapter.Fill(ds, "public.test_table");
  
! 			ds.Tables["public.test_table"].Rows[0]["timestamp_field"] = DateTime.Now;
  
  			adapter.Update(ds, "public.test_table");
--- 379,385 ----
  			adapter.Fill(ds, "public.test_table");
  
! 			DateTime dt = DateTime.Now;
! 
! 			ds.Tables["public.test_table"].Rows[0]["timestamp_field"] = dt;
  
  			adapter.Update(ds, "public.test_table");
***************
*** 338,341 ****
--- 389,404 ----
  			command.Dispose();
  			transaction.Commit();
+ 
+ 			command = new PGCommand("SELECT timestamp_field FROM public.test_table WHERE int_field = @int_field", Connection);
+ 			command.Parameters.Add("@int_field", PGDbType.Int4, "int_field").Value = 90;
+ 
+ 			DateTime val = (DateTime)command.ExecuteScalar();
+ 
+ 			Assertion.AssertEquals("timestamp_field has not correct day", dt.Day, val.Day);
+ 			Assertion.AssertEquals("timestamp_field has not correct month", dt.Month, val.Month);
+ 			Assertion.AssertEquals("timestamp_field has not correct year", dt.Year, val.Year);
+ 			Assertion.AssertEquals("timestamp_field has not correct hour", dt.Hour, val.Hour);
+ 			Assertion.AssertEquals("timestamp_field has not correct minute", dt.Minute, val.Minute);
+ 			Assertion.AssertEquals("timestamp_field has not correct second", dt.Second, val.Second);
  		}

[pgsqlclient-checkins] pgsqlclient changelog.txt,1.15,1.16

From: <car...@us...> - 2003-07-17 21:14:18

Update of /cvsroot/pgsqlclient/pgsqlclient
In directory sc8-pr-cvs1:/tmp/cvs-serv29598

Modified Files:
	changelog.txt 
Log Message:
Updated CHANGELOG.TXT

Index: changelog.txt
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v
retrieving revision 1.15
retrieving revision 1.16
diff -C2 -d -r1.15 -r1.16
*** changelog.txt	17 Jul 2003 13:42:04 -0000	1.15
--- changelog.txt	17 Jul 2003 21:14:14 -0000	1.16
***************
*** 9,17 ****
  	* Added two new files for encode/decode datatype values.
  
! 	* source/NPGClient/PGResponsePAcket.cs:
  
  		- Removed test code.
  
  		- Added call to PGEncodeType.EncodeNumeric.
  
  
--- 9,23 ----
  	* Added two new files for encode/decode datatype values.
  
! 	* source/NPGClient/PGResponsePacket.cs:
  
  		- Removed test code.
  
  		- Added call to PGEncodeType.EncodeNumeric.
+ 
+ 	* source/NPGClient/PGEncodeType.cs:
+ 	* source/NPGClient/PGDecodeType.cs:
+ 	* source/NPGClient/PGResponsePacket.cs:
+ 		
+ 		- CleanUp.

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient PGDecodeType.cs,1.1,1.2 PGEncodeType.cs,1.2,1.3 PGResponsePacket.cs,1.3,1.4

From: <car...@us...> - 2003-07-17 21:13:08

Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient
In directory sc8-pr-cvs1:/tmp/cvs-serv29383

Modified Files:
	PGDecodeType.cs PGEncodeType.cs PGResponsePacket.cs 
Log Message:
CleanUp

Index: PGDecodeType.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient/PGDecodeType.cs,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** PGDecodeType.cs	17 Jul 2003 09:50:40 -0000	1.1
--- PGDecodeType.cs	17 Jul 2003 21:13:05 -0000	1.2
***************
*** 23,29 ****
  	internal class PGDecodeType
  	{
- 		public static void DecodeNumeric()
- 		{
- 		}
  	}
  }
--- 23,26 ----

Index: PGEncodeType.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient/PGEncodeType.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** PGEncodeType.cs	17 Jul 2003 13:41:42 -0000	1.2
--- PGEncodeType.cs	17 Jul 2003 21:13:05 -0000	1.3
***************
*** 23,81 ****
  	internal class PGEncodeType
  	{
- 		public static Decimal EncodeNumeric(int ndigits, int weight, int sign, int dscale, short[] digits)
- 		{
- 			Decimal result = 0M;
- 
- 			// This code was ported from PostgreSQL sources
- 			//		src/Backend/utils/adt/numeric.c
- 			if (sign == PGCodes.NUMERIC_NAN)
- 			{
- 				result = (decimal)Single.NaN;				
- 			}
- 			else
- 			{
- 				int n = ndigits - 1;
- 
- 				// truncate leading zeroes
- 				while (n > 0 && digits[n] == 0)
- 				{
- 					weight--;
- 					n--;
- 				}
- 
- 				// truncate trailing zeroes
- 				while (n > 0 && digits[n - 1] == 0)
- 				{
- 					n--;
- 				}
- 
- 				// If zero result, force to weight=0 and positive sign
- 				if (n == 0)
- 				{
- 					weight = 0;
- 					sign = PGCodes.NUMERIC_POS;
- 				}
- 
- 				// Build the result				
- 				byte[] res = new Byte[PGCodes.NUMERIC_HDRSZ + n * 1];
- 
- 				Buffer.BlockCopy(digits, 0, res, 0, res.Length);
- 
- 				/*
- 				result = (Numeric) palloc(len);
- 				result->varlen = len;
- 				result->n_weight = weight;
- 				result->n_sign_dscale = sign | (var->dscale & NUMERIC_DSCALE_MASK);
- 
- 				// Check for overflow of int16 fields
- 				if (result->n_weight != weight ||
- 					NUMERIC_DSCALE(result) != var->dscale)
- 					elog(ERROR, "Value overflows numeric format");
- 				*/
- 
- 			}
- 
- 			return result;
- 		}
  	}
  }
--- 23,26 ----

Index: PGResponsePacket.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient/PGResponsePacket.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** PGResponsePacket.cs	17 Jul 2003 13:41:42 -0000	1.3
--- PGResponsePacket.cs	17 Jul 2003 21:13:05 -0000	1.4
***************
*** 127,146 ****
  		}
  
- 		public decimal ReadNumeric()
- 		{
- 			short ndigits	= ReadShort();
- 			short weight	= ReadShort();
- 			short sign		= ReadShort();
- 			short dscale	= ReadShort();
- 			short[] digits	= new short[ndigits];
- 
- 			for (int i = 0; i < digits.Length; i++)
- 			{
- 				digits[i] = ReadShort();
- 			}
- 			
- 			return PGEncodeType.EncodeNumeric(ndigits, weight, sign, dscale, digits);
- 		}
- 
  		public decimal ReadMoney()
  		{
--- 127,130 ----
***************
*** 279,282 ****
--- 263,275 ----
  					
  				case DbType.Decimal:
+ 					/*
+ 					Data sent by PostgreSQL In binary mode
+ 					short ndigits	= ReadShort();
+ 					short weight	= ReadShort();
+ 					short sign		= ReadShort();
+ 					short dscale	= ReadShort();
+ 					short[] digits	= new short[ndigits];
+ 					*/
+ 
  					string numericValue = ReadString(length);					
  					return Decimal.Parse(numericValue, NumberFormatInfo.InvariantInfo);

[pgsqlclient-checkins] pgsqlclient changelog.txt,1.14,1.15

From: <car...@us...> - 2003-07-17 13:42:07

Update of /cvsroot/pgsqlclient/pgsqlclient
In directory sc8-pr-cvs1:/tmp/cvs-serv6420

Modified Files:
	changelog.txt 
Log Message:
Updated CHANGELOG.TXT

Index: changelog.txt
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v
retrieving revision 1.14
retrieving revision 1.15
diff -C2 -d -r1.14 -r1.15
*** changelog.txt	17 Jul 2003 09:50:59 -0000	1.14
--- changelog.txt	17 Jul 2003 13:42:04 -0000	1.15
***************
*** 5,8 ****
--- 5,10 ----
  2003-07-17 Carlos Guzmán Álvarez  <car...@te...>
  
+ 	* Added decimal datatype support at this moment using text format ( Task 81641 )
+ 
  	* Added two new files for encode/decode datatype values.

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient PGCodes.cs,1.1.1.1,1.2 PGDbClient.cs,1.2,1.3 PGEncodeType.cs,1.1,1.2 PGOutputPacket.cs,1.1.1.1,1.2 PGResponsePacket.cs,1.2,1.3

From: <car...@us...> - 2003-07-17 13:41:46

Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient
In directory sc8-pr-cvs1:/tmp/cvs-serv6334

Modified Files:
	PGCodes.cs PGDbClient.cs PGEncodeType.cs PGOutputPacket.cs 
	PGResponsePacket.cs 
Log Message:
Added decimal datatype support at this moment using text format ( Task 81641 )

Index: PGCodes.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient/PGCodes.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PGCodes.cs	12 Jul 2003 08:11:22 -0000	1.1.1.1
--- PGCodes.cs	17 Jul 2003 13:41:42 -0000	1.2
***************
*** 122,129 ****
--- 122,132 ----
  
  		// Numeric data type
+ 		public const int NUMERIC_SIGN_MASK		= 0xC000;
  		public const int NUMERIC_POS            = 0x0000;
  		public const int NUMERIC_NEG			= 0x4000;		
  		public const int NUMERIC_NAN            = 0xC000;
  		public const int NUMERIC_MAX_PRECISION	= 1000;
+ 		public const int NUMERIC_DSCALE_MASK	= 0x3FFF;
+ 		public const int NUMERIC_HDRSZ			= 10;
  	}
  }

Index: PGDbClient.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient/PGDbClient.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** PGDbClient.cs	14 Jul 2003 11:59:44 -0000	1.2
--- PGDbClient.cs	17 Jul 2003 13:41:42 -0000	1.3
***************
*** 548,552 ****
  			types.Add(1560	, "bit"		, DbType.Byte		, Type.GetType("System.Byte")		,	0, 0, 1, false, false);
  			types.Add(1562	, "varbit"	, DbType.Byte		, Type.GetType("System.Byte")		,	0, 1, 0, false, false);
! 			types.Add(1700	, "numeric"	, DbType.Decimal	, Type.GetType("System.Decimal")	,	0, 1, 8, false, false);
  			types.Add(2277	, "anyarray", DbType.Object		, Type.GetType("System.Array")		,	0, 1, 8, false, false);
  		}
--- 548,552 ----
  			types.Add(1560	, "bit"		, DbType.Byte		, Type.GetType("System.Byte")		,	0, 0, 1, false, false);
  			types.Add(1562	, "varbit"	, DbType.Byte		, Type.GetType("System.Byte")		,	0, 1, 0, false, false);
! 			types.Add(1700	, "numeric"	, DbType.Decimal	, Type.GetType("System.Decimal")	,	0, 0, 8, false, false);
  			types.Add(2277	, "anyarray", DbType.Object		, Type.GetType("System.Array")		,	0, 1, 8, false, false);
  		}

Index: PGEncodeType.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient/PGEncodeType.cs,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** PGEncodeType.cs	17 Jul 2003 09:50:40 -0000	1.1
--- PGEncodeType.cs	17 Jul 2003 13:41:42 -0000	1.2
***************
*** 23,29 ****
  	internal class PGEncodeType
  	{
! 		public static Decimal EncodeNumeric(short ndigits, short weight, short sign, short dscale, short[] digits)
  		{
! 			return 0;
  		}
  	}
--- 23,80 ----
  	internal class PGEncodeType
  	{
! 		public static Decimal EncodeNumeric(int ndigits, int weight, int sign, int dscale, short[] digits)
  		{
! 			Decimal result = 0M;
! 
! 			// This code was ported from PostgreSQL sources
! 			//		src/Backend/utils/adt/numeric.c
! 			if (sign == PGCodes.NUMERIC_NAN)
! 			{
! 				result = (decimal)Single.NaN;				
! 			}
! 			else
! 			{
! 				int n = ndigits - 1;
! 
! 				// truncate leading zeroes
! 				while (n > 0 && digits[n] == 0)
! 				{
! 					weight--;
! 					n--;
! 				}
! 
! 				// truncate trailing zeroes
! 				while (n > 0 && digits[n - 1] == 0)
! 				{
! 					n--;
! 				}
! 
! 				// If zero result, force to weight=0 and positive sign
! 				if (n == 0)
! 				{
! 					weight = 0;
! 					sign = PGCodes.NUMERIC_POS;
! 				}
! 
! 				// Build the result				
! 				byte[] res = new Byte[PGCodes.NUMERIC_HDRSZ + n * 1];
! 
! 				Buffer.BlockCopy(digits, 0, res, 0, res.Length);
! 
! 				/*
! 				result = (Numeric) palloc(len);
! 				result->varlen = len;
! 				result->n_weight = weight;
! 				result->n_sign_dscale = sign | (var->dscale & NUMERIC_DSCALE_MASK);
! 
! 				// Check for overflow of int16 fields
! 				if (result->n_weight != weight ||
! 					NUMERIC_DSCALE(result) != var->dscale)
! 					elog(ERROR, "Value overflows numeric format");
! 				*/
! 
! 			}
! 
! 			return result;
  		}
  	}

Index: PGOutputPacket.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient/PGOutputPacket.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PGOutputPacket.cs	12 Jul 2003 08:11:23 -0000	1.1.1.1
--- PGOutputPacket.cs	17 Jul 2003 13:41:42 -0000	1.2
***************
*** 189,195 ****
  
  					case DbType.Decimal:
  						WriteInt(size);
  						Write(Convert.ToDecimal(parameter.Value));
! 						break;
  
  					case DbType.Double:
--- 189,202 ----
  
  					case DbType.Decimal:
+ 					{
+ 						/*
  						WriteInt(size);
  						Write(Convert.ToDecimal(parameter.Value));
! 						*/
! 						string paramValue = parameter.Value.ToString();
! 						WriteInt(encoding.GetByteCount(paramValue + PGCodes.NULL_TERMINATOR));
! 						WriteString(paramValue);
! 					}
! 					break;
  
  					case DbType.Double:

Index: PGResponsePacket.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient/PGResponsePacket.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** PGResponsePacket.cs	17 Jul 2003 09:50:40 -0000	1.2
--- PGResponsePacket.cs	17 Jul 2003 13:41:42 -0000	1.3
***************
*** 279,283 ****
  					
  				case DbType.Decimal:
! 					return ReadNumeric();
  
  				case DbType.Currency:
--- 279,284 ----
  					
  				case DbType.Decimal:
! 					string numericValue = ReadString(length);					
! 					return Decimal.Parse(numericValue, NumberFormatInfo.InvariantInfo);
  
  				case DbType.Currency:

[pgsqlclient-checkins] pgsqlclient changelog.txt,1.13,1.14

From: <car...@us...> - 2003-07-17 09:51:02

Update of /cvsroot/pgsqlclient/pgsqlclient
In directory sc8-pr-cvs1:/tmp/cvs-serv2052

Modified Files:
	changelog.txt 
Log Message:
Updated CHANGELOG.TXT

Index: changelog.txt
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** changelog.txt	16 Jul 2003 20:18:14 -0000	1.13
--- changelog.txt	17 Jul 2003 09:50:59 -0000	1.14
***************
*** 3,6 ****
--- 3,17 ----
  
  
+ 2003-07-17 Carlos Guzmán Álvarez  <car...@te...>
+ 
+ 	* Added two new files for encode/decode datatype values.
+ 
+ 	* source/NPGClient/PGResponsePAcket.cs:
+ 
+ 		- Removed test code.
+ 
+ 		- Added call to PGEncodeType.EncodeNumeric.
+ 
+ 
  2003-07-16 Carlos Guzmán Álvarez  <car...@te...>

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient PGDecodeType.cs,NONE,1.1 PGEncodeType.cs,NONE,1.1 PGResponsePacket.cs,1.1.1.1,1.2

From: <car...@us...> - 2003-07-17 09:50:43

Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient
In directory sc8-pr-cvs1:/tmp/cvs-serv2003

Modified Files:
	PGResponsePacket.cs 
Added Files:
	PGDecodeType.cs PGEncodeType.cs 
Log Message:
* Added two new files for encode/decode datatype values.

* source/NPGClient/PGResponsePAcket.cs:

	- Removed test code.

	- Added call to PGEncodeType.EncodeNumeric.

--- NEW FILE: PGDecodeType.cs ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: PGEncodeType.cs ---
(This appears to be a binary file; contents omitted.)

Index: PGResponsePacket.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient/PGResponsePacket.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PGResponsePacket.cs	12 Jul 2003 08:11:23 -0000	1.1.1.1
--- PGResponsePacket.cs	17 Jul 2003 09:50:40 -0000	1.2
***************
*** 138,148 ****
  			{
  				digits[i] = ReadShort();
- 				if (i == 0)
- 				{
- 					digits[i] *= (short)(100*weight);
- 				}
  			}
  			
! 			return 0;
  		}
  
--- 138,144 ----
  			{
  				digits[i] = ReadShort();
  			}
  			
! 			return PGEncodeType.EncodeNumeric(ndigits, weight, sign, dscale, digits);
  		}

[pgsqlclient-checkins] pgsqlclient changelog.txt,1.12,1.13

From: <car...@us...> - 2003-07-16 20:18:18

Update of /cvsroot/pgsqlclient/pgsqlclient
In directory sc8-pr-cvs1:/tmp/cvs-serv11344

Modified Files:
	changelog.txt 
Log Message:
Updated CHANGELOG.TXT

Index: changelog.txt
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** changelog.txt	16 Jul 2003 19:34:21 -0000	1.12
--- changelog.txt	16 Jul 2003 20:18:14 -0000	1.13
***************
*** 18,23 ****
--- 18,31 ----
  	* source/PGDataReader.cs:
  	* source/PGDataAdapter.cs:
+ 	* source/PGCommandBuilder.cs:
+ 	* source/PGErrorCollection.cs:
+ 	* source/PGParameterAdapter.cs:
+ 	* source/PGException.cs:
  
  		- Added better use of design time attributes.
+ 
+ 	* source/PGParameterAdapter.cs:
+ 
+ 		- Added default constructor as internal.

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient/source PGCommandBuilder.cs,1.3,1.4 PGDataAdapter.cs,1.3,1.4 PGErrorCollection.cs,1.1.1.1,1.2 PGException.cs,1.3,1.4 PGParameterCollection.cs,1.1.1.1,1.2

From: <car...@us...> - 2003-07-16 20:17:52

Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source
In directory sc8-pr-cvs1:/tmp/cvs-serv11253

Modified Files:
	PGCommandBuilder.cs PGDataAdapter.cs PGErrorCollection.cs 
	PGException.cs PGParameterCollection.cs 
Log Message:
* source/PGConnection.cs:
* source/PGDataReader.cs:
* source/PGDataAdapter.cs:
* source/PGCommandBuilder.cs:
* source/PGErrorCollection.cs:
* source/PGParameterAdapter.cs:
* source/PGException.cs:

	- Added better use of design time attributes.

* source/PGParameterAdapter.cs:

	- Added default constructor as internal.


Index: PGCommandBuilder.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/PGCommandBuilder.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** PGCommandBuilder.cs	14 Jul 2003 11:57:25 -0000	1.3
--- PGCommandBuilder.cs	16 Jul 2003 20:17:49 -0000	1.4
***************
*** 52,55 ****
--- 52,56 ----
  		#region PROPERTIES
  
+ 		[DefaultValue(null)]
  		public PGDataAdapter DataAdapter
  		{
***************
*** 68,71 ****
--- 69,74 ----
  		}
  		
+ 		[Browsable(false),
+ 		DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
  		public string QuotePrefix
  		{
***************
*** 82,85 ****
--- 85,90 ----
  		}
  
+ 		[Browsable(false),
+ 		DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
  		public string QuoteSuffix
  		{

Index: PGDataAdapter.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/PGDataAdapter.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** PGDataAdapter.cs	16 Jul 2003 19:33:21 -0000	1.3
--- PGDataAdapter.cs	16 Jul 2003 20:17:49 -0000	1.4
***************
*** 33,38 ****
  	#endregion
  
! 	[ToolboxBitmap(typeof(PGDataAdapter), "Resources.ToolboxBitmaps.PGDataAdapter.bmp"),
! 	DesignerCategory("Component"),
  	DefaultEvent("RowUpdated")]
  	public sealed class PGDataAdapter : DbDataAdapter, IDbDataAdapter
--- 33,37 ----
  	#endregion
  
! 	[ToolboxBitmap(typeof(PGDataAdapter), "Resources.ToolboxBitmaps.PGDataAdapter.bmp"),	
  	DefaultEvent("RowUpdated")]
  	public sealed class PGDataAdapter : DbDataAdapter, IDbDataAdapter

Index: PGErrorCollection.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/PGErrorCollection.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PGErrorCollection.cs	12 Jul 2003 08:11:21 -0000	1.1.1.1
--- PGErrorCollection.cs	16 Jul 2003 20:17:49 -0000	1.2
***************
*** 19,27 ****
  using System;
  using System.Collections;
  using System.Globalization;
  
  namespace PostgreSql.Data.PGSqlClient
  {
! 	[Serializable]
  	public sealed class PGErrorCollection : ICollection, IEnumerable
  	{
--- 19,29 ----
  using System;
  using System.Collections;
+ using System.ComponentModel;
  using System.Globalization;
  
  namespace PostgreSql.Data.PGSqlClient
  {
! 	[Serializable,
! 	ListBindable(false)]
  	public sealed class PGErrorCollection : ICollection, IEnumerable
  	{

Index: PGException.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/PGException.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** PGException.cs	13 Jul 2003 13:54:02 -0000	1.3
--- PGException.cs	16 Jul 2003 20:17:49 -0000	1.4
***************
*** 19,24 ****
  using System;
  using System.Text;
  using System.Runtime.Serialization;
- 
  using PostgreSql.Data.NPGClient;
  
--- 19,24 ----
  using System;
  using System.Text;
+ using System.ComponentModel;
  using System.Runtime.Serialization;
  using PostgreSql.Data.NPGClient;
  
***************
*** 36,39 ****
--- 36,40 ----
  		#region PROPERTIES
  		
+ 		[DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]
  		public PGErrorCollection Errors
  		{

Index: PGParameterCollection.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/PGParameterCollection.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PGParameterCollection.cs	12 Jul 2003 08:11:21 -0000	1.1.1.1
--- PGParameterCollection.cs	16 Jul 2003 20:17:49 -0000	1.2
***************
*** 19,22 ****
--- 19,23 ----
  using System;
  using System.Data;
+ using System.ComponentModel;
  using System.Collections;
  using System.Globalization;
***************
*** 24,27 ****
--- 25,29 ----
  namespace PostgreSql.Data.PGSqlClient
  {
+ 	[ListBindable(false)]
  	public sealed class PGParameterCollection : MarshalByRefObject, IDataParameterCollection, IList, ICollection, IEnumerable
  	{	
***************
*** 40,43 ****
--- 42,47 ----
  		}
  
+ 		[Browsable(false),
+ 		DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
  		public PGParameter this[string parameterName]
  		{
***************
*** 52,55 ****
--- 56,61 ----
  		}
  
+ 		[Browsable(false),
+ 		DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
  		public PGParameter this[int parameterIndex]
  		{
***************
*** 60,63 ****
--- 66,77 ----
  		#endregion
  
+ 		#region CONSTRUCTORS
+ 
+ 		internal PGParameterCollection()
+ 		{
+ 		}
+ 
+ 		#endregion
+ 
  		#region ILIST_PROPERTIES
  
***************
*** 76,79 ****
--- 90,95 ----
  		#region ICOLLECTION_PROPERTIES
  
+ 		[Browsable(false),
+ 		DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
  		public int Count 
  		{

Flat | Threaded

<< < 1 .. 51 52 53 54 55 > >> (Page 53 of 55)

2003	Jan	Feb	Mar	Apr	May	Jun	Jul (120)	Aug (95)	Sep (95)	Oct (213)	Nov (114)	Dec (64)
2004	Jan (6)	Feb (134)	Mar (88)	Apr (28)	May (22)	Jun (15)	Jul (23)	Aug (2)	Sep (15)	Oct (2)	Nov (6)	Dec
2005	Jan (8)	Feb (6)	Mar	Apr (42)	May (3)	Jun	Jul	Aug	Sep (84)	Oct	Nov	Dec
2006	Jan	Feb	Mar (84)	Apr (46)	May (40)	Jun (8)	Jul	Aug	Sep	Oct	Nov	Dec