Received: from redbox.venux.net (redbox.venux.net [216.47.238.10]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA64819 for ; Tue, 5 Oct 1999 11:31:02 -0400 (EDT) (envelope-from mitch@venux.net) Received: from inky (inky.venux.net [216.47.238.64]) by redbox.venux.net (Postfix) with SMTP id DDD022E20B for ; Tue, 5 Oct 1999 11:26:51 -0400 (EDT) Message-ID: <019801bf0f46$e1f01c00$40ee2fd8@venux.net> From: "Mitch Vincent" To: Subject: Reasonable Date: Tue, 5 Oct 1999 11:32:50 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 It seems that this below is causing some strange problems with our PostgreSQL database. We're running it on a FreeBSD 3.2 box, PG version 6.5.1 (with a 6.5.2 upgrade planned really soon) These seems good to me, I can't see any errors yet when I try to enter it into a database, it either locks up psql (the client) or just does nothing at all.. As you can see from the format it is from a pg_dump of another datatable, I just added a few things and was going to turn around and create another table, then the problems started.. If the error is something simple then I do apologize for wasting anyone's time, however I can't seem to see anything wrong.. Thanks!! The query that's giving me fits : CREATE TABLE "user_applicant_search" ( "app_id" int4, "created" datetime, "createdcond" varying(2), "status" character varying(1) default 'Active', "statuscond" character varying(1) default '=', "firstname" character varying(25), "firstnamecond" character varying(2) default '=', "lastname" character varying(25), "lastnamecond" character varying(2) default '=', "address1" character varying(30), "address1cond" character varying(2) default '=', "address2" character varying(30), "city" character varying(20), "citycond" character varying(8) default 'starts', "state" character varying(10), "statecond" character varying(2) default '=', "email" character varying(50), "emailcond character varying(8) default 'starts', "clearance" character varying(20), "clearancecond" character varying(8) default 'starts', "language" character varying(20), "languagecond" character varying(8) default 'starts', "dateavailable" date, "dateavailablecond" varying(2) default '=', "employed" bool, "employedcond" character varying(1) default 'X', "sic1" int4, "sic1cond" character varying(2) default '>=', "skill1" int4, "skill1cond" character varying(2) default '>=', "coregroup" character varying(10), "coregroupcond" character varying(8) default 'starts', "objective" character varying(80), "objectivecond" character varying(8) default 'starts', "degree1" character varying(30), "degree1cond" character varying(8) default 'starts', "d1type" character varying(6), "d1typecond" character varying(2) default '=', "d1discipline" character varying(30), "d1disciplinecond" character varying(3) default '=', "d1date" int4, "d1datecond" character varying(2) default '=', "d1gpa" float, "d1gpacond" character varying(2) default '=', "salary" character varying(40), "salarycond" character varying(8) default 'starts', "salarycurrent" int4, "salarycurrentcond" character varying(2) default '=', "salarydesire" int4, "salarydesirecond" character varying(2) default '=', "salarymin" int4, "salarymincond" character varying(2) default '=', "license" character varying(50), "licensecond" character varying(8) default 'starts', "locstate" character varying(2), "locstatecond" character varying(8) default 'contains'); Again, thanks!! - Mitch "0100110100110000010101000100001101001000"