pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mitch Vincent <mitch@venux.net>
To: pgsql-sql@postgresql.org
Subject: Reasonable
Date: Tue, 5 Oct 1999 11:32:50 -0400
Message-ID: <019801bf0f46$e1f01c00$40ee2fd8@venux.net> (raw)

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"




view thread (4+ messages)  latest in thread

Message-ID: <019801bf0f46$e1f01c00$40ee2fd8@venux.net>
Permalink:  ../019801bf0f46$e1f01c00$40ee2fd8@venux.net/
Also on:    postgresql.org/message-id/019801bf0f46$e1f01c00$40ee2fd8@venux.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: mitch@venux.net
  Subject: Re: Reasonable
  In-Reply-To: <019801bf0f46$e1f01c00$40ee2fd8@venux.net>
  References: <019801bf0f46$e1f01c00$40ee2fd8@venux.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox