ERROR: Function 'format_type(oid, int4)' does not exist
От | Ben Udkow |
---|---|
Тема | ERROR: Function 'format_type(oid, int4)' does not exist |
Дата | |
Msg-id | 9mjsou$18gj$1@news.tht.net обсуждение исходный текст |
Ответы |
Re: ERROR: Function 'format_type(oid, int4)' does not exist
|
Список | 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 по дате отправления: