[ADMIN] Postquel?

2000-04-19 Thread Loïc TREGOUËT
Hie Postquel ? Is it an extended request language ? Is it use by PostgreSQL ? Thanks ...

[ADMIN]

2000-04-19 Thread Vladimir V. Zolotych
> . In my case, I used currval(). Basically: > > SELECT currval('table_field_seq'); > > will return the most recently assigned value to the field *by the > current > backend* which means: > > - There's no danger of a race condition (another user creating a > record in > the time between

RE: [ADMIN]

2000-04-19 Thread Rainer Mager
Does anyone know of a good way to do something similar in Java (JDBC) connected to Postgres? Thanks, --Rainer > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Vladimir V. Zolotych > Sent: Wednesday, April 19, 2000 6:34 PM > To: Andrew Perrin - De

[ADMIN] array ...

2000-04-19 Thread Loïc TREGOUËT
Hie, Is there any possibility to know the number of record in an array into a table . Example : create table test ( id int4, array int4[] ); How can i know , how many record i have in array ? (PHP , SQL ) Thanks

Re: [ADMIN] array ...

2000-04-19 Thread Vladimir V. Zolotych
Try to see contrib/array in the distribution. LoÐc TREGOUìT wrote: > Hie, > > Is there any possibility to know the number of record in an array > into a table . > > Example : > > create table test ( > id int4, > array int4[] > ); > >

[ADMIN] ERROR: cannot write block

2000-04-19 Thread Laqtib Slam
Hi, We have renamed a table called "oldTA" to new name  "TA" using pgaccess. Now, the database seems to be corrupted, and here is the error we are getting: ERROR: cannot write block 33 of "oldTA" [my_db] blind. oldTA doesn't exists any more! Any help ! thanks -Slam