| Commit message (Collapse) | Author | Age |
| |
|
| |
|
| |
|
| |
|
| |
|
|
|
|
| |
failure messages.
|
|
|
|
| |
and trigger function found but returns wrong type.
|
|
|
|
|
|
|
|
| |
SelectStmt and CursorStmt tried to parse FOR UPDATE ... / FOR READ ONLY.
Cursor now checks that it is read only by looking at forUpdate of Query.
SelectStmt handles FOR READ ONLY too.
Jan
|
| |
|
| |
|
|
|
|
|
|
| |
will pass through rather than spitting up. This is necessary to handle
cases where coerce_type causes a subexpression to be retransformed, as in
SELECT count(*) + 1.0 FROM table
|
|
|
|
|
|
| |
remove optimizer's arbitrary limit on how large a join it will use hashing
for. (The limit was too large to prevent the problems we'd been seeing,
anyway...)
|
| |
|
|
|
|
|
|
|
| |
fixed-size hashtable. This should prevent 'hashtable out of memory' errors,
unless you really do run out of memory. Note: target size for hashtable
is now taken from -S postmaster switch, not -B, since it is local memory
in the backend rather than shared memory.
|
|
|
|
|
| |
ALTER TABLE RENAME with extents.
Ole Gjerde
|
| |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
looks
like someone just didn't add support for multiple segments for
truncation.
The following patch seems to do the right thing, for me at least.
It passed my tests, my data looks right(no data that shouldn't be in
there) and regression is ok.
Ole Gjerde
|
|
|
|
| |
for SERIAL column's constraint, but forgot to increase space palloc'd...
|
| |
|
|
|
|
| |
ports collection ...
|
| |
|
| |
|
| |
|
|
|
|
| |
for GEQO ...
|
|
|
|
|
| |
is evaluated. This bounds memory usage to something reasonable even
when many tables are being joined.
|
| |
|
| |
|
| |
|
|
|
|
|
| |
reasonable plans again. Still eats memory like there's no tomorrow,
however :-(.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
segments, and my indexes had 3(Yes, it DOES work!).
DROP TABLE removed ALL segments from the table, but only the main index
segment.
So it looks like removing the table itself is using mdunlink in md.c,
while removing indexes uses FileNameUnlink() which only unlinks 1 file.
As far as I can tell, calling FileNameUnlink() and mdunlink() is basically
the same, except mdunlink() deletes any extra segments.
I've done some testing and it seems to work. It also passes regression
tests(except float8, geometry and rules, but that's normal).
If this patch is right, this fixes all known multi-segment problems on
Linux.
Ole Gjerde
|
|
|
|
|
|
|
| |
These are my last changes to lmgr fixing deadlock handling.
Please apply them to cvs...
Vadim
|
|
|
|
|
|
| |
SERIAL data type DEFAULT clause.
This fixes a problem finding the sequence name when mixed case table names
are involved.
|
|
|
|
| |
compiler warnings about an unused variable.
|
| |
|
|
|
|
|
|
|
|
|
|
| |
lists are now plain old garden-variety Lists, allocated with palloc,
rather than specialized expansible-array data allocated with malloc.
This substantially simplifies their handling and eliminates several
sources of memory leakage.
Several basic types of erroneous queries (syntax error, attempt to
insert a duplicate key into a unique index) now demonstrably leak
zero bytes per query.
|
| |
|
|
|
|
|
|
| |
pg_rules to rules regression test.
Jan
|
|
|
|
|
|
|
|
| |
selected.
Disabled ability of defining DISTINCT or ORDER BY on views.
Jan
|
|
|
|
|
|
|
| |
in Resdom and GroupClause so changing of resno's doesn't confuse
the grouping any more.
Jan
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
The
offending code
has been removed, the action is now always dependent :-)
I suggest the following patch, to finally make trigger regression happy
again:
<<refint1.patch>>
After that you can remove the following from TODO:
Remove ERROR: check_primary_key: even number of arguments should be
specified
Trigger regression test fails
Andreas
|
|
|
|
|
|
|
|
|
|
| |
and lock syntax as fully parsed tokens.
Two keywords for isolation are non-reserved SQL92
(COMMITTED, SERIALIZABLE).
All other new keywords are non-reserved Postgres (not SQL92)
(ACCESS, EXCLUSIVE, MODE, SHARE).
Add syntax to allow CREATE [GLOBAL|LOCAL] TEMPORARY TABLE, throwing an
error if GLOBAL is specified.
|
|
|
|
|
|
|
| |
constraints. Reported by Tom Lane.
Now, check for duplicate indices and retain the one which is a primary-key.
Adjust elog NOTICE messages to surround table and column names with single
quotes.
|
| |
|
|
|
|
|
|
| |
the obvious conversion.
Define a new pattern "decimal" which is non-exponential floating point
for use with numeric() and decimal() types.
|
|
|
|
|
|
|
|
|
| |
-d4 now prints compressed trees from nodeToString()
-d5 prints pretty trees via nodeDisplay()
new pg_options: pretty_plan, pretty_parse, pretty_rewritten
Jan
|
| |
|
|
|
|
| |
Jan
|
| |
|
| |
|