|
From: Mark T. <da...@gm...> - 2006-04-19 19:09:41
|
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)
--Mark
On 4/19/06, Oleg Broytmann <ph...@ma...> 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:
>
> MyTable(id=3D"value")
>
> Without this SQLObject tries to get an autoincremented id; from a
> sequence in Postgres.
>
> Oleg.
> --
> Oleg Broytmann http://phd.pp.ru/ ph...@ph...
> 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 Geronim=
o
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> _______________________________________________
> sqlobject-discuss mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>
|
