OSDN Git Service
Tom Lane [Sun, 27 Feb 2000 21:07:03 +0000 (21:07 +0000)]
Correct bogus syntax in SET example.
Tom Lane [Sun, 27 Feb 2000 19:45:44 +0000 (19:45 +0000)]
Avoid a little bit of unnecessary computation in canonicalize_qual.
Bruce Momjian [Sun, 27 Feb 2000 19:04:06 +0000 (19:04 +0000)]
Update TODO list.
Tom Lane [Sun, 27 Feb 2000 18:54:43 +0000 (18:54 +0000)]
Add lztext to TypeCategory so that lztext OP text cases will work
correctly (the lztext value will be promoted to text automatically).
Tom Lane [Sun, 27 Feb 2000 18:06:28 +0000 (18:06 +0000)]
Jan forgot to increment catversion when adding lztext. Naughty naughty.
Bruce Momjian [Sun, 27 Feb 2000 14:57:16 +0000 (14:57 +0000)]
Update history
Jan Wieck [Sun, 27 Feb 2000 12:02:34 +0000 (12:02 +0000)]
Reactivated LZTEXT data type and changed rule plan- and qual-strings
into lztext.
Jan
Tatsuo Ishii [Sun, 27 Feb 2000 10:21:16 +0000 (10:21 +0000)]
Update expected files due to the psql format change
Tatsuo Ishii [Sun, 27 Feb 2000 10:20:13 +0000 (10:20 +0000)]
Suppress unneccesary message from createdb
Tatsuo Ishii [Sun, 27 Feb 2000 10:15:17 +0000 (10:15 +0000)]
Add SQL_ASCII test case
Tatsuo Ishii [Sun, 27 Feb 2000 10:14:33 +0000 (10:14 +0000)]
Fix multibyte regress results for EUC_CN, EUC_KR and EUC_TW
Tatsuo Ishii [Sun, 27 Feb 2000 10:13:22 +0000 (10:13 +0000)]
Add LinuxPPC mappings
Tom Lane [Sun, 27 Feb 2000 07:44:22 +0000 (07:44 +0000)]
Clean up badly-formatted error messages from pg_connect.
Tom Lane [Sun, 27 Feb 2000 07:31:00 +0000 (07:31 +0000)]
Add Assert() to check for trying to heap_close a relation when the
relcache entry's reference count is zero.
Tom Lane [Sun, 27 Feb 2000 07:18:29 +0000 (07:18 +0000)]
Add 'volatile' declarations to silence gcc warnings about longjmp.
Shouldn't create any portability problems, since we have a configure
test to #define away volatile if the compiler doesn't support it.
Tom Lane [Sun, 27 Feb 2000 03:30:27 +0000 (03:30 +0000)]
Minor improvements in regprocout() and oidvectortypes().
Tom Lane [Sun, 27 Feb 2000 02:48:15 +0000 (02:48 +0000)]
Fix poorly worded error messages for unary operator type resolution
failures. Fix some outright bugs too, including a reference to
uninitialized memory that would cause failures like this one:
select -('
1234567890.
1234567'::text);
ERROR: Unable to locate type oid
2139062143 in catalog
Tom Lane [Sun, 27 Feb 2000 01:33:43 +0000 (01:33 +0000)]
Clean up dependencies for version.o.
This avoids the useless rebuild of pg_version that used to happen on
each build or install pass.
Tom Lane [Sun, 27 Feb 2000 01:26:12 +0000 (01:26 +0000)]
Clean up dependencies for version.o.
Tom Lane [Sun, 27 Feb 2000 01:18:46 +0000 (01:18 +0000)]
Clean up dependencies for version.o.
Tom Lane [Sun, 27 Feb 2000 01:10:31 +0000 (01:10 +0000)]
Fix a couple of inconsistent usages of include <...> vs. include "...".
Bruce Momjian [Sat, 26 Feb 2000 23:22:41 +0000 (23:22 +0000)]
Add 7.0 changes to HISTORY file. This has to go into SGML eventually,
but we should get it out to beta testers.
Tom Lane [Sat, 26 Feb 2000 23:03:12 +0000 (23:03 +0000)]
Add date and time datatype handling to convert_to_scalar. (I was waiting
for Thomas to do the datetime consolidation before touching this, but
it's done now...)
Tom Lane [Sat, 26 Feb 2000 21:13:18 +0000 (21:13 +0000)]
Change rule dumper to produce reasonable output for casts that assign
a specific length or precision, such as foo::char(8). Remove erroneous
removal of user-written casts at the top level of a SELECT target item.
Tom Lane [Sat, 26 Feb 2000 21:11:10 +0000 (21:11 +0000)]
Fix exprTypmod to recognize length-coercion function expressions,
such as bpchar(char_expression, N), and pull out the attrtypmod that
the function is coercing to. This allows correct deduction of the
column type in examples such as
CREATE VIEW v AS SELECT f1::char(8) FROM tbl;
Formerly we labeled v's column as char-of-unknown-length not char(8).
Also, this change causes the parser not to insert a redundant length
coercion function if the user has explicitly casted an INSERT or UPDATE
expression to the right length.
Tom Lane [Sat, 26 Feb 2000 18:31:25 +0000 (18:31 +0000)]
psql's \d command wasn't doing the right things with 'char' (type 18)
fields, nor with bpchar and varchar fields that have typmod -1. The
latter effectively have an unspecified length, so I made them display
as char() and varchar() rather than falsely equating them to char(1)
and varchar(1).
Tom Lane [Sat, 26 Feb 2000 18:13:41 +0000 (18:13 +0000)]
I had managed to break acceptance of "char", which worked in 6.5 to
refer to the single-byte char type. 7.0 was taking it as bpchar(1).
Tom Lane [Sat, 26 Feb 2000 06:36:44 +0000 (06:36 +0000)]
Undo a couple of mistaken applications of NameStr() to StringInfos.
It worked, because they both have fields named 'data', but it's surely
trouble waiting to happen. I wonder whether there are more ...
Tom Lane [Sat, 26 Feb 2000 05:25:55 +0000 (05:25 +0000)]
Shared-memory hashtables have non-extensible directories, which means
it's a good idea to choose the directory size based on the expected
number of entries. But ShmemInitHash was using a hard-wired constant.
Boo hiss. This accounts for recent report of postmaster failure when
asking for 64K or more buffers.
Michael Meskes [Fri, 25 Feb 2000 15:26:12 +0000 (15:26 +0000)]
*** empty log message ***
Michael Meskes [Fri, 25 Feb 2000 11:11:15 +0000 (11:11 +0000)]
*** empty log message ***
Bruce Momjian [Fri, 25 Feb 2000 03:24:28 +0000 (03:24 +0000)]
Update TODO list.
Tom Lane [Fri, 25 Feb 2000 02:58:48 +0000 (02:58 +0000)]
Fix longstanding bug that kept functional indexes from working when you
defaulted the opclass. This addresses TODO item
* Allow creation of functional indexes to use default types
(Does that make it a feature? Oh dear...)
Peter Eisentraut [Thu, 24 Feb 2000 23:37:30 +0000 (23:37 +0000)]
Enabled regression driver to run without PGLIB set.
Bruce Momjian [Thu, 24 Feb 2000 16:34:21 +0000 (16:34 +0000)]
Suppress timespan and datetime ops from being brought in via pg_dump
from previous release.
Bruce Momjian [Thu, 24 Feb 2000 16:02:28 +0000 (16:02 +0000)]
Add missing files like foreign key regression tests and config.h.win32.
Bruce Momjian [Thu, 24 Feb 2000 15:53:12 +0000 (15:53 +0000)]
The following is required in order to make beta1 compile on the Win32
platform (psql and libpq):
The file "config.h.win32" in the include\ directory (from my patch from
2000-01-18) is missing from the tree. It needs to be put back :-)
The following patch has to be applied in the interfaces\libpq directory.
//Magnus
Tom Lane [Thu, 24 Feb 2000 04:50:51 +0000 (04:50 +0000)]
Tweak libpq so that if a backend ERROR message arrives while libpq
thinks the connection is idle, the error message is displayed as if
it were a NOTICE. This seems better than dropping the message on
the floor ... particularly if the message is the backend telling us
why it's about to close the connection. The previous behavior was
Backend message type 0x45 arrived while idle
pqReadData() -- backend closed the channel unexpectedly.
which is not real helpful.
Hiroshi Inoue [Thu, 24 Feb 2000 04:36:01 +0000 (04:36 +0000)]
Check pending cancel request before waiting for lock
Hiroshi Inoue [Thu, 24 Feb 2000 04:34:38 +0000 (04:34 +0000)]
Add the check CommonSpecialPortal in use(my fault)
Tom Lane [Thu, 24 Feb 2000 02:05:30 +0000 (02:05 +0000)]
Add numeric <-> int8 and numeric <-> int2 conversion functions, as well
as a unary minus operator for numeric. Now that long numeric constants
will get converted to NUMERIC in early parsing, it's essential to have
numeric->int8 conversion to avoid 'can't convert' errors on undecorated
int8 constants. Threw in the rest for completeness while I was in the
area.
I did not force an initdb for this, since the system will still run
without the new pg_proc/pg_operator entries. Possibly I should've.
Tom Lane [Thu, 24 Feb 2000 01:59:17 +0000 (01:59 +0000)]
Make make_const() check the size and precision of a T_Float Value,
and produce either FLOAT8 or NUMERIC output depending on whether the
value fits in a float8 or not. This is almost back to the way the
code was before I changed T_Float, but there is a critical difference:
now, when a numeric constant doesn't fit in float8, it will be treated
as type NUMERIC instead of type UNKNOWN.
Tom Lane [Thu, 24 Feb 2000 01:54:40 +0000 (01:54 +0000)]
int8in failed to detect overflow; it really should.
Bruce Momjian [Wed, 23 Feb 2000 22:24:46 +0000 (22:24 +0000)]
Fix plpsql for bsdi.
Michael Meskes [Wed, 23 Feb 2000 19:26:05 +0000 (19:26 +0000)]
*** empty log message ***
Bruce Momjian [Wed, 23 Feb 2000 15:46:15 +0000 (15:46 +0000)]
1. miscadmin.h needs to include sys/types.h for a definition of pid_t
2. Regression tests fail for types int2 and int4 (which can easily be
fixed by adding entries to resultmap) aswell as float8 and geometry,
where floating point numbers appear to be rounded a little differently
than in your expected results (besides that I also need the positive
zeros file). I'm including a patch for the first 2, but I don't know
whether the latter two are actually a bug in postgres or a bug in the
OS or even allowed difference. I'm including my results for reference.
Rolf Grossmann
Bruce Momjian [Tue, 22 Feb 2000 20:58:31 +0000 (20:58 +0000)]
Well, here's the first pass on regression
tests for the Foreign Key support in 7.0 which
was made against a CVS copy from this
afternoon.
This modifies
src/test/regress/sql/run_check.tests
src/test/regress/sql/alter_table.sql
src/test/regress/expected/alter_table.out
src/test/regress/sql/foreign_key.sql
src/test/regress/expected/foreign_key.out
sszabo@bigpanda.co
Michael Meskes [Tue, 22 Feb 2000 19:57:12 +0000 (19:57 +0000)]
*** empty log message ***
Bruce Momjian [Tue, 22 Feb 2000 14:16:36 +0000 (14:16 +0000)]
Update TODO list.
Bruce Momjian [Tue, 22 Feb 2000 14:08:12 +0000 (14:08 +0000)]
Update TODO list.
Hiroshi Inoue [Tue, 22 Feb 2000 09:55:26 +0000 (09:55 +0000)]
Change cancel while waiting-for-lock stuff.
Bruce Momjian [Tue, 22 Feb 2000 00:58:51 +0000 (00:58 +0000)]
Update TODO list.
Tom Lane [Tue, 22 Feb 2000 00:05:04 +0000 (00:05 +0000)]
First post-beta1 bug fix :-(. Silly typo in new coding for doNegate
failed to negate a negative value back to positive, so '- - 123.45'
did the wrong thing.
Tom Lane [Mon, 21 Feb 2000 20:18:11 +0000 (20:18 +0000)]
Quick hack solution so that pg_dump of views works. Needs repair after
Thomas gets back, but better this than nonfunctional pg_dump in the beta.
Peter Eisentraut [Mon, 21 Feb 2000 19:40:42 +0000 (19:40 +0000)]
Fixed psql's Control-C handling when COPY in progress
Tom Lane [Mon, 21 Feb 2000 18:49:54 +0000 (18:49 +0000)]
Oops, commited a test version of this file by accident. Revert.
Tom Lane [Mon, 21 Feb 2000 18:47:12 +0000 (18:47 +0000)]
Change parse-time representation of float literals (which include oversize
integers) to be strings instead of 'double'. We convert from string form
to internal representation only after type resolution has determined the
correct type for the constant. This eliminates loss-of-precision worries
and gets rid of the change in behavior seen at 17 digits with the
previous kluge.
Tom Lane [Mon, 21 Feb 2000 18:42:35 +0000 (18:42 +0000)]
To avoid confusion during early beta testing, commit the current rules
test output as expected output. We'll probably want to change this again
after something's done about the verbosity of column alias display.
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 ***