Received: from typhoon.mail.pipex.net (typhoon.mail.pipex.net [158.43.128.27]) by hub.org (8.9.3/8.9.3) with SMTP id TAA32442 for ; Sat, 17 Jul 1999 19:29:38 -0400 (EDT) (envelope-from yd80@dial.pipex.com) Received: (qmail 11749 invoked from network); 17 Jul 1999 23:29:36 -0000 Received: from userb721.uk.uudial.com (HELO m0n7y) (193.149.83.196) by smtp.dial.pipex.com with SMTP; 17 Jul 1999 23:29:36 -0000 Message-ID: <003401bed0f0$75f34c00$010aa8c0@m0n7y> Reply-To: "Stephen Boyle" From: "Stephen Boyle" To: "Ademir Mazer Jr" , Cc: "Renato Souza" Subject: Re: [SQL] Stored Procedures and other stuffs Date: Sun, 18 Jul 1999 00:37:56 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Ademir, AFAIK stored procedures are not implemented but most of their functionality can be implemented with either VIEWS or functions (written in plpgsql, tcl, c ..). I think I read that its currently on a TODO list. Primary key referential integrity is supported but Foreign key is parsed but not implemented yet (6.5). Again this behavior can be emulated using plpgsql / triggers. If you're porting from Access 97 to Postgres you may like to have a look at pgupt - Postgres Upsizing Tool - Its a work in progress but it will automate most of the upsizing process including automatic creation of triggers and functions for referential integrity as per MSAccess. http://dspace.dial.pipex.com/boylesa/pgupt/pgupt.shtml The ODBC link should be no problem. Hope this helps Steve Boyle Roselink Systems Limited -----Original Message----- From: Ademir Mazer Jr To: pgsql-sql@postgreSQL.org Cc: Renato Souza Date: 16 July 1999 06:20 Subject: [SQL] Stored Procedures and other stuffs >Hi, I'm not using PostgreSQL yet. First I need to know if it will satisfy >me. >So, I need to know if it has stored procedures, referential integrity, etc. > >I also need to know if I can developer my client application, that will be >in visual basic, accessing an Access database by ODBC, and later put my >PostgresSQL Server to run. > >Thank you > >[]'s > >Ademir > >