From: | Dmitriy Igrishin <dmitigr(at)gmail(dot)com> |
---|---|
To: | el dorado <do_ra_do(at)mail(dot)ru> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PowerDesigner 15 |
Date: | 2010-12-28 10:31:26 |
Message-ID: | AANLkTikqHm4mBpxKB486F344Tbc3j9UviiKQf1c6GL1U@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
28 декабря 2010 г. 13:02 пользователь el dorado <do_ra_do(at)mail(dot)ru> написал:
> 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.
>
Hey Marina,
We considered the possibility of usage PD with Postgres, but find another
tool -
dbWrench which we liked more.
--
// Dmitriy.
From | Date | Subject | |
---|---|---|---|
Next Message | Devart | 2010-12-28 13:45:21 | Devart ADO.NET Data Providers Deliver Advanced Model-First and Database-First Support and Improved ORM Solution! |
Previous Message | aaliya zarrin | 2010-12-28 10:14:50 | Re: Startup Process Initiated by init proc (Unix) |