Re: Sybase PowerDesigner Data Architect

From: "Dan Langille" <dan(at)langille(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Sybase PowerDesigner Data Architect
Date: 2002-12-19 15:19:53
Message-ID: 3E019D49.15900.4E4F3FB2@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 19 Dec 2002 at 8:57, Dan Langille wrote:

> The two remaining problems are:
>
> - default values are always enclosed in single quotes (') which is
> fine for character fields but not for anything else.
>
> e.g
>
> create table security_notice
> (
> id T_ID not null,
> date_added timestamp not null
> default 'current_timestamp',
>
> - remove key name from foreign keys
>
> alter table element_pathnames
> add foreign key FK_ELEMENT__REF_11730_ELEMENT (element_id)
> references element (id) on update cascade on delete cascade;
>
> Has anyone already done this?

Here's the diff which solves the above problems.

$ diff sqlany55.def sqlany55.def-original
56c56
< Quote =
---
> Quote = '
122c122
< EnableFkeyName = NO
---
> EnableFkeyName = YES
227c227
< EnableAscDesc = NO
---
> EnableAscDesc = YES
--
Dan Langille : http://www.langille.org/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message HT 2002-12-19 18:13:45 Re: HELP? Postgres filling up disk
Previous Message Dan Langille 2002-12-19 13:57:29 Sybase PowerDesigner Data Architect