Elke,
>As mailed several times: we agree that this is a missing feature.
>It is on our to-do-list. There is no time-schedule available so far.
It is a general problem in application servers and object-relatinal mapping
tools that they don't know the values of fields coming from defaults after
inserting the rows into database. Let me propose a simple and general
solution:
-- Probably won't work but just to illustrate the idea
CREATE TABLE foo (
id SERIAL,
bar1 INTEGER DEFAULT 5,
bar2 CHAR(5)
)
-- Now the modified insert clause
INSERT INTO foo ( bar2 ) VALUES ( "good" ) RETURNING ( id, bar1, bar2);
This approach would also improve performance, because it saves a roundtrip
to get current sequence.
Just an idea... :-)
Cheers,
Wojtek
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
