[SQL] Postgres 7.3 migrate to 8.0 date problems.

2005-03-28 Thread Thomas Seeber
Hi, We were upgrading from postgres 7.3 -> 8.0 and having a little problems importing dates from some of our data sources. Say we have a date like '2004-17-05'. In postgres 7.3, postgres would intrept this as Year Day Month automatically. In the documentation, from postgres 7.4 on this has to b

Re: [SQL] Wierd Error on update

2004-08-13 Thread Thomas Seeber
> Original 7.3 release, or (I hope) 7.3.something? Red Hat 7.3.2.96-113 Linux Version 2.4.20-20.7custom from cat /proc/version > > I am getting two errors which are a bit confounding. > > ERROR: pg_class_aclcheck:relation 474653086 not found > > Are there any views involved? No views. Is the

[SQL] Wierd Error on update

2004-08-11 Thread Thomas Seeber
file it works fine. Now I placed the erroring statements at the end of the large file to make sure it was not a ordering error, but that didnt help. Any ideas? Thank you Thomas Seeber ---(end of broadcast)--- TIP 3: if posting/reading through Usenet