- 30 6月, 2005 2 次提交
-
-
由 Tom Lane 提交于
current time: provide a GetCurrentTimestamp() function that returns current time in the form of a TimestampTz, instead of separate time_t and microseconds fields. This is what all the callers really want anyway, and it eliminates low-level dependencies on AbsoluteTime, which is a deprecated datatype that will have to disappear eventually.
-
由 Tom Lane 提交于
role memberships; make superuser/createrole distinction do something useful; fix some locking and CommandCounterIncrement issues; prevent creation of loops in the membership graph.
-
- 29 6月, 2005 7 次提交
-
-
由 Teodor Sigaev 提交于
-
由 Bruce Momjian 提交于
Karl O. Pinc
-
由 Bruce Momjian 提交于
Victor Y. Yegorov
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
Remove extra backslash in pattern. Luke Lonergan
-
由 Tom Lane 提交于
In particular, make hba.c cope with zero-length tokens, which it never did properly before. Also, enforce rolcanlogin.
-
由 Tom Lane 提交于
syntactic conflicts, both privilege and role GRANT/REVOKE commands have to use the same production for scanning the list of tokens that might eventually turn out to be privileges or role names. So, change the existing GRANT/REVOKE code to expect a list of strings not pre-reduced AclMode values. Fix a couple other minor issues while at it, such as InitializeAcl function name conflicting with a Windows system function.
-
- 28 6月, 2005 4 次提交
-
-
由 Teodor Sigaev 提交于
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
and pg_auth_members. There are still many loose ends to finish in this patch (no documentation, no regression tests, no pg_dump support for instance). But I'm going to commit it now anyway so that Alvaro can make some progress on shared dependencies. The catalog changes should be pretty much done.
-
由 Bruce Momjian 提交于
> * -Add concurrency to GIST
-
- 27 6月, 2005 11 次提交
-
-
由 Teodor Sigaev 提交于
- full concurrency for insert/update/select/vacuum: - select and vacuum never locks more than one page simultaneously - select (gettuple) hasn't any lock across it's calls - insert never locks more than two page simultaneously: - during search of leaf to insert it locks only one page simultaneously - while walk upward to the root it locked only parent (may be non-direct parent) and child. One of them X-lock, another may be S- or X-lock - 'vacuum full' locks index - improve gistgetmulti - simplify XLOG records Fix bug in index_beginscan_internal: LockRelation may clean rd_aminfo structure, so move GET_REL_PROCEDURE after LockRelation
-
由 Tom Lane 提交于
name matches the name of any parent-table constraint, without looking at the constraint text. This is a not-very-bulletproof workaround for the problem exhibited by Berend Tober last month. We really ought to record constraint inheritance status in pg_constraint, but it's looking like that may not get done for 8.1 --- and even if it does, we will need this kluge for dumping from older servers.
-
由 Bruce Momjian 提交于
> * -Remove kerberos4 from source tree
-
由 Neil Conway 提交于
some security issues, and upstream has declared it "dead". Patch from Magnus Hagander, minor editorialization from Neil Conway.
-
由 Bruce Momjian 提交于
> o -Allow PL/pgSQL EXECUTE query_var INTO record_var;
-
由 Tom Lane 提交于
wrong, but nobody noticed because they were also useless.
-
由 Tom Lane 提交于
works properly for 1-D comparisons. Fix some other errors such as bogus commutator specifications.
-
由 Tom Lane 提交于
with a table that has a small predicted size. Avoids wasting several hundred K on the timezone hash table, which is likely to have only one or a few entries, but the entries use up 10Kb apiece ...
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
with main, avoid using a SQL-defined SQLSTATE for what is most definitely not a SQL-compatible error condition, fix documentation omissions, adhere to message style guidelines, don't use two GUC_REPORT variables when one is sufficient. Nothing done about pg_dump issues.
-
由 Tom Lane 提交于
-
- 26 6月, 2005 5 次提交
-
-
由 Bruce Momjian 提交于
literally. Add GUC variables: "escape_string_warning" - warn about backslashes in non-E strings "escape_string_syntax" - supports E'' syntax? "standard_compliant_strings" - treats backslashes literally in '' Update code to use E'' when escapes are used.
-
由 Tom Lane 提交于
cosmetic at the moment, but someday Oid might be 64 bits ...
-
由 Tom Lane 提交于
CREATE DATABASE does one internally.
-
由 Tom Lane 提交于
should fix the recent reports of "index is not a btree" failures, as well as preventing a more obscure race condition involving changes to a template database just after copying it with CREATE DATABASE.
-
由 Tom Lane 提交于
was being called twice in normal operation, leading to a leak of one set of relcache subsidiary info. Per report from Jeff Gold.
-
- 25 6月, 2005 7 次提交
-
-
由 Bruce Momjian 提交于
> o Pass arrays natively instead of as text between plperl and postgres > o Add support for polymorphic arguments and return types to plperl
-
由 Bruce Momjian 提交于
< * Allow per-user, per-group quotas per-tablespace > * Allow per-tablespace quotas
-
由 Bruce Momjian 提交于
< * Allow per-user and per-tablespaces quotas > * Allow per-user, per-group quotas per-tablespace
-
由 Bruce Momjian 提交于
> * Allow per-user and per-tablespaces quotas
-
由 Bruce Momjian 提交于
> * Add NUMERIC division operator that doesn't round? > > Currently NUMERIC _rounds_ the result to the specified precision. > This means division can return a result that multiplied by the > divisor is greater than the dividend, e.g. this returns a value > 10: > > SELECT (10::numeric(2,0) / 6::numeric(2,0))::numeric(2,0) * 6; > > The positive modulus result returned by NUMERICs might be considered > inaccurate, in one sense. >
-
由 Bruce Momjian 提交于
> > Currently SIGTERM of a backend can lead to lock table corruption. >
-
由 Tom Lane 提交于
to the existing X-direction tests. An rtree class now includes 4 actual 2-D tests, 4 1-D X-direction tests, and 4 1-D Y-direction tests. This involved adding four new Y-direction test operators for each of box and polygon; I followed the PostGIS project's lead as to the names of these operators. NON BACKWARDS COMPATIBLE CHANGE: the poly_overleft (&<) and poly_overright (&>) operators now have semantics comparable to box_overleft and box_overright. This is necessary to make r-tree indexes work correctly on polygons. Also, I changed circle_left and circle_right to agree with box_left and box_right --- formerly they allowed the boundaries to touch. This isn't actually essential given the lack of any r-tree opclass for circles, but it seems best to sync all the definitions while we are at it.
-
- 24 6月, 2005 4 次提交
-
-
由 Tatsuo Ishii 提交于
-
由 Tom Lane 提交于
CURRENT_TIME, and LOCALTIME: now they just produce "timestamptz" not "timestamptz(6)", etc. This makes the behavior more consistent with our choice to not assign a specific default precision to column datatypes. It should also save a few cycles at runtime due to not having to invoke the round-to-given-precision functions. I also took the opportunity to translate CURRENT_TIMESTAMP into "now()" instead of an invocation of the timestamptz input converter --- this should save a few cycles too.
-
由 Tatsuo Ishii 提交于
performance. patches submitted by Atsushi Ogawa.
-
由 Bruce Momjian 提交于
-