lly interesting 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 b
>
> 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
th
On 9 Jun 2017 14:59, wrote:
Neil Anderson 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 drawing tool but it appears that the relationships between th
> 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; bu
story 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
>
> 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 utility.
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 wonder, does plpgsql compil
s 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.postgrescompare.com
--
Sent vi
LTIMES...
> ^
> 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
ttps://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 maili
users (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..
info.
>
>
>
> --
> *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
refer to
tighten it up.
I guess I don't 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 mailin
>
> 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 disco
cycle 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 subscrip
nge 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...@postgrescompare.com
http
y)
WHERE 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
On 9 May 2017 at 06:20, Neil Anderson wrote:
> 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
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 Python as their
>> back-end language?
>
> Do y
content=webmail&utm_term=icon>
>> Virus-free. www.avast.com
>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
>>
>> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
>
>
stick 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
-
stick 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
-
grationToolkit.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
mailto:neil.t.ander...@gmail.com>> wrote:
On 2016-06-16 11:13 AM, Durgamahesh Manne wrote:
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
mailto:maheshpostgr...@gma
24 matches
Mail list logo
