Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e6EF9p011530 for ; Fri, 14 Jul 2000 11:09:51 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id LAA10757; Fri, 14 Jul 2000 11:09:43 -0400 (EDT) To: John BEPPU cc: pgsql-sql@postgresql.org Subject: Re: nevermind... In-reply-to: <20000714032839.I1265@yukari.lineo.com> References: <20000714032839.I1265@yukari.lineo.com> Comments: In-reply-to John BEPPU message dated "Fri, 14 Jul 2000 03:28:39 -0600" Date: Fri, 14 Jul 2000 11:09:43 -0400 Message-ID: <10754.963587383@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200007/150 John BEPPU writes: > Nevermind my last post. I'm still confused, but for > different reasons. I'm on my friends box, and I have > screen running. In one tty, creating tables with the > serial type works, but in the other tty, it fails. Same comment as I was about to make for your other message: "it fails" is hardly an adequate description, especially for such a peculiar behavior as this. What error message do you get, *exactly*? If there's a crash, what shows up in the postmaster log, and can you get a backtrace from the core dump? BTW, is it possible that your two windows are talking to two different Postgres installations? A sufficiently old Postgres wouldn't have SERIAL, I think. regards, tom lane