summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2004-03-12Translation updatesDennis Bjorklund
2004-03-12Translation updatesDennis Bjorklund
2004-03-12Rename incorrect references to nonblock.c to noblock.c. Claudio.Bruce Momjian
2004-03-12Allow 'Infinity' and '-Infinity' as input to the float4 and float8Neil Conway
types. Update the regression tests and the documentation to reflect this. Remove the UNSAFE_FLOATS #ifdef. This is only half the story: we still unconditionally reject floating point operations that result in +/- infinity. See recent thread on -hackers for more information.
2004-03-11Translation updatesDennis Bjorklund
2004-03-11Revise int2/int4/int8/float4/float8 input routines to allow forNeil Conway
any amount of leading or trailing whitespace (where "whitespace" is defined by isspace()). This is for SQL conformance, as well as consistency with other numeric types (e.g. oid, numeric). Also refactor pg_atoi() to avoid looking at errno where not necessary, and add a bunch of regression tests for the input to these types.
2004-03-11Add NOWAIT option to LOCK commandTatsuo Ishii
2004-03-10Move non-blocking code into its own /port file, for code clarity.Bruce Momjian
2004-03-09Build scanner output when making a distribution.Peter Eisentraut
2004-03-09Corrects a typo, introduces missing variables, and rearranges theBruce Momjian
initialization of stats process under EXEC_BACKEND. [A cleaner, rationalized approach to stat/backend/SSDataBase child processes under EXEC_BACKEND is on my TODO list. However this patch takes care of immediate concerns (ie. stats test now passes under win32)] Claudio Natoli
2004-03-09Determines the PKGLIBDIR equivalent under win32. Requires pgsql lib andBruce Momjian
bin directories to be packaged under the same root directory (eg. <some path>/pgsql/bin and <some path>/pgsql/lib) for the win32 port, which does not appear to be an onerous restriction. Claudio Natoli
2004-03-09Add ALSO keyword to CREATE RULE.Bruce Momjian
Fabien COELHO
2004-03-09Make a separate win32 debug DLL along with the non-debug version:Bruce Momjian
Currently, src/interfaces/libpq/win32.mak builds a statically-linked library "libpq.lib", a debug dll "libpq.dll", import library for the debug dll "libpqdll.lib", a release dll "libpq.dll", import library for the release dll "libpqdll.lib". To avoid naming clashes, I would make the debug dll and import libraries "libpqd.dll" and "libpqddll.lib". Basically, the debug build uses the cl flags: "/MDd /D _DEBUG", and the release build uses the cl flags "/MD /D NDEBUG". Usually the debug build has a "D" suffix on the file name, so for example: libpqd.dll libpq, debug build libpqd.lib libpq, debug build, import library libpq.dll libpq, release build libpq.lib libpq, release build, import library David Turner
2004-03-09The win32 port backend will require the functionality provided byBruce Momjian
canonicalize_path. Patch moves it from initdb.c to port/path.c. Claudio Natoli
2004-03-09Add:Bruce Momjian
#log_line_prefix = '' # e.g. '<%u%%%d> ' # %u=user name %d=database name # %r=remote host and port # %p=PID %t=timestamp %i=command tag # %c=session id %l=session line number # %s=session start timestamp # %x=stop here in non-session processes # %%='%' Andrew Dunstan
2004-03-08Add comment about why ON COMMENT in non-current database throws just anBruce Momjian
warning.
2004-03-08Test for whether a previous IN join restricts the current join was tooTom Lane
strict, per discussion with Dennis Haney. Also, rearrange the preceding tests to avoid redundancy.
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.