On 6/17/2010 10:23 AM, Adam Heath wrote:
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.
I can guarantee that is what your CDT server contains.
Anyways, I've done all I can do. I have a job I need to get back to. I
can reply again on Friday.
-Adrian