aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* Add ALSO keyword to CREATE RULE.Bruce Momjian2004-03-09
| | | | Fabien COELHO
* Make a separate win32 debug DLL along with the non-debug version:Bruce Momjian2004-03-09
| | | | | | | | | | | | | | | | | | | 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
* The win32 port backend will require the functionality provided byBruce Momjian2004-03-09
| | | | | | canonicalize_path. Patch moves it from initdb.c to port/path.c. Claudio Natoli
* Add:Bruce Momjian2004-03-09
| | | | | | | | | | | | | #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
* Add comment about why ON COMMENT in non-current database throws just anBruce Momjian2004-03-08
| | | | warning.
* Test for whether a previous IN join restricts the current join was tooTom Lane2004-03-08
| | | | | strict, per discussion with Dennis Haney. Also, rearrange the preceding tests to avoid redundancy.
* When testing usability of a partial index, recognize that an indexTom Lane2004-03-07
| | | | | | | 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.
* Per a brief conversation with Tom, I've created a patch for addingBruce Momjian2004-03-05
| | | | | | | | | 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
* libpq's query to get the OIDs of large-object support functions was notTom Lane2004-03-05
| | | | | schema-safe. Make it so, and improve the internal support for knowledge of server version.
* Win32:Bruce Momjian2004-03-05
| | | | | | | | | | | | | * 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
* Add new SPI functions for use by PL/Java:Bruce Momjian2004-03-05
| | | | | | | | +extern Oid SPI_getargtypeid(void *plan, int argIndex); +extern int SPI_getargcount(void *plan); +extern bool SPI_is_cursor_plan(void *plan); Thomas Hallgren
* Fix log_executor_stats for non-multi queries. Backpatch to 7.4.X.Bruce Momjian2004-03-05
|
* Emit a warning when an empty string is input to the oid, float4, andNeil Conway2004-03-04
| | | | | | | | 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.
* - Fixed segfault due to missing check for variable declaration.Michael Meskes2004-03-04
| | | | - Added check for multidimensional array usage.
* Modify pg_dump so that the preferred dump order is by name withinTom Lane2004-03-03
| | | | | | | | | 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.
* Adds the -W flag to the pwd call under Win32. This allows directories,Bruce Momjian2004-03-03
| | | | | | | | | | | 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
* Remove useless rebuilding of subPlan list during ExecInitNode. Wouldn'tTom Lane2004-03-02
| | | | | have been there to start with, except for overly enthusiastic copy-and- paste ...
* Update obsolete comment.Tom Lane2004-03-02
|
* Always schema-qualify the name of a function referenced in CREATE CAST.Tom Lane2004-03-02
| | | | | The former coding failed if the cast function was not in the pg_catalog schema. How'd this escape detection?
* Junkfilter logic to force a projection step during SELECT INTO was tooTom Lane2004-03-02
| | | | | simplistic; it recognized SELECT * FROM but not SELECT * FROM LIMIT. Per bug report from Jeff Bohmer.
* Fix sizeof(Oid) in PGSTAT_NUM_TABPURGE. (Actually done in previous commit.)Bruce Momjian2004-03-02
|
* Add missing checks for Borland C compiler.Bruce Momjian2004-03-02
| | | | L J Bayuk
* Teach is_distinct_query to recognize that GROUP BY forces a subquery'sTom Lane2004-03-02
| | | | | output to be distinct, if all the GROUP BY columns appear in the output. Per suggestion from Dennis Haney.
* Add missing sprompt.obj psql usage for Borland compiler, per privateBruce Momjian2004-03-02
| | | | | | report from krizsan. Backpatch to 7.4.X.
* Added partly missing VOLATILE keyword.Michael Meskes2004-03-02
|
* make_sort_from_pathkeys()'s method for choosing which of severalTom Lane2004-02-29
| | | | | | | | | | 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.
* "Corrects" the int8/float4/float8 tests under win32.Bruce Momjian2004-02-29
| | | | Claudio Natoli
* Remove unneeded indxqual field in IndexScanState, and the useless workTom Lane2004-02-28
| | | | spent initializing it during indexscan startup.
* Translation updatesDennis Bjorklund2004-02-28
|
* Translation updateDennis Bjorklund2004-02-28
|
* Translation updatesDennis Bjorklund2004-02-28
|
* Translation updatesDennis Bjorklund2004-02-28
|
* Adjust remove_redundant_join_clauses() so that when it has a choiceTom Lane2004-02-27
| | | | | | | 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.
* genericcostestimate() neglected to include qual startup cost inTom Lane2004-02-27
| | | | | 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.
* process_implied_equality must copy the substructure of the clauses itTom Lane2004-02-27
| | | | | is generating, to avoid problems when subselects are involved. Per report from Damon Hart.
* Fix a few omissions in the initcap() documentation & source codeNeil Conway2004-02-27
| | | | | | | 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.
* For immediate application to HEAD.Bruce Momjian2004-02-26
| | | | | | Corrects bit-rot of recently applied patch. win32/cygwin only. Claudio Natoli
* For application to HEAD, following community review.Bruce Momjian2004-02-25
| | | | | | | | | | | | | | * 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
* Teach plpgsql's lexer about dollar-quoted literals.Tom Lane2004-02-25
| | | | Andrew Dunstan, some help from Tom Lane.
* anyarray really needs to be declared with typalign = 'd', so that entriesTom Lane2004-02-24
| | | | | 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.
* Add %option nodefault to all our flex lexers. Fix a couple of rule gapsTom Lane2004-02-24
| | | | | | 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.
* Implement dollar-quoting in the backend lexer and psql. DocumentationTom Lane2004-02-24
| | | | | | | 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.
* - Corrected error handling in PGTYPEStimestamp_from_asc.Michael Meskes2004-02-24
| | | | - Set pgtypeslib version to 1.2.
* Cause pg_dump to emit a 'SET client_encoding' command at the start ofTom Lane2004-02-24
| | | | | | | | 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.
* Don't crash when a rowtype argument to a plpgsql function is NULL.Tom Lane2004-02-24
| | | | Per report from Chris Campbell.
* Fix obsolete comment.Tom Lane2004-02-23
|
* Replace opendir/closedir calls throughout the backend with AllocateDirTom Lane2004-02-23
| | | | | | | | | | 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.
* NOFILE isn't used anywhere any more.Tom Lane2004-02-23
|
* Do a direct probe during postmaster startup to determine the maximumTom Lane2004-02-23
| | | | | | 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.
* Fixed incorrect output of indicator structs using the name of the data struct.Michael Meskes2004-02-23
|