ERROR: Function 'format_type(oid, int4)' does not exist - Mailing list pgsql-general

From Ben Udkow
Subject ERROR: Function 'format_type(oid, int4)' does not exist
Date
Msg-id 9mjsou$18gj$1@news.tht.net
Whole thread Raw
Responses Re: ERROR: Function 'format_type(oid, int4)' does not exist  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I am converting my PostgreSQL data    base to 7.1.2.  I dumped my database
out of the old server, then dumped it into the new one.  Everything takes
okay, but my Indexes are not working.  When I do a "\d" it lists the Name,
Type, and Owner, but when I try and do a \d on a specific table, I get this
error:

customer=# \d pods
ERROR:  Function 'format_type(oid, int4)' does not exist
        Unable to identify a function that satisfies the given argument
types
        You may need to add explicit typecasts

Here are the creation lines:

customer=# CREATE TABLE "pods" ("pod_id" int4,"group_id" int4,"description"
character(30));
CREATE
customer=# CREATE UNIQUE INDEX "pods_pod_id_key" on "pods" using btree
 "pod_id" "int4_ops" );
CREATE

and I can view the index I just created:

customer=# \di pods_pod_id_key
        List of relations
      Name       | Type  | Owner
-----------------+-------+-------
 pods_pod_id_key | index | root
(1 row)

Any ideas?

Thanks!
Ben Udkow
ben@udkow.com



pgsql-general by date:

Previous
From: "Thurstan R. McDougle"
Date:
Subject: Re: mx is needed by postgresql-python-7.1.3-1PGDG
Next
From: "Ron Looi"
Date:
Subject: Error on postgresql driver (or pg_hba)