]>
granicus.if.org Git - postgresql/log
Bruce Momjian [Wed, 24 Sep 1997 23:37:26 +0000 (23:37 +0000)]
Fix for S_FREE_LOCK.
Thomas G. Lockhart [Wed, 24 Sep 1997 17:55:38 +0000 (17:55 +0000)]
Use additional ORDER BY to cope with new sorting routines.
Thomas G. Lockhart [Wed, 24 Sep 1997 17:53:53 +0000 (17:53 +0000)]
Add SQL/92 "constants" current_date, current_time, and current_timestamp.
Add SQL/92 types decimal and numeric (temporary for syntax support).
These types need more support in the backend to be really implemented,
and the parser will need to be changed at that time.
Adjust limits on precision parameters for FLOAT(p) to match IEEE-compliant
arithmetic. Perhaps these limits should be processor-specific or obtained
from system include files instead.
Thomas G. Lockhart [Wed, 24 Sep 1997 17:49:56 +0000 (17:49 +0000)]
Add SQL/92 types decimal and numeric.
Add SQL/92 "constants" current_date, current_time, and current_timestamp.
Thomas G. Lockhart [Wed, 24 Sep 1997 17:48:25 +0000 (17:48 +0000)]
Restore proper behavior for escaped quotes and for escaped literals
like newline inside quoted strings.
Thomas G. Lockhart [Wed, 24 Sep 1997 17:46:14 +0000 (17:46 +0000)]
Remove debugging "puts" print statement.
Thomas G. Lockhart [Wed, 24 Sep 1997 17:45:21 +0000 (17:45 +0000)]
Coerce type of NULL pointer return to suppress gcc compiler warnings.
Bruce Momjian [Wed, 24 Sep 1997 16:20:04 +0000 (16:20 +0000)]
Fix for pg_dump.
Bruce Momjian [Wed, 24 Sep 1997 15:57:28 +0000 (15:57 +0000)]
Update configure.
Bruce Momjian [Wed, 24 Sep 1997 15:49:46 +0000 (15:49 +0000)]
Remove aix power pc.
Bruce Momjian [Wed, 24 Sep 1997 15:40:59 +0000 (15:40 +0000)]
Remove extra float.h I added.
Bruce Momjian [Wed, 24 Sep 1997 15:36:36 +0000 (15:36 +0000)]
CREATE FUNCTION fixup for types of functions.
Bruce Momjian [Wed, 24 Sep 1997 15:14:02 +0000 (15:14 +0000)]
Rollback changes to pg_dump.c
Vadim B. Mikheev [Wed, 24 Sep 1997 08:36:47 +0000 (08:36 +0000)]
Timetravel tests.
Vadim B. Mikheev [Wed, 24 Sep 1997 08:35:10 +0000 (08:35 +0000)]
Added: ttdummy() - variation of timetravel() function
for regress test.
Vadim B. Mikheev [Wed, 24 Sep 1997 08:32:09 +0000 (08:32 +0000)]
+ SPI_palloc(), SPI_repalloc(), SPI_pfree()
Vadim B. Mikheev [Wed, 24 Sep 1997 08:31:04 +0000 (08:31 +0000)]
Allow use functions with no arguments in DEFAULT
Allow use IDENT as arguments of trigger functions
Vadim B. Mikheev [Wed, 24 Sep 1997 08:28:37 +0000 (08:28 +0000)]
+ SPI_palloc(), SPI_repalloc(), SPI_pfree() - for allocations
in upper Executor memory context.
Vadim B. Mikheev [Wed, 24 Sep 1997 08:17:14 +0000 (08:17 +0000)]
General trigger functions for time-travel
Bruce Momjian [Wed, 24 Sep 1997 04:20:29 +0000 (04:20 +0000)]
HPUX 10 patch.
Bruce Momjian [Wed, 24 Sep 1997 03:20:54 +0000 (03:20 +0000)]
Add -S to top of manual page.
Bruce Momjian [Tue, 23 Sep 1997 22:53:47 +0000 (22:53 +0000)]
AIX fixes.
Bruce Momjian [Tue, 23 Sep 1997 21:44:07 +0000 (21:44 +0000)]
Fix for CREATE FUNCTION.
Bruce Momjian [Tue, 23 Sep 1997 19:47:59 +0000 (19:47 +0000)]
Fix for backslash quote.
Bruce Momjian [Tue, 23 Sep 1997 17:43:33 +0000 (17:43 +0000)]
AIx patch from Frank Dana.
Bruce Momjian [Tue, 23 Sep 1997 00:02:44 +0000 (00:02 +0000)]
Cleanup.
Bruce Momjian [Mon, 22 Sep 1997 18:14:25 +0000 (18:14 +0000)]
Cleanup backslashes.
Bruce Momjian [Mon, 22 Sep 1997 15:59:19 +0000 (15:59 +0000)]
Fix for missing tas on some platforms.
Bruce Momjian [Mon, 22 Sep 1997 15:49:14 +0000 (15:49 +0000)]
Small lock cleanup for prototype.
Vadim B. Mikheev [Mon, 22 Sep 1997 07:13:56 +0000 (07:13 +0000)]
Blowaway relation buffers from buffer pool before truncation:
+ BlowawayRelationBuffers(relation, blocknumber)
Vadim B. Mikheev [Mon, 22 Sep 1997 07:12:33 +0000 (07:12 +0000)]
Blowaway relation buffers from buffer pool before truncation.
Vadim B. Mikheev [Mon, 22 Sep 1997 04:21:51 +0000 (04:21 +0000)]
Two copies...
Vadim B. Mikheev [Mon, 22 Sep 1997 04:20:53 +0000 (04:20 +0000)]
Have to PROC_INCR_SLOCK before return.
Vadim B. Mikheev [Mon, 22 Sep 1997 04:19:36 +0000 (04:19 +0000)]
Fix: Operand Order Affects OR.
where x <> 1 or x isnull
didn't return tuples with x NULL.
Vadim B. Mikheev [Mon, 22 Sep 1997 03:58:32 +0000 (03:58 +0000)]
+#include <access/xact.h>
Bruce Momjian [Sun, 21 Sep 1997 22:54:19 +0000 (22:54 +0000)]
Configure OS cleanup.
Bruce Momjian [Sun, 21 Sep 1997 04:54:36 +0000 (04:54 +0000)]
Make manual page for pg_passwd from README.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:37:02 +0000 (16:37 +0000)]
Output changed for new ORDER BY to cope with new sorting routines.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:35:34 +0000 (16:35 +0000)]
Output changed to reflect extra entries from new regression tests.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:34:08 +0000 (16:34 +0000)]
Change ORDER BY to get consistant results with new sorting routines.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:33:24 +0000 (16:33 +0000)]
Update results count to reflect bad entries now being rejected by new decoder.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:31:44 +0000 (16:31 +0000)]
Change ORDER BY to get more consistant results.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:29:38 +0000 (16:29 +0000)]
Add tinterval comparison operators.
Add integer/money arithmetic.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:25:28 +0000 (16:25 +0000)]
Add point_ne() comparison routine.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:24:39 +0000 (16:24 +0000)]
Add tinterval comparison routines.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:23:47 +0000 (16:23 +0000)]
Add integer/money arithmetic from Darren King.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:22:31 +0000 (16:22 +0000)]
Add point_ne() function.
Fix up tabbing of most function declarations.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:20:29 +0000 (16:20 +0000)]
Fix typo for default units for timespan input.
Place single-ticks around bad argument in elog messages.
Fix tabbing of large lookup tables (ugh).
Thomas G. Lockhart [Sat, 20 Sep 1997 16:17:45 +0000 (16:17 +0000)]
Include tinterval comparison functions for span of interval.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:15:34 +0000 (16:15 +0000)]
Include functions for integer/money arithmetic.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:14:05 +0000 (16:14 +0000)]
Fix up elog warning messages.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:11:44 +0000 (16:11 +0000)]
Add support for FLOAT(p) SQL/92 data type.
Allow ALTER TABLE ADD ( column ) syntax.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:08:24 +0000 (16:08 +0000)]
Replace missing directory delimiter for postmaster installation command.
Marc G. Fournier [Sat, 20 Sep 1997 02:21:25 +0000 (02:21 +0000)]
Bring in Peter's changes...finally :(
Bruce Momjian [Fri, 19 Sep 1997 22:02:26 +0000 (22:02 +0000)]
Update configure.
Marc G. Fournier [Fri, 19 Sep 1997 19:44:30 +0000 (19:44 +0000)]
1997-06-15 Paul Eggert <eggert@twinsun.com>
* (src/backend/Makefile): Use `ln', not `cd;ln' so that installers
can wrap ln.
Vadim B. Mikheev [Fri, 19 Sep 1997 06:52:49 +0000 (06:52 +0000)]
+ _copyGroup(Group *from)
Bruce Momjian [Fri, 19 Sep 1997 03:42:39 +0000 (03:42 +0000)]
Fix \e and \p after query.
Bruce Momjian [Thu, 18 Sep 1997 20:22:58 +0000 (20:22 +0000)]
Inline memset() as MemSet().
Bruce Momjian [Thu, 18 Sep 1997 19:57:31 +0000 (19:57 +0000)]
Have to do [[ ]] in configure.in.
Bruce Momjian [Thu, 18 Sep 1997 18:48:32 +0000 (18:48 +0000)]
UPdate memset macro.
Bruce Momjian [Thu, 18 Sep 1997 17:17:19 +0000 (17:17 +0000)]
Update HISTORY.
Bruce Momjian [Thu, 18 Sep 1997 17:06:21 +0000 (17:06 +0000)]
Cleanup for memset macro.
Marc G. Fournier [Thu, 18 Sep 1997 16:09:41 +0000 (16:09 +0000)]
Add in srandom() check to configure
Add appropriate HAVE_{RANDOM,SRANDOM} values to config.h
Add approrpiate #ifdef's to sparc_solaris port files for Solaris v2.6
Vadim B. Mikheev [Thu, 18 Sep 1997 14:45:33 +0000 (14:45 +0000)]
QUERY: SELECT p.name, p.age FROM person* p ORDER BY age using >;
^^^^^^ - new order of tuples (due to psort changes)
Vadim B. Mikheev [Thu, 18 Sep 1997 14:42:35 +0000 (14:42 +0000)]
No more SortTuplesInTree...
Vadim B. Mikheev [Thu, 18 Sep 1997 14:41:56 +0000 (14:41 +0000)]
Don't limit number of tuples in leftist trees!
Use qsort to sort array of tuples for nextrun when current
run is done and put into leftist tree from sorted array!
It's much faster and creates non-bushy tree - this is ve-e-ery good
for perfomance!
Vadim B. Mikheev [Thu, 18 Sep 1997 14:33:46 +0000 (14:33 +0000)]
No more SortTuplesInTree...
Vadim B. Mikheev [Thu, 18 Sep 1997 14:32:15 +0000 (14:32 +0000)]
Convert sequence names tolower.
Vadim B. Mikheev [Thu, 18 Sep 1997 14:31:38 +0000 (14:31 +0000)]
ALTER TABLE ADD COLUMN: set atthasdef to FALSE.
Bruce Momjian [Thu, 18 Sep 1997 14:21:02 +0000 (14:21 +0000)]
Inline frequently called functions.
Vadim B. Mikheev [Thu, 18 Sep 1997 05:42:01 +0000 (05:42 +0000)]
Addded to Psortstate:
lt_tupcount - number of tuples in struct leftist *Tuples
lasttuple - last tuple put to disk by createfirstrun()
Vadim B. Mikheev [Thu, 18 Sep 1997 05:38:09 +0000 (05:38 +0000)]
+ SortTuplesInTree
Vadim B. Mikheev [Thu, 18 Sep 1997 05:37:31 +0000 (05:37 +0000)]
1. Use qsort for first run
2. Limit number of tuples in leftist trees:
- put one tuple from current tree to disk if limit reached;
- end run creation if limit reached by nextrun.
3. Avoid mergeruns() if first run is single one!
Vadim B. Mikheev [Thu, 18 Sep 1997 05:23:58 +0000 (05:23 +0000)]
+ int SortTuplesInTree = 2560;
(default value for max number of tuples in leftist tree)
Vadim B. Mikheev [Thu, 18 Sep 1997 05:19:17 +0000 (05:19 +0000)]
Allow set max number of tuples in leftist tree for sorts
(-S memory,tuples)
Thomas G. Lockhart [Thu, 18 Sep 1997 03:54:19 +0000 (03:54 +0000)]
Add explicit test for various comment syntaxes.
Thomas G. Lockhart [Thu, 18 Sep 1997 03:52:43 +0000 (03:52 +0000)]
Explicitly test various comment syntaxes.
Thomas G. Lockhart [Thu, 18 Sep 1997 03:46:18 +0000 (03:46 +0000)]
Add syntax and warnings for unsupported ALTER TABLE commands
including DROP COLUMN, SET CONSTRAINT, etc.
Marc G. Fournier [Thu, 18 Sep 1997 01:32:14 +0000 (01:32 +0000)]
Ack, I missed a template file here :(
Edmund Mergl [Wed, 17 Sep 1997 20:53:35 +0000 (20:53 +0000)]
*** empty log message ***
Edmund Mergl [Wed, 17 Sep 1997 20:51:36 +0000 (20:51 +0000)]
*** empty log message ***
Edmund Mergl [Wed, 17 Sep 1997 20:48:15 +0000 (20:48 +0000)]
adapted to pgsql-v6.2
Edmund Mergl [Wed, 17 Sep 1997 20:46:29 +0000 (20:46 +0000)]
*** empty log message ***
Bruce Momjian [Wed, 17 Sep 1997 20:14:16 +0000 (20:14 +0000)]
Remove extra backets in tr test.
Bruce Momjian [Tue, 16 Sep 1997 18:51:49 +0000 (18:51 +0000)]
Linux seems to have 3/4/5/686.
Bruce Momjian [Tue, 16 Sep 1997 18:47:36 +0000 (18:47 +0000)]
Makefile cleanup.
Bruce Momjian [Tue, 16 Sep 1997 16:25:28 +0000 (16:25 +0000)]
Mklinux patch from Tatsuo.
Thomas G. Lockhart [Tue, 16 Sep 1997 16:17:19 +0000 (16:17 +0000)]
Modify to match current expected output
after adding separate sections for DEFAULT and CHECK.
Thomas G. Lockhart [Tue, 16 Sep 1997 16:15:52 +0000 (16:15 +0000)]
Add explicit, separate test sections for DEFAULT and CHECK.
Use conventions common to other regression test input files.
Leave non-temporary files at end of test.
Thomas G. Lockhart [Tue, 16 Sep 1997 16:13:58 +0000 (16:13 +0000)]
Remove extraneous blank lines from error messages.
Thomas G. Lockhart [Tue, 16 Sep 1997 16:12:55 +0000 (16:12 +0000)]
Remove difftime() calls.
Still uses time_t declarations, but most code will be changed for next release.
Thomas G. Lockhart [Tue, 16 Sep 1997 16:11:20 +0000 (16:11 +0000)]
Fix string conversions for operators in DEFAULT and CHECK clauses.
Bruce Momjian [Tue, 16 Sep 1997 16:09:59 +0000 (16:09 +0000)]
Remove uint32 from inet_aton file.
Bruce Momjian [Tue, 16 Sep 1997 15:36:09 +0000 (15:36 +0000)]
Removed un-needed signal suff from pginterface.
Bruce Momjian [Tue, 16 Sep 1997 03:01:43 +0000 (03:01 +0000)]
Add .eo to pgbuiltin.
Bruce Momjian [Tue, 16 Sep 1997 02:53:24 +0000 (02:53 +0000)]
Remove NO_MK_LORDER from Solaris.
Bruce Momjian [Tue, 16 Sep 1997 02:49:23 +0000 (02:49 +0000)]
Manual cleanup for textcat.
Vadim B. Mikheev [Mon, 15 Sep 1997 14:29:01 +0000 (14:29 +0000)]
Fix pfree problem.
Vadim B. Mikheev [Mon, 15 Sep 1997 14:28:16 +0000 (14:28 +0000)]
-S need in optarg...