aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* Restructure handling of inheritance queries so that they work with outerTom Lane2000-11-12
| | | | | | | | | | | | | | | | | joins, and clean things up a good deal at the same time. Append plan node no longer hacks on rangetable at runtime --- instead, all child tables are given their own RT entries during planning. Concept of multiple target tables pushed up into execMain, replacing bug-prone implementation within nodeAppend. Planner now supports generating Append plans for inheritance sets either at the top of the plan (the old way) or at the bottom. Expanding at the bottom is appropriate for tables used as sources, since they may appear inside an outer join; but we must still expand at the top when the target of an UPDATE or DELETE is an inheritance set, because we actually need a different targetlist and junkfilter for each target table in that case. Fortunately a target table can't be inside an outer join... Bizarre mutual recursion between union_planner and prepunion.c is gone --- in fact, union_planner doesn't really have much to do with union queries anymore, so I renamed it grouping_planner.
* Make sure shell scripts send error messages to stderr.Peter Eisentraut2000-11-11
| | | | | Improve help output. Teach droplang to remove 'pltclu'.
* Allow more timezone-like interpretation of INTERVALs.Thomas G. Lockhart2000-11-11
| | | | Fix up labeling of some new test cases.
* Allow more timezone-like interpretation of INTERVALs.Thomas G. Lockhart2000-11-11
|
* Check for existence of the results directory before invoking mkdir.Thomas G. Lockhart2000-11-11
|
* Define conversions to and from text for date, time, and timetz.Thomas G. Lockhart2000-11-11
|
* Allow interpretation of INTERVALs with more timezone-like syntax.Thomas G. Lockhart2000-11-11
| | | | | | Define conversions to and from text for date, time, and timetz. Have millisecond and microsecond return full # of seconds in those units. Previously, only returned full fractional part in those units.
* Fix bug in recent improvement to type resolution code. Forgot to retainThomas G. Lockhart2000-11-11
| | | | | "best choice" type category when resolving UNKNOWN function and operator arguments. Thanks to Tom Lane for finding test case.
* Update expected output to track recent code changes.Tom Lane2000-11-10
|
* Update to PyGreSQL 3.1:Bruce Momjian2000-11-10
| | | | | | | | | | | | | | | | | | | | | | | | | | Fix some quoting functions. In particular handle NULLs better. Use a method to add primary key information rather than direct manipulation of the class structures. Break decimal out in _quote (in pg.py) and treat it as float. Treat timestamp like date for quoting purposes. Remove a redundant SELECT from the get method speeding it, and insert since it calls get, up a little. Add test for BOOL type in typecast method to pgdbTypeCache class. (tv@beamnet.de) Fix pgdb.py to send port as integer to lower level function (dildog@l0pht.com) Change pg.py to speed up some operations Allow updates on tables with no primary keys. D'Arcy J.M. Cain
* the bug was not fixed in the snapshot of November 5th. Also the enterpriseBruce Momjian2000-11-10
| | | | | | | | | edition of the driver did not compile. I have fixed both issues again. I have attached the modified files to this email, maybe you can check them into the repository. (Fixes are marked with //FIXME). Enterprise edition driver now compiles and seems to work. Jan Thomae
* Adjust INET/CIDR display conventions and reimplement some INET/CIDRTom Lane2000-11-10
| | | | | | | functions, per recent discussions on pghackers. For now, I have called the verbose-display formatting function text(), but will reconsider if enough people object. initdb forced.
* Use SearchSysCacheTupleCopy() instead of SearchSysCacheTuple() inHiroshi Inoue2000-11-10
| | | | | order to continue to access the tuple more than now. This would resolve a segmentation fault error.
* pg_fsync is fsync in WAL version.Vadim B. Mikheev2000-11-10
|
* Clean up syscache so that recursive invocation is safe, and remove errorTom Lane2000-11-10
| | | | | | | | message about recursive use of a syscache. Also remove most of the specialized indexscan routines in indexing.c --- it turns out that catcache.c is perfectly able to perform the indexscan for itself, in fact has already looked up all the information needed to do so! This should be faster as well as needing far less boilerplate code.
* Real dynamic loader codePeter Eisentraut2000-11-09
|
* Also test for 'void *' as third arg of accept() (as on Solaris 7 and 8),Peter Eisentraut2000-11-09
| | | | | | | | | | | but take it as 'int *' instead. Add real test for whether ld -R works on Unixware. Rename --enable-uniconv to --enable-unicode-conversion. Install shlibs mode 755 by default, since 644 causes gratuitous complaints from ldd et al. on some systems.
* ExecEndAppend() neglected to close indices on appended result rels,Tom Lane2000-11-09
| | | | | and improperly prevented the main result rel from being closed if it wasn't one of the Append's own result rels. Per report from Hiroshi.
* Applied yet another patch by Christof. Thanks Cristof!Michael Meskes2000-11-09
| | | | Synced parser.
* Auto checkpoint creation.Vadim B. Mikheev2000-11-09
|
* Please apply this patch to current, to fix a problem with runcheck,Bruce Momjian2000-11-09
| | | | | | | | | | | that installs into a different path than is configured. With this applied both postmaster and the shared libs are location independent for AIX 4.2 and up. Thanks Andreas
* Arrange for CASE or UNION with only untyped literal constants as inputTom Lane2000-11-09
| | | | to resolve the unknown constants as type TEXT.
* Add some more union/intersect/except test cases, per suggestionsTom Lane2000-11-09
| | | | from Kevin O'Gorman.
* Repair some bugs in new union/intersect/except code.Tom Lane2000-11-09
| | | | Thanks to Kevin O'Gorman for finding these...
* Clean up compiler warnings.Tom Lane2000-11-08
|
* Make DROP TABLE rollback-able: postpone physical file delete until commit.Tom Lane2000-11-08
| | | | | | | | | (WAL logging for this is not done yet, however.) Clean up a number of really crufty things that are no longer needed now that DROP behaves nicely. Make temp table mapper do the right things when drop or rename affecting a temp table is rolled back. Also, remove "relation modified while in use" error check, in favor of locking tables at first reference and holding that lock throughout the statement.
* Add ANALYSE spelling of ANALYZE for vacuum.Bruce Momjian2000-11-08
|
* Only use ld -R flag in UW 7.1*, since it's new.Peter Eisentraut2000-11-08
|
* Fix 'soname's for various platforms, so that libpq.so.2.0 is consideredPeter Eisentraut2000-11-08
| | | | compatible with libpq.so.2.1, etc.
* Add dependencies required for parallel makePeter Eisentraut2000-11-08
|
* Dump identity of alternative location, if any.Peter Eisentraut2000-11-08
|
* Add '-c name=val' flag for setting run-time parameters.Peter Eisentraut2000-11-08
|
* Reimplement alternative database locations with symlinks. No changes inPeter Eisentraut2000-11-08
| | | | user interface.
* CLUSTER did no permissions checking, forsooth ...Tom Lane2000-11-08
|
* Enable fallback to string type when argument(s) are of UNKNOWN type.Thomas G. Lockhart2000-11-07
| | | | | | | Same code exactly as for function resolution. An obvious example is for select '1' = '01'; which used to throw an error and which now resolves to two text strings.
* This somehow gets moot. Is there a way to make gcc reject those comments?Bruce Momjian2000-11-07
| | | | Andreas
* Undo incorrectly committed Makefile.Michael Meskes2000-11-07
|
* Third try. Sorry, I had a wrong path in my copy statement.Michael Meskes2000-11-07
|
* Added more patches by Cristif Petig.Michael Meskes2000-11-07
|
* Update for new results.Tom Lane2000-11-07
|
* DropErrorMsg() died with assert failure if try to drop a toast table...Tom Lane2000-11-07
| | | | mea culpa...
* Update geometry for FreeBSD 4.1 (same as 4.0)Peter Eisentraut2000-11-06
|
* Add -V option to backend, to show version, since --version doesn't seemPeter Eisentraut2000-11-06
| | | | | to work everywhere. Also, on FreeBSD you need to set the optreset variable to 1 before parsing the command line a second time with getopt().
* Fix GNU make detection.Peter Eisentraut2000-11-06
| | | | | | (The test 'make --version' with FreeBSD make (and potentially others) would just reinvoke make on the same Makefile, resulting in an infinite loop.)
* Add explicit ORDER BYs in a couple of cases --- seems to be necessaryTom Lane2000-11-06
| | | | to get platform-independent results.
* I think Thomas missed an update here...Tom Lane2000-11-06
|
* Back out aix makefile patch.Bruce Momjian2000-11-06
|
* Makefile.ports (copied from makefiles/Makefile.aix) is included beforeBruce Momjian2000-11-06
| | | | | | | the default target in GNUmakefile is reached. This patch calls that default target. Pete Forman
* Add support for AT TIME ZONE syntax.Thomas G. Lockhart2000-11-06
|
* Add tests for more INTERVAL syntax.Thomas G. Lockhart2000-11-06
| | | | | | Add more tests for JOIN syntax. All tests pass on my Linux box (except for the usual couple of lines for geometry).