| From: | el dorado <do_ra_do(at)mail(dot)ru> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | PowerDesigner 15 |
| Date: | 2010-12-28 10:02:20 |
| Message-ID: | E1PXWNo-0005fX-00.do_ra_do-mail-ru@f109.mail.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello!
I would like to get more flexible tool for database management that EMS of pgadmin. So now I'm trying to use PD 15 with Postgres 8.4.1. It's very exciting :)
So what can I say?
It seems to be there are no problems with tables, sequences, FK... But there are some difficulties with:
1. Stored porcedures
At this branch of DBMS definition file - PostgreSQL 8::Script\Objects\Procedure\Create - I write the following:
CREATE FUNCTION %PROC%(%PROCPRMS%)
as $body$
%TRGDEFN%
$body$
LANGUAGE '%ProcLanguage%' VOLATILE CALLED ON NULL INPUT SECURITY DEFINER;
When I do reverse engineering I get the script of procedure, f.e.:
CREATE FUNCTION %PROC%()
as $body$
BEGIN
RETURN i+1;
END
$body$
LANGUAGE '%ProcLanguage%' VOLATILE CALLED ON NULL INPUT SECURITY DEFINER;
The problem is that there is that there should be some params - but here the list of params is empty.
2. Schemas
PD interprets schemas as users - for some reason. I have no definite idea - is there any opportunity to teach PD to work with schemas correctly? Maybe it's necessary to add some structure to 'Object' section or 'Profile' section of DBMS definition file ?
It's interesting at all - does anybody successfully use PD with Postgres? I'll appreciate any notices. There is no much information about it.
Regards, Marina.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | InterRob | 2010-12-28 10:05:27 | Re: CONSTRAINT does not show when applying a EXCLUDE constraint |
| Previous Message | aaliya zarrin | 2010-12-28 08:55:32 | Re: Startup Process Initiated by init proc (Unix) |