Re: [GENERAL] pg_catalog tables don't have constraints?

and uses Graphviz. After doing the work to add the relationships I realised that SchemaSpy does not like the oid system columns that we use for keys so it wouldn't work. I will go ahead and replace them all with something else and see how it does but I haven't gotten back to it yet. -- Neil

Re: [GENERAL] pg_catalog tables don't have constraints?

> > Of course. My plan is to copy the catalogs into a new schema so I can add fk > constraints and then get something like navicat or datagrip to draw it. > Hi. I made some progress on this and I've added all the diagrams and documentation I've been able to produce so far for v10beta as well as

Re: [GENERAL] pg_catalog tables don't have constraints?

On 9 Jun 2017 14:59, <kbran...@pwhome.com> wrote: Neil Anderson <n...@postgrescompare.com> wrote: > I've been exploring the pg_catalog tables and pointed a couple of tools at > it to extract an ER diagram for a blog post. At first I thought it was a bug > in the drawin

Re: [GENERAL] pg_catalog tables don't have constraints?

> The bigger picture here is that catalog changes are supposed to be > executed by C code in response to DDL commands, and it's the C code > that is charged with maintaining catalog consistency. Constraints > would be useful if we supported updating the catalogs with direct > SQL manipulations;

[GENERAL] pg_catalog tables don't have constraints?

as to why? Thanks, Neil -- Neil Anderson n...@postgrescompare.com https://www.postgrescompare.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] dump to pg

> > Thanks for the suggestion. Problem is the data is highly sensible and > cannot go on the cloud or non trusted place Sounds like the real question now is not how to import the data, but how to convert the backups you have to CSV or similar? Another idea for SQL Server is to use the bcp

Re: [GENERAL] Oracle database into PostgreSQL using Ora2PG tool.

On 2 June 2017 at 11:57, stevenchang1213 wrote: > > > tell me where this function add_job_history() is? > Actually, I don't think you can count on ora2pg to transform your pl/sql > code to plpgsql or other (un)trusted procedural language code. It's not that > simple! I

Re: [GENERAL] dump to pg

think SQL Server Express is limited to 10GB on the later versions. Another tool that can read SQL Server backups is SQL Data Compare from Redgate, it has a 14 day trial. http://www.red-gate.com/products/sql-development/sql-data-compare/ Neil Anderson n...@postgrescompare.com https://www.postgrescom

Re: [GENERAL] Oracle database into PostgreSQL using Ora2PG tool.

e_date, LOCALTIMES... > ^ > NOTICE: relation "employees" does not exist, skipping Since this is a NOTICE maybe it's a red herring? the results of a CREATE IF NOT EXISTS or similar? -- Neil Anderson n...@postgrescompare.com https://www.postgrescompare.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Oracle to PostgreSQL Migration.

//github.com/darold/ora2pg/blob/master/README#L307 > Hi Chris, > > I am able to get the output script in output.sql but now data migration is > the big problem. -- Neil Anderson n...@postgrescompare.com https://www.postgrescompare.com -- Sent via pgsql-general mailing li

Re: [GENERAL] Help with terminology to describe what my software does please?

(note: it is also possible to make users database >> specific) >> 4. list of defined databases > > > And anything different below the above, I am thinking checking a dev cluster > against a production cluster. > > > > -- > Adrian Klaver > adrian.kla...@akl

Re: [GENERAL] Help with terminology to describe what my software does please?

t; > > -- > *Melvin Davidson* > I reserve the right to fantasize. Whether or not you > wish to share my fantasy is entirely up to you. > -- Neil Anderson n...@postgrescompare.com https://www.postgrescompare.com

[GENERAL] Help with terminology to describe what my software does please?

know what is the most common way to say that it compares everything but the data. Any suggestions from your experience? Thanks, Neil -- Neil Anderson n...@postgrescompare.com https://www.postgrescompare.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Any undocumented catalog changes remaining for v10?

> > Feature freeze is in effect and we have a Beta release out. Major bugs or > major usability issues are the only things that would cause any change to > the catalogs at this point and there likely won't be many, if any, of those > (at least not ones that necessitate catalog changes - must

[GENERAL] Any undocumented catalog changes remaining for v10?

and whether or not I can expect a lot of changes to the docs between now and release time for v10? Thanks -- Neil Anderson n...@postgrescompare.com https://www.postgrescompare.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] column names and dollar sign

Year$ int >>> ); A strange naming convention. It has a whiff of Visual Basic Type Characters about it, https://docs.microsoft.com/en-us/dotnet/articles/visual-basic/programming-guide/language-features/data-types/type-characters. Any chance there is a connection there? -- Neil Anderson n...@pos

Re: [GENERAL]

ERE tables.relname = 'films' AND columns.attnum > 0; Thanks, Neil -- Neil Anderson n...@postgrescompare.com https://www.postgrescompare.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Python versus Other Languages using PostgreSQL

On 9 May 2017 at 06:20, Neil Anderson <neil.t.ander...@gmail.com> wrote: > On 9 May 2017 at 05:26, Francisco Olarte <fola...@peoplecall.com> wrote: >> Paul: >> >> On Tue, May 9, 2017 at 2:45 AM, Paul Hughes <p...@vivation.com> wrote: >>> My qu

Re: [GENERAL] Python versus Other Languages using PostgreSQL

On 9 May 2017 at 05:26, Francisco Olarte wrote: > Paul: > > On Tue, May 9, 2017 at 2:45 AM, Paul Hughes wrote: >> My question still remains though - why is it that all the largest web >> platforms that have used PostgreSQL *specifically* choose

Re: [GENERAL] Python versus Other Languages using PostgreSQL

_campaign=sig-email_content=webmail_term=icon> >> Virus-free. www.avast.com >> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail_term=link> >> >> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > > > > -- > Adri

Re: [GENERAL] Stored procedure version control

with one or the other. In the early days while you have little data to worry about you might use the static approach and then switch to migrations. You just pick a baseline to start from and carry on from there. -- Neil Anderson n...@postgrescompare.com http://blog.postgrescompare.com -- Sent via

Re: [GENERAL] Stored procedure version control

with one or the other. In the early days while you have little data to worry about you might use the static approach and then switch to migrations. You just pick a baseline to start from and carry on from there. -- Neil Anderson n...@postgrescompare.com http://blog.postgrescompare.com -- Sent via

[GENERAL] Re: regarding schema only migration from sqlserver to postgres with runmtk.sh

ationToolkit.java:3376) at com.edb.MigrationToolkit.main(MigrationToolkit.java:1700) Caused by: java.lang.ClassNotFoundException: org.postgresql.Driver On Thu, Jun 16, 2016 at 8:59 PM, Neil Anderson <neil.t.ander...@gmail.com <mailto:neil.t.ander...@gmail.com>> wrote: On 2016-06-16 11:13 AM, Durgama

[GENERAL] Re: regarding schema only migration from sqlserver to postgres with runmtk.sh

On 2016-06-16 11:13 AM, Durgamahesh Manne wrote: yes sir as per above discussion..i already looked pdf postgres plus guide you mentioned as well as i already set password for postgres user associated with postgres db On Thu, Jun 16, 2016 at 8:30 PM, Durgamahesh Manne