How can I pass an id parameter?  The id is the whole row!

I sent this earlier, here is the SQL I used to make the table:
This is the table as it stands according to my schema:
create table file_index (
    code varchar REFERENCES metainfo (code),
    file_name varchar REFERENCES files (file_name),
    PRIMARY KEY (code, file_name) );

The primary key is a compound of (code, file_name)


On 4/19/06, Oleg Broytmann <> wrote:
On Wed, Apr 19, 2006 at 01:56:26PM -0400, Mark True wrote:
> ProgrammingError: relation "file_index_id_seq" does not exist

   When you 'id' column is not int yuo must pass explicit id parameter:


   Without this SQLObject tries to get an autoincremented id; from a
sequence in Postgres.

     Oleg Broytmann     
           Programmers don't die, they just GOSUB without RETURN.

Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
sqlobject-discuss mailing list