pgsqlclient-checkins — Mailing list for CVS commit messages.

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient/source PGCommand.cs,1.4,1.5 PGDataReader.cs,1.7,1.8

[<car...@us...>]

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

Modified Files:
	PGCommand.cs PGDataReader.cs 
Log Message:
- Added support for Function calls using CommandType.StoredProcedure.

Index: PGCommand.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/PGCommand.cs,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** PGCommand.cs	16 Jul 2003 14:09:12 -0000	1.4
--- PGCommand.cs	28 Jul 2003 12:18:48 -0000	1.5
***************
*** 316,319 ****
--- 316,321 ----
  			InternalPrepare();
  			InternalExecute();
+ 
+ 			InternalSetOutputParameters();
  			
  			return statement.RecordsAffected;
***************
*** 459,462 ****
--- 461,470 ----
  					statement.Status == PGStatementStatus.Error)
  				{
+ 					if (commandType == CommandType.StoredProcedure &&
+ 						!CommandText.ToUpper().StartsWith("SELECT * FROM "))
+ 					{
+ 						CommandText = "SELECT * FROM " + CommandText;
+ 					}
+ 
  					if (parameters.Count != 0)
  					{
***************
*** 549,555 ****
  		}
  	
! 		internal void SetOutputParameterValues()
  		{
! 			/* TODO: Add implementation	*/
  		}
  
--- 557,579 ----
  		}
  	
! 		internal void InternalSetOutputParameters()
  		{
! 			if (this.CommandType == CommandType.StoredProcedure && parameters.Count > 0)
! 			{
! 				IEnumerator paramEnumerator = Parameters.GetEnumerator();
! 				int i = 0;
! 
! 				object[] values = (object[])statement.Rows[0];
! 
! 				while (paramEnumerator.MoveNext())
! 				{					
! 					if (((PGParameter)paramEnumerator.Current).Direction == ParameterDirection.Output ||
! 						((PGParameter)paramEnumerator.Current).Direction == ParameterDirection.ReturnValue)
! 					{
! 						((PGParameter)paramEnumerator.Current).Value = values[i];
! 						i++;
! 					}					
! 				}
! 			}			
  		}
  

