| Commit message (Collapse) | Author | Age |
... | |
|
|
|
|
|
|
| |
function to prevent multiple threads using automatic cursors on
the same connection from stomping over each others cursor.
Jan
|
| |
|
| |
|
| |
|
| |
|
|
|
|
|
| |
Fix pg_restore tar log output bug where Special flag wasn't being
initialized; bug seen on XP.
|
|
|
|
|
|
| |
Change log line to be "duration: ms query:"
Indent multi-line queries with a tab in the server logs.
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
|
|
|
|
| |
one side of a binary operator is probably supposed to be the same type
as the other operand' will be applied for domain types. This worked
in 7.3 but was broken in 7.4 due to code rearrangements. Mea culpa.
|
| |
|
|
|
|
|
|
| |
a single LEFT JOIN query instead of firing the check trigger for each
row individually. Stephan Szabo, with some kibitzing from Tom Lane and
Jan Wieck.
|
| |
|
|
|
|
|
| |
- Fixed typo in ecpg for Informix dec_t type.
- Fixed precision handling in Informix compat funxtions.
|
| |
|
|
|
|
|
|
|
|
|
|
|
| |
before it is de-backslashed, not after. This allows the null string \N
to be reliably distinguished from the data value \N (which must be
represented as \\N). Per bug report from Manfred Koizar ... but it's
amazing this hasn't been reported before ...
Also, be consistent about encoding conversion for null string: the form
specified in the command is in the server encoding, but what is sent
to/from client must be in client encoding. This never worked quite
right before either.
|
|
|
|
|
| |
data transfer during COPY is included in the \timing display. Also
avoid portability problems if tv_usec is unsigned on some platform.
|
|
|
|
|
| |
statistics, but there is a unique index on the column, we can safely
assume it's well-distributed.
|
| |
|
| |
|
|
|
|
| |
to avoid recursively revoking everything from everyone.
|
| |
|
| |
|
|
|
|
|
|
|
| |
will downcase the supplied field name unless it is double-quoted. Also,
upgrade the routine's handling of double quotes to match the backend,
in particular support doubled double quotes within quoted identifiers.
Per pgsql-interfaces discussion a couple weeks ago.
|
|
|
|
|
|
|
| |
with required outer parentheses. Breakage seems to be leftover from
domain-constraint patches. This could be smarter about suppressing
extra parens, but at this stage of the release cycle I want certainty
not cuteness.
|
| |
|
| |
|
|
|
|
| |
pointed out by Peter.
|
| |
|
| |
|
| |
|
| |
|
|
|
|
|
| |
failures in SQL functions, due to forward references or unqualified
references to objects in other schemas. Per recent discussion.
|
|
|
|
|
|
|
| |
of function bodies is done at CREATE FUNCTION time. This is normally
true but can be set false to avoid problems with forward references,
wrong schema search path, etc. This is just the backend patch, still
need to adjust pg_dump to make use of it.
|
|
|
|
|
|
| |
than generating an invalid output string. Per observation and patch
from Igor Shevchenko. Further code cleanup and documentation by
Tom Lane.
|
|
|
|
|
| |
Also remove -g, which has no business in CPPFLAGS in the first place,
let alone being hardwired there by a sub-Makefile.
|
| |
|
|
|
|
|
|
|
| |
to make them comparable to what UpdateStats does in the same situation.
I'm not certain two instances of vac_update_relstats could run in
parallel for the same relation, but parallel invocations of vac_update_dbstats
do seem possible.
|
|
|
|
|
|
| |
in the schema search path. Otherwise pg_dump doesn't correctly dump
scenarios where a custom opclass is created in 'public' and then used
by indexes in other schemas.
|
|
|
|
|
|
| |
processing the request; this ensures that the request won't be taken
to cancel a subsequently-issued query. Race condition originally
noted by Oliver Jowett in the context of JDBC, but libpq has it too.
|
| |
|
|
|
|
| |
from Patrick Welche
|
| |
|
|
|
|
| |
developed on -hackers.
|
|
|
|
| |
longer conveys useful information.
|
|
|
|
| |
and try to coerce the values to boolean if not. Per recent discussions.
|
|
|
|
|
|
|
| |
discussion on pgsql-hackers: in READ COMMITTED mode we just have to force
a QuerySnapshot update in the trigger, but in SERIALIZABLE mode we have
to run the scan under a current snapshot and then complain if any rows
would be updated/deleted that are not visible in the transaction snapshot.
|