| Commit message (Collapse) | Author | Age |
... | |
| |
|
|
|
|
| |
Marko Kreen
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
can create or modify rules for the table. Do setRuleCheckAsUser() while
loading rules into the relcache, rather than when defining a rule. This
ensures that permission checks for tables referenced in a rule are done with
respect to the current owner of the rule's table, whereas formerly ALTER TABLE
OWNER would fail to update the permission checking for associated rules.
Removal of separate RULE privilege is needed to prevent various scenarios
in which a grantee of RULE privilege could effectively have any privilege
of the table owner. For backwards compatibility, GRANT/REVOKE RULE is still
accepted, but it doesn't do anything. Per discussion here:
http://archives.postgresql.org/pgsql-hackers/2006-04/msg01138.php
|
|
|
|
| |
fix suggestion from Peter.
|
| |
|
|
|
|
|
| |
'GIN FailedAssertions on Itanium2 with Intel compiler' in pgsql-hackers,
http://archives.postgresql.org/pgsql-hackers/2006-08/msg01914.php
|
|
|
|
|
| |
Per discussion
http://archives.postgresql.org/pgsql-hackers/2006-08/msg01409.php
|
|
|
|
|
| |
dbase, dbmirror, fulltextindex, mac, userlock; or abandoned: mSQL-interface,
tips.
|
| |
|
|
|
|
| |
Added some interval checks to regression suite.
|
|
|
|
|
| |
Fixed ecpglib trying to read one character after end-of-string.
Fixed port number setting in regression suite.
|
|
|
|
| |
Christopher Kings-Lynne
|
|
|
|
| |
Bruce, Michael Glaesemann
|
|
|
|
| |
Jun Kuwamura
|
|
|
|
|
| |
position_in_unique_constraint (column newly added per SQL2003).
Greg Mullane
|
| |
|
| |
|
|
|
|
| |
Albe Laurenz
|
|
|
|
|
|
| |
second scan of table).
Gregory Stark
|
|
|
|
| |
Magnus Hagander
|
|
|
|
|
|
|
| |
the target relation(s). There might be some cases where we could discard
the pending event instead, but for the moment a conservative approach
seems sufficient. Per report from Markus Schiltknecht and subsequent
discussion.
|
|
|
|
|
|
|
| |
of 'S', and the views were not checking for table visibility with
regards to temporary tables and sequences.
Greg Sabino Mullane
|
|
|
|
| |
Christopher Kings-Lynne
|
|
|
|
| |
Simon Riggs
|
|
|
|
| |
some platforms.
|
|
|
|
|
|
|
| |
working in a multibyte encoding. This fixes the problems exhibited in
bug #1931 and other reports of ILIKE misbehavior in UTF8 encoding.
It's a pretty grotty solution though --- should rethink how to do it
after we install better locale support, someday.
|
|
|
|
| |
Author: Victor Wagner <vitus@cryptocom.ru>
|
| |
|
| |
|
|
|
|
|
| |
unportable elog(NOTICE) report, fix install/uninstall sequence.
Itagaki Takahiro
|
|
|
|
|
|
|
| |
cascaded first to days and only what is leftover into seconds. This
seems to satisfy the principle of least surprise given the general
conversion to three-part interval values --- it was an oversight that
these cases weren't dealt with in 8.1. Michael Glaesemann
|
|
|
|
|
|
| |
of the syntax as this fundamentally dead-end approach can, in particular
combinations of single and multi column assignments. Improve rather
inadequate documentation and provide some regression tests.
|
| |
|
| |
|
| |
|
|
|
|
|
| |
is only invoked on completed WAL segments, period --- there's no 'by
default' about it.
|
|
|
|
|
|
|
|
|
|
| |
PGPROC array into snapshots, and use this information to avoid visits
to pg_subtrans in HeapTupleSatisfiesSnapshot. This appears to solve
the pg_subtrans-related context swap storm problem that's been reported
by several people for 8.1. While at it, modify GetSnapshotData to not
take an exclusive lock on ProcArrayLock, as closer analysis shows that
shared lock is always sufficient.
Itagaki Takahiro and Tom Lane
|
|
|
|
| |
< * Change LIMIT/OFFSET and FETCH/MOVE to use int8
|
|
|
|
| |
Added another regression test and fixed tcp test.
|
|
|
|
|
|
|
| |
multiplication/division queries like select '41 mon 10:00:00'::interval
/ 10 as "pos".
Report from Michael Glaesemann
|
|
|
|
|
| |
< * -Change LIMIT/OFFSET and FETCH/MOVE to use int8
> * Change LIMIT/OFFSET and FETCH/MOVE to use int8
|
|
|
|
| |
fetch/move in scan.l.
|
| |
|
|
|
|
| |
Report from Josh Tolley.
|
| |
|
| |
|
|
|
|
|
|
|
|
|
|
|
| |
> * Simplify ability to create partitioned tables
>
> This would allow creation of partitioned tables without requiring
> creation of rules for INSERT/UPDATE/DELETE, and constraints for
> rapid partition selection. Options could include range and hash
> partition selection.
>
> * Allow auto-selection of partitioned tables for min/max() operations
|
|
|
|
|
|
|
| |
--- was part of autovacuum default 'on' patch that was reverted, but we
want this part.
Peter Eisentraut
|
| |
|
|
|
|
| |
possible autovacuum use.
|