summaryrefslogtreecommitdiff
path: root/src/test/regress/serial_schedule
Commit message (Collapse)AuthorAgeFilesLines
* Extend COPY to support COPY (SELECT ...) TO ...Tom Lane2006-08-301-1/+2
| | | | Bernd Helmle
* Add INSERT/UPDATE/DELETE RETURNING, with basic docs and regression tests.Tom Lane2006-08-121-1/+2
| | | | | | | | plpgsql support to come later. Along the way, convert execMain's SELECT INTO support into a DestReceiver, in order to eliminate some ugly special cases. Jonah Harris and Tom Lane
* Add some basic tests of GUC behavior.Tom Lane2006-08-041-2/+3
| | | | Joachim Wieland
* Allow an optional alias for the target table to be specified for UPDATENeil Conway2006-01-221-1/+2
| | | | | | | | | | and DELETE. If specified, the alias must be used instead of the full table name. Also, the alias currently cannot be used in the SET clause of UPDATE. Patch from Atsushi Ogawa, various editorialization by Neil Conway. Along the way, make the rowtypes regression test pass if add_missing_from is enabled, and add a new (skeletal) regression test for DELETE.
* DROP objecttype IF EXISTS for the following objects:Andrew Dunstan2005-11-191-1/+2
| | | | table view index sequence schema type domain conversion
* Track dependencies on shared objects (which is to say, roles; we alreadyTom Lane2005-07-071-1/+2
| | | | | | | have adequate mechanisms for tracking the contents of databases and tablespaces). This solves the longstanding problem that you can drop a user who still owns objects and/or has access permissions. Alvaro Herrera, with some kibitzing from Tom Lane.
* Two-phase commit. Original patch by Heikki Linnakangas, with additionalTom Lane2005-06-171-1/+2
| | | | hacking by Alvaro Herrera and Tom Lane.
* Tablespaces. Alternate database locations are dead, long live tablespaces.Tom Lane2004-06-181-1/+2
| | | | | | | | | There are various things left to do: contrib dbsize and oid2name modules need work, and so does the documentation. Also someone should think about COMMENT ON TABLESPACE and maybe RENAME TABLESPACE. Also initlocation is dead, it just doesn't know it yet. Gavin Sherry and Tom Lane.
* Add some regression tests for composite-type operations.Tom Lane2004-06-061-1/+2
|
* Add CREATE TRIGGER, CREATE INDEX, and CREATE SEQUENCE to the list ofNeil Conway2004-01-111-1/+2
| | | | | | | expressions supported by CREATE SCHEMA. Also added the beginning of some regression tests for CREATE SCHEMA; plenty more work is needed here.
* $Header: -> $PostgreSQL Changes ...PostgreSQL Daemon2003-11-291-1/+1
|
* With pg_autovacuum becoming increasingly popular it's important toBruce Momjian2003-09-131-1/+2
| | | | | | | have a working stats collector. This test is able to discover the problem that was present in 7.4 Beta 2. Manfred Koizar
* This patch adds a new regression test for the UPDATE command. RightBruce Momjian2003-08-261-1/+2
| | | | | | | | | | | | | | now all that is tested is Rod Taylor's recent addition to allow this syntax: UPDATE ... SET <col> = DEFAULT; If anyone else would like to add more UPDATE tests, go ahead -- I just wanted to write a test for the above functionality, and couldn't see an existing test that it would be appropriate to add to. Neil Conway
* Aggregates can be polymorphic, using polymorphic implementation functions.Tom Lane2003-07-011-1/+2
| | | | | | It also works to create a non-polymorphic aggregate from polymorphic functions, should you want to do that. Regression test added, docs still lacking. By Joe Conway, with some kibitzing from Tom Lane.
* Todo items:Bruce Momjian2003-03-201-1/+2
| | | | | | | | | | | | | | | | | | | Add ALTER SEQUENCE to modify min/max/increment/cache/cycle values Also updated create sequence docs to mention NO MINVALUE, & NO MAXVALUE. New Files: doc/src/sgml/ref/alter_sequence.sgml src/test/regress/expected/sequence.out src/test/regress/sql/sequence.sql ALTER SEQUENCE is NOT transactional. It behaves similarly to setval(). It matches the proposed SQL200N spec, as well as Oracle in most ways -- Oracle lacks RESTART WITH for some strange reason. -- Rod Taylor <rbt@rbt.ca>
* Okay, attached is a patch that moves the alter table regression testBruce Momjian2002-09-021-2/+2
| | | | | | | | into a separate parallel group. I can't confirm that this fixes the problem for me (since it only occurs about one in ten or one in twenty runs), but I think it's a good bet that it does... Neil Conway
* PREPARE/EXECUTE statements. Patch by Neil Conway, some kibitzingTom Lane2002-08-271-1/+2
| | | | from Tom Lane.
* # Disallow TRUNCATE on tables that are involved in referentialBruce Momjian2002-08-221-1/+2
| | | | | | | | | | | | | constraints The issue with finding and removing foreign key constraints is no longer an issue, so please apply the attached. It does NOT check for rules or on delete triggers (old style foreign keys) as those are difficult to deal with (remove, truncate, re-add). Rod Taylor
* Make cluster regress test functional.Tom Lane2002-08-111-1/+2
|
* Implement DROP CONVERSIONTatsuo Ishii2002-07-251-1/+2
| | | | Add regression test
* oid is needed, it is added at the end of the struct (after the nullBruce Momjian2002-07-201-1/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | bitmap, if present). Per Tom Lane's suggestion the information whether a tuple has an oid or not is carried in the tuple descriptor. For debugging reasons tdhasoid is of type char, not bool. There are predefined values for WITHOID, WITHOUTOID and UNDEFOID. This patch has been generated against a cvs snapshot from last week and I don't expect it to apply cleanly to current sources. While I post it here for public review, I'm working on a new version against a current snapshot. (There's been heavy activity recently; hope to catch up some day ...) This is a long patch; if it is too hard to swallow, I can provide it in smaller pieces: Part 1: Accessor macros Part 2: tdhasoid in TupDesc Part 3: Regression test Part 4: Parameter withoid to heap_addheader Part 5: Eliminate t_oid from HeapTupleHeader Part 2 is the most hairy part because of changes in the executor and even in the parser; the other parts are straightforward. Up to part 4 the patched postmaster stays binary compatible to databases created with an unpatched version. Part 5 is small (100 lines) and finally breaks compatibility. Manfred Koizar
* This patch fixes a regression caused by my recent changes to heapBruce Momjian2002-07-201-1/+2
| | | | | | | | | | | | | | tuple header. The fix is based on the thought that HEAP_MOVED_IN is not needed any more as soon as HEAP_XMIN_COMMITTED has been set. So in tqual.c and vacuum.c the HEAP_MOVED bits are cleared when HEAP_XMIN_COMMITTED is set. Vacuum robustness is enhanced by rearranging ifs, so that we have a chance to elog(ERROR, ...) before an assertion fails. A new regression test is included. Manfred Koizar
* The attached patch (against HEAD) implementsBruce Momjian2002-07-181-1/+2
| | | | | | | | | | | | | | | COPY x (a,d,c,b) from stdin; COPY x (a,c) to stdout; as well as the corresponding changes to pg_dump to use the new functionality. This functionality is not available when using the BINARY option. If a column is not specified in the COPY FROM statement, its default values will be used. In addition to this functionality, I tweaked a couple of the error messages emitted by the new COPY <options> checks. Brent Verner
* Attached is a regression test patch for SRFs. I based it on the testBruce Momjian2002-06-201-2/+2
| | | | | | | | scripts that I have been using, minus the C function tests and without calls to random() -- figured random() wouldn't work too well for a regression test ;-) Joe Conway
* Add INSERT(..., DEFAULT, ).Bruce Momjian2002-04-051-1/+2
| | | | Rod Taylor
* Add DOMAIN support. Includes manual pages and regression tests, fromBruce Momjian2002-03-191-1/+3
| | | | Rod Taylor.
* Add separate regression tests for timetz and the new timestamptz type.Thomas G. Lockhart2001-09-281-1/+3
| | | | | Modify the timestamp test to reflect the "no time zone" behavior of this new code; timestamptz resembles the old timestamp code.
* Back out has_table_privilege patch.Bruce Momjian2001-06-121-2/+1
|
* OK -- here's take #5.Bruce Momjian2001-06-121-1/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | It "make"s and "make check"s clean against current cvs tip. There are now both Text and Name variants, and the regression test support is rolled into the patch. Note that to be complete wrt Name based variants, there are now 12 user visible versions of has_table_privilege: has_table_privilege(Text usename, Text relname, Text priv_type) has_table_privilege(Text usename, Name relname, Text priv_type) has_table_privilege(Name usename, Text relname, Text priv_type) has_table_privilege(Name usename, Name relname, Text priv_type) has_table_privilege(Text relname, Text priv_type) /* assumes current_user */ has_table_privilege(Name relname, Text priv_type) /* assumes current_user */ has_table_privilege(Text usename, Oid reloid, Text priv_type) has_table_privilege(Name usename, Oid reloid, Text priv_type) has_table_privilege(Oid reloid, Text priv_type) /* assumes current_user */ has_table_privilege(Oid usesysid, Text relname, Text priv_type) has_table_privilege(Oid usesysid, Name relname, Text priv_type) has_table_privilege(Oid usesysid, Oid reloid, Text priv_type) For the Text based inputs, a new internal function, get_Name is used (shamelessly copied from get_seq_name in sequence.c) to downcase if not quoted, or remove quotes if quoted, and truncate. I also added a few test cases for the downcasing, quote removal, and Name based variants to the regression test. Joe Conway
* Make UPDATE and DELETE privileges distinct. Add REFERENCES and TRIGGERPeter Eisentraut2001-05-271-1/+2
| | | | | privileges. INSERT and COPY FROM now require INSERT (only). Add privileges regression test.
* Bit string regression testPeter Eisentraut2000-11-221-1/+2
| | | | from Adriaan Joubert <a.joubert@albourne.com>
* Fix test orderPeter Eisentraut2000-10-011-7/+11
|
* New unified regression test driver, test/regress makefile cleanup,Peter Eisentraut2000-09-291-0/+74
add "check" and "installcheck" targets, straighten out make variable naming of host_os, host_cpu, etc.
View Lorry Controller Status