| Commit message (Collapse) | Author | Age |
|---|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
now has an RTE of its own, and references to its outputs now are Vars
referencing the JOIN RTE, rather than CASE-expressions. This allows
reverse-listing in ruleutils.c to use the correct alias easily, rather
than painfully reverse-engineering the alias namespace as it used to do.
Also, nested FULL JOINs work correctly, because the result of the inner
joins are simple Vars that the planner can cope with. This fixes a bug
reported a couple times now, notably by Tatsuo on 18-Nov-01. The alias
Vars are expanded into COALESCE expressions where needed at the very end
of planning, rather than during parsing.
Also, beginnings of support for showing plan qualifier expressions in
EXPLAIN. There are probably still cases that need work.
initdb forced due to change of stored-rule representation.
|
| | |
|
| | |
|
| |
|
|
|
|
| |
Patch fixes using lc.lang instead of lc.lc_ctype.
Teodor Sigaev
|
| | |
|
| |
|
|
|
|
| |
libpq++.
Ofir Reichenberg
|
| | |
|
| |
|
|
|
|
|
|
|
|
|
| |
1) Put back the error message for SQLError().
2) Change Disallow premature to handle the SELECTed
result.
3) Put back the behavior of AUTUCOMMIT mode change.
4) Fix SQLColumns for ODBC3.0.
5) Improve the handling of variable bookmark in ODBC3.0.
6) Enable Recognize Unique Index Button.
|
| | |
|
| | |
|
| |
|
|
|
|
|
|
|
| |
> This simple patch fixes broken Makefile, broken ApplySnapshot and
> makes all utilities honour --verbose command line option.
>
> --
> Yours, Alexey V. Borzov, Webmaster of RDW.ru
>
|
| | |
|
| |
|
|
|
|
|
| |
< * Remove brackets as multi-statement rule grouping, must use parens (Bruce)
> * -Remove brackets as multi-statement rule grouping, must use parens (Bruce)
458d457
< * Remove USING clause from pg_get_indexdef() if index is btree (Bruce)
|
| | |
|
| | |
|
| |
|
|
| |
Problem noted by Fernando Nasser.
|
| |
|
|
|
|
| |
moved the check for columnIndex into same call
check at the top of all getXXX
added appropriate error
|
| |
|
|
|
| |
(char != unsigned char, Datum != uint32); make use of new hash code in
dynahash hash tables and hash joins.
|
| |
|
|
| |
driver. PSQLExceptions are thrown instead of SQLExceptions and if a warning is received while waiting for the backend secret key, that warning is chained to the new Connection object instead of generating an exception. A couple new error messages have been added.
|
| |
|
|
|
| |
file that SIGHUP or "pg_ctl reload" are required for changes to take
affect on a running server.
|
| | |
|
| | |
|
| |
|
|
|
|
|
|
|
|
|
|
|
| |
2) Handle Multiple results and implement SQLMoreResult().
3) Improve multibyte handling thanks to Eiji Tokuya.
4) Add new options.
LF <-> CR/LF converion.
TRUE is -1 (for VB).
5) Introduce unicode(UCS-2) support.
6) Reduce the length of connection strings.
7) Improve SQLError, SQLGetDiagRec(ODBC 3.0).
8) Implement SQLTablePrivileges().
9) Miscellaneous changes for ODBC 3.0 support.
|
| | |
|
| | |
|
| |
|
|
|
| |
per reports from Fernando Nasser. Also, rearrange order of declarations
in parsenodes.h as suggested by Fernando.
|
| | |
|
| | |
|
| |
|
|
| |
* Change FIXED_CHAR_SEL to 0.20 from 0.04 to give better selectivity (Bruce)
|
| |
|
|
| |
> * -Change DEBUG startup tag to LOG (Bruce)
|
| |
|
|
| |
> * Prevent aggregates from being used in rule WHERE clauses
|
| | |
|
| | |
|
| | |
|
| | |
|
| | |
|
| |
|
|
|
|
| |
use tables and views interchangeably.
Manuel Sugawara
|
| | |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
PostgreSQL. This hash function replaces the one used by hash indexes and
the catalog cache. Hash joins use a different, relatively poor-quality
hash function, but I'll fix that later.
As suggested by Tom Lane, this patch also changes the size of the fixed
hash table used by the catalog cache to be a power-of-2 (instead of a
prime: I chose 256 instead of 257). This allows the catcache to lookup
hash buckets using a simple bitmask. This should improve the performance
of the catalog cache slightly, since the previous method (modulo a
prime) was slow.
In my tests, this improves the performance of hash indexes by between 4%
and 8%; the performance when using btree indexes or seqscans is
basically unchanged.
Neil Conway <neilconway@rogers.com>
|
| |
|
|
|
|
|
|
|
|
|
| |
so index is not on table during COPY.
> > AFAICT, the patch I posted to -patches a little while to enable the
> > usage of ALTER TABLE ADD PRIMARY KEY by pg_dump hasn't been applied, nor
> > is it in the unapplied patches list. I was under the impression that
> > this was in the queue for application -- did it just get lost?
Neil Conway <neilconway@rogers.com>
|
| |
|
|
| |
Neil Conway
|
| |
|
|
|
|
|
| |
makes all utilities honour --verbose command line option.
--
Yours, Alexey V. Borzov, Webmaster of RDW.ru
|
| |
|
|
|
|
|
| |
'list domains' command '\dD'. This is the interface component of
rbt@zort.ca's domain backend modifications.
Jonathan Eisler
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
- domain.patch -> source patch against pgsql in cvs
- drop_domain.sgml and create_domain.sgml -> New doc/src/sgml/ref docs
- dominfo.txt -> basic domain related queries I used for testing
[ ADDED TO /doc]
Enables domains of array elements -> CREATE DOMAIN dom int4[3][2];
Uses a typbasetype column to describe the origin of the domain.
Copies data to attnotnull rather than processing in execMain().
Some documentation differences from earlier.
If this is approved, I'll start working on pg_dump, and a \dD <domain>
option in psql, and regression tests. I don't really feel like doing
those until the system table structure settles for pg_type.
CHECKS when added, will also be copied to to the table attributes. FK
Constraints (if I ever figure out how) will be done similarly. Both
will lbe handled by MergeDomainAttributes() which is called shortly
before MergeAttributes().
Rod Taylor
|
| |
|
|
| |
Neil Conway
|
| | |
|
| |
|
|
| |
still needed because only removed in 7.4.
|
| | |
|
| | |
|
| | |
|
