]> granicus.if.org Git - postgresql/log
postgresql
27 years agoTests for CHECK/DEFAULT
Vadim B. Mikheev [Thu, 28 Aug 1997 04:49:34 +0000 (04:49 +0000)]
Tests for CHECK/DEFAULT

27 years agoNumber of tuples inserted/affected by INSERT/UPDATE/DELETE...
Vadim B. Mikheev [Wed, 27 Aug 1997 09:05:24 +0000 (09:05 +0000)]
Number of tuples inserted/affected by INSERT/UPDATE/DELETE...

27 years agoheap_delete returns int now (for non-functional deletes).
Vadim B. Mikheev [Wed, 27 Aug 1997 09:03:47 +0000 (09:03 +0000)]
heap_delete returns int now (for non-functional deletes).

27 years agoOnly need to check for strerror once :)
Marc G. Fournier [Wed, 27 Aug 1997 05:06:20 +0000 (05:06 +0000)]
Only need to check for strerror once :)

27 years agoRemove unneeded stat calls.
Bruce Momjian [Wed, 27 Aug 1997 03:48:50 +0000 (03:48 +0000)]
Remove unneeded stat calls.

27 years agoInlined heap_getattr().
Bruce Momjian [Tue, 26 Aug 1997 23:31:58 +0000 (23:31 +0000)]
Inlined heap_getattr().

27 years agoFix for pointer arithmetic.
Bruce Momjian [Tue, 26 Aug 1997 19:24:36 +0000 (19:24 +0000)]
Fix for pointer arithmetic.

27 years agorename sections.
Bruce Momjian [Tue, 26 Aug 1997 17:39:32 +0000 (17:39 +0000)]
rename sections.

27 years agounix.1 renamed to pgintro.1.
Bruce Momjian [Tue, 26 Aug 1997 17:30:09 +0000 (17:30 +0000)]
unix.1 renamed to pgintro.1.

27 years agoManual page renaming.
Bruce Momjian [Tue, 26 Aug 1997 17:00:23 +0000 (17:00 +0000)]
Manual page renaming.

27 years agoChange void * to Dllist*.
Bruce Momjian [Tue, 26 Aug 1997 14:05:47 +0000 (14:05 +0000)]
Change void * to Dllist*.

27 years agopg_passwd cleanup.
Bruce Momjian [Mon, 25 Aug 1997 23:28:04 +0000 (23:28 +0000)]
pg_passwd cleanup.

27 years agopg_passwd cleanup.
Bruce Momjian [Mon, 25 Aug 1997 23:11:21 +0000 (23:11 +0000)]
pg_passwd cleanup.

27 years agopg_passwd cleanup
Bruce Momjian [Mon, 25 Aug 1997 20:00:03 +0000 (20:00 +0000)]
pg_passwd cleanup

27 years agopg_password utility. Cleanup for psql passwords. New datetime contrib stuff for...
Bruce Momjian [Mon, 25 Aug 1997 19:41:52 +0000 (19:41 +0000)]
pg_password utility.  Cleanup for psql passwords.  New datetime contrib stuff for new version.  Fix for strutils needing config.h.

27 years agoSmall cleanup.
Bruce Momjian [Mon, 25 Aug 1997 04:15:40 +0000 (04:15 +0000)]
Small cleanup.

27 years agoMajor patch to speed up backend startup after profiling analysis.
Bruce Momjian [Sun, 24 Aug 1997 23:08:01 +0000 (23:08 +0000)]
Major patch to speed up backend startup after profiling analysis.

27 years agoUpdate .similar version file.
Bruce Momjian [Fri, 22 Aug 1997 18:48:25 +0000 (18:48 +0000)]
Update .similar version file.

27 years agoFix for no NULL in CREATE TABLE.
Bruce Momjian [Fri, 22 Aug 1997 17:15:41 +0000 (17:15 +0000)]
Fix for no NULL in CREATE TABLE.

27 years agoRemove compile warning.
Bruce Momjian [Fri, 22 Aug 1997 16:48:14 +0000 (16:48 +0000)]
Remove compile warning.

27 years agoWarning in makefile added from DArcy.
Bruce Momjian [Fri, 22 Aug 1997 16:38:33 +0000 (16:38 +0000)]
Warning in makefile added from DArcy.

27 years ago+ ExecConstraints ()
Vadim B. Mikheev [Fri, 22 Aug 1997 14:39:33 +0000 (14:39 +0000)]
+ ExecConstraints ()

