aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* > After all that about numbering centuries and millenia correctly,Bruce Momjian2004-08-20
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | > why does CVS tip still give me > > regression=# select extract(century from now()); > date_part > ----------- > 20 > (1 row) > [ ... looks in code ... ] > > Apparently it's because you fixed only timestamp_part, and not > timestamptz_part. I'm not too sure about what timestamp_trunc or > timestamptz_trunc should do, but they may be wrong as well. Sigh... as usual, what is not tested does not work:-( > Could we have a more complete patch? Please find a submission attached. I hope it really fixes all decade, century and millenium issues for extract and *_trunc functions on interval and other timestamp types. If someone could check that the results are reasonnable, it would be great. I indeed overlooked the fact that there were two functions. The patch fixes the code so that both variants agree. I added comments to interval extractions, because it relies on the C division to have a negative remainder: -7/10 = 0 and remains -7. As for *_trunc functions, I have chosen to put the first year of the century or millennium: -100, 1, 101... 1001 2001 etc. Indeed, I don't think it would make sense to put 2000 (last year of the 2nd millennium) for rounding all years of the third millenium. I also fixed the code so that all decades last 10 years and decade 199 means the 1990's. I have added some tests that are relevant to deal with tricky cases. The formula may be simplified, but all these cases must pass. Please keep them. Fabien Coelho
* Repair some issues with column aliases and RowExpr construction in theTom Lane2004-08-19
| | | | | | | | | | | | presence of dropped columns. Document the already-presumed fact that eref aliases in relation RTEs are supposed to have entries for dropped columns; cause the user alias structs to have such entries too, so that there's always a one-to-one mapping to the underlying physical attnums. Adjust expandRTE() and related code to handle the case where a column that is part of a JOIN has been dropped. Generalize expandRTE()'s API so that it can be used in a couple of places that formerly rolled their own implementation of the same logic. Fix ruleutils.c to suppress display of aliases for columns that were dropped since the rule was made.
* Don't use get_home_path so libpq doesn't pull path.c into the library.Bruce Momjian2004-08-19
|
* Clean up some random departures from project's standard declaration style.Tom Lane2004-08-18
|
* Add get_home_path() to use USERPROFILE on Win32 and HOME on Unix.Bruce Momjian2004-08-18
|
* Fix bug introduced into _bt_getstackbuf() on 2003-Feb-21: the initialTom Lane2004-08-17
| | | | | | | | | | value of 'start' could be past the end of the page, if the page was split by some concurrent inserting process since we visited it. In this situation the code could look at bogus entries and possibly find a match (since after all those entries still contain what they had before the split). This would lead to 'specified item offset is too large' followed by 'PANIC: failed to add item to the page', as reported by Joe Conway for scenarios involving heavy concurrent insertion activity.
* Standardize on the assumption that the arguments of a RowExpr correspondTom Lane2004-08-17
| | | | | | | to the physical layout of the rowtype, ie, there are dummy arguments corresponding to any dropped columns in the rowtype. We formerly had a couple of places that did it this way and several others that did not. Fixes Gaetano Mendola's "cache lookup failed for type 0" bug of 5-Aug.
* Chain on to SIGPIPE handler rather than just do action on default.Bruce Momjian2004-08-17
| | | | Always create thread-specific variable.
* Add comment about portability function name inconsistency.Bruce Momjian2004-08-17
|
* Fix linking problem when enabling thread safety on Darwin: uninitializedTom Lane2004-08-17
| | | | | | | global variables are problematic on this platform. Simplest solution seems to be to initialize pthread key variable to 0. Also, rename this variable and check_sigpipe_handler to something involving "pq" to avoid gratuitous pollution of application namespace.
* Add DLLIMPORT for PostGIS.Bruce Momjian2004-08-17
|
* Move io.h include higher in the file so it doesn't conflict withBruce Momjian2004-08-17
| | | | | | rename/unlink defined later. Problem exists on MS VC. Andrew Francis
* Add trivial NULL statement to plpgsql, for Oracle compatibility.Tom Lane2004-08-16
|
* Throw error if initdb -L is not an absolute path.Bruce Momjian2004-08-16
|
* Fix for adding \n for zero-length win32 read_pipe returnBruce Momjian2004-08-16
|
* Mark server_encoding and integer_datetimes as GUC_REPORT, per previousTom Lane2004-08-16
| | | | proposals by Oliver Jowett. Update documentation.
* Clarify need for \r\n -> \n translation in version checking code.Bruce Momjian2004-08-16
|
* Dept. of further reflection: I looked around to see if any other callersTom Lane2004-08-15
| | | | | | | | | | | | of XLogInsert had the same sort of checkpoint interlock problem as RecordTransactionCommit, and indeed I found some. Btree index build and ALTER TABLE SET TABLESPACE write data outside the friendly confines of the buffer manager, and therefore they have to take their own responsibility for checkpoint interlock. The easiest solution seems to be to force smgrimmedsync at the end of the index build or table copy, even when the operation is being WAL-logged. This is sufficient since the new index or table will be of interest to no one if we don't get as far as committing the current transaction.
* Xmin calculations should consider only top transaction IDs, andTom Lane2004-08-15
| | | | | | therefore starting with GetCurrentTransactionId is wrong. Fixes miscomputation of RecentGlobalXmin leading to bizarre behavior reported by Gavin Sherry.
* Specify SA_NOCLDSTOP when enabling SIGCHLD, per suggestion fromTom Lane2004-08-15
| | | | Oliver Jowett.
* Quote PERL expansion for Win32 path that might have spaces.Bruce Momjian2004-08-15
|
* Translation updatesPeter Eisentraut2004-08-14
|
* Fix psql's COPY support to deal with \r\n line endings.Tom Lane2004-08-13
| | | | Andrew Dunstan, some further hacking by Tom Lane.
* Fix breakage with PUBLIC schema. Try to untwist the remarkably contortedTom Lane2004-08-13
| | | | logic a little bit.
* Give a more specific error message for "you can't do that" error casesTom Lane2004-08-13
| | | | in plpgsql, particularly trying to begin/end/rollback a transaction.
* New translationsPeter Eisentraut2004-08-13
|
* Translation updatePeter Eisentraut2004-08-13
|
* Translation updatesPeter Eisentraut2004-08-13
|
* Fix core dumps, inability to count, etc associated with canonicalize_pathTom Lane2004-08-13
| | | | patches.
* Change order of operations in ALTER TABLE SET TABLESPACE so that weTom Lane2004-08-13
| | | | | | don't hold an open file reference to the original table at the end. This is a good thing in any case, particularly so on Windows which cannot drop the table file otherwise.
* Allow commas in BEGIN, START TRANSACTION, and SET TRANSACTION, as requiredTom Lane2004-08-12
| | | | | | by the SQL standard. For backwards compatibility, however, continue to accept the syntax without. Minor editorialization in the reference pages for these commands, too.
* Allow optional SAVEPOINT keyword in RELEASE and ROLLBACK TO, for greaterTom Lane2004-08-12
| | | | | | compliance with SQL2003 spec syntax. Oliver Jowett
* Cleanup Win32 COPY handling, and move archive examples to SGML.Bruce Momjian2004-08-12
|
* Add mention of "WIN32" COPY.Bruce Momjian2004-08-12
|
* Add make_native_path() because Win32 COPY is an internal CMD.EXE commandBruce Momjian2004-08-12
| | | | | | | | | | and doesn't process forward slashes in the same way as external commands. Quoting the first argument to COPY does not convert forward to backward slashes, but COPY does properly process quoted forward slashes in the second argument. Win32 COPY works with quoted forward slashes in the first argument only if the current directory is the same as the directory of the first argument.
* Cause initdb to actually accept -s as intended, and fix some typos inTom Lane2004-08-11
| | | | | | a comment. Jon Jensen
* Fix broken parsing of CREATE TABLE AS (looks like a mis-sync with mainTom Lane2004-08-11
| | | | parser).
* Avoid crashing when restoring a saved GUC session_authorization valueTom Lane2004-08-11
| | | | that refers to a now-deleted userid. Per gripe from Chris Ochs.
* Add PQserverVersion() to libpq to provide more-convenient access toTom Lane2004-08-11
| | | | | | | the server version number. This commit also removes bogus DOS line endings from libpqddll.def. Greg Sabino Mullane
* Work around broken strtod() that's present in many Solaris releases.Tom Lane2004-08-11
| | | | Thanks to Michael Fuhr for identifying the problem.
* Fix function definition that somehow missed being ANSI-fied, and alignTom Lane2004-08-11
| | | | | | it with previous prototype to suppress complaints from picky compilers, per report from Scott Bailey. Also, remove substitute strerror definition --- not needed, since we link this with libpgport.
* Allow compilation when CODESET is not defined (OpenBSD).Peter Eisentraut2004-08-11
|
* Translation updatePeter Eisentraut2004-08-11
|
* Add translation from 7.4 branch to head.Peter Eisentraut2004-08-11
|
* Fix failure to guarantee that a checkpoint will write out pg_clog updatesTom Lane2004-08-11
| | | | | | for transaction commits that occurred just before the checkpoint. This is an EXTREMELY serious bug --- kudos to Satoshi Okada for creating a reproducible test case to prove its existence.
* Set DYLD_LIBRARY_PATH so that 'make check' works without priorTom Lane2004-08-10
| | | | 'make install' on OS X. Per suggestion from Adam Witney.
* New translationPeter Eisentraut2004-08-10
|
* Translation updatesPeter Eisentraut2004-08-10
|
* Translation updatePeter Eisentraut2004-08-10
|
* Translation updatesPeter Eisentraut2004-08-10
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 12:50:42 +0000