Ok,
I designed a simple DB (5 tables) using psql through cygwin (running ipc, too) on Windows 2000.
My users will be (most likely) using Access as a front end. As I actually know my way around Access, I was using it for data entry.
However,
I discovered some of my fields were not large enough, etc. when entering test data (which is why you use test data to test :D).
I used psql alter commands to drop columns and add new ones (no data to loose), and then went in and deleted all my linked tables in Access and tried to relink.
I'm getting the following:
'..............pg.dropped.8........................' is not a valid name. Make sure that it does not contain invalid characters or punctuation and that it is not too long.
This is the psql \d information for the table in question:
Table "public.event"
Column | Type | Modifiers
--------------+-----------------+-------------------------------------------------------------
aeventid | integer | not null default nextval('public.event_aeventid_seq'::text)
title | character(500) | not null
alocationid | smallint | not null
asponsorid | smallint | not null
notes | character(1000) |
description | character(3000) | not null
contactphone | character(20) |
adateid | smallint | not null
pricehigh | numeric(9,2) |
pricelow | numeric(9,2) | not null
category | character(20) | not null
contactname | character(150) |
contactemail | character(200) |
Indexes: event_pkey primary key btree (aeventid)
Can someone explain what's going on, and more importantly, what I can do about it?
I didn't create this DB through a script.. I would prefer not to have to recreate it again. Ugh.
Thanks,
Cheryl in Irving