| Commit message (Collapse) | Author | Age |
| |
|
|
|
|
|
|
| |
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.
|
|
|
|
|
| |
semi-related SGML cleanup. Original patch from ljb220@mindspring.com,
additional cleanup by Neil Conway.
|
|
|
|
|
| |
to perform upgrades, and cleanup some nearby text. Patch from Robert
Treat, editorializing by Neil Conway.
|
|
|
|
| |
From Alvaro Herrera, editorializing by Neil Conway.
|
|
|
|
| |
Euler Taveira de Oliveira
|
| |
|
|
|
|
| |
Mahmoud Taghizadeh
|
| |
|
| |
|
| |
|
|
|
|
| |
tweak by Neil Conway.
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
|
|
|
|
|
|
|
| |
I haven't mentioned any of
~/.postgresql/{root.crt,postgresql.crt,postresql.key} even though they
are checked for in the code, since they do not appear to be supported. I
base this on discussions in pgsql-hackers.
Dominic Mitchell
|
|
|
|
|
|
|
|
| |
Given that PostgreSQL will output a message complaining about it's
absence if you're using SSL mode, I feel it's important that it gets a
mention in the documentation at some point.
Dominic Mitchell
|
|
|
|
| |
added to the SQL:2003 standard.
|
|
|
|
|
| |
required. Original patch from James William Pye, editorializing by
Neil Conway.
|
|
|
|
|
|
| |
log_line_prefix escapes. The escape sequence used for this is %x.
%x previously meant "postmaster et al. stop here" -- this has been
renamed to %q.
|
|
|
|
|
| |
grammar, don't drop discussions into the middle of unrelated discussions,
etc.
|
|
|
|
|
|
|
| |
of commands for which a transaction block should not be forced. Recognize
VACUUM and other PreventTransactionChain commands; handle nested /* .. */
comments correctly; handle multibyte encodings correctly.
Michael Paesold with some kibitzing from Tom Lane.
|
|
|
|
|
| |
If we're going to put brackets around optional precision specs in some
entries, we'd better do it in all.
|
| |
|
|
|
|
| |
Spotted by Josh Purinton.
|
| |
|
| |
|
| |
|
|
|
|
| |
qualified.
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
mode see a fresh snapshot for each command in the function, rather than
using the latest interactive command's snapshot. Also, suppress fresh
snapshots as well as CommandCounterIncrement inside STABLE and IMMUTABLE
functions, instead using the snapshot taken for the most closely nested
regular query. (This behavior is only sane for read-only functions, so
the patch also enforces that such functions contain only SELECT commands.)
As per my proposal of 6-Sep-2004; I note that I floated essentially the
same proposal on 19-Jun-2002, but that discussion tailed off without any
action. Since 8.0 seems like the right place to be taking possibly
nontrivial backwards compatibility hits, let's get it done now.
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
rather than when returning to the idle loop. This makes no particular
difference for interactively-issued queries, but it makes a big difference
for queries issued within functions: trigger execution now occurs before
the calling function is allowed to proceed. This responds to numerous
complaints about nonintuitive behavior of foreign key checking, such as
http://archives.postgresql.org/pgsql-bugs/2004-09/msg00020.php, and
appears to be required by the SQL99 spec.
Also take the opportunity to simplify the data structures used for the
pending-trigger list, rename them for more clarity, and squeeze out a
bit of space.
|
|
|
|
| |
missing the ability to schema-qualify constraint names.
|
| |
|
|
|
|
| |
of an object owner and the SQL spec's treatment of these rights.
|
|
|
|
|
|
| |
<P>In pre-8.0 releases, indexes often can not be used unless the data
types exactly match the index's column types. This is particularly
true of int2, int8, and numeric column indexes.</P>
|
|
|
|
|
|
|
| |
to allow DBA to choose the form in which log filenames reflect the
current time. Also allow for truncating instead of appending to
pre-existing files --- this is convenient when the log filename pattern
rewrites the same names cyclically. Per Ed L.
|
| |
|
|
|
|
| |
for the tutorial files right here.
|
| |
|
|
|
|
| |
be written with quotes. Minor copy-editing too.
|
|
|
|
|
|
|
|
| |
Fix TablespaceCreateDbspace() to be able to create a dummy directory
in place of a dropped tablespace's symlink. This eliminates the open
problem of a PANIC during WAL replay when a replayed action attempts
to touch a file in a since-deleted tablespace. It also makes for a
significant improvement in the usability of PITR replay.
|
| |
|
| |
|
|
|
|
| |
CIDR column in examples first.
|
| |
|
| |
|
|
|
|
| |
Jun Kuwamura
|
| |
|