^}E     None%&'+-1<FQTV=@Information required to connect to a PostgreSQL database using  persistentE's generic facilities. These values are the same that are given to .The connection string.;How many connections should be held on the connection pool.Avoid orphan instances.}PostgresServerVersionError exception. This is thrown when persistent is unable to find the version of the postgreSQL server.A libpqE connection string. A simple example of connection string would be ?"host=localhost port=5432 user=test dbname=test password=test"*. Please read libpq's documentation at  <http://www.postgresql.org/docs/9.1/static/libpq-connect.html1 for more details on how to create such strings.Create a PostgreSQL connection pool and run the given action. The pool is properly released after the action finishes using it. Note that you should not use the given  ; outside the action since it may be already been released.Same as withPostgresPool`, but takes a callback for obtaining the server version (to workaround an Amazon Redshift bug).Create a PostgreSQL connection pool. Note that it's your responsibility to properly close the connection pool when unneeded. Use $ for an automatic resource control.Same as , but additionally takes a callback function for some connection-specific tweaking to be performed after connection creation. This could be used, for example, to change the schema. For more information, see: Ahttps://groups.google.com/d/msg/yesodweb/qUXrEN_swEo/O0pFwqwQIdcJ Same as other similarly-named functions in this module, but takes callbacks for obtaining the server version (to workaround an Amazon Redshift bug) and connection-specific tweaking (to change the schema). Same as O, but instead of opening a pool of connections, only one connection is opened. Same as  `, but takes a callback for obtaining the server version (to workaround an Amazon Redshift bug).!"Gets the PostgreSQL server version"Choose upsert sql generation function based on postgresql version. PostgreSQL version >= 9.5 supports native upsert feature, so depending upon that we have to choose how the sql query is generated.  Generate a # from a $%dCreate the backend given a logging function, server version, mutable statement cell, and connection&ISQL for inserting multiple rows at once and returning their primary keys.'HReturns all of the columns in the given table currently in the database.(MCheck if a column name is listed as the "safe to remove" in the entity list.)PIntelligent comparison of SQL types, to account for SqlInt32 vs SqlOther integer*?Get the references to be added to a table for the given column. [get the SQL string for the table that a PeristEntity represents Useful for raw SQL queries[get the SQL string for the field that an EntityField represents Useful for raw SQL queriesjMock a migration even when the database is not present. This function performs the same functionality of +C with the difference that an actualy database isn't needed for it."Connection string to the database.3Number of connections to be kept open in the pool.5Action to be executed that uses the connection pool.+action to perform to get the server version"Connection string to the database.3Number of connections to be kept open in the pool.5Action to be executed that uses the connection pool."Connection string to the database.3Number of connections to be kept open in the pool.-action to perform after connection is created"Connection string to the database.2Number of connections to be kept open in the pool. +action to perform to get the server version-action to perform after connection is created"Connection string to the database.2Number of connections to be kept open in the pool., table name-./0123456789:;<=>?@+ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ #      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~           !"#$%!&'()*+,-./0!123!45!46!78!79!7:!;<!;=!>?!>@!>A!>B!>C!>D!>E!1F!1G!1H!1I!1J!1K!1L!1M!NO!NP!NQ!NR!NS!NT!NU!NV!NW!NX!YZ!Y[!Y\!Y]!Y^!Y_!`a!`b!`c!`d!`e!`f!gh!gi!gj!gk!gl!gm!gn!go!gp!gq!gr!gs!gt!gu!gv!gw!gx!gy!z{!z|!"*!"}!"}!"~!"!"!"!"!"!"!"!"!"!"!"!"!"!"!"!"!"!"!&!&!&!&!&!&!&!&!&!&!&!&!&!&!&'!&!&!&!&!&!&!&!&!&!&!&!&!&!&!&!&!&!&!&!&!&!&!&!&!&!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!>!>!>!>!>!>!!!!!!!!!!!!!!!!!!!!!!! ! ! ! ! !!!!!!!!!!!!!!!!!!!! !!!"!#!$!%!&!&!'!(!)!*!+!,!-!-!.!/!01!02!03!04!05!05!67!68!69!6:!6;!6<!6=!6>!6?!6@!6A!6B!6C!6D!6E!6E!6F!6G!6H!6I!6J!6K!6L!6M!6N!6O!6P!6Q!6Q!6R!6S!6S!6T!6U!6V!6W!6X!6Y!6Z!6Z!6[!6\!6]!6^!6_!6`!6a!6b!6c!6d!6e!6f!6g!6h!6h!6i!6j!6k!6k!6l!6m!6n!6o!6o!6p!6q!6r!6s!6t!6t!6u!6v!6w!6x!6x!6y!6z!6{!6|!6}!6~!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6!6%!6!6!6!6!6!6!6!6!6!6!6!6!!!!!!! 4persistent-postgresql-2.6.2.2-CzcEguvePyX1t8lDUZZcUgDatabase.Persist.Postgresql PostgresConf pgConnStr pgPoolSizeConnectionStringwithPostgresqlPoolwithPostgresqlPoolWithVersioncreatePostgresqlPoolcreatePostgresqlPoolModified'createPostgresqlPoolModifiedWithVersionwithPostgresqlConnwithPostgresqlConnWithVersionopenSimpleConn tableName fieldName mockMigration%$fExceptionPostgresServerVersionError $fShowPostgresServerVersionError$fToFieldUnknown$fFromFieldUnknown $fToFieldP$fPersistConfigPostgresConf$fFromJSONPostgresConf $fEqUnknown $fShowUnknown $fReadUnknown $fOrdUnknown$fShowPostgresConf$fReadPostgresConf$fDataPostgresConfPPostgresServerVersionError'persistent-2.7.3-HVv8fDFgNycFbLpuUStcnzDatabase.Persist.Sql.TypesConnectionPoolgetServerVersionupsertFunction#Database.Persist.Sql.Types.Internal SqlBackend0postgresql-simple-0.5.3.0-F5ZWV7bgEgBHMmqiDrz13B#Database.PostgreSQL.Simple.Internal Connection createBackendinsertManySql' getColumns safeToRemove sqlTypeEqgetAddReferenceDatabase.Persist.Sql.MigrationprintMigrationdoesTableExistDatabase.Persist.SqltransactionUndotransactionSave(Database.Persist.Sql.Orphan.PersistQuerydecorateSQLWithLimitOffsetupdateWhereCountdeleteWhereCountDatabase.Persist.Sql.Raw.QQ executeQQsqlQQ(Database.Persist.Sql.Orphan.PersistStore fieldDBName getFieldName tableDBName getTableName fromSqlKeytoSqlKey withRawQuerymigraterunMigrationUnsaferunMigrationSilent runMigration getMigration showMigrationparseMigration'parseMigrationDatabase.Persist.Sql.Runclose' withSqlConn askLogFunc createSqlPool withSqlPoolliftSqlPersistMPoolrunSqlPersistMPoolrunSqlPersistM runSqlConn runSqlPoolDatabase.Persist.Sql.RawrawSql getStmtConnrawExecuteCount rawExecute rawQueryResrawQueryDatabase.Persist.Sql.ClassRawSql rawSqlColsrawSqlColCountReasonrawSqlProcessRowPersistFieldSqlsqlTypeDatabase.PersistlimitOffsetOrder toJsonText mapToJSON listToJSON||./<-.<-.>=.>.<=.<.!=.==./=.*=.-=.+=.=.Database.Persist.Sql.Internal mkColumnsdefaultAttributeColumncNamecNullcSqlTypecDefaultcDefaultConstraintNamecMaxLen cReferencePersistentSqlExceptionStatementAlreadyFinalizedCouldn'tGetSQLConnection SqlPersistT SqlPersist SqlPersistMSqlCautiousMigration MigrationSingleunSingle readToUnknown readToWritewriteToUnknownLogFuncInsertSqlResult ISRSingle ISRInsertGet ISRManyKeys Statement stmtFinalize stmtReset stmtExecute stmtQuery connPrepare connInsertSqlconnInsertManySql connUpsertSql connStmtMap connCloseconnMigrateSql connBegin connCommit connRollbackconnEscapeName connNoLimit connRDBMSconnLimitOffset connLogFunc connMaxParamsSqlReadBackendunSqlReadBackendSqlWriteBackendunSqlWriteBackendSqlBackendCanReadSqlBackendCanWriteSqlReadT SqlWriteT IsSqlBackendDatabase.Persist.Class PersistUnique PersistQuery PersistStore$Database.Persist.Class.DeleteCascadedeleteCascadeWhere DeleteCascade deleteCascade#Database.Persist.Class.PersistQueryselectKeysList selectList selectKeys selectSourcePersistQueryReadcountselectSourceRes selectFirst selectKeysResPersistQueryWrite updateWhere deleteWhere$Database.Persist.Class.PersistUnique checkUnique replaceUnique getByValue onlyUniqueinsertUniqueEntityinsertByPersistUniqueReadgetByPersistUniqueWritedeleteBy insertUniqueupsertupsertBy#Database.Persist.Class.PersistStore insertRecord getEntity insertEntity belongsToJust belongsTo getJustEntitygetJust liftPersistHasPersistBackend BaseBackendpersistBackendIsPersistBackendBackendCompatibleprojectBackendPersistRecordBackend ToBackendKey toBackendKeyfromBackendKey SqlBackendKeySqlReadBackendKeySqlWriteBackendKeyunSqlBackendKeyunSqlReadBackendKeyunSqlWriteBackendKey PersistCore BackendKeyPersistStoreReadgetPersistStoreWritedeleteinsertupdateinsert_ insertMany insertMany_insertEntityMany insertKeyrepsertreplace updateGet$Database.Persist.Class.PersistEntityfromPersistValueJSONtoPersistValueJSONentityIdFromJSONentityIdToJSONkeyValueEntityFromJSONkeyValueEntityToJSON entityValues PersistEntityKeyUniquePersistEntityBackend EntityField keyToValues keyFromValuespersistIdField entityDefpersistFieldDeftoPersistFieldsfromPersistValuespersistUniqueKeyspersistUniqueToFieldNamespersistUniqueToValues fieldLensBackendSpecificUpdateUpdate BackendUpdate updateField updateValue updateUpdate SelectOptAscDescOffsetByLimitToBackendSpecificFilterFilter FilterAndFilterOr BackendFilter filterField filterValue filterFilterEntity entityKey entityVal#Database.Persist.Class.PersistField getPersistMap PersistFieldtoPersistValuefromPersistValueSomePersistFieldDatabase.Persist.Types.BasefromPersistValueTexttoEmbedEntityDefkeyAndEntityFieldsentityKeyFields entityPrimary CheckmarkActiveInactive IsNullableNullable NotNullable WhyNullable ByMaybeAttrByNullableAttr EntityDef entityHaskellentityDBentityId entityAttrs entityFields entityUniquesentityForeigns entityDerives entityExtra entitySum ExtraLine HaskellName unHaskellNameDBNameunDBNameAttr FieldType FTTypeConFTAppFTListFieldDef fieldHaskellfieldDB fieldType fieldSqlType fieldAttrs fieldStrictfieldReference ReferenceDef NoReference ForeignRefEmbedRef CompositeRef SelfReferenceEmbedEntityDefembeddedHaskellembeddedFields EmbedFieldDef emFieldDB emFieldEmbed emFieldCycle UniqueDef uniqueHaskell uniqueDBName uniqueFields uniqueAttrs CompositeDefcompositeFieldscompositeAttrsForeignFieldDef ForeignDefforeignRefTableHaskellforeignRefTableDBNameforeignConstraintNameHaskellforeignConstraintNameDBName foreignFields foreignAttrsforeignNullablePersistException PersistErrorPersistMarshalErrorPersistInvalidFieldPersistForeignConstraintUnmetPersistMongoDBErrorPersistMongoDBUnsupported PersistValue PersistTextPersistByteString PersistInt64 PersistDoublePersistRational PersistBool PersistDayPersistTimeOfDayPersistUTCTime PersistNull PersistList PersistMapPersistObjectIdPersistDbSpecificSqlType SqlStringSqlInt32SqlInt64SqlReal SqlNumericSqlBoolSqlDaySqlTime SqlDayTimeSqlBlobSqlOther PersistFilterEqNeGtLtGeLeInNotInUpdateException KeyNotFound UpsertErrorOnlyUniqueException PersistUpdateAssignAddSubtractMultiplyDivide$Database.Persist.Class.PersistConfig PersistConfigPersistConfigBackendPersistConfigPool loadConfigapplyEnvcreatePoolConfigrunPoolAlterDBAddTable AlterColumn AlterTableAddUniqueConstraintDropConstraint ChangeTypeIsNullNotNullAdd'DropDefault NoDefaultUpdate' AddReference DropReferenceUnknown unUnknown