[SQL] Problem with my query whithout double-quotes

2002-07-24 Thread ROUWEZ Stephane
Hi, My pgsql runs on WinNT Server 4. When I try to SELECT nom, prenom FROM individu WHERE numero=2 I have : ERROR: Relation "individu" does not exist It only works if I write : SELECT "Individu"."Nom","Individu"."Prenom" FROM "Individu" WHERE "Individu"."NumIndiv"=2 Can someone help me ? Th

Re: [SQL] Change size of a field

2002-08-02 Thread ROUWEZ Stephane
Hi, Thank you, it works but I loose my foreign keys and the privileges for groups and users. Is there a solution ? Stef -Message d'origine- De : Achilleus Mantzios [mailto:[EMAIL PROTECTED]] Envoye : vendredi 26 juillet 2002 14:50 A : ROUWEZ Stephane Cc : '[EMAIL PROTECTE