[isf-wifidog] PostgreSQL Question

acv acv at miniguru.ca
Ven 9 Oct 13:16:57 EDT 2009


I believe there's a foreign key constraint so instead of orphaning the
records, it will either disallow the delete or cascade and delete every
database record that references them.

Alex

On Fri, Oct 09, 2009 at 09:49:25AM -0700, Dave Lamb wrote:
> X-Mailer: YahooMailRC/182.10 YahooMailWebService/0.7.347.3
> Date: Fri, 9 Oct 2009 09:49:25 -0700 (PDT)
> From: Dave Lamb <delphi9_1971 at yahoo.com>
> To: wifidog at listes.ilesansfil.org
> Subject: [isf-wifidog] PostgreSQL Question
> 
> Theoretically, if I delete users  from the Users's table in  the PostgreSQL DB, the worst thing that will happen is that I will be orphaning usage records correct?
> 
> Is there any other negative ramifications to deleting users this way?  Anything that will hinder the operation of the Auth Server?
> 
> Right now I have a Single Gateway server (Node) connected to an Independence Auth Server in a Single Network configuration.  I plan on implementing more Gateway servers (Nodes) but no additional Networks.  I'm not sure if this matters to my questions above.
> 
> Thanks!
> 
>  Dave Lamb, CCNA, Network+
> 312-560-6933 C
> 
> 
>       
> _______________________________________________
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
-------------- section suivante --------------
Une pièce jointe autre que texte a été nettoyée...
Nom: non disponible
Type: application/pgp-signature
Taille: 195 octets
Desc: non disponible
URL: <http://listes.ilesansfil.org/pipermail/wifidog/attachments/20091009/352c7d42/attachment.pgp>


Plus d'informations sur la liste de diffusion WiFiDog