summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2004-03-07When testing usability of a partial index, recognize that an indexTom Lane
predicate of the form 'foo IS NOT NULL' is implied by a WHERE clause that uses 'foo' in any strict operator or function. Per suggestion and preliminary implementation by John Siracusa; some further hacking by moi.
2004-03-05Per a brief conversation with Tom, I've created a patch for addingBruce Momjian
support for 'week' within the date_trunc function. Within the patch I added a couple of test cases and associated target output, and changed the documentation to add 'week' appropriately. Robert Creager
2004-03-05libpq's query to get the OIDs of large-object support functions was notTom Lane
schema-safe. Make it so, and improve the internal support for knowledge of server version.
2004-03-05Win32:Bruce Momjian
* Mostly, casting etc to remove compilation warnings in win32 only code. * main.c: set _IONBF to stdout/stderr under win32 (under win32, _IOLBF defaults to full buffering) * pg_resetxlog/Makefile: ensures dirmod.o gets cleaned (got bitten by this when, after "make clean"ing, switching compilation between Ming + Cygwin) Claudio Natoli
2004-03-05Add new SPI functions for use by PL/Java:Bruce Momjian
+extern Oid SPI_getargtypeid(void *plan, int argIndex); +extern int SPI_getargcount(void *plan); +extern bool SPI_is_cursor_plan(void *plan); Thomas Hallgren
2004-03-05Fix log_executor_stats for non-multi queries. Backpatch to 7.4.X.Bruce Momjian
2004-03-04Emit a warning when an empty string is input to the oid, float4, andNeil Conway
float8 types. This begins the deprecation of this feature: in 7.6, this input will be rejected. Also added a new error code for warnings about deprecated features, and updated the regression tests.
2004-03-04- Fixed segfault due to missing check for variable declaration.Michael Meskes
- Added check for multidimensional array usage.
2004-03-03Modify pg_dump so that the preferred dump order is by name withinTom Lane
object types, rather than by OID. This should help ensure consistent dump output from databases that are logically the same but have different histories, per recent discussion about 'diffing' databases. The patch is bulky because of renaming of fields, but not very complicated. Also, do some tweaking to cause BLOB restoration to be done in a better order, and clean up pg_restore's textual output to exactly match pg_dump.
2004-03-03Adds the -W flag to the pwd call under Win32. This allows directories,Bruce Momjian
which are munged by sed, such as: /e/cygwin/opt/diff9c/pgsql/src/test/regress/data/agg.data to be correctly passed as: e:/cygwin/opt/diff9c/pgsql/src/test/regress/data/agg.data FWIW, "fixes" a large (> 20) tests under Win32. Claudio Natoli
2004-03-02Remove useless rebuilding of subPlan list during ExecInitNode. Wouldn'tTom Lane
have been there to start with, except for overly enthusiastic copy-and- paste ...
2004-03-02Update obsolete comment.Tom Lane
2004-03-02Always schema-qualify the name of a function referenced in CREATE CAST.Tom Lane
The former coding failed if the cast function was not in the pg_catalog schema. How'd this escape detection?
2004-03-02Junkfilter logic to force a projection step during SELECT INTO was tooTom Lane
simplistic; it recognized SELECT * FROM but not SELECT * FROM LIMIT. Per bug report from Jeff Bohmer.
2004-03-02Fix sizeof(Oid) in PGSTAT_NUM_TABPURGE. (Actually done in previous commit.)Bruce Momjian
2004-03-02Add missing checks for Borland C compiler.Bruce Momjian
L J Bayuk
2004-03-02Teach is_distinct_query to recognize that GROUP BY forces a subquery'sTom Lane
output to be distinct, if all the GROUP BY columns appear in the output. Per suggestion from Dennis Haney.
2004-03-02Add missing sprompt.obj psql usage for Borland compiler, per privateBruce Momjian
report from krizsan. Backpatch to 7.4.X.
2004-03-02Added partly missing VOLATILE keyword.Michael Meskes
2004-02-29make_sort_from_pathkeys()'s method for choosing which of severalTom Lane
equivalent sort expressions to use was broken: you can't just look at the relation membership, you have to actually grovel over the individual Vars in each expression. I think this did work when it was written, but it was broken by subsequent optimizations that made join relations not propagate every single input variable upward. Must find the Var that got propagated, not choose one at random. Per bug report from Daniel O'Neill.
2004-02-29"Corrects" the int8/float4/float8 tests under win32.Bruce Momjian
Claudio Natoli
2004-02-28Remove unneeded indxqual field in IndexScanState, and the useless workTom Lane
spent initializing it during indexscan startup.
2004-02-28Translation updatesDennis Bjorklund
2004-02-28Translation updateDennis Bjorklund
2004-02-28Translation updatesDennis Bjorklund
2004-02-28Translation updatesDennis Bjorklund
2004-02-27Adjust remove_redundant_join_clauses() so that when it has a choiceTom Lane
of which redundant clause to remove, it removes the more expensive one. In simple scenarios the clauses will be like 'var = var' and there's no difference, but we are now capable of considering cases where there are sub-selects in the clauses, and it makes a BIG difference.
2004-02-27genericcostestimate() neglected to include qual startup cost inTom Lane
indexTotalCost. I think this may not make any real difference in 7.4, but it definitely is a problem with CVS tip's new equation.
2004-02-27process_implied_equality must copy the substructure of the clauses itTom Lane
is generating, to avoid problems when subselects are involved. Per report from Damon Hart.
2004-02-27Fix a few omissions in the initcap() documentation & source codeNeil Conway
comments, make some unrelated improvements to the functions documentation, and perform some minor consistency cleanup elsewhere. Original initcap() change from Dennis B., additional changes by Neil C.
2004-02-26For immediate application to HEAD.Bruce Momjian
Corrects bit-rot of recently applied patch. win32/cygwin only. Claudio Natoli
2004-02-25For application to HEAD, following community review.Bruce Momjian
* Changes incorrect CYGWIN defines to __CYGWIN__ * Some localtime returns NULL checks (when unchecked cause SEGVs under Win32 regression tests) * Rationalized CreateSharedMemoryAndSemaphores and AttachSharedMemoryAndSemaphores (Bruce, I finally remembered to do it); requires attention. Claudio Natoli
2004-02-25Teach plpgsql's lexer about dollar-quoted literals.Tom Lane
Andrew Dunstan, some help from Tom Lane.
2004-02-24anyarray really needs to be declared with typalign = 'd', so that entriesTom Lane
in pg_statistic are correctly aligned if they contain values that require double alignment. Too bad we cannot force initdb for this in 7.4 branch.
2004-02-24Add %option nodefault to all our flex lexers. Fix a couple of rule gapsTom Lane
exposed thereby. AFAICT these would not lead to any worse problems than junk emitted on the backend's stdout, but we should have the option to catch possible worse errors in future.
2004-02-24Implement dollar-quoting in the backend lexer and psql. DocumentationTom Lane
is still lacking, as is support in plpgsql and other places, but this is the basic feature. Patch by Andrew Dunstan, some tweaking by Tom Lane. Also, enable %option nodefault in these two lexers, and patch some gaps revealed thereby.
2004-02-24- Corrected error handling in PGTYPEStimestamp_from_asc.Michael Meskes
- Set pgtypeslib version to 1.2.
2004-02-24Cause pg_dump to emit a 'SET client_encoding' command at the start ofTom Lane
any restore operation, thereby ensuring that dumped data is interpreted the same way it was dumped even if the target database has a different encoding. Per suggestions from Pavel Stehule and others. Also, simplify scheme for handling check_function_bodies ... we may as well just set that at the head of the script.
2004-02-24Don't crash when a rowtype argument to a plpgsql function is NULL.Tom Lane
Per report from Chris Campbell.
2004-02-23Fix obsolete comment.Tom Lane
2004-02-23Replace opendir/closedir calls throughout the backend with AllocateDirTom Lane
and FreeDir routines modeled on the existing AllocateFile/FreeFile. Like the latter, these routines will avoid failing on EMFILE/ENFILE conditions whenever possible, and will prevent leakage of directory descriptors if an elog() occurs while one is open. Also, reduce PANIC to ERROR in MoveOfflineLogs() --- this is not critical code and there is no reason to force a DB restart on failure. All per recent trouble report from Olivier Hubaut.
2004-02-23NOFILE isn't used anywhere any more.Tom Lane
2004-02-23Do a direct probe during postmaster startup to determine the maximumTom Lane
number of openable files and the number already opened. This eliminates depending on sysconf(_SC_OPEN_MAX), and allows much saner behavior on platforms where open-file slots are used up by semaphores.
2004-02-23Fixed incorrect output of indicator structs using the name of the data struct.Michael Meskes
2004-02-23Write #include <dl.h>, not #include "dl.h", to correctly reflect theTom Lane
fact that dl.h is a system header and not one of ours.
2004-02-22Move responsibility for copying argv[] array into ps_status.c, where itTom Lane
logically belongs. Arrange to update the _NSGetArgv() copy of the argv pointer on Darwin. (It seems likely that other NeXT-derived platforms also have an _NSGetArgv() problem, but until we have some reports I'll just make this #ifdef __darwin__.)
2004-02-21Fix random build breakage from log_disconnections patch.Tom Lane
2004-02-21Implement a solution to the 'Turkish locale downcases I incorrectly'Tom Lane
problem, per previous discussion. Make some additional changes to centralize the knowledge of just how identifier downcasing is done, in hopes of simplifying any future tweaking in this area.
2004-02-19Re-implement psql's input scanning to use a flex-generated lexer, as perTom Lane
recent discussion. The lexer is used for both SQL command text and backslash commands. The purpose of this change is to make it easier to track the behavior of the backend's SQL lexer --- essentially identical flex rules are now used by psql. Also, this cleans up a lot of very squirrelly code in mainloop.c and command.c. The flex code is somewhat bulkier than the removed code, but should be lots easier to maintain.
2004-02-19Cosmetic changes (mostly whitespace) to make it easier to diff theTom Lane
backend lexer against psql's.
generated by cgit v1.2.3 (git 2.46.0) at 2025-10-07 01:40:46 +0000