can't delete a notice if it has been replied to. 2009-03-11 11:56:38 NZDT ERROR: update or delete on table "notice" violates foreign key constraint "notice_reply_to_fkey" on table "notice" 2009-03-11 11:56:38 NZDT DETAIL: Key (id)=(44) is still referenced from table "notice". 2009-03-11 11:56:38 NZDT STATEMENT: DELETE FROM "notice" WHERE ( "notice"."id" = 44 )
What's the way forward here? remove the foreign key? or instead deleting we make that notice with SET deleted=true. .. Some other method? On Mon, Mar 9, 2009 at 10:02 PM, Ciaran Gultnieks <[email protected]> wrote: > > Brenda Wallace wrote: >> I set up laconica on postgres 8.3 this weekend, and needed several >> patches to get it going. >> >> I've put those patches up at: >> http://gitorious.org/projects/laconica/repos/br3nda-postgres > > Thanks. I can't find any changes in there that aren't already fixed > in the dev repository though, unless I've missed something. Perhaps > you could try merging and running with the latest dev? There are > definitely a number of fixes in dev for postgres that aren't in your > clone. > > Cheers, > > Ciaran > > _______________________________________________ Laconica-dev mailing list [email protected] http://mail.laconi.ca/mailman/listinfo/laconica-dev
