[Gnumed-devel] re: clin_medication constraint

[scaredycat]

There was an application error where I was using setDate instead of 
setTimestamp
which truncated the timestamp for clin_when and last_prescribed,
but below is a packet capture on ethereal showing
the data passed  when I tried fixing it by rolling last_prescribed
one hour ahead , and last_prescribed is 22:11 and clin_when is 21:11
and the constraint was violated.
However, I tried it another way when last_prescribed was set 24 hours ahead,
and it then worked, so I'm guessing it something to do with casting
to timestamp with timezone on one side of the constraint , but not the 
other,
even though the other is a field of timestamp with timezone.
Or I'm trying to find the needle in a haystack, and there's a beam in my 
eye, brother.


> 0000  00 09 f3 07 bf 62 00 00  39 42 68 f6 08 00 45 00   ..ó.¿b.. 9Bhö..E.
> 0010  02 6d 39 80 40 00 40 06  a5 cf c0 a8 00 17 d5 ef   address@hidden@. 
> ¥ÏÀ¨..Õï
> 0020  c2 8c 81 2b 15 38 b7 b7  68 ac 4f d3 9d 91 80 18   Â..+.8·· h¬OÓ....
> 0030  8a ac 40 c1 00 00 01 01  08 0a 00 21 7b 08 50 f3   address@hidden ...!{.Pó
> 0040  5f 84 51 69 6e 73 65 72  74 20 69 6e 74 6f 20 63   _.Qinser t into c
> 0050  6c 69 6e 5f 6d 65 64 69  63 61 74 69 6f 6e 28 70   lin_medi cation(p
> 0060  6b 5f 69 74 65 6d 2c 20  62 72 61 6e 64 6e 61 6d   k_item,  brandnam
> 0070  65 2c 20 61 74 63 5f 63  6f 64 65 2c 20 64 72 75   e, atc_c ode, dru
> 0080  67 5f 64 62 2c 20 75 66  6b 5f 64 72 75 67 2c 20   g_db, uf k_drug,
> 0090  64 6f 73 61 67 65 5f 75  6e 69 74 2c 20 64 6f 73   dosage_u nit, dos
> 00a0  61 67 65 2c 20 70 65 72  69 6f 64 2c 20 64 6f 73   age, per iod, dos
> 00b0  61 67 65 5f 66 6f 72 6d  2c 20 64 69 72 65 63 74   age_form , direct
> 00c0  69 6f 6e 73 2c 20 69 73  5f 70 72 6e 2c 20 6c 61   ions, is _prn, la
> 00d0  73 74 5f 70 72 65 73 63  72 69 62 65 64 2c 20 64   st_presc ribed, d
> 00e0  69 73 63 6f 6e 74 69 6e  75 65 64 2c 20 20 63 6c   iscontin ued,  cl
> 00f0  69 6e 5f 77 68 65 6e 2c  20 6e 61 72 72 61 74 69   in_when,  narrati
> 0100  76 65 2c 20 73 6f 61 70  5f 63 61 74 2c 20 20 66   ve, soap _cat,  f
> 0110  6b 5f 65 6e 63 6f 75 6e  74 65 72 2c 20 66 6b 5f   k_encoun ter, fk_
> 0120  65 70 69 73 6f 64 65 2c  20 67 65 6e 65 72 69 63   episode,  generic
> 0130  20 20 29 20 76 61 6c 75  65 73 20 28 31 33 32 2c     ) valu es (132,
> 0140  20 20 27 41 6d 70 72 61  63 65 20 31 30 27 20 2c     'Ampra ce 10' ,
> 0150  20 27 43 30 39 41 41 30  32 27 20 2c 20 27 64 72    'C09AA0 2' , 'dr
> 0160  75 67 72 65 66 27 2c 20  27 37 38 36 33 27 2c 20   ugref',  '7863',
> 0170  20 27 65 61 63 68 27 2c  20 27 7b 31 2e 30 20 7d    'each',  '{1.0 }
> 0180  27 20 2c 20 27 32 34 68  27 20 2c 20 27 74 61 62   ' , '24h ' , 'tab
> 0190  27 20 2c 20 27 31 2e 30  20 54 61 62 6c 65 74 20   ' , '1.0  Tablet
> 01a0  31 30 20 6d 67 20 64 61  69 6c 79 3b 20 33 30 20   10 mg da ily; 30
> 01b0  78 20 35 72 70 74 27 20  2c 20 27 66 27 2c 20 27   x 5rpt'  , 'f', '
> 01c0  32 30 30 34 2d 31 30 2d  31 36 20 32 32 3a 31 31   2004-10- 16 22:11
> 01d0  3a 35 34 2e 35 39 36 30  30 30 2b 31 30 27 20 2c   :54.5960 00+10' ,
> 01e0  20 6e 75 6c 6c 20 2c 20  27 32 30 30 34 2d 31 30    null ,  '2004-10
> 01f0  2d 31 36 20 32 31 3a 31  31 3a 35 34 2e 35 39 36   -16 21:1 1:54.596
> 0200  30 30 30 2b 31 30 27 20  2c 20 27 6d 65 64 69 63   000+10'  , 'medic
> 0210  61 74 69 6f 6e 20 64 6f  6e 65 0a 0a 73 63 72 69   ation do ne..scri
> 0220  70 74 3a 45 6e 61 6c 61  70 72 69 6c 28 41 6d 70   pt:Enala pril(Amp
> 0230  72 61 63 65 20 31 30 29  20 31 2e 30 20 54 61 62   race 10)  1.0 Tab
> 0240  6c 65 74 20 31 30 20 6d  67 20 64 61 69 6c 79 3b   let 10 m g daily;
> 0250  20 33 30 20 78 20 35 72  70 74 27 20 2c 20 27 70    30 x 5r pt' , 'p
> 0260  27 2c 20 36 31 20 2c 20  37 34 20 2c 20 27 45 6e   ', 61 ,  74 , 'En
> 0270  61 6c 61 70 72 69 6c 27  20 29 00                  alapril'  ).