Re: [SQL] Q: spinlock on Alpha? (PG7.0.2) - solved

2000-10-10 Thread Ryan Kirkpatrick
On Tue, 3 Oct 2000, Emils Klotins wrote: > From: Fabrice Scemama <[EMAIL PROTECTED]> > > Try this: > > http://www.rkirkpat.net/software/ > > > parallel regression testing's initdb stage fails with a core file and > > > message: > > > > > > FATAL: s_lock (2030d360) at spin.c:116,

Re: [SQL] Q: spinlock on Alpha? (PG7.0.2)

2000-10-10 Thread Ryan Kirkpatrick
On Mon, 2 Oct 2000, Tom Lane wrote: > "Emils Klotins" <[EMAIL PROTECTED]> writes: > > RedHat Linux 6.2 on Alphaserver DS10 (egcs-1.1.2, glibc-2.1.3, > > libstdc++-2.9.0). > > Postgresql-7.0.2 source > > > Compiles and installs just fine. However, both the regular initdb and > > parallel regres

Re: AW: [SQL] Table Attribute Help

2000-10-10 Thread Michael Fork
I have been trying to do exactly that, with this being the closest I can come: football=# SELECT a.attname, t.typname, a.attlen, a.atttypmod FROM pg_class c, pg_attribute a, pg_type t WHERE c.relname = 'tblplayer' AND a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid ORDER BY a.attnum;