Re: Schema diff tools excludes the SET directive from the function header

2023-08-03 Thread Дмитрий Иванов
 AM Дмитрий Иванов > wrote: > >> Hi >> Schema diff utilities exclude the SET directive from the function header >> in compare mode. >> Reproducing the problem: >> 1. Create a copy of the database with the function containing the SET >> directive >> 2.

Re: Schema diff tools excludes the SET directive from the function header

2023-08-03 Thread Akshay Joshi
Hi Can you please log the issue on GitHub <https://github.com/pgadmin-org/pgadmin4/issues/new>? On Thu, Aug 3, 2023 at 6:18 AM Дмитрий Иванов wrote: > Hi > Schema diff utilities exclude the SET directive from the function header > in compare mode. > Reproducing the problem:

Schema diff tools excludes the SET directive from the function header

2023-08-02 Thread Дмитрий Иванов
Hi Schema diff utilities exclude the SET directive from the function header in compare mode. Reproducing the problem: 1. Create a copy of the database with the function containing the SET directive 2. Modify the function and perform the comparison. In the resulting script, I am missing the SET

Re: Toll Schema Diff

2023-07-28 Thread Дмитрий Иванов
Schema Diff Tools error <https://gist.github.com/firstDismay/68fc1b45b169d17edb4b2eff85b63c81> -- С уважением, Дмитрий! пт, 28 июл. 2023 г. в 17:23, Akshay Joshi : > Hi > > On Fri, Jul 28, 2023 at 5:47 PM Дмитрий Иванов > wrote: > >> Hello. >> Your toll Schem

Re: Toll Schema Diff

2023-07-28 Thread Akshay Joshi
Hi On Fri, Jul 28, 2023 at 5:47 PM Дмитрий Иванов wrote: > Hello. > Your toll Schema Diff tool has saved me a lot of time and nerves, but I > encountered one unpleasant problem when creating scripts for functions. The > synchronization strategy involves creating source functions

Toll Schema Diff

2023-07-28 Thread Дмитрий Иванов
Hello. Your toll Schema Diff tool has saved me a lot of time and nerves, but I encountered one unpleasant problem when creating scripts for functions. The synchronization strategy involves creating source functions and deleting target functions. In most cases this works. But if a function

Re: schema diff tool problem with owner statements

2021-11-15 Thread Akshay Joshi
>> is the target) and generate a script that can be run on the target that >> will create the missing tables. I ran the schema diff, and it generated >> items like this: >> >> CREATE TABLE IF NOT EXISTS tablename >> ( >> fields, etc >> ) >>

Re: schema diff tool problem with owner statements

2021-11-12 Thread postgresql
that will create the missing tables.  I ran the schema diff, and it generated items like this: CREATE TABLE IF NOT EXISTS tablename ( fields, etc ) TABLESPACE pg_default; ALTER TABLE IF EXISTS public.tablename OWNER to devschema; When I run the s

Re: schema diff tool problem with owner statements

2021-11-11 Thread Akshay Joshi
Hi On Fri, Nov 12, 2021 at 12:45 AM wrote: > I'm trying to compare 2 schemas (devschema is the source and testschema > is the target) and generate a script that can be run on the target that > will create the missing tables. I ran the schema diff, and it generated > items like

schema diff tool problem with owner statements

2021-11-11 Thread postgresql
I'm trying to compare 2 schemas (devschema is the source and testschema is the target) and generate a script that can be run on the target that will create the missing tables.  I ran the schema diff, and it generated items like this: CREATE TABLE IF NOT EXISTS tablename ( fields

Re: Schema Diff

2021-10-01 Thread Pradip Parkale
Hi Endre, Yes, it is available on latest pgAdmin version. On Fri, Oct 1, 2021, 6:16 PM wrote: > Hello, > > > > Is the Schema Diff tool available in the latest release of PGAdmin? We > loved it when it was available. It was taken out after 9.24, and we haven’t > upgrad

Schema Diff

2021-10-01 Thread endre_pekarik
Hello, Is the Schema Diff tool available in the latest release of PGAdmin? We loved it when it was available. It was taken out after 9.24, and we haven't upgraded since as we didn't want to lose it. Thank you Endre

Schema diff tool

2020-08-12 Thread Alexander Smyslov
Is it possible to add a command line interface (CLI) to pgadmin4 to use schema diff in scripts (like apgdiff)?