]>
granicus.if.org Git - postgresql/log
Vadim B. Mikheev [Fri, 22 Aug 1997 14:39:33 +0000 (14:39 +0000)]
+ ExecConstraints ()
Vadim B. Mikheev [Fri, 22 Aug 1997 14:33:21 +0000 (14:33 +0000)]
Restore CONSTRAINT keyword (was lost ... by unknown way)
Vadim B. Mikheev [Fri, 22 Aug 1997 14:28:20 +0000 (14:28 +0000)]
+ ExecConstraints()
Vadim B. Mikheev [Fri, 22 Aug 1997 14:22:14 +0000 (14:22 +0000)]
Turn constraints off for sequences & views
elog(WARN,"ADD ATTRIBUTE: DEFAULT is not implemented, yet");
Call ExecConstraints in CopyFrom
Vadim B. Mikheev [Fri, 22 Aug 1997 14:10:26 +0000 (14:10 +0000)]
Remove DEFAULT/CHECK infos from catalog on DROP TABLE
Store CHECK infos on CREATE TABLE
Bruce Momjian [Fri, 22 Aug 1997 07:13:01 +0000 (07:13 +0000)]
We store Cash/money as int of size 4, so make it an int rather than a long.
Bruce Momjian [Fri, 22 Aug 1997 04:13:18 +0000 (04:13 +0000)]
Fix for psql pager when no tty, cleanup for vacuum attdisbursion type.
Vadim B. Mikheev [Fri, 22 Aug 1997 04:05:27 +0000 (04:05 +0000)]
ConstraintDef changed
Vadim B. Mikheev [Fri, 22 Aug 1997 04:04:19 +0000 (04:04 +0000)]
Set attbyval for attdisbursion to FALSE
Set atttype for relchecks to 21 (int2)
Set relkind for pg_attrdef & pg_relcheck to 'n'
Vadim B. Mikheev [Fri, 22 Aug 1997 03:55:39 +0000 (03:55 +0000)]
+ CreateTupleDescCopyConstr
+ FreeTupleDesc
Vadim B. Mikheev [Fri, 22 Aug 1997 03:35:44 +0000 (03:35 +0000)]
Fetch information about DEFAULT/CHECK while openning a relation.
Vadim B. Mikheev [Fri, 22 Aug 1997 03:17:55 +0000 (03:17 +0000)]
There is no NULL constraint in CREATE TABLE - only NOT NULL one.
Vadim B. Mikheev [Fri, 22 Aug 1997 03:12:19 +0000 (03:12 +0000)]
DEFAULT handling
Use for 'selct .. into ..' copy of TupleDesc (without constraints)
#ifdef NOT_USED for resetVarAttrLenForCreateTable (just free tupdesc copy)
Vadim B. Mikheev [Fri, 22 Aug 1997 03:03:56 +0000 (03:03 +0000)]
DefineRelation: DEFAULT/CHECK handling
Vadim B. Mikheev [Fri, 22 Aug 1997 02:58:51 +0000 (02:58 +0000)]
Store attr DEFAULT info in heap_create
Vadim B. Mikheev [Fri, 22 Aug 1997 02:55:39 +0000 (02:55 +0000)]
CreateTupleDescCopy don't copy constraints now!
+ CreateTupleDescCopyConstr to copy them too.
+ FreeTupleDesc
Bruce Momjian [Fri, 22 Aug 1997 00:17:26 +0000 (00:17 +0000)]
Make psql use pager only when it has a tty.
Bruce Momjian [Fri, 22 Aug 1997 00:02:19 +0000 (00:02 +0000)]
Allow functions and operators on internally-identical types to succeed.
Bruce Momjian [Thu, 21 Aug 1997 23:57:00 +0000 (23:57 +0000)]
Change time function names to be more consistent, and check for zero divides, from Michael Reifenberg.
Bruce Momjian [Thu, 21 Aug 1997 14:33:05 +0000 (14:33 +0000)]
Name change cleanup.
Bruce Momjian [Thu, 21 Aug 1997 13:43:46 +0000 (13:43 +0000)]
Remove unused spin function when no spinlocks.
Vadim B. Mikheev [Thu, 21 Aug 1997 04:33:20 +0000 (04:33 +0000)]
#definitions for pg_attrdef & pg_relcheck names
Vadim B. Mikheev [Thu, 21 Aug 1997 04:10:25 +0000 (04:10 +0000)]
AttrConstr --> TupleConstr
Bruce Momjian [Thu, 21 Aug 1997 03:02:13 +0000 (03:02 +0000)]
Rename pg_attribute.attnvals to attdisbursion.
Bruce Momjian [Thu, 21 Aug 1997 02:28:55 +0000 (02:28 +0000)]
Change pg_attribute.attnvals to float4, change #ifdef 0 to #if 0, fix aix call to strNcpy, fix pg_super_user_id in pg_dumpall, change pg_database.dtadba from oid to int4.
Vadim B. Mikheev [Thu, 21 Aug 1997 01:40:30 +0000 (01:40 +0000)]
+ extern double *box_area(BOX *box);
Vadim B. Mikheev [Thu, 21 Aug 1997 01:39:25 +0000 (01:39 +0000)]
+ struct ConstaintDef - for constraints.
Vadim B. Mikheev [Thu, 21 Aug 1997 01:37:55 +0000 (01:37 +0000)]
New system relations to store DEFAULT/CHECK expressions.
Vadim B. Mikheev [Thu, 21 Aug 1997 01:36:09 +0000 (01:36 +0000)]
Read info for DEFAULT from pg_attrdef.
Vadim B. Mikheev [Thu, 21 Aug 1997 01:34:44 +0000 (01:34 +0000)]
Syntax for [CONSTRAINT name] CHECK ...
Vadim B. Mikheev [Thu, 21 Aug 1997 01:32:19 +0000 (01:32 +0000)]
Get rid of attproc, atttyparg, attcanindex, attdefrel, attbound
from pg_attribute. atthasdef added.
Bruce Momjian [Wed, 20 Aug 1997 15:06:48 +0000 (15:06 +0000)]
Portability fix for pg_dumpall.
Bruce Momjian [Wed, 20 Aug 1997 14:54:35 +0000 (14:54 +0000)]
More NOT_USEDs
Bruce Momjian [Wed, 20 Aug 1997 02:10:47 +0000 (02:10 +0000)]
Add static finding script.
Vadim B. Mikheev [Wed, 20 Aug 1997 02:01:42 +0000 (02:01 +0000)]
HTNegate/HTCommute/HTNegateCommute are not used.
Vadim B. Mikheev [Wed, 20 Aug 1997 01:50:06 +0000 (01:50 +0000)]
CHECK/DEFAULT syntax (some tricks to get current scan position).
Vadim B. Mikheev [Wed, 20 Aug 1997 01:12:38 +0000 (01:12 +0000)]
CHECK/DEFAULT syntax
Marc G. Fournier [Wed, 20 Aug 1997 00:50:11 +0000 (00:50 +0000)]
Changes for Digital Unix
Bruce Momjian [Tue, 19 Aug 1997 21:47:07 +0000 (21:47 +0000)]
Fix for sunos4 difftime() call.
Bruce Momjian [Tue, 19 Aug 1997 21:40:56 +0000 (21:40 +0000)]
Make functions static where possible, enclose unused functions in #ifdef NOT_USED.
Vadim B. Mikheev [Tue, 19 Aug 1997 04:46:15 +0000 (04:46 +0000)]
NOT NULL implementation (submitted by Robson Paniago de Miranda).
Bruce Momjian [Mon, 18 Aug 1997 20:53:48 +0000 (20:53 +0000)]
Now that names are null terminated, no need to do all that NAMEDATALEN stuff.
Bruce Momjian [Mon, 18 Aug 1997 02:15:04 +0000 (02:15 +0000)]
Reduce open() calls. Replace fopen() calls with calls to fd.c functions.
Marc G. Fournier [Sun, 17 Aug 1997 02:40:00 +0000 (02:40 +0000)]
Fixes for alphalinux port by abrams@philos.umass.edu
Marc G. Fournier [Sun, 17 Aug 1997 00:48:51 +0000 (00:48 +0000)]
Changes so that it actually checks for <readline/history.h>, instead
of assuming it does exist
Marc G. Fournier [Sun, 17 Aug 1997 00:39:02 +0000 (00:39 +0000)]
Make sure that LIBPQDIR points to the right directory
Marc G. Fournier [Sun, 17 Aug 1997 00:33:28 +0000 (00:33 +0000)]
Fix up paths to $(SRCDIR)
Marc G. Fournier [Sat, 16 Aug 1997 20:56:28 +0000 (20:56 +0000)]
Add appropriate links into the interfaces directory, as well as a Makefile
covering the interfaces directory
Marc G. Fournier [Sat, 16 Aug 1997 20:51:53 +0000 (20:51 +0000)]
Bring in Adrian's JDBC driver as an interface
Bruce Momjian [Thu, 14 Aug 1997 16:11:41 +0000 (16:11 +0000)]
Cleanup global variables, remove stable memory stuff.
Vadim B. Mikheev [Thu, 14 Aug 1997 05:04:38 +0000 (05:04 +0000)]
sprintf "...%d...", ... (int)getpid(), ...
^^^^^
Vadim B. Mikheev [Thu, 14 Aug 1997 05:01:32 +0000 (05:01 +0000)]
_hash_checkpage: cleanup for CASSERT
Bruce Momjian [Tue, 12 Aug 1997 23:03:50 +0000 (23:03 +0000)]
These changes allow the module to compile quietly when assert checking is
not being done.
Bruce Momjian [Tue, 12 Aug 1997 22:55:25 +0000 (22:55 +0000)]
Remove more (void) and fix -Wall warnings.
Bruce Momjian [Tue, 12 Aug 1997 20:39:16 +0000 (20:39 +0000)]
cleanup of patch
Bruce Momjian [Tue, 12 Aug 1997 20:16:25 +0000 (20:16 +0000)]
Fix pgproc names over 15 chars in output. Add strNcpy() function. remove some (void) casts that are unnecessary.
Bruce Momjian [Fri, 8 Aug 1997 03:51:33 +0000 (03:51 +0000)]
Add bsdi gcc2 options.
Bruce Momjian [Wed, 6 Aug 1997 17:11:20 +0000 (17:11 +0000)]
Fix for psort again.
Bruce Momjian [Wed, 6 Aug 1997 07:39:20 +0000 (07:39 +0000)]
Another psort fix.
Bruce Momjian [Wed, 6 Aug 1997 07:02:49 +0000 (07:02 +0000)]
I think I finally got psort working for all cases.
Bruce Momjian [Wed, 6 Aug 1997 05:38:46 +0000 (05:38 +0000)]
psort cleanups.
Bruce Momjian [Wed, 6 Aug 1997 05:08:37 +0000 (05:08 +0000)]
Another fix.
Bruce Momjian [Wed, 6 Aug 1997 04:45:39 +0000 (04:45 +0000)]
Fix for palloc(0) in new code
Bruce Momjian [Wed, 6 Aug 1997 03:42:21 +0000 (03:42 +0000)]
Allow internal sorts to be stored in memory rather than in files.
Bruce Momjian [Wed, 6 Aug 1997 03:37:34 +0000 (03:37 +0000)]
Add developers help file.
Bruce Momjian [Wed, 6 Aug 1997 03:33:45 +0000 (03:33 +0000)]
Fix for os version handling.
Vadim B. Mikheev [Wed, 6 Aug 1997 02:08:39 +0000 (02:08 +0000)]
Catch non-functional delete attempts.
Bruce Momjian [Sun, 3 Aug 1997 02:38:47 +0000 (02:38 +0000)]
Cleanup for NAMEDATALEN use.
Bruce Momjian [Sun, 3 Aug 1997 02:28:10 +0000 (02:28 +0000)]
Comment out code that makes no sense, and Purify complains about.
Bruce Momjian [Sat, 2 Aug 1997 19:09:33 +0000 (19:09 +0000)]
Prevent relname unallocated string length from being copied into database.
Bruce Momjian [Sat, 2 Aug 1997 16:32:51 +0000 (16:32 +0000)]
Makei configure less os-version specific, were possible.
Bruce Momjian [Fri, 1 Aug 1997 04:07:55 +0000 (04:07 +0000)]
Fix stout/stderr paging. Do not page \h select, but page \h *.
Bruce Momjian [Fri, 1 Aug 1997 03:49:22 +0000 (03:49 +0000)]
FIx solaris template finding.
Bruce Momjian [Fri, 1 Aug 1997 03:33:02 +0000 (03:33 +0000)]
Fix psql error output.
Bruce Momjian [Thu, 31 Jul 1997 01:37:56 +0000 (01:37 +0000)]
Configure cleanup for /usr/ucb patch.
Bruce Momjian [Wed, 30 Jul 1997 19:16:23 +0000 (19:16 +0000)]
Look in /usr/ucb first for install.
Bruce Momjian [Wed, 30 Jul 1997 18:27:18 +0000 (18:27 +0000)]
configure.in cleanup for tr and strerror2.
Bruce Momjian [Wed, 30 Jul 1997 17:21:29 +0000 (17:21 +0000)]
Add -o to psql manual page.
Bruce Momjian [Wed, 30 Jul 1997 15:53:57 +0000 (15:53 +0000)]
Fix c++ copy example code.
Bruce Momjian [Wed, 30 Jul 1997 14:55:20 +0000 (14:55 +0000)]
Remove restart instructions from INSTALL.
Marc G. Fournier [Wed, 30 Jul 1997 14:08:11 +0000 (14:08 +0000)]
Due to BIND 8.1.1, my Solaris 2.5.1 machine doesn't define MAXHOSTNAMELEN...
so, add a check that basically says if it isn't defined, set it to 256...
Marc G. Fournier [Wed, 30 Jul 1997 14:03:33 +0000 (14:03 +0000)]
Check for and use <netdb.h> for postmaster.c, instead of checking if
MAXHOSTNAMELEN is defined. For some reason, my 2.5.1 Solaris box at
work fails on that check...
Vadim B. Mikheev [Wed, 30 Jul 1997 04:42:26 +0000 (04:42 +0000)]
Allow use parameters in target list having aggregates in functions.
Bruce Momjian [Wed, 30 Jul 1997 01:32:44 +0000 (01:32 +0000)]
configure.in cleanup from sco install.
Bruce Momjian [Wed, 30 Jul 1997 00:09:42 +0000 (00:09 +0000)]
Remove HAVE_USAGE because it is no longer used.
Bruce Momjian [Tue, 29 Jul 1997 21:43:40 +0000 (21:43 +0000)]
Update COPY manual page to remove unneeded warnings.
Bruce Momjian [Tue, 29 Jul 1997 21:16:52 +0000 (21:16 +0000)]
Update configure after sunos4 update.
Bruce Momjian [Tue, 29 Jul 1997 16:36:43 +0000 (16:36 +0000)]
Add strerror to pg_version for sunos4.
Thomas G. Lockhart [Tue, 29 Jul 1997 16:24:04 +0000 (16:24 +0000)]
Results from initial changes to add new functions and for bug fixes.
Not all cleaned up yet.
Thomas G. Lockhart [Tue, 29 Jul 1997 16:22:48 +0000 (16:22 +0000)]
Start adding tests for new geometry functions.
Not all cleaned up yet.
Thomas G. Lockhart [Tue, 29 Jul 1997 16:21:12 +0000 (16:21 +0000)]
Use better routines from geometry library.
Thomas G. Lockhart [Tue, 29 Jul 1997 16:19:26 +0000 (16:19 +0000)]
Change call definition for isreltime().
Thomas G. Lockhart [Tue, 29 Jul 1997 16:17:52 +0000 (16:17 +0000)]
Add new operators and functions for geometric types.
Add text concatenation operator and function.
Add text trim function for SQL92 support.
Thomas G. Lockhart [Tue, 29 Jul 1997 16:16:14 +0000 (16:16 +0000)]
Add new routines.
Change definition for isreltime().
Change some names of #define constants to avoid conflicts with the yacc parser.
Thomas G. Lockhart [Tue, 29 Jul 1997 16:14:40 +0000 (16:14 +0000)]
Remove some unnecessary include statements (comment out with #ifdef FALSE).
Thomas G. Lockhart [Tue, 29 Jul 1997 16:12:07 +0000 (16:12 +0000)]
Add routines for text trimming on both ends, substring, and string position.
Used to support SQL92 compatibility.
Thomas G. Lockhart [Tue, 29 Jul 1997 16:09:38 +0000 (16:09 +0000)]
Fix bug to allow hh:mm:ss time entry for timespan/reltime types.
Thomas G. Lockhart [Tue, 29 Jul 1997 16:08:18 +0000 (16:08 +0000)]
Remove #ifdef'd support for old i/o styles.
Change box terminology from "length" to "width".
Use length terminology in common with other geometric types (usually perimeter).
Fix bugs in line arithmetic which resulted in bad intersection calculations.
Deprecate temporary unstored slope fields.
Check explicitly for intersections at endpoints to avoid rounding ugliness.
Add center() routines for lseg, path, polygon.
Add distance() routines for circle-polygon, polygon-polygon.
Check explicitly for points and polygons contained within polygons
using an axis-crossing algorithm. (Old code just checked bounding boxes).
Add routine to convert circle-box.
*whew*
Thomas G. Lockhart [Tue, 29 Jul 1997 15:54:49 +0000 (15:54 +0000)]
Update some reltime code to use new common routines.
Use standard decoder for isreltime().
Thomas G. Lockhart [Tue, 29 Jul 1997 15:51:33 +0000 (15:51 +0000)]
Add debugging statements.