10 years agoSupport :rawdata (bytea)
levente.meszaros@gmail.com [Fri, 20 Apr 2007 14:59:22]
Support :rawdata (bytea)

10 years agoFix boolean binding to allow 'FALSE' and friends.
levente.meszaros@gmail.com [Wed, 21 Feb 2007 16:11:21]
Fix boolean binding to allow 'FALSE' and friends.

10 years agoFIX: do not flush the network stream in send-packet because it slows down api calls that have multiple send-packet calls in them
attila.lendvai@gmail.com [Mon, 11 Dec 2006 14:47:00]
FIX: do not flush the network stream in send-packet because it slows down api calls that have multiple send-packet calls in them

10 years agoAdded int64, float, numeric and boolean binding support by levente.meszaros@gmail.com
attila.lendvai@gmail.com [Mon, 11 Dec 2006 14:45:44]
Added int64, float, numeric and boolean binding support by levente.meszaros@gmail.com

10 years agoFix numeric parser for negative numbers by levente.meszaros@gmail.com
attila.lendvai@gmail.com [Mon, 11 Dec 2006 14:44:37]
Fix numeric parser for negative numbers by levente.meszaros@gmail.com

10 years agoTAG Start of darcs repo
attila.lendvai@gmail.com [Mon, 11 Dec 2006 14:19:22]
TAG Start of darcs repo

10 years ago[pg @ 2006-11-26 18:05:11 by emarsden]
emarsden [Sun, 26 Nov 2006 18:05:11]
[pg @ 2006-11-26 18:05:11 by emarsden]

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.

10 years ago[pg @ 2006-11-20 20:50:36 by emarsden]
emarsden [Mon, 20 Nov 2006 20:50:36]
[pg @ 2006-11-20 20:50:36 by emarsden]

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)."

10 years ago[pg @ 2006-11-19 18:47:58 by emarsden]
emarsden [Sun, 19 Nov 2006 18:47:59]
[pg @ 2006-11-19 18:47:58 by emarsden]

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>)

10 years ago[pg @ 2006-10-22 19:29:47 by emarsden]
emarsden [Sun, 22 Oct 2006 19:29:47]
[pg @ 2006-10-22 19:29:47 by emarsden]

- 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

10 years ago[pg @ 2006-10-22 19:25:51 by emarsden]
emarsden [Sun, 22 Oct 2006 19:25:51]
[pg @ 2006-10-22 19:25:51 by emarsden]

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.

10 years ago[pg @ 2006-10-22 19:22:39 by emarsden]
emarsden [Sun, 22 Oct 2006 19:22:39]
[pg @ 2006-10-22 19:22:39 by emarsden]

Code cleanups.

10 years ago[pg @ 2006-10-22 15:48:45 by emarsden]
emarsden [Sun, 22 Oct 2006 15:48:45]
[pg @ 2006-10-22 15:48:45 by emarsden]

Allow NULL values for bound variables in prepared statements. Bug
pointed out by Steve Purcell <steve@sanityinc.com>.

10 years ago[pg @ 2006-09-30 16:51:12 by emarsden]
emarsden [Sat, 30 Sep 2006 16:51:12]
[pg @ 2006-09-30 16:51:12 by emarsden]

Add unix-domain socket support for Allegro CL (tested with Express
edition for Linux/x86).

10 years ago[pg @ 2006-09-24 21:19:30 by emarsden]
emarsden [Sun, 24 Sep 2006 21:19:30]
[pg @ 2006-09-24 21:19:30 by emarsden]

More additions to the testing code: testing reporting of floating point overflow
and underflow, array syntax, more bitvector tests.

10 years ago[pg @ 2006-09-24 15:50:18 by emarsden]
emarsden [Sun, 24 Sep 2006 15:50:18]
[pg @ 2006-09-24 15:50:18 by emarsden]

Disabling buffering of the socket stream on CLISP greatly improves performance.

10 years ago[pg @ 2006-09-24 15:14:38 by emarsden]
emarsden [Sun, 24 Sep 2006 15:14:38]
[pg @ 2006-09-24 15:14:38 by emarsden]

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.

10 years ago[pg @ 2006-09-24 15:08:38 by emarsden]
emarsden [Sun, 24 Sep 2006 15:08:38]
[pg @ 2006-09-24 15:08:38 by emarsden]

Make the v3 protocol ERROR-RESPONSE inherit from BACKEND-ERROR.

10 years ago[pg @ 2006-09-23 12:24:28 by emarsden]
emarsden [Sat, 23 Sep 2006 12:24:28]
[pg @ 2006-09-23 12:24:28 by emarsden]

- 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.

