Re: DEFAULT USER

----- Original Message ----- 
From: "Robert Klemme" <[email protected]>
To: "Luca Calderano" <[email protected]>
Cc: <[email protected]>
Sent: Thursday, May 31, 2007 10:10 AM
Subject: Re: DEFAULT USER


> 2007/5/30, Luca Calderano <[email protected]>:
>> Using Maxdb I've found a strange error
>>
>> I've defined a table this way:
>>
>> CREATE TABLE FOO(
>>     ID Fixed (10,0) NOT NULL DEFAULT SERIAL (1),
>>     NOTES Varchar (255) ASCII NOT NULL,
>>     USERID Varchar (32) ASCII NOT NULL DEFAULT USER
>> )
>>
>> I've defined 20 USERS which in order to insert records in the table above
>> defined have to exec the folowing stored procedure:
>>
>> CREATE DBPROC "GestionePratiche"."spFOO_INS" ( IN @P1 Fixed (10,0) ,
>> IN @P2 varchar(32)
>> ) AS
>> INSERT INTO FOO ( ID,
>> NOTES)
>> VALUES ( :@P1, :@P2);
>> //
>>
>> here comes the error:
>> doesn't matter which user executes the stored, but the username recorded 
>> in
>> the table is the one of the first user who has logged in the database
>
> Well, that clearly indicates that USER is evaluated on table creation
> not on record insertion. You probably want to be using a trigger
> instead.
>
> robert
>
sorry, but the user that alwais appears in the field named "USERID" is not 
the user that created the table 

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]