OSDN Git Service
Bruce Momjian [Fri, 15 Oct 1999 01:49:49 +0000 (01:49 +0000)]
This patch implements ORACLE's COMMENT SQL command.
>From the ORACLE 7 SQL Language Reference Manual:
-----------------------------------------------------
COMMENT
Purpose:
To add a comment about a table, view, snapshot, or
column into the data dictionary.
Prerequisites:
The table, view, or snapshot must be in your own
schema
or you must have COMMENT ANY TABLE system privilege.
Syntax:
COMMENT ON [ TABLE table ] |
[ COLUMN table.column] IS 'text'
You can effectively drop a comment from the database
by setting it to the empty string ''.
-----------------------------------------------------
Example:
COMMENT ON TABLE workorders IS
'Maintains base records for workorder information';
COMMENT ON COLUMN workorders.hours IS
'Number of hours the engineer worked on the task';
to drop a comment:
COMMENT ON COLUMN workorders.hours IS '';
The current patch will simply perform the insert into
pg_description, as per the TODO. And, of course, when
the table is dropped, any comments relating to it
or any of its attributes are also dropped. I haven't
looked at the ODBC source yet, but I do know from
an ODBC client standpoint that the standard does
support the notion of table and column comments.
Hopefully the ODBC driver is already fetching these
values from pg_description, but if not, it should be
trivial.
Hope this makes the grade,
Mike Mascari
(mascarim@yahoo.com)
Bruce Momjian [Fri, 15 Oct 1999 01:47:55 +0000 (01:47 +0000)]
Add S-tree doc for possible future use.
Bruce Momjian [Thu, 14 Oct 1999 01:28:42 +0000 (01:28 +0000)]
Update psql \? for \w.
Bruce Momjian [Wed, 13 Oct 1999 16:46:28 +0000 (16:46 +0000)]
Correctly return -1 on error to CmdTuples()
Vince.
Tom Lane [Wed, 13 Oct 1999 15:02:32 +0000 (15:02 +0000)]
Split 'BufFile' routines out of fd.c into a new module, buffile.c. Extend
BufFile so that it handles multi-segment temporary files transparently.
This allows sorts and hashes to work with data exceeding 2Gig (or whatever
the local limit on file size is). Change psort.c to use relative seeks
instead of absolute seeks for backwards scanning, so that it won't fail
when the data volume exceeds 2Gig.
Bruce Momjian [Wed, 13 Oct 1999 11:38:42 +0000 (11:38 +0000)]
Hi,
I have changed a bit the makefiles for the win32 port - the *.def files
(created when building shared libraries) are now clean from
Makefile.shlib.
I have also removed "-g" from CFLAGS in the "cygwin32" template - it can
be
enabled when running configure.
Dan
Bruce Momjian [Wed, 13 Oct 1999 11:08:57 +0000 (11:08 +0000)]
Update jdbc for release version #>
Bruce Momjian [Wed, 13 Oct 1999 02:44:23 +0000 (02:44 +0000)]
Update for NUMERIC/DECIMAL data type.
Bruce Momjian [Wed, 13 Oct 1999 02:26:37 +0000 (02:26 +0000)]
BLOBs containing NUL characters (ASCII 0) can be written to the
database, but they get truncated at the first NUL by lo_read
when they are read back. The reason for this is that lo_read in
Pg.xs is using the default:
OUTPUT:
RETVAL
buf
which uses C's strlen() to work out the length of the scalar.
The code ought to read something more like:
OUTPUT:
RETVAL
buf sv_setpvn((SV*)ST(2), buf, RETVAL);
I am not sure if this needs to be done on both lo_read methods
in this file, but I changed both and have not since had any
problems with truncated BLOBs.
Douglas Thomson <dougt@mugc.cc.monash.edu.au>
Bruce Momjian [Tue, 12 Oct 1999 16:04:20 +0000 (16:04 +0000)]
Update new HISTORY file.
Bruce Momjian [Tue, 12 Oct 1999 15:48:47 +0000 (15:48 +0000)]
Update sgml.
Bruce Momjian [Tue, 12 Oct 1999 15:34:19 +0000 (15:34 +0000)]
Update for 6.5.3, including new INSTALL file and updated HISTORY.
Bruce Momjian [Tue, 12 Oct 1999 14:54:28 +0000 (14:54 +0000)]
I have created a small patch that makes possible to compile pgsql on newer
Cygwin snapshots (tested on 990115 which is recommended to use - it fixes
some errors in B20.1)
And I have another patch for including <sys/ipc.h> before <sys/sem.h> in
backend/storage/lmgr/proc.c - it is required due the design of cygipc
headers
Dan
Bruce Momjian [Tue, 12 Oct 1999 14:46:26 +0000 (14:46 +0000)]
Remove pgeasy Makefile on distclean.
Bruce Momjian [Tue, 12 Oct 1999 14:42:04 +0000 (14:42 +0000)]
autoconf
Bruce Momjian [Tue, 12 Oct 1999 14:31:22 +0000 (14:31 +0000)]
autoconf
Bruce Momjian [Tue, 12 Oct 1999 14:06:49 +0000 (14:06 +0000)]
Update pgeasy for missing files.
Thomas G. Lockhart [Tue, 12 Oct 1999 13:59:45 +0000 (13:59 +0000)]
Fix bad markup.
<term> not allowed in paragraphs; <option> is a better choice.
Thomas G. Lockhart [Tue, 12 Oct 1999 13:58:53 +0000 (13:58 +0000)]
Add DEC and SESSION_USER as reserved words.
Move around a few other keywords which were not in the right category.
DEC and SESSION_USER are not yet committed to gram.y,
since I'm in the middle of working on JOIN syntax too.
Thomas G. Lockhart [Tue, 12 Oct 1999 13:57:04 +0000 (13:57 +0000)]
Sequence of date interpretation not quite right.
Tatsuo Ishii [Tue, 12 Oct 1999 10:21:56 +0000 (10:21 +0000)]
Add blcksz to struct ControlFileData to check BLCKSZ is same
as BLCKSZ which the backend was compiled in.
Bruce Momjian [Mon, 11 Oct 1999 18:51:10 +0000 (18:51 +0000)]
Update pgeasy.
Bruce Momjian [Mon, 11 Oct 1999 18:16:06 +0000 (18:16 +0000)]
cleanup of pgeasy.
Bruce Momjian [Mon, 11 Oct 1999 18:05:39 +0000 (18:05 +0000)]
Update again.
Bruce Momjian [Mon, 11 Oct 1999 18:03:04 +0000 (18:03 +0000)]
pgeasy update.
Bruce Momjian [Mon, 11 Oct 1999 17:51:27 +0000 (17:51 +0000)]
Update pgeasy.
Bruce Momjian [Mon, 11 Oct 1999 17:48:23 +0000 (17:48 +0000)]
autoconf
Bruce Momjian [Mon, 11 Oct 1999 17:47:02 +0000 (17:47 +0000)]
Add pginterface into main tree, called pgeasy.
Bruce Momjian [Mon, 11 Oct 1999 13:42:25 +0000 (13:42 +0000)]
Update TODO list.
Hiroshi Inoue [Mon, 11 Oct 1999 06:28:29 +0000 (06:28 +0000)]
The 1st step to implement new type of scan,TidScan.
Now WHERE restriction on ctid is allowed though it is
sequentially scanned.
Bruce Momjian [Sun, 10 Oct 1999 17:00:26 +0000 (17:00 +0000)]
Improve pg_dump template1 error reports.
Bruce Momjian [Sun, 10 Oct 1999 16:53:51 +0000 (16:53 +0000)]
Re-add mention of FAQ's for shared memory/ipc errors.
Bruce Momjian [Sun, 10 Oct 1999 14:42:44 +0000 (14:42 +0000)]
Improve pg_dump template1 error message.
Thomas G. Lockhart [Sat, 9 Oct 1999 02:30:02 +0000 (02:30 +0000)]
Remove rogue </book> tag left in from normalizing this chapter in emacs.
Thomas G. Lockhart [Sat, 9 Oct 1999 02:29:15 +0000 (02:29 +0000)]
Repair markup for sgmltools writeup.
Fix indenting and make other minor markup improvements.
Thomas G. Lockhart [Sat, 9 Oct 1999 02:26:52 +0000 (02:26 +0000)]
Minor repairs of markup.
Bruce Momjian [Sat, 9 Oct 1999 01:32:38 +0000 (01:32 +0000)]
Allow \r as whitespace.
Bruce Momjian [Sat, 9 Oct 1999 01:31:36 +0000 (01:31 +0000)]
Update contrib/README.
Bruce Momjian [Sat, 9 Oct 1999 01:30:23 +0000 (01:30 +0000)]
Move __alpha to port/alpha.h.
Bruce Momjian [Sat, 9 Oct 1999 01:08:51 +0000 (01:08 +0000)]
Remove contrib/int8.
Bruce Momjian [Fri, 8 Oct 1999 17:14:46 +0000 (17:14 +0000)]
Define __alpha__ for __alpha.
Jan Wieck [Fri, 8 Oct 1999 12:00:08 +0000 (12:00 +0000)]
First real FOREIGN KEY constraint trigger functionality.
Implemented now:
FOREIGN KEY ... REFERENCES ... MATCH FULL
FOREIGN KEY ... MATCH FULL ... ON DELETE CASCADE
Jan
Michael Meskes [Fri, 8 Oct 1999 11:05:05 +0000 (11:05 +0000)]
*** empty log message ***
Bruce Momjian [Fri, 8 Oct 1999 05:36:58 +0000 (05:36 +0000)]
Update display of debug levels.
Bruce Momjian [Fri, 8 Oct 1999 05:27:14 +0000 (05:27 +0000)]
clean up debug flags.
Bruce Momjian [Fri, 8 Oct 1999 05:20:48 +0000 (05:20 +0000)]
Comment cleanup.
Bruce Momjian [Fri, 8 Oct 1999 05:03:14 +0000 (05:03 +0000)]
Fix for "--" comment and no trailing newline, as seen in Perl.
Bruce Momjian [Fri, 8 Oct 1999 04:28:57 +0000 (04:28 +0000)]
Cleanup -is flag to -l for SSL. Another PERL variable name fix. Clean
up debugging options for postmaster and postgres programs. postmaster
-d is no longer optional. Documentation updates.
Tom Lane [Fri, 8 Oct 1999 03:49:55 +0000 (03:49 +0000)]
Remove a no-longer-needed kluge for degenerate aggregate cases,
and update some comments.
Vadim B. Mikheev [Fri, 8 Oct 1999 02:16:22 +0000 (02:16 +0000)]
More startup/shutdown log messages.
Bruce Momjian [Fri, 8 Oct 1999 00:15:49 +0000 (00:15 +0000)]
Use $(PERL) variable for perl compile. Now in Makefile.global.
Bruce Momjian [Thu, 7 Oct 1999 16:40:36 +0000 (16:40 +0000)]
Add quotes to password example.
Tom Lane [Thu, 7 Oct 1999 05:48:03 +0000 (05:48 +0000)]
Somehow missed this call to addRangeTableEntry() ...
Tom Lane [Thu, 7 Oct 1999 04:23:24 +0000 (04:23 +0000)]
Fix planner and rewriter to follow SQL semantics for tables that are
mentioned in FROM but not elsewhere in the query: such tables should be
joined over anyway. Aside from being more standards-compliant, this allows
removal of some very ugly hacks for COUNT(*) processing. Also, allow
HAVING clause without aggregate functions, since SQL does. Clean up
CREATE RULE statement-list syntax the same way Bruce just fixed the
main stmtmulti production.
CAUTION: addition of a field to RangeTblEntry nodes breaks stored rules;
you will have to initdb if you have any rules.
Vadim B. Mikheev [Wed, 6 Oct 1999 22:44:25 +0000 (22:44 +0000)]
Small cleanup.
Vadim B. Mikheev [Wed, 6 Oct 1999 21:58:18 +0000 (21:58 +0000)]
XLOG (also known as WAL -:)) Bootstrap/Startup/Shutdown.
First step in cleaning up backend initialization code.
Fix for FATAL: now FATAL is ERROR + exit.
Bruce Momjian [Wed, 6 Oct 1999 18:20:31 +0000 (18:20 +0000)]
More more liszt language code, so remove it from pg_language.
Bruce Momjian [Wed, 6 Oct 1999 13:46:54 +0000 (13:46 +0000)]
Update TODO list.
Bruce Momjian [Wed, 6 Oct 1999 13:36:50 +0000 (13:36 +0000)]
Update TODO list.
Hiroshi Inoue [Wed, 6 Oct 1999 06:38:04 +0000 (06:38 +0000)]
Improve the treatment of partial(incomplete) blocks of relation files.
This may solve a TODO item
* Recover or force failure when disk space is exhausted
Vadim B. Mikheev [Wed, 6 Oct 1999 03:08:46 +0000 (03:08 +0000)]
Don't set BootstrapProcessingMode in AddNewRelationTuple() before
heap_insert() any more. No reasons to do it, and old comments
said about this.
Bruce Momjian [Wed, 6 Oct 1999 03:00:16 +0000 (03:00 +0000)]
CmdTuples() returns an int showing the number of affected tuples after an
insert, update or delete. It will return -1 on error, although I've yet
to an error situation to prove that out!
Vince
Bruce Momjian [Tue, 5 Oct 1999 21:13:31 +0000 (21:13 +0000)]
Update TODO list.
Bruce Momjian [Tue, 5 Oct 1999 18:55:45 +0000 (18:55 +0000)]
Update sgmltools install instructions.
Bruce Momjian [Tue, 5 Oct 1999 18:14:31 +0000 (18:14 +0000)]
Allow comment-only lines, and ;;; lines too.
Bruce Momjian [Tue, 5 Oct 1999 15:51:53 +0000 (15:51 +0000)]
Update TODO list.
Bruce Momjian [Mon, 4 Oct 1999 17:05:51 +0000 (17:05 +0000)]
Update sgmltools for docs.
Thomas G. Lockhart [Mon, 4 Oct 1999 15:18:54 +0000 (15:18 +0000)]
Expunge "UNIX" in favor of "Unix".
A few other changes, but I forget what :(
Bruce Momjian [Mon, 4 Oct 1999 15:17:06 +0000 (15:17 +0000)]
As we now use lipq++.H which wasn't around when I first posted the
2 line GetIsNull diffs, we now need this too:
Patrick Welche
Thomas G. Lockhart [Mon, 4 Oct 1999 15:16:35 +0000 (15:16 +0000)]
Add mention of transactions and large objects.
Still need the code updated for LO examples.
Tom Lane [Mon, 4 Oct 1999 04:38:46 +0000 (04:38 +0000)]
Less noisy rule display...
Bruce Momjian [Mon, 4 Oct 1999 04:37:46 +0000 (04:37 +0000)]
Fix typo in sgml source.
Tom Lane [Mon, 4 Oct 1999 04:37:23 +0000 (04:37 +0000)]
Make the rule deparser a little less quote-happy, so that
display of default expressions isn't quite so ugly.
Tom Lane [Mon, 4 Oct 1999 02:12:26 +0000 (02:12 +0000)]
Oops, DEFAULT processing wasn't doing type compatibility checking
quite the same way that transformInsertStatement does, so that an expression
could be accepted by CREATE TABLE and then fail when used. Also, put back
check that CONSTRAINT expressions must yield boolean...
Tom Lane [Sun, 3 Oct 1999 23:55:40 +0000 (23:55 +0000)]
Reimplement parsing and storage of default expressions and constraint
expressions in CREATE TABLE. There is no longer an emasculated expression
syntax for these things; it's full a_expr for constraints, and b_expr
for defaults (unfortunately the fact that NOT NULL is a part of the
column constraint syntax causes a shift/reduce conflict if you try a_expr.
Oh well --- at least parenthesized boolean expressions work now). Also,
stored expression for a column default is not pre-coerced to the column
type; we rely on transformInsertStatement to do that when the default is
actually used. This means "f1 datetime default 'now'" behaves the way
people usually expect it to.
BTW, all the support code is now there to implement ALTER TABLE ADD
CONSTRAINT and ALTER TABLE ADD COLUMN with a default value. I didn't
actually teach ALTER TABLE to call it, but it wouldn't be much work.
Bruce Momjian [Sun, 3 Oct 1999 18:24:03 +0000 (18:24 +0000)]
autoconf
Bruce Momjian [Sun, 3 Oct 1999 18:05:04 +0000 (18:05 +0000)]
I hope this is what you had in mind:
--enable-debug adds -g (unconditionally)
--disable-debug removes -g (if it was already in there somehow)
(giving neither does nothing)
Since none of the templates default CFLAGS with a -g you're not likely
to
end up with two -g flags. Not that they'd hurt though.
It doesn't do anything about C++.
Peter Eisentraut
Bruce Momjian [Sun, 3 Oct 1999 17:22:21 +0000 (17:22 +0000)]
Update TODO list.
Bruce Momjian [Sun, 3 Oct 1999 17:21:46 +0000 (17:21 +0000)]
Update TODO list.
Tom Lane [Sat, 2 Oct 1999 23:29:19 +0000 (23:29 +0000)]
Teach parse_coerce about non-cachable functions (actually,
make it call eval_const_expressions() so that it doesn't have to know).
Tom Lane [Sat, 2 Oct 1999 21:33:33 +0000 (21:33 +0000)]
Allow CREATE FUNCTION's WITH clause to be used for all language types,
not just C, so that ISCACHABLE attribute can be specified for user-defined
functions. Get rid of ParamString node type, which wasn't actually being
generated by gram.y anymore, even though define.c thought that was what
it was getting. Clean up minor bug in dfmgr.c (premature heap_close).
Tom Lane [Sat, 2 Oct 1999 21:27:49 +0000 (21:27 +0000)]
Document formerly-undocumented WITH clause of CREATE FUNCTION.
Tom Lane [Sat, 2 Oct 1999 17:45:31 +0000 (17:45 +0000)]
Replace float.c's #ifdef finite check with a proper autoconf check, so it
works if finite() is a function. Patch from Christof Petig.
Tom Lane [Sat, 2 Oct 1999 04:42:04 +0000 (04:42 +0000)]
Stick finger into a couple more holes in the leaky dike of
modifyAggrefQual. This routine really, really needs to be retired, but
until we have subselects in FROM there's no chance of doing the job right.
In the meantime try to respond to unhandlable cases with elog rather than
coredump.
Tom Lane [Sat, 2 Oct 1999 04:37:52 +0000 (04:37 +0000)]
Fix make_clause and make_opclause to record valid type info
in the Expr nodes they produce. This fixes a few cases of errors like
'typeidTypeRelid: Invalid type - oid = 0' caused by calling parser-related
routines on expression trees that have already been processed by planner-
related routines.
Tom Lane [Sat, 2 Oct 1999 01:08:05 +0000 (01:08 +0000)]
Revise rule-printing routines to use expandable StringInfo buffers, so that
they have no hardwired limit on the length of a rule's text. Fix a couple
of minor bugs in passing --- deparsed UPDATE queries didn't have quotes
around relation name, and quotes and backslashes in constant values weren't
backslash-quoted.
Bruce Momjian [Fri, 1 Oct 1999 15:46:39 +0000 (15:46 +0000)]
Update TODO list.
Thomas G. Lockhart [Fri, 1 Oct 1999 15:26:29 +0000 (15:26 +0000)]
Refer to "name", rather than "table" as the replaceable parameter.
Seems to read better this way...
Thomas G. Lockhart [Fri, 1 Oct 1999 15:24:46 +0000 (15:24 +0000)]
Make a mention of the new TRUNCATE command.
Thomas G. Lockhart [Fri, 1 Oct 1999 15:24:09 +0000 (15:24 +0000)]
Make TABLE an optional keyword, a la LOCK TABLE (gram.y fixes not yet
committed, but will be within a week or two).
Actually include the reference page into the docs...
Thomas G. Lockhart [Fri, 1 Oct 1999 15:21:08 +0000 (15:21 +0000)]
Add keywords from Jan's recent RI features.
Thomas G. Lockhart [Fri, 1 Oct 1999 15:20:06 +0000 (15:20 +0000)]
Remove xref's to reference pages since they are not available in
the Programmer's Guide.
Tom Lane [Fri, 1 Oct 1999 04:08:24 +0000 (04:08 +0000)]
Clean up rewriter routines to use expression_tree_walker and
expression_tree_mutator rather than ad-hoc tree walking code. This shortens
the code materially and fixes a fair number of sins of omission. Also,
change modifyAggrefQual to *not* recurse into subselects, since its mission
is satisfied if it removes aggregate functions from the top level of a
WHERE clause. This cures problems with queries of the form SELECT ...
WHERE x IN (SELECT ... HAVING something-using-an-aggregate), which would
formerly get mucked up by modifyAggrefQual. The routine is still
fundamentally broken, of course, but I don't think there's any way to get
rid of it before we implement subselects in FROM ...
Jan Wieck [Thu, 30 Sep 1999 15:28:34 +0000 (15:28 +0000)]
Fixed opr_sanity regression test to ignore the new
RI_FKey_... constrint triggers when looking for illegal
pg_proc entries.
Jan
Jan Wieck [Thu, 30 Sep 1999 14:54:24 +0000 (14:54 +0000)]
Added utils/adt/ri_triggers with empty shells for the
FOREIGN KEY triggers.
Added pg_proc entries for all the new functions.
Jan
Jan Wieck [Thu, 30 Sep 1999 10:31:47 +0000 (10:31 +0000)]
Removed (useless) pg_proc_prosrc_index
Jan
Tom Lane [Thu, 30 Sep 1999 02:45:17 +0000 (02:45 +0000)]
Reverse out getopt patch --- turns out it doesn't help on my
platform, and there are at least some people it's not broken for. So undo
change until we can discuss a more portable solution.
Tom Lane [Thu, 30 Sep 1999 02:17:23 +0000 (02:17 +0000)]
Un-break optarg() call --- some peoples' optarg libraries
don't like extraneous colons in the option list...
Tom Lane [Thu, 30 Sep 1999 01:12:36 +0000 (01:12 +0000)]
Hmm, guess I forgot to commit this file the other day ...
just some cosmetic changes now, Vadim already fixed the heap_xxx calls.
Bruce Momjian [Wed, 29 Sep 1999 21:53:56 +0000 (21:53 +0000)]
Update TODO list.