> -Ursprüngliche Nachricht-
> Von: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] Im Auftrag von George Neuner
> Gesendet: Donnerstag, 21. September 2017 18:35
>
> I can't speak for all VM managers, but Vmware's standard static
snapshots
> *do* capture bot
> -Ursprüngliche Nachricht-
> Von: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] Im Auftrag von Moreno Andreo
> Gesendet: Mittwoch, 20. September 2017 17:42
> I may be wrong, as I don't know MS SQL Server, but in the way you describe it,
> you make me com
> Von: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] Im Auftrag von George Neuner
>
> But VSS is needed only to copy VM files *while* they are in use. If you
> snapshot
> the VM, the snapshot files then are read-only and can be freely copied. As
> long
> as t
> -Ursprüngliche Nachricht-
> Von: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] Im Auftrag von Thomas Güttler
> Gesendet: Mittwoch, 20. September 2017 10:03
> An: pgsql-general@postgresql.org
> Betreff: [GENERAL] VM-Ware Backup of VM safe?
>
> We run a P
> -Ursprüngliche Nachricht-
>
> I apologize for not being smarter on this thread. When I helped with the
> Windows port, I was told Windows didn't have hard links for use by
tablespace
> directories, so I got it into my head that Windows didn't have hard links.
> Therefore, when I was wri
Running PostgreSQL 9.6 on a Windows Server.
Table "t" is kind of a materialized view with > 100 columns and 2.24 Mio
rows. Queries are generated by an ORM framework - fairly difficult to
modify.
Vacuum analyze was carried out - no impact.
The framework generates queries like this:
sel
A similar result was achieved by return a dummy ID from the function for
records without country.
Any idea why the functional index does not work in a LEFT JOIN query?
Thanks Klaus
Von: Jeff Janes [mailto:jeff.ja...@gmail.com]
Gesendet: Dienstag, 21. März 2017 08:22
An: Klaus P.
Given a country table and an order table:
CREATE TABLE g.country
(
-- inherited from table g.standard: oid uuid NOT NULL,
--
some more columns inherited
lisocode integer NOT NULL, -- Numeric ISO 3166 code
szisoalpha2 character varying(2), -- The 2 letter country code
szisoalpha
I'm using the setting "Toolchain: Visual Studio 2010" for C language
extensions.
Is this still correct for the current versions?
Thanks Klaus
We run two separate databases which are synchronized through our own
replication system (two master databases, so we use our own trigger based
methods). Let's call the two databases "main" and "remote".
>From time to time we get constraint violations on sorting fields classified
>UNIQUE when us
We run two separate databases which are synchronized through our own
replication system (two master databases, so we use our own trigger based
methods). Let's call the two databases "main" and "remote".
>From time to time we get constraint violations on sorting fields classified
UNIQUE when user
> -Ursprüngliche Nachricht-
>
> What exactly is the problem you are trying to solve?
>
> If you and your users are consistent about never using quotes, your users
can
> write:
>
> SELECT MyColumn FROM MyTable ORDER BY MyColumn;
>
> It will select mycolumn from mytable, but that doesn't
Hi,
does anybody out there have experience with the several PL's which are
available for PostgreSQL? I am currently evaluating several databases
(commercial as well as free & open source) for a new project and would
just like to hear some feedback.
PL/Java seems to be developed by a fairly small
13 matches
Mail list logo