Index: PGDataReader.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/PGDataReader.cs,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** PGDataReader.cs	16 Jul 2003 19:33:21 -0000	1.7
--- PGDataReader.cs	28 Jul 2003 12:18:48 -0000	1.8
***************
*** 144,148 ****
  					{
  						// Set values of output parameters
! 						// TODO : Implement
  
  						// Close statement
--- 144,148 ----
  					{
  						// Set values of output parameters
! 						command.InternalSetOutputParameters();
  
  						// Close statement

[pgsqlclient-checkins] pgsqlclient changelog.txt,1.25,1.26

[<car...@us...>]

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

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

Index: changelog.txt
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v
retrieving revision 1.25
retrieving revision 1.26
diff -C2 -d -r1.25 -r1.26
*** changelog.txt	26 Jul 2003 12:31:33 -0000	1.25
--- changelog.txt	27 Jul 2003 21:21:07 -0000	1.26
***************
*** 2,5 ****
--- 2,13 ----
  -------------------------------------------------------
  
+ 2003-07-27 Carlos Guzmán Álvarez  <car...@te...>
+ 
+ 	* surce/PGParameter.cs:
+ 	* surce/PGParameterCollection.cs:
+ 
+ 		- Removed non standard constructor from PGParameter and added a new one, 
+ 		made needed changes in the Nunit test suite from bring it to work.
+ 
  
  < ----------------------------------- Alpha 2 ---------------------------------- >

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

[<car...@us...>]

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

Modified Files:
	PGDataAdapterTest.cs 
Log Message:
Removed non standard constructor from PGParameter and added a new one.

Index: PGDataAdapterTest.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source/PGDataAdapterTest.cs,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** PGDataAdapterTest.cs	26 Jul 2003 12:30:31 -0000	1.5
--- PGDataAdapterTest.cs	27 Jul 2003 21:19:39 -0000	1.6
***************
*** 33,37 ****
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@date_field", PGDbType.Date, "date_field").Value = DateTime.Now;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 33,37 ----
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@date_field", PGDbType.Date, 4, "date_field").Value = DateTime.Now;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 74,78 ****
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@date_field", PGDbType.Date, "date_field").Value = DateTime.Now;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 74,78 ----
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@date_field", PGDbType.Date, 4, "date_field").Value = DateTime.Now;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 130,134 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 1;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 130,134 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 1;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 154,158 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 10;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 154,158 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 10;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 178,182 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 40;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 178,182 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 40;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 195,199 ****
  
  			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();
--- 195,199 ----
  
  			command = new PGCommand("SELECT int2_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 40;
  
  			short val = (short)command.ExecuteScalar();
***************
*** 209,213 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 20;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 209,213 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 20;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 226,230 ****
  
  			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();
--- 226,230 ----
  
  			command = new PGCommand("SELECT int8_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 20;
  
  			long val = (long)command.ExecuteScalar();
***************
*** 240,244 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 50;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 240,244 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 50;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 257,261 ****
  
  			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();
--- 257,261 ----
  
  			command = new PGCommand("SELECT double_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 50;
  
  			double val = (double)command.ExecuteScalar();
***************
*** 271,275 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 27;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 271,275 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 27;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 288,292 ****
  
  			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();
--- 288,292 ----
  
  			command = new PGCommand("SELECT money_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 27;
  
  			float val = (float)command.ExecuteScalar();
***************
*** 302,306 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 60;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 302,306 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 60;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 319,323 ****
  
  			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();
--- 319,323 ----
  
  			command = new PGCommand("SELECT numeric_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 60;
  
  			decimal val = (decimal)command.ExecuteScalar();
***************
*** 336,340 ****
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 70;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 336,340 ----
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 70;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 355,359 ****
  
  			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();
--- 355,359 ----
  
  			command = new PGCommand("SELECT date_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 70;
  
  			DateTime val = (DateTime)command.ExecuteScalar();
***************
*** 371,375 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 80;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 371,375 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 80;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 390,394 ****
  
  			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();
--- 390,394 ----
  
  			command = new PGCommand("SELECT time_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 80;
  
  			DateTime val = (DateTime)command.ExecuteScalar();
***************
*** 406,410 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 90;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 406,410 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 90;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 425,429 ****
  
  			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();
--- 425,429 ----
  
  			command = new PGCommand("SELECT timestamp_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 90;
  
  			DateTime val = (DateTime)command.ExecuteScalar();
***************
*** 444,448 ****
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 35;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 444,448 ----
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 35;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient/source PGParameter.cs,1.3,1.4 PGParameterCollection.cs,1.2,1.3

[<car...@us...>]

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

Modified Files:
	PGParameter.cs PGParameterCollection.cs 
Log Message:
Removed non standard constructor from PGParameter and added a new one.

Index: PGParameter.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/PGParameter.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** PGParameter.cs	16 Jul 2003 14:09:12 -0000	1.3
--- PGParameter.cs	27 Jul 2003 21:19:17 -0000	1.4
***************
*** 149,169 ****
  		}
  
! 		public PGParameter(string parameterName, PGDbType dbType) : this()
  		{
  			this.parameterName	= parameterName;
! 			this.pgDbType		= dbType;
  		}
  
! 		public PGParameter(string parameterName, object value)  : this()
  		{
  			this.parameterName	= parameterName;
! 			this.value			= value;
  		}
  
! 		public PGParameter(string parameterName, PGDbType dbType, string sourceColumn) : this()
  		{
  			this.parameterName	= parameterName;
  			this.pgDbType		= dbType;
! 			this.sourceColumn	= sourceColumn;
  		}
  
--- 149,169 ----
  		}
  
! 		public PGParameter(string parameterName, object value)  : this()
  		{
  			this.parameterName	= parameterName;
! 			this.value			= value;
  		}
  
! 		public PGParameter(string parameterName, PGDbType dbType) : this()
  		{
  			this.parameterName	= parameterName;
! 			this.pgDbType		= dbType;
  		}
  
! 		public PGParameter(string parameterName, PGDbType dbType, int size) : this()
  		{
  			this.parameterName	= parameterName;
  			this.pgDbType		= dbType;
! 			this.size			= size;
  		}
  
***************
*** 171,177 ****
  		{
  			this.parameterName	= parameterName;
- 			this.sourceColumn	= sourceColumn;
  			this.pgDbType		= dbType;
  			this.size			= size;
  		}
  
--- 171,177 ----
  		{
  			this.parameterName	= parameterName;
  			this.pgDbType		= dbType;
  			this.size			= size;
+ 			this.sourceColumn	= sourceColumn;
  		}
  

Index: PGParameterCollection.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/PGParameterCollection.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** PGParameterCollection.cs	16 Jul 2003 20:17:49 -0000	1.2
--- PGParameterCollection.cs	27 Jul 2003 21:19:17 -0000	1.3
***************
*** 237,245 ****
  		}
  
! 		public PGParameter Add(string parameterName, PGDbType pgType, string sourceColumn)
  		{
! 			PGParameter param = new PGParameter(parameterName, pgType, sourceColumn);
! 			
! 			return Add(param);
  		}
  
--- 237,245 ----
  		}
  
! 		public PGParameter Add(string parameterName, PGDbType pgType, int size)
  		{
! 			PGParameter param = new PGParameter(parameterName, pgType, size);
! 
! 			return Add(param);		
  		}
  

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

[<car...@us...>]

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

Modified Files:
	PGBaseTest.cs PGCommandTest.cs PGDataAdapterTest.cs 
Log Message:
Added some fixes to the NUnit test suite

Index: PGBaseTest.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source/PGBaseTest.cs,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** PGBaseTest.cs	20 Jul 2003 10:01:19 -0000	1.6
--- PGBaseTest.cs	26 Jul 2003 12:30:31 -0000	1.7
***************
*** 64,67 ****
--- 64,68 ----
  		{			
  			connection.Close();
+ 			System.Threading.Thread.Sleep(2000);
  			dropDatabase();
  		}

Index: PGCommandTest.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source/PGCommandTest.cs,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** PGCommandTest.cs	20 Jul 2003 10:01:19 -0000	1.6
--- PGCommandTest.cs	26 Jul 2003 12:30:31 -0000	1.7
***************
*** 48,52 ****
  					command.Parameters["@char_field"].Value		= "Row " + i.ToString();
  					command.Parameters["@varchar_field"].Value	= "Row Number" + i.ToString();
! 					command.Parameters["@int_Field"].Value		= i;
  
  					command.ExecuteNonQuery();
--- 48,52 ----
  					command.Parameters["@char_field"].Value		= "Row " + i.ToString();
  					command.Parameters["@varchar_field"].Value	= "Row Number" + i.ToString();
! 					command.Parameters["@int4_field"].Value		= i;
  
  					command.ExecuteNonQuery();
***************
*** 103,107 ****
  			command.CommandText = "SELECT char_field FROM public.test_table where int4_field = @int4_field";
  									
! 			command.Parameters.Add("@int_Field", 2);
  						
  			string charFieldValue = command.ExecuteScalar().ToString();
--- 103,107 ----
  			command.CommandText = "SELECT char_field FROM public.test_table where int4_field = @int4_field";
  									
! 			command.Parameters.Add("@int4_field", 2);
  						
  			string charFieldValue = command.ExecuteScalar().ToString();

Index: PGDataAdapterTest.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source/PGDataAdapterTest.cs,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** PGDataAdapterTest.cs	20 Jul 2003 10:01:19 -0000	1.4
--- PGDataAdapterTest.cs	26 Jul 2003 12:30:31 -0000	1.5
***************
*** 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;
--- 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;
***************
*** 322,327 ****
  
  			decimal val = (decimal)command.ExecuteScalar();
! 
! 			Assertion.AssertEquals("numeric_field has not correct value", System.Int16.MaxValue, val);
  		}
  
--- 322,330 ----
  
  			decimal val = (decimal)command.ExecuteScalar();
! 			
! 			if (val != (decimal)System.Int16.MaxValue)
! 			{
! 				Assertion.Fail("numeric_field has not correct value");
! 			}
  		}
  

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests PostgreSql.Data.PGSqlClient.UnitTests.dll.config,1.2,1.3

[<car...@us...>]

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

Modified Files:
	PostgreSql.Data.PGSqlClient.UnitTests.dll.config 
Log Message:
Do not use pooling in the Nunit test suite

Index: PostgreSql.Data.PGSqlClient.UnitTests.dll.config
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/PostgreSql.Data.PGSqlClient.UnitTests.dll.config,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** PostgreSql.Data.PGSqlClient.UnitTests.dll.config	26 Jul 2003 12:30:56 -0000	1.2
--- PostgreSql.Data.PGSqlClient.UnitTests.dll.config	26 Jul 2003 12:49:14 -0000	1.3
***************
*** 8,12 ****
  		<add key="Port" value="5432" />
  		<add key="Connection lifetime" value="1" />
! 		<add key="Pooling" value="true" />
  		<add key="Packet Size" value="8192" />		
  	</appSettings>
--- 8,12 ----
  		<add key="Port" value="5432" />
  		<add key="Connection lifetime" value="1" />
! 		<add key="Pooling" value="false" />
  		<add key="Packet Size" value="8192" />		
  	</appSettings>

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source PGBaseTest.cs,1.7,1.8

[<car...@us...>]

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

Modified Files:
	PGBaseTest.cs 
Log Message:
Remove test code

Index: PGBaseTest.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source/PGBaseTest.cs,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** PGBaseTest.cs	26 Jul 2003 12:30:31 -0000	1.7
--- PGBaseTest.cs	26 Jul 2003 12:48:22 -0000	1.8
***************
*** 64,68 ****
  		{			
  			connection.Close();
- 			System.Threading.Thread.Sleep(2000);
  			dropDatabase();
  		}
--- 64,67 ----

[pgsqlclient-checkins] pgsqlclient changelog.txt,1.24,1.25

[<car...@us...>]

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

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

Index: changelog.txt
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v
retrieving revision 1.24
retrieving revision 1.25
diff -C2 -d -r1.24 -r1.25
*** changelog.txt	24 Jul 2003 11:02:59 -0000	1.24
--- changelog.txt	26 Jul 2003 12:31:33 -0000	1.25
***************
*** 3,6 ****
--- 3,9 ----
  
  
+ < ----------------------------------- Alpha 2 ---------------------------------- >
+ 
+ 
  2003-07-24 Carlos Guzmán Álvarez  <car...@te...>
  

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests PostgreSql.Data.PGSqlClient.UnitTests.dll.config,1.1,1.2

[<car...@us...>]

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

Modified Files:
	PostgreSql.Data.PGSqlClient.UnitTests.dll.config 
Log Message:
Updated Nunit config file

Index: PostgreSql.Data.PGSqlClient.UnitTests.dll.config
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/PostgreSql.Data.PGSqlClient.UnitTests.dll.config,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** PostgreSql.Data.PGSqlClient.UnitTests.dll.config	26 Jul 2003 11:41:23 -0000	1.1
--- PostgreSql.Data.PGSqlClient.UnitTests.dll.config	26 Jul 2003 12:30:56 -0000	1.2
***************
*** 7,11 ****
  		<add key="DataSource" value="localhost" />
  		<add key="Port" value="5432" />
! 		<add key="Connection lifetime" value="15" />
  		<add key="Pooling" value="true" />
  		<add key="Packet Size" value="8192" />		
--- 7,11 ----
  		<add key="DataSource" value="localhost" />
  		<add key="Port" value="5432" />
! 		<add key="Connection lifetime" value="1" />
  		<add key="Pooling" value="true" />
  		<add key="Packet Size" value="8192" />		

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source PGConnectionTest.cs,1.2,1.3

[<car...@us...>]

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

Modified Files:
	PGConnectionTest.cs 
Log Message:
Added new test case


Index: PGConnectionTest.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source/PGConnectionTest.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** PGConnectionTest.cs	15 Jul 2003 19:11:39 -0000	1.2
--- PGConnectionTest.cs	26 Jul 2003 11:42:29 -0000	1.3
***************
*** 83,86 ****
--- 83,95 ----
  			PGCommand command = Connection.CreateCommand();
  		}
+ 
+ 		[Test]
+ 		public void DbSchemaTest()
+ 		{
+ 			Connection.GetDbSchemaTable(PGDbSchemaType.Aggregates, null);
+ 			Connection.GetDbSchemaTable(PGDbSchemaType.Casts, null);
+ 			Connection.GetDbSchemaTable(PGDbSchemaType.Check_Constraints, null);
+ 			Connection.GetDbSchemaTable(PGDbSchemaType.Columns, null);
+ 		}
  	}
  }

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests PostgreSql.Data.PGSqlClient.UnitTests.dll.config,NONE,1.1

[<car...@us...>]

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

Added Files:
	PostgreSql.Data.PGSqlClient.UnitTests.dll.config 
Log Message:
Add new config file for Unit tests

--- NEW FILE: PostgreSql.Data.PGSqlClient.UnitTests.dll.config ---
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
	<appSettings>
		<add key="User" value="postgres" />
		<add key="Password" value="" />
		<add key="Database" value="test" />
		<add key="DataSource" value="localhost" />
		<add key="Port" value="5432" />
		<add key="Connection lifetime" value="15" />
		<add key="Pooling" value="true" />
		<add key="Packet Size" value="8192" />		
	</appSettings>
</configuration>

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests UnitTests.config,1.1.1.1,NONE

[<car...@us...>]

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

Removed Files:
	UnitTests.config 
Log Message:
removed file

--- UnitTests.config DELETED ---

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient/source/DbSchema PGTableStatisticsSchema.cs,NONE,1.1

[<car...@us...>]

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

Added Files:
	PGTableStatisticsSchema.cs 
Log Message:
Added new database schema class


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

[pgsqlclient-checkins] pgsqlclient changelog.txt,1.23,1.24

[<car...@us...>]

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

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

Index: changelog.txt
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v
retrieving revision 1.23
retrieving revision 1.24
diff -C2 -d -r1.23 -r1.24
*** changelog.txt	24 Jul 2003 11:01:07 -0000	1.23
--- changelog.txt	24 Jul 2003 11:02:59 -0000	1.24
***************
*** 7,10 ****
--- 7,11 ----
  	* Added Windows installation project file.
  
+ 	* Added CHANGES.TXT file.a
  
  

[pgsqlclient-checkins] pgsqlclient changes.txt,NONE,1.1

[<car...@us...>]

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

Added Files:
	changes.txt 
Log Message:
Added CHANGES.TXT file

--- NEW FILE: changes.txt ---
PGSqlClient - ADO.NET Data Provider for PostgreSQL 7.4+
-------------------------------------------------------

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

[<car...@us...>]

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

Modified Files:
	PGSqlClient.build 
Log Message:
Updated nant build file.

Index: PGSqlClient.build
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PGSqlClient.build,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** PGSqlClient.build	22 Jul 2003 09:35:10 -0000	1.4
--- PGSqlClient.build	24 Jul 2003 11:01:36 -0000	1.5
***************
*** 14,18 ****
  	<property name="build.dir" value="build" />
  	<property name="src.dir" value="${project.FormalName}\source" />
! 	<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" />
--- 14,18 ----
  	<property name="build.dir" value="build" />
  	<property name="src.dir" value="${project.FormalName}\source" />
! 	<property name="nunit.test.dir" value="PostgreSql.Data.PGSqlClient.UnitTests"/>
  	<property name="resources.dir" value="${src.dir}\Resources" />
  	<property name="distribution.dir" value="${build.dir}\distribution" />
***************
*** 156,164 ****
  		<copy todir="${build.dir}">
  			<fileset basedir="${nunit.test.dir}">
! 				<includes name="${project.FormalName}.Tests.dll.config" />
  			</fileset>
  		</copy>
  		<!-- compile PostgreSql.Data.PGSqlClient.Tests -->
! 		<csc output="${build.dir}\${project.FormalName}.Tests.dll" target="library">
  			<sources>
  				<includes name="${nunit.test.dir}/**/*.cs" />
--- 156,164 ----
  		<copy todir="${build.dir}">
  			<fileset basedir="${nunit.test.dir}">
! 				<includes name="*.config" />
  			</fileset>
  		</copy>
  		<!-- compile PostgreSql.Data.PGSqlClient.Tests -->
! 		<csc output="${build.dir}\${project.FormalName}.UnitTests.dll" target="library">
  			<sources>
  				<includes name="${nunit.test.dir}/**/*.cs" />
***************
*** 188,191 ****
--- 188,192 ----
  			<fileset basedir=".">
  				<includes name="*.txt" />
+ 				<includes name="*.html" />
  			</fileset>
  		</copy>

[pgsqlclient-checkins] pgsqlclient changelog.txt,1.22,1.23

[<car...@us...>]

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

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

Index: changelog.txt
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v
retrieving revision 1.22
retrieving revision 1.23
diff -C2 -d -r1.22 -r1.23
*** changelog.txt	22 Jul 2003 17:23:30 -0000	1.22
--- changelog.txt	24 Jul 2003 11:01:07 -0000	1.23
***************
*** 3,6 ****
--- 3,12 ----
  
  
+ 2003-07-24 Carlos Guzmán Álvarez  <car...@te...>
+ 
+ 	* Added Windows installation project file.
+ 
+ 
+ 
  2003-07-22 Carlos Guzmán Álvarez  <car...@te...>
  

[pgsqlclient-checkins] pgsqlclient/WindowsSetup PGSqlClientSetup.gi2,NONE,1.1

[<car...@us...>]

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

Added Files:
	PGSqlClientSetup.gi2 
Log Message:
Added Windows Installation project file

--- NEW FILE: PGSqlClientSetup.gi2 ---
<gi2project version="3.6">
	<packages>
		<package filename="setup" main="1">
			<components>
				<component id="Main" name="Main">
					<files>
						<file src="..\build\distribution\*.*" dst="%InstallPath%\*.*" />
						<file src="..\build\distribution\PostgreSql.Data.PGSqlClient.dll" dst="%GAC%\PostgreSql.Data.PGSqlClient.dll" />
					</files>
					<shortcuts>
						<shortcut name="%ProgramsMenu%\%ProgramGroup%\Uninstall %AppName%" cmdline="%InstallPath%\Uninstall.exe" />
					</shortcuts>
				</component>
				<!--component id="Help" name="Help">
					<files>
						<file src="..\build\distribution\*.chm" dst="%InstallPath%\*.*" />
					</files>
					<shortcuts>
						<shortcut name="%ProgramsMenu%\%ProgramGroup%\SDK" cmdline="%InstallPath%\PGSqlClientSDK.chm" />
					</shortcuts>
				</component -->
				<component id="License" name="License">
					<files>
						<file src="..\build\distribution\LICENSE.TXT" dst="%InstallPath%\*.*" />
					</files>
					<shortcuts>
						<shortcut name="%ProgramsMenu%\%ProgramGroup%\License" cmdline="%InstallPath%\LICENSE.TXT" />
					</shortcuts>
				</component>
				<component id="Readme" name="Readme">
					<files>
						<file src="..\build\distribution\README.TXT" dst="%InstallPath%\*.*" />
					</files>
					<shortcuts>
						<shortcut name="%ProgramsMenu%\%ProgramGroup%\Readme" cmdline="%InstallPath%\README.TXT" />
					</shortcuts>
				</component>
				<component id="Changes" name="Changes">
					<files>
						<file src="..\build\distribution\CHANGES.TXT" dst="%InstallPath%\*.*" />
					</files>
					<shortcuts>
						<shortcut name="%ProgramsMenu%\%ProgramGroup%\Changes" cmdline="%InstallPath%\Changes.TXT" />
					</shortcuts>
				</component>
			</components>
			<plugins>
				<plugin id="StdUI">
					<config>
						<paramgroup name="Config">
							<param name="PreInstallDialogSequence" value="DLG_LANGUAGE,DLG_WELCOME,DLG_LICENSE,DLG_README,DLG_DIR,DLG_GROUP,DLG_START" />
							<param name="PostInstallDialogSequence"/>
							<param name="ShowMainWindow" value="0" />
							<param name="ShowDialogTitle" value="1" />
							<param name="ShowDialogSubTitle" value="1" />
							<param name="ShowFinalDialog" value="1" />
							<param name="GradientTopColor" value="0" />
							<param name="GradientBottomColor" value="$FF0000" />
							<param name="StretchBanner" value="0" />
							<param name="DialogFont" value="MS Sans Serif,8" />
							<param name="DialogBitmap" value="%Presetup%\gins.bmp" />
							<param name="DialogTitleFont" value="MS Sans Serif,10,$C08000,B" />
							<param name="DialogTitleShadow" value="0" />
							<param name="DialogTitleShadowColor" value="$C0C0C0" />
							<param name="DialogPosition" value="1,1" />
							<param name="DialogSubTitleFont" value="MS Sans Serif,8,$000000" />
						</paramgroup>
						<paramgroup name="Labels">
							<param name="TitleShadow" value="%AppName%,33,23,0,Times New Roman,30,$606060,B" />
							<param name="Title" value="%AppName%,30,20,0,Times New Roman,30,$FF0000,B" />
						</paramgroup>
						<paramgroup name="DialogBitmaps">
							<param name="DLG_LANGUAGE"/>
							<param name="DLG_WELCOME"/>
							<param name="DLG_LICENSE"/>
							<param name="DLG_README"/>
							<param name="DLG_DIR"/>
							<param name="DLG_INSTALLTYPE"/>
							<param name="DLG_FEATURES"/>
							<param name="DLG_START"/>
							<param name="DLG_PROGRESS"/>
							<param name="DLG_FINISH"/>
							<param name="DLG_NOTFINISH"/>
							<param name="DLG_REBOOT"/>
							<param name="DLG_PASSWORD"/>
							<param name="DLG_GROUP"/>
						</paramgroup>
					</config>
				</plugin>
			</plugins>
			<presetup>
				<file action="add" src="presetup\*.*"/>
				<file src="..\build\distribution\README.TXT" />
				<file src="..\build\distribution\LICENSE.TXT" />
			</presetup>
		</package>
	</packages>
    <!-- launchconditions>
	    <launchcondition condition = "NETFrameworkInstalled(1.0)" msg="You need to have installed the Microsoft .NET Framework 1.0 before install the PGSqlClient .NET Data Provider" />
    </launchconditions-->
	<variables>
		<var name="AppID" value="PGSqlClient .NET Data Provider 1.0 Alpha 1" />
		<var name="AppName" value="PGSqlClient .NET Data Provider 1.0 Alpha 1" />
		<var name="OutputPath" value="Output" type="normal"/>
		<var name="Password" type="normal"/>
		<var name="CompressionLevel" value="7" type="normal" />
        <var name="Languages" value="Bgr,Csy,Deu,Enu,Epo,Fra,Hun,Nld,Plk,Ptb,Rus,Sky,Ukr,Esn,Ita,Jpn" type="normal"/>
		<var name="AutoSelectLanguage" value="1" type="normal"/>
		<var name="Uninstall" value="1" />
		<var name="ProgramGroup" value="PGSqlClient 1.0 Alpha 1" />
		<var name="AppFolder" value="%ProgramsMenu%\%ProgramGroup%" type="normal"/>
		<var name="InstallPath" value="%ProgramFiles%\PGSqlClient .NET Data Provider 1.0" type="normal"/>
	</variables>
</gi2project>

[pgsqlclient-checkins] pgsqlclient/WindowsSetup - New directory

[<car...@us...>]

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

Log Message:
Directory /cvsroot/pgsqlclient/pgsqlclient/WindowsSetup added to the repository

[pgsqlclient-checkins] pgsqlclient changelog.txt,1.21,1.22

[<car...@us...>]

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

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

Index: changelog.txt
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v
retrieving revision 1.21
retrieving revision 1.22
diff -C2 -d -r1.21 -r1.22
*** changelog.txt	22 Jul 2003 09:35:27 -0000	1.21
--- changelog.txt	22 Jul 2003 17:23:30 -0000	1.22
***************
*** 5,14 ****
  2003-07-22 Carlos Guzmán Álvarez  <car...@te...>
  
! 		* Changed build file for use new NUnit v2.1.
  
  
  2003-07-21 Carlos Guzmán Álvarez  <car...@te...>
  
! 		* Minor changes to db schema support
  
  
--- 5,16 ----
  2003-07-22 Carlos Guzmán Álvarez  <car...@te...>
  
! 	* Changed build file for use new NUnit v2.1.
! 
! 	* Improved database schema handling.
  
  
  2003-07-21 Carlos Guzmán Álvarez  <car...@te...>
  
! 	* Minor changes to db schema support
  
  

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

[<car...@us...>]

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

Modified Files:
	PGDbSchemaType.cs 
Log Message:
Improved database schema handling.

Index: PGDbSchemaType.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/PGDbSchemaType.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PGDbSchemaType.cs	12 Jul 2003 08:11:21 -0000	1.1.1.1
--- PGDbSchemaType.cs	22 Jul 2003 17:22:20 -0000	1.2
***************
*** 26,29 ****
--- 26,30 ----
  		Casts,
  		Check_Constraints,
+ 		Check_Constraints_By_Table,
  		Columns,
  		Database,
***************
*** 34,38 ****
  		Primary_Keys,
  		Functions,
- 		Function_Parameters,
  		Function_Privileges,
  		Provider_Types,
--- 35,38 ----
***************
*** 50,53 ****
--- 50,54 ----
  		Usage_Privileges,
  		Users,
+ 		View_Column_Usage,
  		Views,
  		View_Privileges,

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient/source/DbSchema PGCheckConstraintsByTable.cs,NONE,1.1

[<car...@us...>]

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

Added Files:
	PGCheckConstraintsByTable.cs 
Log Message:
Improved database schema handling.

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

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient/source/DbSchema PGFunctionPrivilegesSchema.cs,NONE,1.1

[<car...@us...>]

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

Added Files:
	PGFunctionPrivilegesSchema.cs 
Log Message:
Improved database schema handling.

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

[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient/source/DbSchema PGCheckConstraints.cs,1.2,1.3 PGDbSchemaFactory.cs,1.1.1.1,1.2 PGFunctionsSchema.cs,1.2,1.3 PGTablePrivilegesSchema.cs,1.1.1.1,1.2 PGTablesSchema.cs,1.1.1.1,1.2

[<car...@us...>]

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

Modified Files:
	PGCheckConstraints.cs PGDbSchemaFactory.cs 
	PGFunctionsSchema.cs PGTablePrivilegesSchema.cs 
	PGTablesSchema.cs 
Log Message:
Improved database schema handling.

Index: PGCheckConstraints.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/DbSchema/PGCheckConstraints.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** PGCheckConstraints.cs	21 Jul 2003 19:54:22 -0000	1.2
--- PGCheckConstraints.cs	22 Jul 2003 17:20:10 -0000	1.3
***************
*** 54,59 ****
  		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,58 ----
  		public override void AddJoins()
  		{
! 			AddJoin("left join", "pg_namespace"		, "pg_constraint.connamespace = pg_namespace.oid");
  			AddJoin("left join", "pg_description"	, "pg_constraint.oid = pg_description.objoid");
  		}
***************
*** 62,67 ****
  		{
  			AddOrderBy("pg_namespace.nspname");
! 			AddOrderBy("pg_class.relname");
! 			AddOrderBy("pg_constraint.conname");			
  		}
  
--- 61,65 ----
  		{
  			AddOrderBy("pg_namespace.nspname");
! 			AddOrderBy("pg_constraint.conname");
  		}
  

Index: PGDbSchemaFactory.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/DbSchema/PGDbSchemaFactory.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PGDbSchemaFactory.cs	12 Jul 2003 08:11:22 -0000	1.1.1.1
--- PGDbSchemaFactory.cs	22 Jul 2003 17:20:10 -0000	1.2
***************
*** 41,44 ****
--- 41,48 ----
  					break;
  
+ 				case PGDbSchemaType.Check_Constraints_By_Table:
+ 					returnSchema = new PGCheckConstraintsByTableSchema();
+ 					break;
+ 
  				case PGDbSchemaType.Columns:
  					returnSchema = new PGColumnsSchema();
***************
*** 69,78 ****
  					break;
  
! 				case PGDbSchemaType.Functions:
! 					returnSchema = new PGFunctionsSchema();
  					break;
  
! 				case PGDbSchemaType.Function_Parameters: 
! 				case PGDbSchemaType.Function_Privileges:
  					break;
  
--- 73,82 ----
  					break;
  
! 				case PGDbSchemaType.Function_Privileges:
! 					returnSchema = new PGFunctionPrivilegesSchema();
  					break;
  
! 				case PGDbSchemaType.Functions:
! 					returnSchema = new PGFunctionsSchema();
  					break;
  
***************
*** 114,118 ****
  					break;
  
! 				case PGDbSchemaType.Trigger_Parameters: 
  				case PGDbSchemaType.Trigger_Privileges: 
  					break;
--- 118,124 ----
  					break;
  
! 				case PGDbSchemaType.Trigger_Parameters:
! 					break;
! 
  				case PGDbSchemaType.Trigger_Privileges: 
  					break;

Index: PGFunctionsSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/DbSchema/PGFunctionsSchema.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** PGFunctionsSchema.cs	21 Jul 2003 19:53:35 -0000	1.2
--- PGFunctionsSchema.cs	22 Jul 2003 17:20:10 -0000	1.3
***************
*** 42,47 ****
  		public override void AddRestrictionColumns()
  		{
! 			AddRestrictionColumn("pg_namespace.nspname"	, "PROCEDURE_SCHEMA", null);
! 			AddRestrictionColumn("pg_proc.proname"		, "PROCEDURE_NAME", null);
  		}
  
--- 42,47 ----
  		public override void AddRestrictionColumns()
  		{
! 			AddRestrictionColumn("pg_namespace.nspname"	, "FUNCTION_SCHEMA", null);
! 			AddRestrictionColumn("pg_proc.proname"		, "FUNCTION_NAME", null);
  		}
  
***************
*** 52,56 ****
--- 52,61 ----
  			AddDataColumn("pg_proc.prosecdef"	, "IS_SECURITY_DEFINER");
  			AddDataColumn("pg_proc.proisstrict"	, "IS_STRICT");
+ 			AddDataColumn(getVolatileExpression("pg_proc.provolatile")	, "VOLATILE");
  			AddDataColumn("pg_proc.proretset"	, "RETURNS_SET");
+ 			AddDataColumn("pg_proc.prorettype"	, "RETURN_TYPE");
+ 			AddDataColumn("pg_proc.pronargs"	, "ARGUMENT_NUMBER");
+ 			AddDataColumn("pg_proc.proargtypes"	, "ARGUMENTS");
+ 			AddDataColumn("pg_proc.prosrc"		, "SOURCE");
  			AddDataColumn("pg_description.description", "DESCRIPTION");
  		}
***************
*** 82,85 ****
--- 87,107 ----
  
  			return parsed;
+ 		}
+ 
+ 		#endregion
+ 
+ 		#region PRIVATE_METHODS
+ 
+ 		private string getVolatileExpression(string fieldName)
+ 		{
+ 			StringBuilder expression = new StringBuilder();
+ 
+ 			expression.AppendFormat(" case {0} ", fieldName);
+ 			expression.Append(" when 'i' THEN 'INMUTABLE'");
+ 			expression.Append(" when 's' THEN 'STABLE'");
+ 			expression.Append(" when 'v' THEN 'VOLATILE'");
+ 			expression.Append(" END ");
+ 
+ 			return expression.ToString();
  		}
  

