- 30 Jun, 2005 5 commits
- 
- 
Neil Conway authored
- 
Neil Conway authoredinclude. 
- 
Tom Lane authored
- 
Neil Conway authoredmalloc() succeeded but the second failed, the buffer allocated by the first malloc() would be leaked. Fix this by allocating both buffers via a single malloc(), as suggested by Tom. Per Coverity static analysis performed by EnterpriseDB. 
- 
Tom Lane authoredthe difference between checkpoints forced due to WAL segment consumption and checkpoints forced for other reasons (such as CREATE DATABASE). Avoid generating 'checkpoints are occurring too frequently' messages when the checkpoint wasn't caused by WAL segment consumption. Per gripe from Chris K-L. 
 
- 
- 29 Jun, 2005 5 commits
- 
- 
Tom Lane authoredcurrent 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 authoredrole memberships; make superuser/createrole distinction do something useful; fix some locking and CommandCounterIncrement issues; prevent creation of loops in the membership graph. 
- 
Teodor Sigaev authored
- 
Bruce Momjian authoredKarl O. Pinc 
- 
Bruce Momjian authoredVictor Y. Yegorov 
 
- 
- 28 Jun, 2005 7 commits
- 
- 
Bruce Momjian authored
- 
Bruce Momjian authoredRemove extra backslash in pattern. Luke Lonergan 
- 
Tom Lane authoredIn particular, make hba.c cope with zero-length tokens, which it never did properly before. Also, enforce rolcanlogin. 
- 
Tom Lane authoredsyntactic 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. 
- 
Teodor Sigaev authored
- 
Tom Lane authored
- 
Tom Lane authoredand 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. 
 
- 
- 27 Jun, 2005 8 commits
- 
- 
Bruce Momjian authored> * -Add concurrency to GIST 
- 
Teodor Sigaev authored- 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 authoredname 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 authored> * -Remove kerberos4 from source tree 
- 
Neil Conway authoredsome security issues, and upstream has declared it "dead". Patch from Magnus Hagander, minor editorialization from Neil Conway. 
- 
Bruce Momjian authored> o -Allow PL/pgSQL EXECUTE query_var INTO record_var; 
- 
Tom Lane authoredwrong, but nobody noticed because they were also useless. 
- 
Tom Lane authoredworks properly for 1-D comparisons. Fix some other errors such as bogus commutator specifications. 
 
- 
- 26 Jun, 2005 5 commits
- 
- 
Tom Lane authoredwith 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 authored
- 
Tom Lane authoredwith 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 authored
- 
Bruce Momjian authoredliterally. 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.
 
- 
- 25 Jun, 2005 9 commits
- 
- 
Tom Lane authoredcosmetic at the moment, but someday Oid might be 64 bits ... 
- 
Tom Lane authoredCREATE DATABASE does one internally. 
- 
Tom Lane authoredshould 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 authoredwas being called twice in normal operation, leading to a leak of one set of relcache subsidiary info. Per report from Jeff Gold. 
- 
Bruce Momjian authored> 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 authored< * Allow per-user, per-group quotas per-tablespace > * Allow per-tablespace quotas 
- 
Bruce Momjian authored< * Allow per-user and per-tablespaces quotas > * Allow per-user, per-group quotas per-tablespace 
- 
Bruce Momjian authored> * Allow per-user and per-tablespaces quotas 
- 
Bruce Momjian authored> * 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. > 
 
- 
- 24 Jun, 2005 1 commit
- 
- 
Bruce Momjian authored> > Currently SIGTERM of a backend can lead to lock table corruption. > 
 
-