27 years agoRestore CONSTRAINT keyword (was lost ... by unknown way)
Vadim B. Mikheev [Fri, 22 Aug 1997 14:33:21 +0000 (14:33 +0000)]
Restore CONSTRAINT keyword (was lost ... by unknown way)

27 years ago+ ExecConstraints()
Vadim B. Mikheev [Fri, 22 Aug 1997 14:28:20 +0000 (14:28 +0000)]
+ ExecConstraints()

27 years agoTurn constraints off for sequences & views
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

27 years agoRemove DEFAULT/CHECK infos from catalog on DROP TABLE
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

27 years agoWe store Cash/money as int of size 4, so make it an int rather than a long.
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.

27 years agoFix for psql pager when no tty, cleanup for vacuum attdisbursion type.
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.

27 years agoConstraintDef changed
Vadim B. Mikheev [Fri, 22 Aug 1997 04:05:27 +0000 (04:05 +0000)]
ConstraintDef changed

27 years agoSet attbyval for attdisbursion to FALSE
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'

27 years ago+ CreateTupleDescCopyConstr
Vadim B. Mikheev [Fri, 22 Aug 1997 03:55:39 +0000 (03:55 +0000)]
+ CreateTupleDescCopyConstr
+ FreeTupleDesc

27 years agoFetch information about DEFAULT/CHECK while openning a relation.
Vadim B. Mikheev [Fri, 22 Aug 1997 03:35:44 +0000 (03:35 +0000)]
Fetch information about DEFAULT/CHECK while openning a relation.

27 years agoThere is no NULL constraint in CREATE TABLE - only NOT NULL one.
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.

27 years agoDEFAULT handling
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)

27 years agoDefineRelation: DEFAULT/CHECK handling
Vadim B. Mikheev [Fri, 22 Aug 1997 03:03:56 +0000 (03:03 +0000)]
DefineRelation: DEFAULT/CHECK handling

27 years agoStore attr DEFAULT info in heap_create
Vadim B. Mikheev [Fri, 22 Aug 1997 02:58:51 +0000 (02:58 +0000)]
Store attr DEFAULT info in heap_create

27 years agoCreateTupleDescCopy don't copy constraints now!
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

27 years agoMake psql use pager only when it has a tty.
Bruce Momjian [Fri, 22 Aug 1997 00:17:26 +0000 (00:17 +0000)]
Make psql use pager only when it has a tty.

27 years agoAllow functions and operators on internally-identical types to succeed.
Bruce Momjian [Fri, 22 Aug 1997 00:02:19 +0000 (00:02 +0000)]
Allow functions and operators on internally-identical types to succeed.

27 years agoChange time function names to be more consistent, and check for zero divides, from...
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.

27 years agoName change cleanup.
Bruce Momjian [Thu, 21 Aug 1997 14:33:05 +0000 (14:33 +0000)]
Name change cleanup.

27 years agoRemove unused spin function when no spinlocks.
Bruce Momjian [Thu, 21 Aug 1997 13:43:46 +0000 (13:43 +0000)]
Remove unused spin function when no spinlocks.

27 years ago#definitions for pg_attrdef & pg_relcheck names
Vadim B. Mikheev [Thu, 21 Aug 1997 04:33:20 +0000 (04:33 +0000)]
#definitions for pg_attrdef & pg_relcheck names

27 years agoAttrConstr --> TupleConstr
Vadim B. Mikheev [Thu, 21 Aug 1997 04:10:25 +0000 (04:10 +0000)]
AttrConstr --> TupleConstr

27 years agoRename pg_attribute.attnvals to attdisbursion.
Bruce Momjian [Thu, 21 Aug 1997 03:02:13 +0000 (03:02 +0000)]
Rename pg_attribute.attnvals to attdisbursion.

27 years agoChange pg_attribute.attnvals to float4, change #ifdef 0 to #if 0, fix aix call to...
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.

27 years ago+ extern double *box_area(BOX *box);
Vadim B. Mikheev [Thu, 21 Aug 1997 01:40:30 +0000 (01:40 +0000)]
+ extern double *box_area(BOX *box);

27 years ago+ struct ConstaintDef - for constraints.
Vadim B. Mikheev [Thu, 21 Aug 1997 01:39:25 +0000 (01:39 +0000)]
+ struct ConstaintDef - for constraints.

27 years agoNew system relations to store DEFAULT/CHECK expressions.
Vadim B. Mikheev [Thu, 21 Aug 1997 01:37:55 +0000 (01:37 +0000)]
New system relations to store DEFAULT/CHECK expressions.

27 years agoRead info for DEFAULT from pg_attrdef.
Vadim B. Mikheev [Thu, 21 Aug 1997 01:36:09 +0000 (01:36 +0000)]
Read info for DEFAULT from pg_attrdef.