Index: PGTablePrivilegesSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/DbSchema/PGTablePrivilegesSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PGTablePrivilegesSchema.cs	12 Jul 2003 08:11:22 -0000	1.1.1.1
--- PGTablePrivilegesSchema.cs	22 Jul 2003 17:20:10 -0000	1.2
***************
*** 43,48 ****
  		public override void AddRestrictionColumns()
  		{
! 			AddRestrictionColumn("pg_namespace.nspname", "TABLE_SCHEMA", null);
! 			AddRestrictionColumn("pg_class.relname", "TABLE_NAME", null);
  		}
  
--- 43,48 ----
  		public override void AddRestrictionColumns()
  		{
! 			AddRestrictionColumn("pg_namespace.nspname"	, "TABLE_SCHEMA", null);
! 			AddRestrictionColumn("pg_class.relname"		, "TABLE_NAME", null);
  		}
  
***************
*** 101,105 ****
  			return privileges;
  		}
- 
  
  		private DataTable getPrivilegesDataTable()
--- 101,104 ----

Index: PGTablesSchema.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/DbSchema/PGTablesSchema.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PGTablesSchema.cs	12 Jul 2003 08:11:22 -0000	1.1.1.1
--- PGTablesSchema.cs	22 Jul 2003 17:20:10 -0000	1.2
***************
*** 42,47 ****
  		public override void AddRestrictionColumns()
  		{
! 			AddRestrictionColumn("pg_namespace.nspname", "TABLE_SCHEMA", null);
! 			AddRestrictionColumn("pg_class.relname", "TABLE_NAME", null);
  			AddRestrictionColumn(getTableTypeExpression("pg_class.relkind"), "TABLE_TYPE", "pg_class.relkind");
  		}
