pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRE: Problem migrating MSAccess97 table
4+ messages / 3 participants
[nested] [flat]
* RE: Problem migrating MSAccess97 table
@ 1999-04-12 08:27 Dave Page <dpage@vale-housing.co.uk>
1999-04-12 12:34 ` RE: Problem migrating MSAccess97 table Glenn Howe <ghowe1@tampabay.rr.com>
1999-04-12 14:54 ` Re: [INTERFACES] RE: Problem migrating MSAccess97 table Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 4+ messages in thread
From: Dave Page @ 1999-04-12 08:27 UTC (permalink / raw)
To: ghowe1@tampabay.rr.com; +Cc: pgsql-interfaces
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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: Problem migrating MSAccess97 table
1999-04-12 08:27 RE: Problem migrating MSAccess97 table Dave Page <dpage@vale-housing.co.uk>
@ 1999-04-12 12:34 ` Glenn Howe <ghowe1@tampabay.rr.com>
1 sibling, 0 replies; 4+ messages in thread
From: Glenn Howe @ 1999-04-12 12:34 UTC (permalink / raw)
To: dpage@vale-housing.co.uk; +Cc: pgsql-interfaces
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
>
Attachments:
psqlodbc_4294789115.log (application/octet-stream, 10.3K) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] RE: Problem migrating MSAccess97 table
1999-04-12 08:27 RE: Problem migrating MSAccess97 table Dave Page <dpage@vale-housing.co.uk>
@ 1999-04-12 14:54 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 4+ messages in thread
From: Tom Lane @ 1999-04-12 14:54 UTC (permalink / raw)
To: ghowe1@tampabay.rr.com; +Cc: pgsql-interfaces; dpage@vale-housing.co.uk
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: Problem migrating MSAccess97 table
@ 1999-04-12 12:58 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 4+ messages in thread
From: Dave Page @ 1999-04-12 12:58 UTC (permalink / raw)
To: ghowe1@tampabay.rr.com; +Cc: pgsql-interfaces
Hi Glenn,
'Addresses' is not the same as 'addresses'. Try:
SELECT * FROM "Addresses";
That should be OK.
Dave.
> -----Original Message-----
> From: ghowe1@tampabay.rr.com [mailto:ghowe1@tampabay.rr.com]
> Sent: 12 April 1999 12:34
> To: Dave Page
> Cc: pgsql-interfaces@postgresql.org
> Subject: RE: Problem migrating MSAccess97 table
>
>
> 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.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-04-12 14:54 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-04-12 08:27 RE: Problem migrating MSAccess97 table Dave Page <dpage@vale-housing.co.uk>
1999-04-12 12:34 ` Glenn Howe <ghowe1@tampabay.rr.com>
1999-04-12 14:54 ` Tom Lane <tgl@sss.pgh.pa.us>
1999-04-12 12:58 RE: Problem migrating MSAccess97 table Dave Page <dpage@vale-housing.co.uk>
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