Re: PostgreSQL Adaptor and Plugin
Re: PostgreSQL Adaptor and Plugin
- Subject: Re: PostgreSQL Adaptor and Plugin
- From: Joe Little <email@hidden>
- Date: Thu, 11 Nov 2004 07:59:33 -0800
This may in fact be my issue. I don't use the EO_PK_whatnot.. I have
various sequences that have always worked with HexDreams, and perhaps
the wonder version just doesn't give a proper error condition when it
runs into this. I definitely don't want to change my sequences for my
large production DB, so I may in fact need to stick with the old until
the wonder solution matures further, gets docs, and is otherwise
usuable my mere mortals :)
On Thu, 11 Nov 2004 16:46:09 +0100, Johan Henselmans <email@hidden> wrote:
>
>
>
> On 11-nov-04, at 16:18, Arturo Perez wrote:
>
> > Benjamin J Doherty wrote:
> >> On Nov 10, 2004, at 2:47 PM, Arturo Perez wrote:
> >>> I've worked on the pgSQL plugin in the past and I've not had these
> >>> problems. Usually the above is caused by not having the necessary
> >>> SEQUENCE in place.
> >>>
> >> maybe we're talking about two different plug ins:
> >> the hexdreams plug in DOES require sequences. it's also required for
> >> EOModeler to generate valid postgresql SQL scripts.
> >> the wonder plug in will create a sequence when one does not exist.
> >> it does it on the fly. it happens to be that it will create a
> >> sequence with the same name as the one created by the hexdreams EOM
> >> Plugin.
> >
> > Right. But the sequence still needs to be there one way or another.
> > So, maybe the plug has a problem creating the sequence. Did you try
> > creating the sequence yourself and seeing if the problem goes away?
> >
> >
> > _______________________________________________
> > Do not post admin requests to the list. They will be ignored.
> > Webobjects-dev mailing list (email@hidden)
> > Help/Unsubscribe/Update your Subscription:
> > email@hidden
> >
> > This email sent to email@hidden
> >
>
> It seems to me that the wonder plugin is very picky on what is a proper
> sequence. I have used the HexDream plugin for years, and wanted to try
> the wonder plugin. Unfortunately, the wonder plugin did not recognize
> the sequences that had been used for year as proper plugins for the
> database and wanted to create it's own sequences. That was where I
> bailed out. The auto-generation of sequences is fine, but it should be
> able to recognize existing sequences.
>
> The reason some people don't have these problems is that they are
> apparently hava a database with the sequences that the wonder plugin
> expects, or create a new database (where the problem will not occur, of
> course).
>
> -johan
>
> Johan Henselmans
>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
>
>
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden