aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* Break transformCreateStmt() into multiple routines and makeTom Lane2001-10-12
| | | | | | | | | 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-11
|
* Tatsuo Ishii <t-ishii@sra.co.jp> writes:Bruce Momjian2001-10-11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | > As you can see, psql reconnect as any user if the password is same as > foo. Of course this is due to the careless password setting, but I > think it's better to prompt ANY TIME the user tries to switch to > another user. Comments? Yeah, I agree. Looks like a simple change in dbconnect(): /* * Use old password if no new one given (if you didn't have an old * one, fine) */ if (!pwparam && oldconn) pwparam = PQpass(oldconn); to /* * Use old password (if any) if no new one given and we are * reconnecting as same user */ if (!pwparam && oldconn && PQuser(oldconn) && userparam && strcmp(PQuser(oldconn), userparam) == 0) pwparam = PQpass(oldconn); regards, tom lane
* Add support for ISO-8859-6 to 16Tatsuo Ishii2001-10-11
|
* Remove gratuitous discrepancy between extract() and date_part(),Peter Eisentraut2001-10-10
| | | | | 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-09
| | | | | | | | | 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.
* This patch fixes a bug introduced in the jdbc bytea support patch.Barry Lind2001-10-09
| | | | | | | | | | | | | | That patch broke the ability to read data from binary cursors. --Barry Lind Modified Files: pgsql/src/interfaces/jdbc/org/postgresql/Connection.java pgsql/src/interfaces/jdbc/org/postgresql/ResultSet.java pgsql/src/interfaces/jdbc/org/postgresql/core/QueryExecutor.java pgsql/src/interfaces/jdbc/org/postgresql/jdbc1/Connection.java pgsql/src/interfaces/jdbc/org/postgresql/jdbc1/ResultSet.java pgsql/src/interfaces/jdbc/org/postgresql/jdbc2/Connection.java pgsql/src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java pgsql/src/interfaces/jdbc/org/postgresql/jdbc2/UpdateableResultSet.java
* Change plpgsql compiler so that all elogs are trapped and a suitableTom Lane2001-10-09
| | | | | | | NOTICE added about error location (same method already used by plpgsql executor). Add checking of pg_proc row xmin/cmin to ensure that plpgsql functions will be recompiled after they've been modified by CREATE OR REPLACE FUNCTION.
* Fix typo in error message. Noted by laser@zhengmai.com.cn.Tom Lane2001-10-09
|
* Change plpgsql to depend on main parser's type-declaration grammar,Tom Lane2001-10-09
| | | | | | | 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-08
| | | | | | 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-08
| | | | | 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-08
| | | | | 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-08
| | | | refer to the renamed column. Brent Verner, with a little help from tgl.
* Remove redundant code, update comments, cause CURRENT_TIME toTom Lane2001-10-08
| | | | agree with CURRENT_TIME(n).
* Fix include file so library is binary compatible again.Michael Meskes2001-10-08
|
* Rearrange fmgr.c and relcache so that it's possible to keep FmgrInfoTom Lane2001-10-06
| | | | | | | | | 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.
* While playing around with trying to add foreign keys to theBruce Momjian2001-10-06
| | | | | | | \d table display in psql, I noticed that tableinfo.triggers is not used once it is set. Greg Sabino Mullane
* Fix shared library builds for MacOS X.Peter Eisentraut2001-10-05
|
* Move psql's zh_TW.po to the right place.Peter Eisentraut2001-10-05
|
* files attached are Traditional Chinese translations translatedBruce Momjian2001-10-05
| | | | | | | and modified from Simplified Chinese translations for backend, pgsql, pg_dump and libpq. I've appended their names to zh_TW.po. forth
* Attached is the updated version of the patch, which matchesBruce Momjian2001-10-05
| | | | | | | | | | | | | | | | on words as opposed to lines, which means that all of the following work in psql: \d foo \d bar \d foo; \d bar \d foo \d bar;; \d foo; <space> This one also uses "true and false" and strips semicolons for the following backslash commands: \C \c \d \e \i \o \s \z Greg Sabino Mullane
* Make sure each call to ECPGraise is logged.Michael Meskes2001-10-05
|
* Further cleanup of dynahash.c API, in pursuit of portability andTom Lane2001-10-05
| | | | | | | | | 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-05
| | | | | | > > thus I ask you to apply the following patch, to make it work. Zeugswetter Andreas SB SD
* Fixed typo in proproc.yMichael Meskes2001-10-05
|
* Define CEST as a synonym for Central European Savings TimeThomas G. Lockhart2001-10-05
| | | | | per Jan Varga <varga@utcru.sk> Fix up spacing and formatting.
* Implement explicit date/time precision per SQL99 spec.Thomas G. Lockhart2001-10-05
| | | | Use CAST() mechanism to define CURRENT_TIME and CURRENT_TIMESTAMP.
* Don't try to hack pg_description if not superuser. (Really want aTom Lane2001-10-04
| | | | | COMMENT ON LARGE OBJECT command instead, but no time for it now.) Fix some code that would not work with OIDs > 2G.
* Consider interpreting a function call as a trivial (binary-compatible)Tom Lane2001-10-04
| | | | | | | | | 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-04
| | | | | 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-04
| | | | From Teodor Sigaev.
* Make the world safe for atttypmod=0 ... this didn't use to mean anything,Tom Lane2001-10-04
| | | | but timestamp now wants it to mean something.
* Make current_time deliver a fractional-second answer.Tom Lane2001-10-04
|
* elog command need to use unicode conversion too.Bruce Momjian2001-10-04
| | | | Vsevolod Lobko
* This patch adds reporting of tcl global variable errorInfoBruce Momjian2001-10-04
| | | | | | | | | which contains stack trace. One problem, after this patch errors will generate multiline ERROR messages. Is it acceptable or do I need split it and generate multiple singleline messages? Vsevolod Lobko
* Attached is a patch which deals withBruce Momjian2001-10-04
| | | | | | | | | | | | | | | | | | | | select 'id' as xxx from table The issue is: When the driver gets a data type which does not map into the SQL.Types it attempts to load the object into a java object. Eventually throwing an exception indicating that the type "unknown" was not found. Since the backend defaults "unknown" types to text it was suggested that the jdbc driver do the same. This patch does just that. I have tested it on the above select statement as well as a small program that serializes, and deserializes a class Dave Cramer
* Using strtol() on int8 values (input parameters or result sets) inBruce Momjian2001-10-04
| | | | | | | | | plpython would result in numeric overflows causing the backend to terminate abruptly. This patch fixes it. Bradley McLean
* I've just finished the Chinese NLS support(zh_CN part) filesBruce Momjian2001-10-04
| | | | | | | | | 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-04
| | | | | | | | | | | | | | | | | 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-04
|
* Make regress tests safe for variable-resolution timestamps.Tom Lane2001-10-04
|
* Fix some problems in new variable-resolution-timestamp code.Tom Lane2001-10-04
|
* Add dependency for regexec.cTatsuo Ishii2001-10-04
|
* Add dependency for like.cTatsuo Ishii2001-10-04
|
* Optimization for single byte encodings.Tatsuo Ishii2001-10-04
|
* Consistently use gcc's __attribute__((format)) to check sprintf-styleTom Lane2001-10-03
| | | | | 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-03
| | | | | | | '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.
* Update error message wording for format_type change.Tom Lane2001-10-03
|
* Remove no-longer-used macros.Tom Lane2001-10-03
|