hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-09 00:57:47 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • 0dfc358427 Fix for memory leak in executor with fjIsNull. Bruce Momjian 1999-03-19 22:31:39 +00:00
  • bd6f98af31 I suggest the following portability patch, which does not change functionality, but makes the code more ANSI C'ish. My AIX xlc compiler barfs on all of these. Can someone please review and apply to current. Bruce Momjian 1999-03-19 18:56:43 +00:00
  • 0d01fd4e19 Add EXCEPT/INTERSECT doc changes. Bruce Momjian 1999-03-19 02:41:41 +00:00
  • 58cc2b6ead cleanup parser Bruce Momjian 1999-03-18 22:11:47 +00:00
  • 5dd9b58a86 grammar cleanup' Bruce Momjian 1999-03-18 22:03:59 +00:00
  • ddd50c440a cleanup of grammer. Bruce Momjian 1999-03-18 22:01:56 +00:00
  • 30ad427388 Fix optimizer indexing not working for negative numbers. Bruce Momjian 1999-03-18 21:39:56 +00:00
  • dc02fd709f cleanups Bruce Momjian 1999-03-18 19:59:55 +00:00
  • 7729ba073d *** empty log message *** Michael Meskes 1999-03-18 15:20:33 +00:00
  • 58118db39d Add new postgres -O option to allow system table structure changes. Bruce Momjian 1999-03-17 22:53:31 +00:00
  • 62a7754e1a grammar cleanup Bruce Momjian 1999-03-17 21:58:25 +00:00
  • cff9ba6570 INET/CIDR doc cleanup Bruce Momjian 1999-03-17 21:38:13 +00:00
  • ddc8899e6b Add docs about left-associativity of operators. Bruce Momjian 1999-03-17 21:27:02 +00:00
  • 259ca6df22 Add documentation change for %'s precidence. Bruce Momjian 1999-03-17 21:24:17 +00:00
  • 4989feaf3d Left associates all operators, instead of non-associating them. Bruce Momjian 1999-03-17 21:02:57 +00:00
  • 3b43accb0f Have % operator have precedence like /. Bruce Momjian 1999-03-17 20:17:13 +00:00
  • ebfa6ab7b0 Update sgml for 6.4.* release changes. Bruce Momjian 1999-03-16 21:03:00 +00:00
  • bfcf90600b Update nextval() code. Bruce Momjian 1999-03-16 20:15:06 +00:00
  • 89b762e509 Fix snprintf with strings, and nextval('"Aa"'); Bruce Momjian 1999-03-16 04:26:01 +00:00
  • 434762b559 Here is a patch. I have changed to call pg_exec_query_dest() instead of pg_exec_query(). Bruce Momjian 1999-03-16 03:24:18 +00:00
  • 787786085f contrib/array_iterator/array_iterator.c won't compile. Included patches should fix the problem. -- Tatsuo Ishii Bruce Momjian 1999-03-16 03:09:51 +00:00
  • 33cac03c3e autoconf Bruce Momjian 1999-03-16 03:09:09 +00:00
  • 0ab3c09356 Hmmm. It had to do with tcl/tk on FreeBSD. The configure scripts are in different directories. The patch gave the option of specifying a dir for the tk script and if they were both in the same directory then it didn't mind being empty. It's small so I'm including it. It was tested with autoconf 2.12. Bruce Momjian 1999-03-16 03:02:55 +00:00
  • d4ff6c3093 Change Does Not Exist to 'does not exist'. Bruce Momjian 1999-03-16 02:57:10 +00:00
  • 3a03e3cd30 cleanup Bruce Momjian 1999-03-15 22:20:20 +00:00
  • 75380d3eae *** empty log message *** Michael Meskes 1999-03-15 18:26:55 +00:00
  • 4b583a8a56 Allow sequence nextval actions to be case-sensitive. Bruce Momjian 1999-03-15 16:48:34 +00:00
  • b53ddbea5e Irix fix from Jeff Johnson Bruce Momjian 1999-03-15 15:20:52 +00:00
  • cd72d24e02 bool uses one byte Bruce Momjian 1999-03-15 15:00:08 +00:00
  • 1a305b7ad5 Drop buffers before destroying database files. Bruce Momjian 1999-03-15 14:07:44 +00:00
  • 25541a5cd3 LIKE cleanup. Bruce Momjian 1999-03-15 13:45:09 +00:00
  • 4a9c239063 Fix brain death in !!= operator ... it's still pretty bogus but at least now it does what it's supposed to do ... Tom Lane 1999-03-15 03:24:32 +00:00
  • 265c283e1b > > > This patches src/bin/psql/psql.c. > > > > > > This patch is in responce to the following TODO list item: > > > * have psql \d on a view show the query > > > -Ryan Bruce Momjian 1999-03-15 02:18:37 +00:00
  • f621b85a2a Fix int8 configure one more time ... prior version didn't define INT64_FORMAT in all cases. Tom Lane 1999-03-15 01:43:07 +00:00
  • 98ad3fcfaf Hi All, I've changed the check_primary_key() function code to allow for either the "automatic insert key rule" or "dependent insert key rule". Previously it restricted the addtion of a child entry if the corresponding parent entry was not there. Now if the option is "automatic" it will add an entry in the parent too ( it will be successful if there are no no-null fields in the parent apart from the primary key). The way to use it now is: :/* * check_primary_key () -- check that key in tuple being inserted/updated * references existing tuple in "primary" table. * Though it's called without args You have to specify referenced * table/keys while creating trigger: key field names in triggered table, * referenced table name, referenced key field names,type of action [automatic|dependent]: * EXECUTE PROCEDURE * check_primary_key ('Fkey1', 'Fkey2', 'Ptable', 'Pkey1', 'Pkey2', '[automatic|dependent]'). */ I am attaching the new ../contrib/spi/refint.c file which will do this. I will be glad to help in case of any problems. Bruce Momjian 1999-03-15 00:34:53 +00:00
  • db42533eae cleanup Bruce Momjian 1999-03-14 20:17:20 +00:00
  • 5d34abc6f1 Cleanup Bruce Momjian 1999-03-14 20:01:14 +00:00
  • d66a44a58c Reversed out libpq protocol patch for Tom Lane. Bruce Momjian 1999-03-14 18:12:21 +00:00
  • 8930699cd6 src/backend/utils/adt/numeric.c fails to compile due to a string having an embedded new-line character. Bruce Momjian 1999-03-14 16:49:32 +00:00
  • cfb7ed414d This is another example of why not allowing utility functions in SPI would be a Bad Thing. Bruce Momjian 1999-03-14 16:46:21 +00:00
  • c10e6bcbed Attempting to insert a value of 'now' into a datetime type results in a bogus datetime value under AlphaLinux. (Note that the link to submit a port-specific bug on your website is broken) Bruce Momjian 1999-03-14 16:44:02 +00:00
  • e2c4d41f32 Hi, Bruce Momjian 1999-03-14 16:42:15 +00:00
  • 80db587e7b Here is a little syntax error found in a .y file... A dropped semi. Bruce Momjian 1999-03-14 16:40:18 +00:00
  • 042ec823cf Cleanup of hash functions in pg_proc. Bruce Momjian 1999-03-14 16:32:46 +00:00
  • 1d3166d3fa compile cleanup Bruce Momjian 1999-03-14 16:27:59 +00:00
  • f1cdcffb05 Compile cleanup Bruce Momjian 1999-03-14 16:25:07 +00:00
  • 4c9392230a Done. Bruce Momjian 1999-03-14 16:08:17 +00:00
  • 9cab13c42e I've been having also sorts of fun trying to get kerberos 4 authentifica tion working with postgresql-6.4.2 and KTH-KRB Ebones (http://www.pdc.kth.se/kth-kr b) on a dec alpha running DU 4.0D using the native compiler. The following patch does the trick. Bruce Momjian 1999-03-14 16:06:43 +00:00
  • aba8c12f67 We have tested the patches on three platforms: Bruce Momjian 1999-03-14 16:03:33 +00:00
  • e94fffc1c1 This patch improves the destroyuser script's behaviour in checking whether the user is allowed to detroy users. It also allows for a possible incorrect empty reply to a yes/no question. Bruce Momjian 1999-03-14 16:00:55 +00:00
  • f45ec44c6b Patches for the SGML documentation relating to the tutorial code changes. Bruce Momjian 1999-03-14 15:24:15 +00:00
  • 344190b7ef Fixup for src/tutorial/func.c and src/tutorial/func.source Bruce Momjian 1999-03-14 15:22:15 +00:00
  • f6a9ed0445 Hello, Bruce Momjian 1999-03-14 05:23:12 +00:00
  • 983fc97672 The isWritable method in ResultSetMetaData returns the logically incorrect result. This bug goes back to at least 6.3. Bruce Momjian 1999-03-14 05:18:00 +00:00
  • d13fe29000 I have a problem with Access97 not working properly when entering new records using a sub form, i.e. entering a new order/orderlines or master and detail tables. The problem is caused by a SQL statement that Access97 makes involving NULL. The syntax that fails is "column_name" = NULL. The following attachment was provided by -Jose'-. It contains a very small enhancement to gram.y that will allow Access97 to work properly with sub forms. Can this enhancement be added to release 6.5? Bruce Momjian 1999-03-14 05:15:08 +00:00
  • fd80c102fa There are errors in the PGmoney class in the conversion routines over the handling of negative numbers and commas. The attached path attempts to fix these. However the getValue method does not yet insert commas into the generated string. Also in getValue there is an incorrect assumption that the currency symbol is '$', it should of course be '£'!. I have no idea on how to go about fixing this one. Bruce Momjian 1999-03-14 05:12:45 +00:00
  • 817a3e6d39 Enclosed below I have a patch to allow a btree index on the int8 type. Bruce Momjian 1999-03-14 05:09:05 +00:00
  • f9f458be10 *** empty log message *** Michael Meskes 1999-03-11 15:42:08 +00:00
  • 2a76aa23e0 We have to return dummy tuple for empty targetlist! Try select t1.x from t1, t2 where t1.y = 1 and t2.y = 1 - t2 scan target list will be empty and so no one tuple will be returned... Vadim B. Mikheev 1999-03-10 12:16:09 +00:00
  • f8f0efb43d Make type 'regproc' binary-compatible with int4 and oid, so that it has some SQL operators available. It's difficult to write automated tests of a data type that you haven't even got == for... Tom Lane 1999-03-10 05:05:58 +00:00
  • 3bca9c6c4b Fix some typos in argument and result types in pg_proc and pg_operator. The lone error in pg_operator was reported as a bug by Michael Reifenberger; the multiple errors in pg_proc would only have been noticed if one invoked the functions by name rather than using operator syntax. I guess few people do that. Tom Lane 1999-03-10 05:02:34 +00:00
  • 1c264e68c5 From: Constantin Teodorescu <teo@flex.ro> Marc G. Fournier 1999-03-09 14:17:51 +00:00
  • f34240de06 Changes to fix/improve the dynamic loading on NT Marc G. Fournier 1999-03-09 13:39:15 +00:00
  • f7430af934 Fix OR index selectivity problem. Bruce Momjian 1999-03-08 14:01:57 +00:00
  • c831d08fac Fix for Alpha OR selectivity bug. Bruce Momjian 1999-03-08 13:35:50 +00:00
  • 75007a72d6 Have configure check for use of %lld for int64, and if that fails, check for use of %qd...a more generic solution then having #ifdef __<INSERT OS HERE>__ in the code... Marc G. Fournier 1999-03-08 04:17:33 +00:00
  • a431aaec44 Export include/utils/mcxt.h so that external stuff can include palloc.h again. Move exporting of backend header files out of libpq's Makefile (whatever was it doing there in the first place?) and into backend/Makefile. Tom Lane 1999-03-07 23:05:57 +00:00
  • 86c2eadb18 Modify mcxt.h so that it doesn't pull in half of creation. Tom Lane 1999-03-07 23:03:32 +00:00
  • dffb88b024 Cleaner autoconf tests for int8 support. Tom Lane 1999-03-07 21:32:06 +00:00
  • a564d2bf0f geqo now at 11 tables Bruce Momjian 1999-03-07 12:00:40 +00:00
  • 6f66fd8c2e *** empty log message *** Michael Meskes 1999-03-07 08:01:18 +00:00
  • 60bb92af33 Really remove Recipe. Bruce Momjian 1999-03-07 03:34:11 +00:00
  • 2ecbf94430 Retrofit hashtable and shared-mem-size-estimation bug fixes into REL6_4. github/REL6_4 REL6_4 Tom Lane 1999-03-07 02:01:09 +00:00
  • 0fda84bfcd Oops, looks like my local copy of dt.c conflicted with Thomas' changes... Tom Lane 1999-03-07 01:35:35 +00:00
  • 6c51355612 Eliminate duplicated code in dt.h Tom Lane 1999-03-06 22:58:11 +00:00
  • 93c7e5026a Correct compile failures in REL6_4 datetime code. Tom Lane 1999-03-06 22:49:03 +00:00
  • d19fc4cacb Reduce DEF_MAXBACKENDS to 32 so that default configuration is less likely to fail for lack of semaphores. Tom Lane 1999-03-06 21:25:04 +00:00
  • 731603a92b A few further tweaks to shared memory space estimation. This change brings the default size of the main shmem block back under 1MB, which is a fairly popular value for the kernel's SHMMAX parameter. Tom Lane 1999-03-06 21:17:56 +00:00
  • 03842eb03b *** empty log message *** Michael Meskes 1999-03-05 09:38:51 +00:00
  • 9db6b7f3f7 *** empty log message *** Michael Meskes 1999-03-05 09:25:34 +00:00
  • 35336849e7 A fix for the int8 problem under FreeBSD ... if __FreeBSD__ is defined, then use %qd vs %lld ... Marc G. Fournier 1999-03-04 15:40:16 +00:00
  • 5e73ab70e6 Move common date/time macros to a central place. Thomas G. Lockhart 1999-03-03 05:11:39 +00:00
  • e0345e09bf Partial fix for copied-plan bugs reported by Hiroshi Inoue: _copyResult didn't copy subPlan structure completely. _copyAgg is still busted, apparently because of changes from EXCEPT/INTERSECT patch (get_agg_tlist_references is no longer sufficient to find all aggregates). No time to look at that tonight, however. Tom Lane 1999-03-03 00:02:42 +00:00
  • b204d10c79 Executor no longer cares about mergejoinop, mergerightorder, mergeleftorder, so remove them from MergeJoin node. Hack together a partial solution for commuted mergejoin operators --- yesterday a mergejoin int4 = int8 would crash if the planner decided to commute it, today it works. The planner's representation of mergejoins really needs a rewrite though. Also, further testing of mergejoin ops in opr_sanity regress test. Tom Lane 1999-03-01 00:10:44 +00:00
  • d077c61492 From: Michael Meskes <Michael_Meskes@topmail.de> Marc G. Fournier 1999-02-28 07:25:34 +00:00
  • 51f0f6ddc8 Fix pg_operator entries for mergejoinable operators with different left and right side data types. Correct the opr_sanity regress test to check these entries properly. NOTE that opr_sanity will now fail until you do an initdb! Tom Lane 1999-02-28 00:56:42 +00:00
  • dc77be0432 Fix executor to work correctly with mergejoins where left and right sides have different data types. Tom Lane 1999-02-28 00:36:05 +00:00
  • 98f739454c Remove recipe.o from Makefile ... dead code not quite dead enough, it seems. Tom Lane 1999-02-27 21:42:33 +00:00
  • 1e006ba2ad Put back T_RecipeStmt, since the system doesn't actually build without it. Sloppy, sloppy. Tom Lane 1999-02-27 21:40:39 +00:00
  • b775655e8a Someone forgot to commit gram.c and parse.h after his latest set of updates to gram.y. Tom Lane 1999-02-27 21:33:53 +00:00
  • c438520b91 Remove reference to recipe.h. Bruce Momjian 1999-02-25 17:25:47 +00:00
  • 6df955fd3b Fix problem with selectivity error in added columns with ALTER TABLE. Move files to deadcode. Bruce Momjian 1999-02-24 17:29:06 +00:00
  • f3f7c2acde update comments Bruce Momjian 1999-02-24 10:20:07 +00:00
  • 02fa3e4394 Thank you for the advice. I concluded that current inet code has a portability problem. Included patches should be applied to both current and 6.4 tree. I have tested on LinuxPPC, FreeBSD and Solaris 2.6. Now the inet regression tests on these platforms are all happy. --- Tatsuo Ishii Bruce Momjian 1999-02-24 03:17:05 +00:00
  • fa9db42a6e From: Michael Meskes <Michael_Meskes@topmail.de> Marc G. Fournier 1999-02-23 12:57:03 +00:00
  • e17d8448f2 Add parameters to function calls to pass back table qualifications. Thomas G. Lockhart 1999-02-23 08:05:27 +00:00
  • 9fd28029eb Add a few other parser-only nodes for debugging help. Define the JoinExpr node. Thomas G. Lockhart 1999-02-23 08:01:47 +00:00
  • 0a8e9c4e7f Define JoinExpr structure for outer join syntax. Clean up comments in execnodes.h. Thomas G. Lockhart 1999-02-23 07:55:24 +00:00
  • 70600bd6f1 Clean up error messages. Thomas G. Lockhart 1999-02-23 07:54:03 +00:00
  • 681c587d22 Do a better job of selecting candidates among functions when no exact match. Clean up elog error messages. Thomas G. Lockhart 1999-02-23 07:51:53 +00:00