Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Conversion problem between physical datatypes MCD --> MPD PostgreSQL

2 posts in General Discussion Last posting was on 2012-10-25 15:46:37.0Z
Alexandra Champavert Posted on 2012-10-11 12:10:41.0Z
Sender: 360c.5076b587.1804289383@sybase.com
From: Alexandra Champavert
Newsgroups: sybase.public.powerdesigner.general
Subject: Conversion problem between physical datatypes MCD --> MPD PostgreSQL
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5076b741.363f.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 11 Oct 2012 05:10:41 -0700
X-Trace: forums-1-dub 1349957441 172.20.134.41 (11 Oct 2012 05:10:41 -0700)
X-Original-Trace: 11 Oct 2012 05:10:41 -0700, 172.20.134.41
Lines: 23
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerdesigner.general:30925
Article PK: 834300

Hello.

I'm creating a MCD to be deployed as a MPD for PostgreSQL.
My version for PowerAMC is 12.5.
When I'm creating a entity containing a "Sequence" with à
relationship with another entity or a association, I
encounter the following problem :
The sequence is converted in BIGSERIAL
The foreign key corresponding column is created with INT4
instead of INT8. This is finally a problem because my two
types don't correspond themselves.
I looked inside the DBMS properties looking into the
"Datatype", saw that Sequence is of internal type NO, and
that SERIAL and BIGSERIAL have the same NO. For SERIAL it
works because SERIAL is INT4, but it doesn't work for the
BIGSERIAL. I'm sure that there is another internal type who
is doing the good thing but I don't know the value to put in
place to ensure that my BIGSERIAL will be with a INT8
foreign key.

Can you please help me ?

Thanks and regards.


wilko Helms Posted on 2012-10-25 15:46:37.0Z
Sender: 7516.50895d0e.1804289383@sybase.com
From: Wilko Helms
Newsgroups: sybase.public.powerdesigner.general
Subject: Re: Conversion problem between physical datatypes MCD --> MPD PostgreSQL
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50895edd.75e3.1681692777@sybase.com>
References: <5076b741.363f.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 25 Oct 2012 08:46:37 -0700
X-Trace: forums-1-dub 1351179997 172.20.134.41 (25 Oct 2012 08:46:37 -0700)
X-Original-Trace: 25 Oct 2012 08:46:37 -0700, 172.20.134.41
Lines: 34
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerdesigner.general:30942
Article PK: 834314

Hi,
I'm facing the same problem since many years. I opened a
case but PD-staff was not able to reproduce the error. the
bug seems to be an internally hardcoded function that
resolves each serial to integer - not careing if serial has
another length than integer. In my case when creating the
final pdm with physical database coming from Ansi 2 model. I
always do a handjob.
regards
Wilko

> Hello.
>
> I'm creating a MCD to be deployed as a MPD for PostgreSQL.
> My version for PowerAMC is 12.5.
> When I'm creating a entity containing a "Sequence" with
à
> relationship with another entity or a association, I
> encounter the following problem :
> The sequence is converted in BIGSERIAL
> The foreign key corresponding column is created with INT4
> instead of INT8. This is finally a problem because my two
> types don't correspond themselves.
> I looked inside the DBMS properties looking into the
> "Datatype", saw that Sequence is of internal type NO, and
> that SERIAL and BIGSERIAL have the same NO. For SERIAL it
> works because SERIAL is INT4, but it doesn't work for the
> BIGSERIAL. I'm sure that there is another internal type
> who is doing the good thing but I don't know the value to
> put in place to ensure that my BIGSERIAL will be with a
> INT8 foreign key.
>
> Can you please help me ?
>
> Thanks and regards.