The pg Reference Manual

Next: , Previous: , Up: (dir)   [Contents][Index]

The pg Reference Manual

This is the pg Reference Manual, version 0.24, generated automatically by Declt version 4.0 beta 2 "William Riker" on Mon Aug 15 05:34:26 2022 GMT+0.

Table of Contents


1 Introduction

pg.lisp -- socket level interface to the PostgreSQL RDBMS for Common Lisp

 Author: Eric Marsden 
 Version: 0.24

     Copyright (C) 1999,2000,2001,2002,2003,2004,2005,2006  Eric Marsden

     This library is free software; you can redistribute it and/or
     modify it under the terms of the GNU Library General Public
     License as published by the Free Software Foundation; either
     version 2 of the License, or (at your option) any later version.

     This library is distributed in the hope that it will be useful,
     but WITHOUT ANY WARRANTY; without even the implied warranty of
     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
     Library General Public License for more details.

     You should have received a copy of the GNU Library General Public
     License along with this library; if not, write to the Free
     Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.

 For download information, mailing lists for suggestions and bug
 reports, see 

     


== Overview =========================================================

 This module lets you access the PostgreSQL object-relational DBMS
 from Common Lisp. The code implements the client part of the
 socket-level frontend/backend protocol, rather than providing a
 wrapper around the libpq library. The module is capable of type
 coercions from a range of SQL types to the equivalent Lisp type.
 The only non portable code is the use of 'socket-connect' and
 (optional) some way of accessing the Unix crypt() function.

 Works with CMUCL, SBCL, CLISP, OpenMCL, ABCL, ACL, Lispworks, and MCL.
 CormanLisp has socket support but not for binary I/O.


