Int_aggregate/pgstattuple minor fix

Поиск
Список
Период
Сортировка
От Dave Page
Тема Int_aggregate/pgstattuple minor fix
Дата
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E4306853@ratbert.vale-housing.co.uk
обсуждение исходный текст
Ответы Re: Int_aggregate/pgstattuple minor fix  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
The patch below removes attempts to drop objects before creating them
from the int_aggregate and pgstattuple SQL scripts. This causes the
script to fail on databases where the affected objects don't already
exist when the script is executed by the Win32 installer, pgAdmin or any
other interface that executes scripts 'as-is'. None of the other contrib
scripts appear do this.

Please apply.

Regards, Dave


Index: int_aggregate.sql.in
===================================================================
RCS file:
/projects/cvsroot/pgsql-server/contrib/intagg/int_aggregate.sql.in,v
retrieving revision 1.5
diff -u -r1.5 int_aggregate.sql.in
--- int_aggregate.sql.in    14 May 2003 03:25:56 -0000    1.5
+++ int_aggregate.sql.in    1 Oct 2004 13:23:25 -0000
@@ -17,7 +17,7 @@

 -- The aggration funcion.
 -- uses the above functions to create an array of integers from an
aggregation.
-DROP AGGREGATE int_array_aggregate(int4);
+-- DROP AGGREGATE int_array_aggregate(int4);
 CREATE AGGREGATE int_array_aggregate (
     BASETYPE = int4,
     SFUNC = int_agg_state,
Index: pgstattuple.sql.in
===================================================================
RCS file:
/projects/cvsroot/pgsql-server/contrib/pgstattuple/pgstattuple.sql.in,v
retrieving revision 1.8
diff -u -r1.8 pgstattuple.sql.in
--- pgstattuple.sql.in    12 Jun 2003 08:02:53 -0000    1.8
+++ pgstattuple.sql.in    1 Oct 2004 13:30:27 -0000
@@ -1,7 +1,7 @@
 -- Adjust this setting to control where the objects get created.
 SET search_path = public;

-DROP TYPE pgstattuple_type CASCADE;
+-- DROP TYPE pgstattuple_type CASCADE;
 CREATE TYPE pgstattuple_type AS (
     table_len BIGINT,        -- physical table length in
bytes
     tuple_count BIGINT,        -- number of live tuples

В списке pgsql-patches по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Preliminary patch for FRONTEND
Следующее
От: Sergej Sergeev
Дата:
Сообщение: Re: plperl features