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

2000-10-01 Thread Tom Lane
"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 regression testing's initdb stage fails with a core file

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

2000-10-01 Thread Emils Klotins
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 regression testing's initdb stage fails with a core file and message: FATAL: s_lock (2030d360) at spin.c:116

Re: [SQL] question on diagnostics

2000-10-01 Thread Bruce Momjian
I can confirm that this is now fixed, and will appear in 7.1 when it is released. test=> select * from a natural inner join b natural inner join c; a --- 1 (1 row) > > > oh, btw this select refused to use an SQL natural join among the 3 > > > relations - the server gives up and disconnects w

[SQL] currval

2000-10-01 Thread Craig May
Hi, I'm executing the following statements in series. insert into [tablename] values('a', 'b', 'c'); select currval('serial'); serial being the default index on [tablename] The statement works fine from the command line, however, when executing via jdbc, I'm getting no results back (null po