summaryrefslogtreecommitdiff
path: root/src/backend
Commit message (Collapse)AuthorAgeFilesLines
* Make selectivity routines cope gracefully with NaNs, infinities, andTom Lane2001-10-132-8/+51
| | | | | NUMERIC values that are out of the range of 'double'. Per trouble report from Mike Quinn.
* path_inter, path_distance, path_length, dist_ppath now do the rightTom Lane2001-10-131-22/+94
| | | | | things with closed paths --- ie, include the closing line segment in their calculations. Per bug report from Curtis Barrett 9-Oct-01.
* Mention createlang when language not installed, per problem report.Bruce Momjian2001-10-131-3/+4
|
* Add a new function "pg_client_encoding" which returns the current clientTatsuo Ishii2001-10-122-2/+15
| | | | | | side encoding name. This is necessary for client API's such as JDBC to perform correct encoding conversions. See my email "[HACKERS] pg_client_encoding" 10 Sep 2001.
* Break transformCreateStmt() into multiple routines and makeTom Lane2001-10-124-1139/+1087
| | | | | | | | | transformAlterStmt() use these routines, instead of having lots of duplicate (not to mention should-have-been-duplicate) code. Adding a column with a CHECK constraint actually works now, and the tests to reject unsupported DEFAULT and NOT NULL clauses actually fire now. ALTER TABLE ADD PRIMARY KEY works, modulo having to have created the column(s) NOT NULL already.
* Suppress gcc warnings.Tom Lane2001-10-111-3/+3
|
* Add support for ISO-8859-6 to 16Tatsuo Ishii2001-10-1122-21/+2284
|
* Remove gratuitous discrepancy between extract() and date_part(),Peter Eisentraut2001-10-103-14/+8
| | | | | regarding timezone_hour, timezone_minute vs. tz_hour, tz_minute. Document the former.
* Allow optional () after current_user, session_user, user, current_time,Peter Eisentraut2001-10-091-7/+10
| | | | | | | | | current_timestamp, current_date for ODBC compatibility. Add more functions to odbc.sql catalog extension, use new CREATE OR REPLACE FUNCTION. Document iODBC/unixODBC build options.
* Fix typo in error message. Noted by laser@zhengmai.com.cn.Tom Lane2001-10-091-2/+2
|
* Change plpgsql to depend on main parser's type-declaration grammar,Tom Lane2001-10-091-1/+74
| | | | | | | rather than having its own somewhat half-baked notion of what a type declaration looks like. This is necessary now to ensure that plpgsql will think a 'timestamp' variable has the same semantics as 'timestamp' does in the main SQL grammar; and it should avoid divergences in future.
* Another go-round with FigureColname, to produce less surprising resultsTom Lane2001-10-081-22/+45
| | | | | | for nested typecasts. It now produces a column header of 'timestamptz' for 'SELECT CURRENT_TIMESTAMP', rather than 'text' as it was doing for awhile there.
* Fix transformExpr() to not scribble on its input datastructure whileTom Lane2001-10-081-49/+57
| | | | | transforming CASE expressions. This was definitely confusing FigureColname, and might lead to bad things elsewhere as well.
* Fix ruleutils to depend on format_type, rather than having a privateTom Lane2001-10-082-37/+102
| | | | | copy of code that knows about displaying types with typmod info. Needed so that it does the right thing with timestamp datatypes now.
* Make ALTER TABLE RENAME COLUMN update column names of indexes thatTom Lane2001-10-081-5/+64
| | | | refer to the renamed column. Brent Verner, with a little help from tgl.
* Remove redundant code, update comments, cause CURRENT_TIME toTom Lane2001-10-081-10/+5
| | | | agree with CURRENT_TIME(n).
* Rearrange fmgr.c and relcache so that it's possible to keep FmgrInfoTom Lane2001-10-0621-327/+358
| | | | | | | | | lookup info in the relcache for index access method support functions. This makes a huge difference for dynamically loaded support functions, and should save a few cycles even for built-in ones. Also tweak dfmgr.c so that load_external_function is called only once, not twice, when doing fmgr_info for a dynamically loaded function. All per performance gripe from Teodor Sigaev, 5-Oct-01.
* files attached are Traditional Chinese translations translatedBruce Momjian2001-10-051-0/+327
| | | | | | | and modified from Simplified Chinese translations for backend, pgsql, pg_dump and libpq. I've appended their names to zh_TW.po. forth
* Further cleanup of dynahash.c API, in pursuit of portability andTom Lane2001-10-0516-530/+350
| | | | | | | | | readability. Bizarre '(long *) TRUE' return convention is gone, in favor of just raising an error internally in dynahash.c when we detect hashtable corruption. HashTableWalk is gone, in favor of using hash_seq_search directly, since it had no hope of working with non-LONGALIGNable datatypes. Simplify some other code that was made undesirably grotty by promixity to HashTableWalk.
* > > I am quite sure that all AIX Versions accept the CLOBBER method,Bruce Momjian2001-10-051-3/+3
| | | | | | > > thus I ask you to apply the following patch, to make it work. Zeugswetter Andreas SB SD
* Define CEST as a synonym for Central European Savings TimeThomas G. Lockhart2001-10-052-17/+10
| | | | | per Jan Varga <varga@utcru.sk> Fix up spacing and formatting.
* Implement explicit date/time precision per SQL99 spec.Thomas G. Lockhart2001-10-051-44/+45
| | | | Use CAST() mechanism to define CURRENT_TIME and CURRENT_TIMESTAMP.
* Consider interpreting a function call as a trivial (binary-compatible)Tom Lane2001-10-042-69/+94
| | | | | | | | | type coercion after failing to find an exact match in pg_proc, but before considering interpretations that involve a function call with one or more argument type coercions. This avoids surprises wherein what looks like a type coercion is interpreted as coercing to some third type and then to the destination type, as in Dave Blasby's bug report of 3-Oct-01. See subsequent discussion in pghackers.
* Ooops, I was a little too enthusiastic about suppressing defaultTom Lane2001-10-041-10/+16
| | | | | index opclasses; they might be default for some other datatype, in which case we mustn't suppress 'em.
* Plug memory leaks introduced by dynamic-search-path changes.Tom Lane2001-10-041-29/+47
| | | | From Teodor Sigaev.
* Make the world safe for atttypmod=0 ... this didn't use to mean anything,Tom Lane2001-10-042-9/+8
| | | | but timestamp now wants it to mean something.
* Make current_time deliver a fractional-second answer.Tom Lane2001-10-041-1/+5
|
* I've just finished the Chinese NLS support(zh_CN part) filesBruce Momjian2001-10-041-0/+327
| | | | | | | | | translation, the attachement is those four files. (.tar.gz file, with the directory, root is $PGSRC). Tested on some Linux platform. Weiping He
* Attached please find an initiation of theBruce Momjian2001-10-042-1/+11970
| | | | | | | | | | | | | | | | | NLS effort for the 'postgresql' component. It includes 'ru.po', which should be added to /src/backend/po/ and a typical patch for nls.mk with the 'ru' entry added in the AVAIL_LANGUAGES. I'll submit a patch with more translations for pg_dump once CVSweb becomes available. CVSweb for me right now is the only way to get to the source code until my system is completely setup by the end of the week. -- Serguei A. Mokhov
* AdjustTimeForTypmod has the same bug ...Tom Lane2001-10-041-4/+6
|
* Fix some problems in new variable-resolution-timestamp code.Tom Lane2001-10-042-11/+22
|
* Add dependency for regexec.cTatsuo Ishii2001-10-041-1/+3
|
* Add dependency for like.cTatsuo Ishii2001-10-041-1/+3
|
* Optimization for single byte encodings.Tatsuo Ishii2001-10-042-314/+433
|
* Consistently use gcc's __attribute__((format)) to check sprintf-styleTom Lane2001-10-031-7/+3
| | | | | format strings wherever possible. Remarkably, this exercise didn't turn up any inconsistencies, but it seems a good idea for the future.
* DROP AGGREGATE and COMMENT ON AGGREGATE now accept the expected syntaxTom Lane2001-10-034-75/+60
| | | | | | | 'aggname (aggtype)'. The old syntax 'aggname aggtype' is still accepted for backwards compatibility. Fix pg_dump, which was actually broken for most cases of user-defined aggregates. Clean up error messages associated with these commands.
* Teach format_type about time/timestamp precision, so that pg_dump andTom Lane2001-10-031-4/+24
| | | | psql's \d option work properly.
* Add missing TIMESTAMPTZ case.Tom Lane2001-10-031-1/+4
|
* AdjustTimestampForTypmod does not work (at least not portably) onTom Lane2001-10-031-10/+6
| | | | | | -infinity and +infinity. Put TIMESTAMP_NOT_FINITE guard into the routine, instead of forgetting it at some call sites. Fixes regression test failures here.
* Implement precision support for timestamp and time, both with and withoutThomas G. Lockhart2001-10-038-314/+363
| | | | | | | | | | | | time zones. SQL99 spec requires a default of zero (round to seconds) which is set in gram.y as typmod is set in the parse tree. We *could* change to a default of either 6 (for internal compatibility with previous versions) or 2 (for external compatibility with previous versions). Evaluate entries in pg_proc wrt the iscachable attribute for timestamp and other date/time types. Try to recognize cases where side effects like the current time zone setting may have an effect on results to decide whether something is cachable or not.
* Add CREATE OR REPLACE FUNCTION syntax to allow replacing a functionTom Lane2001-10-027-41/+80
| | | | | definition without changing the function's OID, thereby not breaking rules, views, triggers, etc that depend on it. From Gavin Sherry.
* Revise shmget() and semget() failure messages to mention the possibilityTom Lane2001-10-011-19/+46
| | | | of coping by reducing shared_buffers/max_connections settings.
* Extend pg_get_indexdef() to know about index predicates. Also, tweakTom Lane2001-10-011-104/+84
| | | | | | | | it to suppress index opclass output for opclasses that are the default for their datatype; only non-default opclasses are shown explicitly. This is expected to improve portability of the CREATE INDEX command across future versions of Postgres --- we've changed index opclasses too often in the past to think we won't do so again.
* Make inclusion logic for sys/sem.h and sys/ipc.h consistent across allTom Lane2001-10-013-22/+17
| | | | the files that need them. Per trouble report from Teodor.
* Add sys/types.h for FreeBSD compile.Bruce Momjian2001-10-011-1/+2
| | | | Teodor Sigaev
* Clean up a little more carefully around fork of pgstat subprocess.Tom Lane2001-10-011-1/+26
| | | | | | Partial support for BEOS (not sure whether second fork of grandchild process needs these extra calls or not; someone who has BEOS will need to test it).
* Another round of cleanups for dynahash.c (maybe it's finally clean ofTom Lane2001-10-0113-623/+464
| | | | | | | | | portability issues). Caller-visible data structures are now allocated on MAXALIGN boundaries, allowing safe use of datatypes wider than 'long'. Rejigger hash_create API so that caller specifies size of key and total size of entry, not size of key and size of rest of entry. This simplifies life considerably since each number is just a sizeof(), and padding issues etc. are taken care of automatically.
* Suppress timestamp_ops for backwards compatibility with 7.1 pg_dump.Tom Lane2001-10-011-2/+7
|
* Remove C++ style comment. Some compilers won't accept it.Tatsuo Ishii2001-10-011-2/+4
|
* Clean up encode/decode functions a little bit.Tom Lane2001-09-301-26/+22
|
View Lorry Controller Status