aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Fix calculation of plan node extParams to account for the possibility that oneTom Lane2006-05-03
| | | | | | | | | | | | initPlan sets a parameter for another. This could not (I think) happen before 8.1, but it's possible now because the initPlans generated by MIN/MAX optimization might themselves use initPlans. We attach those initPlans as siblings of the MIN/MAX ones, not children, to avoid duplicate computation when multiple MIN/MAX aggregates are present; so this leads to the case of an initPlan needing the result of a sibling initPlan, which is not possible with ordinary query nesting. Hadn't been noticed because in most contexts having too much stuff listed in extParam is fairly harmless. Fixes "plan should not reference subplan's variable" bug reported by Catalin Pitis.
* Clean up API for ambulkdelete/amvacuumcleanup as per today's discussion.Tom Lane2006-05-02
| | | | | | This formulation requires every AM to provide amvacuumcleanup, unlike before, but it's surely a whole lot cleaner. Also, add an 'amstorage' column to pg_am so that we can get rid of hardwired knowledge in DefineOpClass().
* Fix broken markup.Tom Lane2006-05-02
|
* Suppress some gcc warnings.Tom Lane2006-05-02
|
* Fix grammar of new error message.Tom Lane2006-05-02
|
* Add GIN opclases for another typesTeodor Sigaev2006-05-02
|
* GIN: Generalized Inverted iNdex.Teodor Sigaev2006-05-02
| | | | text[], int4[], Tsearch2 support for GIN.
* Avoid assuming that statistics for a parent relation reflect the properties ofTom Lane2006-05-02
| | | | | | | | | | | | | the union of its child relations as well. This might have been a good idea when it was originally coded, but it's a fatally bad idea when inheritance is being used for partitioning. It's better to have no stats at all than completely misleading stats. Per report from Mark Liberman. The bug arguably exists all the way back, but I've only patched HEAD and 8.1 because we weren't particularly trying to support partitioning before 8.1. Eventually we ought to look at deriving union statistics instead of just punting, but for now the drop kick looks good.
* Provide a namespace.c function for lookup of an operator with exactTom Lane2006-05-01
| | | | | | | | input datatypes given, and use this before trying OpernameGetCandidates. This is faster than the old method when there's an exact match, and it does not seem materially slower when there's not. And it definitely makes some of the callers cleaner, because they didn't really want to know about a list of candidates anyway. Per discussion with Atsushi Ogawa.
* Code review for GRANT CONNECT patch. Spell the privilege as CONNECT notTom Lane2006-04-30
| | | | | CONNECTION, fix a number of places that were missed (eg pg_dump support), avoid executing an extra search of pg_database during startup.
* Improve the representation of FOR UPDATE/FOR SHARE so that we canTom Lane2006-04-30
| | | | | | support both FOR UPDATE and FOR SHARE in one command, as well as both NOWAIT and normal WAIT behavior. The more general code is actually simpler and cleaner.
* Done:Bruce Momjian2006-04-30
| | | | > o -Allow per-database permissions to be set via GRANT
* Add GRANT CONNECTION ON DATABASE, to be used in addition to pg_hba.conf.Bruce Momjian2006-04-30
| | | | Gevik Babakhani
* Add question mark:Bruce Momjian2006-04-30
| | | | > * %Disallow changing default expression of a SERIAL column?
* Revert patch pending more discussion:Bruce Momjian2006-04-30
| | | | Disallow changing DEFAULT expression of a SERIAL column.
* Remove sema.c, superseded by win32_sema.c.Tom Lane2006-04-29
|
* Rearrange some configure.in comments for better readability.Tom Lane2006-04-29
| | | | | Commit configure and pg_config.h.in, missed in last configure.in update.
* We only need to add thread.c on non-WIN32 platforms, since get_home_pathTom Lane2006-04-29
| | | | | doesn't use pqGetpwuid on WIN32. Rather than try to figure out why it won't build on WIN32, just remove it.
* Done:Bruce Momjian2006-04-29
| | | | > * -Disallow changing default expression of a SERIAL column
* Disallow changing DEFAULT expression of a SERIAL column.Bruce Momjian2006-04-29
| | | | Dhanaraj M
* Add Win32 semaphore implementation, rather than mimicking SysVBruce Momjian2006-04-29
| | | | | | semaphores. Qingqing Zhou
* Solaris tas() uses 'int' now.Bruce Momjian2006-04-29
| | | | Theo Schlossnagle
* Intel compiler has a bug/misoptimization in checking for division by NANBruce Momjian2006-04-29
| | | | | | (NaN == 0), -mp1 fixes it, so add it to the CFLAGS. Autoconf run. Jeremy Drake
* Fix s_lock_test to use tas.o file, if needed.Bruce Momjian2006-04-28
|
* Remove the restriction originally coded into optimize_minmax_aggregates() thatTom Lane2006-04-28
| | | | | | | | | | | | | | | | | | | | | | | | | MIN/MAX not be converted to use an index if the query WHERE clause contains any volatile functions or subplans. I had originally feared that the conversion might alter the behavior of such a query with respect to a volatile function. Well, so it might, but only in the sense that the function would get evaluated at a subset of the table rows rather than all of them --- and we have never made any such guarantee anyway. (For instance, we don't refuse to use an index for an ordinary non-aggregate query when one of the non-indexable filter conditions contains a volatile function.) The prohibition against subplans was because of worry that that case wasn't adequately tested, which it wasn't, but it turns out to be possible to make 8.1 fail anyway: regression=# select o.ten, (select max(unique2) from tenk1 i where ten = o.ten or ten = (select f1 from int4_tbl limit 1)) from tenk1 o; ERROR: direct correlated subquery unsupported as initplan This is due to bogus code in SS_make_initplan_from_plan (it's an initplan, ergo it can't have any parParams). Having fixed that, we might as well allow subplans as well as initplans.
* Modify Solaris compiler build rules to use the cpp preprocessor, the theBruce Momjian2006-04-28
| | | | x86 file.
* Darin -> Darwin.Bruce Momjian2006-04-28
|
* Remove extra 'else' in solaris compiler code.Bruce Momjian2006-04-28
|
* Remove "volatile" from tas function, per TOm.Bruce Momjian2006-04-28
|
* Update list of platforms that have a list of exported symbols.Bruce Momjian2006-04-28
|
* Arrange to strip libpq.so of symbols that aren't officially supposed toTom Lane2006-04-28
| | | | | | | | be exported on Linux and Darwin. We already did this on Windows but that's not enough, as evidenced by the fact that libecpg had an unexpected dependency on one such symbol. We should try to do it on more platforms. Fix ecpg's oversight, and bump libpq's major .so version number to reflect the unwanted but nonetheless real ABI break.
* Add info on pgport linking requirements.Bruce Momjian2006-04-28
|
* Rewrite Solaris compiler tas() assembly routines, merge i386 and x86_64Bruce Momjian2006-04-27
| | | | | | assembler files, renamed as solaris_x86.s. Theo Schlossnagle
* Fix ltreeparentsel so it actually works ...Tom Lane2006-04-27
|
* Generalize mcv_selectivity() to support both VAR OP CONST and CONST OP VARTom Lane2006-04-27
| | | | | | cases. This was not needed in the existing uses within selfuncs.c, but if we're gonna export it for general use, the extra generality seems helpful. Motivated by looking at ltree example.
* Change log message about vacuuming database name from LOG to DEBUG1.Bruce Momjian2006-04-27
| | | | Prevents duplicate meaningless log messsages.
* Add to item log_min_error_messages item:Bruce Momjian2006-04-27
| | | | | > Another idea is to allow separate configuration files for each module, > or allow arbitrary SET commands to be passed to them.
* On second thought, keep SSL CRL as a log, and wait for feedback from 8.2.Bruce Momjian2006-04-27
|
* Downgrade SSL CRL file missing message from LOG to DEBUG1.Bruce Momjian2006-04-27
|
* Turn off strict aliasing when using AIX xlc compiler.Bruce Momjian2006-04-27
| | | | autoconf run.
* Revert patch, causing plpython regression failues:Bruce Momjian2006-04-27
| | | | | | > >> >> > 1) named parameters additionally to args[] > >> >> > 2) return composite-types from plpython as dictionary > >> >> > 3) return result-set from plpython as list, iterator or generator
* Tab alignment cleanup.Bruce Momjian2006-04-27
|
* Add underscores to SSL CERT macro names, for clarity and consistencyBruce Momjian2006-04-27
| | | | with be-secure.c.
* Add SSL include needed for psql, after libpq adjustments.Bruce Momjian2006-04-27
|
* Add:Bruce Momjian2006-04-27
| | | | | > * Invalidate prepared queries, like INSERT, when the table definition > is altered
* Add support for SSL Certificate Revocation List (CRL) files, root.crl.Bruce Momjian2006-04-27
| | | | Libor Hoho?
* plpython improvements:Bruce Momjian2006-04-27
| | | | | | | | | 1) named parameters additionally to args[] 2) return composite-types from plpython as dictionary 3) return result-set from plpython as list, iterator or generator Hannu Krosing Sven Suursoho
* Un-break ltree.Tom Lane2006-04-27
|
* Change libpq's PQgetssl() to return a void*, rather than SSL *, so thatBruce Momjian2006-04-27
| | | | | | applications don't need the SSL headers. Martijn van Oosterhout
* If we're going to expose VariableStatData for contrib modules to use,Tom Lane2006-04-27
| | | | then we should export a reasonable set of the supporting routines too.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 18:33:30 +0000