[Nhibernate-commit] SF.net SVN: nhibernate:[4070] trunk/nhibernate/src/NHibernate/Dialect/ PostgreSQLDialect.cs

[<dar...@us...>]

Revision: 4070
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=4070&view=rev
Author:   darioquintana
Date:     2009-02-07 22:32:27 +0000 (Sat, 07 Feb 2009)

Log Message:
-----------
- Bug fixes in Sequence support.
- Preparing to support sequence-identity

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate/Dialect/PostgreSQLDialect.cs

Modified: trunk/nhibernate/src/NHibernate/Dialect/PostgreSQLDialect.cs
===================================================================
--- trunk/nhibernate/src/NHibernate/Dialect/PostgreSQLDialect.cs	2009-02-07 21:16:36 UTC (rev 4069)
+++ trunk/nhibernate/src/NHibernate/Dialect/PostgreSQLDialect.cs	2009-02-07 22:32:27 UTC (rev 4070)
@@ -85,9 +85,14 @@
 
 		public override string GetSequenceNextValString(string sequenceName)
 		{
-			return string.Concat("select nextval ('", sequenceName, "')");
+			return string.Concat("select ",GetSelectSequenceNextValString(sequenceName));
 		}
 
+		public override string GetSelectSequenceNextValString(string sequenceName)
+		{
+			return string.Concat("nextval ('", sequenceName, "')");
+		}
+
 		public override string GetCreateSequenceString(string sequenceName)
 		{
 			return "create sequence " + sequenceName;
@@ -98,6 +103,11 @@
 			return "drop sequence " + sequenceName;
 		}
 
+		public override SqlString AddIdentifierOutParameterToInsert(SqlString insertString, string identifierColumnName, string parameterName)
+		{
+			return insertString.Append(" returning " + identifierColumnName);
+		}
+
 		public override bool SupportsSequences
 		{
 			get { return true; }


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.