> -Original Message-
> From: Reshat Sabiq [mailto:[EMAIL PROTECTED]]
> Sent: 29 December 2002 21:34
> To: Dave Page; [EMAIL PROTECTED]
> Subject: Re: [pgadmin-support] int types migrated one level lower
>
>
> What I meant to say is that there is nothing wrong with
> either ADO's, or p
What I meant to say is that there is nothing wrong with either ADO's, or
pgAdmin's mappings. The problem arises from the fact that MS Access has
a "downward-revised" mapping of integer types:
byte - 8 bits (this one is fine)
integer - 16 bits (i.e., int2, but normally should be int4)
long integer -
> -Original Message-
> From: Peter Depuydt [mailto:[EMAIL PROTECTED]]
> Sent: 29 December 2002 13:38
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] Can only create a database ?
>
>
> Hi,
>
> I can only create a database, no tables nor anything else.
> I connect as a superuser.
>
> -Original Message-
> From: Reshat Sabiq [mailto:[EMAIL PROTECTED]]
> Sent: 29 December 2002 13:54
> To: Dave Page; [EMAIL PROTECTED]
> Subject: RE: [pgadmin-support] int types migrated one level lower
>
>
> I was right in last message: I just checked that in Access
> docs. A little
I was right in last message: I just checked that in Access docs. A
little surprise from MS: 16-bit int, and 32 bit long.
P.S. That means there's nothing wrong with ADO.
Sincerely,
r.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Reshat Sabiq
Sent: Su
Hi,
I can only create a database, no tables nor anything else.
I connect as a superuser.
Some versions :
postgresql : 7.2.2 on Redhat 8.0
psqlODBC : 7.2.5 on Windows 2000 Pro
pgAdmin II : 1.4.12 on Windows 2000 Pro
Has anyone got a clue ?
Kind regards
Peter Depuydt
--
Actually, I though about it a little, and I am now in doubt about how MS
Access stores integer types internally.
Since there is no "short" type, the consecutive values could potentially
go as follows:
byte - 8 bits
integer - 16 bits
long integer - 32 bits
If that is the case, then integer from Acc