== Entry points =======================================================

 (with-pg-connection ((con &rest open-args) &body body)
     A macro which opens a connection to database DBNAME, executes the
     BODY forms then disconnects. See function `pg-connect' for details
     of the connection arguments OPEN-ARGS.

 (with-pg-transaction con &body body)
     A macro which executes the BODY forms wrapped in an SQL transaction.
     CON is a connection to the database. If an error occurs during the
     execution of the forms, a ROLLBACK instruction is executed.

 (pg-connect dbname user &key password host port) -> connection
     Connect to the database DBNAME on HOST (defaults to localhost) at
     PORT (defaults to 5432), and log in as USER. If HOST designates
     an absolute pathname (its first character is #\/), attempt to
     connect to the localhost using a Unix domain socket that resides
     in that directory (for example "/var/run/postgresql/"); otherwise
     HOST designates a hostname and the connection is established
     using TCP/IP. Connections to unix sockets are not supported on
     all implementations. If the database requires a password, send
     PASSWORD (as clear text unless the backend demands crypt()
     authentication). Set the output date type to 'ISO', and
     initialize our type parser tables.

 (pg-exec connection &rest sql) -> pgresult
     Concatenate the SQL strings and send to the backend. Retrieve
     all the information returned by the database and return it in
     an opaque record PGRESULT.

 (pg-result pgresult what &rest args) -> info
     Extract information from the PGRESULT. WHAT can be one of
          * :connection
          * :status
          * :attributes
          * :tuples
          * :tuple tupleNumber
          * :oid
     `connection' allows you to retrieve the database connection.
     `status' is a string returned by the backend to indicate the
     status of the command; it is normally "SELECT" for a select
     command, "DELETE 1" if the deletion affected a single row, etc.
     `attributes' is a list of tuples providing metadata: the first
     component of each tuple is the attribute's name as a string,
     the second an integer representing its PostgreSQL type, and the
     third an integer representing the size of that type. `tuples'
     returns all the data retrieved from the database, as a list of
     lists, each list corresponding to one row of data returned by
     the backend. `tuple num' can be used to extract a specific
     tuple. `oid' allows you to retrieve the OID returned by the
     backend if the command was an insertion; the OID is a unique
     identifier for that row in the database (this is
     PostgreSQL-specific, please refer to the documentation for more
     details).

 (pg-for-each connection select-form callback)
     Calls CALLBACK on each tuple returned by SELECT-FORM. Declares
     a cursor for SELECT-FORM, then fetches tuples using repeated
     executions of FETCH 1, until no results are left. The cursor is
     then closed. The work is performed within a transaction. When
     you have a large amount of data to handle, this usage is more
     efficient than fetching all the tuples in one go.

 (pg-disconnect connection &key abort) -> nil
     Close the database connection. If the keyword argument ABORT is
     non-NIL, the database connection is closed immediately, without
     first attempting to send a disconnect packet to the PostgreSQL
     backend. 


=== Support for prepared statements ====================================

 (pg-supports-pbe conn) -> boolean
     Returns T iff the connection to the database is able to support
     prepared statements. This is only true of connections using
     version 3 of the frontend/backend protocol. 

 (pg-prepare conn statement-name sql &optional parameter-types)
     Prepares an execution plan for a query (a prepared statement).
     The prepared statement may contain arguments that are refered to
     as $1, $2 etc; if arguments are present their types must be
     declared via the list PARAMETER-TYPES. Each element of
     PARAMETER-TYPES should be a string that defines the type of its
     corresponding parameter (see PG::*TYPE-PARSERS* for examples of
     type names used by PostgreSQL).

     Using execution plans is more efficient than multiple calls to
     PG-EXEC, since the parsing and query optimizing phase only occurs
     once, at preparation time. It also helps to protect against "SQL
     injection" attacks, by ensuring that arguments to an SQL query
     cannot be interpreted as a part of the SQL request.

 (pg-bind conn portal-name statement-name typed-arguments)
     Binds the execution plan that was previously prepared as
     STATEMENT-NAME to PORTAL-NAME, with TYPED-ARGUMENTS.
     TYPED-ARGUMENTS is a list of tuples of the form '(type value),
     where TYPE is one of :char, :byte, :int16, :int32, :string. 

 (pg-execute conn portal-name &optional maximal-return-rows)
     Executes the execution plan that was previously bound to
     PORTAL-NAME. Optionally returns up to MAXIMAL-RETURN-ROWS rows
     (0 means an unlimited number of rows).  

 (pg-close-statement conn statement-name)
     Releases the command execution plan (prepared statement)
     STATEMENT-NAME. This also releases any open portals for that
     prepared statement.

 (pg-close-portal conn portal-name)
     Releases the portal PORTAL-NAME.

Example using prepared statements:

    (defun delete-item (db-connection int-value string-value)
      (pg-prepare db-connection "delete-statement"
    		  "DELETE FROM items WHERE int_column = $1 AND string_column = $2"
    		  `("int4" "varchar"))
      (unwind-protect
           (progn (pg-bind db-connection "delete-portal" "delete-statement"
    		       `((:int32 ,int-value) (:string ,string-value)))
    	      (pg-execute db-connection "delete-portal"))
        ;; NB: portal is closed automatically when statement is closed
        (pg-close-statement db-connection "delete-statement")))


=== Introspection support ==============================================

 (pg-databases connection) -> list of strings
     Return a list of the databases available at this site (a
     database is a set of tables; in a virgin PostgreSQL
     installation there is a single database named "template1").

 (pg-tables connection) -> list of strings
     Return a list of the tables present in the database to which we
     are currently connected. Only include user tables: system
     tables are excluded.

 (pg-columns connection table) -> list of strings
     Return a list of the columns (or attributes) in TABLE, which
     must be a table in the database to which we are currently
     connected. We only include the column names; if you want more
     detailed information (attribute types, for example), it can be
     obtained from `pg-result' on a SELECT statement for that table.


=== Support for large objects (BLOBs) =================================

 (pglo-create conn . args) -> oid
     Create a new large object (BLOB, or binary large object in
     other DBMSes parlance) in the database to which we are
     connected via CONN. Returns an OID (which is represented as an
     integer) which will allow you to use the large object.
     Optional ARGS are a Unix-style mode string which determines the
     permissions of the newly created large object, one of "r" for
     read-only permission, "w" for write-only, "rw" for read+write.
     Default is "r".

     Large-object functions MUST be used within a transaction (see
     the macro `with-pg-transaction').

 (pglo-open conn oid . args) -> fd
     Open a large object whose unique identifier is OID (an integer)
     in the database to which we are connected via CONN. Optional ARGS
     is a Unix-style mode string as for pglo-create; which defaults to
     "r" read-only permissions. Returns a file descriptor (an integer)
     which can be used in other large-object functions.

 (pglo-close conn fd)
     Close the file descriptor FD which was associated with a large
     object. Note that this does not delete the large object; use
     PGLO-UNLINK for that.

 (pglo-read conn fd bytes) -> string
     Read BYTES from the file descriptor FD which is associated with a
     large object. Return a string which should be BYTES characters
     long.

 (pglo-write connection fd buf)
     Write the bytes contained in the string BUF to the large object
     associated with the file descriptor FD.

 (pglo-lseek conn fd offset whence)
     Do the equivalent of a lseek(2) on the file descriptor FD which
     is associated with a large object; ie reposition the read/write
     file offset for that large object to OFFSET (an integer). WHENCE
     has the same significance as in lseek(); it should be one of
     SEEK_SET (set the offset to the absolute position), SEEK_CUR (set
     the offset relative to the current offset) or SEEK_END (set the
     offset relative to the end of the file). WHENCE should be an
     integer whose values can be obtained from the header file
      (probably 0, 1 and 2 respectively).

 (pglo-tell conn oid) -> integer
     Do the equivalent of an ftell(3) on the file associated with
     the large object whose unique identifier is OID. Returns the
     current position of the file offset for the object's associated
     file descriptor, as an integer.

 (pglo-unlink conn oid)
     Remove the large object whose unique identifier is OID from the
     system (in the current implementation of large objects in
     PostgreSQL, each large object is associated with an object in
     the filesystem).

 (pglo-import conn filename) -> oid
     Create a new large object and initialize it to the data contained
     in the file whose name is FILENAME. Returns an OID (as an
     integer). Note that is operation is only syntactic sugar around
     the basic large-object operations listed above.

 (pglo-export conn oid filename)
     Create a new file named FILENAME and fill it with the contents
     of the large object whose unique identifier is OID. This
     operation is also syntactic sugar.

 Boolean variable `*PG-DISABLE-TYPE-COERCION*' which can be set to
 non-nil (before initiating a connection) to disable the library's
 type coercion facility. Default is t.



 SECURITY NOTE: please note that your postmaster has to be started
 with the `-i' option in order for it to accept TCP/IP connections
 (typically this is not the default setting). See the PostgreSQL
 documentation at  for more
 information. 

 Setting up PostgreSQL to accept TCP/IP connections has security
 implications; please consult the documentation for details. You can
 connect to the database using Unix domain sockets if you wish to
 avoid setting up PostgreSQL to listen on a TCP socket.

 pg.lisp is able to use the crypt authentication method to avoid
 sending the password in cleartext over the wire (this assumes access
 to the `crypt' function via the FFI -- see sysdep.lisp). It can also
 use md5 passwords (which are used with the WITH ENCRYPTED PASSWORD
 form of the CREATE USER command), thanks to Pierre Mai's portable md5
 library. It does not support the Kerberos authentication method, nor
 OpenSSL connections (though this should not be difficult if your
 Common Lisp implementation is able to open SSL streams).

 It is also possible to use the port forwarding capabilities of ssh to
 establish a connection to the backend over TCP/IP, which provides
 both a secure authentication mechanism and encryption (and optionally
 compression) of data passing through the tunnel. Here's how to do it
 (thanks to Gene Selkov, Jr.  for the
 description):

 1. Establish a tunnel to the backend machine, like this:

 	ssh -L 3333:backend.dom:5432 postgres@backend.dom

    The first number in the -L argument, 3333, is the port number of
    your end of the tunnel. The second number, 5432, is the remote
    end of the tunnel -- the port number your backend is using. The
    name or the address in between the port numbers belongs to the
    server machine, as does the last argument to ssh that also includes
    the optional user name. Without the user name, ssh will try the
    name you are currently logged on as on the client machine. You can
    use any user name the server machine will accept, not necessarily
    those related to postgres.

 2. Now that you have a running ssh session, you can point pg.lisp to
    the local host at the port number which you specified in step 1.
    For example,

         (pg-connect "dbname" "user" :port 3333)

    You can omit the port argument if you chose 5432 as the local
    end of the tunnel, since pg.lisp defaults to this value.


At various times, this code has been tested or reported to work with

   * CMUCL 18d, 18e, 19a, 19c on Solaris/SPARC and Linux/x86
   * SBCL 0.9.2 to 0.9.16 on Linux/x86
   * CLISP 2.30 on LinuxPPC and SPARC
   * OpenMCL 0.13.x and 0.14.x on LinuxPPC
   * Armed Bear Common Lisp 
   * ACL 6.1 trial/x86
   * Lispworks 4.3 on Linux and Windows
   * PostgreSQL versions 6.5, 7.0, 7.1.2, 7.2, 7.3, 7.4, 8.0, 8.1


You may be interested in using "pg-psql" by Harley Gorrell, which
provides a psql-like listener interface to PostgreSQL (together with
tabulated output), on top of this library. See

  




2 Systems

The main system appears first, followed by any subsystem dependency.


Previous: , Up: Systems   [Contents][Index]

2.1 pg

Author

Eric Marsden

Version

0.24

Dependencies
  • sb-bsd-sockets (system).
  • sb-rotate-byte (system).
Source

pg.asd.

Child Components

Next: , Previous: , Up: The pg Reference Manual   [Contents][Index]

3 Files

Files are sorted by type and then listed depth-first from the systems components trees.


Previous: , Up: Files   [Contents][Index]

3.1 Lisp


Next: , Previous: , Up: Lisp   [Contents][Index]

3.1.1 pg/pg.asd

Source

pg.asd.

Parent Component

pg (system).

ASDF Systems

pg.

Packages

pg-system.

Internals

pg-component (class).


Next: , Previous: , Up: Lisp   [Contents][Index]

3.1.2 pg/md5.lisp

Source

pg.asd.

Parent Component

pg (system).

Packages

pg-md5.

Public Interface
Internals

Next: , Previous: , Up: Lisp   [Contents][Index]

3.1.3 pg/defpackage.lisp

Dependency

md5.lisp (file).

Source

pg.asd.

Parent Component

pg (system).

Packages

postgresql.


3.1.4 pg/sysdep.lisp

Dependencies
Source

pg.asd.

Parent Component

pg (system).

Internals

Next: , Previous: , Up: Lisp   [Contents][Index]

3.1.5 pg/meta-queries.lisp

Dependency

defpackage.lisp (file).

Source

pg.asd.

Parent Component

pg (system).

Public Interface
Internals

pg-describe-table (function).


3.1.6 pg/parsers.lisp

Dependency

defpackage.lisp (file).

Source

pg.asd.

Parent Component

pg (system).

Public Interface

*pg-disable-type-coercion* (special variable).

Internals

Next: , Previous: , Up: Lisp   [Contents][Index]

3.1.7 pg/utility.lisp

Dependency

defpackage.lisp (file).

Source

pg.asd.

Parent Component

pg (system).

Public Interface
Internals

Next: , Previous: , Up: Lisp   [Contents][Index]

3.1.8 pg/lowlevel.lisp

Dependency

defpackage.lisp (file).

Source

pg.asd.

Parent Component

pg (system).

Internals

3.1.9 pg/pg.lisp

Dependencies
Source

pg.asd.

Parent Component

pg (system).

Public Interface
Internals

Next: , Previous: , Up: Lisp   [Contents][Index]

3.1.10 pg/large-object.lisp

Dependency

pg.lisp (file).

Source

pg.asd.

Parent Component

pg (system).

Public Interface
Internals

3.1.11 pg/v2-protocol.lisp

Dependencies
Source

pg.asd.

Parent Component

pg (system).

Public Interface
Internals

Previous: , Up: Lisp   [Contents][Index]

3.1.12 pg/v3-protocol.lisp

Dependencies
Source

pg.asd.

Parent Component

pg (system).

Public Interface
Internals

4 Packages

Packages are listed by definition order.


Next: , Previous: , Up: Packages   [Contents][Index]

4.1 pg-system

Source

pg.asd.

Use List
  • asdf/interface.
  • common-lisp.
Internals

pg-component (class).


Next: , Previous: , Up: Packages   [Contents][Index]

4.2 pg-md5

Source

md5.lisp.

Use List

common-lisp.

Used By List

postgresql.

Public Interface
Internals

Previous: , Up: Packages   [Contents][Index]

4.3 postgresql

Source

defpackage.lisp.

Nickname

pg

Use List
Public Interface
Internals

Next: , Previous: , Up: The pg Reference Manual   [Contents][Index]

5 Definitions

Definitions are sorted by export status, category, package, and then by lexicographic order.


Next: , Previous: , Up: Definitions   [Contents][Index]

5.1 Public Interface


Next: , Previous: , Up: Public Interface   [Contents][Index]

5.1.1 Special variables

Special Variable: *pg-client-encoding*

The encoding that will be used for communication with the PostgreSQL backend, for example "LATIN1", "UTF8", "EUC_JP".
See <http://www.postgresql.org/docs/7.3/static/multibyte.html>.

Package

postgresql.

Source

pg.lisp.

Special Variable: *pg-disable-type-coercion*

Non-nil disables the type coercion mechanism.
The default is nil, which means that data recovered from the database is coerced to the corresponding Common Lisp type before being returned; for example numeric data is transformed to CL numbers, and booleans to booleans.

The coercion mechanism requires an initialization query to the database, in order to build a table mapping type names to OIDs. This option is provided mainly in case you wish to avoid the overhead of this initial query. The overhead is only incurred once per session (not per connection to the backend).

Package

postgresql.

Source

parsers.lisp.


5.1.2 Macros

Macro: with-pg-connection ((con &rest open-args) &body body)

Bindspec is of the form (connection open-args), where OPEN-ARGS are as for PG-CONNECT. The database connection is bound to the variable CONNECTION. If the connection is unsuccessful, the forms are not evaluated. Otherwise, the BODY forms are executed, and upon termination, normal or otherwise, the database connection is closed.

Package

postgresql.

Source

utility.lisp.

Macro: with-pg-transaction (con &body body)

Execute BODY forms in a BEGIN..END block.
If a PostgreSQL error occurs during execution of the forms, execute a ROLLBACK command.
Large-object manipulations _must_ occur within a transaction, since the large object descriptors are only valid within the context of a transaction.

Package

postgresql.

Source

utility.lisp.


5.1.3 Setf expanders

Setf Expander: (setf pg-client-encoding) (conn)
Package

postgresql.

Source

utility.lisp.

Reader

pg-client-encoding (function).

Writer

set-pg-client-encoding (function).

Setf Expander: (setf pg-date-style) (conn)
Package

postgresql.

Source

utility.lisp.

Reader

pg-date-style (function).

Writer

set-pg-date-style (function).


5.1.4 Ordinary functions

Function: fill-block ()

Convert a complete 64 byte input vector segment into the given 16 word MD5 block. This currently works on (unsigned-byte 8) and character simple-arrays, via the functions ‘fill-block-ub8’ and ‘fill-block-char’ respectively.

Package

pg-md5.

Source

md5.lisp.

Function: fill-block-char ()

Convert a complete 64 character input string segment starting from offset into the given 16 word MD5 block.

Package

pg-md5.

Source

md5.lisp.

Function: fill-block-ub8 ()

Convert a complete 64 (unsigned-byte 8) input vector segment starting from offset into the given 16 word MD5 block.

Package

pg-md5.

Source

md5.lisp.

Function: finalize-md5-state ()

If the given md5-state has not already been finalized, finalize it, by processing any remaining input in its buffer, with suitable padding and appended bit-length, as specified by the MD5 standard.

The resulting MD5 message-digest is returned as an array of sixteen (unsigned-byte 8) values. Calling ‘update-md5-state’ after a call to ‘finalize-md5-state’ results in unspecified behaviour.

Package

pg-md5.

Source

md5.lisp.

Function: initial-md5-regs ()

Create the initial working state of an MD5 run.

Package

pg-md5.

Source

md5.lisp.

Function: make-md5-state ()
Package

pg-md5.

Source

md5.lisp.

Function: md5-state-p (object)
Package

pg-md5.

Source

md5.lisp.

Function: md5regs-digest ()

Create the final 16 byte message-digest from the MD5 working state in regs. Returns a (simple-array (unsigned-byte 8) (16)).

Package

pg-md5.

Source

md5.lisp.

Function: md5sum-file (pathname)

Calculate the MD5 message-digest of the file designated by pathname.

Package

pg-md5.

Source

md5.lisp.

Function: md5sum-sequence (sequence &key start end)

Calculate the MD5 message-digest of data bounded by START and END in SEQUENCE , which must be a vector with element-type (UNSIGNED-BYTE 8).

Package

pg-md5.

Source

md5.lisp.

Function: md5sum-stream (stream)

Calculate an MD5 message-digest of the contents of STREAM, whose element-type has to be (UNSIGNED-BYTE 8).

Package

pg-md5.

Source

md5.lisp.

Function: pg-backend-version (conn)

Return a string identifying the version and operating environment of the backend.

Package

postgresql.

Source

meta-queries.lisp.

Function: pg-client-encoding (conn)

Return a string identifying the client encoding.

Package

postgresql.

Source

utility.lisp.

Setf expander for this function

(setf pg-client-encoding).

Function: pg-columns (conn table)

Return a list of the columns present in TABLE.

Package

postgresql.

Source

meta-queries.lisp.

Function: pg-connect (dbname user &key host port password encoding)

Initiate a connection with the PostgreSQL backend.
Connect to the database DBNAME with the username USER, on PORT of HOST, providing PASSWORD if necessary. Return a connection to the database (as an opaque type). If HOST is a pathname or a string starting with #/, it designates the directory containing the Unix socket on which PostgreSQL’s backend is waiting for local connections. We first attempt to speak the PostgreSQL 7.4 protocol, and fall back to the older network protocol if necessary.

Package

postgresql.

Source

pg.lisp.

Function: pg-databases (conn)

Return a list of the databases available at this site.

Package

postgresql.

Source

meta-queries.lisp.

Function: pg-date-style (conn)
Package

postgresql.

Source

utility.lisp.

Setf expander for this function

(setf pg-date-style).

Function: pg-for-each (conn select-form callback)

Create a cursor for SELECT-FORM, and call CALLBACK for each result. Uses the PostgreSQL database connection CONN. SELECT-FORM must be an SQL SELECT statement. The cursor is created using an SQL DECLARE CURSOR command, then results are fetched successively until no results are left. The cursor is then closed.

The work is performed within a transaction. The work can be interrupted before all tuples have been handled by THROWing to a tag called ’pg-finished.

Package

postgresql.

Source

utility.lisp.

Function: pg-result (result what &rest args)

Extract WHAT component of RESULT.
RESULT should be a structure obtained from a call to ‘pg-exec’, and WHAT should be one of
:connection -> return the connection object
:status -> return the status string provided by the database :attributes -> return the metadata, as a list of lists
:tuples -> return the data, as a list of lists
:tuple n -> return the nth component of the data
:oid -> return the OID (a unique identifier generated by PostgreSQL for each row resulting from an insertion

Package

postgresql.

Source

pg.lisp.

Function: pg-tables (conn)

Return a list of the tables present in this database.

Package

postgresql.

Source

meta-queries.lisp.

Function: pglo-close (connection fd)
Package

postgresql.

Source

large-object.lisp.

Function: pglo-create (connection &optional modestr)
Package

postgresql.

Source

large-object.lisp.

Function: pglo-export (connection oid filename)
Package

postgresql.

Source

large-object.lisp.

Function: pglo-import (connection filename)
Package

postgresql.

Source

large-object.lisp.

Function: pglo-lseek (connection fd offset whence)
Package

postgresql.

Source

large-object.lisp.

Function: pglo-open (connection oid &optional modestr)
Package

postgresql.

Source

large-object.lisp.

Function: pglo-tell (connection fd)
Package

postgresql.

Source

large-object.lisp.

Package

postgresql.

Source

large-object.lisp.

Function: pglo-write (connection fd buf)
Package

postgresql.

Source

large-object.lisp.

Function: update-md5-block ()

This is the core part of the MD5 algorithm. It takes a complete 16 word block of input, and updates the working state in A, B, C, and D accordingly.

Package

pg-md5.

Source

md5.lisp.

Function: update-md5-state ()

Update the given md5-state from sequence, which is either a simple-string or a simple-array with element-type (unsigned-byte 8), bounded by start and end, which must be numeric bounding-indices.

Package

pg-md5.

Source

md5.lisp.


5.1.5 Generic functions

Generic Function: pg-bind (connection portal statement-name list-of-types-and-values)

Gives the values for the parameters defined in the statement-name. The types can be one of :char :byte :int16 :int32 or :cstring

Package

postgresql.

Source

pg.lisp.

Methods
Method: pg-bind ((connection pgcon-v3) (portal string) (statement-name string) list-of-types-and-values)
Source

v3-protocol.lisp.

Generic Function: pg-close-portal (connection portal)

Closes a prepared statement portal

Package

postgresql.

Source

pg.lisp.

Methods
Method: pg-close-portal ((connection pgcon-v3) (portal string))
Source

v3-protocol.lisp.

Generic Function: pg-close-statement (connection statement-name)

Closes prepared statement specified by STATEMENT-NAME and closes
all portals associated with that statement (see PG-PREPARE and PG-BIND).

Package

postgresql.

Source

pg.lisp.

Methods
Method: pg-close-statement ((connection pgcon-v3) (statement-name string))
Source

v3-protocol.lisp.

Generic Function: pg-disconnect (connection &key abort)

Disconnects from the DB

Package

postgresql.

Source

pg.lisp.

Methods
Method: pg-disconnect ((connection pgcon-v3) &key abort)
Source

v3-protocol.lisp.

Method: pg-disconnect ((connection pgcon-v2) &key abort)
Source

v2-protocol.lisp.

Generic Function: pg-exec (connection &rest args)

Execute the SQL command given by the concatenation of ARGS on the database to which we are connected via CONNECTION. Return a result structure which can be decoded using ‘pg-result’.

Package

postgresql.

Source

pg.lisp.

Methods
Method: pg-exec ((connection pgcon-v3) &rest args)

Execute the SQL command given by the concatenation of ARGS on the database to which we are connected via CONNECTION. Return a result structure which can be decoded using ‘pg-result’.

Source

v3-protocol.lisp.

Method: pg-exec ((connection pgcon-v2) &rest args)

Execute the SQL command given by the concatenation of ARGS on the database to which we are connected via CONNECTION. Return a result structure which can be decoded using ‘pg-result’.

Source

v2-protocol.lisp.

Generic Function: pg-execute (connection portal &optional maximum-number-of-rows)

Executes the portal defined previously and return (optionally) up to MAXIMUM-NUMBER-OF-ROWS. For an unlimited number of rows use 0.

Package

postgresql.

Source

pg.lisp.

Methods
Method: pg-execute ((connection pgcon-v3) (portal string) &optional maximum-number-of-rows)
Source

v3-protocol.lisp.

Generic Function: pg-prepare (connection statement-name sql-statement &optional type-of-parameters)

Prepares a sql-statement give a given statement-name (can be empty) and optionally declares the types of the parameters as a list of strings. You can define parameters to be filled in later by using $1 and so on.

Package

postgresql.

Source

pg.lisp.

Methods
Method: pg-prepare ((connection pgcon-v3) (statement-name string) (sql-statement string) &optional type-of-parameters)
Source

v3-protocol.lisp.

Generic Function: pg-supports-pbe (connection)

Returns true if the connection supports pg-prepare/-bind and -execute

Package

postgresql.

Source

pg.lisp.

Methods
Method: pg-supports-pbe ((connection pgcon-v3))
Source

v3-protocol.lisp.

Method: pg-supports-pbe (connection)
Generic Reader: pgcon-sql-stream (object)
Package

postgresql.

Methods
Reader Method: pgcon-sql-stream ((pgcon-v3 pgcon-v3))

automatically generated reader method

Source

v3-protocol.lisp.

Target Slot

sql-stream.

Generic Writer: (setf pgcon-sql-stream) (object)
Package

postgresql.

Methods
Writer Method: (setf pgcon-sql-stream) ((pgcon-v3 pgcon-v3))

automatically generated writer method

Source

v3-protocol.lisp.

Target Slot

sql-stream.

Generic Function: pglo-read (connection fd bytes)

Read from a large object on file descriptor FD.

Package

postgresql.

Source

pg.lisp.

Methods
Method: pglo-read ((connection pgcon-v3) fd bytes)
Source

v3-protocol.lisp.

Method: pglo-read ((connection pgcon-v2) fd bytes)
Source

v2-protocol.lisp.


5.1.6 Standalone methods

Method: print-object ((self backend-notification) stream)
Source

v3-protocol.lisp.

Method: print-object ((self pgcon) stream)
Source

pg.lisp.

Method: print-object ((object pg-packet) stream)
Source

v3-protocol.lisp.


5.1.7 Conditions

Condition: authentication-failure
Package

postgresql.

Source

pg.lisp.

Direct superclasses

postgresql-error.

Direct methods

authentication-failure-reason.

Direct slots
Slot: reason
Initargs

:reason

Readers

authentication-failure-reason.

Writers

This slot is read-only.

Condition: backend-error
Package

postgresql.

Source

pg.lisp.

Direct superclasses

postgresql-error.

Direct subclasses

error-response.

Direct methods

backend-error-reason.

Direct slots
Slot: reason
Initargs

:reason

Readers

backend-error-reason.

Writers

This slot is read-only.

Condition: connection-failure
Package

postgresql.

Source

pg.lisp.

Direct superclasses

postgresql-error.

Direct methods
Direct slots
Slot: host
Initargs

:host

Readers

connection-failure-host.

Writers

This slot is read-only.

Slot: port
Initargs

:port

Readers

connection-failure-port.

Writers

This slot is read-only.

Slot: transport-error
Initargs

:transport-error

Readers

connection-failure-transport-error.

Writers

This slot is read-only.

Condition: postgresql-error
Package

postgresql.

Source

pg.lisp.

Direct superclasses

simple-error.

Direct subclasses
Condition: protocol-error
Package

postgresql.

Source

pg.lisp.

Direct superclasses

postgresql-error.

Direct methods

protocol-error-reason.

Direct slots
Slot: reason
Initargs

:reason

Readers

protocol-error-reason.

Writers

This slot is read-only.


Next: , Previous: , Up: Public Interface   [Contents][Index]

5.1.8 Structures

Structure: md5-state
Package

pg-md5.

Source

md5.lisp.

Direct superclasses

structure-object.

Direct slots
Slot: regs
Type

pg-md5:md5-regs

Initform

(pg-md5:initial-md5-regs)

Readers

md5-state-regs.

Writers

This slot is read-only.

Slot: amount
Type

(integer 0 *)

Initform

0

Readers

md5-state-amount.

Writers

(setf md5-state-amount).

Slot: block
Package

common-lisp.

Type

(simple-array (unsigned-byte 32) (16))

Initform

(make-array 16 :element-type (quote (unsigned-byte 32)))

Readers

md5-state-block.

Writers

This slot is read-only.

Slot: buffer
Type

(simple-array (unsigned-byte 8) (64))

Initform

(make-array 64 :element-type (quote (unsigned-byte 8)))

Readers

md5-state-buffer.

Writers

This slot is read-only.

Slot: buffer-index
Type

(integer 0 63)

Initform

0

Readers

md5-state-buffer-index.

Writers

(setf md5-state-buffer-index).

Slot: finalized-p
Readers

md5-state-finalized-p.

Writers

(setf md5-state-finalized-p).


Previous: , Up: Public Interface   [Contents][Index]

5.1.9 Types

Type: md5-regs ()

The working state of the MD5 algorithm, which contains the 4 32-bit registers A, B, C and D.

Package

pg-md5.

Source

md5.lisp.


5.2 Internals


Next: , Previous: , Up: Internals   [Contents][Index]

5.2.1 Constants

Constant: +buffer-size+

Size of internal buffer to use for md5sum-stream and md5sum-file operations. This should be a multiple of 64, the MD5 block size.

Package

pg-md5.

Source

md5.lisp.

Constant: +inv_archive+
Package

postgresql.

Source

large-object.lisp.

Constant: +inv_read+
Package

postgresql.

Source

large-object.lisp.

Constant: +inv_write+
Package

postgresql.

Source

large-object.lisp.

Constant: +lo_bufsiz+
Package

postgresql.

Source

large-object.lisp.

Constant: +max_message_len+
Package

postgresql.

Source

pg.lisp.

Constant: +md5-magic-a+

Initial value of Register A of the MD5 working state.

Package

pg-md5.

Source

md5.lisp.

Constant: +md5-magic-b+

Initial value of Register B of the MD5 working state.

Package

pg-md5.

Source

md5.lisp.

Constant: +md5-magic-c+

Initial value of Register C of the MD5 working state.

Package

pg-md5.

Source

md5.lisp.

Constant: +md5-magic-d+

Initial value of Register D of the MD5 working state.

Package

pg-md5.

Source

md5.lisp.

Constant: +namedatalen+
Package

postgresql.

Source

pg.lisp.

Constant: +sm_database+
Package

postgresql.

Source

pg.lisp.

Constant: +sm_options+
Package

postgresql.

Source

pg.lisp.

Constant: +sm_tty+
Package

postgresql.

Source

pg.lisp.

Constant: +sm_unused+
Package

postgresql.

Source

pg.lisp.

Constant: +sm_user+
Package

postgresql.

Source

pg.lisp.

Constant: +startup_krb4_msg+
Package

postgresql.

Source

pg.lisp.

Constant: +startup_krb5_msg+
Package

postgresql.

Source

pg.lisp.

Constant: +startup_msg+
Package

postgresql.

Source

pg.lisp.

Constant: +startup_packet_size+
Package

postgresql.

Source

pg.lisp.

Constant: +startup_password_msg+
Package

postgresql.

Source

pg.lisp.


Next: , Previous: , Up: Internals   [Contents][Index]

5.2.2 Special variables

Special Variable: *lo-functions*
Package

postgresql.

Source

large-object.lisp.

Special Variable: *lo-initialized*
Package

postgresql.

Source

large-object.lisp.

Special Variable: *old-features*
Package

pg-md5.

Source

md5.lisp.

Special Variable: *parsers*
Package

postgresql.

Source

parsers.lisp.

Special Variable: *pg-date-style*
Package

postgresql.

Source

pg.lisp.

Special Variable: *t*
Package

pg-md5.

Source

md5.lisp.

Special Variable: *type-parsers*
Package

postgresql.

Source

parsers.lisp.

Special Variable: *type-to-oid*

Is a hashtable for turning a typename into a OID. Needed to define the type of objects in pg-prepare

Package

postgresql.

Source

parsers.lisp.


5.2.3 Macros

Macro: %sysdep (desc &rest forms)
Package

postgresql.

Source

sysdep.lisp.

Macro: assemble-ub32 (a b c d)

Assemble an ub32 value from the given (unsigned-byte 8) values, where a is the intended low-order byte and d the high-order byte.

Package

pg-md5.

Source

md5.lisp.

Macro: md5-regs-a (regs)
Package

pg-md5.

Source

md5.lisp.

Macro: md5-regs-b (regs)
Package

pg-md5.

Source

md5.lisp.

Macro: md5-regs-c (regs)
Package

pg-md5.

Source

md5.lisp.

Macro: md5-regs-d (regs)
Package

pg-md5.

Source

md5.lisp.

Macro: with-md5-round ((op block) &rest clauses)
Package

pg-md5.

Source

md5.lisp.


Next: , Previous: , Up: Internals   [Contents][Index]

5.2.4 Compiler macros

Compiler Macro: mod32+ (a b)
Package

pg-md5.

Source

md5.lisp.


5.2.5 Ordinary functions

Function: %flush (connection)
Package

postgresql.

Source

lowlevel.lisp.

Function: %read-bytes (stream howmany)

Reads HOWMANY bytes from the STREAM. Returns the array of

Package

postgresql.

Source

lowlevel.lisp.

Function: %read-chars (stream howmany)
Package

postgresql.

Source

lowlevel.lisp.

Function: %read-cstring (stream maxbytes)

Read a null-terminated string from CONNECTION.

Package

postgresql.

Source

lowlevel.lisp.

Function: %read-net-int16 (stream)

Reads an integer BYTES bytes long from the STREAM. The signed integer is presumed to be in network order. Returns the integer.

Package

postgresql.

Source

lowlevel.lisp.

Function: %read-net-int32 (stream)

Reads an integer BYTES bytes long from the STREAM. The signed integer is presumed to be in network order. Returns the integer.

Package

postgresql.

Source

lowlevel.lisp.

Function: %read-net-int8 (stream)

Reads an integer BYTES bytes long from the STREAM. The signed integer is presumed to be in network order. Returns the integer.

Package

postgresql.

Source

lowlevel.lisp.

Function: %send-cstring (stream str)

Sends a null-terminated string to CONNECTION

Package

postgresql.

Source

lowlevel.lisp.

Function: %send-net-int (stream int bytes)
Package

postgresql.

Source

lowlevel.lisp.

Function: bitmap-ref/v2 (bitmap ref)
Package

postgresql.

Source

v2-protocol.lisp.

Function: bool-parser (str)
Package

postgresql.

Source

parsers.lisp.

Function: bytea->string (data)
Package

postgresql.

Source

parsers.lisp.

Function: convert-string-from-bytes (bytes encoding)
Package

postgresql.

Source

sysdep.lisp.

Function: convert-string-to-bytes (string encoding)
Package

postgresql.

Source

sysdep.lisp.

Function: copy-md5-state (instance)
Package

pg-md5.

Source

md5.lisp.

Function: copy-pgresult (instance)
Package

postgresql.

Source

pg.lisp.

Function: copy-to-buffer ()

Copy a partial segment from input vector from starting at from-offset and copying count elements into the 64 byte buffer starting at buffer-offset.

Package

pg-md5.

Source

md5.lisp.

Function: crypt (key salt)
Package

postgresql.

Source

sysdep.lisp.

Function: date-parser (str)
Package

postgresql.

Source

parsers.lisp.

Function: do-followup-query (connection)

Does the followup of a query

Package

postgresql.

Source

v3-protocol.lisp.

Function: f ()
Package

pg-md5.

Source

md5.lisp.

Function: float-parser (str)
Package

postgresql.

Source

parsers.lisp.

Function: g ()
Package

pg-md5.

Source

md5.lisp.

Function: h ()
Package

pg-md5.

Source

md5.lisp.

Function: handle-notice (connection)
Package

postgresql.

Source

v2-protocol.lisp.

Function: handle-notice/v3 (connection packet)
Package

postgresql.

Source

v3-protocol.lisp.

Function: i ()
Package

pg-md5.

Source

md5.lisp.

Function: implementation-name-for-encoding (encoding)
Package

postgresql.

Source

sysdep.lisp.

Function: initialize-parsers (connection)
Package

postgresql.

Source

parsers.lisp.

Function: integer-parser (str)
Package

postgresql.

Source

parsers.lisp.

Function: interval-parser (str)
Package

postgresql.

Source

parsers.lisp.

Function: isodate-parser (str)
Package

postgresql.

Source

parsers.lisp.

Function: lo-init (connection)
Package

postgresql.

Source

large-object.lisp.

Function: lookup-type (type)

Given the name of a type, returns the oid of the type or NIL if not found

Package

postgresql.

Source

parsers.lisp.

Function: make-pgresult (&key connection status attributes tuples)
Package

postgresql.

Source

pg.lisp.

Function: md5-digest (string &rest strings)
Package

postgresql.

Source

sysdep.lisp.

Function: md5-encode-password (user password salt)
Package

postgresql.

Source

sysdep.lisp.

Reader: md5-state-amount (instance)
Writer: (setf md5-state-amount) (instance)
Package

pg-md5.

Source

md5.lisp.

Target Slot

amount.

Reader: md5-state-block (instance)
Package

pg-md5.

Source

md5.lisp.

Target Slot

block.

Reader: md5-state-buffer (instance)
Package

pg-md5.

Source

md5.lisp.

Target Slot

buffer.

Reader: md5-state-buffer-index (instance)
Writer: (setf md5-state-buffer-index) (instance)
Package

pg-md5.

Source

md5.lisp.

Target Slot

buffer-index.

Reader: md5-state-finalized-p (instance)
Writer: (setf md5-state-finalized-p) (instance)
Package

pg-md5.

Source

md5.lisp.

Target Slot

finalized-p.

Reader: md5-state-regs (instance)
Package

pg-md5.

Source

md5.lisp.

Target Slot

regs.

Function: mod32+ ()
Package

pg-md5.

Source

md5.lisp.

Function: numeric-parser (str)
Package

postgresql.

Source

parsers.lisp.

Function: parse (str oid)
Package

postgresql.

Source

parsers.lisp.

Function: parse-timestamp (str)
Package

postgresql.

Source

parsers.lisp.

Function: pg-close (connection name type)
Package

postgresql.

Source

v3-protocol.lisp.

Function: pg-connect/v2 (dbname user &key host port password encoding)

Initiate a connection with the PostgreSQL backend, using protocol v2. Connect to the database DBNAME with the username USER, on PORT of HOST, providing PASSWORD if necessary. Return a connection to the database (as an opaque type). If HOST is a pathname or a string whose first character is #/, it designates the directory containing the Unix socket on which the PostgreSQL backend is listening.

Package

postgresql.

Source

v2-protocol.lisp.

Function: pg-connect/v3 (dbname user &key host port password encoding)

Initiate a connection with the PostgreSQL backend.
Connect to the database DBNAME with the username USER, on PORT of HOST, providing PASSWORD if necessary. Return a connection to the database (as an opaque type). If HOST is a pathname or a string whose first character is #/, it designates the directory containing the Unix socket on which the PostgreSQL backend is listening.

Package

postgresql.

Source

v3-protocol.lisp.

Function: pg-describe-table (conn table)
Package

postgresql.

Source

meta-queries.lisp.

Reader: pgresult-attributes (instance)
Writer: (setf pgresult-attributes) (instance)
Package

postgresql.

Source

pg.lisp.

Target Slot

attributes.

Reader: pgresult-connection (instance)
Writer: (setf pgresult-connection) (instance)
Package

postgresql.

Source

pg.lisp.

Target Slot

connection.

Function: pgresult-p (object)
Package

postgresql.

Source

pg.lisp.

Reader: pgresult-status (instance)
Writer: (setf pgresult-status) (instance)
Package

postgresql.

Source

pg.lisp.

Target Slot

status.

Reader: pgresult-tuples (instance)
Writer: (setf pgresult-tuples) (instance)
Package

postgresql.

Source

pg.lisp.

Target Slot

tuples.

Function: precise-timestamp-parser (str)
Package

postgresql.

Source

parsers.lisp.

Function: read-and-generate-error-response (connection packet)
Package

postgresql.

Source

v3-protocol.lisp.

Function: read-and-handle-notification-response (connection packet)
Package

postgresql.

Source

v3-protocol.lisp.

Function: read-attributes/v2 (connection)
Package

postgresql.

Source

v2-protocol.lisp.

Function: read-attributes/v3 (packet)
Package

postgresql.

Source

v3-protocol.lisp.

Function: read-net-int (connection bytes)
Package

postgresql.

Source

lowlevel.lisp.

Function: read-packet (connection)

Reads a packet from the connection.
Returns the packet, handles errors and notices automagically, but will still return them

Package

postgresql.

Source

v3-protocol.lisp.

Function: read-tuple/v2 (connection attributes)
Package

postgresql.

Source

v2-protocol.lisp.

Function: read-tuple/v3 (packet attributes)
Package

postgresql.

Source

v3-protocol.lisp.

Function: rol32 ()
Package

pg-md5.

Source

md5.lisp.

Function: row-parser (str)
Package

postgresql.

Source

parsers.lisp.

Function: send-int (connection int bytes)
Package

postgresql.

Source

lowlevel.lisp.

Function: send-octets (connection buffer)
Package

postgresql.

Source

lowlevel.lisp.

Function: send-packet (connection code description)

Sends a packet to the connection. CODE is the character code of the packet, description is a list of items with as first element one of :byte, :char :int16 :int32 or :cstring and as second element the value of the parameter

Package

postgresql.

Source

v3-protocol.lisp.

Function: send-string (connection str &optional pad-to)
Package

postgresql.

Source

lowlevel.lisp.

Function: set-pg-client-encoding (conn new-encoding)

Set the client_encoding.

Package

postgresql.

Source

utility.lisp.

Setf expanders to this function

(setf pg-client-encoding).

Function: set-pg-date-style (conn new-date-style)
Package

postgresql.

Source

utility.lisp.

Setf expanders to this function

(setf pg-date-style).

Function: socket-connect (port host-name)
Package

postgresql.

Source

sysdep.lisp.

Function: text-parser (str)
Package

postgresql.

Source

parsers.lisp.

Function: timestamp-parser (str)
Package

postgresql.

Source

parsers.lisp.


Next: , Previous: , Up: Internals   [Contents][Index]

5.2.6 Generic functions

Generic Reader: authentication-failure-reason (condition)
Package

postgresql.

Methods
Reader Method: authentication-failure-reason ((condition authentication-failure))
Source

pg.lisp.

Target Slot

reason.

Generic Reader: backend-error-reason (condition)
Package

postgresql.

Methods
Reader Method: backend-error-reason ((condition backend-error))
Source

pg.lisp.

Target Slot

reason.

Generic Reader: connection-failure-host (condition)
Package

postgresql.

Methods
Reader Method: connection-failure-host ((condition connection-failure))
Source

pg.lisp.

Target Slot

host.

Generic Reader: connection-failure-port (condition)
Package

postgresql.

Methods
Reader Method: connection-failure-port ((condition connection-failure))
Source

pg.lisp.

Target Slot

port.

Generic Reader: connection-failure-transport-error (condition)
Package

postgresql.

Methods
Reader Method: connection-failure-transport-error ((condition connection-failure))
Source

pg.lisp.

Target Slot

transport-error.

Generic Reader: error-response-code (condition)
Package

postgresql.

Methods
Reader Method: error-response-code ((condition error-response))
Source

v3-protocol.lisp.

Target Slot

code.

Generic Reader: error-response-detail (condition)
Package

postgresql.

Methods
Reader Method: error-response-detail ((condition error-response))
Source

v3-protocol.lisp.

Target Slot

detail.

Generic Reader: error-response-file (condition)
Package

postgresql.

Methods
Reader Method: error-response-file ((condition error-response))
Source

v3-protocol.lisp.

Target Slot

file.

Generic Reader: error-response-hint (condition)
Package

postgresql.

Methods
Reader Method: error-response-hint ((condition error-response))
Source

v3-protocol.lisp.

Target Slot

hint.

Generic Reader: error-response-line (condition)
Package

postgresql.

Methods
Reader Method: error-response-line ((condition error-response))
Source

v3-protocol.lisp.

Target Slot

line.

Generic Reader: error-response-message (condition)
Package

postgresql.

Methods
Reader Method: error-response-message ((condition error-response))
Source

v3-protocol.lisp.

Target Slot

message.

Generic Reader: error-response-position (condition)
Package

postgresql.

Methods
Reader Method: error-response-position ((condition error-response))
Source

v3-protocol.lisp.

Target Slot

position.

Generic Reader: error-response-routine (condition)
Package

postgresql.

Methods
Reader Method: error-response-routine ((condition error-response))
Source

v3-protocol.lisp.

Target Slot

routine.

Generic Reader: error-response-severity (condition)
Package

postgresql.

Methods
Reader Method: error-response-severity ((condition error-response))
Source

v3-protocol.lisp.

Target Slot

severity.

Generic Reader: error-response-where (condition)
Package

postgresql.

Methods
Reader Method: error-response-where ((condition error-response))
Source

v3-protocol.lisp.

Target Slot

where.

Generic Function: fn (connection fn integer-result &rest args)

Execute one of the large-object functions (lo_open, lo_close etc). Argument FN is either an integer, in which case it is the OID of an element in the pg_proc table, and otherwise it is a string which we look up in the alist *lo-functions* to find the corresponding OID.

Package

postgresql.

Source

pg.lisp.

Methods
Method: fn ((connection pgcon-v3) fn binary-result &rest args)
Source

v3-protocol.lisp.

Method: fn ((connection pgcon-v2) fn integer-result &rest args)
Source

v2-protocol.lisp.

Generic Reader: pg-packet-length (object)
Package

postgresql.

Methods
Reader Method: pg-packet-length ((pg-packet pg-packet))

automatically generated reader method

Source

v3-protocol.lisp.

Target Slot

length.

Generic Reader: pg-packet-type (object)
Package

postgresql.

Methods
Reader Method: pg-packet-type ((pg-packet pg-packet))

automatically generated reader method

Source

v3-protocol.lisp.

Target Slot

type.

Generic Reader: pgcon-binary-p (object)
Package

postgresql.

Methods
Reader Method: pgcon-binary-p ((pgcon pgcon))

automatically generated reader method

Source

pg.lisp.

Target Slot

binary-p.

Generic Writer: (setf pgcon-binary-p) (object)
Package

postgresql.

Methods
Writer Method: (setf pgcon-binary-p) ((pgcon pgcon))

automatically generated writer method

Source

pg.lisp.

Target Slot

binary-p.

Generic Reader: pgcon-encoding (object)
Package

postgresql.

Methods
Reader Method: pgcon-encoding ((pgcon pgcon))

automatically generated reader method

Source

pg.lisp.

Target Slot

encoding.

Generic Writer: (setf pgcon-encoding) (object)
Package

postgresql.

Methods
Writer Method: (setf pgcon-encoding) ((pgcon pgcon))

automatically generated writer method

Source

pg.lisp.

Target Slot

encoding.

Generic Reader: pgcon-host (object)
Package

postgresql.

Methods
Reader Method: pgcon-host ((pgcon pgcon))

automatically generated reader method

Source

pg.lisp.

Target Slot

host.

Generic Writer: (setf pgcon-host) (object)
Package

postgresql.

Methods
Writer Method: (setf pgcon-host) ((pgcon pgcon))

automatically generated writer method

Source

pg.lisp.

Target Slot

host.

Generic Reader: pgcon-notices (object)
Package

postgresql.

Methods
Reader Method: pgcon-notices ((pgcon pgcon))

automatically generated reader method

Source

pg.lisp.

Target Slot

notices.

Generic Writer: (setf pgcon-notices) (object)
Package

postgresql.

Methods
Writer Method: (setf pgcon-notices) ((pgcon pgcon))

automatically generated writer method

Source

pg.lisp.

Target Slot

notices.

Generic Reader: pgcon-parameters (object)
Package

postgresql.

Methods
Reader Method: pgcon-parameters ((pgcon-v3 pgcon-v3))

automatically generated reader method

Source

v3-protocol.lisp.

Target Slot

parameters.

Generic Writer: (setf pgcon-parameters) (object)
Package

postgresql.

Methods
Writer Method: (setf pgcon-parameters) ((pgcon-v3 pgcon-v3))

automatically generated writer method

Source

v3-protocol.lisp.

Target Slot

parameters.

Generic Reader: pgcon-pid (object)
Package

postgresql.

Methods
Reader Method: pgcon-pid ((pgcon pgcon))

automatically generated reader method

Source

pg.lisp.

Target Slot

pid.

Generic Writer: (setf pgcon-pid) (object)
Package

postgresql.

Methods
Writer Method: (setf pgcon-pid) ((pgcon pgcon))

automatically generated writer method

Source

pg.lisp.

Target Slot

pid.

Generic Reader: pgcon-port (object)
Package

postgresql.

Methods
Reader Method: pgcon-port ((pgcon pgcon))

automatically generated reader method

Source

pg.lisp.

Target Slot

port.

Generic Writer: (setf pgcon-port) (object)
Package

postgresql.

Methods
Writer Method: (setf pgcon-port) ((pgcon pgcon))

automatically generated writer method

Source

pg.lisp.

Target Slot

port.

Generic Reader: pgcon-secret (object)
Package

postgresql.

Methods
Reader Method: pgcon-secret ((pgcon pgcon))

automatically generated reader method

Source

pg.lisp.

Target Slot

secret.

Generic Writer: (setf pgcon-secret) (object)
Package

postgresql.

Methods
Writer Method: (setf pgcon-secret) ((pgcon pgcon))

automatically generated writer method

Source

pg.lisp.

Target Slot

secret.

Generic Reader: pgcon-stream (object)
Package

postgresql.

Methods
Reader Method: pgcon-stream ((pgcon pgcon))

automatically generated reader method

Source

pg.lisp.

Target Slot

stream.

Generic Writer: (setf pgcon-stream) (object)
Package

postgresql.

Methods
Writer Method: (setf pgcon-stream) ((pgcon pgcon))

automatically generated writer method

Source

pg.lisp.

Target Slot

stream.

Generic Reader: protocol-error-reason (condition)
Package

postgresql.

Methods
Reader Method: protocol-error-reason ((condition protocol-error))
Source

pg.lisp.

Target Slot

reason.

Generic Function: read-from-packet (packet type)

Reads an integer from the given PACKET with type TYPE

Package

postgresql.

Source

v3-protocol.lisp.

Methods
Method: read-from-packet ((packet pg-packet) (type (eql :char)))
Method: read-from-packet ((packet pg-packet) (type (eql :byte)))
Method: read-from-packet ((packet pg-packet) (type (eql :int16)))
Method: read-from-packet ((packet pg-packet) (type (eql :int32)))
Method: read-from-packet ((packet pg-packet) (type (eql :ucstring)))
Method: read-from-packet ((packet pg-packet) (type (eql :cstring)))
Generic Function: read-octets-from-packet (packet length)
Package

postgresql.

Source

v3-protocol.lisp.

Methods
Method: read-octets-from-packet ((packet pg-packet) (length integer))
Generic Function: read-string-from-packet (packet length)

Reads a string of LENGTH characters from the packet

Package

postgresql.

Source

v3-protocol.lisp.

Methods
Method: read-string-from-packet ((packet pg-packet) (length (eql -1)))
Method: read-string-from-packet ((packet pg-packet) (length integer))

Next: , Previous: , Up: Internals   [Contents][Index]

5.2.7 Conditions

Condition: error-response
Package

postgresql.

Source

v3-protocol.lisp.

Direct superclasses

backend-error.

Direct methods
Direct slots
Slot: severity
Initargs

:severity

Readers

error-response-severity.

Writers

This slot is read-only.

Slot: code
Initargs

:code

Readers

error-response-code.

Writers

This slot is read-only.

Slot: message
Initargs

:message

Readers

error-response-message.

Writers

This slot is read-only.

Slot: detail
Initargs

:detail

Readers

error-response-detail.

Writers

This slot is read-only.

Slot: hint
Initargs

:hint

Readers

error-response-hint.

Writers

This slot is read-only.

Slot: position
Package

common-lisp.

Initargs

:position

Readers

error-response-position.

Writers

This slot is read-only.

Slot: where
Initargs

:where

Readers

error-response-where.

Writers

This slot is read-only.

Slot: file
Initargs

:file

Readers

error-response-file.

Writers

This slot is read-only.

Slot: line
Initargs

:line

Readers

error-response-line.

Writers

This slot is read-only.

Slot: routine
Initargs

:routine

Readers

error-response-routine.

Writers

This slot is read-only.


Next: , Previous: , Up: Internals   [Contents][Index]

5.2.8 Structures

Structure: pgresult
Package

postgresql.

Source

pg.lisp.

Direct superclasses

structure-object.

Direct slots
Slot: connection
Readers

pgresult-connection.

Writers

(setf pgresult-connection).

Slot: status
Readers

pgresult-status.

Writers

(setf pgresult-status).

Slot: attributes
Readers

pgresult-attributes.

Writers

(setf pgresult-attributes).

Slot: tuples
Readers

pgresult-tuples.

Writers

(setf pgresult-tuples).


Next: , Previous: , Up: Internals   [Contents][Index]

5.2.9 Classes

Class: backend-notification
Package

postgresql.

Source

v3-protocol.lisp.

Direct methods

print-object.

Direct slots
Slot: severity
Slot: code
Slot: message
Slot: detail
Slot: hint
Slot: position
Package

common-lisp.

Slot: where
Slot: file
Slot: line
Slot: routine
Class: pg-component
Package

pg-system.

Source

pg.asd.

Direct superclasses

cl-source-file.

Class: pg-packet
Package

postgresql.

Source

v3-protocol.lisp.

Direct methods
Direct slots
Slot: type
Package

common-lisp.

Type

base-char

Initargs

:type

Readers

pg-packet-type.

Writers

This slot is read-only.

Slot: length
Package

common-lisp.

Type

(unsigned-byte 32)

Initargs

:length

Readers

pg-packet-length.

Writers

This slot is read-only.

Slot: data
Type

(array (unsigned-byte 8) *)

Initargs

:data

Slot: position
Package

common-lisp.

Type

integer

Initform

0

Slot: connection
Type

postgresql::pgcon-v3

Initargs

:connection

Class: pgcon
Package

postgresql.

Source

pg.lisp.

Direct subclasses
Direct methods
Direct slots
Slot: stream
Package

common-lisp.

Initargs

:stream

Readers

pgcon-stream.

Writers

(setf pgcon-stream).

Slot: host
Initargs

:host

Readers

pgcon-host.

Writers

(setf pgcon-host).

Slot: port
Initform

0

Initargs

:port

Readers

pgcon-port.

Writers

(setf pgcon-port).

Slot: pid
Readers

pgcon-pid.

Writers

(setf pgcon-pid).

Slot: secret
Readers

pgcon-secret.

Writers

(setf pgcon-secret).

Slot: notices
Initform

(list)

Readers

pgcon-notices.

Writers

(setf pgcon-notices).

Slot: binary-p
Readers

pgcon-binary-p.

Writers

(setf pgcon-binary-p).

Slot: encoding
Initargs

:encoding

Readers

pgcon-encoding.

Writers

(setf pgcon-encoding).

Class: pgcon-v2
Package

postgresql.

Source

v2-protocol.lisp.

Direct superclasses

pgcon.

Direct methods
Class: pgcon-v3
Package

postgresql.

Source

v3-protocol.lisp.

Direct superclasses

pgcon.

Direct methods
Direct slots
Slot: parameters
Initform

(list)

Readers

pgcon-parameters.

Writers

(setf pgcon-parameters).

Slot: sql-stream
Type

(or null stream)

Readers

pgcon-sql-stream.

Writers

(setf pgcon-sql-stream).


Previous: , Up: Internals   [Contents][Index]

5.2.10 Types

Type: buffer-index ()
Package

pg-md5.

Source

md5.lisp.

Type: ub32 ()

Corresponds to the 32bit quantity word of the MD5 Spec

Package

pg-md5.

Source

md5.lisp.


Appendix A Indexes


Next: , Previous: , Up: Indexes   [Contents][Index]

A.1 Concepts


Next: , Previous: , Up: Indexes   [Contents][Index]

A.2 Functions

Jump to:   %   (  
A   B   C   D   E   F   G   H   I   L   M   N   P   R   S   T   U   W  
Index Entry  Section

%
%flush: Private ordinary functions
%read-bytes: Private ordinary functions
%read-chars: Private ordinary functions
%read-cstring: Private ordinary functions
%read-net-int16: Private ordinary functions
%read-net-int32: Private ordinary functions
%read-net-int8: Private ordinary functions
%send-cstring: Private ordinary functions
%send-net-int: Private ordinary functions
%sysdep: Private macros

(
(setf md5-state-amount): Private ordinary functions
(setf md5-state-buffer-index): Private ordinary functions
(setf md5-state-finalized-p): Private ordinary functions
(setf pg-client-encoding): Public setf expanders
(setf pg-date-style): Public setf expanders
(setf pgcon-binary-p): Private generic functions
(setf pgcon-binary-p): Private generic functions
(setf pgcon-encoding): Private generic functions
(setf pgcon-encoding): Private generic functions
(setf pgcon-host): Private generic functions
(setf pgcon-host): Private generic functions
(setf pgcon-notices): Private generic functions
(setf pgcon-notices): Private generic functions
(setf pgcon-parameters): Private generic functions
(setf pgcon-parameters): Private generic functions
(setf pgcon-pid): Private generic functions
(setf pgcon-pid): Private generic functions
(setf pgcon-port): Private generic functions
(setf pgcon-port): Private generic functions
(setf pgcon-secret): Private generic functions
(setf pgcon-secret): Private generic functions
(setf pgcon-sql-stream): Public generic functions
(setf pgcon-sql-stream): Public generic functions
(setf pgcon-stream): Private generic functions
(setf pgcon-stream): Private generic functions
(setf pgresult-attributes): Private ordinary functions
(setf pgresult-connection): Private ordinary functions
(setf pgresult-status): Private ordinary functions
(setf pgresult-tuples): Private ordinary functions

A
assemble-ub32: Private macros
authentication-failure-reason: Private generic functions
authentication-failure-reason: Private generic functions

B
backend-error-reason: Private generic functions
backend-error-reason: Private generic functions
bitmap-ref/v2: Private ordinary functions
bool-parser: Private ordinary functions
bytea->string: Private ordinary functions

C
Compiler Macro, mod32+: Private compiler macros
connection-failure-host: Private generic functions
connection-failure-host: Private generic functions
connection-failure-port: Private generic functions
connection-failure-port: Private generic functions
connection-failure-transport-error: Private generic functions
connection-failure-transport-error: Private generic functions
convert-string-from-bytes: Private ordinary functions
convert-string-to-bytes: Private ordinary functions
copy-md5-state: Private ordinary functions
copy-pgresult: Private ordinary functions
copy-to-buffer: Private ordinary functions
crypt: Private ordinary functions

D
date-parser: Private ordinary functions
do-followup-query: Private ordinary functions

E
error-response-code: Private generic functions
error-response-code: Private generic functions
error-response-detail: Private generic functions
error-response-detail: Private generic functions
error-response-file: Private generic functions
error-response-file: Private generic functions
error-response-hint: Private generic functions
error-response-hint: Private generic functions
error-response-line: Private generic functions
error-response-line: Private generic functions
error-response-message: Private generic functions
error-response-message: Private generic functions
error-response-position: Private generic functions
error-response-position: Private generic functions
error-response-routine: Private generic functions
error-response-routine: Private generic functions
error-response-severity: Private generic functions
error-response-severity: Private generic functions
error-response-where: Private generic functions
error-response-where: Private generic functions

F
f: Private ordinary functions
fill-block: Public ordinary functions
fill-block-char: Public ordinary functions
fill-block-ub8: Public ordinary functions
finalize-md5-state: Public ordinary functions
float-parser: Private ordinary functions
fn: Private generic functions
fn: Private generic functions
fn: Private generic functions
Function, %flush: Private ordinary functions
Function, %read-bytes: Private ordinary functions
Function, %read-chars: Private ordinary functions
Function, %read-cstring: Private ordinary functions
Function, %read-net-int16: Private ordinary functions
Function, %read-net-int32: Private ordinary functions
Function, %read-net-int8: Private ordinary functions
Function, %send-cstring: Private ordinary functions
Function, %send-net-int: Private ordinary functions
Function, (setf md5-state-amount): Private ordinary functions
Function, (setf md5-state-buffer-index): Private ordinary functions
Function, (setf md5-state-finalized-p): Private ordinary functions
Function, (setf pgresult-attributes): Private ordinary functions
Function, (setf pgresult-connection): Private ordinary functions
Function, (setf pgresult-status): Private ordinary functions
Function, (setf pgresult-tuples): Private ordinary functions
Function, bitmap-ref/v2: Private ordinary functions
Function, bool-parser: Private ordinary functions
Function, bytea->string: Private ordinary functions
Function, convert-string-from-bytes: Private ordinary functions
Function, convert-string-to-bytes: Private ordinary functions
Function, copy-md5-state: Private ordinary functions
Function, copy-pgresult: Private ordinary functions
Function, copy-to-buffer: Private ordinary functions
Function, crypt: Private ordinary functions
Function, date-parser: Private ordinary functions
Function, do-followup-query: Private ordinary functions
Function, f: Private ordinary functions
Function, fill-block: Public ordinary functions
Function, fill-block-char: Public ordinary functions
Function, fill-block-ub8: Public ordinary functions
Function, finalize-md5-state: Public ordinary functions
Function, float-parser: Private ordinary functions
Function, g: Private ordinary functions
Function, h: Private ordinary functions
Function, handle-notice: Private ordinary functions
Function, handle-notice/v3: Private ordinary functions
Function, i: Private ordinary functions
Function, implementation-name-for-encoding: Private ordinary functions
Function, initial-md5-regs: Public ordinary functions
Function, initialize-parsers: Private ordinary functions
Function, integer-parser: Private ordinary functions
Function, interval-parser: Private ordinary functions
Function, isodate-parser: Private ordinary functions
Function, lo-init: Private ordinary functions
Function, lookup-type: Private ordinary functions
Function, make-md5-state: Public ordinary functions
Function, make-pgresult: Private ordinary functions
Function, md5-digest: Private ordinary functions
Function, md5-encode-password: Private ordinary functions
Function, md5-state-amount: Private ordinary functions
Function, md5-state-block: Private ordinary functions
Function, md5-state-buffer: Private ordinary functions
Function, md5-state-buffer-index: Private ordinary functions
Function, md5-state-finalized-p: Private ordinary functions
Function, md5-state-p: Public ordinary functions
Function, md5-state-regs: Private ordinary functions
Function, md5regs-digest: Public ordinary functions
Function, md5sum-file: Public ordinary functions
Function, md5sum-sequence: Public ordinary functions
Function, md5sum-stream: Public ordinary functions
Function, mod32+: Private ordinary functions
Function, numeric-parser: Private ordinary functions
Function, parse: Private ordinary functions
Function, parse-timestamp: Private ordinary functions
Function, pg-backend-version: Public ordinary functions
Function, pg-client-encoding: Public ordinary functions
Function, pg-close: Private ordinary functions
Function, pg-columns: Public ordinary functions
Function, pg-connect: Public ordinary functions
Function, pg-connect/v2: Private ordinary functions
Function, pg-connect/v3: Private ordinary functions
Function, pg-databases: Public ordinary functions
Function, pg-date-style: Public ordinary functions
Function, pg-describe-table: Private ordinary functions
Function, pg-for-each: Public ordinary functions
Function, pg-result: Public ordinary functions
Function, pg-tables: Public ordinary functions
Function, pglo-close: Public ordinary functions
Function, pglo-create: Public ordinary functions
Function, pglo-export: Public ordinary functions
Function, pglo-import: Public ordinary functions
Function, pglo-lseek: Public ordinary functions
Function, pglo-open: Public ordinary functions
Function, pglo-tell: Public ordinary functions
Function, pglo-unlink: Public ordinary functions
Function, pglo-write: Public ordinary functions
Function, pgresult-attributes: Private ordinary functions
Function, pgresult-connection: Private ordinary functions
Function, pgresult-p: Private ordinary functions
Function, pgresult-status: Private ordinary functions
Function, pgresult-tuples: Private ordinary functions
Function, precise-timestamp-parser: Private ordinary functions
Function, read-and-generate-error-response: Private ordinary functions
Function, read-and-handle-notification-response: Private ordinary functions
Function, read-attributes/v2: Private ordinary functions
Function, read-attributes/v3: Private ordinary functions
Function, read-net-int: Private ordinary functions
Function, read-packet: Private ordinary functions
Function, read-tuple/v2: Private ordinary functions
Function, read-tuple/v3: Private ordinary functions
Function, rol32: Private ordinary functions
Function, row-parser: Private ordinary functions
Function, send-int: Private ordinary functions
Function, send-octets: Private ordinary functions
Function, send-packet: Private ordinary functions
Function, send-string: Private ordinary functions
Function, set-pg-client-encoding: Private ordinary functions
Function, set-pg-date-style: Private ordinary functions
Function, socket-connect: Private ordinary functions
Function, text-parser: Private ordinary functions
Function, timestamp-parser: Private ordinary functions
Function, update-md5-block: Public ordinary functions
Function, update-md5-state: Public ordinary functions

G
g: Private ordinary functions
Generic Function, (setf pgcon-binary-p): Private generic functions
Generic Function, (setf pgcon-encoding): Private generic functions
Generic Function, (setf pgcon-host): Private generic functions
Generic Function, (setf pgcon-notices): Private generic functions
Generic Function, (setf pgcon-parameters): Private generic functions
Generic Function, (setf pgcon-pid): Private generic functions
Generic Function, (setf pgcon-port): Private generic functions
Generic Function, (setf pgcon-secret): Private generic functions
Generic Function, (setf pgcon-sql-stream): Public generic functions
Generic Function, (setf pgcon-stream): Private generic functions
Generic Function, authentication-failure-reason: Private generic functions
Generic Function, backend-error-reason: Private generic functions
Generic Function, connection-failure-host: Private generic functions
Generic Function, connection-failure-port: Private generic functions
Generic Function, connection-failure-transport-error: Private generic functions
Generic Function, error-response-code: Private generic functions
Generic Function, error-response-detail: Private generic functions
Generic Function, error-response-file: Private generic functions
Generic Function, error-response-hint: Private generic functions
Generic Function, error-response-line: Private generic functions
Generic Function, error-response-message: Private generic functions
Generic Function, error-response-position: Private generic functions
Generic Function, error-response-routine: Private generic functions
Generic Function, error-response-severity: Private generic functions
Generic Function, error-response-where: Private generic functions
Generic Function, fn: Private generic functions
Generic Function, pg-bind: Public generic functions
Generic Function, pg-close-portal: Public generic functions
Generic Function, pg-close-statement: Public generic functions
Generic Function, pg-disconnect: Public generic functions
Generic Function, pg-exec: Public generic functions
Generic Function, pg-execute: Public generic functions
Generic Function, pg-packet-length: Private generic functions
Generic Function, pg-packet-type: Private generic functions
Generic Function, pg-prepare: Public generic functions
Generic Function, pg-supports-pbe: Public generic functions
Generic Function, pgcon-binary-p: Private generic functions
Generic Function, pgcon-encoding: Private generic functions
Generic Function, pgcon-host: Private generic functions
Generic Function, pgcon-notices: Private generic functions
Generic Function, pgcon-parameters: Private generic functions
Generic Function, pgcon-pid: Private generic functions
Generic Function, pgcon-port: Private generic functions
Generic Function, pgcon-secret: Private generic functions
Generic Function, pgcon-sql-stream: Public generic functions
Generic Function, pgcon-stream: Private generic functions
Generic Function, pglo-read: Public generic functions
Generic Function, protocol-error-reason: Private generic functions
Generic Function, read-from-packet: Private generic functions
Generic Function, read-octets-from-packet: Private generic functions
Generic Function, read-string-from-packet: Private generic functions

H
h: Private ordinary functions
handle-notice: Private ordinary functions
handle-notice/v3: Private ordinary functions

I
i: Private ordinary functions
implementation-name-for-encoding: Private ordinary functions
initial-md5-regs: Public ordinary functions
initialize-parsers: Private ordinary functions
integer-parser: Private ordinary functions
interval-parser: Private ordinary functions
isodate-parser: Private ordinary functions

L
lo-init: Private ordinary functions
lookup-type: Private ordinary functions

M
Macro, %sysdep: Private macros
Macro, assemble-ub32: Private macros
Macro, md5-regs-a: Private macros
Macro, md5-regs-b: Private macros
Macro, md5-regs-c: Private macros
Macro, md5-regs-d: Private macros
Macro, with-md5-round: Private macros
Macro, with-pg-connection: Public macros
Macro, with-pg-transaction: Public macros
make-md5-state: Public ordinary functions
make-pgresult: Private ordinary functions
md5-digest: Private ordinary functions
md5-encode-password: Private ordinary functions
md5-regs-a: Private macros
md5-regs-b: Private macros
md5-regs-c: Private macros
md5-regs-d: Private macros
md5-state-amount: Private ordinary functions
md5-state-block: Private ordinary functions
md5-state-buffer: Private ordinary functions
md5-state-buffer-index: Private ordinary functions
md5-state-finalized-p: Private ordinary functions
md5-state-p: Public ordinary functions
md5-state-regs: Private ordinary functions
md5regs-digest: Public ordinary functions
md5sum-file: Public ordinary functions
md5sum-sequence: Public ordinary functions
md5sum-stream: Public ordinary functions
Method, (setf pgcon-binary-p): Private generic functions
Method, (setf pgcon-encoding): Private generic functions
Method, (setf pgcon-host): Private generic functions
Method, (setf pgcon-notices): Private generic functions
Method, (setf pgcon-parameters): Private generic functions
Method, (setf pgcon-pid): Private generic functions
Method, (setf pgcon-port): Private generic functions
Method, (setf pgcon-secret): Private generic functions
Method, (setf pgcon-sql-stream): Public generic functions
Method, (setf pgcon-stream): Private generic functions
Method, authentication-failure-reason: Private generic functions
Method, backend-error-reason: Private generic functions
Method, connection-failure-host: Private generic functions
Method, connection-failure-port: Private generic functions
Method, connection-failure-transport-error: Private generic functions
Method, error-response-code: Private generic functions
Method, error-response-detail: Private generic functions
Method, error-response-file: Private generic functions
Method, error-response-hint: Private generic functions
Method, error-response-line: Private generic functions
Method, error-response-message: Private generic functions
Method, error-response-position: Private generic functions
Method, error-response-routine: Private generic functions
Method, error-response-severity: Private generic functions
Method, error-response-where: Private generic functions
Method, fn: Private generic functions
Method, fn: Private generic functions
Method, pg-bind: Public generic functions
Method, pg-close-portal: Public generic functions
Method, pg-close-statement: Public generic functions
Method, pg-disconnect: Public generic functions
Method, pg-disconnect: Public generic functions
Method, pg-exec: Public generic functions
Method, pg-exec: Public generic functions
Method, pg-execute: Public generic functions
Method, pg-packet-length: Private generic functions
Method, pg-packet-type: Private generic functions
Method, pg-prepare: Public generic functions
Method, pg-supports-pbe: Public generic functions
Method, pg-supports-pbe: Public generic functions
Method, pgcon-binary-p: Private generic functions
Method, pgcon-encoding: Private generic functions
Method, pgcon-host: Private generic functions
Method, pgcon-notices: Private generic functions
Method, pgcon-parameters: Private generic functions
Method, pgcon-pid: Private generic functions
Method, pgcon-port: Private generic functions
Method, pgcon-secret: Private generic functions
Method, pgcon-sql-stream: Public generic functions
Method, pgcon-stream: Private generic functions
Method, pglo-read: Public generic functions
Method, pglo-read: Public generic functions
Method, print-object: Public standalone methods
Method, print-object: Public standalone methods
Method, print-object: Public standalone methods
Method, protocol-error-reason: Private generic functions
Method, read-from-packet: Private generic functions
Method, read-from-packet: Private generic functions
Method, read-from-packet: Private generic functions
Method, read-from-packet: Private generic functions
Method, read-from-packet: Private generic functions
Method, read-from-packet: Private generic functions
Method, read-octets-from-packet: Private generic functions
Method, read-string-from-packet: Private generic functions
Method, read-string-from-packet: Private generic functions
mod32+: Private compiler macros
mod32+: Private ordinary functions

N
numeric-parser: Private ordinary functions

P
parse: Private ordinary functions
parse-timestamp: Private ordinary functions
pg-backend-version: Public ordinary functions
pg-bind: Public generic functions
pg-bind: Public generic functions
pg-client-encoding: Public ordinary functions
pg-close: Private ordinary functions
pg-close-portal: Public generic functions
pg-close-portal: Public generic functions
pg-close-statement: Public generic functions
pg-close-statement: Public generic functions
pg-columns: Public ordinary functions
pg-connect: Public ordinary functions
pg-connect/v2: Private ordinary functions
pg-connect/v3: Private ordinary functions
pg-databases: Public ordinary functions
pg-date-style: Public ordinary functions
pg-describe-table: Private ordinary functions
pg-disconnect: Public generic functions
pg-disconnect: Public generic functions
pg-disconnect: Public generic functions
pg-exec: Public generic functions
pg-exec: Public generic functions
pg-exec: Public generic functions
pg-execute: Public generic functions
pg-execute: Public generic functions
pg-for-each: Public ordinary functions
pg-packet-length: Private generic functions
pg-packet-length: Private generic functions
pg-packet-type: Private generic functions
pg-packet-type: Private generic functions
pg-prepare: Public generic functions
pg-prepare: Public generic functions
pg-result: Public ordinary functions
pg-supports-pbe: Public generic functions
pg-supports-pbe: Public generic functions
pg-supports-pbe: Public generic functions
pg-tables: Public ordinary functions
pgcon-binary-p: Private generic functions
pgcon-binary-p: Private generic functions
pgcon-encoding: Private generic functions
pgcon-encoding: Private generic functions
pgcon-host: Private generic functions
pgcon-host: Private generic functions
pgcon-notices: Private generic functions
pgcon-notices: Private generic functions
pgcon-parameters: Private generic functions
pgcon-parameters: Private generic functions
pgcon-pid: Private generic functions
pgcon-pid: Private generic functions
pgcon-port: Private generic functions
pgcon-port: Private generic functions
pgcon-secret: Private generic functions
pgcon-secret: Private generic functions
pgcon-sql-stream: Public generic functions
pgcon-sql-stream: Public generic functions
pgcon-stream: Private generic functions
pgcon-stream: Private generic functions
pglo-close: Public ordinary functions
pglo-create: Public ordinary functions
pglo-export: Public ordinary functions
pglo-import: Public ordinary functions
pglo-lseek: Public ordinary functions
pglo-open: Public ordinary functions
pglo-read: Public generic functions
pglo-read: Public generic functions
pglo-read: Public generic functions
pglo-tell: Public ordinary functions
pglo-unlink: Public ordinary functions
pglo-write: Public ordinary functions
pgresult-attributes: Private ordinary functions
pgresult-connection: Private ordinary functions
pgresult-p: Private ordinary functions
pgresult-status: Private ordinary functions
pgresult-tuples: Private ordinary functions
precise-timestamp-parser: Private ordinary functions
print-object: Public standalone methods
print-object: Public standalone methods
print-object: Public standalone methods
protocol-error-reason: Private generic functions
protocol-error-reason: Private generic functions

R
read-and-generate-error-response: Private ordinary functions
read-and-handle-notification-response: Private ordinary functions
read-attributes/v2: Private ordinary functions
read-attributes/v3: Private ordinary functions
read-from-packet: Private generic functions
read-from-packet: Private generic functions
read-from-packet: Private generic functions
read-from-packet: Private generic functions
read-from-packet: Private generic functions
read-from-packet: Private generic functions
read-from-packet: Private generic functions
read-net-int: Private ordinary functions
read-octets-from-packet: Private generic functions
read-octets-from-packet: Private generic functions
read-packet: Private ordinary functions
read-string-from-packet: Private generic functions
read-string-from-packet: Private generic functions
read-string-from-packet: Private generic functions
read-tuple/v2: Private ordinary functions
read-tuple/v3: Private ordinary functions
rol32: Private ordinary functions
row-parser: Private ordinary functions

S
send-int: Private ordinary functions
send-octets: Private ordinary functions
send-packet: Private ordinary functions
send-string: Private ordinary functions
set-pg-client-encoding: Private ordinary functions
set-pg-date-style: Private ordinary functions
Setf Expander, (setf pg-client-encoding): Public setf expanders
Setf Expander, (setf pg-date-style): Public setf expanders
socket-connect: Private ordinary functions

T
text-parser: Private ordinary functions
timestamp-parser: Private ordinary functions

U
update-md5-block: Public ordinary functions
update-md5-state: Public ordinary functions

W
with-md5-round: Private macros
with-pg-connection: Public macros
with-pg-transaction: Public macros

Jump to:   %   (  
A   B   C   D   E   F   G   H   I   L   M   N   P   R   S   T   U   W  

Next: , Previous: , Up: Indexes   [Contents][Index]

A.3 Variables

Jump to:   *   +  
A   B   C   D   E   F   H   L   M   N   P   R   S   T   W  
Index Entry  Section

*
*lo-functions*: Private special variables
*lo-initialized*: Private special variables
*old-features*: Private special variables
*parsers*: Private special variables
*pg-client-encoding*: Public special variables
*pg-date-style*: Private special variables
*pg-disable-type-coercion*: Public special variables
*t*: Private special variables
*type-parsers*: Private special variables
*type-to-oid*: Private special variables

+
+buffer-size+: Private constants
+inv_archive+: Private constants
+inv_read+: Private constants
+inv_write+: Private constants
+lo_bufsiz+: Private constants
+max_message_len+: Private constants
+md5-magic-a+: Private constants
+md5-magic-b+: Private constants
+md5-magic-c+: Private constants
+md5-magic-d+: Private constants
+namedatalen+: Private constants
+sm_database+: Private constants
+sm_options+: Private constants
+sm_tty+: Private constants
+sm_unused+: Private constants
+sm_user+: Private constants
+startup_krb4_msg+: Private constants
+startup_krb5_msg+: Private constants
+startup_msg+: Private constants
+startup_packet_size+: Private constants
+startup_password_msg+: Private constants

A
amount: Public structures
attributes: Private structures

B
binary-p: Private classes
block: Public structures
buffer: Public structures
buffer-index: Public structures

C
code: Private conditions
code: Private classes
connection: Private structures
connection: Private classes
Constant, +buffer-size+: Private constants
Constant, +inv_archive+: Private constants
Constant, +inv_read+: Private constants
Constant, +inv_write+: Private constants
Constant, +lo_bufsiz+: Private constants
Constant, +max_message_len+: Private constants
Constant, +md5-magic-a+: Private constants
Constant, +md5-magic-b+: Private constants
Constant, +md5-magic-c+: Private constants
Constant, +md5-magic-d+: Private constants
Constant, +namedatalen+: Private constants
Constant, +sm_database+: Private constants
Constant, +sm_options+: Private constants
Constant, +sm_tty+: Private constants
Constant, +sm_unused+: Private constants
Constant, +sm_user+: Private constants
Constant, +startup_krb4_msg+: Private constants
Constant, +startup_krb5_msg+: Private constants
Constant, +startup_msg+: Private constants
Constant, +startup_packet_size+: Private constants
Constant, +startup_password_msg+: Private constants

D
data: Private classes
detail: Private conditions
detail: Private classes

E
encoding: Private classes

F
file: Private conditions
file: Private classes
finalized-p: Public structures

H
hint: Private conditions
hint: Private classes
host: Public conditions
host: Private classes

L
length: Private classes
line: Private conditions
line: Private classes

M
message: Private conditions
message: Private classes

N
notices: Private classes

P
parameters: Private classes
pid: Private classes
port: Public conditions
port: Private classes
position: Private conditions
position: Private classes
position: Private classes

R
reason: Public conditions
reason: Public conditions
reason: Public conditions
regs: Public structures
routine: Private conditions
routine: Private classes

S
secret: Private classes
severity: Private conditions
severity: Private classes
Slot, amount: Public structures
Slot, attributes: Private structures
Slot, binary-p: Private classes
Slot, block: Public structures
Slot, buffer: Public structures
Slot, buffer-index: Public structures
Slot, code: Private conditions
Slot, code: Private classes
Slot, connection: Private structures
Slot, connection: Private classes
Slot, data: Private classes
Slot, detail: Private conditions
Slot, detail: Private classes
Slot, encoding: Private classes
Slot, file: Private conditions
Slot, file: Private classes
Slot, finalized-p: Public structures
Slot, hint: Private conditions
Slot, hint: Private classes
Slot, host: Public conditions
Slot, host: Private classes
Slot, length: Private classes
Slot, line: Private conditions
Slot, line: Private classes
Slot, message: Private conditions
Slot, message: Private classes
Slot, notices: Private classes
Slot, parameters: Private classes
Slot, pid: Private classes
Slot, port: Public conditions
Slot, port: Private classes
Slot, position: Private conditions
Slot, position: Private classes
Slot, position: Private classes
Slot, reason: Public conditions
Slot, reason: Public conditions
Slot, reason: Public conditions
Slot, regs: Public structures
Slot, routine: Private conditions
Slot, routine: Private classes
Slot, secret: Private classes
Slot, severity: Private conditions
Slot, severity: Private classes
Slot, sql-stream: Private classes
Slot, status: Private structures
Slot, stream: Private classes
Slot, transport-error: Public conditions
Slot, tuples: Private structures
Slot, type: Private classes
Slot, where: Private conditions
Slot, where: Private classes
Special Variable, *lo-functions*: Private special variables
Special Variable, *lo-initialized*: Private special variables
Special Variable, *old-features*: Private special variables
Special Variable, *parsers*: Private special variables
Special Variable, *pg-client-encoding*: Public special variables
Special Variable, *pg-date-style*: Private special variables
Special Variable, *pg-disable-type-coercion*: Public special variables
Special Variable, *t*: Private special variables
Special Variable, *type-parsers*: Private special variables
Special Variable, *type-to-oid*: Private special variables
sql-stream: Private classes
status: Private structures
stream: Private classes

T
transport-error: Public conditions
tuples: Private structures
type: Private classes

W
where: Private conditions
where: Private classes

Jump to:   *   +  
A   B   C   D   E   F   H   L   M   N   P   R   S   T   W  

Previous: , Up: Indexes   [Contents][Index]

A.4 Data types

Jump to:   A   B   C   D   E   F   L   M   P   S   T   U   V  
Index Entry  Section

A
authentication-failure: Public conditions

B
backend-error: Public conditions
backend-notification: Private classes
buffer-index: Private types

C
Class, backend-notification: Private classes
Class, pg-component: Private classes
Class, pg-packet: Private classes
Class, pgcon: Private classes
Class, pgcon-v2: Private classes
Class, pgcon-v3: Private classes
Condition, authentication-failure: Public conditions
Condition, backend-error: Public conditions
Condition, connection-failure: Public conditions
Condition, error-response: Private conditions
Condition, postgresql-error: Public conditions
Condition, protocol-error: Public conditions
connection-failure: Public conditions

D
defpackage.lisp: The pg/defpackage․lisp file

E
error-response: Private conditions

F
File, defpackage.lisp: The pg/defpackage․lisp file
File, large-object.lisp: The pg/large-object․lisp file
File, lowlevel.lisp: The pg/lowlevel․lisp file
File, md5.lisp: The pg/md5․lisp file
File, meta-queries.lisp: The pg/meta-queries․lisp file
File, parsers.lisp: The pg/parsers․lisp file
File, pg.asd: The pg/pg․asd file
File, pg.lisp: The pg/pg․lisp file
File, sysdep.lisp: The pg/sysdep․lisp file
File, utility.lisp: The pg/utility․lisp file
File, v2-protocol.lisp: The pg/v2-protocol․lisp file
File, v3-protocol.lisp: The pg/v3-protocol․lisp file

L
large-object.lisp: The pg/large-object․lisp file
lowlevel.lisp: The pg/lowlevel․lisp file

M
md5-regs: Public types
md5-state: Public structures
md5.lisp: The pg/md5․lisp file
meta-queries.lisp: The pg/meta-queries․lisp file

P
Package, pg-md5: The pg-md5 package
Package, pg-system: The pg-system package
Package, postgresql: The postgresql package
parsers.lisp: The pg/parsers․lisp file
pg: The pg system
pg-component: Private classes
pg-md5: The pg-md5 package
pg-packet: Private classes
pg-system: The pg-system package
pg.asd: The pg/pg․asd file
pg.lisp: The pg/pg․lisp file
pgcon: Private classes
pgcon-v2: Private classes
pgcon-v3: Private classes
pgresult: Private structures
postgresql: The postgresql package
postgresql-error: Public conditions
protocol-error: Public conditions

S
Structure, md5-state: Public structures
Structure, pgresult: Private structures
sysdep.lisp: The pg/sysdep․lisp file
System, pg: The pg system

T
Type, buffer-index: Private types
Type, md5-regs: Public types
Type, ub32: Private types

U
ub32: Private types
utility.lisp: The pg/utility․lisp file

V
v2-protocol.lisp: The pg/v2-protocol․lisp file
v3-protocol.lisp: The pg/v3-protocol․lisp file

Jump to:   A   B   C   D   E   F   L   M   P   S   T   U   V