Hello,
I'm developing an intranet application with Catalyst an postgresql. As deleted
(and old) records needed to be accesible I created the following db
structure:
table: company - contains company data
- PK: id
- on delete/update copy old data to company_historic
table: company__historic
Hello all,
I', triyng to call delete in a resultset with a join. like this:
$schema->resultset('Movie')->search(
{ 'category.update_flag' => 'old' },
{ join => 'category' }
)->delete;
The SQL I'm getting is:
DELETE FROM movie WHERE ( update_flag = ? ): 'old'
And I was
On Thursday 29 November 2007 10:07:24 you wrote:
> Hello,
>
> I'm developing an intranet application with Catalyst an postgresql. As
> deleted (and old) records needed to be accesible I created the following db
> structure:
>
> table: company - contains company data
> - PK: id
> - on delete/upd
Hello.
I've got table_a(id SERIAL PK, v TEXT), table_b(id SERIAL PK, v TEXT),
and table_c(id SERIAL PK, x REF table_a(id), y REF table_b(id), z REF
table_b(id)). When I try to insert data to table_a and table_b through
table_c, DBIC errors saying that it tried inserting a NULL value in
the PK colum