[GENERAL] Timestamp shift when importing data

2009-01-03 Thread Jolles, Peter M (GE Infra, Energy)
I am trying to migrate several years of historical data with timestamps from an MS Access database to Postgres. I am running into an issue where specific dates/times get pushed one hour ahead, which creates duplicate date/time stamps or failes the import if I have that defined as my primary key. Th

[GENERAL] Insert into partion table without logic statement

2009-01-05 Thread Jolles, Peter M (GE Infra, Energy)
I have a table that has multiple partitions (1000+) and I want a trigger or rule to be able to write data automatically to each partition. One of the values I am inserting is the table partition name, but I'm not sure how to use it as a variable in a trigger. All trigger examples have a series of I

Re: [GENERAL] Timestamp shift when importing data

2009-01-05 Thread Jolles, Peter M (GE Infra, Energy)
On Saturday, January 03, 2009 6:27 PM, David T Wilson wrote: > Those are the dates of daylight savings time kicking in- > which happens, not coincidentally, at 2am. > > What's the type of the field you're trying to import into, > and how are you doing the import? That makes a lot more sense n