27 years agoSyntax for [CONSTRAINT name] CHECK ...
Vadim B. Mikheev [Thu, 21 Aug 1997 01:34:44 +0000 (01:34 +0000)]
Syntax for [CONSTRAINT name] CHECK ...

27 years agoGet rid of attproc, atttyparg, attcanindex, attdefrel, attbound
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.

27 years agoPortability fix for pg_dumpall.
Bruce Momjian [Wed, 20 Aug 1997 15:06:48 +0000 (15:06 +0000)]
Portability fix for pg_dumpall.

27 years agoMore NOT_USEDs
Bruce Momjian [Wed, 20 Aug 1997 14:54:35 +0000 (14:54 +0000)]
More NOT_USEDs

27 years agoAdd static finding script.
Bruce Momjian [Wed, 20 Aug 1997 02:10:47 +0000 (02:10 +0000)]
Add static finding script.

27 years agoHTNegate/HTCommute/HTNegateCommute are not used.
Vadim B. Mikheev [Wed, 20 Aug 1997 02:01:42 +0000 (02:01 +0000)]
HTNegate/HTCommute/HTNegateCommute are not used.

27 years agoCHECK/DEFAULT syntax (some tricks to get current scan position).
Vadim B. Mikheev [Wed, 20 Aug 1997 01:50:06 +0000 (01:50 +0000)]
CHECK/DEFAULT syntax (some tricks to get current scan position).

27 years agoCHECK/DEFAULT syntax
Vadim B. Mikheev [Wed, 20 Aug 1997 01:12:38 +0000 (01:12 +0000)]
CHECK/DEFAULT syntax

27 years agoChanges for Digital Unix
Marc G. Fournier [Wed, 20 Aug 1997 00:50:11 +0000 (00:50 +0000)]
Changes for Digital Unix

27 years agoFix for sunos4 difftime() call.
Bruce Momjian [Tue, 19 Aug 1997 21:47:07 +0000 (21:47 +0000)]
Fix for sunos4 difftime() call.

27 years agoMake functions static where possible, enclose unused functions in #ifdef NOT_USED.
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.

27 years agoNOT NULL implementation (submitted by Robson Paniago de Miranda).
Vadim B. Mikheev [Tue, 19 Aug 1997 04:46:15 +0000 (04:46 +0000)]
NOT NULL implementation (submitted by Robson Paniago de Miranda).

27 years agoNow that names are null terminated, no need to do all that NAMEDATALEN stuff.
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.

27 years agoReduce open() calls. Replace fopen() calls with calls to fd.c functions.
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.

27 years agoFixes for alphalinux port by abrams@philos.umass.edu
Marc G. Fournier [Sun, 17 Aug 1997 02:40:00 +0000 (02:40 +0000)]
Fixes for alphalinux port by abrams@philos.umass.edu

27 years agoChanges so that it actually checks for <readline/history.h>, instead
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

27 years agoMake sure that LIBPQDIR points to the right directory
Marc G. Fournier [Sun, 17 Aug 1997 00:39:02 +0000 (00:39 +0000)]
Make sure that LIBPQDIR points to the right directory

27 years agoFix up paths to $(SRCDIR)
Marc G. Fournier [Sun, 17 Aug 1997 00:33:28 +0000 (00:33 +0000)]
Fix up paths to $(SRCDIR)

27 years agoAdd appropriate links into the interfaces directory, as well as a Makefile
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

27 years agoBring in Adrian's JDBC driver as an interface
Marc G. Fournier [Sat, 16 Aug 1997 20:51:53 +0000 (20:51 +0000)]
Bring in Adrian's JDBC driver as an interface

27 years agoCleanup global variables, remove stable memory stuff.
Bruce Momjian [Thu, 14 Aug 1997 16:11:41 +0000 (16:11 +0000)]
Cleanup global variables, remove stable memory stuff.

27 years agosprintf "...%d...", ... (int)getpid(), ...
Vadim B. Mikheev [Thu, 14 Aug 1997 05:04:38 +0000 (05:04 +0000)]
sprintf "...%d...", ... (int)getpid(), ...
                        ^^^^^

27 years ago_hash_checkpage: cleanup for CASSERT
Vadim B. Mikheev [Thu, 14 Aug 1997 05:01:32 +0000 (05:01 +0000)]
_hash_checkpage: cleanup for CASSERT

27 years agoThese changes allow the module to compile quietly when assert checking is
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.

