summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2004-08-29Add comment on palloc use and DLLIMPORT>Bruce Momjian
2004-08-29>>> I understand your disliking of non-posix stuff. OTOH,Bruce Momjian
>>GetLastError will >>> give much more details than errno. >> >>How much more, really? That mapping table gave me the impression that >>the win32 error codes aren't all that much more detailed than errno... > >The mapping table is not complete. My winerror.h from the SDK >lists 2209 >error codes, whereas errno.h lists 42... > >I still don't think we'll get that much more stuff. Right now, >the Win32 >code paths that actually use the more advanced functions already write >out the error number in case something happens. We can keep doing that >for the other paths (ereport the error *number* when the mapping does >not have a match). The map to errno will catch almost all cases, I >think. And in the corner cases we can do with just the number, and use >"net helpmsg" to get the actual message when checking... Here's an attempt on this. new file goes in backend/port/win32. Magnus Hagander
2004-08-28The attached patch improves pg_ctl's win32 service code to eliminateBruce Momjian
some possible causes of the stale postmaster.pid problem that some users have reported. - The service did not properly report that it accepts SERVICE_CONTROL_SHUTDOWN events, thus it's possible the SCM simply killed the postmaster on shutdown. - 'WaitHints' are now given to the SCM to prevent it timing out if pg_ctl doesn't respond to a control event quickly enough. - During shutdown, the service checkpoint counter is incremented every five seconds for up to a minute to prevent the SCM timing out and assuming the service is not responding. Dave Page
2004-08-28> Am Dienstag, 17. August 2004 14:26 schrieb Fabien COELHO:Bruce Momjian
> > The patch adds missing the "libpgport.a" file to the installation under > > "install-all-headers". It is needed by some contribs. I install the > > library in "pkglibdir", but I was wondering whether it should be "libdir"? Please find attached a small patch against current CVS head that fixes pgport library installation so that it goes to libdir instead of pkglibdir. It works for me. Fabien Coelho
2004-08-28Fix high-bit comparison compiler warning in pg_dump.Bruce Momjian
Philip Warner
2004-08-28Add regression tests for ALTER INDEX.Bruce Momjian
Gavin Sherry
2004-08-28Now that TransactionIdDidAbort doesn't think it should try to modifyTom Lane
pg_clog, there's no reason to do abort marking of subtransactions in a nonintuitive order.
2004-08-28Propogate pg_ctl -D to the postmaster for command-line identification.Bruce Momjian
2004-08-28Add missing Assert to make TransactionIdDidAbort more consistent withTom Lane
TransactionIdDidCommit.
2004-08-28Remove contrib/rserv, since there are better replication solutionsTom Lane
available elsewhere (including a descendant project on gborg).
2004-08-28Rearrange order of operations in heap_drop_with_catalog and index_dropTom Lane
so that we close and flush the doomed relation's relcache entry before we start to delete the underlying catalog rows, rather than afterwards. For awhile yesterday I thought that an unexpected relcache entry rebuild partway through this sequence might explain the infrequent parallel regression failures we were chasing. It doesn't, mainly because there's no CommandCounterIncrement in the sequence and so the deletions aren't "really" done yet. But it sure seems like trouble waiting to happen.
2004-08-28> > Another issue is that when installing the Postgres service withBruce Momjian
> > "pg_ctl register -w ...." the "-w" parameter was not put in > the registry "ImagePath" > > value for the Postgres service. (I added it manually to test.) So I > > suspect that "pg_ctl register" will need to be enhanced to add the > > "-w" parameter to the registry settings. Dave Page
2004-08-28Use dynamic buffer for token buffer in win32 admin checkBruce Momjian
Magnus Hagander
2004-08-28Fix relcache to account properly for subtransaction status of 'new'Tom Lane
relcache entries. Also, change TransactionIdIsCurrentTransactionId() so that if consulted during transaction abort, it will not say that the aborted xact is still current. (It would be better to ensure that it's never called at all during abort, but I'm not sure we can easily guarantee that.) In combination, these fix a crash we have seen occasionally during parallel regression tests of 8.0.
2004-08-28Further tightening of the array literal parser. Prevent junkJoe Conway
from being accepted after the outer right brace. Per report from Markus Bertheau. Also add regression test cases for this change, and for previous recent array literal parser changes.
2004-08-28Can't truncate pg_subtrans during a recovery checkpoint --- subtransTom Lane
module isn't fully initialized yet.
2004-08-28Add missing semicolon; some bison versions warn of this.Tom Lane
2004-08-27Fix Windows emulation of kill(pid, 0). This will now succeed, but onlyTom Lane
if the target PID is a PG postmaster or backend --- for our purposes that is actually better than the Unix behavior. Per Dave Page and Andrew Dunstan.
2004-08-27Introduce local hash table for lock state, as per recent proposal.Tom Lane
PROCLOCK structs in shared memory now have only a bitmask for held locks, rather than counts (making them 40 bytes smaller, which is a good thing). Multiple locks within a transaction are counted in the local hash table instead, and we have provision for tracking which ResourceOwner each count belongs to. Solves recently reported problem with memory leakage within long transactions.
2004-08-27Update wording:Bruce Momjian
< This would require some background daemon to maintain clustering > This might require some background daemon to maintain clustering 397,398c397,398 < paritally filled for easier reorganization. It also might require < creating a merged heap/index data file so an index lookup would > paritally filled for easier reorganization. Another idea would > be to create a merged heap/index data file so an index lookup would
2004-08-27Update win32 comments.Bruce Momjian
2004-08-27Update:Bruce Momjian
< This would require some background daemon to restore clustering > This would require some background daemon to maintain clustering 397c397,399 < paritally filled for easier reorganization. > paritally filled for easier reorganization. It also might require > creating a merged heap/index data file so an index lookup would > automatically access the heap data too.
2004-08-26Fix user locks. Broken some time ago for all platforms by Windows-relatedTom Lane
changes.
2004-08-26Improve some comments.Tom Lane
2004-08-26New Win32 wording that mentions "code".Bruce Momjian
2004-08-26Update documentation to prefer CIDR format for pg_hba.conf and use newBruce Momjian
CIDR column in examples first.
2004-08-26Update Win32 wording.Bruce Momjian
2004-08-26Add warning about Win32 bugs in this release.Bruce Momjian
2004-08-26Update Japanese FAQ.Bruce Momjian
Jun Kuwamura
2004-08-26Update tcp connection faq.Bruce Momjian
2004-08-26Add:Bruce Momjian
> * Merge hardwired timezone names with the TZ database; allow either kind > everywhere a TZ name is currently taken > * Allow customization of the known set of TZ names (generalize the > present australian_timezones hack)
2004-08-25Fix typo in comment, per Andrew Dunstan.Tom Lane
2004-08-25Revise ResourceOwner code to avoid accumulating ResourceOwner objectsTom Lane
for every command executed within a transaction. For long transactions this was a significant memory leak. Instead, we can delete a portal's or subtransaction's ResourceOwner immediately, if we physically transfer the information about its locks up to the parent owner. This does not fully solve the leak problem; we need to do something about counting multiple acquisitions of the same lock in order to fix it. But it's a necessary step along the way.
2004-08-24Translation updatePeter Eisentraut
2004-08-24Translation updatePeter Eisentraut
2004-08-24Allow second and subsequent names in a qualified (dotted) name to beTom Lane
ColLabel instead of just ColId --- that is, any keyword can appear after a dot and it will be taken as an identifier. Fixes problems with names that are okay as standalone function names but fail when qualified.
2004-08-24Update item:Bruce Momjian
< * Implement dirty reads or shared row locks and use them in RI triggers (?) > * Implement dirty reads or shared row locks and use them in RI triggers > > Adding shared locks requires recording the table/rows numbers in a > shared area, and this could potentially be a large amount of data. > One idea is to store the table/row numbers in a separate table and set > a bit on the row indicating looking in this new table is required to > find any shared row locks. >
2004-08-24Various minor improvements to the SGML documentation: fix some incorrectNeil Conway
SGML markup, add a "deprecated features" section to the 8.0 release notes, untabify release.sgml and runtime.sgml, and make some other minor improvements.
2004-08-23Rearrange pg_subtrans handling as per recent discussion. pg_subtransTom Lane
updates are no longer WAL-logged nor even fsync'd; we do not need to, since after a crash no old pg_subtrans data is needed again. We truncate pg_subtrans to RecentGlobalXmin at each checkpoint. slru.c's API is refactored a little bit to separate out the necessary decisions.
2004-08-23Mention removal of page images in PITR files:Bruce Momjian
< partial page writes during recovery. > partial page writes during recovery. These pages can also be > eliminated from point-in-time archive files.
2004-08-23Update that 8.0 will support MS Win natively.Bruce Momjian
2004-08-23Update newest version number.Bruce Momjian
2004-08-22Tweak code so that pg_subtrans is never consulted for XIDs older thanTom Lane
RecentXmin (== MyProc->xmin). This ensures that it will be safe to truncate pg_subtrans at RecentGlobalXmin, which should largely eliminate any fear of bloat. Along the way, eliminate SubTransXidsHaveCommonAncestor, which isn't really needed and could not give a trustworthy result anyway under the lookback restriction. In an unrelated but nearby change, #ifdef out GetUndoRecPtr, which has been dead code since 2001 and seems unlikely to ever be resurrected.
2004-08-22Code review for ALTER INDEX patch.Tom Lane
2004-08-21Fix tab completion for ALTER INDEX.Bruce Momjian
2004-08-21Seems it would be nice if the ALTER INDEX ref page were actuallyTom Lane
linked into the docs ...
2004-08-21Fix typo (extraneous comma).Tom Lane
2004-08-21Mention that to_char(interval) will be removed in 8.1.Bruce Momjian
2004-08-21Remove Solaris bug mention in pg_hba.conf.Bruce Momjian
2004-08-21Fix pg_ctl -w to properly wait on server startup.Bruce Momjian