]> granicus.if.org Git - postgresql/log
postgresql
23 years agoAdd note explaining that multiple prompts for a password are normal
Tom Lane [Mon, 22 Oct 2001 23:48:11 +0000 (23:48 +0000)]
Add note explaining that multiple prompts for a password are normal
behavior when password auth is used.

23 years agoCause transformIndexConstraints() to do the right thing with requests
Tom Lane [Mon, 22 Oct 2001 22:49:02 +0000 (22:49 +0000)]
Cause transformIndexConstraints() to do the right thing with requests
for indexes on system columns.  Per complaint from Peter.

23 years agoConsolidate tables of known system attributes into one table.
Tom Lane [Mon, 22 Oct 2001 22:47:57 +0000 (22:47 +0000)]
Consolidate tables of known system attributes into one table.

23 years agoUpdate for latest fixes.
Tom Lane [Mon, 22 Oct 2001 19:52:41 +0000 (19:52 +0000)]
Update for latest fixes.

23 years agoFurther cleanup of ps_status setup code. On platforms where the
Tom Lane [Mon, 22 Oct 2001 19:41:38 +0000 (19:41 +0000)]
Further cleanup of ps_status setup code.  On platforms where the
environment strings need to be moved around, do so when called from
initial startup (main.c), not in init_ps_status.  This eliminates the
former risk of invalidating saved environment-string pointers, since
no code has yet had a chance to grab any such pointers when main.c
is running.

