> -----Original Message-----
> From: Simeo Reig [mailto:simreig(at)terra(dot)es]
> Sent: 11 November 2001 22:54
> To: Dave Page
> Subject: Re: [ODBC] Last inserted id
> I had think that the problem was this but I believed that
> was possible to make a mistake because I'm newer with
> ADO. What must I do ? I see two possibilities:
> A) Make a select NEXTVAL from sequence, and
> insert this value in the id
> B) Insert row and after make a CURRVAL
> What option Do you use ?
Use option A), it's multi-user safe whereas the other method isn't.
> Another question please : Are you pleased with Postgres ?
> I have to make a project with almost 50 tables (five with
> arround 100.000 rows), and 20 concurrent users. Can postgres
> make a good job?
I'm project lead for pgAdmin II (pgadmin.postgresql.org) so I'm probably a
bit biased :-) but the main server I run at work hosts about 12 databases
for interactive (VB) applications, PHP apps and also logs data from 3 PBXs.
Most of the databases have at least 10 tables in them (a couple have about
40) and I have some tables over 1.7 million rows. In short, PostgreSQL does
a great job for me and I use it wherever I can (incidently, I also have
Informix, MS-SQL & Unidata servers here which I could have used instead of
> Thanks Dave
> Simeó Reig
> Barcelona (Spain)
> > ADO doesn't re-query the database to get the true
> >representation of
> > the
> > row. The common way around this problem is to manually >get
> the new ID
> > in a seperate query, and then insert that value as well. The >other
> > alternative is to refresh the recordset after the insert, >however
> > this
> > isn't desirable.
> > Regards, Dave.
pgsql-odbc by date
|Next:||From: Geoffrey D. Bennett||Date: 2001-11-12 08:55:04|
|Subject: Re: Last inserted id|
|Previous:||From: Bruce Momjian||Date: 2001-11-12 01:49:57|
|Subject: Re: [ODBC] MD5 support for ODBC|