Received: from alumnos.uc3m.es (alumnos.aig.uc3m.es [163.117.128.148]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA90553 for ; Tue, 18 Jan 2000 11:36:18 -0500 (EST) (envelope-from 100000450@alumnos.uc3m.es) Received: from l031ps20 (l031ps20.aib.uc3m.es [163.117.12.80]) by alumnos.uc3m.es (8.8.7/8.8.7) with ESMTP id RAA10000 for ; Tue, 18 Jan 2000 17:34:52 +0100 Message-Id: <200001181634.RAA10000@alumnos.uc3m.es> Date: Tue, 18 Jan 2000 17:35:37 -0500 From: Nombre y Apellidos <100000450@alumnos.uc3m.es> Sender: 100000450@alumnos.uc3m.es Reply-To: Nombre y Apellidos <100000450@alumnos.uc3m.es> Subject: Internet To: pgsql-interfaces@postgresql.org X-Mailer: EMBLA 1.1 MIME-Version: 1.0 Content-Type: MESSAGE/RFC822 Date: Tue, 18 Jan 2000 17:33:25 -0500 From: Nombre y Apellidos <100000450@alumnos.uc3m.es> Sender: 100000450@alumnos.uc3m.es Reply-To: Nombre y Apellidos <100000450@alumnos.uc3m.es> Subject: php postgres To: php-pgsql@linuxports.com X-Mailer: EMBLA 1.1 MIME-Version: 1.0 Content-Type: MESSAGE/RFC822 Date: Mon, 17 Jan 2000 15:58:45 -0500 From: Nombre y Apellidos <100000450@alumnos.uc3m.es> Sender: 100000450@alumnos.uc3m.es Reply-To: Nombre y Apellidos <100000450@alumnos.uc3m.es> Subject: Connect to the www To: pgsql-users@postgresql.org X-Mailer: EMBLA 1.1 MIME-Version: 1.0 Content-Type: MESSAGE/RFC822 Date: Fri, 14 Jan 2000 19:56:43 -0500 From: Nombre y Apellidos <100000450@alumnos.uc3m.es> Sender: 100000450@alumnos.uc3m.es Reply-To: Nombre y Apellidos <100000450@alumnos.uc3m.es> Subject: Re: embedded sql,ecpg To: Michael Meskes In-Reply-To: <20000113090603.A7463@fam-meskes.de> X-Mailer: EMBLA 1.1 MIME-Version: 1.0 Content-Type: MULTIPART/MIXED; BOUNDARY="1043395584--638262944-947897803:#1" --1043395584--638262944-947897803:#1 Content-Type: TEXT/PLAIN; CHARSET=US-ASCII Michael Meskes: > On Wed, Jan 12, 2000 at 07:10:57PM -0500, Nombre y Apellidos wrote: > > In my program in C with embedded SQL, I am trying to use a cursor for > > a query. > > The new syntax of FETCH is : > > EXEC SQL FETCH FROM cursor_name INTO :variable_name > > > > But I receive the following message of error when I execute my program: > > Segmentation default > > Ouch. Segmentation fault means the program tries to access invalid memory. > You can get it for instance if the variable is not correctly defined. > > > When I worked with a previous version I wrote: > > EXEC SQL FETCH cursor_name INTO :variable_name > > Yes, this syntax was supported and may be supported again in the future. > Right now our parser does not like it due to shift/reduce conflicts. But I'm > working on it. > > > What is the correct syntax? > > Using FROM is and will be correct. > > > How can I use the command FETCH? > > The above mentioned statement ie correct given that you did declare the > cursor in advance. Please check the test file in the source tree for some > examples. > > > Is always neccessary to include the embedded SQL commands in > > transaction blocks? > > Yes and No. It depends on what you mean exactly. ECPG by default starts a > transaction every time the connection starts resp. the open transcation is > committed or rolled back. > > What you can do is start ecpg with option '-t' or issue an exec sql set > autocommit=on to disable that feature. Then you have to manually start a > transaction if you need one. However, you cannot work without a transaction > since the backend executes statements only if they are embedded in a > transaction. If you do not have an open transaction the backend will start > one prior to executing your command and immediately after finishing this > transaction will be committed. > > Hope this helps. > > Michael > -- > Michael Meskes | Go SF 49ers! > Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! > Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! > Email: Michael@Fam-Meskes.De | Use PostgreSQL! > --1043395584--638262944-947897803:#1 Content-Type: TEXT/PLAIN; CHARSET=ISO-8859-1 Content-Transfer-Encoding: 8BIT I am Ana Isabel Canales from Spain, Universidad Carlos III of Madrid. I received your email answering my problems with ecpg. Thanks for your answer because it was very useful for me. I am working in my end of studies project of Industrial Engineering. My project is about a database applied to a flexible manufacturing cell, and I am working with PostgreSQL. It would be very useful for me to have communication with the PostgreSQL Team because I am having some difficulties. Perhaps, you canīt help me, but I would like to know how I can connect and access my database from the Internet. I want to connect my database with a HTML page. What is the easier form to connect my database from Netscape for example? Iīve heard something about apache and php, but I am trying it and it doesnīt work. Can you help me? Thanks for all. --1043395584--638262944-947897803:#1--