============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Roel Bouwman
Your email address : [EMAIL PROTECTED]
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel
Operating System (example: Linux 2.0.26 ELF) : FreeBSD 3.1
PostgreSQL version (example: PostgreSQL-6.5.1): PostgreSQL-7b1
Compiler used (example: gcc 2.8.0) : gcc 2.7.2.1
Please enter a FULL description of your problem:
------------------------------------------------
Various functions seem to be missing.
Running \df in psql results in the following output:
ERROR: No such function 'oid8types' with the specified attributes
Running the statement:
select datetime('20000229'::date, '18:34'::time);
results in:
ERROR: No such function 'datetime' with the specified attributes
while in v6.4 this statement returns:
datetime
----------------------------
Tue Feb 29 18:34:00 2000 MET
It seems like a large number of functions are missing in
pg_proc.h ($Id: pg_proc.h,v 1.124 2000/02/21 03:36:55 tgl Exp $).
There are 1039 rows in pg_proc.
The statement "seleCt proname from pg_proc where proname like '%datetime%'"
returns exactly one row:
proname
------------------
datetime_timestamp
while in 6.4 there are 35 functions.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
See above.
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
Groeten,
Roel Bouwman.
---
Roel Bouwman, [EMAIL PROTECTED], URL: http://roel.bouwman.net/
My PGP Public Key can be found on http://roel.bouwman.net/pgpkey.txt
PGP signature
