OSDN Git Service
Bruce Momjian [Mon, 21 Feb 2000 17:06:26 +0000 (17:06 +0000)]
Update TODO list.
Tom Lane [Mon, 21 Feb 2000 16:46:39 +0000 (16:46 +0000)]
Clean up temp file in 'make clean'.
Jan Wieck [Mon, 21 Feb 2000 12:26:19 +0000 (12:26 +0000)]
Avoid race conditions in detection of EINPROGRESS during connect().
Jan
Hiroshi Inoue [Mon, 21 Feb 2000 07:49:40 +0000 (07:49 +0000)]
Fix "Invalid XID in t_cmin" error in vacuum.
Tom Lane [Mon, 21 Feb 2000 03:36:59 +0000 (03:36 +0000)]
Clean up some really grotty coding in catcache.c, improve hashing
performance in catcache lookups.
Hiroshi Inoue [Mon, 21 Feb 2000 02:42:37 +0000 (02:42 +0000)]
fix the TODO
* Allow PQrequestCancel() to terminate when in waiting-for-lock state
Changes are limited to BACKEND,however.
Tatsuo Ishii [Mon, 21 Feb 2000 02:05:12 +0000 (02:05 +0000)]
Fixes for \encoding command.
1) freeing null pointer
2) invalid encoding info may be stored into psql variable
3) fix indentation
Tom Lane [Mon, 21 Feb 2000 01:20:41 +0000 (01:20 +0000)]
Update discussion of aggregate syntax to mention ALL.
Tom Lane [Mon, 21 Feb 2000 01:13:52 +0000 (01:13 +0000)]
Update SELECT documentation to have a more thorough discussion
of LIMIT, and fix a few other glitches too.
Tom Lane [Mon, 21 Feb 2000 01:13:04 +0000 (01:13 +0000)]
Tweak planner to use OFFSET+LIMIT, not just LIMIT, as estimate of the
portion of the query result that will be retrieved. As far as I could
tell, the consensus was that we should let the planner do the best it
can with a LIMIT query, and require the user to add ORDER BY if he
wants consistent results from different LIMIT values.
Tom Lane [Sun, 20 Feb 2000 23:04:06 +0000 (23:04 +0000)]
Further cleanups for type coercion: treat the locution typename(argument)
as representing a type coercion request in more cases than we did before.
It will work now whenever no underlying function is required, ie if the
coercion is binary-compatible or if the argument is a previously untyped
string constant. Otherwise, you still need a real function to exist.
Tom Lane [Sun, 20 Feb 2000 21:32:16 +0000 (21:32 +0000)]
Create a new expression node type RelabelType, which exists solely to
represent the result of a binary-compatible type coercion. At runtime
it just evaluates its argument --- but during type resolution, exprType
will pick up the output type of the RelabelType node instead of the type
of the argument. This solves some longstanding problems with dropped
type coercions, an example being 'select now()::abstime::int4' which
used to produce date-formatted output, not an integer, because the
coercion to int4 was dropped on the floor.
Peter Eisentraut [Sun, 20 Feb 2000 14:29:21 +0000 (14:29 +0000)]
Forgot to include the documentation for \encoding ...
Peter Eisentraut [Sun, 20 Feb 2000 14:28:28 +0000 (14:28 +0000)]
Moved psql \eset and \eshow to \encoding
Improved psql's Ctrl-C handling
Fixed configure test for sigsetjmp that now even recognizes it if it's a macro
Tom Lane [Sun, 20 Feb 2000 06:35:08 +0000 (06:35 +0000)]
Fix broken list-slinging logic in func_select_candidate and
agg_select_candidate, which could cause them to keep more candidates
than they should and thus fail to select a single match. I had
previously fixed the identical bug in oper_select_candidate, but
didn't realize that the same error was repeated over here.
Also, repair func_select_candidate's curious notion that it could
scribble on the input type-OID vector. That was causing failure to
apply necessary type coercion later on, leading to malfunction of
examples such as select date('now').
Tom Lane [Sun, 20 Feb 2000 06:28:42 +0000 (06:28 +0000)]
Even after the great date/time consolidation, TypeCategory() was still
a few bricks shy of a load concerning knowing all the date/time types.
This is real bad because it interferes with func_select_candidate()'s
willingness to disambiguate functions --- func_select_candidate() will
punt unless all the available choices have the same type category.
I think this whole mechanism needs redesigned, but in the meantime
this is a needed patch.
Tom Lane [Sun, 20 Feb 2000 04:26:35 +0000 (04:26 +0000)]
Reduce proc_exit(1) to proc_exit(0) for errors detected in backend
command line processing. As it stood, a bogus PGOPTIONS value from
a client would force a database system restart. Not bad as a denial-
of-service attack...
Tom Lane [Sun, 20 Feb 2000 02:37:40 +0000 (02:37 +0000)]
Fix missing \n in some psql_error calls.
Tom Lane [Sun, 20 Feb 2000 02:16:02 +0000 (02:16 +0000)]
Add a simple regress test for SERIAL --- it's not much,
but it's better than no test at all...
Tom Lane [Sun, 20 Feb 2000 02:14:58 +0000 (02:14 +0000)]
Fix SERIAL columns, which Thomas inadvertently broke parsing of.
Revised code probably accepts some silly combinations, but that's better
than not accepting valid ones.
Tom Lane [Sat, 19 Feb 2000 23:45:07 +0000 (23:45 +0000)]
Repair longstanding violation of SQL92 semantics: GROUP BY would
interpret a column name as an output column alias (targetlist AS name),
ather than a real column name as it ought to. According to the spec,
only ORDER BY should look at output column names. I left in GROUP BY's
willingness to use an output column number ('GROUP BY 2'), even though
this is also contrary to the spec --- again, only ORDER BY is supposed
to accept that. But there is no possible reason to want to GROUP BY
an integer constant, so keeping this old behavior won't break any
SQL-compliant queries. DISTINCT ON will behave the same as GROUP BY.
Change numerology regress test, which depended on the incorrect
behavior.
Tom Lane [Sat, 19 Feb 2000 22:13:37 +0000 (22:13 +0000)]
Apply Keith Park's updates for expected/horology-solaris-1947.out. Fix
erroneous expected output for RESET DateStyle: should be ISO now.
Fix run_check.sh so that test postmaster is started with PGDATESTYLE=ISO,
else the horology test won't pass.
Tom Lane [Sat, 19 Feb 2000 22:10:47 +0000 (22:10 +0000)]
Get rid of postgres.c's separate parsing logic for PGDATESTYLE env.
variable, instead calling same code in variable.c that is used to parse
SET DATESTYLE. Fix bug: although backend's startup datestyle had been
changed to ISO, 'RESET DATESTYLE' and 'SET DATESTYLE TO DEFAULT' didn't
know about it. For consistency I have made the latter two reset to the
PGDATESTYLE-defined initial value, which may not be the same as the
compiled-in default of ISO.
Tom Lane [Sat, 19 Feb 2000 19:37:21 +0000 (19:37 +0000)]
Accept the noise-word ALL in aggregate function invocations for SQL92
compliance. Wish they were all that easy...
Tom Lane [Sat, 19 Feb 2000 19:02:20 +0000 (19:02 +0000)]
plperl's makefile tried to use perl's choice of compiler with
postgres's choice of compiler options. Tres uncool.
Tom Lane [Sat, 19 Feb 2000 18:58:37 +0000 (18:58 +0000)]
HP's compiler objects (quite rightly too) to 'static void foo();'
followed by 'extern void foo() { ... }'.
Thomas G. Lockhart [Sat, 19 Feb 2000 08:25:49 +0000 (08:25 +0000)]
First workaround solution for Jan's column constraint attributes.
Thomas G. Lockhart [Sat, 19 Feb 2000 08:14:54 +0000 (08:14 +0000)]
Clean up markup so docs will compile.
Thomas G. Lockhart [Sat, 19 Feb 2000 08:14:33 +0000 (08:14 +0000)]
Update for new Irix info.
Tatsuo Ishii [Sat, 19 Feb 2000 05:04:54 +0000 (05:04 +0000)]
Fix nasty bug in setting client_encoding
Tatsuo Ishii [Sat, 19 Feb 2000 05:01:16 +0000 (05:01 +0000)]
Add new backslash command \eset and \eshow.
Tatsuo Ishii [Sat, 19 Feb 2000 04:59:30 +0000 (04:59 +0000)]
Fix compiler warning
Tom Lane [Sat, 19 Feb 2000 04:17:25 +0000 (04:17 +0000)]
Clean up scan.l's handling of \r vs \n --- they are reliably treated as
equivalent now, which should make Windows and Mac clients happier.
Also fix failure to handle SQL comments between segments of a multiline
quoted literal.
Tom Lane [Sat, 19 Feb 2000 02:29:07 +0000 (02:29 +0000)]
Remove gcc warnings. The Postgres world isn't really safe
for 'const' qualifiers yet ...
Tom Lane [Fri, 18 Feb 2000 23:47:31 +0000 (23:47 +0000)]
Plug some more memory leaks in the planner. It still leaks like a sieve,
but this is as good as it'll get for this release...
Michael Meskes [Fri, 18 Feb 2000 16:02:49 +0000 (16:02 +0000)]
*** empty log message ***
Michael Meskes [Fri, 18 Feb 2000 14:34:12 +0000 (14:34 +0000)]
*** empty log message ***
Hiroshi Inoue [Fri, 18 Feb 2000 09:30:20 +0000 (09:30 +0000)]
Implement reindex command
Michael Meskes [Fri, 18 Feb 2000 08:49:07 +0000 (08:49 +0000)]
*** empty log message ***
Tom Lane [Fri, 18 Feb 2000 06:32:39 +0000 (06:32 +0000)]
Replace inefficient _bt_invokestrat calls with direct calls to the
appropriate btree three-way comparison routine. Not clear why the
three-way comparison routines were being used in some paths and not
others in btree --- incomplete changes by someone long ago, maybe?
Anyway, this makes for a nice speedup in CREATE INDEX.
Peter Eisentraut [Fri, 18 Feb 2000 00:21:38 +0000 (00:21 +0000)]
Fixed handling of old --with-mb option using newly gained wisdom from
autoconf mailing list. ;)
Michael Meskes [Thu, 17 Feb 2000 19:48:58 +0000 (19:48 +0000)]
*** empty log message ***
Hiroshi Inoue [Thu, 17 Feb 2000 05:00:38 +0000 (05:00 +0000)]
Fix assert bug(was my fault)
Tom Lane [Thu, 17 Feb 2000 03:40:02 +0000 (03:40 +0000)]
Finish repairing 6.5's problems with r-tree indexes: create appropriate
selectivity functions and make the r-tree operators use them. The
estimation functions themselves are just stubs, unfortunately, but
perhaps someday someone will make them compute realistic estimates.
Change pg_am so that the optimizer can reliably tell the difference
between ordered and unordered indexes --- before it would think that
an r-tree index can be scanned in '<<' order, which is not right AFAIK.
Repair broken negator links for network_sup and related ops.
Initdb forced. This might be my last initdb force for 7.0 ... hope so
anyway ...
Tom Lane [Thu, 17 Feb 2000 02:20:59 +0000 (02:20 +0000)]
Update expected/horology-no-DST-before-1970.out to match
new datetime regress test. Someone needs to deal with fixing
expected/horology-solaris-1947.out too, assuming we still need it.
Bruce Momjian [Wed, 16 Feb 2000 23:07:31 +0000 (23:07 +0000)]
Package: postgresql
Version: 6.5.3-11
Severity: important
'char' is not a signed type by default on powerpc; therefore a character
can
never be equal to EOF (-1). A patch is attached.
Dan
/--------------------------------\ /--------------------------------\
| Daniel Jacobowitz |__| SCS Class of 2002 |
Bruce Momjian [Wed, 16 Feb 2000 21:26:00 +0000 (21:26 +0000)]
README not needed anymore.
Thomas G. Lockhart [Wed, 16 Feb 2000 18:17:02 +0000 (18:17 +0000)]
All regression tests pass except for rules.sql (unrelated).
Implement "date/time grand unification".
Transform datetime and timespan into timestamp and interval.
Deprecate datetime and timespan, though translate to new types in gram.y.
Transform all datetime and timespan catalog entries into new types.
Make "INTERVAL" reserved word allowed as a column identifier in gram.y.
Remove dt.h, dt.c files, and retarget datetime.h, datetime.c as utility
routines for all date/time types.
date.{h,c} now deals with date, time types.
timestamp.{h,c} now deals with timestamp, interval types.
nabstime.{h,c} now deals with abstime, reltime, tinterval types.
Make NUMERIC a known native type for purposes of type coersion. Not tested.
Thomas G. Lockhart [Wed, 16 Feb 2000 17:27:27 +0000 (17:27 +0000)]
All regression tests pass except for rules.sql (unrelated).
Implement "date/time grand unification".
Transform datetime and timespan into timestamp and interval.
Deprecate datetime and timespan, though translate to new types in gram.y.
Transform all datetime and timespan catalog entries into new types.
Make "INTERVAL" reserved word allowed as a column identifier in gram.y.
Remove dt.h, dt.c files, and retarget datetime.h, datetime.c as utility
routines for all date/time types.
date.{h,c} now deals with date, time types.
timestamp.{h,c} now deals with timestamp, interval types.
nabstime.{h,c} now deals with abstime, reltime, tinterval types.
Make NUMERIC a known native type for purposes of type coersion. Not tested.
Thomas G. Lockhart [Wed, 16 Feb 2000 17:26:26 +0000 (17:26 +0000)]
Implement "date/time grand unification".
Transform datetime and timespan into timestamp and interval.
Deprecate datetime and timespan, though translate to new types in gram.y.
Transform all datetime and timespan catalog entries into new types.
Make "INTERVAL" reserved word allowed as a column identifier in gram.y.
Remove dt.h, dt.c files, and retarget datetime.h, datetime.c as utility
routines for all date/time types.
date.{h,c} now deals with date, time types.
timestamp.{h,c} now deals with timestamp, interval types.
nabstime.{h,c} now deals with abstime, reltime, tinterval types.
Make NUMERIC a known native type for purposes of type coersion. Not tested.
Thomas G. Lockhart [Wed, 16 Feb 2000 17:25:49 +0000 (17:25 +0000)]
Make ISO date style (e.g. "2000-02-16 09:33") the default.
Implement "date/time grand unification".
Transform datetime and timespan into timestamp and interval.
Deprecate datetime and timespan, though translate to new types in gram.y.
Transform all datetime and timespan catalog entries into new types.
Make "INTERVAL" reserved word allowed as a column identifier in gram.y.
Remove dt.h, dt.c files, and retarget datetime.h, datetime.c as utility
routines for all date/time types.
date.{h,c} now deals with date, time types.
timestamp.{h,c} now deals with timestamp, interval types.
nabstime.{h,c} now deals with abstime, reltime, tinterval types.
Make NUMERIC a known native type for purposes of type coersion. Not tested.
Michael Meskes [Wed, 16 Feb 2000 16:18:29 +0000 (16:18 +0000)]
*** empty log message ***
Bruce Momjian [Wed, 16 Feb 2000 13:22:00 +0000 (13:22 +0000)]
include cleanup
Bruce Momjian [Wed, 16 Feb 2000 13:15:26 +0000 (13:15 +0000)]
Clean up include files use in psql.
Michael Meskes [Wed, 16 Feb 2000 11:52:25 +0000 (11:52 +0000)]
*** empty log message ***
Tom Lane [Wed, 16 Feb 2000 01:00:23 +0000 (01:00 +0000)]
If we don't have any stats for a boolean column, assume
the disbursion is 0.5, not something small.
Tom Lane [Wed, 16 Feb 2000 00:59:27 +0000 (00:59 +0000)]
Make eqsel produce better results for boolean columns,
and make scalarltsel a little more forgiving at the boundaries of the
known range of a column value.
Tom Lane [Tue, 15 Feb 2000 23:37:49 +0000 (23:37 +0000)]
Update EXPLAIN documentation to reflect the fact that the
planner now produces two cost numbers instead of one.
Tom Lane [Tue, 15 Feb 2000 23:12:26 +0000 (23:12 +0000)]
Remove long-dead code.
Tom Lane [Tue, 15 Feb 2000 23:09:08 +0000 (23:09 +0000)]
Fix missing lfirst() in ListTableAsAttrs(). This code
doesn't seem to be used at the moment, but as long as I'm looking at it...
Tom Lane [Tue, 15 Feb 2000 20:49:31 +0000 (20:49 +0000)]
New cost model for planning, incorporating a penalty for random page
accesses versus sequential accesses, a (very crude) estimate of the
effects of caching on random page accesses, and cost to evaluate WHERE-
clause expressions. Export critical parameters for this model as SET
variables. Also, create SET variables for the planner's enable flags
(enable_seqscan, enable_indexscan, etc) so that these can be controlled
more conveniently than via PGOPTIONS.
Planner now estimates both startup cost (cost before retrieving
first tuple) and total cost of each path, so it can optimize queries
with LIMIT on a reasonable basis by interpolating between these costs.
Same facility is a win for EXISTS(...) subqueries and some other cases.
Redesign pathkey representation to achieve a major speedup in planning
(I saw as much as 5X on a 10-way join); also minor changes in planner
to reduce memory consumption by recycling discarded Path nodes and
not constructing unnecessary lists.
Minor cleanups to display more-plausible costs in some cases in
EXPLAIN output.
Initdb forced by change in interface to index cost estimation
functions.
Tom Lane [Tue, 15 Feb 2000 19:45:31 +0000 (19:45 +0000)]
Change to report COPY line number in error messages affects
results of constraints regress test.
Michael Meskes [Tue, 15 Feb 2000 19:23:20 +0000 (19:23 +0000)]
*** empty log message ***
Tom Lane [Tue, 15 Feb 2000 18:17:33 +0000 (18:17 +0000)]
Silence gcc warning about uninitialized var.
Tom Lane [Tue, 15 Feb 2000 18:15:12 +0000 (18:15 +0000)]
Removed unused var to silence gcc warning.
Michael Meskes [Tue, 15 Feb 2000 12:15:57 +0000 (12:15 +0000)]
*** empty log message ***
Tom Lane [Tue, 15 Feb 2000 08:24:12 +0000 (08:24 +0000)]
Repair bogus rule display of attr lists.
Tom Lane [Tue, 15 Feb 2000 07:47:37 +0000 (07:47 +0000)]
Remove some // comments, which are not ANSI C last I heard.
Thomas G. Lockhart [Tue, 15 Feb 2000 05:22:36 +0000 (05:22 +0000)]
Rename file to be consistant with other platform-specific FAQs.
Thomas G. Lockhart [Tue, 15 Feb 2000 03:57:02 +0000 (03:57 +0000)]
Fix extraneous ending tag on libpq.sgml.
Renormalize query.sgml and fix indenting.
Thomas G. Lockhart [Tue, 15 Feb 2000 03:38:29 +0000 (03:38 +0000)]
Carry column aliases from the parser frontend. Enables queries like
SELECT a FROM t1 tx (a);
Allow join syntax, including queries like
SELECT * FROM t1 NATURAL JOIN t2;
Update RTE structure to hold column aliases in an Attr structure.
Thomas G. Lockhart [Tue, 15 Feb 2000 03:31:33 +0000 (03:31 +0000)]
Update "join syntax" test for new capabilities.
Thomas G. Lockhart [Tue, 15 Feb 2000 03:30:57 +0000 (03:30 +0000)]
Add line to mention PST8PDT time zone. Seems useful, but maybe not?
Thomas G. Lockhart [Tue, 15 Feb 2000 03:30:06 +0000 (03:30 +0000)]
Fix up error message to start with cap letter.
Thomas G. Lockhart [Tue, 15 Feb 2000 03:28:31 +0000 (03:28 +0000)]
Fix up tabbing for _int8 entry.
Thomas G. Lockhart [Tue, 15 Feb 2000 03:26:38 +0000 (03:26 +0000)]
Add "DEC" as synonym for "DECIMAL".
Add "SESSION_USER" as SQL92 keyword; equivalent to CURRENT_USER for now.
Implement column aliases (aka correlation names) and more join syntax.
Fix up indenting and tabbing.
Thomas G. Lockhart [Tue, 15 Feb 2000 03:17:09 +0000 (03:17 +0000)]
Recognize special case of POSIX time zone: "GMT+8" and "GMT-8".
Still needs to be done for the general case:
"tz+/-#" where tz is a 3 char string.
This will probably involve moving code around to other places.
Thomas G. Lockhart [Tue, 15 Feb 2000 03:00:37 +0000 (03:00 +0000)]
Fix up error and log messages.
Bruce Momjian [Mon, 14 Feb 2000 12:33:19 +0000 (12:33 +0000)]
I suspect that you are not the person to send this to, but I wasn't sure
where else to mail it. I am the maintainer of unixODBC, and we have a
set of code in our project that started life as the Postgres windows
ODBC driver, which has been ported back to unix. Anyway I have just
fixed a memory leak in the driver, and I cant see any mention of the fix
being done in the main Postgres code, so I thougth I would let you know.
Its in the statement.c module, after the COMMIT statement has been
executed in SC_Execute, the code was
Nick Gorham
Bruce Momjian [Mon, 14 Feb 2000 12:29:58 +0000 (12:29 +0000)]
Update README.NT with new NT ipc location.
Michael Meskes [Mon, 14 Feb 2000 10:00:06 +0000 (10:00 +0000)]
*** empty log message ***
Peter Eisentraut [Sun, 13 Feb 2000 21:45:15 +0000 (21:45 +0000)]
Adjusted psql echoing options (-a and -e)
Bruce Momjian [Sun, 13 Feb 2000 18:59:53 +0000 (18:59 +0000)]
contrib-array.patch
this is an old patch which I have already submitted and never seen
in the sources. It corrects the datatype oids used in some iterator
functions. This bug has been reported to me by many other people.
contrib-datetime.patch
some code contributed by Reiner Dassing <dassing@wettzell.ifag.de>
contrib-makefiles.patch
fixes all my contrib makefiles which don't work with some compilers,
as reported to me by another user.
contrib-miscutil.patch
an old patch for one of my old contribs.
contrib-string.patch
a small change to the c-like text output functions. Now the '{'
is escaped only at the beginning of the string to distinguish it
from arrays, and the '}' is no more escaped.
elog-lineno.patch
adds the current lineno of CopyFrom to elog messages. This is very
useful when you load a 1 million tuples table from an external file
and there is a bad value somehere. Currently you get an error message
but you can't know where is the bad data. The patch uses a variable
which was declared static in copy.c. The variable is now exported
and initialized to 0. It is always cleared at the end of the copy
or at the first elog message or when the copy is canceled.
I know this is very ugly but I can't find any better way of knowing
where the copy fails and I have this problem quite often.
plperl-makefile.patch
fixes a typo in a makefile, but the error must be elsewhere because
it is a file generated automatically. Please have a look.
tprintf-timestamp.patch
restores the original 2-digit year format, assuming that the two
century digits don't carry much information and that '000202' is
easier to read than
20000202. Being only a log file it shouldn't
break anything.
Please apply the patches before the next scheduled code freeze.
I also noticed that some of the contribs don't compile correcly. Should we
ask people to fix their code or rename their makefiles so that they are
ignored by the top makefile?
--
Massimo Dal Zotto
Bruce Momjian [Sun, 13 Feb 2000 13:21:11 +0000 (13:21 +0000)]
2. trigger.c fails to compile due to a syntax error. It contains
a switch statement that has an empty default label. A label of a
switch statement must be followed by a statement (or a label which
is followed by a statement (or a label which ...)).
3. Files include stringinfo.h failed to compile. The macro,
'appendStringInfoCharMacro' is implemented with a '?:' operation
that returns a void expression for the true part and a char expresion
for the false part. Both the true and false parts of the '?:' oper-
ator must return the same type.
Billy G. Allie
Peter Eisentraut [Thu, 10 Feb 2000 20:08:58 +0000 (20:08 +0000)]
Default argument for createdb
Changed EXIT_ON_ERROR to ON_ERROR_STOP in psql
Bruce Momjian [Thu, 10 Feb 2000 19:51:52 +0000 (19:51 +0000)]
Add btree indexing of boolean values
Don Baccus
Bruce Momjian [Thu, 10 Feb 2000 19:11:17 +0000 (19:11 +0000)]
Improve default compile ops.
Bruce Momjian [Thu, 10 Feb 2000 18:41:35 +0000 (18:41 +0000)]
Add no CVS to make_mkid.
Bruce Momjian [Thu, 10 Feb 2000 18:34:26 +0000 (18:34 +0000)]
Prevent tags files in cvs directory.
Bruce Momjian [Thu, 10 Feb 2000 15:47:58 +0000 (15:47 +0000)]
You will need to copy "config.h.win32" to "config.h" in the include
directory.
I think this patch to the docs should be what is needed.
Magnus Hagander
Bruce Momjian [Thu, 10 Feb 2000 04:08:25 +0000 (04:08 +0000)]
Update length to 31.
Bruce Momjian [Wed, 9 Feb 2000 20:23:26 +0000 (20:23 +0000)]
Here is the patch to add plperl to droplang.
Mark Hollomon
Bruce Momjian [Wed, 9 Feb 2000 20:09:29 +0000 (20:09 +0000)]
Update TODO list.
Bruce Momjian [Wed, 9 Feb 2000 16:23:44 +0000 (16:23 +0000)]
I checked the WinNT port yesterday (a few days old snapshot from CVS) and I
am including a patch to get it compile.
changes to psql:
- added less as default pager when compiling on Cygwin
- need to declare "filename_completion_function" because it is not exported
from readline -> added to include/port/win.h
changes to pg_id:
- include of <getopt.h>
- add .exe when installing
I think there is a problem with calling the regress tests on WinNT - it
should be called with PORTNAME not HOST as the parameter to regress.sh or
the check when to add "-h localhost" to psql has to be changed. Now it is
checked against the PORTNAME.
The results of the regress tests were OK with expected failures ;-)
Daniel Horak
Hiroshi Inoue [Wed, 9 Feb 2000 03:49:47 +0000 (03:49 +0000)]
Enable backward sequential scan even after reaching EOF.
Peter Eisentraut [Wed, 9 Feb 2000 00:21:49 +0000 (00:21 +0000)]
Fixed broken initdb --show patch
Tom Lane [Wed, 9 Feb 2000 00:10:11 +0000 (00:10 +0000)]
Ooops ... 'char c' can hold a char, but it can't hold EOF ...
Bruce Momjian [Tue, 8 Feb 2000 15:58:54 +0000 (15:58 +0000)]
yesterday I had a problem with initdb. I set bad environment values
and initdb crashs (I set pglib path to PG 6.5.3 directory instead to
7.0 and initdb take this BKI old templates ... (initdb not check
BKI version and BKI files not has any version comments (TODO?))
This patch add to the initdb --show option which show setting of all
initdb's values. It spare developers time if in setting is bug.
Karel
----------------------------------------------------------------------
Karel Zak <zakkr@zf.jcu.cz> http://home.zf.jcu.cz/~zakkr/
Bruce Momjian [Tue, 8 Feb 2000 15:57:01 +0000 (15:57 +0000)]
I'm sending patch with new version of to_char numbers formatting.
The PostgreSQL's to_char() is very compatible with Oracle's to_char
now. I hope that to_char's 3000 rows of source is without bugs, but
will good if anyone test it, for me it works very well :-)
Karel
----------------------------------------------------------------------
Karel Zak <zakkr@zf.jcu.cz> http://home.zf.jcu.cz/~zakkr/
Peter Eisentraut [Mon, 7 Feb 2000 23:10:11 +0000 (23:10 +0000)]
Fixed psql double quoting of SQL ids
Fixed libpq printing functions