| Commit message (Collapse) | Author | Age |
| |
|
|
|
|
| |
platforms.
|
| |
|
| |
|
|
|
|
| |
Greg Sabino Mullan
|
|
|
|
|
| |
Rename debug_print_query to log_statement and rename show_query_stats to
show_statement_stats.
|
| |
|
|
|
|
| |
redundant pg_cast searches, fix obsolete comments.
|
| |
|
|
|
|
|
|
|
|
|
|
| |
pointed out by Barry Lind: UPDATE bigintcol = 10000000000 fails because
the constant is initially taken as float8. We really need a better way,
but it's not gonna happen for 7.3.
Also, remove int4reltime() function, which is redundant with the
existing binary-compatibility coercion path from int4 to reltime,
and probably has been unreachable code for a long while.
|
|
|
|
|
|
|
|
|
| |
type for runtime constraint checks, instead of misusing the parse-time
Constraint node for the purpose. Fix some damage introduced into type
coercion logic; in particular ensure that a coerced expression tree will
read out the correct result type when inspected (patch had broken some
RelabelType cases). Enforce domain NOT NULL constraints against columns
that are omitted from an INSERT.
|
| |
|
|
|
|
|
|
| |
you try to use the tupdesc to build a tuple.
Joe Conway
|
|
|
|
|
|
|
|
| |
available (else there's no way to interpret the list links). Change
pg_locks view to show transaction ID locks separately from ordinary
relation locks. Avoid showing N duplicate rows when the same lock is
held multiple times (seems unlikely that users care about exact hold
count). Improve documentation.
|
|
|
|
|
|
| |
functions, per suggestion from John Gray and Joe Conway. Also, fix
plpgsql RETURN NEXT to verify that returned values match the expected
tupdesc.
|
|
|
|
|
|
|
|
|
| |
to false provides more SQL-spec-compliant behavior than we had before.
I am not sure that setting it false is actually a good idea yet; there
is a lot of client-side code that will probably be broken by turning
autocommit off. But it's a start.
Loosely based on a patch by David Van Wie.
|
| |
|
|
|
|
|
|
| |
column additions, deletions, and renames that would let a child table
get out of sync with its parent. Patch by Alvaro Herrera, with some
kibitzing by Tom Lane.
|
| |
|
| |
|
|
|
|
|
| |
* Remove wal_files postgresql.conf option because WAL files are
now recycled
|
| |
|
|
|
|
| |
Improve wording of pre-7.3 syntax mention.
|
| |
|
| |
|
| |
|
|
|
|
|
| |
at least not on HPUX 10.20, and there's no reason to think it
is needed on later versions.
|
|
|
|
| |
which is now required.
|
|
|
|
|
| |
that the functionality is available to anyone via ReturnSetInfo, rather
than hard-wiring it to PL/pgSQL.
|
| |
|
|
|
|
|
|
|
|
|
| |
> > > > where is the code to verify that PGPASSWORDFILE points at a
> > > > non-world-readable file? That needs to be there now, not later, or
> > > > we'll have people moaning about backward compatibility when we finally
> > > > do plug that hole.
Alvaro Herrera
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
> Upon invoking a polygon(integer, circle) function a
> src/backend/utils/adt/geo_ops.c:circle_poly() function will gets
> called, which suffers from a buffer overflow.
>
> 2) A src/backend/adt/utils/geo_ops.c:path_encode() fails to detect a
> buffer overrun condition. It is called in multiple places, the most
> interesting are path_out() and poly_out() functions.
> 5) A src/backend/utils/adt/geo_ops.c:path_add() also fails to detect
> a simple buffer overrun.
I've attached a patch which should fix these problems.
Neil Conway
|
|
|
|
| |
translation.
|
| |
|
| |
|
|
|
|
|
|
| |
memory.
Neil Conway
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
connections by the superuser only.
This patch replaces the last patch I sent a couple of days ago.
It closes a connection that has not been authorised by a superuser if it would
leave less than the GUC variable ReservedBackends
(superuser_reserved_connections in postgres.conf) backend process slots free
in the SISeg. This differs to the first patch which only reserved the last
ReservedBackends slots in the procState array. This has made the free slot
test more expensive due to the use of a lock.
After thinking about a comment on the first patch I've also made it a fatal
error if the number of reserved slots is not less than the maximum number of
connections.
Nigel J. Andrews
|
| |
|
| |
|
|
|
|
|
|
|
| |
to the table function, thus preventing memory leakage accumulation across
calls. This means that SRFs need to be careful to distinguish permanent
and local storage; adjust code and documentation accordingly. Patch by
Joe Conway, very minor tweaks by Tom Lane.
|
|
|
|
| |
Per pghackers discussion from back around 1-August.
|
|
|
|
|
| |
tables that need special defenses. I believe this is okay even for
TOAST tables that belong to system tables.
|
| |
|
| |
|
|
|
|
| |
pghackers discussion around 31-Jul-02.
|
| |
|
|
|
|
|
|
| |
ERROR: Cannot display a value of type RECORD
rather than a random integer when someone tries to SELECT a tuple
value. Per pghackers discussion around 26-May-02.
|
|
|
|
|
| |
INSERT, UPDATE, or DELETE shouldn't change FOUND. IMHO anyway.
Also, try to make documentation a little clearer.
|
|
|
|
| |
This breaks support for 6.2 or older client libraries.
|
|
|
|
| |
defined in the FROM clause. From Joe Conway, with some tweaks.
|