10 years ago[pg @ 2006-09-19 06:57:28 by emarsden]
emarsden [Tue, 19 Sep 2006 06:57:28]
[pg @ 2006-09-19 06:57:28 by emarsden]

Remove the limit on maximum message size when using the v3 protocol
(from Johan Ur Riise <johan@riise-data.no>).

10 years ago[pg @ 2006-09-18 21:37:48 by emarsden]
emarsden [Mon, 18 Sep 2006 21:37:48]
[pg @ 2006-09-18 21:37:48 by emarsden]

Fix problems with text data in prepared statements. Unlike the rest of
the protocol, strings are not sent NUL-terminated.

10 years ago[pg @ 2006-09-18 21:33:10 by emarsden]
emarsden [Mon, 18 Sep 2006 21:33:10]
[pg @ 2006-09-18 21:33:10 by emarsden]

Make comparison in IMPLEMENTATION-NAME-FOR-ENCODING case-insensitive
(from ya007@yandex.ru).

10 years ago[pg @ 2006-09-18 19:10:38 by emarsden]
emarsden [Mon, 18 Sep 2006 19:10:38]
[pg @ 2006-09-18 19:10:38 by emarsden]

Documentation fix for PG-EXECUTE.

10 years ago[pg @ 2006-09-18 19:10:01 by emarsden]
emarsden [Mon, 18 Sep 2006 19:10:01]
[pg @ 2006-09-18 19:10:01 by emarsden]

Put the PG defsystem in its own package.

10 years ago[pg @ 2006-09-18 19:09:25 by emarsden]
emarsden [Mon, 18 Sep 2006 19:09:25]
[pg @ 2006-09-18 19:09:25 by emarsden]

Fix to the prepared statement example.

10 years ago[pg @ 2006-09-15 20:49:03 by emarsden]
emarsden [Fri, 15 Sep 2006 20:49:03]
[pg @ 2006-09-15 20:49:03 by emarsden]

Improved documentation and a basic example for the use of execution
plans (prepared statements).

10 years ago[pg @ 2006-09-15 20:04:37 by emarsden]
emarsden [Fri, 15 Sep 2006 20:04:37]
[pg @ 2006-09-15 20:04:37 by emarsden]

Fix bug in PG-CLOSE-STATEMENT (thanks to ya007@yandex.ru).

10 years ago[pg @ 2006-08-28 20:08:00 by emarsden]
emarsden [Mon, 28 Aug 2006 20:08:00]
[pg @ 2006-08-28 20:08:00 by emarsden]

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).

11 years ago[pg @ 2006-02-07 13:39:40 by pvaneynde]
pvaneynde [Tue, 07 Feb 2006 13:39:40]
[pg @ 2006-02-07 13:39:40 by pvaneynde]

sync with recent debian packages, no real changes

11 years ago[pg @ 2006-01-27 18:03:39 by emarsden]
emarsden [Fri, 27 Jan 2006 18:03:39]
[pg @ 2006-01-27 18:03:39 by emarsden]

Fix for encoding support for CLISP and OpenMCL (encoding still not
working correctly).

OpenMCL fix from Risto Laakso.

11 years ago[pg @ 2006-01-27 17:51:53 by emarsden]
emarsden [Fri, 27 Jan 2006 17:51:53]
[pg @ 2006-01-27 17:51:53 by emarsden]

Load sb-rotate-byte from the ASD file.

11 years ago[pg @ 2006-01-25 19:25:46 by pvaneynde]
pvaneynde [Wed, 25 Jan 2006 19:25:46]
[pg @ 2006-01-25 19:25:46 by pvaneynde]

fix typo in pg-close-portal documentation

11 years ago[pg @ 2005-12-19 22:29:59 by emarsden]
emarsden [Mon, 19 Dec 2005 22:29:59]
[pg @ 2005-12-19 22:29:59 by emarsden]

Fix to timezone handling when parsing timestamps (timezone offset can
be negative).

From Katsuya Tomioka.

11 years ago[pg @ 2005-12-19 22:21:50 by emarsden]
emarsden [Mon, 19 Dec 2005 22:21:50]
[pg @ 2005-12-19 22:21:50 by emarsden]

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)

11 years ago[pg @ 2005-12-19 22:18:32 by emarsden]
emarsden [Mon, 19 Dec 2005 22:18:32]
[pg @ 2005-12-19 22:18:32 by emarsden]

Fix sockets for recent ABCL versions.

Modify the client-encoding code to work with multiple implementations
(incomplete testing).

11 years ago[pg @ 2005-12-19 22:16:42 by emarsden]
emarsden [Mon, 19 Dec 2005 22:16:42]
[pg @ 2005-12-19 22:16:42 by emarsden]

Add a utility function PG-DESCRIBE-TABLE.

