Thread: RE: Problem migrating MSAccess97 table

RE: Problem migrating MSAccess97 table

From
Dave Page
Date:
Hi Glenn,

I must say I a bit stumped by this so I've CC'd it to the PostgreSQL
Interfaces mailing list in the hopes that someone there may have an idea
whats happening.

The obvious (and perhaps condescending!) question has to be: are you sure
you are trying to access the same database you migrated to?

I'm assuming that is the case, so could you re-run the migration with the
ODBC drivers commlog option switched on and send me the logfile created so I
can see if there is anything odd happening.

Regards,

Dave.

--
Dave Page, Network & Systems Manager, The Vale Housing Association Ltd.
dpage@vale-housing.co.uk
http://www.vale-housing.co.uk (Work)
http://www.vale-it.demon.co.uk/ (Home of pgAdmin)
Beer can be a permanent solution - but only if you have enough of it!

> -----Original Message-----
> From: Glenn Howe [mailto:ghowe1@tampabay.rr.com]
> Sent: 11 April 1999 19:35
> To: Dave Page
> Subject: Problem migrating MSAccess97 table
>
>
> Hello,
>
> I am able to add tables and modify etc, using pgadmin on a
> database that
> resides on a linux box. That works great. I can then access
> those tables via
> psql or perl DBI.
>
>
> the problem is when I migrate an access .mdb file. It does
> the migration
> just fine and using pgadmin I can access the newly created
> postgres tables
> just fine, I can see the data etc.  But, if I use psql or
> perl dbi, it tells
> me the table does not exist.
>
> What am I doing wrong. I have tried checking and unchecking
> all the odbc
> driver boxes and trying it again. is there a procedure to
> read regardind
> migrating access 97 tables.
>
>
> <>< ==================
> Glenn Howe
> Network Engineer, MCSE
> 813.651.2700
> MAILTO:ghowe1@tampabay.rr.com
> HomePage: http://home.tampabay.rr.com/tgh
>


RE: Problem migrating MSAccess97 table

From
"Glenn Howe"
Date:
Hi Dave,

First of all, thanks for the reply.


Second, I'm quite sure I am accessing the same database. Infact, from psql I
can list the table, just cannot access it.
---------------------------------------------

contacts=> \dt

Database    = contacts
 +------------------+----------------------------------+----------+
 |  Owner           |             Relation             |   Type   |
 +------------------+----------------------------------+----------+
 | postgres         | Addresses                        | table    |
 | postgres         | msysconf                         | table    |
 | postgres         | pga_forms                        | table    |
 | postgres         | pga_queries                      | table    |
 | postgres         | pga_reports                      | table    |
 | postgres         | pga_scripts                      | table    |
 +------------------+----------------------------------+----------+
contacts=> select * from addresses;
ERROR:  addresses: Table does not exist.
contacts=>
------------------------------------------------------------
Furthermore, I can access the table from within pgadmin using the data
button. I cannot access the table from any other ODBC application
though(even though I am using the same odbc system dsn).

Attached is the database migration events.


-----Original Message-----
From: Dave Page [mailto:dpage@vale-housing.co.uk]
Sent: Monday, April 12, 1999 4:27 AM
To: ghowe1@tampabay.rr.com
Cc: pgsql-interfaces@postgresql.org
Subject: RE: Problem migrating MSAccess97 table


Hi Glenn,

I must say I a bit stumped by this so I've CC'd it to the PostgreSQL
Interfaces mailing list in the hopes that someone there may have an idea
whats happening.

The obvious (and perhaps condescending!) question has to be: are you sure
you are trying to access the same database you migrated to?

I'm assuming that is the case, so could you re-run the migration with the
ODBC drivers commlog option switched on and send me the logfile created so I
can see if there is anything odd happening.

Regards,

Dave.

--
Dave Page, Network & Systems Manager, The Vale Housing Association Ltd.
dpage@vale-housing.co.uk
http://www.vale-housing.co.uk (Work)
http://www.vale-it.demon.co.uk/ (Home of pgAdmin)
Beer can be a permanent solution - but only if you have enough of it!

> -----Original Message-----
> From: Glenn Howe [mailto:ghowe1@tampabay.rr.com]
> Sent: 11 April 1999 19:35
> To: Dave Page
> Subject: Problem migrating MSAccess97 table
>
>
> Hello,
>
> I am able to add tables and modify etc, using pgadmin on a
> database that
> resides on a linux box. That works great. I can then access
> those tables via
> psql or perl DBI.
>
>
> the problem is when I migrate an access .mdb file. It does
> the migration
> just fine and using pgadmin I can access the newly created
> postgres tables
> just fine, I can see the data etc.  But, if I use psql or
> perl dbi, it tells
> me the table does not exist.
>
> What am I doing wrong. I have tried checking and unchecking
> all the odbc
> driver boxes and trying it again. is there a procedure to
> read regardind
> migrating access 97 tables.
>
>
> <>< ==================
> Glenn Howe
> Network Engineer, MCSE
> 813.651.2700
> MAILTO:ghowe1@tampabay.rr.com
> HomePage: http://home.tampabay.rr.com/tgh
>


Attachment

Re: [INTERFACES] RE: Problem migrating MSAccess97 table

From
Tom Lane
Date:
Dave Page <dpage@vale-housing.co.uk> writes:
> The obvious (and perhaps condescending!) question has to be: are you sure
> you are trying to access the same database you migrated to?

Next question after that would be whether the table names are lower case
or not.  Via psql (and anything else that lets you enter raw SQL), table
and field names will be folded to lower case unless you put quotes
around them.  In other words
    SELECT ... FROM MyTable;    --> mytable
    SELECT ... FROM "MyTable";    --> MyTable
But I think pgadmin may supply quotes for you, and if the import process
quoted the names too, then you'd have mixed-case or upper-case table
names inside Postgres.

Try psql's \d command to see what table names the server thinks it has.

            regards, tom lane