Re: I have problem with Postgres.

On Thu, 2002-11-14 at 03:40, =F0=CF=D0=CF=D7 =E1=CE=C4=D2=C5=CA wrote:
> Hi.
> I have problem with Postgres.
> I have perl script, that add 2 records in 2 tables. This script I run
> from web throught web server Apache (on FreeBSD).
> (perl version 5.005)

You would be better off using the sequence rather than trying to fetch
out max(obj_id).


select currval('object_list_obj_id_seq') AS nextvalue;

after the insert into object_list.

>=20
>     $sth =3D $dbh->prepare("select max(obj_id) from object_list");
>     $sth->execute();
>     $max =3D $sth->fetchrow;

--=20
Rod Taylor <rbt@rbt.ca>