Thread: Am I overseen ?

Hi,

Several groups I post most of them does not answer.
Did noone see my postings ?

Please at least give me one answer :-)

Thanks, Lothar

Lothar Behrens wrote:
> Hi,
>
> Several groups I post most of them does not answer.
> Did noone see my postings ?
>
> Please at least give me one answer :-)
>
> Thanks, Lothar
>
>

ping

What was your query?

2007/10/18, Lothar Behrens <lothar.behrens@lollisoft.de>:
> Hi,
>
> Several groups I post most of them does not answer.
> Did noone see my postings ?
>
> Please at least give me one answer :-)
>
> Thanks, Lothar
>

I see your post

Pavel

On 18 Okt., 17:17, br...@zijn-digital.com (brian) wrote:
> Lothar Behrens wrote:
> > Hi,
>
> > Several groups I post most of them does not answer.
> > Did noone see my postings ?
>
> > Please at least give me one answer :-)
>
> > Thanks, Lothar
>
> ping
>
> What was your query?
>

I do convert an UML XMI model to a database script to create the
database schema.
To enable multiple iterations I need conditional alter table add
column like syntax.

For sample:

if not exsist column a in table b then
  alter table b add a char(100);

Is there any way to do this ?

Tanks, Lothar

> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

On 10/18/07, Lothar Behrens <lothar.behrens@lollisoft.de> wrote:
> On 18 Okt., 17:17, br...@zijn-digital.com (brian) wrote:
> > Lothar Behrens wrote:
> > > Hi,
> >
> > > Several groups I post most of them does not answer.
> > > Did noone see my postings ?
> >
> > > Please at least give me one answer :-)
> >
> > > Thanks, Lothar
> >
> > ping
> >
> > What was your query?
> >
>
> I do convert an UML XMI model to a database script to create the
> database schema.
> To enable multiple iterations I need conditional alter table add
> column like syntax.
>
> For sample:
>
> if not exsist column a in table b then
>   alter table b add a char(100);
>
> Is there any way to do this ?

What kind of tools are you familiar with?  I'm guessing you could
write something in perl or php to do it.  Or do you want to do it in
sql?  I'm sure you could do it in plpgsql or some other pl/language,
if you want it all in the db.

But I'm not that familiar with UML as to say what's the best approach.

Normally when you get thundering silence, you've asked a question no
one feels real qualified to answer, and rather than answer it halfway,
they just leave it for the next guy to get.

On 18 Okt., 18:22, scott.marl...@gmail.com ("Scott Marlowe") wrote:
> On 10/18/07, Lothar Behrens <lothar.behr...@lollisoft.de> wrote:
>
>
>
> > On 18 Okt., 17:17, br...@zijn-digital.com (brian) wrote:
> > > Lothar Behrens wrote:
> > > > Hi,
>
> > > > Several groups I post most of them does not answer.
> > > > Did noone see my postings ?
>
> > > > Please at least give me one answer :-)
>
> > > > Thanks, Lothar
>
> > > ping
>
> > > What was your query?
>
> > I do convert an UML XMI model to a database script to create the
> > database schema.
> > To enable multiple iterations I need conditional alter table add
> > column like syntax.
>
> > For sample:
>
> > if not exsist column a in table b then
> >   alter table b add a char(100);
>
> > Is there any way to do this ?
>
> What kind of tools are you familiar with?  I'm guessing you could
> write something in perl or php to do it.  Or do you want to do it in
> sql?  I'm sure you could do it in plpgsql or some other pl/language,
> if you want it all in the db.

Just a copy of my mail.

UML is only a hint, where my source is. I transform it to a big SQL
query
to be executed inside a C/C++ application. So no scripting available
yet.

Also no XML decoding to issue ODBC API commands to determine existing
tables / columns.

> But I'm not that familiar with UML as to say what's the best approach.


Transforming it to SQL queries is best for me, because the application
model
is stored in SQL database. UML is only a possible input to better
model the app.

ER diagramming tools that support XML export would also be an option.

> Normally when you get thundering silence, you've asked a question no
> one feels real qualified to answer, and rather than answer it halfway,
> they just leave it for the next guy to get.


In my opinion the question was clear. How to alter table if the column
not already
inserted of later of given type.

I know about the systables of postgresql as each other database system
has - propably :-)
But I'm not that familar with it.

I need a sample how that is done in plain SQL (i pass the script via
ODBC to the database).

Lothar

Lothar Behrens wrote:
> On 18 Okt., 18:22, scott.marl...@gmail.com ("Scott Marlowe") wrote:
>
>
>>Normally when you get thundering silence, you've asked a question no
>>one feels real qualified to answer, and rather than answer it halfway,
>>they just leave it for the next guy to get.
>
>
>
> In my opinion the question was clear. How to alter table if the column
> not already
> inserted of later of given type.

I think Scott meant that if a question--clear or not--is not something
one feels one is qualified to answer, then one generally does not.

In my opinion, though, the question was not clear.

> I know about the systables of postgresql as each other database system
> has - propably :-)
> But I'm not that familar with it.
>
> I need a sample how that is done in plain SQL (i pass the script via
> ODBC to the database).
>

I don't feel at all qualified to answer this. Sorry.

brian

On 18 Okt., 19:33, br...@zijn-digital.com (brian) wrote:
> Lothar Behrens wrote:
> > On 18 Okt., 18:22, scott.marl...@gmail.com ("Scott Marlowe") wrote:
>
> >>Normally when you get thundering silence, you've asked a question no
> >>one feels real qualified to answer, and rather than answer it halfway,
> >>they just leave it for the next guy to get.
>
> > In my opinion the question was clear. How to alter table if the column
> > not already
> > inserted of later of given type.
>
> I think Scott meant that if a question--clear or not--is not something
> one feels one is qualified to answer, then one generally does not.
>
> In my opinion, though, the question was not clear.
>

Hmm, ok.

> > I know about the systables of postgresql as each other database system
> > has - propably :-)
> > But I'm not that familar with it.
>
> > I need a sample how that is done in plain SQL (i pass the script via
> > ODBC to the database).
>
> I don't feel at all qualified to answer this. Sorry.
>

I will ask differently. Is there a tool that keeps track to syncronize
database models
supporting postgresql (natively) ?

Laurent gave me a hint to http://db.apache.org/ddlutils/ but it is
only
to convert database model to XML representation and vica versa.
What I could read, it does not syncronize. Thus I would propably not
able to look into it for how it works.

I think I'll study the system tables for postgreSQL and do it anyhow.

Thanks, Lothar

> brian
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match