summaryrefslogtreecommitdiff
path: root/doc/src/sgml/errcodes.sgml
AgeCommit message (Collapse)Author
2020-05-06Doc: remove now-redundant align specifications in colspecs.Tom Lane
In the wake of commit f21599311, we don't need to set table columns' align specs retail. Undo a few such settings I'd added in commit 5545b69ae. (The column width adjustments stay, though.)
2020-05-04Doc: improve PDF presentation of some tables by adjusting column widths.Tom Lane
The PDF toolchain defaults to laying out all columns of a table with equal widths, in contrast to the HTML rendering which automatically varies the column widths to fit the data. In many places, this results in very badly laid-out tables, with lots of useless whitespace in some places and text that overruns its cell in other places. For tables that have reasonably static content, we can improve matters by adding <colspec> entries to hand-assign the column widths. This commit does that for a few of the tables that were worst off; it eliminates close to 200 "contents ... exceed the available area" warnings in an A4 PDF build. I also forced align="left" in these tables, overriding the PDF toolchain's default which is evidently "justify". (The HTML toolchain seems to default to that already.) Anyplace where things are tight enough that we need to worry about this, forced justification tends to look truly awful.
2017-11-23Convert documentation to DocBook XMLPeter Eisentraut
Since some preparation work had already been done, the only source changes left were changing empty-element tags like <xref linkend="foo"> to <xref linkend="foo"/>, and changing the DOCTYPE. The source files are still named *.sgml, but they are actually XML files now. Renaming could be considered later. In the build system, the intermediate step to convert from SGML to XML is removed. Everything is build straight from the source files again. The OpenSP (or the old SP) package is no longer needed. The documentation toolchain instructions are updated and are much simpler now. Peter Eisentraut, Alexander Lakhin, Jürgen Purtz
2017-10-17Don't use SGML empty tagsPeter Eisentraut
For DocBook XML compatibility, don't use SGML empty tags (</>) anymore, replace by the full tag name. Add a warning option to catch future occurrences. Alexander Lakhin, Jürgen Purtz
2013-01-29Provide database object names as separate fields in error messages.Tom Lane
This patch addresses the problem that applications currently have to extract object names from possibly-localized textual error messages, if they want to know for example which index caused a UNIQUE_VIOLATION failure. It adds new error message fields to the wire protocol, which can carry the name of a table, table column, data type, or constraint associated with the error. (Since the protocol spec has always instructed clients to ignore unrecognized field types, this should not create any compatibility problem.) Support for providing these new fields has been added to just a limited set of error reports (mainly, those in the "integrity constraint violation" SQLSTATE class), but we will doubtless add them to more calls in future. Pavel Stehule, reviewed and extensively revised by Peter Geoghegan, with additional hacking by Tom Lane.
2011-05-27Drop "meaning" column from error code tablePeter Eisentraut
This is currently the same as the condition name, so it doesn't add any value, only clutter.
2011-05-18Remove obsolete commentPeter Eisentraut
2011-02-04Avoid maintaining three separate copies of the error codes list.Robert Haas
src/pl/plpgsql/src/plerrcodes.h, src/include/utils/errcodes.h, and a big chunk of errcodes.sgml are now automatically generated from a single file, src/backend/utils/errcodes.txt. Jan Urbański, reviewed by Tom Lane.
2011-02-01Re-classify ERRCODE_DATABASE_DROPPED to 57P04Simon Riggs
2011-02-01Create new errcode for recovery conflict caused by db drop on master.Simon Riggs
Previously reported as ERRCODE_ADMIN_SHUTDOWN, this case is now reported as ERRCODE_T_R_DATABASE_DROPPED. No message text change. Unlikely to happen on most servers, so low impact change to allow session poolers to correctly handle this situation. Tatsuo Ishii, edits by me, review by Robert Haas
2010-12-27Corrections to patch adding SQL/MED error codes.Robert Haas
My previous commit, 85cff3ce7f360d139d87aee836d75a6202fee066 on 2010-12-25, failed to update errcodes.sgml or plerrcodes.h. This patch corrects that oversight, per a gripe from Tom Lane, and also corrects a typographical error.
2010-09-20Remove cvs keywords from all files.Magnus Hagander
2010-03-13Add libpq warning message if the .pgpass-retrieved password fails.Bruce Momjian
Add ERRCODE_INVALID_PASSWORD sqlstate error code.
2009-12-07Add exclusion constraints, which generalize the concept of uniqueness toTom Lane
support any indexable commutative operator, not just equality. Two rows violate the exclusion constraint if "row1.col OP row2.col" is TRUE for each of the columns in the constraint. Jeff Davis, reviewed by Robert Haas
2009-03-04Add new SQL:2008 error codes for invalid LIMIT and OFFSET values. RemovePeter Eisentraut
unused nonstandard error code that was perhaps intended for this but never used.
2008-12-28Support window functions a la SQL:2008.Tom Lane
Hitoshi Harada, with some kibitzing from Heikki and Tom.
2008-10-04Implement SQL-standard WITH clauses, including WITH RECURSIVE.Tom Lane
There are some unimplemented aspects: recursive queries must use UNION ALL (should allow UNION too), and we don't have SEARCH or CYCLE clauses. These might or might not get done for 8.4, but even without them it's a pretty useful feature. There are also a couple of small loose ends and definitional quibbles, which I'll send a memo about to pgsql-hackers shortly. But let's land the patch now so we can get on with other development. Yoshiyuki Asaba, with lots of help from Tatsuo Ishii and Tom Lane
2008-05-15Support SQL/PSM-compatible CASE statement in plpgsql.Tom Lane
Pavel Stehule
2008-01-15Somebody forgot to add this ERRCODE everywhere it should go ...Tom Lane
2007-01-31Update documentation on may/can/might:Bruce Momjian
Standard English uses "may", "can", and "might" in different ways: may - permission, "You may borrow my rake." can - ability, "I can lift that log." might - possibility, "It might rain today." Unfortunately, in conversational English, their use is often mixed, as in, "You may use this variable to do X", when in fact, "can" is a better choice. Similarly, "It may crash" is better stated, "It might crash". Also update two error messages mentioned in the documenation to match.
2006-12-24Code review for XML patch. Instill a bit of sanity in the location ofTom Lane
the XmlExpr code in various lists, use a representation that has some hope of reverse-listing correctly (though it's still a de-escaping function shy of correctness), generally try to make it look more like Postgres coding conventions.
2006-06-16Code review for SELECT INTO STRICT patch: use saner choices of errorTom Lane
SQLSTATEs, fix some documentation problems.
2006-06-16Clean up after someone's curious idea that it'd be good to stripTom Lane
leading zeroes from the SQLSTATE codes. They're strings, people, not numbers.
2005-12-09Fix broken markup.Tom Lane
2005-12-08Remove empty heading row in error table.Bruce Momjian
2005-12-08Add "Constant" column to error code table.Bruce Momjian
Also, better mark section headings. [email protected]
2005-11-04Avoid referring to a specific version of the SQL standard except whereTom Lane
necessary, and be careful to refer to the right version where it is useful to do so. This partially reverts an ill-considered search and replace from a few months ago.
2005-07-14This doc patch replaces all inappropriate references to SQL:1999 when itNeil Conway
is used as if it were the latest (and/or still valid) SQL standard. SQL:2003 is used in its place. Patch from Simon Riggs.
2005-06-26Code review for escape-strings patch. Sync psql and plpgsql lexersTom Lane
with main, avoid using a SQL-defined SQLSTATE for what is most definitely not a SQL-compatible error condition, fix documentation omissions, adhere to message style guidelines, don't use two GUC_REPORT variables when one is sufficient. Nothing done about pg_dump issues.
2005-01-06More minor updates and copy-editing.Tom Lane
2004-11-27Update of conformance information to SQL:2003Peter Eisentraut
by Troels Arvin, Simon Riggs, Elein Mustain Make spelling of SQL standard names uniform.
2004-11-15Replace "--" and "---" with "&mdash;" as appropriate, for better-lookingNeil Conway
output.
2004-10-01Code review for NOWAIT patch: downgrade NOWAIT from fully reserved keywordTom Lane
to unreserved keyword, use ereport not elog, assign a separate error code for 'could not obtain lock' so that applications will be able to detect that case cleanly.
2004-08-24Various minor improvements to the SGML documentation: fix some incorrectNeil Conway
SGML markup, add a "deprecated features" section to the 8.0 release notes, untabify release.sgml and runtime.sgml, and make some other minor improvements.
2004-07-31Support "OR condition ..." in plpgsql EXCEPTION clauses to make the syntaxTom Lane
more nearly Oracle-equivalent. Allow matching by category as well as specific error code. Document the set of available condition names (or more accurately, synchronize it with the existing documentation). In passing, update errcodes.sgml to include codes added during 7.5 development.
2004-05-16Change ln(), log(), power(), and sqrt() to emit the correct SQLSTATENeil Conway
error codes for certain error conditions, as specified by SQL2003.
2004-05-14Implement the width_bucket() function, per SQL2003. This commit only addsNeil Conway
a variant of the function for the 'numeric' datatype; it would be possible to add additional variants for other datatypes, but I haven't done so yet. This commit includes regression tests and minimal documentation; if we want developers to actually use this function in applications, we'll probably need to document what it does more fully.
2004-05-14Improve documentation for SQLSTATE error codes, per recent thread onNeil Conway
-patches.
2004-03-04Emit a warning when an empty string is input to the oid, float4, andNeil Conway
float8 types. This begins the deprecation of this feature: in 7.6, this input will be rejected. Also added a new error code for warnings about deprecated features, and updated the regression tests.
2003-11-29$Header: -> $PostgreSQL Changes ...PostgreSQL Daemon
2003-10-17Add a listing of our SQLSTATE error codes to the documentation.Tom Lane
Link to it from some appropriate places.