aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* Clean files after installing, since those files will most likely be rootPeter Eisentraut2000-11-16
| | | | owned, which can be annoying.
* That variable I removed broke XLOG, that part of the deltaBruce Momjian2000-11-16
| | | | | | should have read: Alfred Perlstein
* Make pgsql compile on FreeBSD-alpha.Bruce Momjian2000-11-16
| | | | | | | | | | | | | | | | | | Context diff this time. Remove -m486 compile args for FreeBSD-i386, compile -O2 on i386. Compile with only -O on alpha for codegen safety. Make the port use the TEST_AND_SET for alpha and i386 on FreeBSD. Fix a lot of bogus string formats for outputting pointers (cast to int and %u/%x replaced with no cast and %p), and 'Size'(size_t) are now cast to 'unsigned long' and output with %lu/ Remove an unused variable. Alfred Perlstein
* Syslog Facility PatchBruce Momjian2000-11-16
| | | | | | Here is one with a stray character removed. Larry Rosenman
* Rename parameter "hostname" to "virtual_host". Seemed very ambiguous...Peter Eisentraut2000-11-15
|
* Clean up array-dimensions parser a bit.Tom Lane2000-11-14
| | | | This code still needs a lot of love, however ...
* Fix return typePeter Eisentraut2000-11-14
|
* spaces to tabPeter Eisentraut2000-11-14
|
* Give GCC on Irix a (theoretical) chance.Peter Eisentraut2000-11-14
|
* Minor cleanup of tableOid-related coding.Tom Lane2000-11-14
|
* Clean up comments.Tom Lane2000-11-14
|
* Small polishing of syslog facility and ident settings. Only allow settingPeter Eisentraut2000-11-14
| | | | | at postmaster start, rename syslog_progid to syslog_ident, since syslog itself uses that term, fix doc markup.
* Extend CREATE DATABASE to allow selection of a template database to beTom Lane2000-11-14
| | | | | | | | | | cloned, rather than always cloning template1. Modify initdb to generate two identical databases rather than one, template0 and template1. Connections to template0 are disallowed, so that it will always remain in its virgin as-initdb'd state. pg_dumpall now dumps databases with restore commands that say CREATE DATABASE foo WITH TEMPLATE = template0. This allows proper behavior when there is user-added data in template1. initdb forced!
* Update and polish postmaster and postgres help output and man pages.Peter Eisentraut2000-11-14
|
* Fix illegal combination of SearchSysCacheTuple() and heap_freetuple()Hiroshi Inoue2000-11-14
| | | | in AlterTableOwner().
* Rename PortName to PortNumber.Bruce Momjian2000-11-14
|
* Remove -k unix socketpath option from client side, allow hostname withBruce Momjian2000-11-13
| | | | leading slash to behave as a unix socket path.
* Ok, You guys are probably tired of me, BUT, here is another one, thatBruce Momjian2000-11-13
| | | | | | | | | | | | | adds the facility to set the program name used in syslog. (this includes the other ones). One gotcha, the parser doesn't like special characters in strings. For example, i tried to use pg-test, and if failed the parse coming from the postgresql.conf file. I don't think it's a showstopper.. Larry Rosenman
* Fix for no hterror().Bruce Momjian2000-11-13
|
* UUNET is looking into offering PostgreSQL as a part of a managed webBruce Momjian2000-11-13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | hosting product, on both shared and dedicated machines. We currently offer Oracle and MySQL, and it would be a nice middle-ground. However, as shipped, PostgreSQL lacks the following features we need that MySQL has: 1. The ability to listen only on a particular IP address. Each hosting customer has their own IP address, on which all of their servers (http, ftp, real media, etc.) run. 2. The ability to place the Unix-domain socket in a mode 700 directory. This allows us to automatically create an empty database, with an empty DBA password, for new or upgrading customers without having to interactively set a DBA password and communicate it to (or from) the customer. This in turn cuts down our install and upgrade times. 3. The ability to connect to the Unix-domain socket from within a change-rooted environment. We run CGI programs chrooted to the user's home directory, which is another reason why we need to be able to specify where the Unix-domain socket is, instead of /tmp. 4. The ability to, if run as root, open a pid file in /var/run as root, and then setuid to the desired user. (mysqld -u can almost do this; I had to patch it, too). The patch below fixes problem 1-3. I plan to address #4, also, but haven't done so yet. These diffs are big enough that they should give the PG development team something to think about in the meantime :-) Also, I'm about to leave for 2 weeks' vacation, so I thought I'd get out what I have, which works (for the problems it tackles), now. With these changes, we can set up and run PostgreSQL with scripts the same way we can with apache or proftpd or mysql. In summary, this patch makes the following enhancements: 1. Adds an environment variable PGUNIXSOCKET, analogous to MYSQL_UNIX_PORT, and command line options -k --unix-socket to the relevant programs. 2. Adds a -h option to postmaster to set the hostname or IP address to listen on instead of the default INADDR_ANY. 3. Extends some library interfaces to support the above. 4. Fixes a few memory leaks in PQconnectdb(). The default behavior is unchanged from stock 7.0.2; if you don't use any of these new features, they don't change the operation. David J. MacKenzie
* SearchSysCacheTupleCopy() instead of SearchSysCache()Hiroshi Inoue2000-11-13
|
* prevent open failure of VIEWHiroshi Inoue2000-11-13
|
* Keep track of the last active slot in the shared ProcState array, soTom Lane2000-11-12
| | | | | | | | | that search loops only have to scan that far and not through all maxBackends entries. This eliminates a performance penalty for setting maxBackends much higher than the average number of active backends. Also, eliminate no-longer-used 'backend tag' concept. Remove setting of environment variables at backend start (except for CYR_RECODE), since none of them are being examined by the backend any longer.
* 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
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-24 15:03:52 +0000