From: Massimo Dal Zotto <dz@cs.unitn.it>
Date: Wed, 13 Mar 1996 11:24:53 +0100 (MET)
Subject: [PG95]: postgres95 bug report

============================================================================
                        POSTGRES95 BUG REPORT TEMPLATE
============================================================================

Your name		:	Massimo Dal Zotto
Your email address	:	dz@cs.unitn.it


System Configuration
- ---------------------
  Architecture (example: Intel Pentium)  	:   Intel Pentium

  Operating System (example: Linux 1.3.42 ELF) 	:   Linux 1.3.20 ELF

  Postgres95 version (example: Postgres95-1.01) :   Postgres95-1.01

  Compiler used (example:  gcc 2.7.0)		:   gcc 2.7.0


Please enter a FULL description of your problem:
- ------------------------------------------------

It is not possible to define attributes as arrays of date or time, the
type _time and _date are not defined.

Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible: 
- ----------------------------------------------------------------------

create table a (x time[]);

result is:
WARN:DefineRelation: no such type _time


If you know how this problem might be fixed, list the solution below:
- ---------------------------------------------------------------------

Execute the following commands:

create type _time (
	internallength = variable,
	externallength = variable,
	element = time,
	input = array_in,
	output = array_out,
	send = array_in,
	receive = array_out 
);

create type _date (
	internallength = variable,
	externallength = variable,
	element = date,
	input = array_in,
	output = array_out,
	send = array_in,
	receive = array_out 
);

or apply the following patch and reinstall postgres:

*** src/backend/catalog/pg_type.h.orig	Sat Feb 24 01:10:24 1996
- --- src/backend/catalog/pg_type.h	Tue Mar 12 12:01:10 1996
***************
*** 240,245 ****
- --- 240,247 ----
  
  DATA(insert OID = 1082 ( date      PGUID  4  10 t b t \054 0  0 date_in date_out date_in date_out i _null_ ));
  DATA(insert OID = 1083 ( time      PGUID  8  16 f b t \054 0  0 time_in time_out time_in time_out i _null_ ));
+ DATA(insert OID = 1182 ( _date     PGUID  -1 -1 f b t \054 0  1082 array_in array_out array_in array_out i _null_ ));
+ DATA(insert OID = 1183 ( _time     PGUID  -1 -1 f b t \054 0  1083 array_in array_out array_in array_out d _null_ ));
  /*
   * prototypes for functions in pg_type.c 
   */
- --
Massimo Dal Zotto

+----------------------------------------------------------------------+
|  Massimo Dal Zotto                e-mail:  dz@cs.unitn.it            |
|  Via Marconi, 141                 phone/fax:  ++39-461-534251        |
|  38057 Pergine Valsugana (TN)     pgp:  finger dz@boogie.cs.unitn.it |
|  Italy                                                               |
+----------------------------------------------------------------------+