Gerhard Gonter wrote: > When I try to add a row via a list form to a postgresql database, the > following error occurs: > > Error code: 1 > pq_baseresultset: row index out of range, allowed is 0 to -1, got 0
After playing around with a few more forms and tables, I fixed the problem above and came to these two conclusions: 1. a table needs to have a primary key, otherwise the table can't be edited. The existence of the oid column is not sufficient (pgAdmin is happy when there is an oid). 2. the primary key must be the first column of the table. If a primary key is added to the table later on, the error mentioned above occurs. So, all I had to do was to recreate the tables with a primary key column as the first column in the table. Cheers! GG --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
