Re: [Gmod-schema] Request about Chado structure evolution

[Scott C. <sc...@sc...>]

Hi Lucas,

Just to clarify, when you did your migration, are you talking about a
database dump and then reload into a new version of postgresql? And what
were the nature of the changes: I assume relationships were maintained,
just that the primary keys themselves changed.  Also, what was the nature
of the breakage to your site? How were primary keys being used that
resulted in the breakage?

I'm pretty sure you can specify that primary keys be included in dumps and
when reloading from a dump that the primary keys be either used or not, but
I imagine there's a command line flag for that (I don't recall--I haven't
done that sort of thing in a long time).

Hopefully, there is a way to make this process work for you.

Scott


On Wed, Jul 1, 2020 at 10:17 AM Lucas Fioletti-Nieder <
luc...@cr...> wrote:

> Hello,
>
> We work on a huge database about the Ascidie. Our database is based on
> Chado structure but when we done the last migration, every primary key
> are changed and I don't understand why.
> We meet difficulties because our website is not worked because we wrote
> explicitly our primary key inside our code.
>
> Could you bring me light.
>
> Thanks for you request.
>
> Nieder-Fioletti Lucas.
> CRBM-CNRS.
>
>
>
> _______________________________________________
> Gmod-schema mailing list
> Gmo...@li...
> https://lists.sourceforge.net/lists/listinfo/gmod-schema
>


-- 
------------------------------------------------------------------------
Scott Cain, Ph. D.                                   scott at scottcain dot
net
GMOD Coordinator (http://gmod.org/)                     216-392-3087
Ontario Institute for Cancer Research