On Sun, 9 Oct 2016 06:44:10 -0700,
Adrian Klaver wrote:
[...]
> Not sure. When I tried using the above(on 9.5) it failed during the
> CREATE OR REPLACE FUNCTION public.angle_vectors_avg stage with:
> ERROR: type "vector" does not exist
> So where is that coming from in your setup?
Aw nuts, I
On Sun, 09 Oct 2016 12:40:09 -0400,
Tom Lane wrote:
> Adrian Klaver writes:
>> On 10/09/2016 08:46 AM, Tom Lane wrote:
>>> Clearly a bug --- the wrong type OIDs are being passed down to
>>> array_append. It should be told that it's getting called as
>> For my edification, why does this work?:
On Sun, 09 Oct 2016 16:00:21 -0400,
Tom Lane wrote:
> "Sebastian P. Luque" writes:
>> Tom Lane wrote:
>>> On closer inspection, the error is only in the
>>> aggregate-used-as-window-function case, not plain aggregation.
>> Yes, I see the same phen
On Thu, 11 Feb 2016 23:48:53 -0500,
Tom Lane wrote:
> Seb writes:
>> I recently upgraded a server from 9.4 to 9.5 (Debian) via
>> pg_upgradecluster. The upgrade finished well, and so far the
>> databases in the upgraded cluster seem in good form. However, I
>> noticed a dramatic reduction in t
Hi,
Although I'm quite happy with the way my system (Debian sid) has set up
the server (PosgreSQL 9.1), I'm not sure I'm using the
authentication/privilege mechanism properly.
In particular, I'd like to understand how the administrative user
(postgres) is set up. Here is what pg_hba contains:
#
On Tue, 20 Sep 2011 11:36:15 -0400,
Tom Lane wrote:
> Seb writes:
>> I'm starting to migrate to 9.1 and see that there's a new mechanism
>> to install extensions via de "CREATE EXTENSION" command. It seems
>> very simple and convenient, but with "CREATE EXTENSION tablefunc" I'm
>> getting the e
Hi,
I need to update field1 in table1, gathering data from field1 in table2.
The following SELECT shows the data as it needs to be updated:
SELECT a.field1 || regexp_replace(b.field1, '.*(mypattern)', e'. \\1')
FROM table1 a JOIN table2 b USING (id)
WHERE a.field1 NOT LIKE '%mypattern%' AND b.fie
