pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: operationsengineer1@yahoo.com
To: enzovenegas@mixmail.com, "pgsql-php@postgresql.org" <pgsql-php@postgresql.org>
Subject: Re: lost data
Date: Mon, 19 Jun 2006 10:29:21 -0700 (PDT)
Message-ID: <20060619172921.33312.qmail@web33302.mail.mud.yahoo.com> (raw)
In-Reply-To: <E1FsLiW-00084D-00@relay.mixmail.com>

> 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 



view thread (2+ messages)

Message-ID: <20060619172921.33312.qmail@web33302.mail.mud.yahoo.com>
Permalink:  ../20060619172921.33312.qmail@web33302.mail.mud.yahoo.com/
Also on:    postgresql.org/message-id/20060619172921.33312.qmail@web33302.mail.mud.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: operationsengineer1@yahoo.com
  Subject: Re: lost data
  In-Reply-To: <20060619172921.33312.qmail@web33302.mail.mud.yahoo.com>
  References: <E1FsLiW-00084D-00@relay.mixmail.com> <20060619172921.33312.qmail@web33302.mail.mud.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox