[SQL] Insert Data and autonumeric field

2007-02-01 Thread André José Guergolet
Hi everybody, I need to insert a row in a table and get the Id of this row ( My primary key ). Example: INSERT INTO table1 (date, field2, field3) VALUES (now,'value2','value3'); SELECT last_value FROM seq_table1; I'm running each command

[SQL] Lock Problem

2006-08-24 Thread André José Guergolet
Hello all, I'm using the Postgres 8.0 and my product creates 7 connections at the server. One of my connections do an update at a simple table with 360 rows and I've got many table locks. How I can take more scability? Thanks, and sorry about my english.

RES: [SQL] Lock Problem

2006-08-24 Thread André José Guergolet
Guergolet -Mensagem original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nome de Andrew Sullivan Enviada em: quinta-feira, 24 de agosto de 2006 17:53 Para: pgsql-sql@postgresql.org Assunto: Re: [SQL] Lock Problem On Thu, Aug 24, 2006 at 05:27:58PM -0300, André José Guergolet wrote: Hello

[SQL] Loading JDBC Driver

2000-10-05 Thread José
Hello. I am trying to load a jdbc driver for postgres, only I want to make it from an Applet. For an application I used the form: Class.forName ("postgresql.Driver"); Which the correct form would be to be able to make it? __ Do You