Re: [Gnumed-devel] re: clin_medication constraint

[Karsten Hilbert]

I have a feeling this got to do with timestamp settings for
your connection somehow.

On Sat, Oct 16, 2004 at 09:24:24PM +1000, scaredycat wrote:
> 
> 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'  ).
> >
> 
> 
> _______________________________________________
> Gnumed-devel mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/gnumed-devel

-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346