The pg Reference Manual

Table of Contents

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

The pg Reference Manual

This is the pg Reference Manual, version 0.24, generated automatically by Declt version 2.3 "Robert April" on Tue Feb 20 09:10:14 2018 GMT+0.


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

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

  




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

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
Source

pg.asd (file)

Components

Next: , Previous: , Up: Top   [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 files   [Contents][Index]

3.1.1 pg.asd

Location

pg.asd

Systems

pg (system)

Packages

pg-system

Internal Definitions

pg-component (class)


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

3.1.2 pg/md5.lisp

Parent

pg (system)

Location

md5.lisp

Packages

pg-md5

Exported Definitions
Internal Definitions

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

3.1.3 pg/defpackage.lisp

Dependency

md5.lisp (file)

Parent

pg (system)

Location

defpackage.lisp

Packages

postgresql


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

3.1.4 pg/sysdep.lisp

Dependencies
Parent

pg (system)

Location

sysdep.lisp

Internal Definitions

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

3.1.5 pg/meta-queries.lisp

Dependency

defpackage.lisp (file)

Parent

pg (system)

Location

meta-queries.lisp

Exported Definitions
Internal Definitions

pg-describe-table (function)


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

3.1.6 pg/parsers.lisp

Dependency

defpackage.lisp (file)

Parent

pg (system)

Location

parsers.lisp

Exported Definitions

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

Internal Definitions

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

3.1.7 pg/utility.lisp

Dependency

defpackage.lisp (file)

Parent

pg (system)

Location

utility.lisp

Exported Definitions
Internal Definitions

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

3.1.8 pg/lowlevel.lisp

Dependency

defpackage.lisp (file)

Parent

pg (system)

Location

lowlevel.lisp

Internal Definitions

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

3.1.9 pg/pg.lisp

Dependencies
Parent

pg (system)

Location

pg.lisp

Exported Definitions
Internal Definitions

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

3.1.10 pg/large-object.lisp

Dependency

pg.lisp (file)

Parent

pg (system)

Location

large-object.lisp

Exported Definitions
Internal Definitions

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

3.1.11 pg/v2-protocol.lisp

Dependencies
Parent

pg (system)

Location

v2-protocol.lisp

Exported Definitions
Internal Definitions

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

3.1.12 pg/v3-protocol.lisp

Dependencies
Parent

pg (system)

Location

v3-protocol.lisp

Exported Definitions
Internal Definitions

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

4 Packages

Packages are listed by definition order.


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

4.1 pg-system

Source

pg.asd

Use List
Internal Definitions

pg-component (class)


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

4.2 pg-md5

Source

md5.lisp (file)

Use List

common-lisp

Used By List

postgresql

Exported Definitions
Internal Definitions

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

4.3 postgresql

Source

defpackage.lisp (file)

Nickname

pg

Use List
Exported Definitions
Internal Definitions

Next: , Previous: , Up: Top   [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 Exported definitions


Next: , Previous: , Up: Exported definitions   [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 (file)

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


Next: , Previous: , Up: Exported definitions   [Contents][Index]

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

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


Next: , Previous: , Up: Exported definitions   [Contents][Index]

5.1.3 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 (file)

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

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

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

Function: initial-md5-regs ()

Create the initial working state of an MD5 run.

Package

pg-md5

Source

md5.lisp (file)

Function: make-md5-state ()
Package

pg-md5

Source

md5.lisp (file)

Function: md5-state-p OBJECT
Package

pg-md5

Source

md5.lisp (file)

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

Function: md5sum-file PATHNAME

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

Package

pg-md5

Source

md5.lisp (file)

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

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

Function: pg-backend-version CONN

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

Package

postgresql

Source

meta-queries.lisp (file)

Function: pg-client-encoding CONN

Return a string identifying the client encoding.

Package

postgresql

Source

utility.lisp (file)

Setf Expander

(setf pg-client-encoding) (setf expander)

Setf Expander: (setf pg-client-encoding) CONN NEW-ENCODING
Package

postgresql

Source

utility.lisp (file)

Reader

pg-client-encoding (function)

Writer

set-pg-client-encoding (function)

Function: pg-columns CONN TABLE

Return a list of the columns present in TABLE.

Package

postgresql

Source

meta-queries.lisp (file)

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

Function: pg-databases CONN

Return a list of the databases available at this site.

Package

postgresql

Source

meta-queries.lisp (file)

Function: pg-date-style CONN
Package

postgresql

Source

utility.lisp (file)

Setf Expander

(setf pg-date-style) (setf expander)

Setf Expander: (setf pg-date-style) CONN NEW-DATE-STYLE
Package

postgresql

Source

utility.lisp (file)

Reader

pg-date-style (function)

Writer

set-pg-date-style (function)

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

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

Function: pg-tables CONN

Return a list of the tables present in this database.

Package

postgresql

Source

meta-queries.lisp (file)

Function: pglo-close CONNECTION FD
Package

postgresql

Source

large-object.lisp (file)

Function: pglo-create CONNECTION &optional MODESTR
Package

postgresql

Source

large-object.lisp (file)

Function: pglo-export CONNECTION OID FILENAME
Package

postgresql

Source

large-object.lisp (file)

Function: pglo-import CONNECTION FILENAME
Package

postgresql

Source

large-object.lisp (file)

Function: pglo-lseek CONNECTION FD OFFSET WHENCE
Package

postgresql

Source

large-object.lisp (file)

Function: pglo-open CONNECTION OID &optional MODESTR
Package

postgresql

Source

large-object.lisp (file)

Function: pglo-tell CONNECTION FD
Package

postgresql

Source

large-object.lisp (file)

Function: pglo-unlink CONNECTION OID
Package

postgresql

Source

large-object.lisp (file)

Function: pglo-write CONNECTION FD BUF
Package

postgresql

Source

large-object.lisp (file)

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

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


Next: , Previous: , Up: Exported definitions   [Contents][Index]

5.1.4 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 (file)

Methods
Method: pg-bind (CONNECTION pgcon-v3) (PORTAL string) (STATEMENT-NAME string) LIST-OF-TYPES-AND-VALUES
Source

v3-protocol.lisp (file)

Generic Function: pg-close-portal CONNECTION PORTAL

Closes a prepared statement portal

Package

postgresql

Source

pg.lisp (file)

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

v3-protocol.lisp (file)

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

Methods
Method: pg-close-statement (CONNECTION pgcon-v3) (STATEMENT-NAME string)
Source

v3-protocol.lisp (file)

Generic Function: pg-disconnect CONNECTION &key ABORT

Disconnects from the DB

Package

postgresql

Source

pg.lisp (file)

Methods
Method: pg-disconnect (CONNECTION pgcon-v3) &key ABORT
Source

v3-protocol.lisp (file)

Method: pg-disconnect (CONNECTION pgcon-v2) &key ABORT
Source

v2-protocol.lisp (file)

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

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

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

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

Methods
Method: pg-execute (CONNECTION pgcon-v3) (PORTAL string) &optional MAXIMUM-NUMBER-OF-ROWS
Source

v3-protocol.lisp (file)

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

Methods
Method: pg-prepare (CONNECTION pgcon-v3) (STATEMENT-NAME string) (SQL-STATEMENT string) &optional TYPE-OF-PARAMETERS
Source

v3-protocol.lisp (file)

Generic Function: pg-supports-pbe CONNECTION

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

Package

postgresql

Source

pg.lisp (file)

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

v3-protocol.lisp (file)

Method: pg-supports-pbe CONNECTION
Generic Function: pgcon-sql-stream OBJECT
Generic Function: (setf pgcon-sql-stream) NEW-VALUE OBJECT
Package

postgresql

Methods
Method: pgcon-sql-stream (PGCON-V3 pgcon-v3)

automatically generated reader method

Source

v3-protocol.lisp (file)

Method: (setf pgcon-sql-stream) NEW-VALUE (PGCON-V3 pgcon-v3)

automatically generated writer method

Source

v3-protocol.lisp (file)

Generic Function: pglo-read CONNECTION FD BYTES

Read from a large object on file descriptor FD.

Package

postgresql

Source

pg.lisp (file)

Methods
Method: pglo-read (CONNECTION pgcon-v3) FD BYTES
Source

v3-protocol.lisp (file)

Method: pglo-read (CONNECTION pgcon-v2) FD BYTES
Source

v2-protocol.lisp (file)


Next: , Previous: , Up: Exported definitions   [Contents][Index]

5.1.5 Conditions

Condition: authentication-failure ()
Package

postgresql

Source

pg.lisp (file)

Direct superclasses

postgresql-error (condition)

Direct methods

authentication-failure-reason (method)

Direct slots
Slot: reason
Initargs

:reason

Readers

authentication-failure-reason (generic function)

Condition: backend-error ()
Package

postgresql

Source

pg.lisp (file)

Direct superclasses

postgresql-error (condition)

Direct subclasses

error-response (condition)

Direct methods

backend-error-reason (method)

Direct slots
Slot: reason
Initargs

:reason

Readers

backend-error-reason (generic function)

Condition: connection-failure ()
Package

postgresql

Source

pg.lisp (file)

Direct superclasses

postgresql-error (condition)

Direct methods
Direct slots
Slot: host
Initargs

:host

Readers

connection-failure-host (generic function)

Slot: port
Initargs

:port

Readers

connection-failure-port (generic function)

Slot: transport-error
Initargs

:transport-error

Readers

connection-failure-transport-error (generic function)

Condition: postgresql-error ()
Package

postgresql

Source

pg.lisp (file)

Direct superclasses

simple-error (condition)

Direct subclasses
Condition: protocol-error ()
Package

postgresql

Source

pg.lisp (file)

Direct superclasses

postgresql-error (condition)

Direct methods

protocol-error-reason (method)

Direct slots
Slot: reason
Initargs

:reason

Readers

protocol-error-reason (generic function)


Next: , Previous: , Up: Exported definitions   [Contents][Index]

5.1.6 Structures

Structure: md5-state ()
Package

pg-md5

Source

md5.lisp (file)

Direct superclasses

structure-object (structure)

Direct slots
Slot: regs
Type

pg-md5:md5-regs

Initform

(pg-md5:initial-md5-regs)

Readers

md5-state-regs (function)

Writers

(setf md5-state-regs) (function)

Slot: amount
Type

(integer 0 *)

Initform

0

Readers

md5-state-amount (function)

Writers

(setf md5-state-amount) (function)

Slot: block
Type

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

Initform

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

Readers

md5-state-block (function)

Writers

(setf md5-state-block) (function)

Slot: buffer
Type

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

Initform

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

Readers

md5-state-buffer (function)

Writers

(setf md5-state-buffer) (function)

Slot: buffer-index
Type

(integer 0 63)

Initform

0

Readers

md5-state-buffer-index (function)

Writers

(setf md5-state-buffer-index) (function)

Slot: finalized-p
Readers

md5-state-finalized-p (function)

Writers

(setf md5-state-finalized-p) (function)


Previous: , Up: Exported definitions   [Contents][Index]

5.1.7 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 (file)


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

5.2 Internal definitions


Next: , Previous: , Up: Internal definitions   [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 (file)

Constant: +inv_archive+
Package

postgresql

Source

large-object.lisp (file)

Constant: +inv_read+
Package

postgresql

Source

large-object.lisp (file)

Constant: +inv_write+
Package

postgresql

Source

large-object.lisp (file)

Constant: +lo_bufsiz+
Package

postgresql

Source

large-object.lisp (file)

Constant: +max_message_len+
Package

postgresql

Source

pg.lisp (file)

Constant: +md5-magic-a+

Initial value of Register A of the MD5 working state.

Package

pg-md5

Source

md5.lisp (file)

Constant: +md5-magic-b+

Initial value of Register B of the MD5 working state.

Package

pg-md5

Source

md5.lisp (file)

Constant: +md5-magic-c+

Initial value of Register C of the MD5 working state.

Package

pg-md5

Source

md5.lisp (file)

Constant: +md5-magic-d+

Initial value of Register D of the MD5 working state.

Package

pg-md5

Source

md5.lisp (file)

Constant: +namedatalen+
Package

postgresql

Source

pg.lisp (file)

Constant: +sm_database+
Package

postgresql

Source

pg.lisp (file)

Constant: +sm_options+
Package

postgresql

Source

pg.lisp (file)

Constant: +sm_tty+
Package

postgresql

Source

pg.lisp (file)

Constant: +sm_unused+
Package

postgresql

Source

pg.lisp (file)

Constant: +sm_user+
Package

postgresql

Source

pg.lisp (file)

Constant: +startup_krb4_msg+
Package

postgresql

Source

pg.lisp (file)

Constant: +startup_krb5_msg+
Package

postgresql

Source

pg.lisp (file)

Constant: +startup_msg+
Package

postgresql

Source

pg.lisp (file)

Constant: +startup_packet_size+
Package

postgresql

Source

pg.lisp (file)

Constant: +startup_password_msg+
Package

postgresql

Source

pg.lisp (file)


Next: , Previous: , Up: Internal definitions   [Contents][Index]

5.2.2 Special variables

Special Variable: *lo-functions*
Package

postgresql

Source

large-object.lisp (file)

Special Variable: *lo-initialized*
Package

postgresql

Source

large-object.lisp (file)

Special Variable: *old-features*
Package

pg-md5

Source

md5.lisp (file)

Special Variable: *parsers*
Package

postgresql

Source

parsers.lisp (file)

Special Variable: *pg-date-style*
Package

postgresql

Source

pg.lisp (file)

Special Variable: *t*
Package

pg-md5

Source

md5.lisp (file)

Special Variable: *type-parsers*
Package

postgresql

Source

parsers.lisp (file)

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


Next: , Previous: , Up: Internal definitions   [Contents][Index]

5.2.3 Macros

Macro: %sysdep DESC &rest FORMS
Package

postgresql

Source

sysdep.lisp (file)

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

Macro: md5-regs-a REGS
Package

pg-md5

Source

md5.lisp (file)

Macro: md5-regs-b REGS
Package

pg-md5

Source

md5.lisp (file)

Macro: md5-regs-c REGS
Package

pg-md5

Source

md5.lisp (file)

Macro: md5-regs-d REGS
Package

pg-md5

Source

md5.lisp (file)

Macro: with-md5-round (OP BLOCK) &rest CLAUSES
Package

pg-md5

Source

md5.lisp (file)


Next: , Previous: , Up: Internal definitions   [Contents][Index]

5.2.4 Compiler macros

Compiler Macro: mod32+ A B
Package

pg-md5

Source

md5.lisp (file)


Next: , Previous: , Up: Internal definitions   [Contents][Index]

5.2.5 Functions

Function: %flush CONNECTION
Package

postgresql

Source

lowlevel.lisp (file)

Function: %read-bytes STREAM HOWMANY

Reads HOWMANY bytes from the STREAM. Returns the array of

Package

postgresql

Source

lowlevel.lisp (file)

Function: %read-chars STREAM HOWMANY
Package

postgresql

Source

lowlevel.lisp (file)

Function: %read-cstring STREAM MAXBYTES

Read a null-terminated string from CONNECTION.

Package

postgresql

Source

lowlevel.lisp (file)

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

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

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

Function: %send-cstring STREAM STR

Sends a null-terminated string to CONNECTION

Package

postgresql

Source

lowlevel.lisp (file)

Function: %send-net-int STREAM INT BYTES
Package

postgresql

Source

lowlevel.lisp (file)

Function: bitmap-ref/v2 BITMAP REF
Package

postgresql

Source

v2-protocol.lisp (file)

Function: bool-parser STR
Package

postgresql

Source

parsers.lisp (file)

Function: bytea->string DATA
Package

postgresql

Source

parsers.lisp (file)

Function: convert-string-from-bytes BYTES ENCODING
Package

postgresql

Source

sysdep.lisp (file)

Function: convert-string-to-bytes STRING ENCODING
Package

postgresql

Source

sysdep.lisp (file)

Function: copy-md5-state INSTANCE
Package

pg-md5

Source

md5.lisp (file)

Function: copy-pgresult INSTANCE
Package

postgresql

Source

pg.lisp (file)

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

Function: crypt KEY SALT
Package

postgresql

Source

sysdep.lisp (file)

Function: date-parser STR
Package

postgresql

Source

parsers.lisp (file)

Function: do-followup-query CONNECTION

Does the followup of a query

Package

postgresql

Source

v3-protocol.lisp (file)

Function: f ()
Package

pg-md5

Source

md5.lisp (file)

Function: float-parser STR
Package

postgresql

Source

parsers.lisp (file)

Function: g ()
Package

pg-md5

Source

md5.lisp (file)

Function: h ()
Package

pg-md5

Source

md5.lisp (file)

Function: handle-notice CONNECTION
Package

postgresql

Source

v2-protocol.lisp (file)

Function: handle-notice/v3 CONNECTION PACKET
Package

postgresql

Source

v3-protocol.lisp (file)

Function: i ()
Package

pg-md5

Source

md5.lisp (file)

Function: implementation-name-for-encoding ENCODING
Package

postgresql

Source

sysdep.lisp (file)

Function: initialize-parsers CONNECTION
Package

postgresql

Source

parsers.lisp (file)

Function: integer-parser STR
Package

postgresql

Source

parsers.lisp (file)

Function: interval-parser STR
Package

postgresql

Source

parsers.lisp (file)

Function: isodate-parser STR
Package

postgresql

Source

parsers.lisp (file)

Function: lo-init CONNECTION
Package

postgresql

Source

large-object.lisp (file)

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

Function: make-pgresult &key (CONNECTION CONNECTION) (STATUS STATUS) (ATTRIBUTES ATTRIBUTES) (TUPLES TUPLES)
Package

postgresql

Source

pg.lisp (file)

Function: md5-digest STRING &rest STRINGS
Package

postgresql

Source

sysdep.lisp (file)

Function: md5-encode-password USER PASSWORD SALT
Package

postgresql

Source

sysdep.lisp (file)

Function: md5-state-amount INSTANCE
Function: (setf md5-state-amount) VALUE INSTANCE
Package

pg-md5

Source

md5.lisp (file)

Function: md5-state-block INSTANCE
Package

pg-md5

Source

md5.lisp (file)

Function: md5-state-buffer INSTANCE
Package

pg-md5

Source

md5.lisp (file)

Function: md5-state-buffer-index INSTANCE
Function: (setf md5-state-buffer-index) VALUE INSTANCE
Package

pg-md5

Source

md5.lisp (file)

Function: md5-state-finalized-p INSTANCE
Function: (setf md5-state-finalized-p) VALUE INSTANCE
Package

pg-md5

Source

md5.lisp (file)

Function: md5-state-regs INSTANCE
Package

pg-md5

Source

md5.lisp (file)

Function: mod32+ ()
Package

pg-md5

Source

md5.lisp (file)

Function: numeric-parser STR
Package

postgresql

Source

parsers.lisp (file)

Function: parse STR OID
Package

postgresql

Source

parsers.lisp (file)

Function: parse-timestamp STR
Package

postgresql

Source

parsers.lisp (file)

Function: pg-close CONNECTION NAME TYPE
Package

postgresql

Source

v3-protocol.lisp (file)

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

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

Function: pg-describe-table CONN TABLE
Package

postgresql

Source

meta-queries.lisp (file)

Function: pgresult-attributes INSTANCE
Function: (setf pgresult-attributes) VALUE INSTANCE
Package

postgresql

Source

pg.lisp (file)

Function: pgresult-connection INSTANCE
Function: (setf pgresult-connection) VALUE INSTANCE
Package

postgresql

Source

pg.lisp (file)

Function: pgresult-p OBJECT
Package

postgresql

Source

pg.lisp (file)

Function: pgresult-status INSTANCE
Function: (setf pgresult-status) VALUE INSTANCE
Package

postgresql

Source

pg.lisp (file)

Function: pgresult-tuples INSTANCE
Function: (setf pgresult-tuples) VALUE INSTANCE
Package

postgresql

Source

pg.lisp (file)

Function: precise-timestamp-parser STR
Package

postgresql

Source

parsers.lisp (file)

Function: read-and-generate-error-response CONNECTION PACKET
Package

postgresql

Source

v3-protocol.lisp (file)

Function: read-and-handle-notification-response CONNECTION PACKET
Package

postgresql

Source

v3-protocol.lisp (file)

Function: read-attributes/v2 CONNECTION
Package

postgresql

Source

v2-protocol.lisp (file)

Function: read-attributes/v3 PACKET
Package

postgresql

Source

v3-protocol.lisp (file)

Function: read-net-int CONNECTION BYTES
Package

postgresql

Source

lowlevel.lisp (file)

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

Function: read-tuple/v2 CONNECTION ATTRIBUTES
Package

postgresql

Source

v2-protocol.lisp (file)

Function: read-tuple/v3 PACKET ATTRIBUTES
Package

postgresql

Source

v3-protocol.lisp (file)

Function: rol32 ()
Package

pg-md5

Source

md5.lisp (file)

Function: row-parser STR
Package

postgresql

Source

parsers.lisp (file)

Function: send-int CONNECTION INT BYTES
Package

postgresql

Source

lowlevel.lisp (file)

Function: send-octets CONNECTION BUFFER
Package

postgresql

Source

lowlevel.lisp (file)

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

Function: send-string CONNECTION STR &optional PAD-TO
Package

postgresql

Source

lowlevel.lisp (file)

Function: set-pg-client-encoding CONN NEW-ENCODING

Set the client_encoding.

Package

postgresql

Source

utility.lisp (file)

Setf Expander

(setf pg-client-encoding) (setf expander)

Function: set-pg-date-style CONN NEW-DATE-STYLE
Package

postgresql

Source

utility.lisp (file)

Setf Expander

(setf pg-date-style) (setf expander)

Function: socket-connect PORT HOST-NAME
Package

postgresql

Source

sysdep.lisp (file)

Function: text-parser STR
Package

postgresql

Source

parsers.lisp (file)

Function: timestamp-parser STR
Package

postgresql

Source

parsers.lisp (file)


Next: , Previous: , Up: Internal definitions   [Contents][Index]

5.2.6 Generic functions

Generic Function: authentication-failure-reason CONDITION
Package

postgresql

Methods
Method: authentication-failure-reason (CONDITION authentication-failure)
Source

pg.lisp (file)

Generic Function: backend-error-reason CONDITION
Package

postgresql

Methods
Method: backend-error-reason (CONDITION backend-error)
Source

pg.lisp (file)

Generic Function: connection-failure-host CONDITION
Package

postgresql

Methods
Method: connection-failure-host (CONDITION connection-failure)
Source

pg.lisp (file)

Generic Function: connection-failure-port CONDITION
Package

postgresql

Methods
Method: connection-failure-port (CONDITION connection-failure)
Source

pg.lisp (file)

Generic Function: connection-failure-transport-error CONDITION
Package

postgresql

Methods
Method: connection-failure-transport-error (CONDITION connection-failure)
Source

pg.lisp (file)

Generic Function: error-response-code CONDITION
Package

postgresql

Methods
Method: error-response-code (CONDITION error-response)
Source

v3-protocol.lisp (file)

Generic Function: error-response-detail CONDITION
Package

postgresql

Methods
Method: error-response-detail (CONDITION error-response)
Source

v3-protocol.lisp (file)

Generic Function: error-response-file CONDITION
Package

postgresql

Methods
Method: error-response-file (CONDITION error-response)
Source

v3-protocol.lisp (file)

Generic Function: error-response-hint CONDITION
Package

postgresql

Methods
Method: error-response-hint (CONDITION error-response)
Source

v3-protocol.lisp (file)

Generic Function: error-response-line CONDITION
Package

postgresql

Methods
Method: error-response-line (CONDITION error-response)
Source

v3-protocol.lisp (file)

Generic Function: error-response-message CONDITION
Package

postgresql

Methods
Method: error-response-message (CONDITION error-response)
Source

v3-protocol.lisp (file)

Generic Function: error-response-position CONDITION
Package

postgresql

Methods
Method: error-response-position (CONDITION error-response)
Source

v3-protocol.lisp (file)

Generic Function: error-response-routine CONDITION
Package

postgresql

Methods
Method: error-response-routine (CONDITION error-response)
Source

v3-protocol.lisp (file)

Generic Function: error-response-severity CONDITION
Package

postgresql

Methods
Method: error-response-severity (CONDITION error-response)
Source

v3-protocol.lisp (file)

Generic Function: error-response-where CONDITION
Package

postgresql

Methods
Method: error-response-where (CONDITION error-response)
Source

v3-protocol.lisp (file)

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

Methods
Method: fn (CONNECTION pgcon-v3) FN BINARY-RESULT &rest ARGS
Source

v3-protocol.lisp (file)

Method: fn (CONNECTION pgcon-v2) FN INTEGER-RESULT &rest ARGS
Source

v2-protocol.lisp (file)

Generic Function: pg-packet-length OBJECT
Package

postgresql

Methods
Method: pg-packet-length (PG-PACKET pg-packet)

automatically generated reader method

Source

v3-protocol.lisp (file)

Generic Function: pg-packet-type OBJECT
Package

postgresql

Methods
Method: pg-packet-type (PG-PACKET pg-packet)

automatically generated reader method

Source

v3-protocol.lisp (file)

Generic Function: pgcon-binary-p OBJECT
Generic Function: (setf pgcon-binary-p) NEW-VALUE OBJECT
Package

postgresql

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

automatically generated reader method

Source

pg.lisp (file)

Method: (setf pgcon-binary-p) NEW-VALUE (PGCON pgcon)

automatically generated writer method

Source

pg.lisp (file)

Generic Function: pgcon-encoding OBJECT
Generic Function: (setf pgcon-encoding) NEW-VALUE OBJECT
Package

postgresql

Methods
Method: pgcon-encoding (PGCON pgcon)

automatically generated reader method

Source

pg.lisp (file)

Method: (setf pgcon-encoding) NEW-VALUE (PGCON pgcon)

automatically generated writer method

Source

pg.lisp (file)

Generic Function: pgcon-host OBJECT
Generic Function: (setf pgcon-host) NEW-VALUE OBJECT
Package

postgresql

Methods
Method: pgcon-host (PGCON pgcon)

automatically generated reader method

Source

pg.lisp (file)

Method: (setf pgcon-host) NEW-VALUE (PGCON pgcon)

automatically generated writer method

Source

pg.lisp (file)

Generic Function: pgcon-notices OBJECT
Generic Function: (setf pgcon-notices) NEW-VALUE OBJECT
Package

postgresql

Methods
Method: pgcon-notices (PGCON pgcon)

automatically generated reader method

Source

pg.lisp (file)

Method: (setf pgcon-notices) NEW-VALUE (PGCON pgcon)

automatically generated writer method

Source

pg.lisp (file)

Generic Function: pgcon-parameters OBJECT
Generic Function: (setf pgcon-parameters) NEW-VALUE OBJECT
Package

postgresql

Methods
Method: pgcon-parameters (PGCON-V3 pgcon-v3)

automatically generated reader method

Source

v3-protocol.lisp (file)

Method: (setf pgcon-parameters) NEW-VALUE (PGCON-V3 pgcon-v3)

automatically generated writer method

Source

v3-protocol.lisp (file)

Generic Function: pgcon-pid OBJECT
Generic Function: (setf pgcon-pid) NEW-VALUE OBJECT
Package

postgresql

Methods
Method: pgcon-pid (PGCON pgcon)

automatically generated reader method

Source

pg.lisp (file)

Method: (setf pgcon-pid) NEW-VALUE (PGCON pgcon)

automatically generated writer method

Source

pg.lisp (file)

Generic Function: pgcon-port OBJECT
Generic Function: (setf pgcon-port) NEW-VALUE OBJECT
Package

postgresql

Methods
Method: pgcon-port (PGCON pgcon)

automatically generated reader method

Source

pg.lisp (file)

Method: (setf pgcon-port) NEW-VALUE (PGCON pgcon)

automatically generated writer method

Source

pg.lisp (file)

Generic Function: pgcon-secret OBJECT
Generic Function: (setf pgcon-secret) NEW-VALUE OBJECT
Package

postgresql

Methods
Method: pgcon-secret (PGCON pgcon)

automatically generated reader method

Source

pg.lisp (file)

Method: (setf pgcon-secret) NEW-VALUE (PGCON pgcon)

automatically generated writer method

Source

pg.lisp (file)

Generic Function: pgcon-stream OBJECT
Generic Function: (setf pgcon-stream) NEW-VALUE OBJECT
Package

postgresql

Methods
Method: pgcon-stream (PGCON pgcon)

automatically generated reader method

Source

pg.lisp (file)

Method: (setf pgcon-stream) NEW-VALUE (PGCON pgcon)

automatically generated writer method

Source

pg.lisp (file)

Generic Function: protocol-error-reason CONDITION
Package

postgresql

Methods
Method: protocol-error-reason (CONDITION protocol-error)
Source

pg.lisp (file)

Generic Function: read-from-packet PACKET TYPE

Reads an integer from the given PACKET with type TYPE

Package

postgresql

Source

v3-protocol.lisp (file)

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

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

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: Internal definitions   [Contents][Index]

5.2.7 Conditions

Condition: error-response ()
Package

postgresql

Source

v3-protocol.lisp (file)

Direct superclasses

backend-error (condition)

Direct methods
Direct slots
Slot: severity
Initargs

:severity

Readers

error-response-severity (generic function)

Slot: code
Initargs

:code

Readers

error-response-code (generic function)

Slot: message
Initargs

:message

Readers

error-response-message (generic function)

Slot: detail
Initargs

:detail

Readers

error-response-detail (generic function)

Slot: hint
Initargs

:hint

Readers

error-response-hint (generic function)

Slot: position
Initargs

:position

Readers

error-response-position (generic function)

Slot: where
Initargs

:where

Readers

error-response-where (generic function)

Slot: file
Initargs

:file

Readers

error-response-file (generic function)

Slot: line
Initargs

:line

Readers

error-response-line (generic function)

Slot: routine
Initargs

:routine

Readers

error-response-routine (generic function)


Next: , Previous: , Up: Internal definitions   [Contents][Index]

5.2.8 Structures

Structure: pgresult ()
Package

postgresql

Source

pg.lisp (file)

Direct superclasses

structure-object (structure)

Direct slots
Slot: connection
Readers

pgresult-connection (function)

Writers

(setf pgresult-connection) (function)

Slot: status
Readers

pgresult-status (function)

Writers

(setf pgresult-status) (function)

Slot: attributes
Readers

pgresult-attributes (function)

Writers

(setf pgresult-attributes) (function)

Slot: tuples
Readers

pgresult-tuples (function)

Writers

(setf pgresult-tuples) (function)


Next: , Previous: , Up: Internal definitions   [Contents][Index]

5.2.9 Classes

Class: backend-notification ()
Package

postgresql

Source

v3-protocol.lisp (file)

Direct superclasses

standard-object (class)

Direct methods

print-object (method)

Direct slots
Slot: severity
Slot: code
Slot: message
Slot: detail
Slot: hint
Slot: position
Slot: where
Slot: file
Slot: line
Slot: routine
Class: pg-component ()
Package

pg-system

Source

pg.asd

Direct superclasses

cl-source-file (class)

Class: pg-packet ()
Package

postgresql

Source

v3-protocol.lisp (file)

Direct superclasses

standard-object (class)

Direct methods
Direct slots
Slot: type
Type

base-char

Initargs

:type

Readers

pg-packet-type (generic function)

Slot: length
Type

(unsigned-byte 32)

Initargs

:length

Readers

pg-packet-length (generic function)

Slot: data
Type

(array (unsigned-byte 8) *)

Initargs

:data

Slot: position
Type

integer

Initform

0

Slot: connection
Type

postgresql::pgcon-v3

Initargs

:connection

Class: pgcon ()
Package

postgresql

Source

pg.lisp (file)

Direct superclasses

standard-object (class)

Direct subclasses
Direct methods
Direct slots
Slot: stream
Initargs

:stream

Readers

pgcon-stream (generic function)

Writers

(setf pgcon-stream) (generic function)

Slot: host
Initargs

:host

Readers

pgcon-host (generic function)

Writers

(setf pgcon-host) (generic function)

Slot: port
Initargs

:port

Initform

0

Readers

pgcon-port (generic function)

Writers

(setf pgcon-port) (generic function)

Slot: pid
Readers

pgcon-pid (generic function)

Writers

(setf pgcon-pid) (generic function)

Slot: secret
Readers

pgcon-secret (generic function)

Writers

(setf pgcon-secret) (generic function)

Slot: notices
Initform

(list)

Readers

pgcon-notices (generic function)

Writers

(setf pgcon-notices) (generic function)

Slot: binary-p
Readers

pgcon-binary-p (generic function)

Writers

(setf pgcon-binary-p) (generic function)

Slot: encoding
Initargs

:encoding

Readers

pgcon-encoding (generic function)

Writers

(setf pgcon-encoding) (generic function)

Class: pgcon-v2 ()
Package

postgresql

Source

v2-protocol.lisp (file)

Direct superclasses

pgcon (class)

Direct methods
Class: pgcon-v3 ()
Package

postgresql

Source

v3-protocol.lisp (file)

Direct superclasses

pgcon (class)

Direct methods
Direct slots
Slot: parameters
Initform

(list)

Readers

pgcon-parameters (generic function)

Writers

(setf pgcon-parameters) (generic function)

Slot: sql-stream
Type

(or null stream)

Readers

pgcon-sql-stream (generic function)

Writers

(setf pgcon-sql-stream) (generic function)


Previous: , Up: Internal definitions   [Contents][Index]

5.2.10 Types

Type: buffer-index ()
Package

pg-md5

Source

md5.lisp (file)

Type: ub32 ()

Corresponds to the 32bit quantity word of the MD5 Spec

Package

pg-md5

Source

md5.lisp (file)


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

Appendix A Indexes


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

A.1 Concepts

Jump to:   F   L   P  
Index Entry  Section

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

L
Lisp File, pg.asd: The pg<dot>asd file
Lisp File, pg/defpackage.lisp: The pg/defpackage<dot>lisp file
Lisp File, pg/large-object.lisp: The pg/large-object<dot>lisp file
Lisp File, pg/lowlevel.lisp: The pg/lowlevel<dot>lisp file
Lisp File, pg/md5.lisp: The pg/md5<dot>lisp file
Lisp File, pg/meta-queries.lisp: The pg/meta-queries<dot>lisp file
Lisp File, pg/parsers.lisp: The pg/parsers<dot>lisp file
Lisp File, pg/pg.lisp: The pg/pg<dot>lisp file
Lisp File, pg/sysdep.lisp: The pg/sysdep<dot>lisp file
Lisp File, pg/utility.lisp: The pg/utility<dot>lisp file
Lisp File, pg/v2-protocol.lisp: The pg/v2-protocol<dot>lisp file
Lisp File, pg/v3-protocol.lisp: The pg/v3-protocol<dot>lisp file

P
pg.asd: The pg<dot>asd file
pg/defpackage.lisp: The pg/defpackage<dot>lisp file
pg/large-object.lisp: The pg/large-object<dot>lisp file
pg/lowlevel.lisp: The pg/lowlevel<dot>lisp file
pg/md5.lisp: The pg/md5<dot>lisp file
pg/meta-queries.lisp: The pg/meta-queries<dot>lisp file
pg/parsers.lisp: The pg/parsers<dot>lisp file
pg/pg.lisp: The pg/pg<dot>lisp file
pg/sysdep.lisp: The pg/sysdep<dot>lisp file
pg/utility.lisp: The pg/utility<dot>lisp file
pg/v2-protocol.lisp: The pg/v2-protocol<dot>lisp file
pg/v3-protocol.lisp: The pg/v3-protocol<dot>lisp file

Jump to:   F   L   P  

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: Internal functions
%read-bytes: Internal functions
%read-chars: Internal functions
%read-cstring: Internal functions
%read-net-int16: Internal functions
%read-net-int32: Internal functions
%read-net-int8: Internal functions
%send-cstring: Internal functions
%send-net-int: Internal functions
%sysdep: Internal macros

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

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

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

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

D
date-parser: Internal functions
do-followup-query: Internal functions

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

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

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

H
h: Internal functions
handle-notice: Internal functions
handle-notice/v3: Internal functions

I
i: Internal functions
implementation-name-for-encoding: Internal functions
initial-md5-regs: Exported functions
initialize-parsers: Internal functions
integer-parser: Internal functions
interval-parser: Internal functions
isodate-parser: Internal functions

L
lo-init: Internal functions
lookup-type: Internal functions

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

N
numeric-parser: Internal functions

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

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

S
send-int: Internal functions
send-octets: Internal functions
send-packet: Internal functions
send-string: Internal functions
set-pg-client-encoding: Internal functions
set-pg-date-style: Internal functions
Setf Expander, (setf pg-client-encoding): Exported functions
Setf Expander, (setf pg-date-style): Exported functions
socket-connect: Internal functions

T
text-parser: Internal functions
timestamp-parser: Internal functions

U
update-md5-block: Exported functions
update-md5-state: Exported functions

W
with-md5-round: Internal macros
with-pg-connection: Exported macros
with-pg-transaction: Exported 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*: Internal special variables
*lo-initialized*: Internal special variables
*old-features*: Internal special variables
*parsers*: Internal special variables
*pg-client-encoding*: Exported special variables
*pg-date-style*: Internal special variables
*pg-disable-type-coercion*: Exported special variables
*t*: Internal special variables
*type-parsers*: Internal special variables
*type-to-oid*: Internal special variables

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

A
amount: Exported structures
attributes: Internal structures

B
binary-p: Internal classes
block: Exported structures
buffer: Exported structures
buffer-index: Exported structures

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

D
data: Internal classes
detail: Internal conditions
detail: Internal classes

E
encoding: Internal classes

F
file: Internal conditions
file: Internal classes
finalized-p: Exported structures

H
hint: Internal conditions
hint: Internal classes
host: Exported conditions
host: Internal classes

L
length: Internal classes
line: Internal conditions
line: Internal classes

M
message: Internal conditions
message: Internal classes

N
notices: Internal classes

P
parameters: Internal classes
pid: Internal classes
port: Exported conditions
port: Internal classes
position: Internal conditions
position: Internal classes
position: Internal classes

R
reason: Exported conditions
reason: Exported conditions
reason: Exported conditions
regs: Exported structures
routine: Internal conditions
routine: Internal classes

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

T
transport-error: Exported conditions
tuples: Internal structures
type: Internal classes

W
where: Internal conditions
where: Internal 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   E   M   P   S   T   U  
Index Entry  Section

A
authentication-failure: Exported conditions

B
backend-error: Exported conditions
backend-notification: Internal classes
buffer-index: Internal types

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

E
error-response: Internal conditions

M
md5-regs: Exported types
md5-state: Exported structures

P
Package, pg-md5: The pg-md5 package
Package, pg-system: The pg-system package
Package, postgresql: The postgresql package
pg: The pg system
pg-component: Internal classes
pg-md5: The pg-md5 package
pg-packet: Internal classes
pg-system: The pg-system package
pgcon: Internal classes
pgcon-v2: Internal classes
pgcon-v3: Internal classes
pgresult: Internal structures
postgresql: The postgresql package
postgresql-error: Exported conditions
protocol-error: Exported conditions

S
Structure, md5-state: Exported structures
Structure, pgresult: Internal structures
System, pg: The pg system

T
Type, buffer-index: Internal types
Type, md5-regs: Exported types
Type, ub32: Internal types

U
ub32: Internal types

Jump to:   A   B   C   E   M   P   S   T   U