X-Original-To: pgsql-php-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1701B9FA6A2 for ; Mon, 19 Jun 2006 14:29:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 69703-05 for ; Mon, 19 Jun 2006 14:29:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web33302.mail.mud.yahoo.com (web33302.mail.mud.yahoo.com [68.142.206.117]) by postgresql.org (Postfix) with SMTP id 8FC139F9998 for ; Mon, 19 Jun 2006 14:29:22 -0300 (ADT) Received: (qmail 33314 invoked by uid 60001); 19 Jun 2006 17:29:21 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=hYD2HYfxSxLBMObSb1reBT67SURXuW/oIwDrbgVdzG9Qq2WnYkIMBSoGo9PTrNm1rIZ+aY2bv0yEjKWL0CqMLRCXP5v6JHW8nlDoqzDuGGjnb1pypWBOC+7lmyc+cGru3XphOa9099BGYMgL+shkrzoPFf+sAgv7F63+CSraI0Y= ; Message-ID: <20060619172921.33312.qmail@web33302.mail.mud.yahoo.com> Received: from [12.9.179.126] by web33302.mail.mud.yahoo.com via HTTP; Mon, 19 Jun 2006 10:29:21 PDT Date: Mon, 19 Jun 2006 10:29:21 -0700 (PDT) From: Subject: Re: lost data To: enzovenegas@mixmail.com, "pgsql-php@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/16 X-Sequence-Number: 3541 > hello, I have a database in postgresql running in > linux mandriva, it is for a > system of purchases, and I am suffering an important > one lost of data in > the table of products, I have all the key primary > and forean made > validations, in my alone system an user has access > to modify products and > you that the it doesn't erase them, like I can know > as much as I space he > has assigned my database, and if I can take a > registration of when the > data are eliminated, any help serves, thank you. > > enzo i'm not sure i'm reading right, but it sounds like you could add an is_active boolean column. if the boolean is true, the product is considered active. if false, the product is considered "deleted", even though it isn't eally deleted. deny permission to delete from the products table. you will not accidently lose any products this way. if you *absolutely* know you want to delete a product, you can do so manually - or set up an interface that allows for deleting and deny access to ordinary users. i hope i understood correctly. good luck. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com