From: | "Ben Udkow" <ben(at)udkow(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | ERROR: Function 'format_type(oid, int4)' does not exist |
Date: | 2001-08-30 02:21:25 |
Message-ID: | 9mjsou$18gj$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)udkow(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Horst Herb | 2001-08-30 03:40:49 | Re: Re: [SQL] getting the oid for a new tuple in a BEFORE trigger |
Previous Message | Tatsuo Ishii | 2001-08-30 00:58:04 | Re: Default encoding in database |