| From: | Dmitriy Igrishin <dmitigr(at)gmail(dot)com> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | Rebecca Clarke <r(dot)clarke83(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Function tracking |
| Date: | 2013-06-07 11:57:46 |
| Message-ID: | CAAfz9KMXoE4RJvkwGrjA=kwwcuaBUy7rMwePWcFW8fLWu1v3Ow@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2013/6/7 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> Hello
>
> 2013/6/7 Rebecca Clarke <r(dot)clarke83(at)gmail(dot)com>:
> > Hi all
> >
> > I'm looking for suggestions on the best way to track the updates to a
> > function.
> >
> > We have two databases, Dev & Live, so I want to update Live with just the
> > functions that have been modified in the DEV databas3e.
> > Is there another, easier way to track the updates than manually
> recording it
> > in a document? (I'm trying to eliminate human interference).
> >
>
> There is a few tools
>
>
> http://stackoverflow.com/questions/4804779/how-to-check-difference-between-two-databases-in-postgressql
> http://pgdiff.sourceforge.net/
>
> But I prefer editing files for storing schema and function
> definitions. And I use a git. I dislike direct object modifying via
> tools like pgAdmin and similar.
>
Same here.
--
// Dmitriy.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Dahn | 2013-06-07 12:10:27 | Full text search, SQL functions, and the planner |
| Previous Message | Beena Emerson | 2013-06-07 11:53:18 | excute function before DROP EXTENSION |