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 Feb 26 17:33:08 2024 GMT+0.

Table of Contents


1 Introduction


2 Systems

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


2.1 pg

Author

Eric Marsden

Version

0.24

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

pg.asd.

Child Components

3 Files

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


3.1 Lisp


3.1.1 pg/pg.asd

Source

pg.asd.

Parent Component

pg (system).

ASDF Systems

pg.

Packages

pg-system.

Internals

pg-component (class).


3.1.2 pg/md5.lisp

Source

pg.asd.

Parent Component

pg (system).

Packages

pg-md5.

Public Interface
Internals

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

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

3.1.7 pg/utility.lisp

Dependency

defpackage.lisp (file).

Source

pg.asd.

Parent Component

pg (system).

Public Interface
Internals

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

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

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.


4.1 postgresql

Source

defpackage.lisp.

Nickname

pg

Use List
Public Interface
Internals

4.2 pg-system

Source

pg.asd.

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

pg-component (class).


4.3 pg-md5

Source

md5.lisp.

Use List

common-lisp.

Used By List

postgresql.

Public Interface
Internals

5 Definitions

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


5.1 Public Interface


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 (block buffer offset)

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 (block buffer offset)

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 (block buffer offset)

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

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 (regs 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 (state sequence &key start end)

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.


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


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


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.


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.


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 (from from-offset count buffer buffer-offset)

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 (x y z)
Package

pg-md5.

Source

md5.lisp.

Function: float-parser (str)
Package

postgresql.

Source

parsers.lisp.

Function: g (x y z)
Package

pg-md5.

Source

md5.lisp.

Function: h (x y z)
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 (x y z)
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+ (a b)
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 (a s)
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.


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

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.


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


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


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


A.1 Concepts


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


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


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