Commit Graph

  • 7e533da492 Rename int4 to int32 in a few places. Bruce Momjian 2001-01-23 01:48:17 +00:00
  • 26aa69a2f6 Add threaded mention email. Bruce Momjian 2001-01-23 01:23:13 +00:00
  • 746d7e9145 Update TODO list. Bruce Momjian 2001-01-23 01:21:22 +00:00
  • fc031fbe5c Update FAQ. Bruce Momjian 2001-01-23 01:11:34 +00:00
  • c805491792 Update FAQ. Bruce Momjian 2001-01-23 01:11:06 +00:00
  • 728b0aa290 Improve realloc() per idea from Karel Zak --- if chunk to be enlarged is at end of its block, maybe we can enlarge it in-place. Tom Lane 2001-01-23 01:01:36 +00:00
  • c0bb21b369 Update FAQ. Bruce Momjian 2001-01-23 01:00:55 +00:00
  • d90703aaf2 Update TODO list. Bruce Momjian 2001-01-23 00:50:10 +00:00
  • 18f45e9aed Update TODO list. Bruce Momjian 2001-01-23 00:49:13 +00:00
  • f60e4347a8 Update TODO list. Bruce Momjian 2001-01-23 00:02:33 +00:00
  • 21a3857f1f Rip out table expression section from SQL syntax chapter and develop it into new chapter on query (SELECT) syntax. In the end this should become a narrative and example-filled counterpart to the SELECT reference page. Peter Eisentraut 2001-01-22 23:34:33 +00:00
  • e9c936ff38 Remove rangechecks on errno; just call strerror unconditionally. This eliminates a raft of portability issues, including whether sys_nerr exists, whether the platform has any valid negative errnos, etc. The downside is minimal: errno shouldn't ever contain an invalid value anyway, and if it does, reasonably modern versions of strerror will not choke. This rangecheck idea seemed good at the time, but it's clearly a net loss, and I apologize to all concerned for having ever put it in. Tom Lane 2001-01-22 23:28:52 +00:00
  • 60b282fd26 Put back old MS FAQ> Bruce Momjian 2001-01-22 22:54:07 +00:00
  • e84c429062 Clean up lockmanager data structures some more, in preparation for planned rewrite of deadlock checking. Lock holder objects are now reachable from the associated LOCK as well as from the owning PROC. This makes it practical to find all the processes holding a lock, as well as all those waiting on the lock. Also, clean up some of the grottier aspects of the SHMQueue API, and cause the waitProcs list to be stored in the intuitive direction instead of the nonintuitive one. (Bet you didn't know that the code followed the 'prev' link to get to the next waiting process, instead of the 'next' link. It doesn't do that anymore.) Tom Lane 2001-01-22 22:30:06 +00:00
  • 56f5f2bf82 Update FAQ. Bruce Momjian 2001-01-22 17:20:12 +00:00
  • 88ce6a2ba0 Synced preproc.y with gram.y and added missing include file to pgc.l. Michael Meskes 2001-01-22 17:05:50 +00:00
  • 0fada37f5d Update FAQ. Bruce Momjian 2001-01-22 16:35:35 +00:00
  • 7e0919136a Minor fixes. Tom Lane 2001-01-22 16:11:17 +00:00
  • 505cdd5873 Update FAQ. Bruce Momjian 2001-01-22 06:27:41 +00:00
  • 5f93794f1e Update FAQ. Bruce Momjian 2001-01-22 05:56:26 +00:00
  • 64b3af90f1 Add. Bruce Momjian 2001-01-22 03:47:22 +00:00
  • ede3d259fc Update. Bruce Momjian 2001-01-22 03:36:58 +00:00
  • bf01c7983b Make Kevin Lo's MS FAQ the default. Bruce Momjian 2001-01-22 03:33:55 +00:00
  • c9fe128316 Clean up per-tuple memory leaks in trigger firing and plpgsql expression evaluation. Tom Lane 2001-01-22 00:50:07 +00:00
  • 59a3a40149 All the global memory contexts should be DLLIMPORT, if any are. Tom Lane 2001-01-22 00:18:13 +00:00
  • d90eb434e4 Update FAQ. Bruce Momjian 2001-01-21 22:16:56 +00:00
  • 4f34f55d3d Description of table expressions, including join syntax, from Robert B. Easter <reaster@comptechnews.com>, heavily massaged by me. Also cleaned up value expressions a bit. Peter Eisentraut 2001-01-21 22:02:01 +00:00
  • d7d51bc138 Put quotes around environment variables. Bruce Momjian 2001-01-21 05:16:45 +00:00
  • 11d9d2cfaa Update FAQ. Bruce Momjian 2001-01-21 05:01:57 +00:00
  • b8f23aff82 Back out patch for BLOB operations until approval. Bruce Momjian 2001-01-21 03:50:25 +00:00
  • c655935217 Hello, Bruce Momjian 2001-01-21 03:49:14 +00:00
  • 023a48b811 Deal with C++ incompatibility of sys_nerr declaration by taking it out of c.h altogether, and putting it into the only places that use it (elog.c and exc.c), instead. Modify these routines to check for a NULL or empty-string return from strerror, too, since some platforms define strerror to return empty string for unknown errors (what a useless definition that is ...). Clean up some cruft in ExcPrint while at it. Tom Lane 2001-01-21 00:59:26 +00:00
  • 37fd198456 Get rid of sunos4-only strerror() macro, and arrange to use the implementation in backend/port/strerror.c if configure finds no strerror in libc, same as we do for snprintf and inet_aton. Tom Lane 2001-01-20 23:07:27 +00:00
  • 531cd44fd1 Remove no-longer-used STRERROR2 config symbol. Tom Lane 2001-01-20 22:56:33 +00:00
  • a2405d5554 Get rid of initdb -t bugs by the simple expedient of getting rid of initdb -t. This option is obsoleted by 7.1's ability to drop and recreate template1 during normal operation. Tom Lane 2001-01-20 22:09:24 +00:00
  • 74bbe8097d Replace some oldish, non-SQL'ish elements with more standard forms. (cast syntax, type names, function names, etc.) Peter Eisentraut 2001-01-20 20:59:29 +00:00
  • 8453208634 Add. Bruce Momjian 2001-01-20 18:55:35 +00:00
  • 1a02edae60 Give a good error message for what's likely to be a common syntax error, namely omitting the alias clause for a sub-SELECT in FROM. Tom Lane 2001-01-20 17:37:52 +00:00
  • e832ae337d Add emails about transaction rollover. Bruce Momjian 2001-01-20 05:00:03 +00:00
  • 5647b72e02 Update TODO list. Bruce Momjian 2001-01-20 04:59:36 +00:00
  • 9fe2255e08 Update TODO list. Bruce Momjian 2001-01-20 04:57:11 +00:00
  • 4b1e934894 Add. Bruce Momjian 2001-01-20 04:46:46 +00:00
  • 9e250f7aa3 Update TODO list. Bruce Momjian 2001-01-20 04:46:04 +00:00
  • 923513b52f Move anoncvs to top of docs, then put cvs tree. Hope that is OK. Seems more logical. Bruce Momjian 2001-01-20 04:16:55 +00:00
  • 19cba0cc1b Add missing piece of BitString support to node output functions. Expand and remove IsA_Value macro. Peter Eisentraut 2001-01-20 00:15:59 +00:00
  • d128852358 In the Programmer's Guide, the sample code for accessing large objects from libpq has two functions with memory leaks. Bruce Momjian 2001-01-20 00:05:54 +00:00
  • a7ea9f46e1 Still further tweaking of s_lock assembler: do not assume that leading whitespace is unimportant in assembly code. Also, move VAX definition of typedef slock_t to port header files to be like all the other ports. Note that netbsd.h and openbsd.h are now identical, and I rather think that freebsd.h is broken in the places where it doesn't agree --- but I'll leave it to the freebsders to look at that. Tom Lane 2001-01-20 00:03:55 +00:00
  • 58f4028518 From Jason Tishler <jt@dothill.com> Peter Eisentraut 2001-01-19 23:43:36 +00:00
  • d4067b53f1 Add. Bruce Momjian 2001-01-19 22:34:45 +00:00
  • 6ce0ed2813 Make critical sections (elog->crash) and interrupt holdoff sections into distinct concepts, per recent discussion on pghackers. Tom Lane 2001-01-19 22:08:47 +00:00
  • 75815c3100 cleanup. Bruce Momjian 2001-01-19 21:09:57 +00:00
  • 27aaf9df7e Remove ; and add \n to ASM code. Bruce Momjian 2001-01-19 20:39:16 +00:00
  • b864793e80 update Bruce Momjian 2001-01-19 19:50:04 +00:00
  • e4e64e7fef Update to reality. Peter Eisentraut 2001-01-19 19:43:27 +00:00
  • 6bb6209bee Make pqexpbuffer a little more robust, per bug report from Heinz Ekker. Tom Lane 2001-01-19 19:39:23 +00:00
  • e8990eba31 Repair circular dependencies and broken clean commands. Peter Eisentraut 2001-01-19 19:15:33 +00:00
  • d62d4c3300 Change #! /usr/local/bin/perl -w to #! /usr/bin/perl Peter Eisentraut 2001-01-19 19:06:48 +00:00
  • b7001d0f6a Change #! /usr/local/bin/python to #! /usr/bin/env python which is the recommended way. Peter Eisentraut 2001-01-19 18:35:40 +00:00
  • d239dfb4b0 Add email. Bruce Momjian 2001-01-19 18:19:34 +00:00
  • 7c89a5aa95 Add more about LRU-2. Bruce Momjian 2001-01-19 18:00:22 +00:00
  • 0ca231f736 Add to optimizer file. Bruce Momjian 2001-01-19 16:54:31 +00:00
  • d183dd6b75 Update TODO list. Bruce Momjian 2001-01-19 16:54:01 +00:00
  • 57fa481e5c Update TODO list. Bruce Momjian 2001-01-19 16:34:14 +00:00
  • de266c6d73 > > I have attached a simple change to src/pl/plperl/plperl.c to > > enable the :bash_math opcodes. Currently plperl.c only > > enables the :default opcodes. This leave out about five of six > > math functions including sqrt(). Bruce Momjian 2001-01-19 16:14:36 +00:00
  • be281916f9 Fri Jan 19 08:47:00 GMT 2001 peter@retep.org.uk - Applied patch submitted by John Schutz <schutz@austin.rr.com> that fixed a bug with ANT's SQL functions (not needed for building but nice to have fixed). Peter Mount 2001-01-19 08:49:06 +00:00
  • 8fe8fc9db0 Fix alignment Bruce Momjian 2001-01-19 07:03:53 +00:00
  • 246b5398b4 Fix univel asm alignment Bruce Momjian 2001-01-19 06:59:59 +00:00
  • 86a2c2595b Suppress compiler warning in MULTIBYTE code. Tom Lane 2001-01-19 06:57:25 +00:00
  • bdb72d8765 Suppress compiler warning in MULTIBYTE case. Tom Lane 2001-01-19 06:54:57 +00:00
  • c78e19544e Suppress unused-variable warning in non-Assert compilations. Tom Lane 2001-01-19 06:50:23 +00:00
  • 2cd23b6555 New emails. Bruce Momjian 2001-01-19 05:09:47 +00:00
  • d192236b05 Add to type conversion TODO emails. Bruce Momjian 2001-01-19 04:57:43 +00:00
  • 1073123baa Update docs to explain that 7.1 locks down LC_COLLATE and LC_CTYPE at initdb time. A few copy-editing cleanups, too. Tom Lane 2001-01-19 04:47:50 +00:00
  • 671f798cc9 Update TODO list. Bruce Momjian 2001-01-19 04:07:58 +00:00
  • cef28fd943 Add __volatile__ to all __asm__ and make consistent indenting Bruce Momjian 2001-01-19 03:58:35 +00:00
  • d7810023c5 New ASM format: Bruce Momjian 2001-01-19 02:58:59 +00:00
  • 27e618986b Update TODO list. Bruce Momjian 2001-01-19 02:53:52 +00:00
  • 9e9075b887 Update TODO list. Bruce Momjian 2001-01-19 02:05:51 +00:00
  • c0a0f34618 Fix VAX ASM '1 f' -> '1f'. Bruce Momjian 2001-01-18 23:40:26 +00:00
  • 77b347d24f Oops. Remove extra semicolon in comment. Bruce Momjian 2001-01-18 19:12:36 +00:00
  • 27677416a8 Update TODO list. Bruce Momjian 2001-01-18 18:52:20 +00:00
  • 0a12767004 Comment out xlrec in xact_redo - no support for file unlinking on commit yet. Vadim B. Mikheev 2001-01-18 18:33:45 +00:00
  • af8630f26a Forgot to cvs add UpdateableResultSet.java ;-) Peter Mount 2001-01-18 17:38:50 +00:00
  • 8bc9f0016b Thu Jan 18 17:37:00 GMT 2001 peter@retep.org.uk - Added new error message into errors.properties "postgresql.notsensitive" This is used by jdbc2.ResultSet when a method is called that should fetch the current value of a row from the database refreshRow() for example. - These methods no longer throw the not implemented but the new noupdate error. This is in preparation for the Updateable ResultSet support which will overide these methods by extending the existing class to implement that functionality, but needed to show something other than notimplemented: moveToCurrentRow() moveToInsertRow() rowDeleted() rowInserted() all update*() methods, except those that took the column as a String as they were already implemented to convert the String to an int. - getFetchDirection() and setFetchDirection() now throws "postgresql.notimp" as we only support one direction. The CursorResultSet will overide this when its implemented. - Created a new class under jdbc2 UpdateableResultSet which extends ResultSet and overides the relevent update methods. This allows us to implement them easily at a later date. - In jdbc2.Connection, the following methods are now implemented: createStatement(type,concurrency); getTypeMap(); setTypeMap(Map); - The JDBC2 type mapping scheme almost complete, just needs SQLInput & SQLOutput to be implemented. - Removed some Statement methods that somehow appeared in Connection. - In jdbc2.Statement() getResultSetConcurrency() getResultSetType() setResultSetConcurrency() setResultSetType() - Finally removed the old 6.5.x driver. Peter Mount 2001-01-18 17:37:15 +00:00
  • 45b5d792af Thu Jan 18 12:24:00 GMT 2001 peter@retep.org.uk - These methods in org.postgresql.jdbc2.ResultSet are now implemented: getBigDecimal(int) ie: without a scale (why did this get missed?) getBlob(int) getCharacterStream(int) getConcurrency() getDate(int,Calendar) getFetchDirection() getFetchSize() getTime(int,Calendar) getTimestamp(int,Calendar) getType() NB: Where int represents the column name, the associated version taking a String were already implemented by calling the int version. - These methods no longer throw the not implemented but the new noupdate error. This is in preparation for the Updateable ResultSet support which will overide these methods by extending the existing class to implement that functionality, but needed to show something other than notimplemented: cancelRowUpdates() deleteRow() - Added new error message into errors.properties "postgresql.noupdate" This is used by jdbc2.ResultSet when an update method is called and the ResultSet is not updateable. A new method notUpdateable() has been added to that class to throw this exception, keeping the binary size down. - Added new error message into errors.properties "postgresql.psqlnotimp" This is used instead of unimplemented when it's a feature in the backend that is preventing this method from being implemented. - Removed getKeysetSize() as its not part of the ResultSet API Peter Mount 2001-01-18 14:50:15 +00:00
  • 89ac643964 Fix some leaks(was my fault). Hiroshi Inoue 2001-01-18 07:29:04 +00:00
  • 6acdebbd3a Fix up "Postgres-style" time interval representation when fields have mixed-signs. Previous effort left way too many minus signs, and was at least as broken as the one before that :( Clean up "ISO-style" time interval representation to omit zero fields if there is at least one non-zero field. Supress some leading plus signs when not necessary for clarity. Replace every #ifdef __CYGWIN__ block with a cleaner TIMEZONE_GLOBAL macro defined in datetime.h. Thomas G. Lockhart 2001-01-18 07:22:43 +00:00
  • 6439de1752 Fix incorrect placeholder name in example. Thomas G. Lockhart 2001-01-18 07:18:39 +00:00
  • 26696580c4 Add "--nodata" option to allow schema conversion only. Thomas G. Lockhart 2001-01-18 07:16:56 +00:00
  • b06fbc7ad2 Fix performance issue with qualifications on VIEWs: outer query should try to push restrictions on the view down into the view subquery, so that they can become indexscan quals or what-have-you rather than being applied at the top level of the subquery. 7.0 and before were able to do this, though in a much klugier way, and I'd hate to have anyone complaining that 7.1 is stupider than 7.0 ... Tom Lane 2001-01-18 07:12:37 +00:00
  • 7705581e49 Replace contraction with long form. Cosmetic only. Thomas G. Lockhart 2001-01-18 07:11:36 +00:00
  • 787654351d Add "OK, OK, Hiroshi's right" thread. Bruce Momjian 2001-01-18 04:12:47 +00:00
  • 53ebb2286d Change LockClassinfoForUpdate() to retry mark4update() in case the tuple is already uodated. (If LockClassinfoForUpdate() is thought to be useful). Hiroshi Inoue 2001-01-18 04:01:42 +00:00
  • 5322bf46e3 Update TODO list. Bruce Momjian 2001-01-18 03:15:55 +00:00
  • 56e10b0e82 Update TODO list. Bruce Momjian 2001-01-18 03:15:26 +00:00
  • 392793b1ac Functions -> Function's Bruce Momjian 2001-01-17 22:13:33 +00:00
  • 978c03f9cf attached is a patch that makes SysV semaphore emulation using POSIX semaphores more robust on Darwin 1.2/Mac OS X Public Beta. this is for the version of 7.1 available via anon cvs as of Jan 14 2001 14:00 PST. Bruce Momjian 2001-01-17 22:11:19 +00:00
  • 5088f0748a Change lcons(x, NIL) to makeList(x) where appropriate. Bruce Momjian 2001-01-17 17:26:45 +00:00
  • 8e9840383c Change comparisons of tm->tm_isdst from "nonzero" to "greater than zero". Not sure why some were this way, and others were already correct, but it seems to have been like this for several years. This caused problems on a few damaged platforms like AIX and IRIX which do not support DST calculations for years before 1970. Thanks to Andreas Zeugswetter <ZeugswetterA@wien.spardat.at> for finding the problem. Thomas G. Lockhart 2001-01-17 16:46:56 +00:00
  • 9a342d2035 There are misprints in postgres doc., in : Chapter 10. PL/pgSQL - SQL Procedural Language (c40914117.htm) Bruce Momjian 2001-01-17 16:34:34 +00:00