summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2003-07-15Cause SHOW DATESTYLE to produce a string that will be accepted by SETTom Lane
DATESTYLE, for instance 'SQL, European' instead of 'SQL with European conventions'. Per gripe a month or two back from Barry Lind.
2003-07-15Avoid use of int64_t, which seems not to be very portable. SimplifyTom Lane
padding logic for struct sockaddr_storage --- original version did not do what it claimed to when SALEN is defined.
2003-07-15OSF supports pthreads, per Philip Yarra.Tom Lane
2003-07-15Started to create different error codes for different backend messages.Michael Meskes
2003-07-15Tweak original coding so that we can determine the platform-specificTom Lane
shared_buffers and max_connections values to use before we run the bootstrap process. Without this, initdb would fail on platforms where the hardwired default values are too large. (We could get around that by making the hardwired defaults tiny, perhaps, but why slow down bootstrap by starving it for buffers...)
2003-07-14Remove duplicate definition of ERROR.Tom Lane
2003-07-14Make cost estimates for SubqueryScan more realistic: charge cpu_tuple_costTom Lane
for each row processed, and don't forget the evaluation cost of any restriction clauses attached to the node. Per discussion with Greg Stark.
2003-07-14Fix typo in comment, as noted by Weiping He.Tom Lane
2003-07-14The default values for shared_buffers and max_connections are now 1000Tom Lane
and 100 respectively, if the platform will allow it. initdb selects values that are not too large to allow the postmaster to start, and places these values in the installed postgresql.conf file. This allows us to continue to start up out-of-the-box on platforms with small SHMMAX, while having somewhat-realistic default settings on platforms with reasonable SHMMAX. Per recent pghackers discussion.
2003-07-14Whoops, missed committing this change to match cosmetic changes inTom Lane
ascii.c.
2003-07-14Fix a *second* buffer overrun bug in to_ascii(). Grumble.Tom Lane
2003-07-14Missed one rule in syncinc preproc.y which resulted in reduce/reduce conflicts.Michael Meskes
2003-07-14 - Synced preproc.y with gram.yMichael Meskes
- Init sqlca in ECPGprepare(). - Added CLOSE DATABASE for Informix compatibility.
2003-07-09Add description for new GUC context.Bruce Momjian
Aizaz Ahmed
2003-07-09Argh! Missed one file.Michael Meskes
2003-07-09Fixed some Informix compat functions so they handle NULL resp. indicators ↵Michael Meskes
better.
2003-07-09Add special checks for non-super-user setting LOG_MIN_DURATION_STATEMENTBruce Momjian
to zero.
2003-07-09Add new USERLIMIT GUC source level so certain options can be disabledBruce Momjian
or increased only by super-users. This fixes problems caused by making certain variables SUSET for security reasons.
2003-07-09Applied patch from Kim Ho @ redhat.com to make support for setObject() moreBarry Lind
spec complient with regards to various data/time/timestamp objects Modified Files: jdbc/org/postgresql/errors.properties jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
2003-07-08More informix fixes.Michael Meskes
2003-07-08Fix segfault in connect in informix mode.Michael Meskes
2003-07-07"char *" of course is not the same as "char []". So I had to fix the way ↵Michael Meskes
ecpg treated the second one.
2003-07-04tm2timestamp should return -1, not elog, on overflow. (In the backendTom Lane
this is merely an API inconsistency, but in ecpg it's fatal.) Also, fix misconceived overflow test in HAVE_INT64_TIMESTAMP case.
2003-07-04Fix missing code for HAVE_INT64_TIMESTAMP.Tom Lane
2003-07-04Add --help-config facility to dump information about GUC parametersTom Lane
without needing a running backend. Reorder postgresql.conf.sample to match new layout of runtime.sgml. This commit re-adds work lost in Wednesday's crash.
2003-07-04Add #include <limits.h> (re-add lost change from Wednesday).Tom Lane
2003-07-04date, interval and timestamp data should be quoted.Michael Meskes
2003-07-04Fixed informix behaviour for select without into.Michael Meskes
2003-07-04Some early work on error message editing. Operator-not-found andTom Lane
function-not-found messages now distinguish the cases no-match and ambiguous-match, and they follow the style guidelines too.
2003-07-03Fix bug I introduced in recent rewrite of NUMERIC code: numeric toTom Lane
integer conversions gave the wrong answer for values with stripped trailing zeroes, such as 10000000.
2003-07-03Do honest transformation and preprocessing of LIMIT/OFFSET clauses,Tom Lane
instead of the former kluge whereby gram.y emitted already-transformed expressions. This is needed so that Params appearing in these clauses actually work correctly. I suppose some might claim that the side effect of 'SELECT ... LIMIT 2+2' working is a new feature, but I say this is a bug fix.
2003-07-03Code review for UPDATE tab SET col = DEFAULT patch ... whack it aroundTom Lane
so it has some chance of working in rules ...
2003-07-02Fixed initialization bug and added postgres_fe.h to pgtypeslib.Michael Meskes
2003-07-01Support polymorphic functions in plpgsql. Along the way, replaceTom Lane
linked-list search of function cache with hash-table lookup. By Joe Conway.
2003-07-01Fix ecpg typo --- change ;; to ;.Bruce Momjian
2003-07-01Aggregates can be polymorphic, using polymorphic implementation functions.Tom Lane
It also works to create a non-polymorphic aggregate from polymorphic functions, should you want to do that. Regression test added, docs still lacking. By Joe Conway, with some kibitzing from Tom Lane.
2003-07-01Dept. of second thoughts: supporting inlining of polymorphic SQL functionsTom Lane
takes only a few more lines of code than preventing it, so might as well support it.
2003-07-01STRENGH => STRENGTH, per Jon Jensen.Tom Lane
2003-07-01Use ISO dates in pgtypeslib by default.Michael Meskes
Applied patch by Philip Yarra to fix some thread issues. Added a new data type "decimal" which is mostly the same as our "numeric" but uses a fixed length array to store the digits. This is for compatibility with Informix and maybe others.
2003-07-01Department of second thoughts: even if we can't run the full parser onTom Lane
a SQL function with polymorphic inputs, we can at least run the raw parser to catch silly syntactic errors.
2003-07-01Translation updatePeter Eisentraut
2003-07-01SQL functions can have arguments and results declared ANYARRAY orTom Lane
ANYELEMENT. The effect is to postpone typechecking of the function body until runtime. Documentation is still lacking. Original patch by Joe Conway, modified to postpone type checking by Tom Lane.
2003-07-01Change EXECUTE INTO to CREATE TABLE AS EXECUTE.Peter Eisentraut
2003-06-30patches by Kim Ho to fixDave Cramer
getByte, getSort if input has decimal or whitespace setObject if object is a BIT boolean not on list of SQLKeywords
2003-06-30Rename plpython to plpythonu, and update documentation to reflect itsTom Lane
now-untrusted status.
2003-06-30Add GUC option log_error_verbosity to control which fields of errorTom Lane
reports get put into the postmaster log. Options are TERSE, DEFAULT, VERBOSE, with the same behavior as implemented on the client side in libpq.
2003-06-30Patches applied:Barry Lind
1) Patch from Kris Jurka to fix IPv6 parsing of the jdbc URL 2) Patch from Kris Jurka to fix an ArrayIndexOutOfBounds error when calling moveToCurrentRow while currentRow is "beforeFirst" 3) Patch from Kim Ho to fix add some bounds checking in setMaxRows(), setQueryTimeout(), setFetchSize() Modified Files: jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/errors.properties jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java
2003-06-29Restructure building of join relation targetlists so that a join planTom Lane
node emits only those vars that are actually needed above it in the plan tree. (There were comments in the code suggesting that this was done at some point in the dim past, but for a long time we have just made join nodes emit everything that either input emitted.) Aside from being marginally more efficient, this fixes the problem noted by Peter Eisentraut where a join above an IN-implemented-as-join might fail, because the subplan targetlist constructed in the latter case didn't meet the expectation of including everything. Along the way, fix some places that were O(N^2) in the targetlist length. This is not all the trouble spots for wide queries by any means, but it's a step forward.
2003-06-29- Made sure Informix style decimal vars are initialized. They use aMichael Meskes
fixed amount of digits and not an allocated one. So we have to work around. PostgreSQL numeric type remains the same. - In INFORMIX_SE mode with autcommit set, make all cursors be "with hold". Is this really they way SE behaves?
2003-06-29Information schema views for group privileges, some corrections on columnPeter Eisentraut
privileges.