ERROR: Function 'format_type(oid, int4)' does not exist

Started by Ben Udkowover 24 years ago2 messagesgeneral
Jump to latest
#1Ben Udkow
ben@udkow.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Ben Udkow (#1)
Re: ERROR: Function 'format_type(oid, int4)' does not exist

"Ben Udkow" <ben@udkow.com> writes:

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

It looks to me like you are running a 7.1 psql application against a
pre-7.1 backend.

regards, tom lane