- Mar 18, 2001
-
-
Tom Lane authored
space in front of it. Improve comments a little.
-
Tom Lane authored
I'm betting the QNX4 port does not either ...
-
Tom Lane authored
work in BeOS port.
-
Philip Warner authored
which caused segfault in a data-only retore with BLOBs
-
Tom Lane authored
-
Tom Lane authored
slow backend, if we update unconditionally as the code did before).
-
- Mar 17, 2001
-
-
Tom Lane authored
the new log file with zeroes, only while renaming it into place. This should prevent problems with 'stuck spinlock' errors under heavy load.
-
- Mar 16, 2001
-
-
Michael Meskes authored
-
Hiroshi Inoue authored
Sorry Eiji.
-
Tom Lane authored
O_SYNC, or O_DSYNC (as available on a given platform). Add GUC parameter to control sync method. Also, add defense to XLogWrite to prevent it from going nuts if passed a target write position that's past the end of the buffers so far filled by XLogInsert.
-
Hiroshi Inoue authored
Provide an extenisible scheme of encoding conversion. As the first step, SJIS and BIG5 are supported. From now on multibyte people would be happy to use this psqlodbc driver. Eiji Tokuya e-tokuya@mail.sankyo-unyu.co.jp
-
- Mar 15, 2001
-
-
D'Arcy J.M. Cain authored
Fix a bug where cs.execute('select %d + %d', (1, 2)) would get interpreted as cs.executemany('select %d + %d', (1, 2))
-
D'Arcy J.M. Cain authored
-
Tom Lane authored
to a join or subselect alias ... cf. Oliver Elphick's complaint 13-Mar.
-
- Mar 14, 2001
-
-
Tom Lane authored
is still a memory leak, but a little less bad than it was.
-
Tom Lane authored
I'm not sure that it's really necessary to save insert events when there are only after update or delete triggers, but certainly it's wrong for COPY to behave differently from an INSERT query.
-
Peter Eisentraut authored
-
Peter Eisentraut authored
-
Peter Eisentraut authored
does have -o.
-
Peter Eisentraut authored
bug reports. ;-)
-
Peter Eisentraut authored
-
Peter Eisentraut authored
-
Peter Eisentraut authored
-
Tom Lane authored
-
Tom Lane authored
(per recent discussion with Tatsuo). Hopefully the compilers with that old bug are all long gone.
-
Tom Lane authored
-
Bruce Momjian authored
Change the administrator to 'an' administrator.
-
Tom Lane authored
Just try again later.
-
Tom Lane authored
-
Bruce Momjian authored
This connection has been terminated by the administrator
-
Hiroshi Inoue authored
-
Hiroshi Inoue authored
-
- Mar 13, 2001
-
-
Peter Eisentraut authored
pg_ctl '-l' option.
-
Tom Lane authored
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...
-
Philip Warner authored
- Use exact table names when enabling/disabling triggers
-
Hiroshi Inoue authored
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.
-
Tom Lane authored
* 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.
-
Tom Lane authored
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.
-
- Mar 11, 2001
-
-
Peter Eisentraut authored
Respect default port setting in JDBC driver. Pick up version number from Makefile.global. Change installation directory to share/java/. Document.
-
Tom Lane authored
driver does not work because its internal cross-references get bound to similarly named functions in unixODBC shared library.
-