Re: [HACKERS] alter operator class

2007-03-19 Thread Tom Lane
Teodor Sigaev <[EMAIL PROTECTED]> writes: > 'alter operator class' command isn't "dumpable": > postgres=# ALTER OPERATOR CLASS name_pattern_ops USING btree RENAME TO > namep_ops; Sure it's dumpable. The point here is that name_pattern_ops is a built-in object and so pg_dump doesn't think it sho

[HACKERS] alter operator class

2007-03-19 Thread Teodor Sigaev
'alter operator class' command isn't "dumpable": postgres=# ALTER OPERATOR CLASS name_pattern_ops USING btree RENAME TO namep_ops; postgres=# create table n (a name); postgres=# create index ni on n (a namep_ops); % pg_dump postgres | psql wow ERROR: operator class "namep_ops" does not ex