11 years ago[pg @ 2005-10-18 13:07:27 by pvaneynde]
pvaneynde [Tue, 18 Oct 2005 13:07:28]
[pg @ 2005-10-18 13:07:27 by pvaneynde]

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

11 years ago[pg @ 2005-08-01 09:15:12 by pvaneynde]
pvaneynde [Mon, 01 Aug 2005 09:15:12]
[pg @ 2005-08-01 09:15:12 by pvaneynde]

new debian package

11 years ago[pg @ 2005-07-17 15:49:14 by emarsden]
emarsden [Sun, 17 Jul 2005 15:49:14]
[pg @ 2005-07-17 15:49:14 by emarsden]

Note that the current code has been tested against PostgreSQL 8.0
(with both v2 and v3 protocol versions).

11 years ago[pg @ 2005-07-17 15:48:06 by emarsden]
emarsden [Sun, 17 Jul 2005 15:48:06]
[pg @ 2005-07-17 15:48:06 by emarsden]

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.

11 years ago[pg @ 2005-07-17 15:46:32 by emarsden]
emarsden [Sun, 17 Jul 2005 15:46:32]
[pg @ 2005-07-17 15:46:32 by emarsden]

Use the updated MD5 code, that operates on octet arrays rather than
strings.

11 years ago[pg @ 2005-07-17 15:44:48 by emarsden]
emarsden [Sun, 17 Jul 2005 15:44:48]
[pg @ 2005-07-17 15:44:48 by emarsden]

Update to a more recent version of md5.lisp, taken from SBCL's SB-MD5
contrib. The change is motivated by the fact that SBCL generates a runtime
error "function declared not to return returned" with the current
code. Made a few changes to make the code compile in other Common Lisp
implementations.

11 years ago[pg @ 2005-07-17 13:49:43 by emarsden]
emarsden [Sun, 17 Jul 2005 13:49:43]
[pg @ 2005-07-17 13:49:43 by emarsden]

Minor fix to tests for PostgreSQL 8.0: the MONEY type is deprecated.

11 years ago[pg @ 2005-07-17 13:46:50 by emarsden]
emarsden [Sun, 17 Jul 2005 13:46:50]
[pg @ 2005-07-17 13:46:50 by emarsden]

Three fixes from Björn Lindberg <d95-bli@nada.kth.se>:

- Two trivial bugs with regards to use with Allegro

- Handling of the special timestamp values infinity and -infinity. They
gave an error, but now returns the symbols :INFINITY and :-INFINITY
respectively.

- A bug in the version 3 of the protocol, where it would return NIL for
fields in the database containing the empty string, rather than an
empty string.

12 years ago[pg @ 2005-05-04 20:51:35 by pvaneynde]
pvaneynde [Wed, 04 May 2005 20:51:35]
[pg @ 2005-05-04 20:51:35 by pvaneynde]

possible sbcl unicode fix

12 years ago[pg @ 2004-09-19 22:32:33 by pvaneynde]
pvaneynde [Sun, 19 Sep 2004 22:32:33]
[pg @ 2004-09-19 22:32:33 by pvaneynde]

Corrected wrong code for Close Complete

12 years ago[pg @ 2004-09-19 22:14:13 by pvaneynde]
pvaneynde [Sun, 19 Sep 2004 22:14:13]
[pg @ 2004-09-19 22:14:13 by pvaneynde]

new debian package

12 years ago[pg @ 2004-09-19 22:13:35 by pvaneynde]
pvaneynde [Sun, 19 Sep 2004 22:13:36]
[pg @ 2004-09-19 22:13:35 by pvaneynde]

fixed extended queries for newer versions of postgreSQL, they need the sync message

12 years ago[pg @ 2004-09-07 12:52:19 by emarsden]
emarsden [Tue, 07 Sep 2004 12:52:19]
[pg @ 2004-09-07 12:52:19 by emarsden]

Add support for the SQL NUMERIC type, thanks to Risto Sakari Laakso.
Was previously being parsed as an integer, but is in fact a fix-precision
floating-point number.

12 years ago[pg @ 2004-08-13 16:50:37 by emarsden]
emarsden [Fri, 13 Aug 2004 16:50:37]
[pg @ 2004-08-13 16:50:37 by emarsden]

Implement binary-mode transfers for large-object operations in the v3
protocol. The v2 protocol transfers arguments in binary mode, but the
v3 protocol requires the client to specify for each argument of a
FunctionCall whether it is encoded as binary or as text.

- add possibility to send (unsigned-byte 8) arguments to function calls

- add a method READ-OCTETS-FROM-PACKET that reads raw octets

- make PG-IMPORT and PG-EXPORT use binary I/O

- PGLO-READ reads data in binary

- change the large-object tests to use binary I/O (fixes the pglo test)

Next ->