View Single Post

   
  #3 (permalink)  
Old 04-17-2008, 09:29 PM
Akbar
 
Posts: n/a
Default Re: how to know this row has been referenced or not????

On Wed, 2005-02-09 at 22:22 -0700, Michael Fuhr wrote:
> On Thu, Feb 10, 2005 at 07:00:14PM +0700, Akbar wrote:
>
> > How do I know for sure that "this row" or "that row" has or has not
> > been referenced by other table????

>
> Why do you need to know? What are you trying to do?


Well, I made application using postgresql database.... there is a list
of employee.... if user want to delete the employee data, I have to
check whether this employee data has been referenced or not.... if no
body need this employee data ( has not been referenced ), my application
will delete it... but if somebody need this employee data ( has been
referenced / maybe transaction table need it ), I just move the employee
data to not-active list of employee.....



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Reply With Quote