Column Name Length problem? - Mailing list pgsql-odbc

From Corey W. Gibbs
Subject Column Name Length problem?
Date
Msg-id 000a01c1c2dc$28dc3b80$0300a8c0@Domain
Whole thread Raw
List pgsql-odbc
Good Morning Everyone,
I had a perfectly good working application written in VB that tied to a PG database on a Red Hat system with the latest ODBC driver.
After working on the app for awhile, I had to re-write the database layout based on user requests.  I made some field names longer and others shorter, and generally "neatened things up".  Why does "neatening things up" always break it? :). 
Of course, I didn't document the old layout, so I can't compare where things went wrong.  (Mental note, save printouts of the database layout)
On Friday, "select * from schedule" in the recordset.open statement would cause a "division by zero" error.  In debugging it, I got up to "select id,quote_number,price_required,bid_date,bid_time,project_name from schedule" before I had to leave for the day.  On Monday morning I'm going to start debugging the app from that point, but I was wondering if anyone could see anything that I would need to watch out for in the layout below.  Or that would cause select * to bomb out.
thanks in advance
corey
                    Table schedule in database est_track
     _________________________________________________________________
 
   Field name             Type      Array? Allow nulls?
   id - a serial field    int4      No     No
   quote_number           int4      No     Yes
   price_required         timestamp No     Yes
   bid_date               timestamp No     Yes
   bid_time               timestamp No     Yes
   project_name           text      No     Yes
   location               text      No     Yes
   state                  text      No     Yes
   estimator              text      No     Yes
   job_number             int4      No     Yes
   hund_percent_sell      float8    No     Yes
   percent_sell           float8    No     Yes
   bid_amount             float8    No     Yes
   low_bid_amount         float8    No     Yes
   low_bid_percent        float8    No     Yes
   low_bid_bidder         text      No     Yes
   addl_bid               text      No     Yes
   addl_bid_amount        float8    No     Yes
   spread                 float8    No     Yes
   addl_bidder2           text      No     Yes
   addl_bidder2_amount    float8    No     Yes
   addl_bidder3           text      No     Yes
   addl_bidder3_amount    float8    No     Yes
   addl_bidder4           text      No     Yes
   addl_bidder4_amouint   float8    No     Yes
   spread_percent         float8    No     Yes
   low_bid_notes          text      No     Yes
   low_bid_spread         float8    No     Yes
   low_bid_spread_percent float8    No     Yes
   addl_bidder2_notes     text      No     Yes
   addl_bidder3_notes     text      No     Yes
   addl_bid_notes         text      No     Yes
   rebid                  bool      No     Yes
   rebid_info             text      No     Yes
   sales_person           text      No     Yes
   date_complete          timestamp No     Yes
   no_tabs_avail          bool      No     Yes
   only_bidder            bool      No     Yes
   negotiated             bool      No     Yes
   no_tabs                bool      No     Yes
   dealer_bid             bool      No     Yes
   accept_date            timestamp No     Yes
   date_modified          timestamp No     Yes
   plan_deposit           bool      No     Yes
   plan_return_date       timestamp No     Yes
 

pgsql-odbc by date:

Previous
From: Gary Stainburn
Date:
Subject: Re: [ADMIN] PHP ODBC conflict
Next
From: Dave Page
Date:
Subject: Re: [pgadmin-hackers] Multibyte ODBC