aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* updatePeter Eisentraut2001-03-13
|
* updatePeter Eisentraut2001-03-13
|
* Change xlog page-header format to include StartUpID. Use the SUI toTom Lane2001-03-13
| | | | | | | | | detect case that next page in log came from an older run than the prior page. This avoids the necessity to re-zero the log after recovery from a crash, which is good because we need not risk destroying valuable log information. This forces another initdb since yesterday :-(. Need to get that log reset utility done...
* 'test -e' isn't portable. Use 'test -f'.Peter Eisentraut2001-03-13
|
* Update FAQ.Bruce Momjian2001-03-13
|
* Document changed features of pg_dump, including:Philip Warner2001-03-13
| | | | | | - Large Object dumps - Compressed custom format - Requirement to use template0 when creating DB
* - Use subselect when enabling triggers,Philip Warner2001-03-13
| | | | - Use exact table names when enabling/disabling triggers
* The attached file contains the registry settings required to install theHiroshi Inoue2001-03-13
| | | | | | | | | | | | ODBC driver on Windows 9X/ME/NT/2K when using the later versions of the driver that don't have the Installshield installation: 1) Install psqlodbc.dll in to C:\Windows\System or C:\Winnt\System32 2) Add the registry settings in the attached file using regedit. A useful addition to src/interfaces/odbc perhaps? Regards, Dave.
* Update for new pg_control format.Tom Lane2001-03-13
|
* XLOG (and related) changes:Tom Lane2001-03-13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Store two past checkpoint locations, not just one, in pg_control. On startup, we fall back to the older checkpoint if the newer one is unreadable. Also, a physical copy of the newest checkpoint record is kept in pg_control for possible use in disaster recovery (ie, complete loss of pg_xlog). Also add a version number for pg_control itself. Remove archdir from pg_control; it ought to be a GUC parameter, not a special case (not that it's implemented yet anyway). * Suppress successive checkpoint records when nothing has been entered in the WAL log since the last one. This is not so much to avoid I/O as to make it actually useful to keep track of the last two checkpoints. If the things are right next to each other then there's not a lot of redundancy gained... * Change CRC scheme to a true 64-bit CRC, not a pair of 32-bit CRCs on alternate bytes. Polynomial borrowed from ECMA DLT1 standard. * Fix XLOG record length handling so that it will work at BLCKSZ = 32k. * Change XID allocation to work more like OID allocation. (This is of dubious necessity, but I think it's a good idea anyway.) * Fix a number of minor bugs, such as off-by-one logic for XLOG file wraparound at the 4 gig mark. * Add documentation and clean up some coding infelicities; move file format declarations out to include files where planned contrib utilities can get at them. * Checkpoint will now occur every CHECKPOINT_SEGMENTS log segments or every CHECKPOINT_TIMEOUT seconds, whichever comes first. It is also possible to force a checkpoint by sending SIGUSR1 to the postmaster (undocumented feature...) * Defend against kill -9 postmaster by storing shmem block's key and ID in postmaster.pid lockfile, and checking at startup to ensure that no processes are still connected to old shmem block (if it still exists). * Switch backends to accept SIGQUIT rather than SIGUSR1 for emergency stop, for symmetry with postmaster and xlog utilities. Clean up signal handling in bootstrap.c so that xlog utilities launched by postmaster will react to signals better. * Standalone bootstrap now grabs lockfile in target directory, as added insurance against running it in parallel with live postmaster.
* Avoid O(N^2) behavior in deferredTriggerAddEvent() for large numbers ofTom Lane2001-03-12
| | | | | | tuples inserted/deleted/updated in a single transaction. On my machine, this reduced the time to delete 80000 tuples in a foreign-key-referencing table from ~15min to ~8sec.
* Update TODO list.Bruce Momjian2001-03-11
|
* Throw error if Ant is not found and Java is requested. Remove redundantPeter Eisentraut2001-03-11
| | | | AC_SUBST that messed up the diversions and thus the configure output.
* Add uninstall target to Java build.Peter Eisentraut2001-03-11
| | | | | | | Respect default port setting in JDBC driver. Pick up version number from Makefile.global. Change installation directory to share/java/. Document.
* Turns out the HPUX linker likes -Bsymbolic too. Without this, ODBCTom Lane2001-03-10
| | | | | driver does not work because its internal cross-references get bound to similarly named functions in unixODBC shared library.
* Provide a hack to let initialization happen on platforms for whichTom Lane2001-03-10
| | | | psqlodbc.c's constructor-making techniques do not work.
* Do not accept values from sections following the specified section.Tom Lane2001-03-10
|
* BOX documentation disagreed with code about corner order.Tom Lane2001-03-10
|
* Update TODO list.Bruce Momjian2001-03-10
|
* Document --with-java.Peter Eisentraut2001-03-10
|
* Eliminate some hackery when creating text files (INSTALL) with a few linesPeter Eisentraut2001-03-10
| | | | of DSSSL.
* Use install-sh unconditionally.Peter Eisentraut2001-03-10
|
* FATAL errors should cause exit with nonzero status if we are not runningTom Lane2001-03-10
| | | | | under the postmaster --- specifically, if we are a standalone backend running under the initdb script, this is critical!
* 1)Allow the access to indexes with up to 16 keys.Hiroshi Inoue2001-03-10
| | | | | 2)Fix some memory leaks. 3)Change some bogus error messages.
* Don't choke on superuser names containing random punctuation.Tom Lane2001-03-09
|
* Recursive distclean shouldn't depend on recursive clean. SubdirectoriesPeter Eisentraut2001-03-09
| | | | handle this.
* Integrate "Porting from Oracle PL/SQL" HOWTO from Roberto Mello.Peter Eisentraut2001-03-09
|
* hold interupts during LockWaitCancel().Hiroshi Inoue2001-03-09
|
* Add Japanese FAQ>Bruce Momjian2001-03-08
|
* Update TODO list.Bruce Momjian2001-03-08
|
* Update FAQ.Bruce Momjian2001-03-08
|
* A subplan invoked within an aggregate function's argument shouldTom Lane2001-03-08
| | | | | be allowed to receive ungrouped variables of the current query level. Curious that no one reported this bug before...
* Modify wchar conversion routines to not fetch the next byte past the endTom Lane2001-03-08
| | | | | | | | | | | | | of a counted input string. Marinos Yannikos' recent crash report turns out to be due to applying pg_ascii2wchar_with_len to a TEXT object that is smack up against the end of memory. This is the second just-barely- reproducible bug report I have seen that traces to some bit of code fetching one more byte than it is allowed to. Let's be more careful out there, boys and girls. While at it, I changed the code to not risk a similar crash when there is a truncated multibyte character at the end of an input string. The output in this case might not be the most reasonable output possible; if anyone wants to improve it further, step right up...
* Repair a number of places that didn't bother to check whether PageAddItemTom Lane2001-03-07
| | | | | | | | | | succeeds or not. Revise rtree page split algorithm to take care about making a feasible split --- ie, will the incoming tuple actually fit? Failure to make a feasible split, combined with failure to notice the failure, account for Jim Stone's recent bug report. I suspect that hash and gist indices may have the same type of bug, but at least now we'll get error messages rather than silent failures if so. Also clean up rtree code to use Datum rather than char* where appropriate.
* > Applied. Thanks.Bruce Momjian2001-03-07
| | | | | | | | | | | One more :)) It's for improper function argumets for PLTCL_UNKNOWN_SUPPORT code I'm not an autoconf expert, but is it possible to enable unknown support in pltcl with configure option ? This support is really handy for real life usage of pl/tcl. seva@sevasoft.kiev.ua
* pltcl_loadmod has problems with big (>4k) modules because of missing incrBruce Momjian2001-03-07
| | | | | | in splitting code: seva@sevasoft.kiev.ua
* Update my2pg, new version.Bruce Momjian2001-03-06
|
* Believe $POSTGRES_LIB and $POSTGRES_INCLUDE only if they name actualTom Lane2001-03-06
| | | | directories, per suggestion from Robert Creager.
* Sync rule for making INSTALL file.Peter Eisentraut2001-03-06
|
* Help message s/dump/restore/ (must have been copy&pasted from pg_dump).Peter Eisentraut2001-03-06
|
* Some editing, enhance markup, move description section before options list.Peter Eisentraut2001-03-06
|
* Shorten TOAST mentionBruce Momjian2001-03-06
|
* Update/correct/refine.Peter Eisentraut2001-03-06
|
* Tue Mar 06 12:05:00 GMT 2001 peter@retep.org.ukPeter Mount2001-03-06
| | | | | - Removed org.postgresql.xa.Test from the JDBC EE driver as it's an old test class and prevented it from compiling.
* - Reflect change of option -U to -LPhilip Warner2001-03-06
|
* - Minor correction to usagePhilip Warner2001-03-06
|
* - Dump relevant parts of sequences only when doing schemaOnly & dataOnlyPhilip Warner2001-03-06
| | | | - Prevent double-dumping of sequences when dataOnly.
* - Only disable triggers in DataOnly (or implied data-only) restores.Philip Warner2001-03-06
| | | | - Change -U option to -L to allow -U to specify username in future. (pg_restore)
* Add missing space, change some markup.Peter Eisentraut2001-03-05
|
* Sorry, that change was not correct.Peter Eisentraut2001-03-05
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-02 23:59:15 +0000