[Dbix-class] deleting from a view

[Peter Edwards]

On 6 July 2011 15:01, Dave Howorth <dhoworth at mrc-lmb.cam.ac.uk> wrote:

> I have a DBIC class made up using a UNION, something like this
>  __PACKAGE__->result_source_instance->is_virtual(1);
>  __PACKAGE__->result_source_instance->view_definition(
>   "SELECT
>        sp_id AS id,
>
> ...

> I've discovered that this doesn't work:
>
>  $node_rs->search({status =3D> 'obsolete' })->delete;
>
>
I thought you couldn't Delete through a View in most databases?

Regards, Peter
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20110706/12c=
201cd/attachment.htm