Adrian Crum wrote: > On 6/17/2010 10:10 AM, Ean Schuessler wrote: >> Adrian Crum wrote: >>> The seed data works fine. It has been working fine for years. It's the >>> process you're using that is the problem. >> Just because something has been broken for a long time does not mean it >> is fixed. We have found numerous long-standing problems that simply have >> never been addressed. I'm sure you have found your share as well. > > Someone please prove to me the existing seed data is broken. I can prove > that it isn't. > > Using Adam's example... > > In UserDemoData.xml: > > <UserLoginSecurityGroup groupId="FULLADMIN" userLoginId="admin" > fromDate="2001-01-01 12:00:00.0"/> > > The Postgress dump from Adam's reply: > > user_login_id | group_id | from_date | thru_date | > last_updated_stamp | last_updated_tx_stamp | > created_stamp | created_tx_stamp > ---------------+-----------+------------------------+-----------+----------------------------+----------------------------+----------------------------+---------------------------- > > system | FULLADMIN | 2001-01-01 12:00:00-05 | | > 2010-06-15 20:30:20.83-04 | 2010-06-15 20:30:20.723-04 | 2010-06-15 > 20:30:20.83-04 | 2010-06-15 20:30:20.723-04 > > The fromDate was imported correctly. The seed data is not broken. What > is broken is the process used to transfer that data to a server in > another time zone.
Your copy of my psql dump is incorrect. There were 2 rows returned. One was imported on 06-13(the initial import). Then, on 06-15, the seed xml data was imported a second time, but in a different tz.