23 years agoAdd defenses against invalid operator names passed in CREATE OPERATOR
Tom Lane [Mon, 22 Oct 2001 19:34:13 +0000 (19:34 +0000)]
Add defenses against invalid operator names passed in CREATE OPERATOR
arguments (where the parser doesn't check them already).  Minor code
cleanups too.

23 years agoRebuild cached function definition after CREATE OR REPLACE FUNCTION.
Tom Lane [Mon, 22 Oct 2001 19:32:27 +0000 (19:32 +0000)]
Rebuild cached function definition after CREATE OR REPLACE FUNCTION.
Fix typlen-vs-typmod errors inherited from pltcl.

23 years agoGenerate correct syntax for DROP OPERATOR with unary operators.
Tom Lane [Mon, 22 Oct 2001 19:31:09 +0000 (19:31 +0000)]
Generate correct syntax for DROP OPERATOR with unary operators.

23 years agoAdd ecpg items to HISTORY file.
Bruce Momjian [Mon, 22 Oct 2001 18:42:44 +0000 (18:42 +0000)]
Add ecpg items to HISTORY file.

23 years agoMake the CREATE TABLE ref page more readable and update some information.
Peter Eisentraut [Mon, 22 Oct 2001 18:14:47 +0000 (18:14 +0000)]
Make the CREATE TABLE ref page more readable and update some information.

23 years agosynced preproc.y with gram.y
Michael Meskes [Mon, 22 Oct 2001 17:05:56 +0000 (17:05 +0000)]
synced preproc.y with gram.y

23 years agoFix FindExec() for case where executable is found via a relative path
Tom Lane [Sun, 21 Oct 2001 03:43:54 +0000 (03:43 +0000)]
Fix FindExec() for case where executable is found via a relative path
in .:/home/postgres/testversion/bin:/opt/perl5.6.1/bin:/home/postgres/bin:/usr/local/bin:/usr/bin:/opt/ansic/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/nettladm/bin:/opt/pd/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/upgrade/bin:/opt/CC/bin:/opt/langtools/bin:/opt/graphics/phigs/bin:/opt/java/bin:/bin:/opt/imake/bin:/opt/hparray/bin:/opt/aCC/bin:/opt/lrom/bin:/usr/local/nmh/bin:. (I suppose the only common case for this is '.').

23 years agoFix getopt-vs-init_ps_display problem by copying original argv[] info,
Tom Lane [Sun, 21 Oct 2001 03:25:36 +0000 (03:25 +0000)]
Fix getopt-vs-init_ps_display problem by copying original argv[] info,
per suggestion from Peter.  Simplify several APIs by transmitting the
original argv location directly from main.c to ps_status.c, instead of
passing it down through several levels of subroutines.

23 years agoRevert change to autodetect '__getopt_initialized' variable ... turns
Tom Lane [Sat, 20 Oct 2001 17:57:39 +0000 (17:57 +0000)]
Revert change to autodetect '__getopt_initialized' variable ... turns
out glibc doesn't actually export this variable, so we need a different
solution.

23 years agoChange LIMIT #,# error message to be more generic.
Bruce Momjian [Sat, 20 Oct 2001 16:51:02 +0000 (16:51 +0000)]
Change LIMIT #,# error message to be more generic.

23 years agoRemove LIMIT #,# and suggest LIMIT # OFFSET #, per mailing list discussion.
Bruce Momjian [Sat, 20 Oct 2001 02:55:39 +0000 (02:55 +0000)]
Remove LIMIT #,# and suggest LIMIT # OFFSET #, per mailing list discussion.

23 years agoFix transposed arguments for typmod for one INTERVAL production.
Thomas G. Lockhart [Sat, 20 Oct 2001 01:02:22 +0000 (01:02 +0000)]
Fix transposed arguments for typmod for one INTERVAL production.
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.

23 years agoFix plperl to discard cached function definition after CREATE OR
Tom Lane [Fri, 19 Oct 2001 22:43:49 +0000 (22:43 +0000)]
Fix plperl to discard cached function definition after CREATE OR
REPLACE FUNCTION.  Clean up typlen/typmod errors inherited from pltcl.

23 years agoProper fix for glibc getopt() botch. Surprising we did not see this
Tom Lane [Fri, 19 Oct 2001 20:47:09 +0000 (20:47 +0000)]
Proper fix for glibc getopt() botch.  Surprising we did not see this
before.

23 years agoFix a lot of confusion between typlen and typmod. Didn't hurt too much
Tom Lane [Fri, 19 Oct 2001 19:43:19 +0000 (19:43 +0000)]
Fix a lot of confusion between typlen and typmod.  Didn't hurt too much
back when only varlena types paid any attention to typmod ...

23 years agoSet optreset on platforms that have it before launching postmaster
Tom Lane [Fri, 19 Oct 2001 18:19:41 +0000 (18:19 +0000)]
Set optreset on platforms that have it before launching postmaster
subprocesses; perhaps this will fix portability problem just noted by
Lockhart.  Also, move test for bad permissions of DataDir to a more
logical place.

23 years agoEnsure that all startup paths (postmaster, standalone postgres, or
Tom Lane [Fri, 19 Oct 2001 17:03:08 +0000 (17:03 +0000)]
Ensure that all startup paths (postmaster, standalone postgres, or
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.

23 years agoRename macro arg to avoid useless compiler warning when building plperl.
Tom Lane [Fri, 19 Oct 2001 15:38:57 +0000 (15:38 +0000)]
Rename macro arg to avoid useless compiler warning when building plperl.

23 years agoWithout this patch I couldn't compile PostgreSQL on Solaris 8 x86 using
Bruce Momjian [Fri, 19 Oct 2001 15:06:48 +0000 (15:06 +0000)]
Without this patch I couldn't compile PostgreSQL on Solaris 8 x86 using
Sun's compiler. May be it will be usefull for someone else?

Denis Ustimenko

23 years ago> This stops the interface from leaking the row tuples (and thus the
Bruce Momjian [Fri, 19 Oct 2001 15:00:26 +0000 (15:00 +0000)]
> This stops the interface from leaking the row tuples (and thus the
> results of every fetch).

Stephen Robert Norris

23 years agoUpdate TODO list.
Bruce Momjian [Fri, 19 Oct 2001 14:59:04 +0000 (14:59 +0000)]
Update TODO list.

23 years agoremoved "not fully implemented" warning for nullif
Michael Meskes [Fri, 19 Oct 2001 14:31:44 +0000 (14:31 +0000)]
removed "not fully implemented" warning for nullif

23 years agoChange SC_fetch() to not retrieve data in case the
Hiroshi Inoue [Fri, 19 Oct 2001 05:39:14 +0000 (05:39 +0000)]
Change SC_fetch() to not retrieve data in case the
SQL_RETRIEVE_DATA option is SQL_RD_OFF. This would
avoid a crash when scrolling Grid controls.

23 years agoFix pltcl to update cached function def after
Tom Lane [Fri, 19 Oct 2001 02:43:46 +0000 (02:43 +0000)]
Fix pltcl to update cached function def after
CREATE OR REPLACE FUNCTION.

23 years agoUpdate TODO list.
Bruce Momjian [Fri, 19 Oct 2001 01:30:17 +0000 (01:30 +0000)]
Update TODO list.

23 years agoTypo.
Tom Lane [Fri, 19 Oct 2001 00:46:51 +0000 (00:46 +0000)]
Typo.

23 years agoMove init_ps_display from postgres.c to postmaster.c, putting it
Tom Lane [Fri, 19 Oct 2001 00:44:08 +0000 (00:44 +0000)]
Move init_ps_display from postgres.c to postmaster.c, putting it
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.

23 years agoSpell 'between' correctly, clean up spacing in error messages.
Tom Lane [Thu, 18 Oct 2001 23:16:09 +0000 (23:16 +0000)]
Spell 'between' correctly, clean up spacing in error messages.

23 years agoFix memory leakage when sending notice messages to client.
Tom Lane [Thu, 18 Oct 2001 23:07:29 +0000 (23:07 +0000)]
Fix memory leakage when sending notice messages to client.

23 years agoFix authentication so that it doesn't record an extra 'Password
Tom Lane [Thu, 18 Oct 2001 22:44:37 +0000 (22:44 +0000)]
Fix authentication so that it doesn't record an extra 'Password
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.

23 years agoAdd STATUS_EOF value needed for auth.c. Remove a bunch of unused
Tom Lane [Thu, 18 Oct 2001 22:40:52 +0000 (22:40 +0000)]
Add STATUS_EOF value needed for auth.c.  Remove a bunch of unused
STATUS_xxx macros to reduce clutter.

23 years agoFix several problems with simple_prompt() --- the nastiest being that
Tom Lane [Thu, 18 Oct 2001 21:57:11 +0000 (21:57 +0000)]
Fix several problems with simple_prompt() --- the nastiest being that
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.

23 years agoChange error code docs to use colons.
Bruce Momjian [Thu, 18 Oct 2001 20:43:05 +0000 (20:43 +0000)]
Change error code docs to use colons.

23 years agoDocument all the ecpg error codes.
Bruce Momjian [Thu, 18 Oct 2001 20:32:58 +0000 (20:32 +0000)]
Document all the ecpg error codes.

23 years agoUpdate for new expected results.
Tom Lane [Thu, 18 Oct 2001 20:10:31 +0000 (20:10 +0000)]
Update for new expected results.

23 years agoDidn't compile on non-HAVE_TM_ZONE machines.
Tom Lane [Thu, 18 Oct 2001 19:54:59 +0000 (19:54 +0000)]
Didn't compile on non-HAVE_TM_ZONE machines.

23 years agoRepair missing brace in HAVE_INT_TIMEZONE case.
Tom Lane [Thu, 18 Oct 2001 19:52:03 +0000 (19:52 +0000)]
Repair missing brace in HAVE_INT_TIMEZONE case.

23 years agoAccept an INTERVAL argument for SET TIME ZONE per SQL99.
Thomas G. Lockhart [Thu, 18 Oct 2001 17:30:21 +0000 (17:30 +0000)]
Accept an INTERVAL argument for SET TIME ZONE per SQL99.
 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.

23 years agoExtend code that deduces implied equality clauses to detect whether a
Tom Lane [Thu, 18 Oct 2001 16:11:42 +0000 (16:11 +0000)]
Extend code that deduces implied equality clauses to detect whether a
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.

23 years agoAdded Lee Kindness' patches.
Michael Meskes [Thu, 18 Oct 2001 11:01:35 +0000 (11:01 +0000)]
Added Lee Kindness' patches.

23 years agoUpdate file for pgcrypto.
Bruce Momjian [Wed, 17 Oct 2001 00:48:24 +0000 (00:48 +0000)]
Update file for pgcrypto.

23 years agoAdd documentation about statistics collector and stats views & functions.
Tom Lane [Tue, 16 Oct 2001 23:57:06 +0000 (23:57 +0000)]
Add documentation about statistics collector and stats views & functions.

23 years agoMake sure to clean out old activity string when recycling a backend entry.
Tom Lane [Tue, 16 Oct 2001 22:35:27 +0000 (22:35 +0000)]
Make sure to clean out old activity string when recycling a backend entry.

23 years agoUse LEFT JOIN, not FULL JOIN, in statistical views.
Tom Lane [Tue, 16 Oct 2001 20:51:35 +0000 (20:51 +0000)]
Use LEFT JOIN, not FULL JOIN, in statistical views.

23 years agoUpdated the list of encodings supported to match what the backend now supports
Barry Lind [Tue, 16 Oct 2001 20:07:17 +0000 (20:07 +0000)]
Updated the list of encodings supported to match what the backend now supports

23 years agoAdded some additional comments in the code
Barry Lind [Tue, 16 Oct 2001 20:05:22 +0000 (20:05 +0000)]
Added some additional comments in the code

23 years agoPython handle as string all int8 values from postgresql. This could be
Bruce Momjian [Tue, 16 Oct 2001 13:42:57 +0000 (13:42 +0000)]
Python handle as string all int8 values from postgresql. This could be
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

23 years agoOk, here is the modified encoding table (column1 is the standard name,
Tatsuo Ishii [Tue, 16 Oct 2001 10:09:17 +0000 (10:09 +0000)]
Ok, here is the modified encoding table (column1 is the standard name,
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

23 years agoAdd a section about the planner's statistics, including a description
Tom Lane [Tue, 16 Oct 2001 01:13:44 +0000 (01:13 +0000)]
Add a section about the planner's statistics, including a description
of the new pg_stats view.

23 years agoAdd note about pg_stats to pg_statistic entry; add sections for
Tom Lane [Mon, 15 Oct 2001 22:47:47 +0000 (22:47 +0000)]
Add note about pg_stats to pg_statistic entry; add sections for
pg_largeobject, pg_listener, pg_rewrite, pg_trigger; miscellaneous
small improvements.

23 years agoDoesn't anyone test stuff before they commit it?
Tom Lane [Mon, 15 Oct 2001 20:15:09 +0000 (20:15 +0000)]
Doesn't anyone test stuff before they commit it?

23 years agoFix some portability problems (get it to compile, at least, on HP's cc)
Tom Lane [Mon, 15 Oct 2001 19:15:18 +0000 (19:15 +0000)]
Fix some portability problems (get it to compile, at least, on HP's cc)

23 years agoFix some portability problems (get it to compile, at least, on HP's cc)
Tom Lane [Mon, 15 Oct 2001 18:56:30 +0000 (18:56 +0000)]
Fix some portability problems (get it to compile, at least, on HP's cc)

23 years agoFix some portability problems (get it to compile, at least, on HP's cc)
Tom Lane [Mon, 15 Oct 2001 18:49:40 +0000 (18:49 +0000)]
Fix some portability problems (get it to compile, at least, on HP's cc)

23 years ago > Uh, isn't the correct fix
Bruce Momjian [Mon, 15 Oct 2001 18:16:31 +0000 (18:16 +0000)]
 > Uh, isn't the correct fix
 > ! $$ = 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

23 years agoUpdated regression test for tsearch, from Teodor Sigaev.
Tom Lane [Mon, 15 Oct 2001 17:41:33 +0000 (17:41 +0000)]
Updated regression test for tsearch, from Teodor Sigaev.

23 years agoPrompt for password from /dev/tty and fall back to stdin/stderr.
Bruce Momjian [Mon, 15 Oct 2001 16:40:27 +0000 (16:40 +0000)]
Prompt for password from /dev/tty and fall back to stdin/stderr.

23 years agoForgot to add this file...
Tatsuo Ishii [Mon, 15 Oct 2001 04:52:59 +0000 (04:52 +0000)]
Forgot to add this file...

23 years agoPG_DUMP NLS (Russian)
Bruce Momjian [Mon, 15 Oct 2001 02:50:16 +0000 (02:50 +0000)]
PG_DUMP NLS (Russian)

Here is another one :)
Another chunk of translated messages.
Please apply to the same file.

Serguei Mokhov

23 years agoSuggest placing audit trail on pg_shadow, not its view pg_user.
Tom Lane [Mon, 15 Oct 2001 02:02:06 +0000 (02:02 +0000)]
Suggest placing audit trail on pg_shadow, not its view pg_user.

23 years agoCommit Patrice's patches except:
Tatsuo Ishii [Mon, 15 Oct 2001 01:25:10 +0000 (01:25 +0000)]
Commit Patrice's patches except:

> - corrects a bit the UTF-8 code from Tatsuo to allow Unicode 3.1
>  characters (characters with values >= 0x10000, which are encoded on
>  four bytes).

Also, update mb/expected/unicode.out. This is necessary since the
patches affetc the result of queries using UTF-8.
---------------------------------------------------------------
Hi,

I should have sent the patch earlier, but got delayed by other stuff.
Anyway, here is the patch:

- most of the functionality is only activated when MULTIBYTE is
  defined,

- check valid UTF-8 characters, client-side only yet, and only on
  output, you still can send invalid UTF-8 to the server (so, it's
  only partly compliant to Unicode 3.1, but that's better than
  nothing).

- formats with the correct number of columns (that's why I made it in
  the first place after all), but only for UNICODE. However, the code
  allows to plug-in routines for other encodings, as Tatsuo did for
  the other multibyte functions.

- corrects a bit the UTF-8 code from Tatsuo to allow Unicode 3.1
  characters (characters with values >= 0x10000, which are encoded on
  four bytes).

- doesn't depend on the locale capabilities of the glibc (useful for
  remote telnet).

I would like somebody to check it closely, as it is my first patch to
pgsql.  Also, I created dummy .orig files, so that the two files I
created are included, I hope that's the right way.

Now, a lot of functionality is NOT included here, but I will keep that
for 7.3 :) That includes all string checking on the server side (which
will have to be a bit more optimised ;) ), and the input checking on
the client side for UTF-8, though that should not be difficult. It's
just to send the strings through mbvalidate() before sending them to
the server. Strong checking on UTF-8 strings is mandatory to be
compliant with Unicode 3.1+ .

Do I have time to look for a patch to include iso-8859-15 for 7.2 ?
The euro is coming 1. january 2002 (before 7.3 !) and over 280
millions people in Europe will need the euro sign and only iso-8859-15
and iso-8859-16 have it (and unfortunately, I don't think all Unices
will switch to Unicode in the meantime)....

err... yes, I know that this is not every single person in Europe that
uses PostgreSql, so it's not exactly 280m, but it's just a matter of
time ! ;)

I'll come back (on pgsql-hackers) later to ask a few questions
regarding the full unicode support (normalisation, collation,
regexes,...) on the server side :)

Here is the patch !

Patrice.

--
Patrice HÉDÉ ------------------------------- patrice à islande org -----
  --  Isn't it weird  how scientists  can imagine  all the matter of the
universe exploding out of a dot smaller than the head of a pin, but they
can't come up with a more evocative name for it than "The Big Bang" ?
  -- What would _you_ call the creation of the universe ?
  -- "The HORRENDOUS SPACE KABLOOIE !"               - Calvin and Hobbes
------------------------------------------ http://www.islande.org/ -----

23 years agoAdd UTF-8 char >= 0x10000 check
Tatsuo Ishii [Mon, 15 Oct 2001 01:19:15 +0000 (01:19 +0000)]
Add UTF-8 char >= 0x10000 check

23 years agoUpdate examples of type coercion rules --- some of them no longer worked
Tom Lane [Mon, 15 Oct 2001 01:00:59 +0000 (01:00 +0000)]
Update examples of type coercion rules --- some of them no longer worked
as the example claimed, because of changes elsewhere in the system.

23 years agoSynchronize with main parser's keyword list (someone didn't check his
Tom Lane [Mon, 15 Oct 2001 00:06:04 +0000 (00:06 +0000)]
Synchronize with main parser's keyword list (someone didn't check his
last commit very carefully...)

23 years agoUpdate FAQ.
Bruce Momjian [Sun, 14 Oct 2001 23:27:31 +0000 (23:27 +0000)]
Update FAQ.

23 years ago - Fixed GRANT statement.
Michael Meskes [Sun, 14 Oct 2001 12:07:57 +0000 (12:07 +0000)]
    - Fixed GRANT statement.
        - Synced preproc.y with gram.y.

23 years agoMake selectivity routines cope gracefully with NaNs, infinities, and
Tom Lane [Sat, 13 Oct 2001 23:32:34 +0000 (23:32 +0000)]
Make selectivity routines cope gracefully with NaNs, infinities, and
NUMERIC values that are out of the range of 'double'.  Per trouble
report from Mike Quinn.

23 years agoFix logic in insert() function.
Peter Eisentraut [Sat, 13 Oct 2001 19:16:32 +0000 (19:16 +0000)]
Fix logic in insert() function.

23 years agoFixing closed-path intersection logic causes this test to find more
Tom Lane [Sat, 13 Oct 2001 17:41:11 +0000 (17:41 +0000)]
Fixing closed-path intersection logic causes this test to find more
streets than it used to...

23 years agopath_inter, path_distance, path_length, dist_ppath now do the right
Tom Lane [Sat, 13 Oct 2001 17:40:24 +0000 (17:40 +0000)]
path_inter, path_distance, path_length, dist_ppath now do the right
things with closed paths --- ie, include the closing line segment in
their calculations.  Per bug report from Curtis Barrett 9-Oct-01.

23 years agoAdd missing prototype to suppress gcc warning.
Tom Lane [Sat, 13 Oct 2001 16:34:08 +0000 (16:34 +0000)]
Add missing prototype to suppress gcc warning.

23 years agoResidual cleanup from making pltcl unknown support always enabled.
Tom Lane [Sat, 13 Oct 2001 15:24:23 +0000 (15:24 +0000)]
Residual cleanup from making pltcl unknown support always enabled.

23 years agoAutoconf.
Tom Lane [Sat, 13 Oct 2001 15:20:51 +0000 (15:20 +0000)]
Autoconf.

23 years agoUpdate FAQ.
Bruce Momjian [Sat, 13 Oct 2001 05:27:05 +0000 (05:27 +0000)]
Update FAQ.

23 years agoMore keyword uppercasing.
Bruce Momjian [Sat, 13 Oct 2001 04:58:35 +0000 (04:58 +0000)]
More keyword uppercasing.

23 years agoHere are few more translated messages into Russian
Bruce Momjian [Sat, 13 Oct 2001 04:25:27 +0000 (04:25 +0000)]
Here are few more translated messages into Russian
for the PG_DUMP component.

Please apply to </src/bin/pg_dump/ru.po>

Serguei A. Mokhov

23 years agoAttached patch for unconditional enabling of pltcl-unknown support.
Bruce Momjian [Sat, 13 Oct 2001 04:23:50 +0000 (04:23 +0000)]
Attached patch for unconditional enabling of pltcl-unknown support.

Enabling this feature adds very light overhead of 1 select from pg_class on
first using of pl/tcl in backend if unknown suppport is really unused.
But pl/tcl with this support has very improved functionality.

Patch includes changes to documentation.

23 years agoUpdate FAQ.
Bruce Momjian [Sat, 13 Oct 2001 03:53:45 +0000 (03:53 +0000)]
Update FAQ.

23 years agoUpdate FAQ.
Bruce Momjian [Sat, 13 Oct 2001 03:37:42 +0000 (03:37 +0000)]
Update FAQ.

23 years agoMention createlang when language not installed, per problem report.
Bruce Momjian [Sat, 13 Oct 2001 01:35:25 +0000 (01:35 +0000)]
Mention createlang when language not installed, per problem report.

23 years agoUpdate FAQ.
Bruce Momjian [Sat, 13 Oct 2001 01:32:47 +0000 (01:32 +0000)]
Update FAQ.

23 years agoMore uppercasing.
Bruce Momjian [Fri, 12 Oct 2001 23:34:30 +0000 (23:34 +0000)]
More uppercasing.

23 years agoUppercase keywords where appropriate.
Bruce Momjian [Fri, 12 Oct 2001 23:32:34 +0000 (23:32 +0000)]
Uppercase keywords where appropriate.

23 years agotxtidx datatype for full text indexing with GiST.
Tom Lane [Fri, 12 Oct 2001 23:19:09 +0000 (23:19 +0000)]
txtidx datatype for full text indexing with GiST.
From Oleg Bartunov and Teodor Sigaev.

23 years agoFix reverse FOR loop to work properly, uppercase cleanup in file.
Bruce Momjian [Fri, 12 Oct 2001 21:19:09 +0000 (21:19 +0000)]
Fix reverse FOR loop to work properly, uppercase cleanup in file.

23 years agoRemove locale/multibyte in HISTORY file, for Tatsuo.
Bruce Momjian [Fri, 12 Oct 2001 17:46:00 +0000 (17:46 +0000)]
Remove locale/multibyte in HISTORY file, for Tatsuo.

23 years agoAdd WAL mmap() mention.
Bruce Momjian [Fri, 12 Oct 2001 17:35:10 +0000 (17:35 +0000)]
Add WAL mmap() mention.

23 years agoUpdate TODO list.
Bruce Momjian [Fri, 12 Oct 2001 17:34:36 +0000 (17:34 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Fri, 12 Oct 2001 17:33:46 +0000 (17:33 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Fri, 12 Oct 2001 17:28:41 +0000 (17:28 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Fri, 12 Oct 2001 17:23:04 +0000 (17:23 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Fri, 12 Oct 2001 16:29:36 +0000 (16:29 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Fri, 12 Oct 2001 16:14:17 +0000 (16:14 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Fri, 12 Oct 2001 16:13:48 +0000 (16:13 +0000)]
Update TODO list.

23 years agoRemove mutex mention. Fixed now.
Bruce Momjian [Fri, 12 Oct 2001 16:10:51 +0000 (16:10 +0000)]
Remove mutex mention.  Fixed now.