I'm running 10.9.5 of OSX.
I got the MySQL and PostgreSQL dependencies installed (I think).
Checked out the git repo for mysql_fdw from
git://github.com/EnterpriseDB/mysql_fdw
USE_PGXS=1 make
and got the error:
mysql_fdw.c
mysql_fdw.c:153:56: error: use of undeclared identifier 'RTLD_
at 12:40 PM, Kirk Roybal wrote:
>
>> Hi Guys, I propose a lag (and/or lead) window function that propagates the
>> last non-null value to the current row. Here's an example of what I mean by
>> that: CREATE TABLE lag_test (id serial primary key, natural_key intege
This is cleaner and better.
Thanks for the link, I hope to see it in a commitfest some time soon.
/Kirk
On 2014-10-28 16:34, Vladimir Sitnikov wrote:
> There is already a patch for that (ignore/respect nulls in lead/lag):
> https://commitfest.postgresql.org/action/patch_view?id=1096 [1]
Hi Guys,
I propose a lag (and/or lead) window function that propagates the last
non-null value to the current row.
Here's an example of what I mean by that:
CREATE TABLE lag_test (id serial primary key, natural_key integer,
somebody text);
INSERT INTO lag_test(natural_key, somebody)
VALUES
On 2014-09-30 17:01, Josh Berkus wrote:
> On 09/30/2014 02:43 PM, Tom Lane wrote:
> =?UTF-8?Q?Fabr=C3=ADzio_de_Royes_Mello?= writes:
> What's your thoughts about we implement IF NOT EXISTS for CREATE INDEX? It's
> got the same semantic problems as every other variant of CINE. If there were
Since PostgreSQL started down that road for so many other relations, I
think many people just expect this to happen as a logical extension.
It certainly makes life a lot easier in combination with build
management systems.
/kirk
On 2014-09-30 16:43, Tom Lane wrote:
> =?UTF-8?Q?Fabr=C3=AD
I think this (pg_restore -l | pg_restore -L) will get me where I need to
go for now by inserting a small shell script in between that pushes the
materialized views to the end of the list, but then I will also have to
manage my own dependencies for the items that I re-sort (MatViews of
MatViews).
Th
I asked a question over on StackOverflow, and Craig Ringer told me to
report it here.
http://stackoverflow.com/questions/24413161/how-can-i-prevent-materialized-views-from-refreshing-during-pg-restore
I have created a dump of the database using pg_dump in "custom" format
(-Fc). This format allows
