summaryrefslogtreecommitdiff
path: root/src/backend/commands/command.c
AgeCommit message (Collapse)Author
2000-06-15Final #include cleanup.Bruce Momjian
2000-06-12Back out pg_shadow changes to allow create table and locking permissions.Bruce Momjian
2000-06-09 I have large database and with this DB work more users and I very needBruce Momjian
more restriction for fretful users. The current PG allow define only NO-CREATE-DB and NO-CREATE-USER restriction, but for some users I need NO-CREATE-TABLE and NO-LOCK-TABLE. This patch add to current code NOCREATETABLE and NOLOCKTABLE feature: CREATE USER username [ WITH [ SYSID uid ] [ PASSWORD 'password' ] ] [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ] -> [ CREATETABLE | NOCREATETABLE ] [ LOCKTABLE | NOLOCKTABLE ] ...etc. If CREATETABLE or LOCKTABLE is not specific in CREATE USER command, as default is set CREATETABLE or LOCKTABLE (true). A user with NOCREATETABLE restriction can't call CREATE TABLE or SELECT INTO commands, only create temp table is allow for him. Karel
2000-06-04Disallow CLOSE of reserved system portal names.Tom Lane
2000-05-30Added header files required for ALTER TABLE DROP COLUMNHiroshi Inoue
trial implementation.
2000-05-30Remove unused include files. Do not touch /port or includes used by defines.Bruce Momjian
2000-05-29Generated header files parse.h and fmgroids.h are now copied intoTom Lane
the src/include tree, so that -I backend is no longer necessary anywhere. Also, clean up some bit rot in contrib tree.
2000-05-29Second round of fmgr changes: triggers are now invoked in new style,Tom Lane
CurrentTriggerData is history.
2000-05-28First round of changes for new fmgr interface. fmgr itself and theTom Lane
key call sites are changed, but most called functions are still oldstyle. An exception is that the PL managers are updated (so, for example, NULL handling now behaves as expected in plperl and plpgsql functions). NOTE initdb is forced due to added column in pg_proc.
2000-04-12Ye-old pgindent run. Same 4-space tabs.Bruce Momjian
2000-03-09Trial implementation of ALTER DROP COLUMN.Hiroshi Inoue
They are #ifdef'd. Add -D_DROP_COLUMN_HACK__ compile option to evaluate it.
2000-02-15Removed unused var to silence gcc warning.Tom Lane
2000-02-04Added ALTER TABLE ... ADD CONSTRAINT (provided by Stephan Szabo).Jan Wieck
Added constraint dumping capability to pg_dump (also from Stephan) Fixed DROP TABLE -> RelationBuildTriggers: 2 record(s) not found for rel error. Fixed little error in gram.y I made the last days. Jan
2000-01-29A few minor psql enhancementsPeter Eisentraut
Initdb help correction Changed end/abort to commit/rollback and changed related notices Commented out way old printing functions in libpq Fixed a typo in alter table / alter column
2000-01-26Add:Bruce Momjian
* Portions Copyright (c) 1996-2000, PostgreSQL, Inc to all files copyright Regents of Berkeley. Man, that's a lot of files.
2000-01-24Removed alter table drop column.Peter Eisentraut
2000-01-22added ALTER TABLE DROP COLUMN, early versionPeter Eisentraut
2000-01-16Included all yacc and lex files into the distribution.Peter Eisentraut
1999-12-20Required catalog changes for extended LONG attribute storage.Jan Wieck
Jan
1999-12-16Some changes to prepare for LONG attributes.Jan Wieck
Jan
1999-12-14fix_parsetree_attnums was not nearly smart enough about walking parseTom Lane
trees. Also rewrite find_all_inheritors() in a more intelligible style.
1999-12-10Rename several destroy* functions/tags to drop*.Bruce Momjian
1999-11-24Rename heap_replace to heap_update.Bruce Momjian
1999-11-22Add system indexes to match all caches.Bruce Momjian
Make all system indexes unique. Make all cache loads use system indexes. Rename *rel to *relid in inheritance tables. Rename cache names to be clearer.
1999-11-07New NameStr macro to convert Name to Str. No need for var.data anymore.Bruce Momjian
Fewer calls to nameout. Better use of RelationGetRelationName.
1999-10-03Reimplement parsing and storage of default expressions and constraintTom Lane
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.
1999-09-18Mega-commit to make heap_open/heap_openr/heap_close take anTom Lane
additional argument specifying the kind of lock to acquire/release (or 'NoLock' to do no lock processing). Ensure that all relations are locked with some appropriate lock level before being examined --- this ensures that relevant shared-inval messages have been processed and should prevent problems caused by concurrent VACUUM. Fix several bugs having to do with mismatched increment/decrement of relation ref count and mismatched heap_open/close (which amounts to the same thing). A bogus ref count on a relation doesn't matter much *unless* a SI Inval message happens to arrive at the wrong time, which is probably why we got away with this sloppiness for so long. Repair missing grab of AccessExclusiveLock in DROP TABLE, ALTER/RENAME TABLE, etc, as noted by Hiroshi. Recommend 'make clean all' after pulling this update; I modified the Relation struct layout slightly. Will post further discussion to pghackers list shortly.
1999-09-04Remove no-longer-needed code to update temprel's copy ofTom Lane
pg_class tuple during ALTER TABLE ADD COLUMN.
1999-07-17 Move some system includes into c.h, and remove duplicates.Bruce Momjian
1999-07-16Final cleanup.Bruce Momjian
1999-07-15Change #include's to use <> and "" as appropriate.Bruce Momjian
1999-07-15Remove unused #includes in *.c files.Bruce Momjian
1999-07-15Clean up #include in /include directory. Add scripts for checking includes.Bruce Momjian
1999-06-19Change form() to varargform() to prevent portability problems.Bruce Momjian
1999-05-25Another pgindent run. Sorry folks.Bruce Momjian
1999-05-25pgindent run over code.Bruce Momjian
1999-05-10Change error messages to oids come out as %u and not %d. Change has noBruce Momjian
real affect now.
1999-04-13Fix adding columns to a temp table.Bruce Momjian
1999-03-30Small cleanups.Bruce Momjian
1999-03-23cleanupsBruce Momjian
1999-03-17Add new postgres -O option to allow system table structure changes.Bruce Momjian
1999-02-24Fix problem with selectivity error in added columns with ALTER TABLE.Bruce Momjian
Move files to deadcode.
1999-02-13Change my-function-name-- to my_function_name, and optimizer renames.Bruce Momjian
1999-02-08Added LIMIT/OFFSET functionality including new regression test for it.Jan Wieck
Removed CURRENT keyword for rule queries and changed rules regression accordingly. CURRENT has beed announced to disappear in v6.5. Jan
1999-02-03Cleanup of source files where 'return' or 'var =' is alone on a line.Bruce Momjian
1998-12-18SET TRANSACTION ISOLATION LEVEL ...Vadim B. Mikheev
LOCK TABLE IN ... MODE ...implemented
1998-12-15Initial MVCC code.Vadim B. Mikheev
New code for locking buffer' context.
1998-11-27New HeapTuple structure/interface.Vadim B. Mikheev
1998-09-01OK, folks, here is the pgindent output.Bruce Momjian
1998-09-01Renaming cleanup, no pgindent yet.Bruce Momjian
generated by cgit v1.2.3 (git 2.46.0) at 2025-08-17 03:11:47 +0000