Skip to content
  1. Apr 20, 2007
  2. Feb 21, 2007
  3. Dec 11, 2006
  4. Nov 26, 2006
    • emarsden's avatar
      [pg @ 2006-11-26 18:05:11 by emarsden] · 429be41f
      emarsden authored
      Make sure we consume the ReadyForQuery packet that is generated when
      closing a prepared statement or portal, or the packet can be
      misinterpreted by a later query, leading to data loss. Fix from Robert
      J. Macomber.
      
      darcs-hash:7ef83e38bdbd39d64bf602a5bfa60133234b743c
  5. Nov 20, 2006
    • emarsden's avatar
      [pg @ 2006-11-20 20:50:36 by emarsden] · 22cb3e7f
      emarsden authored
      Add an ABORT keyword argument to PG-DISCONNECT (from Robert J.
      Macomber <pgsql@rojoma.com>), as per CL:CLOSE.
      
        "I've run into a problem with pg-disconnect if something abnormal
         happens to the database connection -- if the database goes away for a
         restart while pg has a connection open, for example.  When this
         happens, pg-disconnect fails, and the socket file descriptor is left
         open (presumably for a finalizer to clean up), also raising a new
         error from the unwind-protect in with-pg-connection.  To guard against
         the possibility, I've added an :abort parameter to pg-disconnect, like
         cl:close has, and made with-pg-connection call it with :abort t if the
         body exits abnormally, in the same way that with-open-file operates.
         When :abort is true, the modified pg-disconnect closes the database
         connection ungracefully, including making the close call abort
         (otherwise, sbcl at keast tries to flush the stream, raising another
         error if the database isn't there anymore)."
      
      darcs-hash:aad628cf0093846dca55fe4f8fa47b0db89249c2
      22cb3e7f
  6. Nov 19, 2006
    • emarsden's avatar
      [pg @ 2006-11-19 18:47:58 by emarsden] · d74a5aa1
      emarsden authored
      Allow encoding used for socket communication with the backend to be
      specified as a keyword argument to PG-CONNECT, for cases where
      rebinding *PG-CLIENT-ENCODING* is inconvenient.
      
      Add a simple test for encoding support.
      
      (From Attila Lendvai <attila.lendvai@gmail.com>)
      
      darcs-hash:9f1f315eb332972142eadea0eff9cb70e5702ece
      d74a5aa1
  7. Oct 22, 2006
    • emarsden's avatar
      [pg @ 2006-10-22 19:29:47 by emarsden] · 843356b8
      emarsden authored
      - implement basic parsing support for the PostgreSQL record type
      
       - supply a utility function to escape binary data into a format that
         can be used within an SQL string to initialize a field of type
         BYTEA
      
       - add optimize declarations for improved performance
      
      darcs-hash:e575d1fea8f22a1b00cd2f0797023849b1313a9b
      843356b8
    • emarsden's avatar
      [pg @ 2006-10-22 19:25:51 by emarsden] · 8a24b325
      emarsden authored
      Fixes to the prepared statement support, in order to implement precise
      error reporting. Deadlocks were possible with previous version, where
      pg-dot-lisp would be blocked waiting for input from the backend that
      never arrived.
      
      Also some code cleanups.
      
      darcs-hash:0588a2f36bb19982641cd4e7f147578e669feb59
      8a24b325
    • emarsden's avatar
      [pg @ 2006-10-22 19:22:39 by emarsden] · 77f59db9
      emarsden authored
      Code cleanups.
      
      darcs-hash:accdbe4ec375dd9630c452cea382a94d5886ed06
      77f59db9
    • emarsden's avatar
      [pg @ 2006-10-22 15:48:45 by emarsden] · f0bed50a
      emarsden authored
      Allow NULL values for bound variables in prepared statements. Bug
      pointed out by Steve Purcell <steve@sanityinc.com>.
      
      darcs-hash:0def4f65865e39ec833ed7213f93e8a8eafe7f25
      f0bed50a
  8. Sep 30, 2006
    • emarsden's avatar
      [pg @ 2006-09-30 16:51:12 by emarsden] · ede17214
      emarsden authored
      Add unix-domain socket support for Allegro CL (tested with Express
      edition for Linux/x86).
      
      darcs-hash:8b5f269f3f48782be742a3e1ccbcca7f9506674c
      ede17214
  9. Sep 24, 2006
    • emarsden's avatar
      [pg @ 2006-09-24 21:19:30 by emarsden] · 364ef86a
      emarsden authored
      More additions to the testing code: testing reporting of floating point overflow
      and underflow, array syntax, more bitvector tests.
      
      darcs-hash:1cb791a745cf28dc05dfa478efda5aea402a2593
      364ef86a
    • emarsden's avatar
      [pg @ 2006-09-24 15:50:18 by emarsden] · cac9186a
      emarsden authored
      Disabling buffering of the socket stream on CLISP greatly improves performance.
      
      darcs-hash:407b5c85d4c3ff9659a67852f901724c703a124b
      cac9186a
    • emarsden's avatar
      [pg @ 2006-09-24 15:14:38 by emarsden] · 8c7d92cd
      emarsden authored
      Added numerous additional tests, for string support, various types of
      errors signaled by PostgreSQL, integer overflow, transactions, arrays,
      bit-tables, prepared statements using TEXT parameters.
      
      darcs-hash:72a804e8f855a32fb4e693b983f99ee0d6484060
      8c7d92cd
    • emarsden's avatar
      [pg @ 2006-09-24 15:08:38 by emarsden] · a5c6fd5e
      emarsden authored
      Make the v3 protocol ERROR-RESPONSE inherit from BACKEND-ERROR.
      
      darcs-hash:2b258607c624bc07be363ef34dcd4186513fce31
      a5c6fd5e
  10. Sep 23, 2006
    • emarsden's avatar
      [pg @ 2006-09-23 12:24:28 by emarsden] · 06d67504
      emarsden authored
      - on CL implementations that support Unix sockets, the HOST argument
         to PG-CONNECT may designate the directory containing the local
         PostgreSQL unix socket (often "/var/run/postgresql/"). The HOST
         argument is assumed to designate a local directory rather than a
         hostname when its first character is #\/. You may need to modify
         authentication options in the PostgreSQL configuration file
         pg_hba.conf to allow connections over a unix-domain socket where
         the databse username is not equal to your ident tokens. This is an
         incompatible change to previous support for unix-domain sockets
         with CMUCL (previously a HOST of NIL told pg-dot-lisp to connect
         to a unix-domain socket whose name was hardwired into the library).
         This support currently exists for SBCL, CMUCL and OpenMCL.
      
      darcs-hash:1079feb38d33f9b9d1f14fbcd0fef67dc7954aa3
      06d67504
  11. Sep 19, 2006
    • emarsden's avatar
      [pg @ 2006-09-19 06:57:28 by emarsden] · cb43a340
      emarsden authored
      Remove the limit on maximum message size when using the v3 protocol
      (from Johan Ur Riise <johan@riise-data.no>).
      
      darcs-hash:0fb3e5b4e207dd2ec0b6e6c4705339b35d0b0fa9
      cb43a340
  12. Sep 18, 2006
  13. Sep 15, 2006
  14. Aug 28, 2006
    • emarsden's avatar
      [pg @ 2006-08-28 20:08:00 by emarsden] · 606e1f92
      emarsden authored
      Fixes to client-encoding support, based on a bug report from Johan Ur
      Riise <johan@riise-data.no>. Not tested very heavily (but the tests
      work in UTF-8 mode with unicode-enabled SBCL and CLISP).
      
      darcs-hash:ad4154ce4c456179f353b980697e6d052f5e631b
      606e1f92
  15. Feb 07, 2006
  16. Jan 27, 2006
  17. Jan 25, 2006
  18. Dec 19, 2005
    • emarsden's avatar
      [pg @ 2005-12-19 22:29:59 by emarsden] · 4f09e4d4
      emarsden authored
      Fix to timezone handling when parsing timestamps (timezone offset can
      be negative).
      
      From Katsuya Tomioka.
      
      darcs-hash:656ed17ea7f0d6b56554558f2a5e7f67e60d032d
      4f09e4d4
    • emarsden's avatar
      [pg @ 2005-12-19 22:21:50 by emarsden] · 6129fd6a
      emarsden authored
      Fix the SB-ROTATE-BYTE dependency for SBCL (was loaded twice, with
      unfortunate consequences).
      
      Add support for unix-socket connections to the backend for SBCL.
      
      (Thanks to Andreas Fuchs)
      
      darcs-hash:05cb2a519fdd72ffabda336b5e10b942b437fb57
      6129fd6a
    • emarsden's avatar
      [pg @ 2005-12-19 22:18:32 by emarsden] · b0a17f1c
      emarsden authored
      Fix sockets for recent ABCL versions.
      
      Modify the client-encoding code to work with multiple implementations
      (incomplete testing).
      
      darcs-hash:d6167b9b0a85f5c7367d7fee7b2ce9d3a8c3d961
      b0a17f1c
    • emarsden's avatar
      [pg @ 2005-12-19 22:16:42 by emarsden] · 4caa23f6
      emarsden authored
      Add a utility function PG-DESCRIBE-TABLE.
      
      darcs-hash:638c85c5c8aef6227571f4d6a86008a478be0eef
      4caa23f6
  19. Oct 18, 2005
    • pvaneynde's avatar
      [pg @ 2005-10-18 13:07:27 by pvaneynde] · 9b899499
      pvaneynde authored
      Modified sbcl unicode support, works for me.
      Moved requires into asdf package, otherwise we get asdf package problems, unknown if it works with other lisps
      
      darcs-hash:033df81cf627c24fdcd34df9adab60e10377fd4c
      9b899499
  20. Aug 01, 2005
  21. Jul 17, 2005
    • emarsden's avatar
      [pg @ 2005-07-17 15:49:14 by emarsden] · d45d1d7e
      emarsden authored
      Note that the current code has been tested against PostgreSQL 8.0
      (with both v2 and v3 protocol versions).
      
      darcs-hash:199fc743bbc5c8eff88ba89dc683a6af693af98b
      d45d1d7e
    • emarsden's avatar
      [pg @ 2005-07-17 15:48:06 by emarsden] · 8aac175a
      emarsden authored
      Make PGLO-READ a generic function, with specializations on the v2 and
      v3 protocols. The difference is necessary because the v2 protocol
      reads large-object data in text, whereas the v3 protocol changed to
      use a binary format.
      
      darcs-hash:6639fd1b9dd10ca051ea03d7e2fbff94c0d917e2
      8aac175a
    • emarsden's avatar
      [pg @ 2005-07-17 15:46:32 by emarsden] · 237b460b
      emarsden authored
      Use the updated MD5 code, that operates on octet arrays rather than
      strings.
      
      darcs-hash:bde42a8e54d275e9eda02c5739ce30eb4f539d59
      237b460b