27 years agoRemove more (void) and fix -Wall warnings.
Bruce Momjian [Tue, 12 Aug 1997 22:55:25 +0000 (22:55 +0000)]
Remove more (void) and fix -Wall warnings.

27 years agocleanup of patch
Bruce Momjian [Tue, 12 Aug 1997 20:39:16 +0000 (20:39 +0000)]
cleanup of patch

27 years agoFix pgproc names over 15 chars in output. Add strNcpy() function. remove some ...
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.

27 years agoAdd bsdi gcc2 options.
Bruce Momjian [Fri, 8 Aug 1997 03:51:33 +0000 (03:51 +0000)]
Add bsdi gcc2 options.

27 years agoFix for psort again.
Bruce Momjian [Wed, 6 Aug 1997 17:11:20 +0000 (17:11 +0000)]
Fix for psort again.

27 years agoAnother psort fix.
Bruce Momjian [Wed, 6 Aug 1997 07:39:20 +0000 (07:39 +0000)]
Another psort fix.

27 years agoI think I finally got psort working for all cases.
Bruce Momjian [Wed, 6 Aug 1997 07:02:49 +0000 (07:02 +0000)]
I think I finally got psort working for all cases.

27 years agopsort cleanups.
Bruce Momjian [Wed, 6 Aug 1997 05:38:46 +0000 (05:38 +0000)]
psort cleanups.

27 years agoAnother fix.
Bruce Momjian [Wed, 6 Aug 1997 05:08:37 +0000 (05:08 +0000)]
Another fix.

27 years agoFix for palloc(0) in new code
Bruce Momjian [Wed, 6 Aug 1997 04:45:39 +0000 (04:45 +0000)]
Fix for palloc(0) in new code

27 years agoAllow internal sorts to be stored in memory rather than in files.
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.

27 years agoAdd developers help file.
Bruce Momjian [Wed, 6 Aug 1997 03:37:34 +0000 (03:37 +0000)]
Add developers help file.

27 years agoFix for os version handling.
Bruce Momjian [Wed, 6 Aug 1997 03:33:45 +0000 (03:33 +0000)]
Fix for os version handling.

27 years agoCatch non-functional delete attempts.
Vadim B. Mikheev [Wed, 6 Aug 1997 02:08:39 +0000 (02:08 +0000)]
Catch non-functional delete attempts.

27 years agoCleanup for NAMEDATALEN use.
Bruce Momjian [Sun, 3 Aug 1997 02:38:47 +0000 (02:38 +0000)]
Cleanup for NAMEDATALEN use.

27 years agoComment out code that makes no sense, and Purify complains about.
Bruce Momjian [Sun, 3 Aug 1997 02:28:10 +0000 (02:28 +0000)]
Comment out code that makes no sense, and Purify complains about.

27 years agoPrevent relname unallocated string length from being copied into database.
Bruce Momjian [Sat, 2 Aug 1997 19:09:33 +0000 (19:09 +0000)]
Prevent relname unallocated string length from being copied into database.

27 years agoMakei configure less os-version specific, were possible.
Bruce Momjian [Sat, 2 Aug 1997 16:32:51 +0000 (16:32 +0000)]
Makei configure less os-version specific, were possible.

27 years agoFix stout/stderr paging. Do not page \h select, but page \h *.
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 *.

27 years agoFIx solaris template finding.
Bruce Momjian [Fri, 1 Aug 1997 03:49:22 +0000 (03:49 +0000)]
FIx solaris template finding.

27 years agoFix psql error output.
Bruce Momjian [Fri, 1 Aug 1997 03:33:02 +0000 (03:33 +0000)]
Fix psql error output.

27 years agoConfigure cleanup for /usr/ucb patch.
Bruce Momjian [Thu, 31 Jul 1997 01:37:56 +0000 (01:37 +0000)]
Configure cleanup for /usr/ucb patch.

27 years agoLook in /usr/ucb first for install.
Bruce Momjian [Wed, 30 Jul 1997 19:16:23 +0000 (19:16 +0000)]
Look in /usr/ucb first for install.

27 years agoconfigure.in cleanup for tr and strerror2.
Bruce Momjian [Wed, 30 Jul 1997 18:27:18 +0000 (18:27 +0000)]
configure.in cleanup for tr and strerror2.

27 years agoAdd -o to psql manual page.
Bruce Momjian [Wed, 30 Jul 1997 17:21:29 +0000 (17:21 +0000)]
Add -o to psql manual page.

27 years agoFix c++ copy example code.
Bruce Momjian [Wed, 30 Jul 1997 15:53:57 +0000 (15:53 +0000)]
Fix c++ copy example code.