Forum OpenACS Development: cr_mime_type

Collapse
1: cr_mime_type
Posted by Sid Widge on 09/03/01 08:13 AM
Hi all, I have been getting this error for a while, I have been scratching my head over it for a while, but no luck. Hopefully someone can let me know why I get it. ERROR IS: cr_mime_types_pk is an index relation CODE IS: 
insert into cr_mime_types_pk (mime_type)
 select 'application/octet-stream'
  from dual
  where not exists (select 1 from cr_mime_types where mime_type =
'application/octet-stream');
Collapse
2: Response to cr_mime_type (response to 1)
Posted by Jack Purswani on 09/03/01 09:02 AM
Thanks everyone... But we have solved the problem.

Just removed the '_pk' in the 'cr_mime_types'. Realised this mistake after looking up the tables in psql.

thanks
Jack