aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Change LIMIT #,# error message to be more generic.Bruce Momjian2001-10-20
|
* Remove LIMIT #,# and suggest LIMIT # OFFSET #, per mailing list discussion.Bruce Momjian2001-10-20
|
* Fix transposed arguments for typmod for one INTERVAL production.Thomas G. Lockhart2001-10-20
| | | | | | | | | | | | | | Mask both typmod subfields for INTERVAL to avoid setting the high bit, per dire warning from Tom Lane. Clear tmask for DTK_ISO_TIME case to avoid time zone troubles. Symptom reported by Tom Lane. Clean up checking for valid time zone info in output routine. This should now work for both SQL99 and Unix-style time zones. Put in explicit check for INTERVAL() typmod rounding to avoid accumulating cruft in the lower bits. Not sure that this helps, but we'll need to do something. The symptom is visible with a query like select interval(2) '10000 days 01:02:03.040506'; Regression tests are patched to repair the Tom Lane symptom, and all pass.
* Fix plperl to discard cached function definition after CREATE ORTom Lane2001-10-19
| | | | REPLACE FUNCTION. Clean up typlen/typmod errors inherited from pltcl.
* Proper fix for glibc getopt() botch. Surprising we did not see thisTom Lane2001-10-19
| | | | before.
* Fix a lot of confusion between typlen and typmod. Didn't hurt too muchTom Lane2001-10-19
| | | | back when only varlena types paid any attention to typmod ...
* Set optreset on platforms that have it before launching postmasterTom Lane2001-10-19
| | | | | | subprocesses; perhaps this will fix portability problem just noted by Lockhart. Also, move test for bad permissions of DataDir to a more logical place.
* Ensure that all startup paths (postmaster, standalone postgres, orTom Lane2001-10-19
| | | | | | | bootstrap) check for a valid PG_VERSION file before looking at anything else in the data directory. This fixes confusing error report when trying to start current sources in a pre-7.1 data directory. Per trouble report from Rich Shepard 10/18/01.
* Rename macro arg to avoid useless compiler warning when building plperl.Tom Lane2001-10-19
|
* Without this patch I couldn't compile PostgreSQL on Solaris 8 x86 usingBruce Momjian2001-10-19
| | | | | | Sun's compiler. May be it will be usefull for someone else? Denis Ustimenko
* > This stops the interface from leaking the row tuples (and thus theBruce Momjian2001-10-19
| | | | | | > results of every fetch). Stephen Robert Norris
* Update TODO list.Bruce Momjian2001-10-19
|
* removed "not fully implemented" warning for nullifMichael Meskes2001-10-19
|
* Change SC_fetch() to not retrieve data in case theHiroshi Inoue2001-10-19
| | | | | SQL_RETRIEVE_DATA option is SQL_RD_OFF. This would avoid a crash when scrolling Grid controls.
* Fix pltcl to update cached function def afterTom Lane2001-10-19
| | | | CREATE OR REPLACE FUNCTION.
* Update TODO list.Bruce Momjian2001-10-19
|
* Typo.Tom Lane2001-10-19
|
* Move init_ps_display from postgres.c to postmaster.c, putting itTom Lane2001-10-19
| | | | | | | | | | | just after receipt of the startup packet. Now, postmaster children that are waiting for client authentication response will show as 'postgres: user database host authentication'. Also, do an init_ps_display for startup/shutdown/checkpoint subprocesses, so that they are readily identifiable as well. Fix an obscure race condition that could lead to Assert failure in the postmaster --- attempting to start a checkpoint process before any connections have been received led to calling PostmasterRandom before setting random_seed.
* Spell 'between' correctly, clean up spacing in error messages.Tom Lane2001-10-18
|
* Fix memory leakage when sending notice messages to client.Tom Lane2001-10-18
|
* Fix authentication so that it doesn't record an extra 'PasswordTom Lane2001-10-18
| | | | | | | | | | authentication failed' and a 'send() failed: Broken pipe' message on every connection from psql in password auth mode. Problem is that psql doesn't ask user for a password until it sees a password challenge failure, and libpq just closes the connection unceremoniously if it's challenged for a password when it hasn't got one to send. Accordingly, EOF from the client after asking for a password is normal behavior and should not result in postmaster log entries.
* Add STATUS_EOF value needed for auth.c. Remove a bunch of unusedTom Lane2001-10-18
| | | | STATUS_xxx macros to reduce clutter.
* Fix several problems with simple_prompt() --- the nastiest being thatTom Lane2001-10-18
| | | | | | the entered password would get echoed on some platforms, eg HPUX. We have enough copies of this code that I'm thinking it ought to be moved into libpq, but that's a task for another day.
* Change error code docs to use colons.Bruce Momjian2001-10-18
|
* Document all the ecpg error codes.Bruce Momjian2001-10-18
|
* Update for new expected results.Tom Lane2001-10-18
|
* Didn't compile on non-HAVE_TM_ZONE machines.Tom Lane2001-10-18
|
* Repair missing brace in HAVE_INT_TIMEZONE case.Tom Lane2001-10-18
|
* Accept an INTERVAL argument for SET TIME ZONE per SQL99.Thomas G. Lockhart2001-10-18
| | | | | | | | | | | | | | | | | | | | | | | | | Modified the parser and the SET handlers to use full Node structures rather than simply a character string argument. Implement INTERVAL() YEAR TO MONTH (etc) syntax per SQL99. Does not yet accept the goofy string format that goes along with, but this should be fairly straight forward to fix now as a bug or later as a feature. Implement precision for the INTERVAL() type. Use the typmod mechanism for both of INTERVAL features. Fix the INTERVAL syntax in the parser: opt_interval was in the wrong place. INTERVAL is now a reserved word, otherwise we get reduce/reduce errors. Implement an explicit date_part() function for TIMETZ. Should fix coersion problem with INTERVAL reported by Peter E. Fix up some error messages for date/time types. Use all caps for type names within message. Fix recently introduced side-effect bug disabling 'epoch' as a recognized field for date_part() etc. Reported by Peter E. (??) Bump catalog version number. Rename "microseconds" current transaction time field from ...Msec to ...Usec. Duh! date/time regression tests updated for reference platform, but a few changes will be necessary for others.
* Extend code that deduces implied equality clauses to detect whether aTom Lane2001-10-18
| | | | | | | | clause being added to a particular restriction-clause list is redundant with those already in the list. This avoids useless work at runtime, and (perhaps more importantly) keeps the selectivity estimation routines from generating too-small estimates of numbers of output rows. Also some minor improvements in OPTIMIZER_DEBUG displays.
* Added Lee Kindness' patches.Michael Meskes2001-10-18
|
* Update file for pgcrypto.Bruce Momjian2001-10-17
|
* Add documentation about statistics collector and stats views & functions.Tom Lane2001-10-16
|
* Make sure to clean out old activity string when recycling a backend entry.Tom Lane2001-10-16
|
* Use LEFT JOIN, not FULL JOIN, in statistical views.Tom Lane2001-10-16
|
* Updated the list of encodings supported to match what the backend now supportsBarry Lind2001-10-16
|
* Added some additional comments in the codeBarry Lind2001-10-16
|
* Python handle as string all int8 values from postgresql. This could beBruce Momjian2001-10-16
| | | | | | | | | | | | | | | view when using the aggregate function count() and function nextval that returns an int8 value, but in python is represented like string: >> db.query("select nextval('my_seq')").getresult() [('2',)] >> db.query("select count(*) from films").dictresult() [{'count': '120'}] Ricardo Caesar Lenzi
* Ok, here is the modified encoding table (column1 is the standard name,Tatsuo Ishii2001-10-16
| | | | | | | | | | | | | | | | | | | | | | | 2 is our "official" name, and 3 is alias). If there's no objection, I will change them. ASCII SQL_ASCII UTF-8 UNICODE UTF_8 MULE-INTERNAL MULE_INTERNAL ISO-8859-1 LATIN1 ISO_8859_1 ISO-8859-2 LATIN2 ISO_8859_2 ISO-8859-3 LATIN3 ISO_8859_3 ISO-8859-4 LATIN4 ISO_8859_4 ISO-8859-5 ISO_8859_5 ISO-8859-6 ISO_8859_6 ISO-8859-7 ISO_8859_7 ISO-8859-8 ISO_8859_8 ISO-8859-9 LATIN5 ISO_8859_9 ISO-8859-10 LATIN6 ISO_8859_10 ISO-8859-13 LATIN7 ISO_8859_13 ISO-8859-14 LATIN8 ISO_8859_14 ISO-8859-15 LATIN9 ISO_8859_15 ISO-8859-16 LATIN10 ISO_8859_16
* Add a section about the planner's statistics, including a descriptionTom Lane2001-10-16
| | | | of the new pg_stats view.
* Add note about pg_stats to pg_statistic entry; add sections forTom Lane2001-10-15
| | | | | pg_largeobject, pg_listener, pg_rewrite, pg_trigger; miscellaneous small improvements.
* Doesn't anyone test stuff before they commit it?Tom Lane2001-10-15
|
* Fix some portability problems (get it to compile, at least, on HP's cc)Tom Lane2001-10-15
|
* Fix some portability problems (get it to compile, at least, on HP's cc)Tom Lane2001-10-15
|
* Fix some portability problems (get it to compile, at least, on HP's cc)Tom Lane2001-10-15
|
* > Uh, isn't the correct fixBruce Momjian2001-10-15
| | | | | | | | | | | | | | | | | | | | | | | | | > ! $$ = cat_str(8, make_str("grant"), $2, make_str("on"), $4, $5, > make_str("to"), $7, $8); > ISTM your patch loses the opt_with_grant clause. (Of course the > backend doesn't currently accept that clause anyway, but that's no > reason for ecpg to drop it.) My patch doesn't loose the option, it's never been passed on anyway: opt_with_grant: WITH GRANT OPTION { mmerror(ET_ERROR, "WITH GRANT OPTION is not supported. Only relation owners can set privileges"); } | /*EMPTY*/ ; The existing code in ecpg/preproc/preproc.y to handle the WITH option simply throws an error and aborts the processing... The patch below prevents the segfault and also passes on the WITH option to the backend, probably a better fix. Lee Kindness
* Updated regression test for tsearch, from Teodor Sigaev.Tom Lane2001-10-15
|
* Prompt for password from /dev/tty and fall back to stdin/stderr.Bruce Momjian2001-10-15
|
* Forgot to add this file...Tatsuo Ishii2001-10-15
|
* PG_DUMP NLS (Russian)Bruce Momjian2001-10-15
| | | | | | | | Here is another one :) Another chunk of translated messages. Please apply to the same file. Serguei Mokhov
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-07 18:50:09 +0000