--- 42,47 ----
  		public override void AddRestrictionColumns()
  		{
! 			AddRestrictionColumn("pg_namespace.nspname"	, "TABLE_SCHEMA", null);
! 			AddRestrictionColumn("pg_class.relname"		, "TABLE_NAME", null);
  			AddRestrictionColumn(getTableTypeExpression("pg_class.relkind"), "TABLE_TYPE", "pg_class.relkind");
  		}
***************
*** 49,59 ****
  		public override void AddDataColumns()
  		{
! 			AddDataColumn("pg_class.relhasindex", "HAS_INDEXES");
! 			AddDataColumn("pg_class.relisshared", "IS_SHARED");
! 			AddDataColumn("pg_class.relchecks", "CONSTRAINT_COUNT");
! 			AddDataColumn("pg_class.reltriggers", "TRIGGER_COUNT");
! 			AddDataColumn("pg_class.relhaspkey", "HAS_PRIMARY");
! 			AddDataColumn("pg_class.relhasrules", "HAS_RULES");
! 			AddDataColumn("pg_class.relhassubclass", "HAS_SUBCLASS");
  			AddDataColumn("pg_description.description", "DESCRIPTION");
  		}
--- 49,59 ----
  		public override void AddDataColumns()
  		{
! 			AddDataColumn("pg_class.relhasindex"	, "HAS_INDEXES");
! 			AddDataColumn("pg_class.relisshared"	, "IS_SHARED");
! 			AddDataColumn("pg_class.relchecks"		, "CONSTRAINT_COUNT");
! 			AddDataColumn("pg_class.reltriggers"	, "TRIGGER_COUNT");
! 			AddDataColumn("pg_class.relhaspkey"		, "HAS_PRIMARY");
! 			AddDataColumn("pg_class.relhasrules"	, "HAS_RULES");
! 			AddDataColumn("pg_class.relhassubclass"	, "HAS_SUBCLASS");
  			AddDataColumn("pg_description.description", "DESCRIPTION");
  		}
***************
*** 61,66 ****
  		public override void AddJoins()
  		{
! 			AddJoin("left join", "pg_namespace", "pg_class.relnamespace = pg_namespace.oid");
! 			AddJoin("left join", "pg_description", "pg_class.oid = pg_description.objoid");
  		}
  
--- 61,66 ----
  		public override void AddJoins()
  		{
! 			AddJoin("left join", "pg_namespace"		, "pg_class.relnamespace = pg_namespace.oid");
! 			AddJoin("left join", "pg_description"	, "pg_class.oid = pg_description.objoid");
  		}
  

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

[<car...@us...>]

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

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

Index: changelog.txt
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v
retrieving revision 1.20
retrieving revision 1.21
diff -C2 -d -r1.20 -r1.21
*** changelog.txt	21 Jul 2003 19:56:01 -0000	1.20
--- changelog.txt	22 Jul 2003 09:35:27 -0000	1.21
***************
*** 2,5 ****
--- 2,11 ----
  -------------------------------------------------------
  
+ 
+ 2003-07-22 Carlos Guzmán Álvarez  <car...@te...>
+ 
+ 		* Changed build file for use new NUnit v2.1.
+ 
+ 
  2003-07-21 Carlos Guzmán Álvarez  <car...@te...>