hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-11 15:07:36 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • 8daa31a21e Add QNX fixes from Kardos, Dr. Andreas Bruce Momjian 2000-03-01 19:11:12 +00:00
  • 1bd6f76ed6 equalAttr() had its strcmp test backwards :-( Tom Lane 2000-03-01 18:47:43 +00:00
  • 73dd716285 Small performance improvement in comparetup_heap. Tom Lane 2000-03-01 17:14:09 +00:00
  • 8cb8da38b8 *** empty log message *** Michael Meskes 2000-03-01 12:49:43 +00:00
  • a50aaa7289 Change reindex command to work properly with gist/hash/rtree Hiroshi Inoue 2000-03-01 05:39:24 +00:00
  • ab3dc66426 Simplify parsing of column constraints by treating constraint attributes as independent clauses in the grammar. analyze.c takes care of putting the data where it belongs and complaining about invalid combinations. Also, make TEMP (and TEMPORARY) non-reserved words. Tom Lane 2000-03-01 05:18:20 +00:00
  • ea8cadbf94 Remove using puts() to print messages. Instead use TPRINTF. Tatsuo Ishii 2000-03-01 02:39:46 +00:00
  • b1e4b56144 Changed execution time of ON <event> RESTRICT referential integrity triggers to after statement allways. Ignores deferred state now, closer to SQL3 semantics. Jan Wieck 2000-02-29 12:28:25 +00:00
  • f55624a96c autoconf Bruce Momjian 2000-02-28 23:32:43 +00:00
  • da8b899d6c Update ecpg to use snprintf Bruce Momjian 2000-02-28 23:28:41 +00:00
  • 9418e701b3 Update HISTORY file. Bruce Momjian 2000-02-28 18:43:07 +00:00
  • 2a18b1507f Update TODO list. Bruce Momjian 2000-02-28 09:24:47 +00:00
  • cf1d2165b3 Fix comment spacing. Bruce Momjian 2000-02-28 08:51:43 +00:00
  • 81704b9070 update to 6.40.0009 and provide WIN32 defines for auto-configured items such as BLCKSZ and MAXPGPATHLEN? Byron Nikolaidis 2000-02-28 03:31:36 +00:00
  • dcba387636 remove extra include. Bruce Momjian 2000-02-28 02:21:17 +00:00
  • a7b1a008cd missing state transition Byron Nikolaidis 2000-02-28 00:23:18 +00:00
  • 18baa9790e Looks like I broke SET variable = DEFAULT awhile ago. Ooops. Tom Lane 2000-02-27 21:10:41 +00:00
  • 80b7955d60 Correct bogus syntax in SET example. Tom Lane 2000-02-27 21:07:03 +00:00
  • 84ccfdf087 Avoid a little bit of unnecessary computation in canonicalize_qual. Tom Lane 2000-02-27 19:45:44 +00:00
  • 8b33278450 Update TODO list. Bruce Momjian 2000-02-27 19:04:06 +00:00
  • 52a8d71203 Add lztext to TypeCategory so that lztext OP text cases will work correctly (the lztext value will be promoted to text automatically). Tom Lane 2000-02-27 18:54:43 +00:00
  • 8d0f1dd179 Jan forgot to increment catversion when adding lztext. Naughty naughty. Tom Lane 2000-02-27 18:06:28 +00:00
  • 1210bd4526 Update history Bruce Momjian 2000-02-27 14:57:16 +00:00
  • 75133d9a46 Reactivated LZTEXT data type and changed rule plan- and qual-strings into lztext. Jan Wieck 2000-02-27 12:02:34 +00:00
  • 97e38d32b8 Update expected files due to the psql format change Tatsuo Ishii 2000-02-27 10:21:16 +00:00
  • 570bb30d73 Suppress unneccesary message from createdb Tatsuo Ishii 2000-02-27 10:20:13 +00:00
  • c9ceab967c Add SQL_ASCII test case Tatsuo Ishii 2000-02-27 10:15:17 +00:00
  • 544cafb4d5 Fix multibyte regress results for EUC_CN, EUC_KR and EUC_TW Tatsuo Ishii 2000-02-27 10:14:33 +00:00
  • f30d5f9e6c Add LinuxPPC mappings Tatsuo Ishii 2000-02-27 10:13:22 +00:00
  • a065827554 Clean up badly-formatted error messages from pg_connect. Tom Lane 2000-02-27 07:44:22 +00:00
  • 750549db34 Add Assert() to check for trying to heap_close a relation when the relcache entry's reference count is zero. Tom Lane 2000-02-27 07:31:00 +00:00
  • 1e091ad601 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 2000-02-27 07:18:29 +00:00
  • f884130241 Minor improvements in regprocout() and oidvectortypes(). Tom Lane 2000-02-27 03:30:27 +00:00
  • 66fe0fc87e 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 2000-02-27 02:48:15 +00:00
  • ed0e292354 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 2000-02-27 01:33:43 +00:00
  • 22cab26131 Clean up dependencies for version.o. Tom Lane 2000-02-27 01:26:12 +00:00
  • 22a9537ff3 Clean up dependencies for version.o. Tom Lane 2000-02-27 01:18:46 +00:00
  • 01eea27c4c Fix a couple of inconsistent usages of include <...> vs. include "...". Tom Lane 2000-02-27 01:10:31 +00:00
  • a4a9976d2e Add 7.0 changes to HISTORY file. This has to go into SGML eventually, but we should get it out to beta testers. Bruce Momjian 2000-02-26 23:22:41 +00:00
  • aff830a760 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 2000-02-26 23:03:12 +00:00
  • baeef0e172 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 2000-02-26 21:13:18 +00:00
  • 7173c485c8 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 2000-02-26 21:11:10 +00:00
  • cbf4c9671e 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 2000-02-26 18:31:25 +00:00
  • 6f11af0c62 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 2000-02-26 18:13:41 +00:00
  • 664908f564 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 2000-02-26 06:36:44 +00:00
  • 08b1040374 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. Tom Lane 2000-02-26 05:25:55 +00:00
  • c05abfb1a8 *** empty log message *** Michael Meskes 2000-02-25 15:26:12 +00:00
  • 70130905d1 *** empty log message *** Michael Meskes 2000-02-25 11:11:15 +00:00
  • 94ae69f4dc Update TODO list. Bruce Momjian 2000-02-25 03:24:28 +00:00
  • 4926709563 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...) Tom Lane 2000-02-25 02:58:48 +00:00
  • 73348316e7 Enabled regression driver to run without PGLIB set. Peter Eisentraut 2000-02-24 23:37:30 +00:00
  • 46ba3f839d Suppress timespan and datetime ops from being brought in via pg_dump from previous release. Bruce Momjian 2000-02-24 16:34:21 +00:00
  • 5cdfaea899 Add missing files like foreign key regression tests and config.h.win32. Bruce Momjian 2000-02-24 16:02:28 +00:00
  • ce9f73c162 The following is required in order to make beta1 compile on the Win32 platform (psql and libpq): Bruce Momjian 2000-02-24 15:53:12 +00:00
  • 58f481c4ff 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. Tom Lane 2000-02-24 04:50:51 +00:00
  • f017d7eeee Check pending cancel request before waiting for lock Hiroshi Inoue 2000-02-24 04:36:01 +00:00
  • a5e944580f Add the check CommonSpecialPortal in use(my fault) Hiroshi Inoue 2000-02-24 04:34:38 +00:00
  • 9110b33f46 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 2000-02-24 02:05:30 +00:00
  • 512669db9e 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 2000-02-24 01:59:17 +00:00
  • 399a570fe2 int8in failed to detect overflow; it really should. Tom Lane 2000-02-24 01:54:40 +00:00
  • f40c50627f Fix plpsql for bsdi. Bruce Momjian 2000-02-23 22:24:46 +00:00
  • 9f74608f47 *** empty log message *** Michael Meskes 2000-02-23 19:26:05 +00:00
  • c969e2662f 1. miscadmin.h needs to include sys/types.h for a definition of pid_t Bruce Momjian 2000-02-23 15:46:15 +00:00
  • 020be62dea 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. Bruce Momjian 2000-02-22 20:58:31 +00:00
  • 991b9740ac *** empty log message *** Michael Meskes 2000-02-22 19:57:12 +00:00
  • 62f064592f Update TODO list. Bruce Momjian 2000-02-22 14:16:36 +00:00
  • 5d91f38a70 Update TODO list. Bruce Momjian 2000-02-22 14:08:12 +00:00
  • 5525297465 Change cancel while waiting-for-lock stuff. Hiroshi Inoue 2000-02-22 09:55:26 +00:00
  • 167dce8912 Update TODO list. Bruce Momjian 2000-02-22 00:58:51 +00:00
  • e391c15ca5 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 2000-02-22 00:05:04 +00:00
  • e1a95def8b 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. Tom Lane 2000-02-21 20:18:11 +00:00
  • c8009959c9 Fixed psql's Control-C handling when COPY in progress Peter Eisentraut 2000-02-21 19:40:42 +00:00
  • fc8e6c7746 Oops, commited a test version of this file by accident. Revert. Tom Lane 2000-02-21 18:49:54 +00:00
  • 393f313227 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 2000-02-21 18:47:12 +00:00
  • ee97d103cc 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. Tom Lane 2000-02-21 18:42:35 +00:00
  • 45e2910994 Update TODO list. Bruce Momjian 2000-02-21 17:06:26 +00:00
  • b04b55a9af Clean up temp file in 'make clean'. Tom Lane 2000-02-21 16:46:39 +00:00
  • da9501bddb Avoid race conditions in detection of EINPROGRESS during connect(). Jan Wieck 2000-02-21 12:26:19 +00:00
  • 4b4dbf8cba Fix "Invalid XID in t_cmin" error in vacuum. Hiroshi Inoue 2000-02-21 07:49:40 +00:00
  • d8cedf67ad Clean up some really grotty coding in catcache.c, improve hashing performance in catcache lookups. Tom Lane 2000-02-21 03:36:59 +00:00
  • a60c9e33e9 fix the TODO * Allow PQrequestCancel() to terminate when in waiting-for-lock state Changes are limited to BACKEND,however. Hiroshi Inoue 2000-02-21 02:42:37 +00:00
  • 320d3e06ee Fixes for \encoding command. 1) freeing null pointer 2) invalid encoding info may be stored into psql variable 3) fix indentation Tatsuo Ishii 2000-02-21 02:05:12 +00:00
  • f72aad5678 Update discussion of aggregate syntax to mention ALL. Tom Lane 2000-02-21 01:20:41 +00:00
  • a7f85783fb Update SELECT documentation to have a more thorough discussion of LIMIT, and fix a few other glitches too. Tom Lane 2000-02-21 01:13:52 +00:00
  • be05edd812 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 2000-02-21 01:13:04 +00:00
  • 07c495f5d8 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 2000-02-20 23:04:06 +00:00
  • 57b30e8e22 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. Tom Lane 2000-02-20 21:32:16 +00:00
  • bd8e071482 Forgot to include the documentation for \encoding ... Peter Eisentraut 2000-02-20 14:29:21 +00:00
  • 718bb2cc9c 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 Peter Eisentraut 2000-02-20 14:28:28 +00:00
  • 5253c518ae 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 2000-02-20 06:35:08 +00:00
  • f4d108a257 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 2000-02-20 06:28:42 +00:00
  • 4467194b44 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 2000-02-20 04:26:35 +00:00
  • e79b2dd5e7 Fix missing \n in some psql_error calls. Tom Lane 2000-02-20 02:37:40 +00:00
  • bf023bd162 Add a simple regress test for SERIAL --- it's not much, but it's better than no test at all... Tom Lane 2000-02-20 02:16:02 +00:00
  • 37a71f90b2 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 2000-02-20 02:14:58 +00:00
  • 751a14e60c 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. Tom Lane 2000-02-19 23:45:07 +00:00
  • b48f983ec3 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 2000-02-19 22:13:37 +00:00
  • f46571165d 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 2000-02-19 22:10:47 +00:00
  • bd43ae0ecd Accept the noise-word ALL in aggregate function invocations for SQL92 compliance. Wish they were all that easy... Tom Lane 2000-02-19 19:37:21 +00:00
  • 63746a90c1 plperl's makefile tried to use perl's choice of compiler with postgres's choice of compiler options. Tres uncool. Tom Lane 2000-02-19 19:02:20 +00:00