aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* Avoid multiple scans of utils/mb/conversion_procs/ subdirectories duringTom Lane2002-09-04
| | | | | | | 'make install'; there are enough of 'em that this slowed down the make noticeably. Ensure that 'all' is the default make target in all these directories (defaulting to 'make install' is surprising and dangerous IMHO). Fix a couple small typos.
* File list cleanup.Bruce Momjian2002-09-04
|
* Update files to be changed.Bruce Momjian2002-09-04
|
* Brand 7.3. Ready for beta!Bruce Momjian2002-09-04
|
* Refrect the changes to src/test/regress/sql/conversion.sql By Tom.Tatsuo Ishii2002-09-04
|
* EXTRACT(EPOCH FROM timestamp) gave wrong answers in the int64-timestampTom Lane2002-09-03
| | | | | case for timestamptz input, and differently wrong answers in the float- timestamp case for timestamp input.
* Arrange for the default permissions on a database to allow temp tableTom Lane2002-09-03
| | | | | | | creation to world, but disallow temp table creation in template1. Per latest round of pghackers discussion. I did not force initdb, but the permissions lockdown on template1 will not take effect unless you do one (or manually REVOKE TEMP ON DATABASE template1 FROM public).
* conversion test fails if there is an existing user named foo. Choose a nameTom Lane2002-09-03
| | | | somewhat less likely to provoke a conflict.
* Remove all traces of multibyte and locale options. Clean up commentsPeter Eisentraut2002-09-03
| | | | referring to "multibyte" where it really means character encoding.
* Work around mktime() brain damage in recent versions of glibc by usingTom Lane2002-09-03
| | | | | | | a series of localtime() calls to determine the local timezone offset when mktime() fails. This eliminates regression failures on RHL 7.3, and should continue to work until it occurs to the glibc boys to break localtime() as well. By then I hope we'll have our own timezone code...
* Eliminate unnecessary dependency on mktime(), and consequent 'Unable toTom Lane2002-09-03
| | | | convert date to tm' failures, by using DetermineLocalTimeZone() instead.
* Workaround for format strings that are concatenated from macrosPeter Eisentraut2002-09-03
| | | | (INT64_FORMAT), which gettext cannot handle.
* AIX shlib fix for building libpq.so from Tomoyuki NiijimaBruce Momjian2002-09-03
|
* I think reindex_index had better get AccessExclusiveLock on the parentTom Lane2002-09-03
| | | | heap, not just ExclusiveLock.
* Code review and documentation updates for indisclustered patch.Tom Lane2002-09-03
|
* Partial solution for 'unexpected EOF' problem with pg_disconnect: itTom Lane2002-09-02
| | | | | | | seems we have a choice between annoying messages and leaking memory (or dumping core, but that's right out). Patch also fixes several other problems in pg_disconnect, such as being willing to close a channel that isn't a PG channel.
* Translation updatesPeter Eisentraut2002-09-02
|
* Avoid shell syntax error if list of languages is empty.Peter Eisentraut2002-09-02
|
* Fix typos.Peter Eisentraut2002-09-02
|
* Convert control status codes to human-readable strings.Peter Eisentraut2002-09-02
|
* pg_on_connection_loss command for libpgtcl. Patch fromTom Lane2002-09-02
| | | | | | | | Gerhard Hintermayer, revised and documented by Tom Lane. This patch also fixes a 'must fix' bug: libpgtcl's LISTEN/NOTIFY support was broken by the recent changes to the PGnotify structure. Guess that change wasn't quite so safe as we thought.
* Department of second thoughts: make checks for replacing a view slightlyTom Lane2002-09-02
| | | | | more flexible, and improve the error reporting. Also, add documentation for REPLACE RULE/VIEW.
* Improve CVS log grouping.Bruce Momjian2002-09-02
|
* Fix breakage introduced by evidently-completely-untested snprintf patch.Tom Lane2002-09-02
|
* Fix conversion regressin test failure.Tatsuo Ishii2002-09-02
|
* Update catversion so we are sure everyone gets the bytea LIKE fix.Bruce Momjian2002-09-02
|
* > Okay. When you get back to the original issue, the gold is hidden inBruce Momjian2002-09-02
| | | | | | | | | | | | > src/backend/optimizer/path/indxpath.c; see the "special indexable > operators" stuff near the bottom of that file. (It's a bit of a crock > that this code is hardwired there, and not somehow accessed through a > system catalog, but it's what we've got at the moment.) The attached patch re-enables a bytea right hand argument (as compared to a text right hand argument), and enables index usage, for bytea LIKE Joe Conway
* Tab completion in psql is missing the REINDEX command.Bruce Momjian2002-09-02
| | | | Alvaro Herrera
* I checked all the previous string handling errors and most of them wereBruce Momjian2002-09-02
| | | | | | | | | | | | | | | already fixed by You. However there were a few left and attached patch should fix the rest of them. I used StringInfo only in 2 places and both of them are inside debug ifdefs. Only performance penalty will come from using strlen() like all the other code does. I also modified some of the already patched parts by changing snprintf(buf, 2 * BUFSIZE, ... style lines to snprintf(buf, sizeof(buf), ... where buf is an array. Jukka Holappa
* I guess the intention was to test incomplete SELECT statements, notBruce Momjian2002-09-02
| | | | | | | | missing semicolons. I also added a SELECT statement without a target list. Manfred Koizar
* Okay, attached is a patch that moves the alter table regression testBruce Momjian2002-09-02
| | | | | | | | into a separate parallel group. I can't confirm that this fixes the problem for me (since it only occurs about one in ten or one in twenty runs), but I think it's a good bet that it does... Neil Conway
* Add GUC variable to print original query to the server logs when thereBruce Momjian2002-09-02
| | | | | | is an error, warning, etc. Gavin Sherry
* Remove documentation that says debug_query_string is only used byBruce Momjian2002-09-02
| | | | | | pgmonitor. Now log_min_error_statement uses it.
* Fix ordering regression problem on freebsd/alpha by adding ORDER BY.Bruce Momjian2002-09-02
|
* I tried to build PostgreSQL with the following step to see backends hungBruce Momjian2002-09-02
| | | | | | | | | | | | | | | | | | | | | | | | | | | during the regression test. The problem has been reproduced on two machine but both of these are the same type of hardware and software. I also tried to recreate the problem on other machines, on older version of AIX but I couldn't. After looked through pgsql-hackers mailing list, I focused on spin lock issue to solve the problem. The easiest and may not be the best solution for the problem is to give up HAS_TEST_AND_SET. This actually works. One another and better solution for the problem is to use _check_lock() and _clear_lock() as spin lock. Important thing here is to define S_UNLOCK() with _clear_lock(). This will solve the so called "Compiler bug" issue someone wrote on the mailing list. We have some other API such as cs(), compare_and_swap() and fetch_and_or() to do test and set on AIX, but any of these didn't solve my problem. I wrote tiny testing program to see if we have any bug of these API of AIX, but I couldn't see any problem except for compare_and_swap(). It seems that you can not use compare_and_swap() for the purpose, as it would not work as spin lock on any SMP machines I tested. I don't know the reason why cs() nor fetch_and_or()/fetch_and_and() will not work with PostgreSQL on p690. These worked with my testing program on all machines I tested. Tomoyuki Niijima
* JDBC checkin fixing the following bugs:Barry Lind2002-09-02
| | | | | | | | | | | | | | | | | | | | | | Fixed support in the driver for notifications (added PGConnection.getNotifications()) - problem reported by Benjamin.Feinstein@guardent.com Worked around server problems with int8/int2 and constants; quote values when they are intended to bind to an int8/int2 column - reported by many Fixed bug in the Array interface with string parsing not handling escaped characters correctly - reported by devajx@yahoo.com Added workaround to support 'infinity' and '-infinity' for dates - reported bydmitry@openratings.com Fixed some performance issues with setBlob - reported by d.wall@computer.org Added support for using new prepared statements functionality in 7.3 (added PGStatement.setUseServerPrepare() and isUseServerPrepare() methods) Modified Files: jdbc/org/postgresql/PGConnection.java jdbc/org/postgresql/PGStatement.java jdbc/org/postgresql/core/QueryExecutor.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java jdbc/org/postgresql/jdbc2/Array.java Added Files: jdbc/org/postgresql/PGNotification.java jdbc/org/postgresql/core/Notification.java
* Remove sys/types.h in files that include postgres.h, and hence c.h,Bruce Momjian2002-09-02
| | | | because c.h has sys/types.h.
* CREATE OR REPLACE VIEW, CREATE OR REPLACE RULE.Tom Lane2002-09-02
| | | | | Gavin Sherry, Neil Conway, and Tom Lane all got their hands dirty on this one ...
* Code review for HeapTupleHeader changes. Add version number to page headersTom Lane2002-09-02
| | | | | | | | | | (overlaying low byte of page size) and add HEAP_HASOID bit to t_infomask, per earlier discussion. Simplify scheme for overlaying fields in tuple header (no need for cmax to live in more than one place). Don't try to clear infomask status bits in tqual.c --- not safe to do it there. Don't try to force output table of a SELECT INTO to have OIDs, either. Get rid of unnecessarily complex three-state scheme for TupleDesc.tdhasoids, which has already caused one recent failure. Improve documentation.
* patch from Thomas O'Dowd to ensure that connections are closedDave Cramer2002-09-01
|
* testing for insertRowDave Cramer2002-09-01
|
* Update MEMSET_LOOP_LIMIT to 1024 because it is the best value for mostBruce Momjian2002-09-01
| | | | platforms.
* patch to allow insertRow on an empty resultSetDave Cramer2002-09-01
|
* Changed to reflect the current reality, ie we do support updateable resultsetsDave Cramer2002-09-01
|
* Improve footer length computation for psql.Bruce Momjian2002-09-01
| | | | Greg Sabino Mullan
* Add log_duration to GUC/postgresql.conf.Bruce Momjian2002-09-01
| | | | | Rename debug_print_query to log_statement and rename show_query_stats to show_statement_stats.
* plpgsql functions can return RECORD, per Neil Conway.Tom Lane2002-09-01
|
* Code cleanups: make non-implicit WITHOUT FUNCTION casts work, avoidTom Lane2002-09-01
| | | | redundant pg_cast searches, fix obsolete comments.
* Remove code that suggested increasing wal_files.Bruce Momjian2002-09-01
|
* Mark the float8 -> int8 cast as implicit. This resolves the problemTom Lane2002-09-01
| | | | | | | | | | pointed out by Barry Lind: UPDATE bigintcol = 10000000000 fails because the constant is initially taken as float8. We really need a better way, but it's not gonna happen for 7.3. Also, remove int4reltime() function, which is redundant with the existing binary-compatibility coercion path from int4 to reltime, and probably has been unreachable code for a long while.