Mailing lists [pgsql-bugs]
- Re: BUG #14046: Bad mathematical rules for 0 cast Jarosław Stokłosa
- Re: BUG #14046: Bad mathematical rules for 0 cast Jarosław Stokłosa
- Re: BUG #14046: Bad mathematical rules for 0 cast Jarosław Stokłosa
- Re: BUG #14046: Bad mathematical rules for 0 cast David G. Johnston
- BUG #14058: Alternate storage path syspegasus@gmail.com
- how to regenerate pg_control file ? Brahim EL ALLIOUI
- Re: BUG #14058: Alternate storage path David G. Johnston
- Re: how to regenerate pg_control file ? David G. Johnston
- BUG #14059: BUG? function in select clause called more times when use offset digoal@126.com
- Re: BUG #14059: BUG? function in select clause called more times when use offset Tom Lane
- Re: BUG #14059: BUG? function in select clause called more times when use offset 德哥
- BUG #14060: row security policy does not work for updatable views adudnik@gmail.com
- Re: BUG #14060: row security policy does not work for updatable views Stephen Frost
- Re: BUG #14060: row security policy does not work for updatable views Stephen Frost
- Re: BUG #14050: "could not reserve shared memory region" in postgresql log Noah Misch
- Re: BUG #14050: "could not reserve shared memory region" in postgresql log John R Pierce
- Re: BUG #14060: row security policy does not work for updatable views Artur Dudnik
- BUG #14061: Cannot update RPM from PGDG - unsigned package ondrej@svetlik.info
- Re: BUG #14050: "could not reserve shared memory region" in postgresql log Schuch, Mathias (Mathias)
- Re: BUG #13755: pgwin32_is_service not checking if SECURITY_SERVICE_SID is disabled Alvaro Herrera
- Re: Breakage with VACUUM ANALYSE + partitions Robert Haas
- BUG #14062: pg_dump dies after dumping first 60 gigabytes of text for large table dll@sonic.net
- BUG #14063: ALTER SYSTEM accepts 'newline' and renders itself inoperable. julian.schauder@credativ.de
- Re: BUG #14062: pg_dump dies after dumping first 60 gigabytes of text for large table Tom Lane
- Re: BUG #13970: Vacuum hangs on particular table; cannot be terminated - requires `kill -QUIT pid` Alvaro Herrera
- Re: BUG #14063: ALTER SYSTEM accepts 'newline' and renders itself inoperable. Tom Lane
- Re: BUG #13755: pgwin32_is_service not checking if SECURITY_SERVICE_SID is disabled Michael Paquier
- Re: BUG #14054: "create index using gist ..." on large table never completes. Emre Hasegeli
- BUG #14064: Sort order of bytea, etc. not defined cpacejo@clearskydata.com
- BUG #14065: Dutch_Belgium locale not working correctly bert.vanhertum.ext@klav.be
- PosgreSQL backend process crashed with signal 9 Aleksey Romanov
- Re: PosgreSQL backend process crashed with signal 9 Tom Lane
- pg_upgrade on Windows Marc Daelemans
- Re: pg_upgrade on Windows John R Pierce
- Re: Breakage with VACUUM ANALYSE + partitions Noah Misch
- Re: BUG #14050: "could not reserve shared memory region" in postgresql log Noah Misch
- Re: PosgreSQL backend process crashed with signal 9 Tom Lane
- Re: PosgreSQL backend process crashed with signal 9 Tom Lane
- Re: BUG #14062: pg_dump dies after dumping first 60 gigabytes of text for large table D
- Wrong result of yuanrui
- BUG #14067: Wrong result of yuan_rui1987@126.com
- Re: BUG #14050: "could not reserve shared memory region" in postgresql log Schuch, Mathias (Mathias)
- Re: PosgreSQL backend process crashed with signal 9 Pavel Suderevsky
- Re: PosgreSQL backend process crashed with signal 9 Pavel Suderevsky
- Re: PosgreSQL backend process crashed with signal 9 Pavel Suderevsky
- Re: Wrong result of Peter Geoghegan
- Re: PosgreSQL backend process crashed with signal 9 David Gould
- Re: Re: BUG #14050: "could not reserve shared memory region" in postgresql log John R Pierce
- Re: BUG #14067: Wrong result of David Rowley
- Re: BUG #14054: "create index using gist ..." on large table never completes. Jeff Janes
- Re: BUG #14050: "could not reserve shared memory region" in postgresql log Noah Misch
- released savepoint blocking further statements Miklós Fazekas
- BUG #14072: char() and application of locale collation emmanuel.reynard@eranea.com
- Re: BUG #14054: "create index using gist ..." on large table never completes. Tim Singletary
- Re: [HACKERS] BUG #13854: SSPI authentication failure: wrong realm name used Christian Ullrich
- Re: [HACKERS] BUG #13854: SSPI authentication failure: wrong realm name used Magnus Hagander
- Re: Re: [HACKERS] BUG #13854: SSPI authentication failure: wrong realm name used Tom Lane
- Re: Re: [HACKERS] BUG #13854: SSPI authentication failure: wrong realm name used Magnus Hagander
- Re: BUG #13755: pgwin32_is_service not checking if SECURITY_SERVICE_SID is disabled Michael Paquier
- Re: [HACKERS] BUG #13854: SSPI authentication failure: wrong realm name used Magnus Hagander
- Re: released savepoint blocking further statements Jeff Janes
- BUG #14077: Error with pgadim v1.22.1 and ubuntu 15.10 + postgres 9.2 jacksonemmerich@gmail.com
- BUG #14078: Excessive memory growth during nested loop in select psuderevsky@gmail.com
- Re: [HACKERS] BUG #13854: SSPI authentication failure: wrong realm name used Magnus Hagander
- BUG #14079: Issues with query hector.bejarano@gmail.com
- Re: BUG #14079: Issues with query Phillip Couto
- Re: BUG #14079: Issues with query John R Pierce
- Re: released savepoint blocking further statements Miklós Fazekas
- BUG #14080: JSONB order changes when using json_pretty() jack@fastly.com
- Re: BUG #14079: Issues with query Hector Bejarano
- BUG #14081: System LC_COLLATE changed cgh_chen@126.com
- Re: BUG #14080: JSONB order changes when using json_pretty() David G. Johnston
- Re: BUG #14079: Issues with query David G. Johnston
- Re: BUG #14028: FATAL: cannot perform encoding conversion outside a transaction Noah Misch
- Re: [HACKERS] Breakage with VACUUM ANALYSE + partitions Andres Freund
- Re: [HACKERS] Breakage with VACUUM ANALYSE + partitions Robert Haas
- Re: [HACKERS] Breakage with VACUUM ANALYSE + partitions Andres Freund
- BUG #14082: Unexpected time adjustment for output using "at time zone" duncan.stokes@eyemagnet.com
- Re: BUG #14082: Unexpected time adjustment for output using "at time zone" Tom Lane
- Re: [HACKERS] Breakage with VACUUM ANALYSE + partitions Fabien COELHO
- Re: [HACKERS] Breakage with VACUUM ANALYSE + partitions Robert Haas
- Repeated requests for feedback in logical standby Magnus Hagander
- Re: BUG #14078: Excessive memory growth during nested loop in select Tom Lane
- Bus error in pg_logical_slot_get_changes (9.4.7, sparc) Christoph Berg
- Re: Bus error in pg_logical_slot_get_changes (9.4.7, sparc) Andres Freund
- Re: Bus error in pg_logical_slot_get_changes (9.4.7, sparc) Tom Lane
- Re: Bus error in pg_logical_slot_get_changes (9.4.7, sparc) Andres Freund
- Re: Bus error in pg_logical_slot_get_changes (9.4.7, sparc) Christoph Berg
- Lock pileup stuck processes Josh berkus
- Re: Lock pileup stuck processes Tom Lane
- Re: Repeated requests for feedback in logical standby Nick Cleaton
- Re: Bus error in pg_logical_slot_get_changes (9.4.7, sparc) Christoph Berg
- Re: BUG #14033: cross-compilation to ARM fails Christoph Berg
- Re: Repeated requests for feedback in logical standby Magnus Hagander
- BUG #14085: Weird generic plan in PL/pgSQL function root@simply.name
- Re: Repeated requests for feedback in logical standby Magnus Hagander
- Weird generic plan in PL/pgSQL function Vladimir Borodin
- help:how to rollback postgresql to several minutes ago 刘剑
- BUG #14084: typo in LIMIT documentation pgu@mailcatch.com
- BUG #14083: 'postgresql95-setup initdb' breaks inside docker container porjo38@yahoo.com.au
- Re: BUG #14083: 'postgresql95-setup initdb' breaks inside docker container Devrim Gündüz
- Re: Repeated requests for feedback in logical standby Marko Tiikkaja
- Re: Repeated requests for feedback in logical standby Magnus Hagander
- Re: Bus error in pg_logical_slot_get_changes (9.4.7, sparc) Christoph Berg
- Re: Repeated requests for feedback in logical standby Nick Cleaton
- Re: help:how to rollback postgresql to several minutes ago Michael Paquier
- Re: help:how to rollback postgresql to several minutes ago Michael Paquier
- 9.6 synchronous_standby_names: discrepancy between docs and functionality Nicholson, Brad (Toronto, ON, CA)
- Re: 9.6 synchronous_standby_names: discrepancy between docs and functionality Michael Paquier
- Re: BUG #14084: typo in LIMIT documentation Tom Lane
- Re: 9.6 synchronous_standby_names: discrepancy between docs and functionality Fujii Masao
- PostgreSQL on Korean Windows Server 2008 R2 Standard Zombade, Prashant
- Re: Bus error in pg_logical_slot_get_changes (9.4.7, sparc) Tom Lane
- Re: Bus error in pg_logical_slot_get_changes (9.4.7, sparc) Christoph Berg
- Re: Bus error in pg_logical_slot_get_changes (9.4.7, sparc) Andres Freund
- Re: Bus error in pg_logical_slot_get_changes (9.4.7, sparc) Tom Lane
- Re: Bus error in pg_logical_slot_get_changes (9.4.7, sparc) Tom Lane
- Re: Bus error in pg_logical_slot_get_changes (9.4.7, sparc) Tom Lane
- Re: Bus error in pg_logical_slot_get_changes (9.4.7, sparc) Andres Freund
- Re: Bus error in pg_logical_slot_get_changes (9.4.7, sparc) Tom Lane
- Re: BUG #14083: 'postgresql95-setup initdb' breaks inside docker container IanB
- Re: BUG #14033: cross-compilation to ARM fails Tom Lane
- Re: BUG #14033: cross-compilation to ARM fails Andres Freund
- Re: BUG #14033: cross-compilation to ARM fails Tom Lane
- Re: BUG #14033: cross-compilation to ARM fails Christoph Berg
- BUG #14087: btree_gin index doesn't work on INT with POSITIVE constraint joris.vandyck@promani.be
- BUG #14088: pg_restore, --schema, causes TOC entries from even executing. psi-jack@linux-help.org
- Re: BUG #14088: pg_restore, --schema, causes TOC entries from even executing. David G. Johnston
- Re: BUG #14087: btree_gin index doesn't work on INT with POSITIVE constraint Tom Lane
- BUG #14089: ON CONFLICT allows function variables in index expressions quassnoi@gmail.com
- Re: BUG #14089: ON CONFLICT allows function variables in index expressions David G. Johnston
- Re: BUG #14089: ON CONFLICT allows function variables in index expressions Peter Geoghegan
- Re: BUG #14089: ON CONFLICT allows function variables in index expressions Alex Bolenok
- Re: BUG #14089: ON CONFLICT allows function variables in index expressions David G. Johnston
- Re: PostgreSQL on Korean Windows Server 2008 R2 Standard Noah Misch
- Re: Breakage with VACUUM ANALYSE + partitions Noah Misch
- Re: Breakage with VACUUM ANALYSE + partitions Andres Freund
- Re: Breakage with VACUUM ANALYSE + partitions Noah Misch
- BUG #14095: Make uninstall does not delete some files yoonghm@gmail.com
- Re: BUG #14089: ON CONFLICT allows function variables in index expressions David G. Johnston
- BUG #14098: misleading message "out of shared memory" when lock table space exhausted johnlumby@hotmail.com
- BUG #14099: Altering temporary sequence in session has no effect imraan@techie.com
- Re: BUG #14098: misleading message "out of shared memory" when lock table space exhausted Tom Lane
- Re: BUG #14099: Altering temporary sequence in session has no effect Tom Lane
- BUG #14090: Some installations of Postgres 8 and 9 are configured to allow loading external scripting languages. soufiane.boussali@efet.ac.ma
- BUG #14096: run pgbench, db crash zhaozp@uxsino.com
- BUG #14097: unalbe to locate runuser in /usr/pgsql-9.4/bin/postgresql94-setup rajeshwar.mukund@gmail.com
- Re: BUG #14089: ON CONFLICT allows function variables in index expressions Alex Bolenok
- Error instalación PostgreSQL 8.2 en Win10 Javier Mogetta
- Re: BUG #14090: Some installations of Postgres 8 and 9 are configured to allow loading external scripting languages. David G. Johnston
- Re: BUG #14096: run pgbench, db crash Alvaro Herrera
- Re: [BUGS] Error instalación PostgreSQL 8.2 en Win10 David G. Johnston
- Re: Too many files in pg_replslot folder Dmitriy Sarafannikov
- Re: BUG #14098: misleading message "out of shared memory" when lock table space exhausted John Lumby
- Re: Re: BUG #14098: misleading message "out of shared memory" when lock table space exhausted Tom Lane
- Re: Re: BUG #14098: misleading message "out of shared memory" when lock table space exhausted John Lumby
- Re: Re: BUG #14098: misleading message "out of shared memory" when lock table space exhausted David Gould
- Re: Re: BUG #14098: misleading message "out of shared memory" when lock table space exhausted John Lumby
- Re: BUG #14089: ON CONFLICT allows function variables in index expressions Peter Geoghegan
- Re: BUG #14096: run pgbench, db crash zhaozp@uxsino.com
- BUG #14100: Large memory consumption in a partitioning insert of great values Nikolay.Nikitin@infowatch.com
- Fwd: Postgresql 9.4 installation error Prashant Hunnure
- BUG #14101: Postgres Service Crashes With Memory Error And Does Not Recover nathanmascitelli@geotab.com
- Re: Fwd: Postgresql 9.4 installation error David G. Johnston
- Re: postmaster became multithreaded during startup Noah Misch
- Postgresql 9.4 installation error Prashant Hunnure
- Re: BUG #14101: Postgres Service Crashes With Memory Error And Does Not Recover Tom Lane
- Re: BUG #14101: Postgres Service Crashes With Memory Error And Does Not Recover Nathan Mascitelli
- BUG #14103: stored function encryption salianjag@gmail.com
- Re: BUG #14103: stored function encryption John R Pierce
- Re: BUG #14101: Postgres Service Crashes With Memory Error And Does Not Recover Tom Lane
- Re: BUG #14101: Postgres Service Crashes With Memory Error And Does Not Recover John R Pierce
- BUG #14104: PREPARE document has a missing parameter in one of the examples hus787@gmail.com
- Re: BUG #14101: Postgres Service Crashes With Memory Error And Does Not Recover Nathan Mascitelli
- BUG #14105: regression for right join - failed to build any 2-way joins vojta.rylko@gmail.com
- Re: BUG #14101: Postgres Service Crashes With Memory Error And Does Not Recover Nathan Mascitelli
- BUG #14106: Large memory client and server consumption in the insert of big values. Nikolay.Nikitin@infowatch.com
- BUG #14107: Major query planner bug regarding subqueries and indices mathiaskunter@gmail.com
- DATA RESTORE PGADMINIII AbdulShukoor Mohammed
- Re: BUG #14107: Major query planner bug regarding subqueries and indices David G. Johnston
- Re: DATA RESTORE PGADMINIII John R Pierce
- Re: BUG #14105: regression for right join - failed to build any 2-way joins David G. Johnston
- Re: BUG #14104: PREPARE document has a missing parameter in one of the examples Tom Lane
- Re: BUG #14105: regression for right join - failed to build any 2-way joins Tom Lane
- Re: BUG #14101: Postgres Service Crashes With Memory Error And Does Not Recover David Gould
- Re: BUG #14107: Major query planner bug regarding subqueries and indices Mathias Kunter
- Re: BUG #14107: Major query planner bug regarding subqueries and indices David Rowley
- Re: BUG #14107: Major query planner bug regarding subqueries and indices Mathias Kunter
- Re: BUG #14107: Major query planner bug regarding subqueries and indices Mathias Kunter
- Re: BUG #14107: Major query planner bug regarding subqueries and indices Victor Yegorov
- Re: BUG #14107: Major query planner bug regarding subqueries and indices Francisco Olarte
- Re: BUG #14107: Major query planner bug regarding subqueries and indices Victor Yegorov
- Re: BUG #14107: Major query planner bug regarding subqueries and indices Mathias Kunter
- BUG #14108: \Copy Command does not takes varibales supplied using -v neeraj.chaurasia@wipro.com
- problem installing postgres in debian8 from debian repository Armando Perryman Morales
- Re: BUG #14108: \Copy Command does not takes varibales supplied using -v David G. Johnston
- Re: problem installing postgres in debian8 from debian repository Tom Lane
- UPDATE grabs multiple rows when it seems like it should only grab one Kevin Burke
- Re: UPDATE grabs multiple rows when it seems like it should only grab one Kevin Burke
- Re: UPDATE grabs multiple rows when it seems like it should only grab one David G. Johnston
- Re: UPDATE grabs multiple rows when it seems like it should only grab one Tom Lane
- Re: UPDATE grabs multiple rows when it seems like it should only grab one David G. Johnston
- Re: UPDATE grabs multiple rows when it seems like it should only grab one Kevin Burke
- Re: UPDATE grabs multiple rows when it seems like it should only grab one Kevin Burke
- Re: BUG #14107: Major query planner bug regarding subqueries and indices Yaroslav
- Re: Re: BUG #14107: Major query planner bug regarding subqueries and indices Mathias Kunter
- Re: UPDATE grabs multiple rows when it seems like it should only grab one Tom Lane
- Re: BUG #14081: System LC_COLLATE changed Noah Misch
- BUG #14109: pg_rewind fails to update target control file in one scenario johnlumby@hotmail.com
- Re: BUG #14109: pg_rewind fails to update target control file in one scenario Michael Paquier
- BUG #14111: After minor upgrade (9.2.6 -> 9.2.16): ERROR: failed to build any 2-way joins bgrundmann@janestreet.com
- Re: BUG #14109: pg_rewind fails to update target control file in one scenario John Lumby
- Re: BUG #14109: pg_rewind fails to update target control file in one scenario Michael Paquier
- Re: BUG #14109: pg_rewind fails to update target control file in one scenario John Lumby
- Re: BUG #14109: pg_rewind fails to update target control file in one scenario Julien Rouhaud
- Re: BUG #14109: pg_rewind fails to update target control file in one scenario John Lumby
- Re: BUG #14111: After minor upgrade (9.2.6 -> 9.2.16): ERROR: failed to build any 2-way joins David G. Johnston
- Re: BUG #14109: pg_rewind fails to update target control file in one scenario Guillaume Lelarge
- Re: BUG #14109: pg_rewind fails to update target control file in one scenario Julien Rouhaud
- Re: BUG #14107: Major query planner bug regarding subqueries and indices Yaroslav
- Re: BUG #14109: pg_rewind fails to update target control file in one scenario John Lumby
- Re: BUG #14109: pg_rewind fails to update target control file in one scenario Michael Paquier
- Re: BUG #14111: After minor upgrade (9.2.6 -> 9.2.16): ERROR: failed to build any 2-way joins Benedikt Grundmann
- Re: BUG #14111: After minor upgrade (9.2.6 -> 9.2.16): ERROR: failed to build any 2-way joins David G. Johnston
- Re: BUG #14109: pg_rewind fails to update target control file in one scenario John Lumby
- BUG #14114: FK on-delete-cascade trouble zha-vova@yandex.ru
- Re: BUG #14114: FK on-delete-cascade trouble Tom Lane
- BUG #14115: PostgreSQL stopped listening to ip address andreas.schmidt1982@googlemail.com
- Re: BUG #14014: postgresql95-setup script determines PGDATA wrongly Bruce Momjian
- Re: BUG #14014: postgresql95-setup script determines PGDATA wrongly Devrim Gündüz
- Re: BUG #14016: Incomplete documentation of IN subquery expression Bruce Momjian
- Re: BUG #14016: Incomplete documentation of IN subquery expression David G. Johnston
- Re: BUG #14016: Incomplete documentation of IN subquery expression Bruce Momjian
- Re: BUG #14016: Incomplete documentation of IN subquery expression David G. Johnston
- Re: BUG #14016: Incomplete documentation of IN subquery expression Bruce Momjian
- Re: BUG #14016: Incomplete documentation of IN subquery expression David G. Johnston
- Re: BUG #14109: pg_rewind fails to update target control file in one scenario Michael Paquier
- Re: BUG #14109: pg_rewind fails to update target control file in one scenario Michael Paquier
- BUG #14116: Character with value 0x0a must be escaped. using COPY FROM mso1830@gmail.com
- BUG #14117: psql and pg_dump commands should use ENV perl jsteffee@bepress.com
- Re: BUG #14117: psql and pg_dump commands should use ENV perl Tom Lane
- Re: BUG #14117: psql and pg_dump commands should use ENV perl Andres Freund
- Re: BUG #14041: transaction_read_only documentation Bruce Momjian
- Re: BUG #14117: psql and pg_dump commands should use ENV perl Joe Steffee
- Re: BUG #14117: psql and pg_dump commands should use ENV perl Joe Steffee
- BUG #14110: information_schema.constraint_column_usage not working as expected srkunze@mail.de
- BUG #14112: sorting v and w is broken with et_EE locate georg.kahest@internet.ee
-
BUG #14113: LIKE
INCLUDING STORAGE bug? jdnelson@dyn.com -
Re: BUG #14113: LIKE
INCLUDING STORAGE bug? David G. Johnston - Re: BUG #14110: information_schema.constraint_column_usage not working as expected David G. Johnston
- Re: BUG #14112: sorting v and w is broken with et_EE locate Thomas Munro
- Problem Running Post-Install Step. Installation May Not Complete Correctly. The Database Cluster Initialisation Failed. Justin Noor
- Re: BUG #14112: sorting v and w is broken with et_EE locate Peter Geoghegan
- Re: BUG #14112: sorting v and w is broken with et_EE locate Peter Geoghegan
- Re: BUG #14112: sorting v and w is broken with et_EE locate Tom Lane
- Re: BUG #14112: sorting v and w is broken with et_EE locate Thomas Munro
- Re: BUG #14112: sorting v and w is broken with et_EE locate Peter Geoghegan
- Re: BUG #14112: sorting v and w is broken with et_EE locate Thomas Munro
- Re: BUG #14116: Character with value 0x0a must be escaped. using COPY FROM Francisco Olarte
- Re: BUG #14112: sorting v and w is broken with et_EE locate Georg Kahest
- alter table .. reset not throwing an error if storage_parameter name is wrong tushar
- Re: BUG #14109: pg_rewind fails to update target control file in one scenario Alvaro Herrera
- Re: alter table .. reset not throwing an error if storage_parameter name is wrong Michael Paquier
- BUG #14119: Database restore aborts with permission denied message Jeffrey.Marshall@usitc.gov
- Bug report Кирковский Александр
- BUG #14118: ERROR: could not read block 0 in file causes the application goes down yuqiang.liao@polycom.com
- Re: streaming replication master can fail to shut down Andres Freund
- Re: streaming replication master can fail to shut down Nick Cleaton
- Re: BUG #14107: Major query planner bug regarding subqueries and indices Mathias Kunter
- Re: BUG #14107: Major query planner bug regarding subqueries and indices Tom Lane
- Re: BUG #14107: Major query planner bug regarding subqueries and indices David Rowley
- BUG #14120: Documentation suggestion 35.4.2 kayzizz@gmail.com
- Re: streaming replication master can fail to shut down Andres Freund
- Re: streaming replication master can fail to shut down Nick Cleaton
- Re: streaming replication master can fail to shut down Magnus Hagander
- Re: BUG #14109: pg_rewind fails to update target control file in one scenario Michael Paquier
- Re: BUG #14109: pg_rewind fails to update target control file in one scenario Alvaro Herrera
- Re: BUG #14109: pg_rewind fails to update target control file in one scenario Michael Paquier
- Re: BUG #14107: Major query planner bug regarding subqueries and indices Mathias Kunter
- BUG #14121: Constraint UNIQUE m.giraldo@stt-telefonia.it
- Re: BUG #14121: Constraint UNIQUE John McKown
- Re: BUG #14121: Constraint UNIQUE David G. Johnston
- Re: streaming replication master can fail to shut down Andres Freund
- Re: Bug report Tom Lane
- Re: BUG #14103: stored function encryption Bruce Momjian
- Re: BUG #14103: stored function encryption John R Pierce