Submit
Path:
~
/
/
proc
/
thread-self
/
root
/
opt
/
alt
/
postgresql11
/
usr
/
share
/
doc
/
alt-postgresql11-9.2.24
/
html
/
File Content:
release-8-4.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >Release 8.4</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.4.1" HREF="release-8-4-1.html"><LINK REL="NEXT" TITLE="Release 8.3.23" HREF="release-8-3-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.4.1" HREF="release-8-4-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.3.23" HREF="release-8-3-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-4" >E.97. Release 8.4</A ></H1 ><DIV CLASS="FORMALPARA" ><P ><B >Release date: </B >2009-07-01</P ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="AEN127458" >E.97.1. Overview</A ></H2 ><P > After many years of development, <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > has become feature-complete in many areas. This release shows a targeted approach to adding features (e.g., authentication, monitoring, space reuse), and adds capabilities defined in the later SQL standards. The major areas of enhancement are: </P ><P ></P ><UL ><LI ><P > Windowing Functions </P ></LI ><LI ><P > Common Table Expressions and Recursive Queries </P ></LI ><LI ><P > Default and variadic parameters for functions </P ></LI ><LI ><P > Parallel Restore </P ></LI ><LI ><P > Column Permissions </P ></LI ><LI ><P > Per-database locale settings </P ></LI ><LI ><P > Improved hash indexes </P ></LI ><LI ><P > Improved join performance for <TT CLASS="LITERAL" >EXISTS</TT > and <TT CLASS="LITERAL" >NOT EXISTS</TT > queries </P ></LI ><LI ><P > Easier-to-use Warm Standby </P ></LI ><LI ><P > Automatic sizing of the Free Space Map </P ></LI ><LI ><P > Visibility Map (greatly reduces vacuum overhead for slowly-changing tables) </P ></LI ><LI ><P > Version-aware psql (backslash commands work against older servers) </P ></LI ><LI ><P > Support SSL certificates for user authentication </P ></LI ><LI ><P > Per-function runtime statistics </P ></LI ><LI ><P > Easy editing of functions in psql </P ></LI ><LI ><P > New contrib modules: pg_stat_statements, auto_explain, citext, btree_gin </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="AEN127498" >E.97.2. Migration to Version 8.4</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="AEN127503" >E.97.2.1. General</A ></H3 ><P ></P ><UL ><LI ><P > Use 64-bit integer datetimes by default (Neil Conway) </P ><P > Previously this was selected by <SPAN CLASS="APPLICATION" >configure</SPAN >'s <TT CLASS="OPTION" >--enable-integer-datetimes</TT > option. To retain the old behavior, build with <TT CLASS="OPTION" >--disable-integer-datetimes</TT >. </P ></LI ><LI ><P > Remove <SPAN CLASS="APPLICATION" >ipcclean</SPAN > utility command (Bruce) </P ><P > The utility only worked on a few platforms. Users should use their operating system tools instead. </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN127516" >E.97.2.2. Server Settings</A ></H3 ><P ></P ><UL ><LI ><P > Change default setting for <TT CLASS="LITERAL" >log_min_messages</TT > to <TT CLASS="LITERAL" >warning</TT > (previously it was <TT CLASS="LITERAL" >notice</TT >) to reduce log file volume (Tom) </P ></LI ><LI ><P > Change default setting for <TT CLASS="LITERAL" >max_prepared_transactions</TT > to zero (previously it was 5) (Tom) </P ></LI ><LI ><P > Make <TT CLASS="LITERAL" >debug_print_parse</TT >, <TT CLASS="LITERAL" >debug_print_rewritten</TT >, and <TT CLASS="LITERAL" >debug_print_plan</TT > output appear at <TT CLASS="LITERAL" >LOG</TT > message level, not <TT CLASS="LITERAL" >DEBUG1</TT > as formerly (Tom) </P ></LI ><LI ><P > Make <TT CLASS="LITERAL" >debug_pretty_print</TT > default to <TT CLASS="LITERAL" >on</TT > (Tom) </P ></LI ><LI ><P > Remove <TT CLASS="VARNAME" >explain_pretty_print</TT > parameter (no longer needed) (Tom) </P ></LI ><LI ><P > Make <TT CLASS="VARNAME" >log_temp_files</TT > settable by superusers only, like other logging options (Simon Riggs) </P ></LI ><LI ><P > Remove automatic appending of the epoch timestamp when no <TT CLASS="LITERAL" >%</TT > escapes are present in <TT CLASS="LITERAL" >log_filename</TT > (Robert Haas) </P ><P > This change was made because some users wanted a fixed log filename, for use with an external log rotation tool. </P ></LI ><LI ><P > Remove <TT CLASS="VARNAME" >log_restartpoints</TT > from <TT CLASS="FILENAME" >recovery.conf</TT >; instead use <TT CLASS="VARNAME" >log_checkpoints</TT > (Simon) </P ></LI ><LI ><P > Remove <TT CLASS="VARNAME" >krb_realm</TT > and <TT CLASS="VARNAME" >krb_server_hostname</TT >; these are now set in <TT CLASS="FILENAME" >pg_hba.conf</TT > instead (Magnus) </P ></LI ><LI ><P > There are also significant changes in <A HREF="release-8-4.html#RELEASE-8-4-PG-HBA-CONF" ><TT CLASS="FILENAME" >pg_hba.conf</TT ></A >, as described below. </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN127563" >E.97.2.3. Queries</A ></H3 ><P ></P ><UL ><LI ><P > Change <TT CLASS="COMMAND" >TRUNCATE</TT > and <TT CLASS="COMMAND" >LOCK</TT > to apply to child tables of the specified table(s) (Peter) </P ><P > These commands now accept an <TT CLASS="LITERAL" >ONLY</TT > option that prevents processing child tables; this option must be used if the old behavior is needed. </P ></LI ><LI ><P > <TT CLASS="COMMAND" >SELECT DISTINCT</TT > and <TT CLASS="LITERAL" >UNION</TT >/<TT CLASS="LITERAL" >INTERSECT</TT >/<TT CLASS="LITERAL" >EXCEPT</TT > no longer always produce sorted output (Tom) </P ><P > Previously, these types of queries always removed duplicate rows by means of Sort/Unique processing (i.e., sort then remove adjacent duplicates). Now they can be implemented by hashing, which will not produce sorted output. If an application relied on the output being in sorted order, the recommended fix is to add an <TT CLASS="LITERAL" >ORDER BY</TT > clause. As a short-term workaround, the previous behavior can be restored by disabling <TT CLASS="LITERAL" >enable_hashagg</TT >, but that is a very performance-expensive fix. <TT CLASS="LITERAL" >SELECT DISTINCT ON</TT > never uses hashing, however, so its behavior is unchanged. </P ></LI ><LI ><P > Force child tables to inherit <TT CLASS="LITERAL" >CHECK</TT > constraints from parents (Alex Hunsaker, Nikhil Sontakke, Tom) </P ><P > Formerly it was possible to drop such a constraint from a child table, allowing rows that violate the constraint to be visible when scanning the parent table. This was deemed inconsistent, as well as contrary to SQL standard. </P ></LI ><LI ><P > Disallow negative <TT CLASS="LITERAL" >LIMIT</TT > or <TT CLASS="LITERAL" >OFFSET</TT > values, rather than treating them as zero (Simon) </P ></LI ><LI ><P > Disallow <TT CLASS="COMMAND" >LOCK TABLE</TT > outside a transaction block (Tom) </P ><P > Such an operation is useless because the lock would be released immediately. </P ></LI ><LI ><P > Sequences now contain an additional <TT CLASS="STRUCTFIELD" >start_value</TT > column (Zoltan Boszormenyi) </P ><P > This supports <TT CLASS="COMMAND" >ALTER SEQUENCE ... RESTART</TT >. </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN127599" >E.97.2.4. Functions and Operators</A ></H3 ><P ></P ><UL ><LI ><P > Make <TT CLASS="TYPE" >numeric</TT > zero raised to a fractional power return <TT CLASS="LITERAL" >0</TT >, rather than throwing an error, and make <TT CLASS="TYPE" >numeric</TT > zero raised to the zero power return <TT CLASS="LITERAL" >1</TT >, rather than error (Bruce) </P ><P > This matches the longstanding <TT CLASS="TYPE" >float8</TT > behavior. </P ></LI ><LI ><P > Allow unary minus of floating-point values to produce minus zero (Tom) </P ><P > The changed behavior is more <ACRONYM CLASS="ACRONYM" >IEEE</ACRONYM >-standard compliant. </P ></LI ><LI ><P > Throw an error if an escape character is the last character in a <TT CLASS="LITERAL" >LIKE</TT > pattern (i.e., it has nothing to escape) (Tom) </P ><P > Previously, such an escape character was silently ignored, thus possibly masking application logic errors. </P ></LI ><LI ><P > Remove <TT CLASS="LITERAL" >~=~</TT > and <TT CLASS="LITERAL" >~<>~</TT > operators formerly used for <TT CLASS="LITERAL" >LIKE</TT > index comparisons (Tom) </P ><P > Pattern indexes now use the regular equality operator. </P ></LI ><LI ><P > <CODE CLASS="FUNCTION" >xpath()</CODE > now passes its arguments to <SPAN CLASS="APPLICATION" >libxml</SPAN > without any changes (Andrew) </P ><P > This means that the XML argument must be a well-formed XML document. The previous coding attempted to allow XML fragments, but it did not work well. </P ></LI ><LI ><P > Make <CODE CLASS="FUNCTION" >xmlelement()</CODE > format attribute values just like content values (Peter) </P ><P > Previously, attribute values were formatted according to the normal SQL output behavior, which is sometimes at odds with XML rules. </P ></LI ><LI ><P > Rewrite memory management for <SPAN CLASS="APPLICATION" >libxml</SPAN >-using functions (Tom) </P ><P > This change should avoid some compatibility problems with use of <SPAN CLASS="APPLICATION" >libxml</SPAN > in PL/Perl and other add-on code. </P ></LI ><LI ><P > Adopt a faster algorithm for hash functions (Kenneth Marshall, based on work of Bob Jenkins) </P ><P > Many of the built-in hash functions now deliver different results on little-endian and big-endian platforms. </P ></LI ></UL ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN127641" >E.97.2.4.1. Temporal Functions and Operators</A ></H4 ><P ></P ><UL ><LI ><P > <TT CLASS="VARNAME" >DateStyle</TT > no longer controls <TT CLASS="TYPE" >interval</TT > output formatting; instead there is a new variable <TT CLASS="VARNAME" >IntervalStyle</TT > (Ron Mayer) </P ></LI ><LI ><P > Improve consistency of handling of fractional seconds in <TT CLASS="TYPE" >timestamp</TT > and <TT CLASS="TYPE" >interval</TT > output (Ron Mayer) </P ><P > This may result in displaying a different number of fractional digits than before, or rounding instead of truncating. </P ></LI ><LI ><P > Make <CODE CLASS="FUNCTION" >to_char()</CODE >'s localized month/day names depend on <TT CLASS="VARNAME" >LC_TIME</TT >, not <TT CLASS="VARNAME" >LC_MESSAGES</TT > (Euler Taveira de Oliveira) </P ></LI ><LI ><P > Cause <CODE CLASS="FUNCTION" >to_date()</CODE > and <CODE CLASS="FUNCTION" >to_timestamp()</CODE > to more consistently report errors for invalid input (Brendan Jurd) </P ><P > Previous versions would often ignore or silently misread input that did not match the format string. Such cases will now result in an error. </P ></LI ><LI ><P > Fix <CODE CLASS="FUNCTION" >to_timestamp()</CODE > to not require upper/lower case matching for meridian (<TT CLASS="LITERAL" >AM</TT >/<TT CLASS="LITERAL" >PM</TT >) and era (<TT CLASS="LITERAL" >BC</TT >/<TT CLASS="LITERAL" >AD</TT >) format designations (Brendan Jurd) </P ><P > For example, input value <TT CLASS="LITERAL" >ad</TT > now matches the format string <TT CLASS="LITERAL" >AD</TT >. </P ></LI ></UL ></DIV ></DIV ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="AEN127674" >E.97.3. Changes</A ></H2 ><P > Below you will find a detailed account of the changes between <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > 8.4 and the previous major release. </P ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN127678" >E.97.3.1. Performance</A ></H3 ><P ></P ><UL ><LI ><P > Improve optimizer statistics calculations (Jan Urbanski, Tom) </P ><P > In particular, estimates for full-text-search operators are greatly improved. </P ></LI ><LI ><P > Allow <TT CLASS="COMMAND" >SELECT DISTINCT</TT > and <TT CLASS="LITERAL" >UNION</TT >/<TT CLASS="LITERAL" >INTERSECT</TT >/<TT CLASS="LITERAL" >EXCEPT</TT > to use hashing (Tom) </P ><P > This means that these types of queries no longer automatically produce sorted output. </P ></LI ><LI ><P > Create explicit concepts of semi-joins and anti-joins (Tom) </P ><P > This work formalizes our previous ad-hoc treatment of <TT CLASS="LITERAL" >IN (SELECT ...)</TT > clauses, and extends it to <TT CLASS="LITERAL" >EXISTS</TT > and <TT CLASS="LITERAL" >NOT EXISTS</TT > clauses. It should result in significantly better planning of <TT CLASS="LITERAL" >EXISTS</TT > and <TT CLASS="LITERAL" >NOT EXISTS</TT > queries. In general, logically equivalent <TT CLASS="LITERAL" >IN</TT > and <TT CLASS="LITERAL" >EXISTS</TT > clauses should now have similar performance, whereas previously <TT CLASS="LITERAL" >IN</TT > often won. </P ></LI ><LI ><P > Improve optimization of sub-selects beneath outer joins (Tom) </P ><P > Formerly, a sub-select or view could not be optimized very well if it appeared within the nullable side of an outer join and contained non-strict expressions (for instance, constants) in its result list. </P ></LI ><LI ><P > Improve the performance of <CODE CLASS="FUNCTION" >text_position()</CODE > and related functions by using Boyer-Moore-Horspool searching (David Rowley) </P ><P > This is particularly helpful for long search patterns. </P ></LI ><LI ><P > Reduce I/O load of writing the statistics collection file by writing the file only when requested (Martin Pihlak) </P ></LI ><LI ><P > Improve performance for bulk inserts (Robert Haas, Simon) </P ></LI ><LI ><P > Increase the default value of <TT CLASS="VARNAME" >default_statistics_target</TT > from <TT CLASS="LITERAL" >10</TT > to <TT CLASS="LITERAL" >100</TT > (Greg Sabino Mullane, Tom) </P ><P > The maximum value was also increased from <TT CLASS="LITERAL" >1000</TT > to <TT CLASS="LITERAL" >10000</TT >. </P ></LI ><LI ><P > Perform <TT CLASS="VARNAME" >constraint_exclusion</TT > checking by default in queries involving inheritance or <TT CLASS="LITERAL" >UNION ALL</TT > (Tom) </P ><P > A new <TT CLASS="VARNAME" >constraint_exclusion</TT > setting, <TT CLASS="LITERAL" >partition</TT >, was added to specify this behavior. </P ></LI ><LI ><P > Allow I/O read-ahead for bitmap index scans (Greg Stark) </P ><P > The amount of read-ahead is controlled by <TT CLASS="VARNAME" >effective_io_concurrency</TT >. This feature is available only if the kernel has <CODE CLASS="FUNCTION" >posix_fadvise()</CODE > support. </P ></LI ><LI ><P > Inline simple set-returning <ACRONYM CLASS="ACRONYM" >SQL</ACRONYM > functions in <TT CLASS="LITERAL" >FROM</TT > clauses (Richard Rowell) </P ></LI ><LI ><P > Improve performance of multi-batch hash joins by providing a special case for join key values that are especially common in the outer relation (Bryce Cutt, Ramon Lawrence) </P ></LI ><LI ><P > Reduce volume of temporary data in multi-batch hash joins by suppressing <SPAN CLASS="QUOTE" >"physical tlist"</SPAN > optimization (Michael Henderson, Ramon Lawrence) </P ></LI ><LI ><P > Avoid waiting for idle-in-transaction sessions during <TT CLASS="COMMAND" >CREATE INDEX CONCURRENTLY</TT > (Simon) </P ></LI ><LI ><P > Improve performance of shared cache invalidation (Tom) </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN127747" >E.97.3.2. Server</A ></H3 ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN127749" >E.97.3.2.1. Settings</A ></H4 ><P ></P ><UL ><LI ><P > Convert many <TT CLASS="FILENAME" >postgresql.conf</TT > settings to enumerated values so that <TT CLASS="LITERAL" >pg_settings</TT > can display the valid values (Magnus) </P ></LI ><LI ><P > Add <TT CLASS="VARNAME" >cursor_tuple_fraction</TT > parameter to control the fraction of a cursor's rows that the planner assumes will be fetched (Robert Hell) </P ></LI ><LI ><P > Allow underscores in the names of custom variable classes in <TT CLASS="FILENAME" >postgresql.conf</TT > (Tom) </P ></LI ></UL ></DIV ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN127762" >E.97.3.2.2. Authentication and security</A ></H4 ><P ></P ><UL ><LI ><P > Remove support for the (insecure) <TT CLASS="LITERAL" >crypt</TT > authentication method (Magnus) </P ><P > This effectively obsoletes pre-<SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > 7.2 client libraries, as there is no longer any non-plaintext password method that they can use. </P ></LI ><LI ><P > Support regular expressions in <TT CLASS="FILENAME" >pg_ident.conf</TT > (Magnus) </P ></LI ><LI ><P > Allow <SPAN CLASS="PRODUCTNAME" >Kerberos</SPAN >/<ACRONYM CLASS="ACRONYM" >GSSAPI</ACRONYM > parameters to be changed without restarting the postmaster (Magnus) </P ></LI ><LI ><P > Support <ACRONYM CLASS="ACRONYM" >SSL</ACRONYM > certificate chains in server certificate file (Andrew Gierth) </P ><P > Including the full certificate chain makes the client able to verify the certificate without having all intermediate CA certificates present in the local store, which is often the case for commercial CAs. </P ></LI ><LI ><P > Report appropriate error message for combination of <TT CLASS="LITERAL" >MD5</TT > authentication and <TT CLASS="VARNAME" >db_user_namespace</TT > enabled (Bruce) </P ></LI ></UL ></DIV ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="RELEASE-8-4-PG-HBA-CONF" >E.97.3.2.3. <TT CLASS="FILENAME" >pg_hba.conf</TT ></A ></H4 ><P ></P ><UL ><LI ><P > Change all authentication options to use <TT CLASS="LITERAL" >name=value</TT > syntax (Magnus) </P ><P > This makes incompatible changes to the <TT CLASS="LITERAL" >ldap</TT >, <TT CLASS="LITERAL" >pam</TT > and <TT CLASS="LITERAL" >ident</TT > authentication methods. All <TT CLASS="FILENAME" >pg_hba.conf</TT > entries with these methods need to be rewritten using the new format. </P ></LI ><LI ><P > Remove the <TT CLASS="LITERAL" >ident sameuser</TT > option, instead making that behavior the default if no usermap is specified (Magnus) </P ></LI ><LI ><P > Allow a usermap parameter for all external authentication methods (Magnus) </P ><P > Previously a usermap was only supported for <TT CLASS="LITERAL" >ident</TT > authentication. </P ></LI ><LI ><P > Add <TT CLASS="LITERAL" >clientcert</TT > option to control requesting of a client certificate (Magnus) </P ><P > Previously this was controlled by the presence of a root certificate file in the server's data directory. </P ></LI ><LI ><P > Add <TT CLASS="LITERAL" >cert</TT > authentication method to allow <SPAN CLASS="emphasis" ><I CLASS="EMPHASIS" >user</I ></SPAN > authentication via <ACRONYM CLASS="ACRONYM" >SSL</ACRONYM > certificates (Magnus) </P ><P > Previously <ACRONYM CLASS="ACRONYM" >SSL</ACRONYM > certificates could only verify that the client had access to a certificate, not authenticate a user. </P ></LI ><LI ><P > Allow <TT CLASS="LITERAL" >krb5</TT >, <TT CLASS="LITERAL" >gssapi</TT > and <TT CLASS="LITERAL" >sspi</TT > realm and <TT CLASS="LITERAL" >krb5</TT > host settings to be specified in <TT CLASS="FILENAME" >pg_hba.conf</TT > (Magnus) </P ><P > These override the settings in <TT CLASS="FILENAME" >postgresql.conf</TT >. </P ></LI ><LI ><P > Add <TT CLASS="VARNAME" >include_realm</TT > parameter for <TT CLASS="LITERAL" >krb5</TT >, <TT CLASS="LITERAL" >gssapi</TT >, and <TT CLASS="LITERAL" >sspi</TT > methods (Magnus) </P ><P > This allows identical usernames from different realms to be authenticated as different database users using usermaps. </P ></LI ><LI ><P > Parse <TT CLASS="FILENAME" >pg_hba.conf</TT > fully when it is loaded, so that errors are reported immediately (Magnus) </P ><P > Previously, most errors in the file wouldn't be detected until clients tried to connect, so an erroneous file could render the system unusable. With the new behavior, if an error is detected during reload then the bad file is rejected and the postmaster continues to use its old copy. </P ></LI ><LI ><P > Show all parsing errors in <TT CLASS="FILENAME" >pg_hba.conf</TT > instead of aborting after the first one (Selena Deckelmann) </P ></LI ><LI ><P > Support <TT CLASS="LITERAL" >ident</TT > authentication over Unix-domain sockets on <SPAN CLASS="PRODUCTNAME" >Solaris</SPAN > (Garick Hamlin) </P ></LI ></UL ></DIV ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN127842" >E.97.3.2.4. Continuous Archiving</A ></H4 ><P ></P ><UL ><LI ><P > Provide an option to <CODE CLASS="FUNCTION" >pg_start_backup()</CODE > to force its implied checkpoint to finish as quickly as possible (Tom) </P ><P > The default behavior avoids excess I/O consumption, but that is pointless if no concurrent query activity is going on. </P ></LI ><LI ><P > Make <CODE CLASS="FUNCTION" >pg_stop_backup()</CODE > wait for modified <ACRONYM CLASS="ACRONYM" >WAL</ACRONYM > files to be archived (Simon) </P ><P > This guarantees that the backup is valid at the time <CODE CLASS="FUNCTION" >pg_stop_backup()</CODE > completes. </P ></LI ><LI ><P > When archiving is enabled, rotate the last WAL segment at shutdown so that all transactions can be archived immediately (Guillaume Smet, Heikki) </P ></LI ><LI ><P > Delay <SPAN CLASS="QUOTE" >"smart"</SPAN > shutdown while a continuous archiving base backup is in progress (Laurenz Albe) </P ></LI ><LI ><P > Cancel a continuous archiving base backup if <SPAN CLASS="QUOTE" >"fast"</SPAN > shutdown is requested (Laurenz Albe) </P ></LI ><LI ><P > Allow <TT CLASS="FILENAME" >recovery.conf</TT > boolean variables to take the same range of string values as <TT CLASS="FILENAME" >postgresql.conf</TT > boolean variables (Bruce) </P ></LI ></UL ></DIV ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN127867" >E.97.3.2.5. Monitoring</A ></H4 ><P ></P ><UL ><LI ><P > Add <CODE CLASS="FUNCTION" >pg_conf_load_time()</CODE > to report when the <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > configuration files were last loaded (George Gensure) </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >pg_terminate_backend()</CODE > to safely terminate a backend (the <TT CLASS="LITERAL" >SIGTERM</TT > signal works also) (Tom, Bruce) </P ><P > While it's always been possible to <TT CLASS="LITERAL" >SIGTERM</TT > a single backend, this was previously considered unsupported; and testing of the case found some bugs that are now fixed. </P ></LI ><LI ><P > Add ability to track user-defined functions' call counts and runtimes (Martin Pihlak) </P ><P > Function statistics appear in a new system view, <TT CLASS="LITERAL" >pg_stat_user_functions</TT >. Tracking is controlled by the new parameter <TT CLASS="VARNAME" >track_functions</TT >. </P ></LI ><LI ><P > Allow specification of the maximum query string size in <TT CLASS="LITERAL" >pg_stat_activity</TT > via new <TT CLASS="VARNAME" >track_activity_query_size</TT > parameter (Thomas Lee) </P ></LI ><LI ><P > Increase the maximum line length sent to <SPAN CLASS="APPLICATION" >syslog</SPAN >, in hopes of improving performance (Tom) </P ></LI ><LI ><P > Add read-only configuration variables <TT CLASS="VARNAME" >segment_size</TT >, <TT CLASS="VARNAME" >wal_block_size</TT >, and <TT CLASS="VARNAME" >wal_segment_size</TT > (Bernd Helmle) </P ></LI ><LI ><P > When reporting a deadlock, report the text of all queries involved in the deadlock to the server log (Itagaki Takahiro) </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >pg_stat_get_activity(pid)</CODE > function to return information about a specific process id (Magnus) </P ></LI ><LI ><P > Allow the location of the server's statistics file to be specified via <TT CLASS="VARNAME" >stats_temp_directory</TT > (Magnus) </P ><P > This allows the statistics file to be placed in a <ACRONYM CLASS="ACRONYM" >RAM</ACRONYM >-resident directory to reduce I/O requirements. On startup/shutdown, the file is copied to its traditional location (<TT CLASS="LITERAL" >$PGDATA/global/</TT >) so it is preserved across restarts. </P ></LI ></UL ></DIV ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN127908" >E.97.3.3. Queries</A ></H3 ><P ></P ><UL ><LI ><P > Add support for <TT CLASS="LITERAL" >WINDOW</TT > functions (Hitoshi Harada) </P ></LI ><LI ><P > Add support for <TT CLASS="LITERAL" >WITH</TT > clauses (CTEs), including <TT CLASS="LITERAL" >WITH RECURSIVE</TT > (Yoshiyuki Asaba, Tatsuo Ishii, Tom) </P ></LI ><LI ><P > Add <TT CLASS="COMMAND" >TABLE</TT > command (Peter) </P ><P > <TT CLASS="LITERAL" >TABLE tablename</TT > is a SQL standard short-hand for <TT CLASS="LITERAL" >SELECT * FROM tablename</TT >. </P ></LI ><LI ><P > Allow <TT CLASS="LITERAL" >AS</TT > to be optional when specifying a <TT CLASS="COMMAND" >SELECT</TT > (or <TT CLASS="LITERAL" >RETURNING</TT >) column output label (Hiroshi Saito) </P ><P > This works so long as the column label is not any <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > keyword; otherwise <TT CLASS="LITERAL" >AS</TT > is still needed. </P ></LI ><LI ><P > Support set-returning functions in <TT CLASS="COMMAND" >SELECT</TT > result lists even for functions that return their result via a tuplestore (Tom) </P ><P > In particular, this means that functions written in PL/pgSQL and other PL languages can now be called this way. </P ></LI ><LI ><P > Support set-returning functions in the output of aggregation and grouping queries (Tom) </P ></LI ><LI ><P > Allow <TT CLASS="COMMAND" >SELECT FOR UPDATE</TT >/<TT CLASS="LITERAL" >SHARE</TT > to work on inheritance trees (Tom) </P ></LI ><LI ><P > Add infrastructure for <ACRONYM CLASS="ACRONYM" >SQL/MED</ACRONYM > (Martin Pihlak, Peter) </P ><P > There are no remote or external <ACRONYM CLASS="ACRONYM" >SQL/MED</ACRONYM > capabilities yet, but this change provides a standardized and future-proof system for managing connection information for modules like <TT CLASS="FILENAME" >dblink</TT > and <TT CLASS="FILENAME" >plproxy</TT >. </P ></LI ><LI ><P > Invalidate cached plans when referenced schemas, functions, operators, or operator classes are modified (Martin Pihlak, Tom) </P ><P > This improves the system's ability to respond to on-the-fly DDL changes. </P ></LI ><LI ><P > Allow comparison of composite types and allow arrays of anonymous composite types (Tom) </P ><P > This allows constructs such as <TT CLASS="LITERAL" >row(1, 1.1) = any (array[row(7, 7.7), row(1, 1.0)])</TT >. This is particularly useful in recursive queries. </P ></LI ><LI ><P > Add support for Unicode string literal and identifier specifications using code points, e.g. <TT CLASS="LITERAL" >U&'d\0061t\+000061'</TT > (Peter) </P ></LI ><LI ><P > Reject <TT CLASS="LITERAL" >\000</TT > in string literals and <TT CLASS="COMMAND" >COPY</TT > data (Tom) </P ><P > Previously, this was accepted but had the effect of terminating the string contents. </P ></LI ><LI ><P > Improve the parser's ability to report error locations (Tom) </P ><P > An error location is now reported for many semantic errors, such as mismatched datatypes, that previously could not be localized. </P ></LI ></UL ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN127967" >E.97.3.3.1. <TT CLASS="COMMAND" >TRUNCATE</TT ></A ></H4 ><P ></P ><UL ><LI ><P > Support statement-level <TT CLASS="LITERAL" >ON TRUNCATE</TT > triggers (Simon) </P ></LI ><LI ><P > Add <TT CLASS="LITERAL" >RESTART</TT >/<TT CLASS="LITERAL" >CONTINUE IDENTITY</TT > options for <TT CLASS="COMMAND" >TRUNCATE TABLE</TT > (Zoltan Boszormenyi) </P ><P > The start value of a sequence can be changed by <TT CLASS="COMMAND" >ALTER SEQUENCE START WITH</TT >. </P ></LI ><LI ><P > Allow <TT CLASS="COMMAND" >TRUNCATE tab1, tab1</TT > to succeed (Bruce) </P ></LI ><LI ><P > Add a separate <TT CLASS="COMMAND" >TRUNCATE</TT > permission (Robert Haas) </P ></LI ></UL ></DIV ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN127987" >E.97.3.3.2. <TT CLASS="COMMAND" >EXPLAIN</TT ></A ></H4 ><P ></P ><UL ><LI ><P > Make <TT CLASS="COMMAND" >EXPLAIN VERBOSE</TT > show the output columns of each plan node (Tom) </P ><P > Previously <TT CLASS="COMMAND" >EXPLAIN VERBOSE</TT > output an internal representation of the query plan. (That behavior is now available via <TT CLASS="VARNAME" >debug_print_plan</TT >.) </P ></LI ><LI ><P > Make <TT CLASS="COMMAND" >EXPLAIN</TT > identify subplans and initplans with individual labels (Tom) </P ></LI ><LI ><P > Make <TT CLASS="COMMAND" >EXPLAIN</TT > honor <TT CLASS="VARNAME" >debug_print_plan</TT > (Tom) </P ></LI ><LI ><P > Allow <TT CLASS="COMMAND" >EXPLAIN</TT > on <TT CLASS="COMMAND" >CREATE TABLE AS</TT > (Peter) </P ></LI ></UL ></DIV ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN128008" >E.97.3.3.3. <TT CLASS="LITERAL" >LIMIT</TT >/<TT CLASS="LITERAL" >OFFSET</TT ></A ></H4 ><P ></P ><UL ><LI ><P > Allow sub-selects in <TT CLASS="LITERAL" >LIMIT</TT > and <TT CLASS="LITERAL" >OFFSET</TT > (Tom) </P ></LI ><LI ><P > Add <ACRONYM CLASS="ACRONYM" >SQL</ACRONYM >-standard syntax for <TT CLASS="LITERAL" >LIMIT</TT >/<TT CLASS="LITERAL" >OFFSET</TT > capabilities (Peter) </P ><P > To wit, <TT CLASS="LITERAL" >OFFSET num {ROW|ROWS} FETCH {FIRST|NEXT} [num] {ROW|ROWS} ONLY</TT >. </P ></LI ></UL ></DIV ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN128024" >E.97.3.4. Object Manipulation</A ></H3 ><P ></P ><UL ><LI ><P > Add support for column-level privileges (Stephen Frost, KaiGai Kohei) </P ></LI ><LI ><P > Refactor multi-object <TT CLASS="COMMAND" >DROP</TT > operations to reduce the need for <TT CLASS="LITERAL" >CASCADE</TT > (Alex Hunsaker) </P ><P > For example, if table <TT CLASS="LITERAL" >B</TT > has a dependency on table <TT CLASS="LITERAL" >A</TT >, the command <TT CLASS="LITERAL" >DROP TABLE A, B</TT > no longer requires the <TT CLASS="LITERAL" >CASCADE</TT > option. </P ></LI ><LI ><P > Fix various problems with concurrent <TT CLASS="COMMAND" >DROP</TT > commands by ensuring that locks are taken before we begin to drop dependencies of an object (Tom) </P ></LI ><LI ><P > Improve reporting of dependencies during <TT CLASS="COMMAND" >DROP</TT > commands (Tom) </P ></LI ><LI ><P > Add <TT CLASS="LITERAL" >WITH [NO] DATA</TT > clause to <TT CLASS="COMMAND" >CREATE TABLE AS</TT >, per the <ACRONYM CLASS="ACRONYM" >SQL</ACRONYM > standard (Peter, Tom) </P ></LI ><LI ><P > Add support for user-defined I/O conversion casts (Heikki) </P ></LI ><LI ><P > Allow <TT CLASS="COMMAND" >CREATE AGGREGATE</TT > to use an <TT CLASS="TYPE" >internal</TT > transition datatype (Tom) </P ></LI ><LI ><P > Add <TT CLASS="LITERAL" >LIKE</TT > clause to <TT CLASS="COMMAND" >CREATE TYPE</TT > (Tom) </P ><P > This simplifies creation of data types that use the same internal representation as an existing type. </P ></LI ><LI ><P > Allow specification of the type category and <SPAN CLASS="QUOTE" >"preferred"</SPAN > status for user-defined base types (Tom) </P ><P > This allows more control over the coercion behavior of user-defined types. </P ></LI ><LI ><P > Allow <TT CLASS="COMMAND" >CREATE OR REPLACE VIEW</TT > to add columns to the end of a view (Robert Haas) </P ></LI ></UL ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN128067" >E.97.3.4.1. <TT CLASS="COMMAND" >ALTER</TT ></A ></H4 ><P ></P ><UL ><LI ><P > Add <TT CLASS="COMMAND" >ALTER TYPE RENAME</TT > (Petr Jelinek) </P ></LI ><LI ><P > Add <TT CLASS="COMMAND" >ALTER SEQUENCE ... RESTART</TT > (with no parameter) to reset a sequence to its initial value (Zoltan Boszormenyi) </P ></LI ><LI ><P > Modify the <TT CLASS="COMMAND" >ALTER TABLE</TT > syntax to allow all reasonable combinations for tables, indexes, sequences, and views (Tom) </P ><P > This change allows the following new syntaxes: <P ></P ></P><UL ><LI ><P > <TT CLASS="COMMAND" >ALTER SEQUENCE OWNER TO</TT > </P ></LI ><LI ><P > <TT CLASS="COMMAND" >ALTER VIEW ALTER COLUMN SET/DROP DEFAULT</TT > </P ></LI ><LI ><P > <TT CLASS="COMMAND" >ALTER VIEW OWNER TO</TT > </P ></LI ><LI ><P > <TT CLASS="COMMAND" >ALTER VIEW SET SCHEMA</TT > </P ></LI ></UL ><P> There is no actual new functionality here, but formerly you had to say <TT CLASS="COMMAND" >ALTER TABLE</TT > to do these things, which was confusing. </P ></LI ><LI ><P > Add support for the syntax <TT CLASS="COMMAND" >ALTER TABLE ... ALTER COLUMN ... SET DATA TYPE</TT > (Peter) </P ><P > This is <ACRONYM CLASS="ACRONYM" >SQL</ACRONYM >-standard syntax for functionality that was already supported. </P ></LI ><LI ><P > Make <TT CLASS="COMMAND" >ALTER TABLE SET WITHOUT OIDS</TT > rewrite the table to physically remove <TT CLASS="TYPE" >OID</TT > values (Tom) </P ><P > Also, add <TT CLASS="COMMAND" >ALTER TABLE SET WITH OIDS</TT > to rewrite the table to add <TT CLASS="TYPE" >OID</TT >s. </P ></LI ></UL ></DIV ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN128107" >E.97.3.4.2. Database Manipulation</A ></H4 ><P ></P ><UL ><LI ><P > Improve reporting of <TT CLASS="COMMAND" >CREATE</TT >/<TT CLASS="COMMAND" >DROP</TT >/<TT CLASS="COMMAND" >RENAME DATABASE</TT > failure when uncommitted prepared transactions are the cause (Tom) </P ></LI ><LI ><P > Make <TT CLASS="VARNAME" >LC_COLLATE</TT > and <TT CLASS="VARNAME" >LC_CTYPE</TT > into per-database settings (Radek Strnad, Heikki) </P ><P > This makes collation similar to encoding, which was always configurable per database. </P ></LI ><LI ><P > Improve checks that the database encoding, collation (<TT CLASS="VARNAME" >LC_COLLATE</TT >), and character classes (<TT CLASS="VARNAME" >LC_CTYPE</TT >) match (Heikki, Tom) </P ><P > Note in particular that a new database's encoding and locale settings can be changed only when copying from <TT CLASS="LITERAL" >template0</TT >. This prevents possibly copying data that doesn't match the settings. </P ></LI ><LI ><P > Add <TT CLASS="COMMAND" >ALTER DATABASE SET TABLESPACE</TT > to move a database to a new tablespace (Guillaume Lelarge, Bernd Helmle) </P ></LI ></UL ></DIV ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN128129" >E.97.3.5. Utility Operations</A ></H3 ><P ></P ><UL ><LI ><P > Add a <TT CLASS="LITERAL" >VERBOSE</TT > option to the <TT CLASS="COMMAND" >CLUSTER</TT > command and <SPAN CLASS="APPLICATION" >clusterdb</SPAN > (Jim Cox) </P ></LI ><LI ><P > Decrease memory requirements for recording pending trigger events (Tom) </P ></LI ></UL ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN128139" >E.97.3.5.1. Indexes</A ></H4 ><P ></P ><UL ><LI ><P > Dramatically improve the speed of building and accessing hash indexes (Tom Raney, Shreya Bhargava) </P ><P > This allows hash indexes to be sometimes faster than btree indexes. However, hash indexes are still not crash-safe. </P ></LI ><LI ><P > Make hash indexes store only the hash code, not the full value of the indexed column (Xiao Meng) </P ><P > This greatly reduces the size of hash indexes for long indexed values, improving performance. </P ></LI ><LI ><P > Implement fast update option for GIN indexes (Teodor, Oleg) </P ><P > This option greatly improves update speed at a small penalty in search speed. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >xxx_pattern_ops</TT > indexes can now be used for simple equality comparisons, not only for <TT CLASS="LITERAL" >LIKE</TT > (Tom) </P ></LI ></UL ></DIV ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN128155" >E.97.3.5.2. Full Text Indexes</A ></H4 ><P ></P ><UL ><LI ><P > Remove the requirement to use <TT CLASS="LITERAL" >@@@</TT > when doing <ACRONYM CLASS="ACRONYM" >GIN</ACRONYM > weighted lookups on full text indexes (Tom, Teodor) </P ><P > The normal <TT CLASS="LITERAL" >@@</TT > text search operator can be used instead. </P ></LI ><LI ><P > Add an optimizer selectivity function for <TT CLASS="LITERAL" >@@</TT > text search operations (Jan Urbanski) </P ></LI ><LI ><P > Allow prefix matching in full text searches (Teodor Sigaev, Oleg Bartunov) </P ></LI ><LI ><P > Support multi-column <ACRONYM CLASS="ACRONYM" >GIN</ACRONYM > indexes (Teodor Sigaev) </P ></LI ><LI ><P > Improve support for Nepali language and Devanagari alphabet (Teodor) </P ></LI ></UL ></DIV ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN128174" >E.97.3.5.3. <TT CLASS="COMMAND" >VACUUM</TT ></A ></H4 ><P ></P ><UL ><LI ><P > Track free space in separate per-relation <SPAN CLASS="QUOTE" >"fork"</SPAN > files (Heikki) </P ><P > Free space discovered by <TT CLASS="COMMAND" >VACUUM</TT > is now recorded in <TT CLASS="FILENAME" >*_fsm</TT > files, rather than in a fixed-sized shared memory area. The <TT CLASS="VARNAME" >max_fsm_pages</TT > and <TT CLASS="VARNAME" >max_fsm_relations</TT > settings have been removed, greatly simplifying administration of free space management. </P ></LI ><LI ><P > Add a visibility map to track pages that do not require vacuuming (Heikki) </P ><P > This allows <TT CLASS="COMMAND" >VACUUM</TT > to avoid scanning all of a table when only a portion of the table needs vacuuming. The visibility map is stored in per-relation <SPAN CLASS="QUOTE" >"fork"</SPAN > files. </P ></LI ><LI ><P > Add <TT CLASS="VARNAME" >vacuum_freeze_table_age</TT > parameter to control when <TT CLASS="COMMAND" >VACUUM</TT > should ignore the visibility map and do a full table scan to freeze tuples (Heikki) </P ></LI ><LI ><P > Track transaction snapshots more carefully (Alvaro) </P ><P > This improves <TT CLASS="COMMAND" >VACUUM</TT >'s ability to reclaim space in the presence of long-running transactions. </P ></LI ><LI ><P > Add ability to specify per-relation autovacuum and <ACRONYM CLASS="ACRONYM" >TOAST</ACRONYM > parameters in <TT CLASS="COMMAND" >CREATE TABLE</TT > (Alvaro, Euler Taveira de Oliveira) </P ><P > Autovacuum options used to be stored in a system table. </P ></LI ><LI ><P > Add <TT CLASS="LITERAL" >--freeze</TT > option to <SPAN CLASS="APPLICATION" >vacuumdb</SPAN > (Bruce) </P ></LI ></UL ></DIV ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN128208" >E.97.3.6. Data Types</A ></H3 ><P ></P ><UL ><LI ><P > Add a <TT CLASS="LITERAL" >CaseSensitive</TT > option for text search synonym dictionaries (Simon) </P ></LI ><LI ><P > Improve the precision of <TT CLASS="TYPE" >NUMERIC</TT > division (Tom) </P ></LI ><LI ><P > Add basic arithmetic operators for <TT CLASS="TYPE" >int2</TT > with <TT CLASS="TYPE" >int8</TT > (Tom) </P ><P > This eliminates the need for explicit casting in some situations. </P ></LI ><LI ><P > Allow <TT CLASS="TYPE" >UUID</TT > input to accept an optional hyphen after every fourth digit (Robert Haas) </P ></LI ><LI ><P > Allow <TT CLASS="LITERAL" >on</TT >/<TT CLASS="LITERAL" >off</TT > as input for the boolean data type (Itagaki Takahiro) </P ></LI ><LI ><P > Allow spaces around <TT CLASS="LITERAL" >NaN</TT > in the input string for type <TT CLASS="TYPE" >numeric</TT > (Sam Mason) </P ></LI ></UL ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN128233" >E.97.3.6.1. Temporal Data Types</A ></H4 ><P ></P ><UL ><LI ><P > Reject year <TT CLASS="LITERAL" >0 BC</TT > and years <TT CLASS="LITERAL" >000</TT > and <TT CLASS="LITERAL" >0000</TT > (Tom) </P ><P > Previously these were interpreted as <TT CLASS="LITERAL" >1 BC</TT >. (Note: years <TT CLASS="LITERAL" >0</TT > and <TT CLASS="LITERAL" >00</TT > are still assumed to be the year 2000.) </P ></LI ><LI ><P > Include <TT CLASS="LITERAL" >SGT</TT > (Singapore time) in the default list of known time zone abbreviations (Tom) </P ></LI ><LI ><P > Support <TT CLASS="LITERAL" >infinity</TT > and <TT CLASS="LITERAL" >-infinity</TT > as values of type <TT CLASS="TYPE" >date</TT > (Tom) </P ></LI ><LI ><P > Make parsing of <TT CLASS="TYPE" >interval</TT > literals more standard-compliant (Tom, Ron Mayer) </P ><P > For example, <TT CLASS="LITERAL" >INTERVAL '1' YEAR</TT > now does what it's supposed to. </P ></LI ><LI ><P > Allow <TT CLASS="TYPE" >interval</TT > fractional-seconds precision to be specified after the <TT CLASS="LITERAL" >second</TT > keyword, for <ACRONYM CLASS="ACRONYM" >SQL</ACRONYM > standard compliance (Tom) </P ><P > Formerly the precision had to be specified after the keyword <TT CLASS="TYPE" >interval</TT >. (For backwards compatibility, this syntax is still supported, though deprecated.) Data type definitions will now be output using the standard format. </P ></LI ><LI ><P > Support the <ACRONYM CLASS="ACRONYM" >IS0 8601</ACRONYM > <TT CLASS="TYPE" >interval</TT > syntax (Ron Mayer, Kevin Grittner) </P ><P > For example, <TT CLASS="LITERAL" >INTERVAL 'P1Y2M3DT4H5M6.7S'</TT > is now supported. </P ></LI ><LI ><P > Add <TT CLASS="VARNAME" >IntervalStyle</TT > parameter which controls how <TT CLASS="TYPE" >interval</TT > values are output (Ron Mayer) </P ><P > Valid values are: <TT CLASS="LITERAL" >postgres</TT >, <TT CLASS="LITERAL" >postgres_verbose</TT >, <TT CLASS="LITERAL" >sql_standard</TT >, <TT CLASS="LITERAL" >iso_8601</TT >. This setting also controls the handling of negative <TT CLASS="TYPE" >interval</TT > input when only some fields have positive/negative designations. </P ></LI ><LI ><P > Improve consistency of handling of fractional seconds in <TT CLASS="TYPE" >timestamp</TT > and <TT CLASS="TYPE" >interval</TT > output (Ron Mayer) </P ></LI ></UL ></DIV ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN128285" >E.97.3.6.2. Arrays</A ></H4 ><P ></P ><UL ><LI ><P > Improve the handling of casts applied to <TT CLASS="LITERAL" >ARRAY[]</TT > constructs, such as <TT CLASS="LITERAL" >ARRAY[...]::integer[]</TT > (Brendan Jurd) </P ><P > Formerly <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > attempted to determine a data type for the <TT CLASS="LITERAL" >ARRAY[]</TT > construct without reference to the ensuing cast. This could fail unnecessarily in many cases, in particular when the <TT CLASS="LITERAL" >ARRAY[]</TT > construct was empty or contained only ambiguous entries such as <TT CLASS="LITERAL" >NULL</TT >. Now the cast is consulted to determine the type that the array elements must be. </P ></LI ><LI ><P > Make <ACRONYM CLASS="ACRONYM" >SQL</ACRONYM >-syntax <TT CLASS="TYPE" >ARRAY</TT > dimensions optional to match the <ACRONYM CLASS="ACRONYM" >SQL</ACRONYM > standard (Peter) </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >array_ndims()</CODE > to return the number of dimensions of an array (Robert Haas) </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >array_length()</CODE > to return the length of an array for a specified dimension (Jim Nasby, Robert Haas, Peter Eisentraut) </P ></LI ><LI ><P > Add aggregate function <CODE CLASS="FUNCTION" >array_agg()</CODE >, which returns all aggregated values as a single array (Robert Haas, Jeff Davis, Peter) </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >unnest()</CODE >, which converts an array to individual row values (Tom) </P ><P > This is the opposite of <CODE CLASS="FUNCTION" >array_agg()</CODE >. </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >array_fill()</CODE > to create arrays initialized with a value (Pavel Stehule) </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >generate_subscripts()</CODE > to simplify generating the range of an array's subscripts (Pavel Stehule) </P ></LI ></UL ></DIV ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN128322" >E.97.3.6.3. Wide-Value Storage (<ACRONYM CLASS="ACRONYM" >TOAST</ACRONYM >)</A ></H4 ><P ></P ><UL ><LI ><P > Consider <ACRONYM CLASS="ACRONYM" >TOAST</ACRONYM > compression on values as short as 32 bytes (previously 256 bytes) (Greg Stark) </P ></LI ><LI ><P > Require 25% minimum space savings before using <ACRONYM CLASS="ACRONYM" >TOAST</ACRONYM > compression (previously 20% for small values and any-savings-at-all for large values) (Greg) </P ></LI ><LI ><P > Improve <ACRONYM CLASS="ACRONYM" >TOAST</ACRONYM > heuristics for rows that have a mix of large and small toastable fields, so that we prefer to push large values out of line and don't compress small values unnecessarily (Greg, Tom) </P ></LI ></UL ></DIV ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN128335" >E.97.3.7. Functions</A ></H3 ><P ></P ><UL ><LI ><P > Document that <CODE CLASS="FUNCTION" >setseed()</CODE > allows values from <TT CLASS="LITERAL" >-1</TT > to <TT CLASS="LITERAL" >1</TT > (not just <TT CLASS="LITERAL" >0</TT > to <TT CLASS="LITERAL" >1</TT >), and enforce the valid range (Kris Jurka) </P ></LI ><LI ><P > Add server-side function <CODE CLASS="FUNCTION" >lo_import(filename, oid)</CODE > (Tatsuo) </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >quote_nullable()</CODE >, which behaves like <CODE CLASS="FUNCTION" >quote_literal()</CODE > but returns the string <TT CLASS="LITERAL" >NULL</TT > for a null argument (Brendan Jurd) </P ></LI ><LI ><P > Improve full text search <CODE CLASS="FUNCTION" >headline()</CODE > function to allow extracting several fragments of text (Sushant Sinha) </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >suppress_redundant_updates_trigger()</CODE > trigger function to avoid overhead for non-data-changing updates (Andrew) </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >div(numeric, numeric)</CODE > to perform <TT CLASS="TYPE" >numeric</TT > division without rounding (Tom) </P ></LI ><LI ><P > Add <TT CLASS="TYPE" >timestamp</TT > and <TT CLASS="TYPE" >timestamptz</TT > versions of <CODE CLASS="FUNCTION" >generate_series()</CODE > (Hitoshi Harada) </P ></LI ></UL ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN128368" >E.97.3.7.1. Object Information Functions</A ></H4 ><P ></P ><UL ><LI ><P > Implement <CODE CLASS="FUNCTION" >current_query()</CODE > for use by functions that need to know the currently running query (Tomas Doran) </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >pg_get_keywords()</CODE > to return a list of the parser keywords (Dave Page) </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >pg_get_functiondef()</CODE > to see a function's definition (Abhijit Menon-Sen) </P ></LI ><LI ><P > Allow the second argument of <CODE CLASS="FUNCTION" >pg_get_expr()</CODE > to be zero when deparsing an expression that does not contain variables (Tom) </P ></LI ><LI ><P > Modify <CODE CLASS="FUNCTION" >pg_relation_size()</CODE > to use <TT CLASS="LITERAL" >regclass</TT > (Heikki) </P ><P > <CODE CLASS="FUNCTION" >pg_relation_size(data_type_name)</CODE > no longer works. </P ></LI ><LI ><P > Add <TT CLASS="LITERAL" >boot_val</TT > and <TT CLASS="LITERAL" >reset_val</TT > columns to <TT CLASS="LITERAL" >pg_settings</TT > output (Greg Smith) </P ></LI ><LI ><P > Add source file name and line number columns to <TT CLASS="LITERAL" >pg_settings</TT > output for variables set in a configuration file (Magnus, Alvaro) </P ><P > For security reasons, these columns are only visible to superusers. </P ></LI ><LI ><P > Add support for <TT CLASS="VARNAME" >CURRENT_CATALOG</TT >, <TT CLASS="VARNAME" >CURRENT_SCHEMA</TT >, <TT CLASS="VARNAME" >SET CATALOG</TT >, <TT CLASS="VARNAME" >SET SCHEMA</TT > (Peter) </P ><P > These provide <ACRONYM CLASS="ACRONYM" >SQL</ACRONYM >-standard syntax for existing features. </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >pg_typeof()</CODE > which returns the data type of any value (Brendan Jurd) </P ></LI ><LI ><P > Make <CODE CLASS="FUNCTION" >version()</CODE > return information about whether the server is a 32- or 64-bit binary (Bruce) </P ></LI ><LI ><P > Fix the behavior of information schema columns <TT CLASS="STRUCTFIELD" >is_insertable_into</TT > and <TT CLASS="STRUCTFIELD" >is_updatable</TT > to be consistent (Peter) </P ></LI ><LI ><P > Improve the behavior of information schema <TT CLASS="STRUCTFIELD" >datetime_precision</TT > columns (Peter) </P ><P > These columns now show zero for <TT CLASS="TYPE" >date</TT > columns, and 6 (the default precision) for <TT CLASS="TYPE" >time</TT >, <TT CLASS="TYPE" >timestamp</TT >, and <TT CLASS="TYPE" >interval</TT > without a declared precision, rather than showing null as formerly. </P ></LI ><LI ><P > Convert remaining builtin set-returning functions to use <TT CLASS="LITERAL" >OUT</TT > parameters (Jaime Casanova) </P ><P > This makes it possible to call these functions without specifying a column list: <CODE CLASS="FUNCTION" >pg_show_all_settings()</CODE >, <CODE CLASS="FUNCTION" >pg_lock_status()</CODE >, <CODE CLASS="FUNCTION" >pg_prepared_xact()</CODE >, <CODE CLASS="FUNCTION" >pg_prepared_statement()</CODE >, <CODE CLASS="FUNCTION" >pg_cursor()</CODE > </P ></LI ><LI ><P > Make <CODE CLASS="FUNCTION" >pg_*_is_visible()</CODE > and <CODE CLASS="FUNCTION" >has_*_privilege()</CODE > functions return <TT CLASS="LITERAL" >NULL</TT > for invalid OIDs, rather than reporting an error (Tom) </P ></LI ><LI ><P > Extend <CODE CLASS="FUNCTION" >has_*_privilege()</CODE > functions to allow inquiring about the OR of multiple privileges in one call (Stephen Frost, Tom) </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >has_column_privilege()</CODE > and <CODE CLASS="FUNCTION" >has_any_column_privilege()</CODE > functions (Stephen Frost, Tom) </P ></LI ></UL ></DIV ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN128445" >E.97.3.7.2. Function Creation</A ></H4 ><P ></P ><UL ><LI ><P > Support variadic functions (functions with a variable number of arguments) (Pavel Stehule) </P ><P > Only trailing arguments can be optional, and they all must be of the same data type. </P ></LI ><LI ><P > Support default values for function arguments (Pavel Stehule) </P ></LI ><LI ><P > Add <TT CLASS="COMMAND" >CREATE FUNCTION ... RETURNS TABLE</TT > clause (Pavel Stehule) </P ></LI ><LI ><P > Allow <ACRONYM CLASS="ACRONYM" >SQL</ACRONYM >-language functions to return the output of an <TT CLASS="COMMAND" >INSERT</TT >/<TT CLASS="COMMAND" >UPDATE</TT >/<TT CLASS="COMMAND" >DELETE</TT > <TT CLASS="LITERAL" >RETURNING</TT > clause (Tom) </P ></LI ></UL ></DIV ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN128463" >E.97.3.7.3. PL/pgSQL Server-Side Language</A ></H4 ><P ></P ><UL ><LI ><P > Support <TT CLASS="LITERAL" >EXECUTE USING</TT > for easier insertion of data values into a dynamic query string (Pavel Stehule) </P ></LI ><LI ><P > Allow looping over the results of a cursor using a <TT CLASS="LITERAL" >FOR</TT > loop (Pavel Stehule) </P ></LI ><LI ><P > Support <TT CLASS="LITERAL" >RETURN QUERY EXECUTE</TT > (Pavel Stehule) </P ></LI ><LI ><P > Improve the <TT CLASS="LITERAL" >RAISE</TT > command (Pavel Stehule) <P ></P ></P><UL ><LI ><P > Support <TT CLASS="LITERAL" >DETAIL</TT > and <TT CLASS="LITERAL" >HINT</TT > fields </P ></LI ><LI ><P > Support specification of the <TT CLASS="LITERAL" >SQLSTATE</TT > error code </P ></LI ><LI ><P > Support an exception name parameter </P ></LI ><LI ><P > Allow <TT CLASS="LITERAL" >RAISE</TT > without parameters in an exception block to re-throw the current error </P ></LI ></UL ><P> </P ></LI ><LI ><P > Allow specification of <TT CLASS="VARNAME" >SQLSTATE</TT > codes in <TT CLASS="LITERAL" >EXCEPTION</TT > lists (Pavel Stehule) </P ><P > This is useful for handling custom <TT CLASS="VARNAME" >SQLSTATE</TT > codes. </P ></LI ><LI ><P > Support the <TT CLASS="LITERAL" >CASE</TT > statement (Pavel Stehule) </P ></LI ><LI ><P > Make <TT CLASS="COMMAND" >RETURN QUERY</TT > set the special <TT CLASS="LITERAL" >FOUND</TT > and <TT CLASS="COMMAND" >GET DIAGNOSTICS</TT > <TT CLASS="LITERAL" >ROW_COUNT</TT > variables (Pavel Stehule) </P ></LI ><LI ><P > Make <TT CLASS="COMMAND" >FETCH</TT > and <TT CLASS="COMMAND" >MOVE</TT > set the <TT CLASS="COMMAND" >GET DIAGNOSTICS</TT > <TT CLASS="LITERAL" >ROW_COUNT</TT > variable (Andrew Gierth) </P ></LI ><LI ><P > Make <TT CLASS="COMMAND" >EXIT</TT > without a label always exit the innermost loop (Tom) </P ><P > Formerly, if there were a <TT CLASS="LITERAL" >BEGIN</TT > block more closely nested than any loop, it would exit that block instead. The new behavior matches Oracle(TM) and is also what was previously stated by our own documentation. </P ></LI ><LI ><P > Make processing of string literals and nested block comments match the main SQL parser's processing (Tom) </P ><P > In particular, the format string in <TT CLASS="COMMAND" >RAISE</TT > now works the same as any other string literal, including being subject to <TT CLASS="VARNAME" >standard_conforming_strings</TT >. This change also fixes other cases in which valid commands would fail when <TT CLASS="VARNAME" >standard_conforming_strings</TT > is on. </P ></LI ><LI ><P > Avoid memory leakage when the same function is called at varying exception-block nesting depths (Tom) </P ></LI ></UL ></DIV ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN128525" >E.97.3.8. Client Applications</A ></H3 ><P ></P ><UL ><LI ><P > Fix <TT CLASS="LITERAL" >pg_ctl restart</TT > to preserve command-line arguments (Bruce) </P ></LI ><LI ><P > Add <TT CLASS="LITERAL" >-w</TT >/<TT CLASS="LITERAL" >--no-password</TT > option that prevents password prompting in all utilities that have a <TT CLASS="LITERAL" >-W</TT >/<TT CLASS="LITERAL" >--password</TT > option (Peter) </P ></LI ><LI ><P > Remove <TT CLASS="OPTION" >-q</TT > (quiet) option of <SPAN CLASS="APPLICATION" >createdb</SPAN >, <SPAN CLASS="APPLICATION" >createuser</SPAN >, <SPAN CLASS="APPLICATION" >dropdb</SPAN >, <SPAN CLASS="APPLICATION" >dropuser</SPAN > (Peter) </P ><P > These options have had no effect since <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > 8.3. </P ></LI ></UL ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN128546" >E.97.3.8.1. <SPAN CLASS="APPLICATION" >psql</SPAN ></A ></H4 ><P ></P ><UL ><LI ><P > Remove verbose startup banner; now just suggest <TT CLASS="LITERAL" >help</TT > (Joshua Drake) </P ></LI ><LI ><P > Make <TT CLASS="LITERAL" >help</TT > show common backslash commands (Greg Sabino Mullane) </P ></LI ><LI ><P > Add <TT CLASS="LITERAL" >\pset format wrapped</TT > mode to wrap output to the screen width, or file/pipe output too if <TT CLASS="LITERAL" >\pset columns</TT > is set (Bryce Nesbitt) </P ></LI ><LI ><P > Allow all supported spellings of boolean values in <TT CLASS="COMMAND" >\pset</TT >, rather than just <TT CLASS="LITERAL" >on</TT > and <TT CLASS="LITERAL" >off</TT > (Bruce) </P ><P > Formerly, any string other than <SPAN CLASS="QUOTE" >"off"</SPAN > was silently taken to mean <TT CLASS="LITERAL" >true</TT >. <SPAN CLASS="APPLICATION" >psql</SPAN > will now complain about unrecognized spellings (but still take them as <TT CLASS="LITERAL" >true</TT >). </P ></LI ><LI ><P > Use the pager for wide output (Bruce) </P ></LI ><LI ><P > Require a space between a one-letter backslash command and its first argument (Bernd Helmle) </P ><P > This removes a historical source of ambiguity. </P ></LI ><LI ><P > Improve tab completion support for schema-qualified and quoted identifiers (Greg Sabino Mullane) </P ></LI ><LI ><P > Add optional <TT CLASS="LITERAL" >on</TT >/<TT CLASS="LITERAL" >off</TT > argument for <TT CLASS="COMMAND" >\timing</TT > (David Fetter) </P ></LI ><LI ><P > Display access control rights on multiple lines (Brendan Jurd, Andreas Scherbaum) </P ></LI ><LI ><P > Make <TT CLASS="COMMAND" >\l</TT > show database access privileges (Andrew Gilligan) </P ></LI ><LI ><P > Make <TT CLASS="COMMAND" >\l+</TT > show database sizes, if permissions allow (Andrew Gilligan) </P ></LI ><LI ><P > Add the <TT CLASS="COMMAND" >\ef</TT > command to edit function definitions (Abhijit Menon-Sen) </P ></LI ></UL ></DIV ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN128593" >E.97.3.8.2. <SPAN CLASS="APPLICATION" >psql</SPAN > \d* commands</A ></H4 ><P ></P ><UL ><LI ><P > Make <TT CLASS="COMMAND" >\d*</TT > commands that do not have a pattern argument show system objects only if the <TT CLASS="LITERAL" >S</TT > modifier is specified (Greg Sabino Mullane, Bruce) </P ><P > The former behavior was inconsistent across different variants of <TT CLASS="COMMAND" >\d</TT >, and in most cases it provided no easy way to see just user objects. </P ></LI ><LI ><P > Improve <TT CLASS="COMMAND" >\d*</TT > commands to work with older <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > server versions (back to 7.4), not only the current server version (Guillaume Lelarge) </P ></LI ><LI ><P > Make <TT CLASS="COMMAND" >\d</TT > show foreign-key constraints that reference the selected table (Kenneth D'Souza) </P ></LI ><LI ><P > Make <TT CLASS="COMMAND" >\d</TT > on a sequence show its column values (Euler Taveira de Oliveira) </P ></LI ><LI ><P > Add column storage type and other relation options to the <TT CLASS="COMMAND" >\d+</TT > display (Gregory Stark, Euler Taveira de Oliveira) </P ></LI ><LI ><P > Show relation size in <TT CLASS="COMMAND" >\dt+</TT > output (Dickson S. Guedes) </P ></LI ><LI ><P > Show the possible values of <TT CLASS="LITERAL" >enum</TT > types in <TT CLASS="COMMAND" >\dT+</TT > (David Fetter) </P ></LI ><LI ><P > Allow <TT CLASS="COMMAND" >\dC</TT > to accept a wildcard pattern, which matches either datatype involved in the cast (Tom) </P ></LI ><LI ><P > Add a function type column to <TT CLASS="COMMAND" >\df</TT >'s output, and add options to list only selected types of functions (David Fetter) </P ></LI ><LI ><P > Make <TT CLASS="COMMAND" >\df</TT > not hide functions that take or return type <TT CLASS="TYPE" >cstring</TT > (Tom) </P ><P > Previously, such functions were hidden because most of them are datatype I/O functions, which were deemed uninteresting. The new policy about hiding system functions by default makes this wart unnecessary. </P ></LI ></UL ></DIV ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN128634" >E.97.3.8.3. <SPAN CLASS="APPLICATION" >pg_dump</SPAN ></A ></H4 ><P ></P ><UL ><LI ><P > Add a <TT CLASS="LITERAL" >--no-tablespaces</TT > option to <SPAN CLASS="APPLICATION" >pg_dump</SPAN >/<SPAN CLASS="APPLICATION" >pg_dumpall</SPAN >/<SPAN CLASS="APPLICATION" >pg_restore</SPAN > so that dumps can be restored to clusters that have non-matching tablespace layouts (Gavin Roy) </P ></LI ><LI ><P > Remove <TT CLASS="OPTION" >-d</TT > and <TT CLASS="OPTION" >-D</TT > options from <SPAN CLASS="APPLICATION" >pg_dump</SPAN > and <SPAN CLASS="APPLICATION" >pg_dumpall</SPAN > (Tom) </P ><P > These options were too frequently confused with the option to select a database name in other <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > client applications. The functionality is still available, but you must now spell out the long option name <TT CLASS="OPTION" >--inserts</TT > or <TT CLASS="OPTION" >--column-inserts</TT >. </P ></LI ><LI ><P > Remove <TT CLASS="OPTION" >-i</TT >/<TT CLASS="OPTION" >--ignore-version</TT > option from <SPAN CLASS="APPLICATION" >pg_dump</SPAN > and <SPAN CLASS="APPLICATION" >pg_dumpall</SPAN > (Tom) </P ><P > Use of this option does not throw an error, but it has no effect. This option was removed because the version checks are necessary for safety. </P ></LI ><LI ><P > Disable <TT CLASS="VARNAME" >statement_timeout</TT > during dump and restore (Joshua Drake) </P ></LI ><LI ><P > Add <SPAN CLASS="APPLICATION" >pg_dump</SPAN >/<SPAN CLASS="APPLICATION" >pg_dumpall</SPAN > option <TT CLASS="OPTION" >--lock-wait-timeout</TT > (David Gould) </P ><P > This allows dumps to fail if unable to acquire a shared lock within the specified amount of time. </P ></LI ><LI ><P > Reorder <SPAN CLASS="APPLICATION" >pg_dump</SPAN > <TT CLASS="LITERAL" >--data-only</TT > output to dump tables referenced by foreign keys before the referencing tables (Tom) </P ><P > This allows data loads when foreign keys are already present. If circular references make a safe ordering impossible, a <TT CLASS="LITERAL" >NOTICE</TT > is issued. </P ></LI ><LI ><P > Allow <SPAN CLASS="APPLICATION" >pg_dump</SPAN >, <SPAN CLASS="APPLICATION" >pg_dumpall</SPAN >, and <SPAN CLASS="APPLICATION" >pg_restore</SPAN > to use a specified role (Benedek László) </P ></LI ><LI ><P > Allow <SPAN CLASS="APPLICATION" >pg_restore</SPAN > to use multiple concurrent connections to do the restore (Andrew) </P ><P > The number of concurrent connections is controlled by the option <TT CLASS="LITERAL" >--jobs</TT >. This is supported only for custom-format archives. </P ></LI ></UL ></DIV ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN128686" >E.97.3.9. Programming Tools</A ></H3 ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN128688" >E.97.3.9.1. <SPAN CLASS="APPLICATION" >libpq</SPAN ></A ></H4 ><P ></P ><UL ><LI ><P > Allow the <TT CLASS="TYPE" >OID</TT > to be specified when importing a large object, via new function <CODE CLASS="FUNCTION" >lo_import_with_oid()</CODE > (Tatsuo) </P ></LI ><LI ><P > Add <SPAN CLASS="QUOTE" >"events"</SPAN > support (Andrew Chernow, Merlin Moncure) </P ><P > This adds the ability to register callbacks to manage private data associated with <TT CLASS="STRUCTNAME" >PGconn</TT > and <TT CLASS="STRUCTNAME" >PGresult</TT > objects. </P ></LI ><LI ><P > Improve error handling to allow the return of multiple error messages as multi-line error reports (Magnus) </P ></LI ><LI ><P > Make <CODE CLASS="FUNCTION" >PQexecParams()</CODE > and related functions return <TT CLASS="VARNAME" >PGRES_EMPTY_QUERY</TT > for an empty query (Tom) </P ><P > They previously returned <TT CLASS="VARNAME" >PGRES_COMMAND_OK</TT >. </P ></LI ><LI ><P > Document how to avoid the overhead of <CODE CLASS="FUNCTION" >WSACleanup()</CODE > on Windows (Andrew Chernow) </P ></LI ><LI ><P > Do not rely on Kerberos tickets to determine the default database username (Magnus) </P ><P > Previously, a Kerberos-capable build of libpq would use the principal name from any available Kerberos ticket as default database username, even if the connection wasn't using Kerberos authentication. This was deemed inconsistent and confusing. The default username is now determined the same way with or without Kerberos. Note however that the database username must still match the ticket when Kerberos authentication is used. </P ></LI ></UL ></DIV ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN128716" >E.97.3.9.2. <SPAN CLASS="APPLICATION" >libpq</SPAN > <ACRONYM CLASS="ACRONYM" >SSL</ACRONYM > (Secure Sockets Layer) support</A ></H4 ><P ></P ><UL ><LI ><P > Fix certificate validation for <ACRONYM CLASS="ACRONYM" >SSL</ACRONYM > connections (Magnus) </P ><P > <SPAN CLASS="APPLICATION" >libpq</SPAN > now supports verifying both the certificate and the name of the server when making <ACRONYM CLASS="ACRONYM" >SSL</ACRONYM > connections. If a root certificate is not available to use for verification, <ACRONYM CLASS="ACRONYM" >SSL</ACRONYM > connections will fail. The <TT CLASS="LITERAL" >sslmode</TT > parameter is used to enable certificate verification and set the level of checking. The default is still not to do any verification, allowing connections to SSL-enabled servers without requiring a root certificate on the client. </P ></LI ><LI ><P > Support wildcard server certificates (Magnus) </P ><P > If a certificate <ACRONYM CLASS="ACRONYM" >CN</ACRONYM > starts with <TT CLASS="LITERAL" >*</TT >, it will be treated as a wildcard when matching the hostname, allowing the use of the same certificate for multiple servers. </P ></LI ><LI ><P > Allow the file locations for client certificates to be specified (Mark Woodward, Alvaro, Magnus) </P ></LI ><LI ><P > Add a <CODE CLASS="FUNCTION" >PQinitOpenSSL</CODE > function to allow greater control over OpenSSL/libcrypto initialization (Andrew Chernow) </P ></LI ><LI ><P > Make <SPAN CLASS="APPLICATION" >libpq</SPAN > unregister its <SPAN CLASS="APPLICATION" >OpenSSL</SPAN > callbacks when no database connections remain open (Bruce, Magnus, Russell Smith) </P ><P > This is required for applications that unload the libpq library, otherwise invalid <SPAN CLASS="APPLICATION" >OpenSSL</SPAN > callbacks will remain. </P ></LI ></UL ></DIV ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN128745" >E.97.3.9.3. <SPAN CLASS="APPLICATION" >ecpg</SPAN ></A ></H4 ><P ></P ><UL ><LI ><P > Add localization support for messages (Euler Taveira de Oliveira) </P ></LI ><LI ><P > ecpg parser is now automatically generated from the server parser (Michael) </P ><P > Previously the ecpg parser was hand-maintained. </P ></LI ></UL ></DIV ><DIV CLASS="SECT4" ><H4 CLASS="SECT4" ><A NAME="AEN128754" >E.97.3.9.4. Server Programming Interface (<ACRONYM CLASS="ACRONYM" >SPI</ACRONYM >)</A ></H4 ><P ></P ><UL ><LI ><P > Add support for single-use plans with out-of-line parameters (Tom) </P ></LI ><LI ><P > Add new <TT CLASS="VARNAME" >SPI_OK_REWRITTEN</TT > return code for <CODE CLASS="FUNCTION" >SPI_execute()</CODE > (Heikki) </P ><P > This is used when a command is rewritten to another type of command. </P ></LI ><LI ><P > Remove unnecessary inclusions from <TT CLASS="FILENAME" >executor/spi.h</TT > (Tom) </P ><P > SPI-using modules might need to add some <TT CLASS="LITERAL" >#include</TT > lines if they were depending on <TT CLASS="FILENAME" >spi.h</TT > to include things for them. </P ></LI ></UL ></DIV ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN128771" >E.97.3.10. Build Options</A ></H3 ><P ></P ><UL ><LI ><P > Update build system to use <SPAN CLASS="PRODUCTNAME" >Autoconf</SPAN > 2.61 (Peter) </P ></LI ><LI ><P > Require <SPAN CLASS="PRODUCTNAME" >GNU bison</SPAN > for source code builds (Peter) </P ><P > This has effectively been required for several years, but now there is no infrastructure claiming to support other parser tools. </P ></LI ><LI ><P > Add <SPAN CLASS="APPLICATION" >pg_config</SPAN > <TT CLASS="LITERAL" >--htmldir</TT > option (Peter) </P ></LI ><LI ><P > Pass <TT CLASS="TYPE" >float4</TT > by value inside the server (Zoltan Boszormenyi) </P ><P > Add <SPAN CLASS="APPLICATION" >configure</SPAN > option <TT CLASS="LITERAL" >--disable-float4-byval</TT > to use the old behavior. External C functions that use old-style (version 0) call convention and pass or return <TT CLASS="TYPE" >float4</TT > values will be broken by this change, so you may need the <SPAN CLASS="APPLICATION" >configure</SPAN > option if you have such functions and don't want to update them. </P ></LI ><LI ><P > Pass <TT CLASS="TYPE" >float8</TT >, <TT CLASS="TYPE" >int8</TT >, and related datatypes by value inside the server on 64-bit platforms (Zoltan Boszormenyi) </P ><P > Add <SPAN CLASS="APPLICATION" >configure</SPAN > option <TT CLASS="LITERAL" >--disable-float8-byval</TT > to use the old behavior. As above, this change might break old-style external C functions. </P ></LI ><LI ><P > Add configure options <TT CLASS="LITERAL" >--with-segsize</TT >, <TT CLASS="LITERAL" >--with-blocksize</TT >, <TT CLASS="LITERAL" >--with-wal-blocksize</TT >, <TT CLASS="LITERAL" >--with-wal-segsize</TT > (Zdenek Kotala, Tom) </P ><P > This simplifies build-time control over several constants that previously could only be changed by editing <TT CLASS="FILENAME" >pg_config_manual.h</TT >. </P ></LI ><LI ><P > Allow threaded builds on <SPAN CLASS="PRODUCTNAME" >Solaris</SPAN > 2.5 (Bruce) </P ></LI ><LI ><P > Use the system's <CODE CLASS="FUNCTION" >getopt_long()</CODE > on <SPAN CLASS="PRODUCTNAME" >Solaris</SPAN > (Zdenek Kotala, Tom) </P ><P > This makes option processing more consistent with what Solaris users expect. </P ></LI ><LI ><P > Add support for the <SPAN CLASS="PRODUCTNAME" >Sun Studio</SPAN > compiler on <SPAN CLASS="PRODUCTNAME" >Linux</SPAN > (Julius Stroffek) </P ></LI ><LI ><P > Append the major version number to the backend <SPAN CLASS="APPLICATION" >gettext</SPAN > domain, and the <TT CLASS="LITERAL" >soname</TT > major version number to libraries' <SPAN CLASS="APPLICATION" >gettext</SPAN > domain (Peter) </P ><P > This simplifies parallel installations of multiple versions. </P ></LI ><LI ><P > Add support for code coverage testing with <SPAN CLASS="APPLICATION" >gcov</SPAN > (Michelle Caisse) </P ></LI ><LI ><P > Allow out-of-tree builds on <SPAN CLASS="PRODUCTNAME" >Mingw</SPAN > and <SPAN CLASS="PRODUCTNAME" >Cygwin</SPAN > (Richard Evans) </P ></LI ><LI ><P > Fix the use of <SPAN CLASS="PRODUCTNAME" >Mingw</SPAN > as a cross-compiling source platform (Peter) </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN128836" >E.97.3.11. Source Code</A ></H3 ><P ></P ><UL ><LI ><P > Support 64-bit time zone data files (Heikki) </P ><P > This adds support for daylight saving time (<ACRONYM CLASS="ACRONYM" >DST</ACRONYM >) calculations beyond the year 2038. </P ></LI ><LI ><P > Deprecate use of platform's <TT CLASS="TYPE" >time_t</TT > data type (Tom) </P ><P > Some platforms have migrated to 64-bit <TT CLASS="TYPE" >time_t</TT >, some have not, and Windows can't make up its mind what it's doing. Define <TT CLASS="TYPE" >pg_time_t</TT > to have the same meaning as <TT CLASS="TYPE" >time_t</TT >, but always be 64 bits (unless the platform has no 64-bit integer type), and use that type in all module APIs and on-disk data formats. </P ></LI ><LI ><P > Fix bug in handling of the time zone database when cross-compiling (Richard Evans) </P ></LI ><LI ><P > Link backend object files in one step, rather than in stages (Peter) </P ></LI ><LI ><P > Improve <SPAN CLASS="APPLICATION" >gettext</SPAN > support to allow better translation of plurals (Peter) </P ></LI ><LI ><P > Add message translation support to the PL languages (Alvaro, Peter) </P ></LI ><LI ><P > Add more <SPAN CLASS="APPLICATION" >DTrace</SPAN > probes (Robert Lor) </P ></LI ><LI ><P > Enable <SPAN CLASS="APPLICATION" >DTrace</SPAN > support on <SPAN CLASS="APPLICATION" >Mac OS X Leopard</SPAN > and other non-Solaris platforms (Robert Lor) </P ></LI ><LI ><P > Simplify and standardize conversions between C strings and <TT CLASS="TYPE" >text</TT > datums, by providing common functions for the purpose (Brendan Jurd, Tom) </P ></LI ><LI ><P > Clean up the <TT CLASS="FILENAME" >include/catalog/</TT > header files so that frontend programs can include them without including <TT CLASS="FILENAME" >postgres.h</TT > (Zdenek Kotala) </P ></LI ><LI ><P > Make <TT CLASS="TYPE" >name</TT > char-aligned, and suppress zero-padding of <TT CLASS="TYPE" >name</TT > entries in indexes (Tom) </P ></LI ><LI ><P > Recover better if dynamically-loaded code executes <CODE CLASS="FUNCTION" >exit()</CODE > (Tom) </P ></LI ><LI ><P > Add a hook to let plug-ins monitor the executor (Itagaki Takahiro) </P ></LI ><LI ><P > Add a hook to allow the planner's statistics lookup behavior to be overridden (Simon Riggs) </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >shmem_startup_hook()</CODE > for custom shared memory requirements (Tom) </P ></LI ><LI ><P > Replace the index access method <CODE CLASS="FUNCTION" >amgetmulti</CODE > entry point with <CODE CLASS="FUNCTION" >amgetbitmap</CODE >, and extend the API for <CODE CLASS="FUNCTION" >amgettuple</CODE > to support run-time determination of operator lossiness (Heikki, Tom, Teodor) </P ><P > The API for GIN and GiST opclass <CODE CLASS="FUNCTION" >consistent</CODE > functions has been extended as well. </P ></LI ><LI ><P > Add support for partial-match searches in <ACRONYM CLASS="ACRONYM" >GIN</ACRONYM > indexes (Teodor Sigaev, Oleg Bartunov) </P ></LI ><LI ><P > Replace <TT CLASS="STRUCTNAME" >pg_class</TT > column <TT CLASS="STRUCTFIELD" >reltriggers</TT > with boolean <TT CLASS="STRUCTFIELD" >relhastriggers</TT > (Simon) </P ><P > Also remove unused <TT CLASS="STRUCTNAME" >pg_class</TT > columns <TT CLASS="STRUCTFIELD" >relukeys</TT >, <TT CLASS="STRUCTFIELD" >relfkeys</TT >, and <TT CLASS="STRUCTFIELD" >relrefs</TT >. </P ></LI ><LI ><P > Add a <TT CLASS="STRUCTFIELD" >relistemp</TT > column to <TT CLASS="STRUCTNAME" >pg_class</TT > to ease identification of temporary tables (Tom) </P ></LI ><LI ><P > Move platform <ACRONYM CLASS="ACRONYM" >FAQ</ACRONYM >s into the main documentation (Peter) </P ></LI ><LI ><P > Prevent parser input files from being built with any conflicts (Peter) </P ></LI ><LI ><P > Add support for the <TT CLASS="LITERAL" >KOI8U</TT > (Ukrainian) encoding (Peter) </P ></LI ><LI ><P > Add Japanese message translations (Japan PostgreSQL Users Group) </P ><P > This used to be maintained as a separate project. </P ></LI ><LI ><P > Fix problem when setting <TT CLASS="VARNAME" >LC_MESSAGES</TT > on <SPAN CLASS="APPLICATION" >MSVC</SPAN >-built systems (Hiroshi Inoue, Hiroshi Saito, Magnus) </P ></LI ></UL ></DIV ><DIV CLASS="SECT3" ><H3 CLASS="SECT3" ><A NAME="AEN128926" >E.97.3.12. Contrib</A ></H3 ><P ></P ><UL ><LI ><P > Add <TT CLASS="FILENAME" >contrib/auto_explain</TT > to automatically run <TT CLASS="COMMAND" >EXPLAIN</TT > on queries exceeding a specified duration (Itagaki Takahiro, Tom) </P ></LI ><LI ><P > Add <TT CLASS="FILENAME" >contrib/btree_gin</TT > to allow GIN indexes to handle more datatypes (Oleg, Teodor) </P ></LI ><LI ><P > Add <TT CLASS="FILENAME" >contrib/citext</TT > to provide a case-insensitive, multibyte-aware text data type (David Wheeler) </P ></LI ><LI ><P > Add <TT CLASS="FILENAME" >contrib/pg_stat_statements</TT > for server-wide tracking of statement execution statistics (Itagaki Takahiro) </P ></LI ><LI ><P > Add duration and query mode options to <TT CLASS="FILENAME" >contrib/pgbench</TT > (Itagaki Takahiro) </P ></LI ><LI ><P > Make <TT CLASS="FILENAME" >contrib/pgbench</TT > use table names <TT CLASS="STRUCTNAME" >pgbench_accounts</TT >, <TT CLASS="STRUCTNAME" >pgbench_branches</TT >, <TT CLASS="STRUCTNAME" >pgbench_history</TT >, and <TT CLASS="STRUCTNAME" >pgbench_tellers</TT >, rather than just <TT CLASS="STRUCTNAME" >accounts</TT >, <TT CLASS="STRUCTNAME" >branches</TT >, <TT CLASS="STRUCTNAME" >history</TT >, and <TT CLASS="STRUCTNAME" >tellers</TT > (Tom) </P ><P > This is to reduce the risk of accidentally destroying real data by running <SPAN CLASS="APPLICATION" >pgbench</SPAN >. </P ></LI ><LI ><P > Fix <TT CLASS="FILENAME" >contrib/pgstattuple</TT > to handle tables and indexes with over 2 billion pages (Tatsuhito Kasahara) </P ></LI ><LI ><P > In <TT CLASS="FILENAME" >contrib/fuzzystrmatch</TT >, add a version of the Levenshtein string-distance function that allows the user to specify the costs of insertion, deletion, and substitution (Volkan Yazici) </P ></LI ><LI ><P > Make <TT CLASS="FILENAME" >contrib/ltree</TT > support multibyte encodings (laser) </P ></LI ><LI ><P > Enable <TT CLASS="FILENAME" >contrib/dblink</TT > to use connection information stored in the SQL/MED catalogs (Joe Conway) </P ></LI ><LI ><P > Improve <TT CLASS="FILENAME" >contrib/dblink</TT >'s reporting of errors from the remote server (Joe Conway) </P ></LI ><LI ><P > Make <TT CLASS="FILENAME" >contrib/dblink</TT > set <TT CLASS="VARNAME" >client_encoding</TT > to match the local database's encoding (Joe Conway) </P ><P > This prevents encoding problems when communicating with a remote database that uses a different encoding. </P ></LI ><LI ><P > Make sure <TT CLASS="FILENAME" >contrib/dblink</TT > uses a password supplied by the user, and not accidentally taken from the server's <TT CLASS="FILENAME" >.pgpass</TT > file (Joe Conway) </P ><P > This is a minor security enhancement. </P ></LI ><LI ><P > Add <CODE CLASS="FUNCTION" >fsm_page_contents()</CODE > to <TT CLASS="FILENAME" >contrib/pageinspect</TT > (Heikki) </P ></LI ><LI ><P > Modify <CODE CLASS="FUNCTION" >get_raw_page()</CODE > to support free space map (<TT CLASS="FILENAME" >*_fsm</TT >) files. Also update <TT CLASS="FILENAME" >contrib/pg_freespacemap</TT >. </P ></LI ><LI ><P > Add support for multibyte encodings to <TT CLASS="FILENAME" >contrib/pg_trgm</TT > (Teodor) </P ></LI ><LI ><P > Rewrite <TT CLASS="FILENAME" >contrib/intagg</TT > to use new functions <CODE CLASS="FUNCTION" >array_agg()</CODE > and <CODE CLASS="FUNCTION" >unnest()</CODE > (Tom) </P ></LI ><LI ><P > Make <TT CLASS="FILENAME" >contrib/pg_standby</TT > recover all available WAL before failover (Fujii Masao, Simon, Heikki) </P ><P > To make this work safely, you now need to set the new <TT CLASS="LITERAL" >recovery_end_command</TT > option in <TT CLASS="FILENAME" >recovery.conf</TT > to clean up the trigger file after failover. <SPAN CLASS="APPLICATION" >pg_standby</SPAN > will no longer remove the trigger file itself. </P ></LI ><LI ><P > <TT CLASS="FILENAME" >contrib/pg_standby</TT >'s <TT CLASS="OPTION" >-l</TT > option is now a no-op, because it is unsafe to use a symlink (Simon) </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-4-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-3-23.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Release 8.4.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.3.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
