Hi
We get the fowling exception when we move our Database from a Windows2003 (PostgreSQL 8.1beta4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)) server to a Ubuntu server 5.10 .
(PostgreSQL 8.1.0 on i386-pc-linux-gnu, compiled by GCC cc (GCC) 3.3.5 (Debian 1:3.3.5-13))
We use pg_dump and pg_restore to do it.
This also happen on PostgreSQL version 8.0.4.
Any ideal what the problem may be?
Message...
timestamp out of range
Detail Message...
Hint...
Error Code...
22008
Procedure Name...
timestamp_recv
Position...
0
Line Number...
194
File Name...
timestamp.c
Target Site...
Int32 Update(System.Data.DataRow[], System.Data.Common.DataTableMapping)
Call Stack...
Stack Trace...
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
at HS.Definitive.BT.DAL.DataAdapterUpdate(IDbConnection ICon, IDbTransaction ITrx, IDbCommand ICmdInsert, IDbCommand ICmdUpdate, IDbCommand ICmdDelete, DataTable Table, DatabaseType DB)
at HS.Definitive.BT.DAL.DataAdapterUpdate(IDbConnection ICon, IDbTransaction ITrx, IDbCommand ICmdInsert, IDbCommand ICmdUpdate, IDbCommand ICmdDelete, DataTable Table)
at HS.Definitive.BT.Dev.TrackerDD.UpdateIssue()
at HS.Definitive.PT.Dev.Tracker.IssueDlg.SaveRecord(Boolean Close)
at HS.Definitive.PT.Dev.Tracker.IssueDlg.Toolbars_ToolClick(Object sender, ToolClickEventArgs e)
at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.OnToolClick(ToolClickEventArgs e)
at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.FireEvent(ToolbarEventIds id, EventArgs e)
at Infragistics.Win.UltraWinToolbars.ToolBase.OnToolClick()
at Infragistics.Win.UltraWinToolbars.ButtonToolUIElement.DoClickProcessing(MouseEventArgs e)
at Infragistics.Win.UltraWinToolbars.ButtonToolUIElement.OnMouseUp(MouseEventArgs e)
at Infragistics.Win.ControlUIElementBase.ProcessMouseUp(Object sender, MouseEventArgs e)
at System.Windows.Forms.Control.OnMouseUp(MouseEventArgs e)
at Infragistics.Win.UltraWinToolbars.UltraToolbarsDockArea.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)Message...
timestamp out of range
Source...
System.Data
Target Site...
Int32 Update(System.Data.DataRow[], System.Data.Common.DataTableMapping)
Stack Trace...
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
at HS.Definitive.BT.DAL.DataAdapterUpdate(IDbConnection ICon, IDbTransaction ITrx, IDbCommand ICmdInsert, IDbCommand ICmdUpdate, IDbCommand ICmdDelete, DataTable Table, DatabaseType DB)
at HS.Definitive.BT.DAL.DataAdapterUpdate(IDbConnection ICon, IDbTransaction ITrx, IDbCommand ICmdInsert, IDbCommand ICmdUpdate, IDbCommand ICmdDelete, DataTable Table)
at HS.Definitive.BT.Dev.TrackerDD.UpdateIssue()
at HS.Definitive.PT.Dev.Tracker.IssueDlg.SaveRecord(Boolean Close)
at HS.Definitive.PT.Dev.Tracker.IssueDlg.Toolbars_ToolClick(Object sender, ToolClickEventArgs e)
at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.OnToolClick(ToolClickEventArgs e)
at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.FireEvent(ToolbarEventIds id, EventArgs e)
at Infragistics.Win.UltraWinToolbars.ToolBase.OnToolClick()
at Infragistics.Win.UltraWinToolbars.ButtonToolUIElement.DoClickProcessing(MouseEventArgs e)
at Infragistics.Win.UltraWinToolbars.ButtonToolUIElement.OnMouseUp(MouseEventArgs e)
at Infragistics.Win.ControlUIElementBase.ProcessMouseUp(Object sender, MouseEventArgs e)
at System.Windows.Forms.Control.OnMouseUp(MouseEventArgs e)
at Infragistics.Win.UltraWinToolbars.UltraToolbarsDockArea.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
errors when moving from Win2003 to Linux
Since PostgreSQL 8.1beta4 is not a release version we only work on adding support for PostgreSQL 8.1 server into PostgreSQLDirect .NET. We plan to release version of our provider that supports PostgreSQL 8.1 server after it will be available. So it is the possible problem with the last version of provider since in the new version of PostgreSQL the format of few datetime types was changed.
For now you can use the standard backup/restore procedures available in pgAdmin.
For now you can use the standard backup/restore procedures available in pgAdmin.