dropping a rule find an error
От | Prabu Subroto |
---|---|
Тема | dropping a rule find an error |
Дата | |
Msg-id | 20040803095450.12823.qmail@web41812.mail.yahoo.com обсуждение исходный текст |
Ответы |
Re: dropping a rule find an error
|
Список | pgsql-general |
Dear my friends... I want to drop a rule but I get an error message. Could you tell me my I can not drop (delete) the rule? Thank you very much in advance. ps: Here is my try underbelow: postgres@patrix:~> psql kv Welcome to psql 7.4.2, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit kv=# create rule viewpatrixcust as on update to viewpatrix do instead update customer set firstname=new.firstname, lastname=new.lastname where custid=old.custid; ERROR: rule "viewpatrixcust" for relation "viewpatrix" already exists kv=# drop rule viewpatrixcust; ERROR: syntax error at or near ";" at character 25 kv=# __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail
В списке pgsql-general по дате отправления: