Submit
Path:
~
/
/
proc
/
thread-self
/
root
/
opt
/
alt
/
postgresql11
/
usr
/
share
/
doc
/
alt-postgresql11-9.2.24
/
html
/
File Content:
release-8-3.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >Release 8.3</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REV="MADE" HREF="mailto:pgsql-docs@postgresql.org"><LINK REL="HOME" TITLE="PostgreSQL 9.2.24 Documentation" HREF="index.html"><LINK REL="UP" TITLE="Release Notes" HREF="release.html"><LINK REL="PREVIOUS" TITLE="Release 8.3.1" HREF="release-8-3-1.html"><LINK REL="NEXT" TITLE="Release 8.2.23" HREF="release-8-2-23.html"><LINK REL="STYLESHEET" TYPE="text/css" HREF="stylesheet.css"><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" CONTENT="2017-11-06T22:43:11"></HEAD ><BODY CLASS="SECT1" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="5" ALIGN="center" VALIGN="bottom" ><A HREF="index.html" >PostgreSQL 9.2.24 Documentation</A ></TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A TITLE="Release 8.3.1" HREF="release-8-3-1.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A HREF="release.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="60%" ALIGN="center" VALIGN="bottom" >Appendix E. Release Notes</TD ><TD WIDTH="20%" ALIGN="right" VALIGN="top" ><A TITLE="Release 8.2.23" HREF="release-8-2-23.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="RELEASE-8-3" >E.121. Release 8.3</A ></H1 ><DIV CLASS="FORMALPARA" ><P ><B >Release date: </B >2008-02-04</P ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="AEN131333" >E.121.1. Overview</A ></H2 ><P > With significant new functionality and performance enhancements, this release represents a major leap forward for <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN >. This was made possible by a growing community that has dramatically accelerated the pace of development. This release adds the following major features: </P ><P ></P ><UL ><LI ><P > Full text search is integrated into the core database system </P ></LI ><LI ><P > Support for the SQL/XML standard, including new operators and an <TT CLASS="TYPE" >XML</TT > data type </P ></LI ><LI ><P > Enumerated data types (<TT CLASS="TYPE" >ENUM</TT >) </P ></LI ><LI ><P > Arrays of composite types </P ></LI ><LI ><P > Universally Unique Identifier (<TT CLASS="TYPE" >UUID</TT >) data type </P ></LI ><LI ><P > Add control over whether <TT CLASS="LITERAL" >NULL</TT >s sort first or last </P ></LI ><LI ><P > Updatable cursors </P ></LI ><LI ><P > Server configuration parameters can now be set on a per-function basis </P ></LI ><LI ><P > User-defined types can now have type modifiers </P ></LI ><LI ><P > Automatically re-plan cached queries when table definitions change or statistics are updated </P ></LI ><LI ><P > Numerous improvements in logging and statistics collection </P ></LI ><LI ><P > Support Security Service Provider Interface (<ACRONYM CLASS="ACRONYM" >SSPI</ACRONYM >) for authentication on Windows </P ></LI ><LI ><P > Support multiple concurrent autovacuum processes, and other autovacuum improvements </P ></LI ><LI ><P > Allow the whole <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > distribution to be compiled with <SPAN CLASS="PRODUCTNAME" >Microsoft Visual C++</SPAN > </P ></LI ></UL ><P > Major performance improvements are listed below. Most of these enhancements are automatic and do not require user changes or tuning: </P ><P ></P ><UL ><LI ><P > Asynchronous commit delays writes to WAL during transaction commit </P ></LI ><LI ><P > Checkpoint writes can be spread over a longer time period to smooth the I/O spike during each checkpoint </P ></LI ><LI ><P > Heap-Only Tuples (<ACRONYM CLASS="ACRONYM" >HOT</ACRONYM >) accelerate space reuse for most <TT CLASS="COMMAND" >UPDATE</TT >s and <TT CLASS="COMMAND" >DELETE</TT >s </P ></LI ><LI ><P > Just-in-time background writer strategy improves disk write efficiency </P ></LI ><LI ><P > Using non-persistent transaction IDs for read-only transactions reduces overhead and <TT CLASS="COMMAND" >VACUUM</TT > requirements </P ></LI ><LI ><P > Per-field and per-row storage overhead has been reduced </P ></LI ><LI ><P > Large sequential scans no longer force out frequently used cached pages </P ></LI ><LI ><P > Concurrent large sequential scans can now share disk reads </P ></LI ><LI ><P > <TT CLASS="LITERAL" >ORDER BY ... LIMIT</TT > can be done without sorting </P ></LI ></UL ><P > The above items are explained in more detail in the sections below. </P ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="AEN131399" >E.121.2. Migration to Version 8.3</A ></H2 ><P > A dump/restore using <SPAN CLASS="APPLICATION" >pg_dump</SPAN > is required for those wishing to migrate data from any previous release. </P ><P > Observe the following incompatibilities: </P ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN131404" >E.121.2.1. General</A ></H3 ><P ></P ><UL ><LI ><P > Non-character data types are no longer automatically cast to <TT CLASS="TYPE" >TEXT</TT > (Peter, Tom) </P ><P > Previously, if a non-character value was supplied to an operator or function that requires <TT CLASS="TYPE" >text</TT > input, it was automatically cast to <TT CLASS="TYPE" >text</TT >, for most (though not all) built-in data types. This no longer happens: an explicit cast to <TT CLASS="TYPE" >text</TT > is now required for all non-character-string types. For example, these expressions formerly worked: </P><PRE CLASS="PROGRAMLISTING" >substr(current_date, 1, 4) 23 LIKE '2%'</PRE ><P> but will now draw <SPAN CLASS="QUOTE" >"function does not exist"</SPAN > and <SPAN CLASS="QUOTE" >"operator does not exist"</SPAN > errors respectively. Use an explicit cast instead: </P><PRE CLASS="PROGRAMLISTING" >substr(current_date::text, 1, 4) 23::text LIKE '2%'</PRE ><P> (Of course, you can use the more verbose <TT CLASS="LITERAL" >CAST()</TT > syntax too.) The reason for the change is that these automatic casts too often caused surprising behavior. An example is that in previous releases, this expression was accepted but did not do what was expected: </P><PRE CLASS="PROGRAMLISTING" >current_date < 2017-11-17</PRE ><P> This is actually comparing a date to an integer, which should be (and now is) rejected — but in the presence of automatic casts both sides were cast to <TT CLASS="TYPE" >text</TT > and a textual comparison was done, because the <TT CLASS="LITERAL" >text < text</TT > operator was able to match the expression when no other <TT CLASS="LITERAL" ><</TT > operator could. </P ><P > Types <TT CLASS="TYPE" >char(<TT CLASS="REPLACEABLE" ><I >n</I ></TT >)</TT > and <TT CLASS="TYPE" >varchar(<TT CLASS="REPLACEABLE" ><I >n</I ></TT >)</TT > still cast to <TT CLASS="TYPE" >text</TT > automatically. Also, automatic casting to <TT CLASS="TYPE" >text</TT > still works for inputs to the concatenation (<TT CLASS="LITERAL" >||</TT >) operator, so long as least one input is a character-string type. </P ></LI ><LI ><P > Full text search features from <TT CLASS="FILENAME" >contrib/tsearch2</TT > have been moved into the core server, with some minor syntax changes </P ><P > <TT CLASS="FILENAME" >contrib/tsearch2</TT > now contains a compatibility interface. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >ARRAY(SELECT ...)</TT >, where the <TT CLASS="COMMAND" >SELECT</TT > returns no rows, now returns an empty array, rather than NULL (Tom) </P ></LI ><LI ><P > The array type name for a base data type is no longer always the base type's name with an underscore prefix </P ><P > The old naming convention is still honored when possible, but application code should no longer depend on it. Instead use the new <TT CLASS="LITERAL" >pg_type.typarray</TT > column to identify the array data type associated with a given type. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >ORDER BY ... USING</TT > <TT CLASS="REPLACEABLE" ><I >operator</I ></TT > must now use a less-than or greater-than <TT CLASS="REPLACEABLE" ><I >operator</I ></TT > that is defined in a btree operator class </P ><P > This restriction was added to prevent inconsistent results. </P ></LI ><LI ><P > <TT CLASS="COMMAND" >SET LOCAL</TT > changes now persist until the end of the outermost transaction, unless rolled back (Tom) </P ><P > Previously <TT CLASS="COMMAND" >SET LOCAL</TT >'s effects were lost after subtransaction commit (<TT CLASS="COMMAND" >RELEASE SAVEPOINT</TT > or exit from a PL/pgSQL exception block). </P ></LI ><LI ><P > Commands rejected in transaction blocks are now also rejected in multiple-statement query strings (Tom) </P ><P > For example, <TT CLASS="LITERAL" >"BEGIN; DROP DATABASE; COMMIT"</TT > will now be rejected even if submitted as a single query message. </P ></LI ><LI ><P > <TT CLASS="COMMAND" >ROLLBACK</TT > outside a transaction block now issues <TT CLASS="LITERAL" >NOTICE</TT > instead of <TT CLASS="LITERAL" >WARNING</TT > (Bruce) </P ></LI ><LI ><P > Prevent <TT CLASS="COMMAND" >NOTIFY</TT >/<TT CLASS="COMMAND" >LISTEN</TT >/<TT CLASS="COMMAND" >UNLISTEN</TT > from accepting schema-qualified names (Bruce) </P ><P > Formerly, these commands accepted <TT CLASS="LITERAL" >schema.relation</TT > but ignored the schema part, which was confusing. </P ></LI ><LI ><P > <TT CLASS="COMMAND" >ALTER SEQUENCE</TT > no longer affects the sequence's <CODE CLASS="FUNCTION" >currval()</CODE > state (Tom) </P ></LI ><LI ><P > Foreign keys now must match indexable conditions for cross-data-type references (Tom) </P ><P > This improves semantic consistency and helps avoid performance problems. </P ></LI ><LI ><P > Restrict object size functions to users who have reasonable permissions to view such information (Tom) </P ><P > For example, <CODE CLASS="FUNCTION" >pg_database_size()</CODE > now requires <TT CLASS="LITERAL" >CONNECT</TT > permission, which is granted to everyone by default. <CODE CLASS="FUNCTION" >pg_tablespace_size()</CODE > requires <TT CLASS="LITERAL" >CREATE</TT > permission in the tablespace, or is allowed if the tablespace is the default tablespace for the database. </P ></LI ><LI ><P > Remove the undocumented <TT CLASS="LITERAL" >!!=</TT > (not in) operator (Tom) </P ><P > <TT CLASS="LITERAL" >NOT IN (SELECT ...)</TT > is the proper way to perform this operation. </P ></LI ><LI ><P > Internal hashing functions are now more uniformly-distributed (Tom) </P ><P > If application code was computing and storing hash values using internal <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > hashing functions, the hash values must be regenerated. </P ></LI ><LI ><P > C-code conventions for handling variable-length data values have changed (Greg Stark, Tom) </P ><P > The new <CODE CLASS="FUNCTION" >SET_VARSIZE()</CODE > macro <SPAN CLASS="emphasis" ><I CLASS="EMPHASIS" >must</I ></SPAN > be used to set the length of generated <TT CLASS="TYPE" >varlena</TT > values. Also, it might be necessary to expand (<SPAN CLASS="QUOTE" >"de-TOAST"</SPAN >) input values in more cases. </P ></LI ><LI ><P > Continuous archiving no longer reports each successful archive operation to the server logs unless <TT CLASS="LITERAL" >DEBUG</TT > level is used (Simon) </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN131505" >E.121.2.2. Configuration Parameters</A ></H3 ><P ></P ><UL ><LI ><P > Numerous changes in administrative server parameters </P ><P > <TT CLASS="VARNAME" >bgwriter_lru_percent</TT >, <TT CLASS="VARNAME" >bgwriter_all_percent</TT >, <TT CLASS="VARNAME" >bgwriter_all_maxpages</TT >, <TT CLASS="VARNAME" >stats_start_collector</TT >, and <TT CLASS="VARNAME" >stats_reset_on_server_start</TT > are removed. <TT CLASS="VARNAME" >redirect_stderr</TT > is renamed to <TT CLASS="VARNAME" >logging_collector</TT >. <TT CLASS="VARNAME" >stats_command_string</TT > is renamed to <TT CLASS="VARNAME" >track_activities</TT >. <TT CLASS="VARNAME" >stats_block_level</TT > and <TT CLASS="VARNAME" >stats_row_level</TT > are merged into <TT CLASS="VARNAME" >track_counts</TT >. A new boolean configuration parameter, <TT CLASS="VARNAME" >archive_mode</TT >, controls archiving. Autovacuum's default settings have changed. </P ></LI ><LI ><P > Remove <TT CLASS="VARNAME" >stats_start_collector</TT > parameter (Tom) </P ><P > We now always start the collector process, unless <ACRONYM CLASS="ACRONYM" >UDP</ACRONYM > socket creation fails. </P ></LI ><LI ><P > Remove <TT CLASS="VARNAME" >stats_reset_on_server_start</TT > parameter (Tom) </P ><P > This was removed because <CODE CLASS="FUNCTION" >pg_stat_reset()</CODE > can be used for this purpose. </P ></LI ><LI ><P > Commenting out a parameter in <TT CLASS="FILENAME" >postgresql.conf</TT > now causes it to revert to its default value (Joachim Wieland) </P ><P > Previously, commenting out an entry left the parameter's value unchanged until the next server restart. </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN131538" >E.121.2.3. Character Encodings</A ></H3 ><P ></P ><UL ><LI ><P > Add more checks for invalidly-encoded data (Andrew) </P ><P > This change plugs some holes that existed in literal backslash escape string processing and <TT CLASS="COMMAND" >COPY</TT > escape processing. Now the de-escaped string is rechecked to see if the result created an invalid multi-byte character. </P ></LI ><LI ><P > Disallow database encodings that are inconsistent with the server's locale setting (Tom) </P ><P > On most platforms, <TT CLASS="LITERAL" >C</TT > locale is the only locale that will work with any database encoding. Other locale settings imply a specific encoding and will misbehave if the database encoding is something different. (Typical symptoms include bogus textual sort order and wrong results from <CODE CLASS="FUNCTION" >upper()</CODE > or <CODE CLASS="FUNCTION" >lower()</CODE >.) The server now rejects attempts to create databases that have an incompatible encoding. </P ></LI ><LI ><P > Ensure that <CODE CLASS="FUNCTION" >chr()</CODE > cannot create invalidly-encoded values (Andrew) </P ><P > In UTF8-encoded databases the argument of <CODE CLASS="FUNCTION" >chr()</CODE > is now treated as a Unicode code point. In other multi-byte encodings <CODE CLASS="FUNCTION" >chr()</CODE >'s argument must designate a 7-bit ASCII character. Zero is no longer accepted. <CODE CLASS="FUNCTION" >ascii()</CODE > has been adjusted to match. </P ></LI ><LI ><P > Adjust <CODE CLASS="FUNCTION" >convert()</CODE > behavior to ensure encoding validity (Andrew) </P ><P > The two argument form of <CODE CLASS="FUNCTION" >convert()</CODE > has been removed. The three argument form now takes a <TT CLASS="TYPE" >bytea</TT > first argument and returns a <TT CLASS="TYPE" >bytea</TT >. To cover the loss of functionality, three new functions have been added: </P ><P ></P ><UL ><LI ><P > <CODE CLASS="FUNCTION" >convert_from(bytea, name)</CODE > returns <TT CLASS="TYPE" >text</TT > — converts the first argument from the named encoding to the database encoding </P ></LI ><LI ><P > <CODE CLASS="FUNCTION" >convert_to(text, name)</CODE > returns <TT CLASS="TYPE" >bytea</TT > — converts the first argument from the database encoding to the named encoding </P ></LI ><LI ><P > <CODE CLASS="FUNCTION" >length(bytea, name)</CODE > returns <TT CLASS="TYPE" >integer</TT > — gives the length of the first argument in characters in the named encoding </P ></LI ></UL ></LI ><LI ><P > Remove <TT CLASS="LITERAL" >convert(argument USING conversion_name)</TT > (Andrew) </P ><P > Its behavior did not match the SQL standard. </P ></LI ><LI ><P > Make JOHAB encoding client-only (Tatsuo) </P ><P > JOHAB is not safe as a server-side encoding. </P ></LI ></UL ></DIV ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="AEN131585" >E.121.3. Changes</A ></H2 ><P > Below you will find a detailed account of the changes between <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > 8.3 and the previous major release. </P ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN131589" >E.121.3.1. Performance</A ></H3 ><P ></P ><UL ><LI ><P > Asynchronous commit delays writes to WAL during transaction commit (Simon) </P ><P > This feature dramatically increases performance for short data-modifying transactions. The disadvantage is that because disk writes are delayed, if the database or operating system crashes before data is written to the disk, committed data will be lost. This feature is useful for applications that can accept some data loss. Unlike turning off <TT CLASS="VARNAME" >fsync</TT >, using asynchronous commit does not put database consistency at risk; the worst case is that after a crash the last few reportedly-committed transactions might not be committed after all. This feature is enabled by turning off <TT CLASS="VARNAME" >synchronous_commit</TT > (which can be done per-session or per-transaction, if some transactions are critical and others are not). <TT CLASS="VARNAME" >wal_writer_delay</TT > can be adjusted to control the maximum delay before transactions actually reach disk. </P ></LI ><LI ><P > Checkpoint writes can be spread over a longer time period to smooth the I/O spike during each checkpoint (Itagaki Takahiro and Heikki Linnakangas) </P ><P > Previously all modified buffers were forced to disk as quickly as possible during a checkpoint, causing an I/O spike that decreased server performance. This new approach spreads out disk writes during checkpoints, reducing peak I/O usage. (User-requested and shutdown checkpoints are still written as quickly as possible.) </P ></LI ><LI ><P > Heap-Only Tuples (<ACRONYM CLASS="ACRONYM" >HOT</ACRONYM >) accelerate space reuse for most <TT CLASS="COMMAND" >UPDATE</TT >s and <TT CLASS="COMMAND" >DELETE</TT >s (Pavan Deolasee, with ideas from many others) </P ><P > <TT CLASS="COMMAND" >UPDATE</TT >s and <TT CLASS="COMMAND" >DELETE</TT >s leave dead tuples behind, as do failed <TT CLASS="COMMAND" >INSERT</TT >s. Previously only <TT CLASS="COMMAND" >VACUUM</TT > could reclaim space taken by dead tuples. With <ACRONYM CLASS="ACRONYM" >HOT</ACRONYM > dead tuple space can be automatically reclaimed at the time of <TT CLASS="COMMAND" >INSERT</TT > or <TT CLASS="COMMAND" >UPDATE</TT > if no changes are made to indexed columns. This allows for more consistent performance. Also, <ACRONYM CLASS="ACRONYM" >HOT</ACRONYM > avoids adding duplicate index entries. </P ></LI ><LI ><P > Just-in-time background writer strategy improves disk write efficiency (Greg Smith, Itagaki Takahiro) </P ><P > This greatly reduces the need for manual tuning of the background writer. </P ></LI ><LI ><P > Per-field and per-row storage overhead have been reduced (Greg Stark, Heikki Linnakangas) </P ><P > Variable-length data types with data values less than 128 bytes long will see a storage decrease of 3 to 6 bytes. For example, two adjacent <TT CLASS="TYPE" >char(1)</TT > fields now use 4 bytes instead of 16. Row headers are also 4 bytes shorter than before. </P ></LI ><LI ><P > Using non-persistent transaction IDs for read-only transactions reduces overhead and <TT CLASS="COMMAND" >VACUUM</TT > requirements (Florian Pflug) </P ><P > Non-persistent transaction IDs do not increment the global transaction counter. Therefore, they reduce the load on <TT CLASS="STRUCTNAME" >pg_clog</TT > and increase the time between forced vacuums to prevent transaction ID wraparound. Other performance improvements were also made that should improve concurrency. </P ></LI ><LI ><P > Avoid incrementing the command counter after a read-only command (Tom) </P ><P > There was formerly a hard limit of 2<SUP >32</SUP > (4 billion) commands per transaction. Now only commands that actually changed the database count, so while this limit still exists, it should be significantly less annoying. </P ></LI ><LI ><P > Create a dedicated <ACRONYM CLASS="ACRONYM" >WAL</ACRONYM > writer process to off-load work from backends (Simon) </P ></LI ><LI ><P > Skip unnecessary WAL writes for <TT CLASS="COMMAND" >CLUSTER</TT > and <TT CLASS="COMMAND" >COPY</TT > (Simon) </P ><P > Unless WAL archiving is enabled, the system now avoids WAL writes for <TT CLASS="COMMAND" >CLUSTER</TT > and just <CODE CLASS="FUNCTION" >fsync()</CODE >s the table at the end of the command. It also does the same for <TT CLASS="COMMAND" >COPY</TT > if the table was created in the same transaction. </P ></LI ><LI ><P > Large sequential scans no longer force out frequently used cached pages (Simon, Heikki, Tom) </P ></LI ><LI ><P > Concurrent large sequential scans can now share disk reads (Jeff Davis) </P ><P > This is accomplished by starting the new sequential scan in the middle of the table (where another sequential scan is already in-progress) and wrapping around to the beginning to finish. This can affect the order of returned rows in a query that does not specify <TT CLASS="LITERAL" >ORDER BY</TT >. The <TT CLASS="VARNAME" >synchronize_seqscans</TT > configuration parameter can be used to disable this if necessary. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >ORDER BY ... LIMIT</TT > can be done without sorting (Greg Stark) </P ><P > This is done by sequentially scanning the table and tracking just the <SPAN CLASS="QUOTE" >"top N"</SPAN > candidate rows, rather than performing a full sort of the entire table. This is useful when there is no matching index and the <TT CLASS="LITERAL" >LIMIT</TT > is not large. </P ></LI ><LI ><P > Put a rate limit on messages sent to the statistics collector by backends (Tom) </P ><P > This reduces overhead for short transactions, but might sometimes increase the delay before statistics are tallied. </P ></LI ><LI ><P > Improve hash join performance for cases with many NULLs (Tom) </P ></LI ><LI ><P > Speed up operator lookup for cases with non-exact datatype matches (Tom) </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN131662" >E.121.3.2. Server</A ></H3 ><P ></P ><UL ><LI ><P > Autovacuum is now enabled by default (Alvaro) </P ><P > Several changes were made to eliminate disadvantages of having autovacuum enabled, thereby justifying the change in default. Several other autovacuum parameter defaults were also modified. </P ></LI ><LI ><P > Support multiple concurrent autovacuum processes (Alvaro, Itagaki Takahiro) </P ><P > This allows multiple vacuums to run concurrently. This prevents vacuuming of a large table from delaying vacuuming of smaller tables. </P ></LI ><LI ><P > Automatically re-plan cached queries when table definitions change or statistics are updated (Tom) </P ><P > Previously PL/pgSQL functions that referenced temporary tables would fail if the temporary table was dropped and recreated between function invocations, unless <TT CLASS="LITERAL" >EXECUTE</TT > was used. This improvement fixes that problem and many related issues. </P ></LI ><LI ><P > Add a <TT CLASS="VARNAME" >temp_tablespaces</TT > parameter to control the tablespaces for temporary tables and files (Jaime Casanova, Albert Cervera, Bernd Helmle) </P ><P > This parameter defines a list of tablespaces to be used. This enables spreading the I/O load across multiple tablespaces. A random tablespace is chosen each time a temporary object is created. Temporary files are no longer stored in per-database <TT CLASS="FILENAME" >pgsql_tmp/</TT > directories but in per-tablespace directories. </P ></LI ><LI ><P > Place temporary tables' TOAST tables in special schemas named <TT CLASS="LITERAL" >pg_toast_temp_<TT CLASS="REPLACEABLE" ><I >nnn</I ></TT ></TT > (Tom) </P ><P > This allows low-level code to recognize these tables as temporary, which enables various optimizations such as not WAL-logging changes and using local rather than shared buffers for access. This also fixes a bug wherein backends unexpectedly held open file references to temporary TOAST tables. </P ></LI ><LI ><P > Fix problem that a constant flow of new connection requests could indefinitely delay the postmaster from completing a shutdown or a crash restart (Tom) </P ></LI ><LI ><P > Guard against a very-low-probability data loss scenario by preventing re-use of a deleted table's relfilenode until after the next checkpoint (Heikki) </P ></LI ><LI ><P > Fix <TT CLASS="COMMAND" >CREATE CONSTRAINT TRIGGER</TT > to convert old-style foreign key trigger definitions into regular foreign key constraints (Tom) </P ><P > This will ease porting of foreign key constraints carried forward from pre-7.3 databases, if they were never converted using <TT CLASS="FILENAME" >contrib/adddepend</TT >. </P ></LI ><LI ><P > Fix <TT CLASS="LITERAL" >DEFAULT NULL</TT > to override inherited defaults (Tom) </P ><P > <TT CLASS="LITERAL" >DEFAULT NULL</TT > was formerly considered a noise phrase, but it should (and now does) override non-null defaults that would otherwise be inherited from a parent table or domain. </P ></LI ><LI ><P > Add new encodings EUC_JIS_2004 and SHIFT_JIS_2004 (Tatsuo) </P ><P > These new encodings can be converted to and from UTF-8. </P ></LI ><LI ><P > Change server startup log message from <SPAN CLASS="QUOTE" >"database system is ready"</SPAN > to <SPAN CLASS="QUOTE" >"database system is ready to accept connections"</SPAN >, and adjust its timing </P ><P > The message now appears only when the postmaster is really ready to accept connections. </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN131707" >E.121.3.3. Monitoring</A ></H3 ><P ></P ><UL ><LI ><P > Add <TT CLASS="VARNAME" >log_autovacuum_min_duration</TT > parameter to support configurable logging of autovacuum activity (Simon, Alvaro) </P ></LI ><LI ><P > Add <TT CLASS="VARNAME" >log_lock_waits</TT > parameter to log lock waiting (Simon) </P ></LI ><LI ><P > Add <TT CLASS="VARNAME" >log_temp_files</TT > parameter to log temporary file usage (Bill Moran) </P ></LI ><LI ><P > Add <TT CLASS="VARNAME" >log_checkpoints</TT > parameter to improve logging of checkpoints (Greg Smith, Heikki) </P ></LI ><LI ><P > <TT CLASS="VARNAME" >log_line_prefix</TT > now supports <TT CLASS="LITERAL" >%s</TT > and <TT CLASS="LITERAL" >%c</TT > escapes in all processes (Andrew) </P ><P > Previously these escapes worked only for user sessions, not for background database processes. </P ></LI ><LI ><P > Add <TT CLASS="VARNAME" >log_restartpoints</TT > to control logging of point-in-time recovery restart points (Simon) </P ></LI ><LI ><P > Last transaction end time is now logged at end of recovery and at each logged restart point (Simon) </P ></LI ><LI ><P > Autovacuum now reports its activity start time in <TT CLASS="LITERAL" >pg_stat_activity</TT > (Tom) </P ></LI ><LI ><P > Allow server log output in comma-separated value (CSV) format (Arul Shaji, Greg Smith, Andrew Dunstan) </P ><P > CSV-format log files can easily be loaded into a database table for subsequent analysis. </P ></LI ><LI ><P > Use PostgreSQL-supplied timezone support for formatting timestamps displayed in the server log (Tom) </P ><P > This avoids Windows-specific problems with localized time zone names that are in the wrong encoding. There is a new <TT CLASS="VARNAME" >log_timezone</TT > parameter that controls the timezone used in log messages, independently of the client-visible <TT CLASS="VARNAME" >timezone</TT > parameter. </P ></LI ><LI ><P > New system view <TT CLASS="LITERAL" >pg_stat_bgwriter</TT > displays statistics about background writer activity (Magnus) </P ></LI ><LI ><P > Add new columns for database-wide tuple statistics to <TT CLASS="LITERAL" >pg_stat_database</TT > (Magnus) </P ></LI ><LI ><P > Add an <TT CLASS="LITERAL" >xact_start</TT > (transaction start time) column to <TT CLASS="LITERAL" >pg_stat_activity</TT > (Neil) </P ><P > This makes it easier to identify long-running transactions. </P ></LI ><LI ><P > Add <TT CLASS="LITERAL" >n_live_tuples</TT > and <TT CLASS="LITERAL" >n_dead_tuples</TT > columns to <TT CLASS="LITERAL" >pg_stat_all_tables</TT > and related views (Glen Parker) </P ></LI ><LI ><P > Merge <TT CLASS="VARNAME" >stats_block_level</TT > and <TT CLASS="VARNAME" >stats_row_level</TT > parameters into a single parameter <TT CLASS="VARNAME" >track_counts</TT >, which controls all messages sent to the statistics collector process (Tom) </P ></LI ><LI ><P > Rename <TT CLASS="VARNAME" >stats_command_string</TT > parameter to <TT CLASS="VARNAME" >track_activities</TT > (Tom) </P ></LI ><LI ><P > Fix statistical counting of live and dead tuples to recognize that committed and aborted transactions have different effects (Tom) </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN131771" >E.121.3.4. Authentication</A ></H3 ><P ></P ><UL ><LI ><P > Support Security Service Provider Interface (<ACRONYM CLASS="ACRONYM" >SSPI</ACRONYM >) for authentication on Windows (Magnus) </P ></LI ><LI ><P > Support GSSAPI authentication (Henry Hotz, Magnus) </P ><P > This should be preferred to native Kerberos authentication because GSSAPI is an industry standard. </P ></LI ><LI ><P > Support a global SSL configuration file (Victor Wagner) </P ></LI ><LI ><P > Add <TT CLASS="VARNAME" >ssl_ciphers</TT > parameter to control accepted SSL ciphers (Victor Wagner) </P ></LI ><LI ><P > Add a Kerberos realm parameter, <TT CLASS="VARNAME" >krb_realm</TT > (Magnus) </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN131788" >E.121.3.5. Write-Ahead Log (<ACRONYM CLASS="ACRONYM" >WAL</ACRONYM >) and Continuous Archiving</A ></H3 ><P ></P ><UL ><LI ><P > Change the timestamps recorded in transaction WAL records from time_t to TimestampTz representation (Tom) </P ><P > This provides sub-second resolution in WAL, which can be useful for point-in-time recovery. </P ></LI ><LI ><P > Reduce WAL disk space needed by warm standby servers (Simon) </P ><P > This change allows a warm standby server to pass the name of the earliest still-needed WAL file to the recovery script, allowing automatic removal of no-longer-needed WAL files. This is done using <TT CLASS="LITERAL" >%r</TT > in the <TT CLASS="VARNAME" >restore_command</TT > parameter of <TT CLASS="FILENAME" >recovery.conf</TT >. </P ></LI ><LI ><P > New boolean configuration parameter, <TT CLASS="VARNAME" >archive_mode</TT >, controls archiving (Simon) </P ><P > Previously setting <TT CLASS="VARNAME" >archive_command</TT > to an empty string turned off archiving. Now <TT CLASS="VARNAME" >archive_mode</TT > turns archiving on and off, independently of <TT CLASS="VARNAME" >archive_command</TT >. This is useful for stopping archiving temporarily. </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN131808" >E.121.3.6. Queries</A ></H3 ><P ></P ><UL ><LI ><P > Full text search is integrated into the core database system (Teodor, Oleg) </P ><P > Text search has been improved, moved into the core code, and is now installed by default. <TT CLASS="FILENAME" >contrib/tsearch2</TT > now contains a compatibility interface. </P ></LI ><LI ><P > Add control over whether <TT CLASS="LITERAL" >NULL</TT >s sort first or last (Teodor, Tom) </P ><P > The syntax is <TT CLASS="LITERAL" >ORDER BY ... NULLS FIRST/LAST</TT >. </P ></LI ><LI ><P > Allow per-column ascending/descending (<TT CLASS="LITERAL" >ASC</TT >/<TT CLASS="LITERAL" >DESC</TT >) ordering options for indexes (Teodor, Tom) </P ><P > Previously a query using <TT CLASS="LITERAL" >ORDER BY</TT > with mixed <TT CLASS="LITERAL" >ASC</TT >/<TT CLASS="LITERAL" >DESC</TT > specifiers could not fully use an index. Now an index can be fully used in such cases if the index was created with matching <TT CLASS="LITERAL" >ASC</TT >/<TT CLASS="LITERAL" >DESC</TT > specifications. <TT CLASS="LITERAL" >NULL</TT > sort order within an index can be controlled, too. </P ></LI ><LI ><P > Allow <TT CLASS="LITERAL" >col IS NULL</TT > to use an index (Teodor) </P ></LI ><LI ><P > Updatable cursors (Arul Shaji, Tom) </P ><P > This eliminates the need to reference a primary key to <TT CLASS="COMMAND" >UPDATE</TT > or <TT CLASS="COMMAND" >DELETE</TT > rows returned by a cursor. The syntax is <TT CLASS="LITERAL" >UPDATE/DELETE WHERE CURRENT OF</TT >. </P ></LI ><LI ><P > Allow <TT CLASS="LITERAL" >FOR UPDATE</TT > in cursors (Arul Shaji, Tom) </P ></LI ><LI ><P > Create a general mechanism that supports casts to and from the standard string types (<TT CLASS="TYPE" >TEXT</TT >, <TT CLASS="TYPE" >VARCHAR</TT >, <TT CLASS="TYPE" >CHAR</TT >) for <SPAN CLASS="emphasis" ><I CLASS="EMPHASIS" >every</I ></SPAN > datatype, by invoking the datatype's I/O functions (Tom) </P ><P > Previously, such casts were available only for types that had specialized function(s) for the purpose. These new casts are assignment-only in the to-string direction, explicit-only in the other direction, and therefore should create no surprising behavior. </P ></LI ><LI ><P > Allow <TT CLASS="LITERAL" >UNION</TT > and related constructs to return a domain type, when all inputs are of that domain type (Tom) </P ><P > Formerly, the output would be considered to be of the domain's base type. </P ></LI ><LI ><P > Allow limited hashing when using two different data types (Tom) </P ><P > This allows hash joins, hash indexes, hashed subplans, and hash aggregation to be used in situations involving cross-data-type comparisons, if the data types have compatible hash functions. Currently, cross-data-type hashing support exists for <TT CLASS="TYPE" >smallint</TT >/<TT CLASS="TYPE" >integer</TT >/<TT CLASS="TYPE" >bigint</TT >, and for <TT CLASS="TYPE" >float4</TT >/<TT CLASS="TYPE" >float8</TT >. </P ></LI ><LI ><P > Improve optimizer logic for detecting when variables are equal in a <TT CLASS="LITERAL" >WHERE</TT > clause (Tom) </P ><P > This allows mergejoins to work with descending sort orders, and improves recognition of redundant sort columns. </P ></LI ><LI ><P > Improve performance when planning large inheritance trees in cases where most tables are excluded by constraints (Tom) </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN131868" >E.121.3.7. Object Manipulation</A ></H3 ><P ></P ><UL ><LI ><P > Arrays of composite types (David Fetter, Andrew, Tom) </P ><P > In addition to arrays of explicitly-declared composite types, arrays of the rowtypes of regular tables and views are now supported, except for rowtypes of system catalogs, sequences, and TOAST tables. </P ></LI ><LI ><P > Server configuration parameters can now be set on a per-function basis (Tom) </P ><P > For example, functions can now set their own <TT CLASS="VARNAME" >search_path</TT > to prevent unexpected behavior if a different <TT CLASS="VARNAME" >search_path</TT > exists at run-time. Security definer functions should set <TT CLASS="VARNAME" >search_path</TT > to avoid security loopholes. </P ></LI ><LI ><P > <TT CLASS="COMMAND" >CREATE/ALTER FUNCTION</TT > now supports <TT CLASS="LITERAL" >COST</TT > and <TT CLASS="LITERAL" >ROWS</TT > options (Tom) </P ><P > <TT CLASS="LITERAL" >COST</TT > allows specification of the cost of a function call. <TT CLASS="LITERAL" >ROWS</TT > allows specification of the average number or rows returned by a set-returning function. These values are used by the optimizer in choosing the best plan. </P ></LI ><LI ><P > Implement <TT CLASS="COMMAND" >CREATE TABLE LIKE ... INCLUDING INDEXES</TT > (Trevor Hardcastle, Nikhil Sontakke, Neil) </P ></LI ><LI ><P > Allow <TT CLASS="COMMAND" >CREATE INDEX CONCURRENTLY</TT > to ignore transactions in other databases (Simon) </P ></LI ><LI ><P > Add <TT CLASS="COMMAND" >ALTER VIEW ... RENAME TO</TT > and <TT CLASS="COMMAND" >ALTER SEQUENCE ... RENAME TO</TT > (David Fetter, Neil) </P ><P > Previously this could only be done via <TT CLASS="COMMAND" >ALTER TABLE ... RENAME TO</TT >. </P ></LI ><LI ><P > Make <TT CLASS="COMMAND" >CREATE/DROP/RENAME DATABASE</TT > wait briefly for conflicting backends to exit before failing (Tom) </P ><P > This increases the likelihood that these commands will succeed. </P ></LI ><LI ><P > Allow triggers and rules to be deactivated in groups using a configuration parameter, for replication purposes (Jan) </P ><P > This allows replication systems to disable triggers and rewrite rules as a group without modifying the system catalogs directly. The behavior is controlled by <TT CLASS="COMMAND" >ALTER TABLE</TT > and a new parameter <TT CLASS="VARNAME" >session_replication_role</TT >. </P ></LI ><LI ><P > User-defined types can now have type modifiers (Teodor, Tom) </P ><P > This allows a user-defined type to take a modifier, like <TT CLASS="TYPE" >ssnum(7)</TT >. Previously only built-in data types could have modifiers. </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN131913" >E.121.3.8. Utility Commands</A ></H3 ><P ></P ><UL ><LI ><P > Non-superuser database owners now are able to add trusted procedural languages to their databases by default (Jeremy Drake) </P ><P > While this is reasonably safe, some administrators might wish to revoke the privilege. It is controlled by <TT CLASS="STRUCTNAME" >pg_pltemplate</TT >.<TT CLASS="STRUCTFIELD" >tmpldbacreate</TT >. </P ></LI ><LI ><P > Allow a session's current parameter setting to be used as the default for future sessions (Tom) </P ><P > This is done with <TT CLASS="LITERAL" >SET ... FROM CURRENT</TT > in <TT CLASS="COMMAND" >CREATE/ALTER FUNCTION</TT >, <TT CLASS="COMMAND" >ALTER DATABASE</TT >, or <TT CLASS="COMMAND" >ALTER ROLE</TT >. </P ></LI ><LI ><P > Implement new commands <TT CLASS="COMMAND" >DISCARD ALL</TT >, <TT CLASS="COMMAND" >DISCARD PLANS</TT >, <TT CLASS="COMMAND" >DISCARD TEMPORARY</TT >, <TT CLASS="COMMAND" >CLOSE ALL</TT >, and <TT CLASS="COMMAND" >DEALLOCATE ALL</TT > (Marko Kreen, Neil) </P ><P > These commands simplify resetting a database session to its initial state, and are particularly useful for connection-pooling software. </P ></LI ><LI ><P > Make <TT CLASS="COMMAND" >CLUSTER</TT > MVCC-safe (Heikki Linnakangas) </P ><P > Formerly, <TT CLASS="COMMAND" >CLUSTER</TT > would discard all tuples that were committed dead, even if there were still transactions that should be able to see them under MVCC visibility rules. </P ></LI ><LI ><P > Add new <TT CLASS="COMMAND" >CLUSTER</TT > syntax: <TT CLASS="LITERAL" >CLUSTER <TT CLASS="REPLACEABLE" ><I >table</I ></TT > USING <TT CLASS="REPLACEABLE" ><I >index</I ></TT ></TT > (Holger Schurig) </P ><P > The old <TT CLASS="COMMAND" >CLUSTER</TT > syntax is still supported, but the new form is considered more logical. </P ></LI ><LI ><P > Fix <TT CLASS="COMMAND" >EXPLAIN</TT > so it can show complex plans more accurately (Tom) </P ><P > References to subplan outputs are now always shown correctly, instead of using <TT CLASS="LITERAL" >?column<TT CLASS="REPLACEABLE" ><I >N</I ></TT >?</TT > for complicated cases. </P ></LI ><LI ><P > Limit the amount of information reported when a user is dropped (Alvaro) </P ><P > Previously, dropping (or attempting to drop) a user who owned many objects could result in large <TT CLASS="LITERAL" >NOTICE</TT > or <TT CLASS="LITERAL" >ERROR</TT > messages listing all these objects; this caused problems for some client applications. The length of the message is now limited, although a full list is still sent to the server log. </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN131960" >E.121.3.9. Data Types</A ></H3 ><P ></P ><UL ><LI ><P > Support for the SQL/XML standard, including new operators and an <TT CLASS="TYPE" >XML</TT > data type (Nikolay Samokhvalov, Pavel Stehule, Peter) </P ></LI ><LI ><P > Enumerated data types (<TT CLASS="TYPE" >ENUM</TT >) (Tom Dunstan) </P ><P > This feature provides convenient support for fields that have a small, fixed set of allowed values. An example of creating an <TT CLASS="LITERAL" >ENUM</TT > type is <TT CLASS="LITERAL" >CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy')</TT >. </P ></LI ><LI ><P > Universally Unique Identifier (<TT CLASS="TYPE" >UUID</TT >) data type (Gevik Babakhani, Neil) </P ><P > This closely matches <ACRONYM CLASS="ACRONYM" >RFC</ACRONYM > 4122. </P ></LI ><LI ><P > Widen the <TT CLASS="TYPE" >MONEY</TT > data type to 64 bits (D'Arcy Cain) </P ><P > This greatly increases the range of supported <TT CLASS="TYPE" >MONEY</TT > values. </P ></LI ><LI ><P > Fix <TT CLASS="TYPE" >float4</TT >/<TT CLASS="TYPE" >float8</TT > to handle <TT CLASS="LITERAL" >Infinity</TT > and <TT CLASS="LITERAL" >NAN</TT > (Not A Number) consistently (Bruce) </P ><P > The code formerly was not consistent about distinguishing <TT CLASS="LITERAL" >Infinity</TT > from overflow conditions. </P ></LI ><LI ><P > Allow leading and trailing whitespace during input of <TT CLASS="TYPE" >boolean</TT > values (Neil) </P ></LI ><LI ><P > Prevent <TT CLASS="COMMAND" >COPY</TT > from using digits and lowercase letters as delimiters (Tom) </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN131996" >E.121.3.10. Functions</A ></H3 ><P ></P ><UL ><LI ><P > Add new regular expression functions <CODE CLASS="FUNCTION" >regexp_matches()</CODE >, <CODE CLASS="FUNCTION" >regexp_split_to_array()</CODE >, and <CODE CLASS="FUNCTION" >regexp_split_to_table()</CODE > (Jeremy Drake, Neil) </P ><P > These functions provide extraction of regular expression subexpressions and allow splitting a string using a POSIX regular expression. </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >lo_truncate()</CODE > for large object truncation (Kris Jurka) </P ></LI ><LI ><P > Implement <CODE CLASS="FUNCTION" >width_bucket()</CODE > for the <TT CLASS="TYPE" >float8</TT > data type (Neil) </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >pg_stat_clear_snapshot()</CODE > to discard statistics snapshots collected during the current transaction (Tom) </P ><P > The first request for statistics in a transaction takes a statistics snapshot that does not change during the transaction. This function allows the snapshot to be discarded and a new snapshot loaded during the next statistics query. This is particularly useful for PL/pgSQL functions, which are confined to a single transaction. </P ></LI ><LI ><P > Add <TT CLASS="LITERAL" >isodow</TT > option to <CODE CLASS="FUNCTION" >EXTRACT()</CODE > and <CODE CLASS="FUNCTION" >date_part()</CODE > (Bruce) </P ><P > This returns the day of the week, with Sunday as seven. (<TT CLASS="LITERAL" >dow</TT > returns Sunday as zero.) </P ></LI ><LI ><P > Add <TT CLASS="LITERAL" >ID</TT > (ISO day of week) and <TT CLASS="LITERAL" >IDDD</TT > (ISO day of year) format codes for <CODE CLASS="FUNCTION" >to_char()</CODE >, <CODE CLASS="FUNCTION" >to_date()</CODE >, and <CODE CLASS="FUNCTION" >to_timestamp()</CODE > (Brendan Jurd) </P ></LI ><LI ><P > Make <CODE CLASS="FUNCTION" >to_timestamp()</CODE > and <CODE CLASS="FUNCTION" >to_date()</CODE > assume <TT CLASS="LITERAL" >TM</TT > (trim) option for potentially variable-width fields (Bruce) </P ><P > This matches <SPAN CLASS="PRODUCTNAME" >Oracle</SPAN >'s behavior. </P ></LI ><LI ><P > Fix off-by-one conversion error in <CODE CLASS="FUNCTION" >to_date()</CODE >/<CODE CLASS="FUNCTION" >to_timestamp()</CODE > <TT CLASS="LITERAL" >D</TT > (non-ISO day of week) fields (Bruce) </P ></LI ><LI ><P > Make <CODE CLASS="FUNCTION" >setseed()</CODE > return void, rather than a useless integer value (Neil) </P ></LI ><LI ><P > Add a hash function for <TT CLASS="TYPE" >NUMERIC</TT > (Neil) </P ><P > This allows hash indexes and hash-based plans to be used with <TT CLASS="TYPE" >NUMERIC</TT > columns. </P ></LI ><LI ><P > Improve efficiency of <TT CLASS="LITERAL" >LIKE</TT >/<TT CLASS="LITERAL" >ILIKE</TT >, especially for multi-byte character sets like UTF-8 (Andrew, Itagaki Takahiro) </P ></LI ><LI ><P > Make <CODE CLASS="FUNCTION" >currtid()</CODE > functions require <TT CLASS="LITERAL" >SELECT</TT > privileges on the target table (Tom) </P ></LI ><LI ><P > Add several <CODE CLASS="FUNCTION" >txid_*()</CODE > functions to query active transaction IDs (Jan) </P ><P > This is useful for various replication solutions. </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN132062" >E.121.3.11. PL/pgSQL Server-Side Language</A ></H3 ><P ></P ><UL ><LI ><P > Add scrollable cursor support, including directional control in <TT CLASS="COMMAND" >FETCH</TT > (Pavel Stehule) </P ></LI ><LI ><P > Allow <TT CLASS="LITERAL" >IN</TT > as an alternative to <TT CLASS="LITERAL" >FROM</TT > in PL/pgSQL's <TT CLASS="COMMAND" >FETCH</TT > statement, for consistency with the backend's <TT CLASS="COMMAND" >FETCH</TT > command (Pavel Stehule) </P ></LI ><LI ><P > Add <TT CLASS="COMMAND" >MOVE</TT > to PL/pgSQL (Magnus, Pavel Stehule, Neil) </P ></LI ><LI ><P > Implement <TT CLASS="COMMAND" >RETURN QUERY</TT > (Pavel Stehule, Neil) </P ><P > This adds convenient syntax for PL/pgSQL set-returning functions that want to return the result of a query. <TT CLASS="COMMAND" >RETURN QUERY</TT > is easier and more efficient than a loop around <TT CLASS="COMMAND" >RETURN NEXT</TT >. </P ></LI ><LI ><P > Allow function parameter names to be qualified with the function's name (Tom) </P ><P > For example, <TT CLASS="LITERAL" >myfunc.myvar</TT >. This is particularly useful for specifying variables in a query where the variable name might match a column name. </P ></LI ><LI ><P > Make qualification of variables with block labels work properly (Tom) </P ><P > Formerly, outer-level block labels could unexpectedly interfere with recognition of inner-level record or row references. </P ></LI ><LI ><P > Tighten requirements for <TT CLASS="LITERAL" >FOR</TT > loop <TT CLASS="LITERAL" >STEP</TT > values (Tom) </P ><P > Prevent non-positive <TT CLASS="LITERAL" >STEP</TT > values, and handle loop overflows. </P ></LI ><LI ><P > Improve accuracy when reporting syntax error locations (Tom) </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN132098" >E.121.3.12. Other Server-Side Languages</A ></H3 ><P ></P ><UL ><LI ><P > Allow type-name arguments to PL/Perl <CODE CLASS="FUNCTION" >spi_prepare()</CODE > to be data type aliases in addition to names found in <TT CLASS="LITERAL" >pg_type</TT > (Andrew) </P ></LI ><LI ><P > Allow type-name arguments to PL/Python <CODE CLASS="FUNCTION" >plpy.prepare()</CODE > to be data type aliases in addition to names found in <TT CLASS="LITERAL" >pg_type</TT > (Andrew) </P ></LI ><LI ><P > Allow type-name arguments to PL/Tcl <CODE CLASS="FUNCTION" >spi_prepare</CODE > to be data type aliases in addition to names found in <TT CLASS="LITERAL" >pg_type</TT > (Andrew) </P ></LI ><LI ><P > Enable PL/PythonU to compile on Python 2.5 (Marko Kreen) </P ></LI ><LI ><P > Support a true PL/Python boolean type in compatible Python versions (Python 2.3 and later) (Marko Kreen) </P ></LI ><LI ><P > Fix PL/Tcl problems with thread-enabled <TT CLASS="FILENAME" >libtcl</TT > spawning multiple threads within the backend (Steve Marshall, Paul Bayer, Doug Knight) </P ><P > This caused all sorts of unpleasantness. </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN132121" >E.121.3.13. <A HREF="app-psql.html" ><SPAN CLASS="APPLICATION" >psql</SPAN ></A ></A ></H3 ><P ></P ><UL ><LI ><P > List disabled triggers separately in <TT CLASS="LITERAL" >\d</TT > output (Brendan Jurd) </P ></LI ><LI ><P > In <TT CLASS="LITERAL" >\d</TT > patterns, always match <TT CLASS="LITERAL" >$</TT > literally (Tom) </P ></LI ><LI ><P > Show aggregate return types in <TT CLASS="LITERAL" >\da</TT > output (Greg Sabino Mullane) </P ></LI ><LI ><P > Add the function's volatility status to the output of <TT CLASS="LITERAL" >\df+</TT > (Neil) </P ></LI ><LI ><P > Add <TT CLASS="LITERAL" >\prompt</TT > capability (Chad Wagner) </P ></LI ><LI ><P > Allow <TT CLASS="LITERAL" >\pset</TT >, <TT CLASS="LITERAL" >\t</TT >, and <TT CLASS="LITERAL" >\x</TT > to specify <TT CLASS="LITERAL" >on</TT > or <TT CLASS="LITERAL" >off</TT >, rather than just toggling (Chad Wagner) </P ></LI ><LI ><P > Add <TT CLASS="LITERAL" >\sleep</TT > capability (Jan) </P ></LI ><LI ><P > Enable <TT CLASS="LITERAL" >\timing</TT > output for <TT CLASS="LITERAL" >\copy</TT > (Andrew) </P ></LI ><LI ><P > Improve <TT CLASS="LITERAL" >\timing</TT > resolution on Windows (Itagaki Takahiro) </P ></LI ><LI ><P > Flush <TT CLASS="LITERAL" >\o</TT > output after each backslash command (Tom) </P ></LI ><LI ><P > Correctly detect and report errors while reading a <TT CLASS="LITERAL" >-f</TT > input file (Peter) </P ></LI ><LI ><P > Remove <TT CLASS="LITERAL" >-u</TT > option (this option has long been deprecated) (Tom) </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN132168" >E.121.3.14. <A HREF="app-pgdump.html" ><SPAN CLASS="APPLICATION" >pg_dump</SPAN ></A ></A ></H3 ><P ></P ><UL ><LI ><P > Add <TT CLASS="LITERAL" >--tablespaces-only</TT > and <TT CLASS="LITERAL" >--roles-only</TT > options to <SPAN CLASS="APPLICATION" >pg_dumpall</SPAN > (Dave Page) </P ></LI ><LI ><P > Add an output file option to <SPAN CLASS="APPLICATION" >pg_dumpall</SPAN > (Dave Page) </P ><P > This is primarily useful on Windows, where output redirection of child <SPAN CLASS="APPLICATION" >pg_dump</SPAN > processes does not work. </P ></LI ><LI ><P > Allow <SPAN CLASS="APPLICATION" >pg_dumpall</SPAN > to accept an initial-connection database name rather than the default <TT CLASS="LITERAL" >template1</TT > (Dave Page) </P ></LI ><LI ><P > In <TT CLASS="LITERAL" >-n</TT > and <TT CLASS="LITERAL" >-t</TT > switches, always match <TT CLASS="LITERAL" >$</TT > literally (Tom) </P ></LI ><LI ><P > Improve performance when a database has thousands of objects (Tom) </P ></LI ><LI ><P > Remove <TT CLASS="LITERAL" >-u</TT > option (this option has long been deprecated) (Tom) </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN132197" >E.121.3.15. Other Client Applications</A ></H3 ><P ></P ><UL ><LI ><P > In <SPAN CLASS="APPLICATION" >initdb</SPAN >, allow the location of the <TT CLASS="FILENAME" >pg_xlog</TT > directory to be specified (Euler Taveira de Oliveira) </P ></LI ><LI ><P > Enable server core dump generation in <SPAN CLASS="APPLICATION" >pg_regress</SPAN > on supported operating systems (Andrew) </P ></LI ><LI ><P > Add a <TT CLASS="LITERAL" >-t</TT > (timeout) parameter to <SPAN CLASS="APPLICATION" >pg_ctl</SPAN > (Bruce) </P ><P > This controls how long <SPAN CLASS="APPLICATION" >pg_ctl</SPAN > will wait when waiting for server startup or shutdown. Formerly the timeout was hard-wired as 60 seconds. </P ></LI ><LI ><P > Add a <SPAN CLASS="APPLICATION" >pg_ctl</SPAN > option to control generation of server core dumps (Andrew) </P ></LI ><LI ><P > Allow Control-C to cancel <SPAN CLASS="APPLICATION" >clusterdb</SPAN >, <SPAN CLASS="APPLICATION" >reindexdb</SPAN >, and <SPAN CLASS="APPLICATION" >vacuumdb</SPAN > (Itagaki Takahiro, Magnus) </P ></LI ><LI ><P > Suppress command tag output for <SPAN CLASS="APPLICATION" >createdb</SPAN >, <SPAN CLASS="APPLICATION" >createuser</SPAN >, <SPAN CLASS="APPLICATION" >dropdb</SPAN >, and <SPAN CLASS="APPLICATION" >dropuser</SPAN > (Peter) </P ><P > The <TT CLASS="LITERAL" >--quiet</TT > option is ignored and will be removed in 8.4. Progress messages when acting on all databases now go to stdout instead of stderr because they are not actually errors. </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN132229" >E.121.3.16. <A HREF="libpq.html" ><SPAN CLASS="APPLICATION" >libpq</SPAN ></A ></A ></H3 ><P ></P ><UL ><LI ><P > Interpret the <TT CLASS="LITERAL" >dbName</TT > parameter of <CODE CLASS="FUNCTION" >PQsetdbLogin()</CODE > as a <TT CLASS="LITERAL" >conninfo</TT > string if it contains an equals sign (Andrew) </P ><P > This allows use of <TT CLASS="LITERAL" >conninfo</TT > strings in client programs that still use <TT CLASS="LITERAL" >PQsetdbLogin()</TT >. </P ></LI ><LI ><P > Support a global <ACRONYM CLASS="ACRONYM" >SSL</ACRONYM > configuration file (Victor Wagner) </P ></LI ><LI ><P > Add environment variable <TT CLASS="VARNAME" >PGSSLKEY</TT > to control <ACRONYM CLASS="ACRONYM" >SSL</ACRONYM > hardware keys (Victor Wagner) </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >lo_truncate()</CODE > for large object truncation (Kris Jurka) </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >PQconnectionNeedsPassword()</CODE > that returns true if the server required a password but none was supplied (Joe Conway, Tom) </P ><P > If this returns true after a failed connection attempt, a client application should prompt the user for a password. In the past applications have had to check for a specific error message string to decide whether a password is needed; that approach is now deprecated. </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >PQconnectionUsedPassword()</CODE > that returns true if the supplied password was actually used (Joe Conway, Tom) </P ><P > This is useful in some security contexts where it is important to know whether a user-supplied password is actually valid. </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN132260" >E.121.3.17. <A HREF="ecpg.html" ><SPAN CLASS="APPLICATION" >ecpg</SPAN ></A ></A ></H3 ><P ></P ><UL ><LI ><P > Use V3 frontend/backend protocol (Michael) </P ><P > This adds support for server-side prepared statements. </P ></LI ><LI ><P > Use native threads, instead of pthreads, on Windows (Magnus) </P ></LI ><LI ><P > Improve thread-safety of ecpglib (Itagaki Takahiro) </P ></LI ><LI ><P > Make the ecpg libraries export only necessary API symbols (Michael) </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN132274" >E.121.3.18. <SPAN CLASS="APPLICATION" >Windows</SPAN > Port</A ></H3 ><P ></P ><UL ><LI ><P > Allow the whole <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > distribution to be compiled with <SPAN CLASS="PRODUCTNAME" >Microsoft Visual C++</SPAN > (Magnus and others) </P ><P > This allows Windows-based developers to use familiar development and debugging tools. Windows executables made with Visual C++ might also have better stability and performance than those made with other tool sets. The client-only Visual C++ build scripts have been removed. </P ></LI ><LI ><P > Drastically reduce postmaster's memory usage when it has many child processes (Magnus) </P ></LI ><LI ><P > Allow regression tests to be started by an administrative user (Magnus) </P ></LI ><LI ><P > Add native shared memory implementation (Magnus) </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN132289" >E.121.3.19. Server Programming Interface (<ACRONYM CLASS="ACRONYM" >SPI</ACRONYM >)</A ></H3 ><P ></P ><UL ><LI ><P > Add cursor-related functionality in SPI (Pavel Stehule) </P ><P > Allow access to the cursor-related planning options, and add <TT CLASS="COMMAND" >FETCH</TT >/<TT CLASS="COMMAND" >MOVE</TT > routines. </P ></LI ><LI ><P > Allow execution of cursor commands through <CODE CLASS="FUNCTION" >SPI_execute</CODE > (Tom) </P ><P > The macro <TT CLASS="LITERAL" >SPI_ERROR_CURSOR</TT > still exists but will never be returned. </P ></LI ><LI ><P > SPI plan pointers are now declared as <TT CLASS="LITERAL" >SPIPlanPtr</TT > instead of <TT CLASS="LITERAL" >void *</TT > (Tom) </P ><P > This does not break application code, but switching is recommended to help catch simple programming mistakes. </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN132308" >E.121.3.20. Build Options</A ></H3 ><P ></P ><UL ><LI ><P > Add <SPAN CLASS="APPLICATION" >configure</SPAN > option <TT CLASS="LITERAL" >--enable-profiling</TT > to enable code profiling (works only with <SPAN CLASS="APPLICATION" >gcc</SPAN >) (Korry Douglas and Nikhil Sontakke) </P ></LI ><LI ><P > Add <SPAN CLASS="APPLICATION" >configure</SPAN > option <TT CLASS="LITERAL" >--with-system-tzdata</TT > to use the operating system's time zone database (Peter) </P ></LI ><LI ><P > Fix <ACRONYM CLASS="ACRONYM" >PGXS</ACRONYM > so extensions can be built against PostgreSQL installations whose <SPAN CLASS="APPLICATION" >pg_config</SPAN > program does not appear first in the <TT CLASS="VARNAME" >PATH</TT > (Tom) </P ></LI ><LI ><P > Support <TT CLASS="COMMAND" >gmake draft</TT > when building the <ACRONYM CLASS="ACRONYM" >SGML</ACRONYM > documentation (Bruce) </P ><P > Unless <TT CLASS="LITERAL" >draft</TT > is used, the documentation build will now be repeated if necessary to ensure the index is up-to-date. </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN132331" >E.121.3.21. Source Code</A ></H3 ><P ></P ><UL ><LI ><P > Rename macro <TT CLASS="LITERAL" >DLLIMPORT</TT > to <TT CLASS="LITERAL" >PGDLLIMPORT</TT > to avoid conflicting with third party includes (like Tcl) that define <TT CLASS="LITERAL" >DLLIMPORT</TT > (Magnus) </P ></LI ><LI ><P > Create <SPAN CLASS="QUOTE" >"operator families"</SPAN > to improve planning of queries involving cross-data-type comparisons (Tom) </P ></LI ><LI ><P > Update GIN <CODE CLASS="FUNCTION" >extractQuery()</CODE > API to allow signalling that nothing can satisfy the query (Teodor) </P ></LI ><LI ><P > Move <TT CLASS="LITERAL" >NAMEDATALEN</TT > definition from <TT CLASS="FILENAME" >postgres_ext.h</TT > to <TT CLASS="FILENAME" >pg_config_manual.h</TT > (Peter) </P ></LI ><LI ><P > Provide <CODE CLASS="FUNCTION" >strlcpy()</CODE > and <CODE CLASS="FUNCTION" >strlcat()</CODE > on all platforms, and replace error-prone uses of <CODE CLASS="FUNCTION" >strncpy()</CODE >, <CODE CLASS="FUNCTION" >strncat()</CODE >, etc (Peter) </P ></LI ><LI ><P > Create hooks to let an external plugin monitor (or even replace) the planner and create plans for hypothetical situations (Gurjeet Singh, Tom) </P ></LI ><LI ><P > Create a function variable <TT CLASS="LITERAL" >join_search_hook</TT > to let plugins override the join search order portion of the planner (Julius Stroffek) </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >tas()</CODE > support for Renesas' M32R processor (Kazuhiro Inaoka) </P ></LI ><LI ><P > <CODE CLASS="FUNCTION" >quote_identifier()</CODE > and <SPAN CLASS="APPLICATION" >pg_dump</SPAN > no longer quote keywords that are unreserved according to the grammar (Tom) </P ></LI ><LI ><P > Change the on-disk representation of the <TT CLASS="TYPE" >NUMERIC</TT > data type so that the <TT CLASS="STRUCTFIELD" >sign_dscale</TT > word comes before the weight (Tom) </P ></LI ><LI ><P > Use <ACRONYM CLASS="ACRONYM" >SYSV</ACRONYM > semaphores rather than POSIX on Darwin >= 6.0, i.e., OS X 10.2 and up (Chris Marcellino) </P ></LI ><LI ><P > Add <A HREF="acronyms.html" >acronym</A > and <A HREF="creating-cluster.html#CREATING-CLUSTER-NFS" >NFS</A > documentation sections (Bruce) </P ></LI ><LI ><P > "Postgres" is now documented as an accepted alias for "PostgreSQL" (Peter) </P ></LI ><LI ><P > Add documentation about preventing database server spoofing when the server is down (Bruce) </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN132383" >E.121.3.22. Contrib</A ></H3 ><P ></P ><UL ><LI ><P > Move <TT CLASS="FILENAME" >contrib</TT > <TT CLASS="FILENAME" >README</TT > content into the main <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > documentation (Albert Cervera i Areny) </P ></LI ><LI ><P > Add <TT CLASS="FILENAME" >contrib/pageinspect</TT > module for low-level page inspection (Simon, Heikki) </P ></LI ><LI ><P > Add <TT CLASS="FILENAME" >contrib/pg_standby</TT > module for controlling warm standby operation (Simon) </P ></LI ><LI ><P > Add <TT CLASS="FILENAME" >contrib/uuid-ossp</TT > module for generating <TT CLASS="TYPE" >UUID</TT > values using the OSSP UUID library (Peter) </P ><P > Use <SPAN CLASS="APPLICATION" >configure</SPAN > <TT CLASS="LITERAL" >--with-ossp-uuid</TT > to activate. This takes advantage of the new <TT CLASS="TYPE" >UUID</TT > builtin type. </P ></LI ><LI ><P > Add <TT CLASS="FILENAME" >contrib/dict_int</TT >, <TT CLASS="FILENAME" >contrib/dict_xsyn</TT >, and <TT CLASS="FILENAME" >contrib/test_parser</TT > modules to provide sample add-on text search dictionary templates and parsers (Sergey Karpov) </P ></LI ><LI ><P > Allow <SPAN CLASS="APPLICATION" >contrib/pgbench</SPAN > to set the fillfactor (Pavan Deolasee) </P ></LI ><LI ><P > Add timestamps to <SPAN CLASS="APPLICATION" >contrib/pgbench</SPAN > <TT CLASS="LITERAL" >-l</TT > (Greg Smith) </P ></LI ><LI ><P > Add usage count statistics to <TT CLASS="FILENAME" >contrib/pgbuffercache</TT > (Greg Smith) </P ></LI ><LI ><P > Add GIN support for <TT CLASS="FILENAME" >contrib/hstore</TT > (Teodor) </P ></LI ><LI ><P > Add GIN support for <TT CLASS="FILENAME" >contrib/pg_trgm</TT > (Guillaume Smet, Teodor) </P ></LI ><LI ><P > Update OS/X startup scripts in <TT CLASS="FILENAME" >contrib/start-scripts</TT > (Mark Cotner, David Fetter) </P ></LI ><LI ><P > Restrict <CODE CLASS="FUNCTION" >pgrowlocks()</CODE > and <CODE CLASS="FUNCTION" >dblink_get_pkey()</CODE > to users who have <TT CLASS="LITERAL" >SELECT</TT > privilege on the target table (Tom) </P ></LI ><LI ><P > Restrict <TT CLASS="FILENAME" >contrib/pgstattuple</TT > functions to superusers (Tom) </P ></LI ><LI ><P > <TT CLASS="FILENAME" >contrib/xml2</TT > is deprecated and planned for removal in 8.4 (Peter) </P ><P > The new XML support in core PostgreSQL supersedes this module. </P ></LI ></UL ></DIV ></DIV ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="release-8-3-1.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="release-8-2-23.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Release 8.3.1</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="release.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Release 8.2.23</TD ></TR ></TABLE ></DIV ></BODY ></HTML >
Submit
FILE
FOLDER
Name
Size
Permission
Action
LEGALNOTICE.html
2681 bytes
0644
acronyms.html
16284 bytes
0644
admin.html
12564 bytes
0644
adminpack.html
7889 bytes
0644
app-clusterdb.html
10602 bytes
0644
app-createdb.html
12856 bytes
0644
app-createlang.html
9907 bytes
0644
app-createuser.html
15640 bytes
0644
app-dropdb.html
9642 bytes
0644
app-droplang.html
9638 bytes
0644
app-dropuser.html
9596 bytes
0644
app-ecpg.html
8718 bytes
0644
app-initdb.html
15405 bytes
0644
app-pg-ctl.html
22459 bytes
0644
app-pg-dumpall.html
20706 bytes
0644
app-pgbasebackup.html
19833 bytes
0644
app-pgconfig.html
11093 bytes
0644
app-pgcontroldata.html
3979 bytes
0644
app-pgdump.html
43964 bytes
0644
app-pgreceivexlog.html
11057 bytes
0644
app-pgresetxlog.html
11566 bytes
0644
app-pgrestore.html
30269 bytes
0644
app-postgres.html
31828 bytes
0644
app-postmaster.html
3005 bytes
0644
app-psql.html
138871 bytes
0644
app-reindexdb.html
11281 bytes
0644
app-vacuumdb.html
12616 bytes
0644
appendixes.html
26329 bytes
0644
applevel-consistency.html
10315 bytes
0644
archive-recovery-settings.html
7338 bytes
0644
arrays.html
28079 bytes
0644
auth-delay.html
3780 bytes
0644
auth-methods.html
36202 bytes
0644
auth-pg-hba-conf.html
29759 bytes
0644
auth-username-maps.html
8597 bytes
0644
auto-explain.html
9887 bytes
0644
backup-dump.html
15927 bytes
0644
backup-file.html
7996 bytes
0644
backup.html
4485 bytes
0644
biblio.html
11549 bytes
0644
bki-commands.html
9646 bytes
0644
bki-example.html
3049 bytes
0644
bki-format.html
3463 bytes
0644
bki-structure.html
4320 bytes
0644
bki.html
4330 bytes
0644
bookindex.html
243165 bytes
0644
btree-gin.html
4600 bytes
0644
btree-gist.html
6884 bytes
0644
bug-reporting.html
18646 bytes
0644
catalog-pg-aggregate.html
5502 bytes
0644
catalog-pg-am.html
10547 bytes
0644
catalog-pg-amop.html
7593 bytes
0644
catalog-pg-amproc.html
4885 bytes
0644
catalog-pg-attrdef.html
4364 bytes
0644
catalog-pg-attribute.html
10287 bytes
0644
catalog-pg-auth-members.html
4255 bytes
0644
catalog-pg-authid.html
6815 bytes
0644
catalog-pg-cast.html
6955 bytes
0644
catalog-pg-class.html
12661 bytes
0644
catalog-pg-collation.html
5897 bytes
0644
catalog-pg-constraint.html
11579 bytes
0644
catalog-pg-conversion.html
4430 bytes
0644
catalog-pg-database.html
7027 bytes
0644
catalog-pg-db-role-setting.html
4068 bytes
0644
catalog-pg-default-acl.html
5267 bytes
0644
catalog-pg-depend.html
8635 bytes
0644
catalog-pg-description.html
4478 bytes
0644
catalog-pg-enum.html
4716 bytes
0644
catalog-pg-extension.html
5282 bytes
0644
catalog-pg-foreign-data-wrapper.html
4945 bytes
0644
catalog-pg-foreign-server.html
4688 bytes
0644
catalog-pg-foreign-table.html
4036 bytes
0644
catalog-pg-index.html
8868 bytes
0644
catalog-pg-inherits.html
3888 bytes
0644
catalog-pg-language.html
5952 bytes
0644
catalog-pg-largeobject-metadata.html
3630 bytes
0644
catalog-pg-largeobject.html
5154 bytes
0644
catalog-pg-namespace.html
3751 bytes
0644
catalog-pg-opclass.html
5863 bytes
0644
catalog-pg-operator.html
6645 bytes
0644
catalog-pg-opfamily.html
4811 bytes
0644
catalog-pg-pltemplate.html
5364 bytes
0644
catalog-pg-proc.html
13403 bytes
0644
catalog-pg-range.html
5182 bytes
0644
catalog-pg-rewrite.html
5391 bytes
0644
catalog-pg-seclabel.html
4515 bytes
0644
catalog-pg-shdepend.html
7043 bytes
0644
catalog-pg-shdescription.html
4247 bytes
0644
catalog-pg-shseclabel.html
4404 bytes
0644
catalog-pg-statistic.html
9538 bytes
0644
catalog-pg-tablespace.html
4158 bytes
0644
catalog-pg-trigger.html
8287 bytes
0644
catalog-pg-ts-config-map.html
4193 bytes
0644
catalog-pg-ts-config.html
4481 bytes
0644
catalog-pg-ts-dict.html
4716 bytes
0644
catalog-pg-ts-parser.html
5082 bytes
0644
catalog-pg-ts-template.html
4258 bytes
0644
catalog-pg-type.html
19905 bytes
0644
catalog-pg-user-mapping.html
3847 bytes
0644
catalogs-overview.html
10431 bytes
0644
catalogs.html
10387 bytes
0644
charset.html
4162 bytes
0644
chkpass.html
4391 bytes
0644
citext.html
11148 bytes
0644
client-authentication-problems.html
4224 bytes
0644
client-authentication.html
5914 bytes
0644
client-interfaces.html
13717 bytes
0644
collation.html
14222 bytes
0644
config-setting.html
11146 bytes
0644
connect-estab.html
4315 bytes
0644
continuous-archiving.html
49830 bytes
0644
contrib-dblink-build-sql-delete.html
5451 bytes
0644
contrib-dblink-build-sql-insert.html
6052 bytes
0644
contrib-dblink-build-sql-update.html
6281 bytes
0644
contrib-dblink-cancel-query.html
3820 bytes
0644
contrib-dblink-close.html
4650 bytes
0644
contrib-dblink-connect-u.html
4482 bytes
0644
contrib-dblink-connect.html
7325 bytes
0644
contrib-dblink-disconnect.html
3718 bytes
0644
contrib-dblink-error-message.html
3508 bytes
0644
contrib-dblink-exec.html
5466 bytes
0644
contrib-dblink-fetch.html
5979 bytes
0644
contrib-dblink-function.html
8630 bytes
0644
contrib-dblink-get-connections.html
3206 bytes
0644
contrib-dblink-get-notify.html
4168 bytes
0644
contrib-dblink-get-pkey.html
4498 bytes
0644
contrib-dblink-get-result.html
6959 bytes
0644
contrib-dblink-is-busy.html
3490 bytes
0644
contrib-dblink-open.html
5464 bytes
0644
contrib-dblink-send-query.html
4170 bytes
0644
contrib-prog-client.html
3434 bytes
0644
contrib-prog-server.html
3837 bytes
0644
contrib-prog.html
3320 bytes
0644
contrib-spi.html
11236 bytes
0644
contrib.html
8904 bytes
0644
creating-cluster.html
12465 bytes
0644
cube.html
15941 bytes
0644
database-roles.html
6092 bytes
0644
datatype-binary.html
12893 bytes
0644
datatype-bit.html
5096 bytes
0644
datatype-boolean.html
5267 bytes
0644
datatype-character.html
11893 bytes
0644
datatype-datetime.html
50763 bytes
0644
datatype-enum.html
6433 bytes
0644
datatype-geometric.html
12503 bytes
0644
datatype-json.html
3439 bytes
0644
datatype-money.html
5482 bytes
0644
datatype-net-types.html
10423 bytes
0644
datatype-numeric.html
22353 bytes
0644
datatype-oid.html
9686 bytes
0644
datatype-pseudo.html
7285 bytes
0644
datatype-textsearch.html
10033 bytes
0644
datatype-uuid.html
4560 bytes
0644
datatype-xml.html
11334 bytes
0644
datatype.html
16609 bytes
0644
datetime-appendix.html
3525 bytes
0644
datetime-config-files.html
8980 bytes
0644
datetime-input-rules.html
6763 bytes
0644
datetime-keywords.html
5096 bytes
0644
datetime-units-history.html
7634 bytes
0644
dblink.html
5322 bytes
0644
ddl-alter.html
10498 bytes
0644
ddl-basics.html
7816 bytes
0644
ddl-constraints.html
22790 bytes
0644
ddl-default.html
4540 bytes
0644
ddl-depend.html
6498 bytes
0644
ddl-foreign-data.html
4485 bytes
0644
ddl-inherit.html
15308 bytes
0644
ddl-others.html
3080 bytes
0644
ddl-partitioning.html
27763 bytes
0644
ddl-priv.html
6066 bytes
0644
ddl-schemas.html
18046 bytes
0644
ddl-system-columns.html
8049 bytes
0644
ddl.html
6382 bytes
0644
dict-int.html
4793 bytes
0644
dict-xsyn.html
6481 bytes
0644
different-replication-solutions.html
14793 bytes
0644
disk-full.html
3517 bytes
0644
disk-usage.html
5661 bytes
0644
diskusage.html
2668 bytes
0644
dml-delete.html
3565 bytes
0644
dml-insert.html
5801 bytes
0644
dml-returning.html
5104 bytes
0644
dml-update.html
5556 bytes
0644
dml.html
2944 bytes
0644
docguide-authoring.html
6757 bytes
0644
docguide-build.html
15280 bytes
0644
docguide-docbook.html
3853 bytes
0644
docguide-style.html
7429 bytes
0644
docguide-toolsets.html
20683 bytes
0644
docguide.html
3624 bytes
0644
dummy-seclabel.html
4358 bytes
0644
dynamic-trace.html
27234 bytes
0644
earthdistance.html
8806 bytes
0644
ecpg-commands.html
9527 bytes
0644
ecpg-concept.html
4979 bytes
0644
ecpg-connect.html
10826 bytes
0644
ecpg-cpp.html
9624 bytes
0644
ecpg-descriptors.html
34909 bytes
0644
ecpg-develop.html
7964 bytes
0644
ecpg-dynamic.html
6515 bytes
0644
ecpg-errors.html
25737 bytes
0644
ecpg-informix-compat.html
52760 bytes
0644
ecpg-library.html
5798 bytes
0644
ecpg-lo.html
5527 bytes
0644
ecpg-pgtypes.html
54457 bytes
0644
ecpg-preproc.html
8985 bytes
0644
ecpg-process.html
5386 bytes
0644
ecpg-sql-allocate-descriptor.html
3983 bytes
0644
ecpg-sql-commands.html
4698 bytes
0644
ecpg-sql-connect.html
9375 bytes
0644
ecpg-sql-deallocate-descriptor.html
3773 bytes
0644
ecpg-sql-declare.html
5397 bytes
0644
ecpg-sql-describe.html
4595 bytes
0644
ecpg-sql-disconnect.html
4733 bytes
0644
ecpg-sql-execute-immediate.html
3877 bytes
0644
ecpg-sql-get-descriptor.html
7709 bytes
0644
ecpg-sql-open.html
4642 bytes
0644
ecpg-sql-prepare.html
4177 bytes
0644
ecpg-sql-set-autocommit.html
3333 bytes
0644
ecpg-sql-set-connection.html
3929 bytes
0644
ecpg-sql-set-descriptor.html
5505 bytes
0644
ecpg-sql-type.html
5026 bytes
0644
ecpg-sql-var.html
3539 bytes
0644
ecpg-sql-whenever.html
4686 bytes
0644
ecpg-variables.html
40283 bytes
0644
ecpg.html
10344 bytes
0644
encryption-options.html
7495 bytes
0644
errcodes-appendix.html
36965 bytes
0644
error-message-reporting.html
14124 bytes
0644
error-style-guide.html
16769 bytes
0644
event-log-registration.html
4188 bytes
0644
executor.html
6612 bytes
0644
explicit-joins.html
11019 bytes
0644
explicit-locking.html
25073 bytes
0644
extend-extensions.html
32430 bytes
0644
extend-how.html
4552 bytes
0644
extend-pgxs.html
11761 bytes
0644
extend-type-system.html
10111 bytes
0644
extend.html
9982 bytes
0644
external-admin-tools.html
2722 bytes
0644
external-extensions.html
3263 bytes
0644
external-interfaces.html
5513 bytes
0644
external-pl.html
4670 bytes
0644
external-projects.html
3004 bytes
0644
fdw-callbacks.html
12905 bytes
0644
fdw-functions.html
4496 bytes
0644
fdw-helpers.html
5988 bytes
0644
fdw-planning.html
9845 bytes
0644
fdwhandler.html
3990 bytes
0644
features-sql-standard.html
39105 bytes
0644
features.html
7566 bytes
0644
file-fdw.html
7709 bytes
0644
functions-admin.html
50395 bytes
0644
functions-aggregate.html
21814 bytes
0644
functions-array.html
13521 bytes
0644
functions-binarystring.html
12588 bytes
0644
functions-bitstring.html
6786 bytes
0644
functions-comparison.html
10638 bytes
0644
functions-comparisons.html
13531 bytes
0644
functions-conditional.html
11007 bytes
0644
functions-datetime.html
48303 bytes
0644
functions-enum.html
5491 bytes
0644
functions-formatting.html
35401 bytes
0644
functions-geometry.html
20347 bytes
0644
functions-info.html
58658 bytes
0644
functions-json.html
3814 bytes
0644
functions-logical.html
4665 bytes
0644
functions-matching.html
75728 bytes
0644
functions-math.html
20401 bytes
0644
functions-net.html
13502 bytes
0644
functions-range.html
10857 bytes
0644
functions-sequence.html
12925 bytes
0644
functions-srf.html
8840 bytes
0644
functions-string.html
59052 bytes
0644
functions-subquery.html
16381 bytes
0644
functions-textsearch.html
20488 bytes
0644
functions-trigger.html
4548 bytes
0644
functions-window.html
12085 bytes
0644
functions-xml.html
32169 bytes
0644
functions.html
9939 bytes
0644
fuzzystrmatch.html
8061 bytes
0644
geqo-biblio.html
3459 bytes
0644
geqo-intro.html
4415 bytes
0644
geqo-intro2.html
5627 bytes
0644
geqo-pg-intro.html
8785 bytes
0644
geqo.html
3616 bytes
0644
gin-examples.html
3322 bytes
0644
gin-extensibility.html
14402 bytes
0644
gin-implementation.html
6564 bytes
0644
gin-intro.html
4662 bytes
0644
gin-limit.html
2817 bytes
0644
gin-tips.html
5713 bytes
0644
gin.html
2929 bytes
0644
gist-examples.html
3752 bytes
0644
gist-extensibility.html
24354 bytes
0644
gist-implementation.html
4101 bytes
0644
gist-intro.html
3616 bytes
0644
gist.html
2679 bytes
0644
git.html
4564 bytes
0644
high-availability.html
7698 bytes
0644
history.html
11918 bytes
0644
hot-standby.html
36045 bytes
0644
hstore.html
22629 bytes
0644
index-catalog.html
7996 bytes
0644
index-cost-estimation.html
9991 bytes
0644
index-functions.html
19114 bytes
0644
index-locking.html
8049 bytes
0644
index-scanning.html
10707 bytes
0644
index-unique-checks.html
9192 bytes
0644
index.html
8071 bytes
0644
indexam.html
5247 bytes
0644
indexes-bitmap-scans.html
6580 bytes
0644
indexes-collations.html
3640 bytes
0644
indexes-examine.html
7161 bytes
0644
indexes-expressional.html
4813 bytes
0644
indexes-intro.html
6313 bytes
0644
indexes-multicolumn.html
6298 bytes
0644
indexes-opclass.html
7336 bytes
0644
indexes-ordering.html
6480 bytes
0644
indexes-partial.html
11812 bytes
0644
indexes-types.html
10233 bytes
0644
indexes-unique.html
4002 bytes
0644
indexes.html
3619 bytes
0644
information-schema.html
11177 bytes
0644
infoschema-administrable-role-authorizations.html
3751 bytes
0644
infoschema-applicable-roles.html
3970 bytes
0644
infoschema-attributes.html
12807 bytes
0644
infoschema-character-sets.html
7050 bytes
0644
infoschema-check-constraint-routine-usage.html
4349 bytes
0644
infoschema-check-constraints.html
3876 bytes
0644
infoschema-collation-character-set-applicab.html
4425 bytes
0644
infoschema-collations.html
3885 bytes
0644
infoschema-column-domain-usage.html
4322 bytes
0644
infoschema-column-options.html
4109 bytes
0644
infoschema-column-privileges.html
5029 bytes
0644
infoschema-column-udt-usage.html
4583 bytes
0644
infoschema-columns.html
17625 bytes
0644
infoschema-constraint-column-usage.html
4873 bytes
0644
infoschema-constraint-table-usage.html
4774 bytes
0644
infoschema-data-type-privileges.html
5089 bytes
0644
infoschema-datatypes.html
4229 bytes
0644
infoschema-domain-constraints.html
4664 bytes
0644
infoschema-domain-udt-usage.html
4171 bytes
0644
infoschema-domains.html
11367 bytes
0644
infoschema-element-types.html
11374 bytes
0644
infoschema-enabled-roles.html
3780 bytes
0644
infoschema-foreign-data-wrapper-options.html
3910 bytes
0644
infoschema-foreign-data-wrappers.html
4227 bytes
0644
infoschema-foreign-server-options.html
3853 bytes
0644
infoschema-foreign-servers.html
4571 bytes
0644
infoschema-foreign-table-options.html
3974 bytes
0644
infoschema-foreign-tables.html
4072 bytes
0644
infoschema-information-schema-catalog-name.html
3357 bytes
0644
infoschema-key-column-usage.html
5185 bytes
0644
infoschema-parameters.html
10799 bytes
0644
infoschema-referential-constraints.html
5664 bytes
0644
infoschema-role-column-grants.html
5017 bytes
0644
infoschema-role-routine-grants.html
5360 bytes
0644
infoschema-role-table-grants.html
5427 bytes
0644
infoschema-role-udt-grants.html
4781 bytes
0644
infoschema-role-usage-grants.html
5010 bytes
0644
infoschema-routine-privileges.html
5032 bytes
0644
infoschema-routines.html
23052 bytes
0644
infoschema-schema.html
3180 bytes
0644
infoschema-schemata.html
4248 bytes
0644
infoschema-sequences.html
6111 bytes
0644
infoschema-sql-features.html
4708 bytes
0644
infoschema-sql-implementation-info.html
4503 bytes
0644
infoschema-sql-languages.html
5094 bytes
0644
infoschema-sql-packages.html
4178 bytes
0644
infoschema-sql-parts.html
4080 bytes
0644
infoschema-sql-sizing-profiles.html
4177 bytes
0644
infoschema-sql-sizing.html
4101 bytes
0644
infoschema-table-constraints.html
4914 bytes
0644
infoschema-table-privileges.html
5097 bytes
0644
infoschema-tables.html
5957 bytes
0644
infoschema-triggered-update-columns.html
4554 bytes
0644
infoschema-triggers.html
9447 bytes
0644
infoschema-udt-privileges.html
4509 bytes
0644
infoschema-usage-privileges.html
5512 bytes
0644
infoschema-user-defined-types.html
9753 bytes
0644
infoschema-user-mapping-options.html
4449 bytes
0644
infoschema-user-mappings.html
3833 bytes
0644
infoschema-view-column-usage.html
4728 bytes
0644
infoschema-view-routine-usage.html
4368 bytes
0644
infoschema-view-table-usage.html
4389 bytes
0644
infoschema-views.html
5529 bytes
0644
install-getsource.html
3574 bytes
0644
install-post.html
8076 bytes
0644
install-procedure.html
46527 bytes
0644
install-requirements.html
14481 bytes
0644
install-short.html
2870 bytes
0644
install-windows-full.html
19274 bytes
0644
install-windows-libpq.html
6283 bytes
0644
install-windows.html
6620 bytes
0644
installation-platform-notes.html
39380 bytes
0644
installation.html
4160 bytes
0644
intagg.html
6254 bytes
0644
intarray.html
13757 bytes
0644
internals.html
15638 bytes
0644
intro-whatis.html
4011 bytes
0644
isn.html
13356 bytes
0644
kernel-resources.html
37822 bytes
0644
largeobjects.html
4675 bytes
0644
libpq-async.html
21020 bytes
0644
libpq-build.html
6369 bytes
0644
libpq-cancel.html
6777 bytes
0644
libpq-connect.html
51248 bytes
0644
libpq-control.html
6280 bytes
0644
libpq-copy.html
22442 bytes
0644
libpq-envars.html
9820 bytes
0644
libpq-events.html
23093 bytes
0644
libpq-example.html
16024 bytes
0644
libpq-exec.html
64877 bytes
0644
libpq-fastpath.html
6124 bytes
0644
libpq-ldap.html
5506 bytes
0644
libpq-misc.html
13815 bytes
0644
libpq-notice-processing.html
6284 bytes
0644
libpq-notify.html
6715 bytes
0644
libpq-pgpass.html
4861 bytes
0644
libpq-pgservice.html
3905 bytes
0644
libpq-single-row-mode.html
6353 bytes
0644
libpq-ssl.html
19972 bytes
0644
libpq-status.html
17695 bytes
0644
libpq-threading.html
5544 bytes
0644
libpq.html
7918 bytes
0644
lo-examplesect.html
8696 bytes
0644
lo-funcs.html
4640 bytes
0644
lo-implementation.html
3353 bytes
0644
lo-interfaces.html
15155 bytes
0644
lo-intro.html
3206 bytes
0644
lo.html
6627 bytes
0644
locale.html
13691 bytes
0644
locking-indexes.html
4350 bytes
0644
log-shipping-alternative.html
11057 bytes
0644
logfile-maintenance.html
7143 bytes
0644
ltree.html
27295 bytes
0644
maintenance.html
5538 bytes
0644
manage-ag-config.html
3746 bytes
0644
manage-ag-createdb.html
6310 bytes
0644
manage-ag-dropdb.html
3605 bytes
0644
manage-ag-overview.html
5144 bytes
0644
manage-ag-tablespaces.html
9250 bytes
0644
manage-ag-templatedbs.html
8162 bytes
0644
managing-databases.html
3273 bytes
0644
monitoring-locks.html
3673 bytes
0644
monitoring-ps.html
6782 bytes
0644
monitoring-stats.html
58063 bytes
0644
monitoring.html
4458 bytes
0644
multibyte.html
31965 bytes
0644
mvcc-caveats.html
4077 bytes
0644
mvcc-intro.html
4552 bytes
0644
mvcc.html
4302 bytes
0644
nls-programmer.html
10078 bytes
0644
nls-translator.html
14522 bytes
0644
nls.html
3134 bytes
0644
non-durability.html
4484 bytes
0644
notation.html
4415 bytes
0644
oid2name.html
11962 bytes
0644
overview.html
4093 bytes
0644
pageinspect.html
8117 bytes
0644
parser-stage.html
8117 bytes
0644
passwordcheck.html
4788 bytes
0644
performance-tips.html
4501 bytes
0644
perm-functions.html
3338 bytes
0644
pgarchivecleanup.html
8999 bytes
0644
pgbench.html
30833 bytes
0644
pgbuffercache.html
7715 bytes
0644
pgcrypto.html
38804 bytes
0644
pgfreespacemap.html
5230 bytes
0644
pgrowlocks.html
6078 bytes
0644
pgstandby.html
15204 bytes
0644
pgstatstatements.html
16068 bytes
0644
pgstattuple.html
9449 bytes
0644
pgtestfsync.html
5254 bytes
0644
pgtesttiming.html
12476 bytes
0644
pgtrgm.html
12333 bytes
0644
pgupgrade.html
24737 bytes
0644
planner-optimizer.html
9396 bytes
0644
planner-stats-details.html
3276 bytes
0644
planner-stats-security.html
5556 bytes
0644
planner-stats.html
9058 bytes
0644
plhandler.html
13748 bytes
0644
plperl-builtins.html
18276 bytes
0644
plperl-data.html
2878 bytes
0644
plperl-funcs.html
13369 bytes
0644
plperl-global.html
5067 bytes
0644
plperl-triggers.html
6446 bytes
0644
plperl-trusted.html
6712 bytes
0644
plperl-under-the-hood.html
8991 bytes
0644
plperl.html
4930 bytes
0644
plpgsql-control-structures.html
46183 bytes
0644
plpgsql-cursors.html
25586 bytes
0644
plpgsql-declarations.html
21746 bytes
0644
plpgsql-development-tips.html
9511 bytes
0644
plpgsql-errors-and-messages.html
10094 bytes
0644
plpgsql-expressions.html
4662 bytes
0644
plpgsql-implementation.html
18043 bytes
0644
plpgsql-overview.html
9032 bytes
0644
plpgsql-porting.html
27094 bytes
0644
plpgsql-statements.html
32221 bytes
0644
plpgsql-structure.html
8329 bytes
0644
plpgsql-trigger.html
22322 bytes
0644
plpgsql.html
6965 bytes
0644
plpython-data.html
14648 bytes
0644
plpython-database.html
15413 bytes
0644
plpython-do.html
2771 bytes
0644
plpython-envar.html
3885 bytes
0644
plpython-funcs.html
5478 bytes
0644
plpython-python23.html
7207 bytes
0644
plpython-sharing.html
3032 bytes
0644
plpython-subtransaction.html
7888 bytes
0644
plpython-trigger.html
5069 bytes
0644
plpython-util.html
5104 bytes
0644
plpython.html
6067 bytes
0644
pltcl-data.html
2906 bytes
0644
pltcl-dbaccess.html
13902 bytes
0644
pltcl-functions.html
6177 bytes
0644
pltcl-global.html
5066 bytes
0644
pltcl-overview.html
5288 bytes
0644
pltcl-procnames.html
3222 bytes
0644
pltcl-trigger.html
9452 bytes
0644
pltcl-unknown.html
5075 bytes
0644
pltcl.html
3400 bytes
0644
populate.html
17114 bytes
0644
postgres-user.html
3314 bytes
0644
preface.html
5070 bytes
0644
preventing-server-spoofing.html
4604 bytes
0644
protocol-changes.html
6650 bytes
0644
protocol-error-fields.html
6131 bytes
0644
protocol-flow.html
46202 bytes
0644
protocol-message-formats.html
40844 bytes
0644
protocol-message-types.html
4933 bytes
0644
protocol-overview.html
9670 bytes
0644
protocol-replication.html
14666 bytes
0644
protocol.html
5652 bytes
0644
queries-limit.html
5335 bytes
0644
queries-order.html
7369 bytes
0644
queries-overview.html
5068 bytes
0644
queries-select-lists.html
9308 bytes
0644
queries-table-expressions.html
39874 bytes
0644
queries-union.html
5114 bytes
0644
queries-values.html
4930 bytes
0644
queries-with.html
20880 bytes
0644
queries.html
4418 bytes
0644
query-path.html
5470 bytes
0644
querytree.html
11136 bytes
0644
rangetypes.html
22735 bytes
0644
recovery-config.html
3550 bytes
0644
recovery-target-settings.html
7762 bytes
0644
reference-client.html
6102 bytes
0644
reference-server.html
3964 bytes
0644
reference.html
23162 bytes
0644
regress-coverage.html
3325 bytes
0644
regress-evaluation.html
12487 bytes
0644
regress-run.html
13710 bytes
0644
regress-variant.html
7177 bytes
0644
regress.html
4277 bytes
0644
release-0-01.html
2555 bytes
0644
release-0-02.html
4292 bytes
0644
release-0-03.html
7798 bytes
0644
release-1-0.html
4229 bytes
0644
release-1-01.html
9346 bytes
0644
release-1-02.html
6489 bytes
0644
release-1-09.html
2525 bytes
0644
release-6-0.html
7920 bytes
0644
release-6-1-1.html
3719 bytes
0644
release-6-1.html
9025 bytes
0644
release-6-2-1.html
4405 bytes
0644
release-6-2.html
8883 bytes
0644
release-6-3-1.html
4444 bytes
0644
release-6-3-2.html
4157 bytes
0644
release-6-3.html
16311 bytes
0644
release-6-4-1.html
4061 bytes
0644
release-6-4-2.html
2908 bytes
0644
release-6-4.html
14732 bytes
0644
release-6-5-1.html
3842 bytes
0644
release-6-5-2.html
4102 bytes
0644
release-6-5-3.html
3053 bytes
0644
release-6-5.html
17387 bytes
0644
release-7-0-1.html
3920 bytes
0644
release-7-0-2.html
2887 bytes
0644
release-7-0-3.html
4656 bytes
0644
release-7-0.html
23104 bytes
0644
release-7-1-1.html
3262 bytes
0644
release-7-1-2.html
2975 bytes
0644
release-7-1-3.html
3139 bytes
0644
release-7-1.html
13017 bytes
0644
release-7-2-1.html
4011 bytes
0644
release-7-2-2.html
3793 bytes
0644
release-7-2-3.html
3364 bytes
0644
release-7-2-4.html
3587 bytes
0644
release-7-2-5.html
3746 bytes
0644
release-7-2-6.html
3624 bytes
0644
release-7-2-7.html
3726 bytes
0644
release-7-2-8.html
3948 bytes
0644
release-7-2.html
27098 bytes
0644
release-7-3-1.html
4168 bytes
0644
release-7-3-10.html
7493 bytes
0644
release-7-3-11.html
4111 bytes
0644
release-7-3-12.html
3527 bytes
0644
release-7-3-13.html
4618 bytes
0644
release-7-3-14.html
3931 bytes
0644
release-7-3-15.html
6315 bytes
0644
release-7-3-16.html
3424 bytes
0644
release-7-3-17.html
3550 bytes
0644
release-7-3-18.html
3647 bytes
0644
release-7-3-19.html
3686 bytes
0644
release-7-3-2.html
5205 bytes
0644
release-7-3-20.html
3524 bytes
0644
release-7-3-21.html
6216 bytes
0644
release-7-3-3.html
10290 bytes
0644
release-7-3-4.html
3502 bytes
0644
release-7-3-5.html
4493 bytes
0644
release-7-3-6.html
4428 bytes
0644
release-7-3-7.html
3352 bytes
0644
release-7-3-8.html
3571 bytes
0644
release-7-3-9.html
4079 bytes
0644
release-7-3.html
33053 bytes
0644
release-7-4-1.html
7116 bytes
0644
release-7-4-10.html
3806 bytes
0644
release-7-4-11.html
4857 bytes
0644
release-7-4-12.html
4221 bytes
0644
release-7-4-13.html
6961 bytes
0644
release-7-4-14.html
3673 bytes
0644
release-7-4-15.html
4270 bytes
0644
release-7-4-16.html
3972 bytes
0644
release-7-4-17.html
4013 bytes
0644
release-7-4-18.html
3927 bytes
0644
release-7-4-19.html
7242 bytes
0644
release-7-4-2.html
8260 bytes
0644
release-7-4-20.html
6605 bytes
0644
release-7-4-21.html
3922 bytes
0644
release-7-4-22.html
4071 bytes
0644
release-7-4-23.html
4423 bytes
0644
release-7-4-24.html
4289 bytes
0644
release-7-4-25.html
4506 bytes
0644
release-7-4-26.html
5455 bytes
0644
release-7-4-27.html
5164 bytes
0644
release-7-4-28.html
5629 bytes
0644
release-7-4-29.html
6960 bytes
0644
release-7-4-3.html
4615 bytes
0644
release-7-4-30.html
6211 bytes
0644
release-7-4-4.html
4085 bytes
0644
release-7-4-5.html
3194 bytes
0644
release-7-4-6.html
4731 bytes
0644
release-7-4-7.html
4274 bytes
0644
release-7-4-8.html
10156 bytes
0644
release-7-4-9.html
5118 bytes
0644
release-7-4.html
57378 bytes
0644
release-8-0-1.html
4744 bytes
0644
release-8-0-10.html
4751 bytes
0644
release-8-0-11.html
3969 bytes
0644
release-8-0-12.html
3134 bytes
0644
release-8-0-13.html
4118 bytes
0644
release-8-0-14.html
4518 bytes
0644
release-8-0-15.html
9101 bytes
0644
release-8-0-16.html
8946 bytes
0644
release-8-0-17.html
3920 bytes
0644
release-8-0-18.html
5579 bytes
0644
release-8-0-19.html
4976 bytes
0644
release-8-0-2.html
9566 bytes
0644
release-8-0-20.html
4312 bytes
0644
release-8-0-21.html
4504 bytes
0644
release-8-0-22.html
6440 bytes
0644
release-8-0-23.html
6023 bytes
0644
release-8-0-24.html
7002 bytes
0644
release-8-0-25.html
7427 bytes
0644
release-8-0-26.html
8026 bytes
0644
release-8-0-3.html
7425 bytes
0644
release-8-0-4.html
6680 bytes
0644
release-8-0-5.html
4816 bytes
0644
release-8-0-6.html
5694 bytes
0644
release-8-0-7.html
5909 bytes
0644
release-8-0-8.html
7225 bytes
0644
release-8-0-9.html
4306 bytes
0644
release-8-0.html
66818 bytes
0644
release-8-1-1.html
5459 bytes
0644
release-8-1-10.html
4781 bytes
0644
release-8-1-11.html
9946 bytes
0644
release-8-1-12.html
9341 bytes
0644
release-8-1-13.html
4292 bytes
0644
release-8-1-14.html
6901 bytes
0644
release-8-1-15.html
6274 bytes
0644
release-8-1-16.html
5278 bytes
0644
release-8-1-17.html
6035 bytes
0644
release-8-1-18.html
6442 bytes
0644
release-8-1-19.html
6612 bytes
0644
release-8-1-2.html
6335 bytes
0644
release-8-1-20.html
7298 bytes
0644
release-8-1-21.html
7213 bytes
0644
release-8-1-22.html
8324 bytes
0644
release-8-1-23.html
7933 bytes
0644
release-8-1-3.html
7026 bytes
0644
release-8-1-4.html
8873 bytes
0644
release-8-1-5.html
5479 bytes
0644
release-8-1-6.html
5337 bytes
0644
release-8-1-7.html
4558 bytes
0644
release-8-1-8.html
3116 bytes
0644
release-8-1-9.html
4388 bytes
0644
release-8-1.html
62113 bytes
0644
release-8-2-1.html
5065 bytes
0644
release-8-2-10.html
8180 bytes
0644
release-8-2-11.html
7147 bytes
0644
release-8-2-12.html
6748 bytes
0644
release-8-2-13.html
7348 bytes
0644
release-8-2-14.html
7876 bytes
0644
release-8-2-15.html
8155 bytes
0644
release-8-2-16.html
9293 bytes
0644
release-8-2-17.html
8214 bytes
0644
release-8-2-18.html
10277 bytes
0644
release-8-2-19.html
8589 bytes
0644
release-8-2-2.html
5802 bytes
0644
release-8-2-20.html
6244 bytes
0644
release-8-2-21.html
5593 bytes
0644
release-8-2-22.html
9617 bytes
0644
release-8-2-23.html
9559 bytes
0644
release-8-2-3.html
3095 bytes
0644
release-8-2-4.html
5428 bytes
0644
release-8-2-5.html
5995 bytes
0644
release-8-2-6.html
10551 bytes
0644
release-8-2-7.html
9311 bytes
0644
release-8-2-8.html
7521 bytes
0644
release-8-2-9.html
4281 bytes
0644
release-8-2.html
69398 bytes
0644
release-8-3-1.html
10585 bytes
0644
release-8-3-10.html
10725 bytes
0644
release-8-3-11.html
8963 bytes
0644
release-8-3-12.html
12119 bytes
0644
release-8-3-13.html
9506 bytes
0644
release-8-3-14.html
6242 bytes
0644
release-8-3-15.html
6381 bytes
0644
release-8-3-16.html
11015 bytes
0644
release-8-3-17.html
10590 bytes
0644
release-8-3-18.html
11265 bytes
0644
release-8-3-19.html
8466 bytes
0644
release-8-3-2.html
12203 bytes
0644
release-8-3-20.html
9251 bytes
0644
release-8-3-21.html
5034 bytes
0644
release-8-3-22.html
10585 bytes
0644
release-8-3-23.html
6284 bytes
0644
release-8-3-3.html
4275 bytes
0644
release-8-3-4.html
11273 bytes
0644
release-8-3-5.html
8689 bytes
0644
release-8-3-6.html
9197 bytes
0644
release-8-3-7.html
9729 bytes
0644
release-8-3-8.html
9260 bytes
0644
release-8-3-9.html
10206 bytes
0644
release-8-3.html
69773 bytes
0644
release-8-4-1.html
9563 bytes
0644
release-8-4-10.html
11932 bytes
0644
release-8-4-11.html
13787 bytes
0644
release-8-4-12.html
9987 bytes
0644
release-8-4-13.html
9714 bytes
0644
release-8-4-14.html
5117 bytes
0644
release-8-4-15.html
10626 bytes
0644
release-8-4-16.html
7329 bytes
0644
release-8-4-17.html
9572 bytes
0644
release-8-4-18.html
7048 bytes
0644
release-8-4-19.html
7780 bytes
0644
release-8-4-2.html
15697 bytes
0644
release-8-4-20.html
16258 bytes
0644
release-8-4-21.html
5450 bytes
0644
release-8-4-22.html
11306 bytes
0644
release-8-4-3.html
13928 bytes
0644
release-8-4-4.html
10736 bytes
0644
release-8-4-5.html
15933 bytes
0644
release-8-4-6.html
10430 bytes
0644
release-8-4-7.html
6220 bytes
0644
release-8-4-8.html
8850 bytes
0644
release-8-4-9.html
14528 bytes
0644
release-8-4.html
87976 bytes
0644
release-9-0-1.html
5946 bytes
0644
release-9-0-10.html
5693 bytes
0644
release-9-0-11.html
12666 bytes
0644
release-9-0-12.html
8824 bytes
0644
release-9-0-13.html
11671 bytes
0644
release-9-0-14.html
8759 bytes
0644
release-9-0-15.html
9147 bytes
0644
release-9-0-16.html
17408 bytes
0644
release-9-0-17.html
6335 bytes
0644
release-9-0-18.html
11879 bytes
0644
release-9-0-19.html
26610 bytes
0644
release-9-0-2.html
13636 bytes
0644
release-9-0-20.html
15836 bytes
0644
release-9-0-21.html
5166 bytes
0644
release-9-0-22.html
4321 bytes
0644
release-9-0-23.html
16158 bytes
0644
release-9-0-3.html
7256 bytes
0644
release-9-0-4.html
11345 bytes
0644
release-9-0-5.html
17915 bytes
0644
release-9-0-6.html
13426 bytes
0644
release-9-0-7.html
18091 bytes
0644
release-9-0-8.html
10993 bytes
0644
release-9-0-9.html
11743 bytes
0644
release-9-0.html
96127 bytes
0644
release-9-1-1.html
3670 bytes
0644
release-9-1-10.html
10352 bytes
0644
release-9-1-11.html
9584 bytes
0644
release-9-1-12.html
18554 bytes
0644
release-9-1-13.html
6685 bytes
0644
release-9-1-14.html
13036 bytes
0644
release-9-1-15.html
28969 bytes
0644
release-9-1-16.html
19119 bytes
0644
release-9-1-17.html
4947 bytes
0644
release-9-1-18.html
4102 bytes
0644
release-9-1-19.html
17617 bytes
0644
release-9-1-2.html
21571 bytes
0644
release-9-1-20.html
17541 bytes
0644
release-9-1-21.html
7601 bytes
0644
release-9-1-22.html
7258 bytes
0644
release-9-1-23.html
12653 bytes
0644
release-9-1-24.html
8731 bytes
0644
release-9-1-3.html
21153 bytes
0644
release-9-1-4.html
16018 bytes
0644
release-9-1-5.html
14042 bytes
0644
release-9-1-6.html
9521 bytes
0644
release-9-1-7.html
14941 bytes
0644
release-9-1-8.html
10154 bytes
0644
release-9-1-9.html
12679 bytes
0644
release-9-1.html
78963 bytes
0644
release-9-2-1.html
7111 bytes
0644
release-9-2-10.html
32368 bytes
0644
release-9-2-11.html
20298 bytes
0644
release-9-2-12.html
5130 bytes
0644
release-9-2-13.html
4102 bytes
0644
release-9-2-14.html
18386 bytes
0644
release-9-2-15.html
18605 bytes
0644
release-9-2-16.html
7598 bytes
0644
release-9-2-17.html
8195 bytes
0644
release-9-2-18.html
12718 bytes
0644
release-9-2-19.html
10514 bytes
0644
release-9-2-2.html
23001 bytes
0644
release-9-2-20.html
13332 bytes
0644
release-9-2-21.html
14198 bytes
0644
release-9-2-22.html
15865 bytes
0644
release-9-2-23.html
8126 bytes
0644
release-9-2-24.html
7877 bytes
0644
release-9-2-3.html
13373 bytes
0644
release-9-2-4.html
14800 bytes
0644
release-9-2-5.html
12005 bytes
0644
release-9-2-6.html
11684 bytes
0644
release-9-2-7.html
20022 bytes
0644
release-9-2-8.html
7375 bytes
0644
release-9-2-9.html
15615 bytes
0644
release-9-2.html
79519 bytes
0644
release.html
22882 bytes
0644
resources.html
4226 bytes
0644
role-attributes.html
7855 bytes
0644
role-membership.html
8390 bytes
0644
role-removal.html
5303 bytes
0644
routine-reindex.html
3628 bytes
0644
routine-vacuuming.html
38023 bytes
0644
row-estimation-examples.html
20767 bytes
0644
rowtypes.html
23412 bytes
0644
rule-system.html
4117 bytes
0644
rules-privileges.html
11663 bytes
0644
rules-status.html
4512 bytes
0644
rules-triggers.html
9476 bytes
0644
rules-update.html
32615 bytes
0644
rules-views.html
26888 bytes
0644
rules.html
4948 bytes
0644
runtime-config-autovacuum.html
10974 bytes
0644
runtime-config-client.html
32815 bytes
0644
runtime-config-compatible.html
14827 bytes
0644
runtime-config-connection.html
23478 bytes
0644
runtime-config-custom.html
3548 bytes
0644
runtime-config-developer.html
14070 bytes
0644
runtime-config-error-handling.html
3570 bytes
0644
runtime-config-file-locations.html
6977 bytes
0644
runtime-config-locks.html
7634 bytes
0644
runtime-config-logging.html
45446 bytes
0644
runtime-config-preset.html
8710 bytes
0644
runtime-config-query.html
24950 bytes
0644
runtime-config-replication.html
18294 bytes
0644
runtime-config-resource.html
27901 bytes
0644
runtime-config-short.html
6683 bytes
0644
runtime-config-statistics.html
8616 bytes
0644
runtime-config-wal.html
27093 bytes
0644
runtime-config.html
8249 bytes
0644
runtime.html
5241 bytes
0644
seg.html
15470 bytes
0644
sepgsql.html
30829 bytes
0644
server-programming.html
9618 bytes
0644
server-shutdown.html
6469 bytes
0644
server-start.html
14217 bytes
0644
source-format.html
5133 bytes
0644
source.html
4071 bytes
0644
sourcerepo.html
3411 bytes
0644
spgist-examples.html
2703 bytes
0644
spgist-extensibility.html
31282 bytes
0644
spgist-implementation.html
8098 bytes
0644
spgist-intro.html
4323 bytes
0644
spgist.html
2966 bytes
0644
spi-examples.html
6217 bytes
0644
spi-interface-support.html
3770 bytes
0644
spi-interface.html
5998 bytes
0644
spi-memory.html
7089 bytes
0644
spi-realloc.html
3627 bytes
0644
spi-spi-connect.html
4052 bytes
0644
spi-spi-copytuple.html
3453 bytes
0644
spi-spi-cursor-close.html
3336 bytes
0644
spi-spi-cursor-fetch.html
4110 bytes
0644
spi-spi-cursor-find.html
3464 bytes
0644
spi-spi-cursor-move.html
3890 bytes
0644
spi-spi-cursor-open-with-args.html
6178 bytes
0644
spi-spi-cursor-open-with-paramlist.html
5035 bytes
0644
spi-spi-cursor-open.html
5732 bytes
0644
spi-spi-exec.html
3591 bytes
0644
spi-spi-execp.html
4866 bytes
0644
spi-spi-execute-plan-with-paramlist.html
4893 bytes
0644
spi-spi-execute-plan.html
5901 bytes
0644
spi-spi-execute-with-args.html
6221 bytes
0644
spi-spi-execute.html
12598 bytes
0644
spi-spi-finish.html
3655 bytes
0644
spi-spi-fname.html
3767 bytes
0644
spi-spi-fnumber.html
3936 bytes
0644
spi-spi-freeplan.html
3505 bytes
0644
spi-spi-freetuple.html
3277 bytes
0644
spi-spi-freetupletable.html
3628 bytes
0644
spi-spi-getargcount.html
3698 bytes
0644
spi-spi-getargtypeid.html
4141 bytes
0644
spi-spi-getbinval.html
4287 bytes
0644
spi-spi-getnspname.html
3467 bytes
0644
spi-spi-getrelname.html
3351 bytes
0644
spi-spi-gettype.html
3714 bytes
0644
spi-spi-gettypeid.html
3718 bytes
0644
spi-spi-getvalue.html
4166 bytes
0644
spi-spi-is-cursor-plan.html
4560 bytes
0644
spi-spi-keepplan.html
3884 bytes
0644
spi-spi-modifytuple.html
5631 bytes
0644
spi-spi-palloc.html
3157 bytes
0644
spi-spi-pfree.html
3275 bytes
0644
spi-spi-pop.html
2743 bytes
0644
spi-spi-prepare-cursor.html
5055 bytes
0644
spi-spi-prepare-params.html
4412 bytes
0644
spi-spi-prepare.html
7661 bytes
0644
spi-spi-push.html
3737 bytes
0644
spi-spi-returntuple.html
4097 bytes
0644
spi-spi-saveplan.html
4576 bytes
0644
spi-spi-scroll-cursor-fetch.html
4809 bytes
0644
spi-spi-scroll-cursor-move.html
4899 bytes
0644
spi-visibility.html
4152 bytes
0644
spi.html
10843 bytes
0644
sql-abort.html
4177 bytes
0644
sql-alteraggregate.html
6111 bytes
0644
sql-altercollation.html
5084 bytes
0644
sql-alterconversion.html
5170 bytes
0644
sql-alterdatabase.html
8778 bytes
0644
sql-alterdefaultprivileges.html
9407 bytes
0644
sql-alterdomain.html
11113 bytes
0644
sql-alterextension.html
11745 bytes
0644
sql-alterforeigndatawrapper.html
7378 bytes
0644
sql-alterforeigntable.html
12707 bytes
0644
sql-alterfunction.html
12845 bytes
0644
sql-altergroup.html
5239 bytes
0644
sql-alterindex.html
7655 bytes
0644
sql-alterlanguage.html
4022 bytes
0644
sql-alterlargeobject.html
3730 bytes
0644
sql-alteropclass.html
5114 bytes
0644
sql-alteroperator.html
5435 bytes
0644
sql-alteropfamily.html
13564 bytes
0644
sql-alterrole.html
13028 bytes
0644
sql-alterschema.html
4314 bytes
0644
sql-altersequence.html
13031 bytes
0644
sql-alterserver.html
5928 bytes
0644
sql-altertable.html
43543 bytes
0644
sql-altertablespace.html
5866 bytes
0644
sql-altertrigger.html
4647 bytes
0644
sql-altertsconfig.html
8126 bytes
0644
sql-altertsdictionary.html
6539 bytes
0644
sql-altertsparser.html
4257 bytes
0644
sql-altertstemplate.html
4223 bytes
0644
sql-altertype.html
11193 bytes
0644
sql-alteruser.html
4720 bytes
0644
sql-alterusermapping.html
5714 bytes
0644
sql-alterview.html
6969 bytes
0644
sql-analyze.html
10674 bytes
0644
sql-begin.html
6695 bytes
0644
sql-checkpoint.html
3758 bytes
0644
sql-close.html
4984 bytes
0644
sql-cluster.html
9404 bytes
0644
sql-commands.html
18810 bytes
0644
sql-comment.html
13799 bytes
0644
sql-commit-prepared.html
4516 bytes
0644
sql-commit.html
3992 bytes
0644
sql-copy.html
37443 bytes
0644
sql-createaggregate.html
13829 bytes
0644
sql-createcast.html
19632 bytes
0644
sql-createcollation.html
6739 bytes
0644
sql-createconversion.html
6538 bytes
0644
sql-createdatabase.html
12133 bytes
0644
sql-createdomain.html
8544 bytes
0644
sql-createextension.html
9083 bytes
0644
sql-createforeigndatawrapper.html
8059 bytes
0644
sql-createforeigntable.html
7718 bytes
0644
sql-createfunction.html
31076 bytes
0644
sql-creategroup.html
4012 bytes
0644
sql-createindex.html
25934 bytes
0644
sql-createlanguage.html
14888 bytes
0644
sql-createopclass.html
12676 bytes
0644
sql-createoperator.html
10688 bytes
0644
sql-createopfamily.html
5626 bytes
0644
sql-createrole.html
19325 bytes
0644
sql-createrule.html
12656 bytes
0644
sql-createschema.html
8319 bytes
0644
sql-createsequence.html
13862 bytes
0644
sql-createserver.html
6251 bytes
0644
sql-createtable.html
59172 bytes
0644
sql-createtableas.html
12772 bytes
0644
sql-createtablespace.html
6104 bytes
0644
sql-createtrigger.html
23175 bytes
0644
sql-createtsconfig.html
5352 bytes
0644
sql-createtsdictionary.html
5533 bytes
0644
sql-createtsparser.html
5947 bytes
0644
sql-createtstemplate.html
5437 bytes
0644
sql-createtype.html
39460 bytes
0644
sql-createuser.html
4524 bytes
0644
sql-createusermapping.html
5503 bytes
0644
sql-createview.html
10556 bytes
0644
sql-deallocate.html
3785 bytes
0644
sql-declare.html
15400 bytes
0644
sql-delete.html
11777 bytes
0644
sql-discard.html
4309 bytes
0644
sql-do.html
5204 bytes
0644
sql-drop-owned.html
5058 bytes
0644
sql-dropaggregate.html
4561 bytes
0644
sql-dropcast.html
4344 bytes
0644
sql-dropcollation.html
4409 bytes
0644
sql-dropconversion.html
4437 bytes
0644
sql-dropdatabase.html
4344 bytes
0644
sql-dropdomain.html
4257 bytes
0644
sql-dropextension.html
4785 bytes
0644
sql-dropforeigndatawrapper.html
4526 bytes
0644
sql-dropforeigntable.html
4560 bytes
0644
sql-dropfunction.html
5838 bytes
0644
sql-dropgroup.html
3047 bytes
0644
sql-dropindex.html
5182 bytes
0644
sql-droplanguage.html
4841 bytes
0644
sql-dropopclass.html
5678 bytes
0644
sql-dropoperator.html
5222 bytes
0644
sql-dropopfamily.html
5279 bytes
0644
sql-droprole.html
5158 bytes
0644
sql-droprule.html
4151 bytes
0644
sql-dropschema.html
4529 bytes
0644
sql-dropsequence.html
4367 bytes
0644
sql-dropserver.html
4265 bytes
0644
sql-droptable.html
5028 bytes
0644
sql-droptablespace.html
4585 bytes
0644
sql-droptrigger.html
4711 bytes
0644
sql-droptsconfig.html
4772 bytes
0644
sql-droptsdictionary.html
4689 bytes
0644
sql-droptsparser.html
4595 bytes
0644
sql-droptstemplate.html
4567 bytes
0644
sql-droptype.html
4463 bytes
0644
sql-dropuser.html
3181 bytes
0644
sql-dropusermapping.html
4679 bytes
0644
sql-dropview.html
4262 bytes
0644
sql-end.html
4157 bytes
0644
sql-execute.html
5073 bytes
0644
sql-explain.html
17094 bytes
0644
sql-expressions.html
47801 bytes
0644
sql-fetch.html
14251 bytes
0644
sql-grant.html
29245 bytes
0644
sql-insert.html
12860 bytes
0644
sql-keywords-appendix.html
106534 bytes
0644
sql-listen.html
5903 bytes
0644
sql-load.html
4207 bytes
0644
sql-lock.html
11869 bytes
0644
sql-move.html
4984 bytes
0644
sql-notify.html
10948 bytes
0644
sql-prepare-transaction.html
8640 bytes
0644
sql-prepare.html
9181 bytes
0644
sql-reassign-owned.html
5344 bytes
0644
sql-reindex.html
11103 bytes
0644
sql-release-savepoint.html
5005 bytes
0644
sql-reset.html
4993 bytes
0644
sql-revoke.html
14879 bytes
0644
sql-rollback-prepared.html
4627 bytes
0644
sql-rollback-to.html
6401 bytes
0644
sql-rollback.html
3996 bytes
0644
sql-savepoint.html
5605 bytes
0644
sql-security-label.html
8879 bytes
0644
sql-select.html
79544 bytes
0644
sql-selectinto.html
7634 bytes
0644
sql-set-constraints.html
7068 bytes
0644
sql-set-role.html
6915 bytes
0644
sql-set-session-authorization.html
6062 bytes
0644
sql-set-transaction.html
12696 bytes
0644
sql-set.html
12057 bytes
0644
sql-show.html
6851 bytes
0644
sql-start-transaction.html
4983 bytes
0644
sql-syntax-calling-funcs.html
8080 bytes
0644
sql-syntax-lexical.html
43370 bytes
0644
sql-syntax.html
5430 bytes
0644
sql-truncate.html
9364 bytes
0644
sql-unlisten.html
4923 bytes
0644
sql-update.html
15669 bytes
0644
sql-vacuum.html
10669 bytes
0644
sql-values.html
10640 bytes
0644
sql.html
13569 bytes
0644
ssh-tunnels.html
6263 bytes
0644
ssl-tcp.html
13477 bytes
0644
sslinfo.html
7594 bytes
0644
standby-settings.html
5427 bytes
0644
storage-file-layout.html
12936 bytes
0644
storage-fsm.html
3821 bytes
0644
storage-init.html
2760 bytes
0644
storage-page-layout.html
13891 bytes
0644
storage-toast.html
11478 bytes
0644
storage-vm.html
3540 bytes
0644
storage.html
2952 bytes
0644
stylesheet.css
1538 bytes
0644
supported-platforms.html
5042 bytes
0644
tablefunc.html
32193 bytes
0644
tcn.html
4974 bytes
0644
test-parser.html
4530 bytes
0644
textsearch-configuration.html
6257 bytes
0644
textsearch-controls.html
26966 bytes
0644
textsearch-debugging.html
17227 bytes
0644
textsearch-dictionaries.html
31261 bytes
0644
textsearch-features.html
21310 bytes
0644
textsearch-indexes.html
7387 bytes
0644
textsearch-intro.html
18453 bytes
0644
textsearch-limitations.html
3859 bytes
0644
textsearch-migration.html
5034 bytes
0644
textsearch-parsers.html
9210 bytes
0644
textsearch-psql.html
9345 bytes
0644
textsearch-tables.html
9750 bytes
0644
textsearch.html
5878 bytes
0644
transaction-iso.html
27240 bytes
0644
trigger-datachanges.html
5072 bytes
0644
trigger-definition.html
15507 bytes
0644
trigger-example.html
7749 bytes
0644
trigger-interface.html
10719 bytes
0644
triggers.html
3798 bytes
0644
tsearch2.html
9950 bytes
0644
tutorial-accessdb.html
7040 bytes
0644
tutorial-advanced-intro.html
3341 bytes
0644
tutorial-advanced.html
2856 bytes
0644
tutorial-agg.html
7594 bytes
0644
tutorial-arch.html
4852 bytes
0644
tutorial-concepts.html
3839 bytes
0644
tutorial-conclusion.html
2849 bytes
0644
tutorial-createdb.html
9200 bytes
0644
tutorial-delete.html
3517 bytes
0644
tutorial-fk.html
4422 bytes
0644
tutorial-inheritance.html
6137 bytes
0644
tutorial-install.html
4522 bytes
0644
tutorial-join.html
9685 bytes
0644
tutorial-populate.html
4839 bytes
0644
tutorial-select.html
8033 bytes
0644
tutorial-sql-intro.html
4904 bytes
0644
tutorial-sql.html
3060 bytes
0644
tutorial-start.html
2629 bytes
0644
tutorial-table.html
5704 bytes
0644
tutorial-transactions.html
9948 bytes
0644
tutorial-update.html
3159 bytes
0644
tutorial-views.html
3375 bytes
0644
tutorial-window.html
12481 bytes
0644
tutorial.html
5209 bytes
0644
typeconv-func.html
12170 bytes
0644
typeconv-oper.html
14907 bytes
0644
typeconv-overview.html
8301 bytes
0644
typeconv-query.html
5450 bytes
0644
typeconv-union-case.html
6612 bytes
0644
typeconv.html
3721 bytes
0644
unaccent.html
6742 bytes
0644
unsupported-features-sql-standard.html
35115 bytes
0644
upgrading.html
12795 bytes
0644
user-manag.html
3983 bytes
0644
using-explain.html
41824 bytes
0644
uuid-ossp.html
7228 bytes
0644
vacuumlo.html
7548 bytes
0644
view-pg-available-extension-versions.html
4642 bytes
0644
view-pg-available-extensions.html
3944 bytes
0644
view-pg-cursors.html
5669 bytes
0644
view-pg-group.html
3897 bytes
0644
view-pg-indexes.html
4155 bytes
0644
view-pg-locks.html
14444 bytes
0644
view-pg-prepared-statements.html
5060 bytes
0644
view-pg-prepared-xacts.html
4912 bytes
0644
view-pg-roles.html
6073 bytes
0644
view-pg-rules.html
3999 bytes
0644
view-pg-seclabels.html
5123 bytes
0644
view-pg-settings.html
10600 bytes
0644
view-pg-shadow.html
5381 bytes
0644
view-pg-stats.html
8887 bytes
0644
view-pg-tables.html
4836 bytes
0644
view-pg-timezone-abbrevs.html
3860 bytes
0644
view-pg-timezone-names.html
4177 bytes
0644
view-pg-user-mappings.html
5165 bytes
0644
view-pg-user.html
4517 bytes
0644
view-pg-views.html
3853 bytes
0644
views-overview.html
6542 bytes
0644
wal-async-commit.html
9016 bytes
0644
wal-configuration.html
14960 bytes
0644
wal-internals.html
6151 bytes
0644
wal-intro.html
5534 bytes
0644
wal-reliability.html
11479 bytes
0644
wal.html
2928 bytes
0644
warm-standby-failover.html
6102 bytes
0644
warm-standby.html
34646 bytes
0644
xaggr.html
9902 bytes
0644
xfunc-c.html
78520 bytes
0644
xfunc-internal.html
4004 bytes
0644
xfunc-overload.html
5911 bytes
0644
xfunc-pl.html
2991 bytes
0644
xfunc-sql.html
38027 bytes
0644
xfunc-volatility.html
9839 bytes
0644
xfunc.html
4518 bytes
0644
xindex.html
44593 bytes
0644
xml2.html
16900 bytes
0644
xoper-optimization.html
23144 bytes
0644
xoper.html
4835 bytes
0644
xplang-install.html
11127 bytes
0644
xplang.html
4235 bytes
0644
xtypes.html
12114 bytes
0644
N4ST4R_ID | Naxtarrr
