summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2004-03-24Add a more useful error message for the case where someone tries to passTom Lane
a whole row or record variable into a SQL function. Eventually this case should be made to actually work, but for now this is better than what it did before.
2004-03-24Replace max_expr_depth parameter with a max_stack_depth parameter thatTom Lane
is measured in kilobytes and checked against actual physical execution stack depth, as per my proposal of 30-Dec. This gives us a fairly bulletproof defense against crashing due to runaway recursive functions.
2004-03-24Adjust error message wording per Andrew Dunstan's advice.Tom Lane
2004-03-24Update description error text:Bruce Momjian
(errmsg("no socket configured for listening")));
2004-03-24Here's a patch implementing the "thread method" to workaround the bugBruce Momjian
with socket calls in signal handlers (APC) on Win32. See details in mail to pgsql-hackers-win32 a couple of minutes ago. Magnus Hagander
2004-03-24Allow unlink/rename of files open by another process on Win32, using aBruce Momjian
special Win32 open flag FILE_SHARE_DELETE. Claudio Natoli
2004-03-24Add thread locking to SSL and Kerberos connections.Bruce Momjian
I have removed the docs mentioning that SSL and Kerberos are not thread-safe. Manfred Spraul
2004-03-24Fix some whitespace formatting, and remove an overly-verboseNeil Conway
parameter description: postgresql.conf is not the place for documentating the functionality of a GUC var.
2004-03-24>>Also, what is the default connection mode of psql? It should probably beBruce Momjian
>>equivalent to "-h localhost", shouldn't it? >> >> > >Now that is something I had not thought of. Seems we can assume a Win32 >psql can never use unix domain sockets, so defaulting that to localhost >is a good solution too. Andrew Dunstan
2004-03-24Use the new GUC variable default_with_oids in pg_dump, rather than usingBruce Momjian
WITH/WITHOUT OIDS in dump files. This makes dump files more portable. I have updated the pg_dump version so old binary dumps will load fine. Pre-7.5 dumps use WITHOUT OIDS in SQL were needed, so they should be fine.
2004-03-24Update the float8 regression tests: they should now pass on FreeBSD 4.xNeil Conway
and (in theory) QNX. Thanks to Chris KL for the report.
2004-03-23Use dollar-quoting for function bodies, unless disabled withTom Lane
--disable-dollar-quoting. Andrew Dunstan
2004-03-23When changing select() calls for delays into pg_usleep(), two commentsBruce Momjian
in s_lock.c were not updated, and still refers to select. Made my grep hit the wrong files, so I figured a simple patch was in order.. (other refs in the same comment block was changed..) Magnus Hagander
2004-03-23Upgrade ALTER TABLE DROP COLUMN so that it can drop an OID column, andTom Lane
remove separate implementation of ALTER TABLE SET WITHOUT OIDS in favor of doing a regular DROP. Also, cause CREATE TABLE to account completely correctly for the inheritance status of the OID column. This fixes problems with dropping OID columns that have dependencies, as noted by Christopher Kings-Lynne, as well as making sure that you can't drop an OID column that was inherited from a parent.
2004-03-23fflush() FILE buffer to descriptor so stat call gets proper size in fseeko.c.Bruce Momjian
Fixed problem with pg_dump tar backups. Only happens on platforms that use our port/fseeko.c, which is currently BSD/OS and NetBSD.
2004-03-23Fix getpwuid_r call:Bruce Momjian
*result = getpwuid_r(uid, resultbuf, buffer, buflen);
2004-03-23Replace the virtual_host and tcpip_socket parameters with a unifiedTom Lane
listen_addresses parameter, as per recent discussion. The default behavior is now to listen on localhost, which eliminates the need for the -i postmaster switch in many scenarios. Andrew Dunstan
2004-03-22Before deciding we can use a socket for statistics collection, test toTom Lane
ensure that it actually passes data. This catches cases such as a kernel packet filter rule that makes the socket useless. Andrew Dunstan
2004-03-22Add missing extern for optind.Tom Lane
2004-03-22Standardize output buffer size and display format for strftime;Tom Lane
followup to complaint from Korean User's Group.
2004-03-22Disasble threads on unixware until other platforms report a problem.Bruce Momjian
2004-03-22Increase xlog str_time() static string variable, per Korean User's Group.Bruce Momjian
2004-03-22I just noticed that \dp outputs "Table" to indicate relations (tables,Bruce Momjian
sequences and views). This patch allows it to handle views and sequences. Euler Taveira de Oliveira
2004-03-22Adds DLLIMPORT modifier to check_function_bodiesBruce Momjian
Claudio Natoli
2004-03-22Add mention of "-D_POSIX_PTHREAD_SEMANTICS" enabling 5-arg getpwuid_r().Bruce Momjian
2004-03-22Add timestamp-versus-timestamptz cross-type comparison functions,Tom Lane
flesh out the index operator classes to include these. In passing, fix erroneous volatility marking of ACL functions.
2004-03-21Revise syntax-error reporting behavior to give pleasant results forTom Lane
errors in internally-generated queries, such as those submitted by plpgsql functions. Per recent discussions with Fabien Coelho.
2004-03-21Translation updatesDennis Bjorklund
2004-03-21Translation updatesDennis Bjorklund
2004-03-20Rewrite pg_dump's comment-dumping code to pull over all the commentsTom Lane
in one query, rather than making a separate query for each object that could have a comment. This costs relatively little space (a few tens of K typically) and saves substantial time in databases with many objects. I find it reduces the runtime of 'pg_dump -s regression' by about a third.
2004-03-20Remove suggestiong for using test for wal_sync_method.Bruce Momjian
2004-03-20Handle draft version of getpwuid_r() that accepts only four arguments.Bruce Momjian
Backpatch to 7.4.X. Required for Solaris 7 & 8.
2004-03-19Create a validator for plpgsql, so that some minimal syntax checkingTom Lane
is done at creation time for plpgsql functions. Improve createlang and droplang to support adding/dropping validators for PLs. Initial steps towards producing a syntax error position from plpgsql syntax errors (this part is a work in progress, and will change depending on outcome of current discussions).
2004-03-19Code review for log_line_prefix patch. Cooperate with StringInfo insteadTom Lane
of fighting it, avoid hard-wired (and wrong) assumption about max length of prefix, cause %l to actually work as documented, don't compute data we may not need.
2004-03-18Make test_fsync use optimizer flag.Bruce Momjian
2004-03-18Fix log_executor_stats if() test.Bruce Momjian
2004-03-18Add Unixware thread support from Larry Rosenman.Bruce Momjian
2004-03-18Allocate 16mb file for testing.Bruce Momjian
2004-03-18Have program default to 1000 loops, and add file name and loop option.Bruce Momjian
Make open/close loop testings the same. Add descriptions for certain tests.
2004-03-18Add comment about using this testing for wal_sync_method.Bruce Momjian
2004-03-18Add fsync tests:Bruce Momjian
Compare fsync before and after write's close: Compare one o_sync write to two: Compare file sync methods with one 8k write: Compare file sync methods with 2 8k writes:
2004-03-18Mention which fsync methods are unavailable.Bruce Momjian
2004-03-18Add permission mode to opens().Bruce Momjian
2004-03-18Add missing includeBruce Momjian
2004-03-18Remove acccidental object/binary files.Bruce Momjian
2004-03-18Add fsync test program. It tests fsync to see if times for fsync are theBruce Momjian
same when done on the write() ile descriptor and a new descriptor. it also times various fsync methods.
2004-03-17During btree index build, sort equal-keyed tuples according to theirTom Lane
TID (heap position). This doesn't do anything to the validity of the finished index, but by pretending to qsort() that there are no really equal keys in the sort, we can avoid performance problems with qsort implementations that have trouble with large numbers of equal keys. Patch from Manfred Koizar.
2004-03-17Reimplement CASE val WHEN compval1 THEN ... WHEN compval2 THEN ... ENDTom Lane
so that the 'val' is computed only once, per recent discussion. The speedup is not much when 'val' is just a simple variable, but could be significant for larger expressions. More importantly this avoids issues with multiple evaluations of a volatile 'val', and it allows the CASE expression to be reverse-listed in its original form by ruleutils.c.
2004-03-17Document SPI_push() and SPI_pop().Bruce Momjian
2004-03-17Replace the switching function ExecEvalExpr() with a macro that jumpsTom Lane
directly to the appropriate per-node execution function, using a function pointer stored by ExecInitExpr. This speeds things up by eliminating one level of function call. The function-pointer technique also enables further small improvements such as only making one-time tests once (and then changing the function pointer). Overall this seems to gain about 10% on evaluation of simple expressions, which isn't earthshaking but seems a worthwhile gain for a relatively small hack. Per recent discussion on pghackers.