Re: [Brahms-dev-l] ltr file problem

Hello.  There is no script in DAQ which sets energy, specie and 
RunPeriod.  (Someone can make one :) ).  But, the easiest way is to 
change the default value for those columns to be right one.  (And, just 
make sure to remember to change it when anyone of those parameters are 
changed.)   To change the default value,

alter table table_name alter column_name set default new_default_value;

For example,
alter table Runs alter RunPeriod set default 6 ;
or
alter table Runs alter Energy set default '62';


Hiro

Flemming Videbaek wrote:

> Ramiro alerted me to the fact that recent runs (>16053) have ended up 
> on the pp/200/r.. rather than 62. I spend time earlier to make sure 
> this was done
> correctly going to /run06/pp/62 . I am not sure how this happened. but 
> the run database shows Energy=200 rathere than the 62 set in the script.
> I will change the DB after having deleted all ltr/gtr/..  runs > 16053 
> so the filecatalog and rundb  can be corrected.
>  
> Flemming
>  
>  
> --------------------------------------------
> Flemming Videbaek
> Physics Department
> Bldg 510-D
> Brookhaven National Laboratory
> Upton, NY11973
>  
> phone: 631-344-4106
> cell:       631-681-1596
> fax:        631-344-1334
> e-mail: videbaek @ bnl.gov
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Brahms-dev-l mailing list
>Brahms-dev-l@lists.bnl.gov
>http://lists.bnl.gov/mailman/listinfo/brahms-dev-l
>  
>

_______________________________________________
Brahms-dev-l mailing list
Brahms-dev-l@lists.bnl.gov
http://lists.bnl.gov/mailman/listinfo/brahms-dev-l