diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-05-14 03:26:03 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-05-14 03:26:03 +0000 |
| commit | f85f43dfb5b9043ea6b01d8b824c195cd7f9ed3c (patch) | |
| tree | 149a8221767ed2e9c63adc58cc88c4d8faca5381 /contrib/spi | |
| parent | d9b679c13a820eb7b464a1eeb1f177c3fea13ece (diff) | |
| download | postgresql-f85f43dfb5b9043ea6b01d8b824c195cd7f9ed3c.tar.gz | |
Backend support for autocommit removed, per recent discussions. The
only remnant of this failed experiment is that the server will take
SET AUTOCOMMIT TO ON. Still TODO: provide some client-side autocommit
logic in libpq.
Diffstat (limited to 'contrib/spi')
| -rw-r--r-- | contrib/spi/autoinc.sql.in | 2 | ||||
| -rw-r--r-- | contrib/spi/insert_username.sql.in | 2 | ||||
| -rw-r--r-- | contrib/spi/moddatetime.sql.in | 2 | ||||
| -rw-r--r-- | contrib/spi/refint.sql.in | 2 | ||||
| -rw-r--r-- | contrib/spi/timetravel.sql.in | 2 |
5 files changed, 0 insertions, 10 deletions
diff --git a/contrib/spi/autoinc.sql.in b/contrib/spi/autoinc.sql.in index cec50b6189..75889b3786 100644 --- a/contrib/spi/autoinc.sql.in +++ b/contrib/spi/autoinc.sql.in @@ -1,8 +1,6 @@ -- Adjust this setting to control where the objects get created. SET search_path = public; -SET autocommit TO 'on'; - CREATE OR REPLACE FUNCTION autoinc() RETURNS trigger AS 'MODULE_PATHNAME' diff --git a/contrib/spi/insert_username.sql.in b/contrib/spi/insert_username.sql.in index c8c6766579..3d096592d2 100644 --- a/contrib/spi/insert_username.sql.in +++ b/contrib/spi/insert_username.sql.in @@ -1,8 +1,6 @@ -- Adjust this setting to control where the objects get created. SET search_path = public; -SET autocommit TO 'on'; - CREATE OR REPLACE FUNCTION insert_username() RETURNS trigger AS 'MODULE_PATHNAME' diff --git a/contrib/spi/moddatetime.sql.in b/contrib/spi/moddatetime.sql.in index e89c37e6d5..9bdaa9aefe 100644 --- a/contrib/spi/moddatetime.sql.in +++ b/contrib/spi/moddatetime.sql.in @@ -1,8 +1,6 @@ -- Adjust this setting to control where the objects get created. SET search_path = public; -SET autocommit TO 'on'; - CREATE OR REPLACE FUNCTION moddatetime() RETURNS trigger AS 'MODULE_PATHNAME' diff --git a/contrib/spi/refint.sql.in b/contrib/spi/refint.sql.in index 322de9521e..14b135e258 100644 --- a/contrib/spi/refint.sql.in +++ b/contrib/spi/refint.sql.in @@ -1,8 +1,6 @@ -- Adjust this setting to control where the objects get created. SET search_path = public; -SET autocommit TO 'on'; - CREATE OR REPLACE FUNCTION check_primary_key() RETURNS trigger AS 'MODULE_PATHNAME' diff --git a/contrib/spi/timetravel.sql.in b/contrib/spi/timetravel.sql.in index b297a23ec2..f20e9fedf6 100644 --- a/contrib/spi/timetravel.sql.in +++ b/contrib/spi/timetravel.sql.in @@ -1,8 +1,6 @@ -- Adjust this setting to control where the objects get created. SET search_path = public; -SET autocommit TO 'on'; - CREATE OR REPLACE FUNCTION timetravel() RETURNS trigger AS 'MODULE_PATHNAME' |