summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2002-09-04Avoid multiple scans of utils/mb/conversion_procs/ subdirectories duringTom Lane
'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.
2002-09-04File list cleanup.Bruce Momjian
2002-09-04Update files to be changed.Bruce Momjian
2002-09-04Brand 7.3. Ready for beta!Bruce Momjian
2002-09-04Refrect the changes to src/test/regress/sql/conversion.sql By Tom.Tatsuo Ishii
2002-09-03EXTRACT(EPOCH FROM timestamp) gave wrong answers in the int64-timestampTom Lane
case for timestamptz input, and differently wrong answers in the float- timestamp case for timestamp input.
2002-09-03Arrange for the default permissions on a database to allow temp tableTom Lane
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).
2002-09-03conversion test fails if there is an existing user named foo. Choose a nameTom Lane
somewhat less likely to provoke a conflict.
2002-09-03Remove all traces of multibyte and locale options. Clean up commentsPeter Eisentraut
referring to "multibyte" where it really means character encoding.
2002-09-03Work around mktime() brain damage in recent versions of glibc by usingTom Lane
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...
2002-09-03Eliminate unnecessary dependency on mktime(), and consequent 'Unable toTom Lane
convert date to tm' failures, by using DetermineLocalTimeZone() instead.
2002-09-03Workaround for format strings that are concatenated from macrosPeter Eisentraut
(INT64_FORMAT), which gettext cannot handle.
2002-09-03AIX shlib fix for building libpq.so from Tomoyuki NiijimaBruce Momjian
2002-09-03I think reindex_index had better get AccessExclusiveLock on the parentTom Lane
heap, not just ExclusiveLock.
2002-09-03Code review and documentation updates for indisclustered patch.Tom Lane
2002-09-02Partial solution for 'unexpected EOF' problem with pg_disconnect: itTom Lane
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.
2002-09-02Translation updatesPeter Eisentraut
2002-09-02Avoid shell syntax error if list of languages is empty.Peter Eisentraut
2002-09-02Fix typos.Peter Eisentraut
2002-09-02Convert control status codes to human-readable strings.Peter Eisentraut
2002-09-02pg_on_connection_loss command for libpgtcl. Patch fromTom Lane
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.
2002-09-02Department of second thoughts: make checks for replacing a view slightlyTom Lane
more flexible, and improve the error reporting. Also, add documentation for REPLACE RULE/VIEW.
2002-09-02Improve CVS log grouping.Bruce Momjian
2002-09-02Fix breakage introduced by evidently-completely-untested snprintf patch.Tom Lane
2002-09-02Fix conversion regressin test failure.Tatsuo Ishii
2002-09-02Update catversion so we are sure everyone gets the bytea LIKE fix.Bruce Momjian
2002-09-02> Okay. When you get back to the original issue, the gold is hidden inBruce Momjian
> 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
2002-09-02Tab completion in psql is missing the REINDEX command.Bruce Momjian
Alvaro Herrera
2002-09-02I checked all the previous string handling errors and most of them wereBruce Momjian
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
2002-09-02I guess the intention was to test incomplete SELECT statements, notBruce Momjian
missing semicolons. I also added a SELECT statement without a target list. Manfred Koizar
2002-09-02Okay, attached is a patch that moves the alter table regression testBruce Momjian
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
2002-09-02Add GUC variable to print original query to the server logs when thereBruce Momjian
is an error, warning, etc. Gavin Sherry
2002-09-02Remove documentation that says debug_query_string is only used byBruce Momjian
pgmonitor. Now log_min_error_statement uses it.
2002-09-02Fix ordering regression problem on freebsd/alpha by adding ORDER BY.Bruce Momjian
2002-09-02I tried to build PostgreSQL with the following step to see backends hungBruce Momjian
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
2002-09-02JDBC checkin fixing the following bugs:Barry Lind
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
2002-09-02Remove sys/types.h in files that include postgres.h, and hence c.h,Bruce Momjian
because c.h has sys/types.h.
2002-09-02CREATE OR REPLACE VIEW, CREATE OR REPLACE RULE.Tom Lane
Gavin Sherry, Neil Conway, and Tom Lane all got their hands dirty on this one ...
2002-09-02Code review for HeapTupleHeader changes. Add version number to page headersTom Lane
(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.
2002-09-01patch from Thomas O'Dowd to ensure that connections are closedDave Cramer
2002-09-01testing for insertRowDave Cramer
2002-09-01Update MEMSET_LOOP_LIMIT to 1024 because it is the best value for mostBruce Momjian
platforms.
2002-09-01patch to allow insertRow on an empty resultSetDave Cramer
2002-09-01Changed to reflect the current reality, ie we do support updateable resultsetsDave Cramer
2002-09-01Improve footer length computation for psql.Bruce Momjian
Greg Sabino Mullan
2002-09-01Add log_duration to GUC/postgresql.conf.Bruce Momjian
Rename debug_print_query to log_statement and rename show_query_stats to show_statement_stats.
2002-09-01plpgsql functions can return RECORD, per Neil Conway.Tom Lane
2002-09-01Code cleanups: make non-implicit WITHOUT FUNCTION casts work, avoidTom Lane
redundant pg_cast searches, fix obsolete comments.
2002-09-01Remove code that suggested increasing wal_files.Bruce Momjian
2002-09-01Mark the float8 -> int8 cast as implicit. This resolves the problemTom Lane
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.
generated by cgit v1.2.3 (git 2.46.0) at 2025-08-15 17:03:05 +0000