Just for the record, and put some closure, today I finaly got unstable
packages for postgresql-8.0 (up to yesterday the unstable package was the
same as the testing one on SPARC) and this problem creating views is gone.
>From the changelog it looks like a bus error:
postgresql-8.0 (8.0.3-16) unstable; urgency=medium
* Urgency medium since this fixes two release critical bugs in testing.
* libpq-dev: Add missing dependency libssl-dev. Closes: #327380
* Add debian/patches/07-relax-sslkey-permscheck.patch:
- Relax security check on private SSL key file: The file is also
considered safe if it has owner and/or group "root", and if it is
group-readable (unless the group is something other than root or the
database owner group).
- Closes: #327901
* Build with gcc 3.3 on ia64, hppa, mips, mipsel, and sparc. Building with
gcc 4.0 causes bus errors. See bug #329197.
-- Martin Pitt <mpitt@xxxxxxxxxx> Wed, 21 Sep 2005 23:20:27 +0200
Thanks to all
El Mié 28 Sep 2005 09:16, Martín Marqués escribió:
> El Sáb 24 Sep 2005 13:15, Tom Lane escribió:
> > =?iso-8859-1?q?Mart=EDn_Marqu=E9s?= <martin@xxxxxxxxxxxxxxx> writes:
> > > I can't create any VIEW at all. I'm using the latest debian testing
> > > PostgreSQL (8.0.3):
> >
> > Maybe you got a corrupt download?
>
> How can I seek if it's a corrupt download or something else?
>
> OK, I filed a BUG report at debian.org, even sent mail to Oliver and Martin
> (the 2 persons that appear in de packagers list). I have had absolutly no
> responce on the subject, and I really need to have this solved.
>
> What should I do now?
--
07:33:54 up 12 days, 12:51, 2 users, load average: 1.91, 1.90, 1.75
---------------------------------------------------------
Lic. Martín Marqués | SELECT 'mmarques' ||
Centro de Telemática | '@' || 'unl.edu.ar';
Universidad Nacional | DBA, Programador,
del Litoral | Administrador
---------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
