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

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

7 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 06: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

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

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

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

7 years ago[pg @ 2006-11-26 18:05:11 by emarsden]
emarsden [Sun, 26 Nov 2006 10: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.

7 years ago[pg @ 2006-11-20 20:50:36 by emarsden]
emarsden [Mon, 20 Nov 2006 12: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)."

7 years ago[pg @ 2006-11-19 18:47:58 by emarsden]
emarsden [Sun, 19 Nov 2006 10: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>)

7 years ago[pg @ 2006-10-22 19:29:47 by emarsden]
emarsden [Sun, 22 Oct 2006 12: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

7 years ago[pg @ 2006-10-22 19:25:51 by emarsden]
emarsden [Sun, 22 Oct 2006 12: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.

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

Code cleanups.

7 years ago[pg @ 2006-10-22 15:48:45 by emarsden]
emarsden [Sun, 22 Oct 2006 08: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>.

7 years ago[pg @ 2006-09-30 16:51:12 by emarsden]
emarsden [Sat, 30 Sep 2006 09: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).

7 years ago[pg @ 2006-09-24 21:19:30 by emarsden]
emarsden [Sun, 24 Sep 2006 14: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.

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

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

7 years ago[pg @ 2006-09-24 15:14:38 by emarsden]
emarsden [Sun, 24 Sep 2006 08: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.

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

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

7 years ago[pg @ 2006-09-23 12:24:28 by emarsden]
emarsden [Sat, 23 Sep 2006 05: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.

7 years ago[pg @ 2006-09-19 06:57:28 by emarsden]
emarsden [Mon, 18 Sep 2006 23: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>).

7 years ago[pg @ 2006-09-18 21:37:48 by emarsden]
emarsden [Mon, 18 Sep 2006 14: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.

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

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

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

Documentation fix for PG-EXECUTE.

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

Put the PG defsystem in its own package.

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

Fix to the prepared statement example.

7 years ago[pg @ 2006-09-15 20:49:03 by emarsden]
emarsden [Fri, 15 Sep 2006 13: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).

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

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

7 years ago[pg @ 2006-08-28 20:08:00 by emarsden]
emarsden [Mon, 28 Aug 2006 13: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).

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

sync with recent debian packages, no real changes

8 years ago[pg @ 2006-01-27 18:03:39 by emarsden]
emarsden [Fri, 27 Jan 2006 10: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.

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

Load sb-rotate-byte from the ASD file.

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

fix typo in pg-close-portal documentation

8 years ago[pg @ 2005-12-19 22:29:59 by emarsden]
emarsden [Mon, 19 Dec 2005 14: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.

8 years ago[pg @ 2005-12-19 22:21:50 by emarsden]
emarsden [Mon, 19 Dec 2005 14: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)

8 years ago[pg @ 2005-12-19 22:18:32 by emarsden]
emarsden [Mon, 19 Dec 2005 14: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).

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

Add a utility function PG-DESCRIBE-TABLE.

8 years ago[pg @ 2005-10-18 13:07:27 by pvaneynde]
pvaneynde [Tue, 18 Oct 2005 06: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

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

new debian package

9 years ago[pg @ 2005-07-17 15:49:14 by emarsden]
emarsden [Sun, 17 Jul 2005 08: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).

9 years ago[pg @ 2005-07-17 15:48:06 by emarsden]
emarsden [Sun, 17 Jul 2005 08: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.

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

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

9 years ago[pg @ 2005-07-17 15:44:48 by emarsden]
emarsden [Sun, 17 Jul 2005 08: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.

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

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

9 years ago[pg @ 2005-07-17 13:46:50 by emarsden]
emarsden [Sun, 17 Jul 2005 06: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.

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

possible sbcl unicode fix

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

Corrected wrong code for Close Complete

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

new debian package

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

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

9 years ago[pg @ 2004-09-07 12:52:19 by emarsden]
emarsden [Tue, 07 Sep 2004 05: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.

9 years ago[pg @ 2004-08-13 16:50:37 by emarsden]
emarsden [Fri, 13 Aug 2004 09: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 ->