diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-08-15 02:53:35 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-08-15 02:53:35 +0000 |
| commit | 46aaa5dda3a876ad958d4ea8fe3e8836d2043750 (patch) | |
| tree | b1ec83eb856247f6fce4fa0fb3d666a9d8893d9f /src/interfaces/python/tutorial/syscat.py | |
| parent | 45e25445846e98fe4aac23d1073566c08cd62f0b (diff) | |
| download | postgresql-46aaa5dda3a876ad958d4ea8fe3e8836d2043750.tar.gz postgresql-46aaa5dda3a876ad958d4ea8fe3e8836d2043750.zip | |
Appears there is a problem finding the opclass when indexing a domain.
CREATE DOMAIN newint as int4;
CREATE TABLE tab (col newint unique);
ERROR: data type newint has no default operator class for access method
"btree"
You must specify an operator class for the index or define a
default operator class for the data type
Specifically, GetDefaultOpClass() finds 0 exact matches and 3 binary
compatible matches. Fetching getBaseType() of the attribute fixes the
problem for domains (see attachment).
Rod Taylor
Diffstat (limited to 'src/interfaces/python/tutorial/syscat.py')
0 files changed, 0 insertions, 0 deletions