Namespaces

Types

Type PostgreSQL81Dialect

Namespace NHibernate.Dialect

Parent PostgreSQLDialect

Methods

Properties

Public instance methods

SqlString AddIdentitySelectToInsert(SqlString insertSql, string identityColumn, string tableName)

Parameters
return SqlString
SqlString insertSql
string identityColumn
string tableName

string AppendLockHint(LockMode lockMode, string tableName)

Parameters
return string
LockMode lockMode
string tableName

SqlString ApplyLocksToSql(SqlString sql, IDictionary aliasedLockModes, IDictionary keyColumnNames)

Parameters
return SqlString
SqlString sql
IDictionary aliasedLockModes
IDictionary keyColumnNames

CaseFragment CreateCaseFragment()

Parameters
return CaseFragment

JoinFragment CreateOuterJoinFragment()

Parameters
return JoinFragment

bool Equals(object obj)

Parameters
return bool
object obj

string GetAddForeignKeyConstraintString(string constraintName, String[] foreignKey, string referencedTable, String[] primaryKey)

Parameters
return string
string constraintName
String[] foreignKey
string referencedTable
String[] primaryKey

string GetAddPrimaryKeyConstraintString(string constraintName)

Parameters
return string
string constraintName

string GetCastTypeName(SqlType sqlType)

Parameters
return string
SqlType sqlType

string GetCreateSequenceString(string sequenceName)

Parameters
return string
string sequenceName

string GetDropForeignKeyConstraintString(string constraintName)

Parameters
return string
string constraintName

string GetDropIndexConstraintString(string constraintName)

Parameters
return string
string constraintName

string GetDropPrimaryKeyConstraintString(string constraintName)

Parameters
return string
string constraintName

string GetDropSequenceString(string sequenceName)

Parameters
return string
string sequenceName

string GetDropTableString(string tableName)

Parameters
return string
string tableName

string GetForUpdateNowaitString(string aliases)

Parameters
return string
string aliases

string GetForUpdateString(string aliases)

Parameters
return string
string aliases

string GetForUpdateString(LockMode lockMode)

Parameters
return string
LockMode lockMode

int GetHashCode()

Parameters
return int

string GetIdentitySelectString(string identityColumn, string tableName)

PostgreSQL 8.1 and above defined the fuction lastval() that returns the value of the last sequence that nextval() was used on in the current session. Call lastval() if nextval() has not yet been called in the current session throw an exception.
Parameters
return string
string identityColumn not used
string tableName not used

SqlString GetLimitString(SqlString querySqlString, bool hasOffset)

Parameters
return SqlString
SqlString querySqlString
bool hasOffset

SqlString GetLimitString(SqlString querySqlString, int offset, int limit)

Parameters
return SqlString
SqlString querySqlString
int offset
int limit

string GetSequenceNextValString(string sequenceName)

Parameters
return string
string sequenceName

Type GetType()

Parameters
return Type

string GetTypeName(SqlType sqlType)

Parameters
return string
SqlType sqlType

string GetTypeName(SqlType sqlType, int length)

Parameters
return string
SqlType sqlType
int length

bool IsQuoted(string name)

Parameters
return bool
string name

string QuoteForAliasName(string aliasName)

Parameters
return string
string aliasName

string QuoteForColumnName(string columnName)

Parameters
return string
string columnName

string QuoteForSchemaName(string schemaName)

Parameters
return string
string schemaName

string QuoteForTableName(string tableName)

Parameters
return string
string tableName

string ToString()

Parameters
return string

String[] UnQuote(String[] quoted)

Parameters
return String[]
String[] quoted

string UnQuote(string quoted)

Parameters
return string
string quoted

Public properties

string AddColumnString get;

return string

bool BindLimitParametersFirst get;

return bool

bool BindLimitParametersInReverseOrder get;

return bool

Char CloseQuote get;

return Char

IDictionary DefaultProperties get;

return IDictionary

bool DropConstraints get;

return bool

string ForUpdateNowaitString get;

return string

bool ForUpdateOfColumns get;

return bool

string ForUpdateString get;

return string

IDictionary Functions get;

return IDictionary

bool HasAlterTable get;

return bool

bool HasDataTypeInIdentityColumn get;

PostgreSQL doesn't have type in identity column.
To create an identity column it uses the SQL syntax CREATE TABLE tablename (colname SERIAL); or CREATE TABLE tablename (colname BIGSERIAL);
return bool

string IdentityColumnString get;

PostgreSQL supports serial and serial4 type for 4 bytes integer auto increment column. bigserial or serial8 can be used for 8 bytes integer auto increment column. This dialect uses serial
return string

string IdentityInsertString get;

return string

string LowercaseFunction get;

return string

int MaxAliasLength get;

return int

string MultipleQueriesSeparator get;

return string

string NoColumnsInsertString get;

The sql syntax to insert a row without specifying any column in PostgreSQL is INSERT INTO table DEFAULT VALUES;
return string

string NullColumnString get;

return string

Char OpenQuote get;

return Char

bool QualifyIndexName get;

return bool

bool SupportsIdentityColumns get;

PostgreSQL supports Identity column using the "SERIAL" type.
return bool

bool SupportsLimit get;

return bool

bool SupportsLimitOffset get;

return bool

bool SupportsSequences get;

return bool

bool SupportsSubSelects get;

return bool

bool SupportsUnique get;

return bool

bool SupportsVariableLimit get;

return bool

long TimestampResolutionInTicks get;

return long

bool UseMaxForLimit get;

return bool