Point taken, thanx,
however from the docs, it is far from explicit that setting
session_replication_role to 'replica'
can disable FK constraints (RI) and finally result in an incosistent database.
It might be that RI in postgres is implemented via triggers, but to the user,
that is just an
W dniu 04/26/2013 12:25 AM, Merlin Moncure pisze:
On Thu, Apr 25, 2013 at 1:30 PM, Rafał Pietrak ra...@zorro.isa-geek.com wrote:
[--]
No, I don't (manual:
http://www.postgresql.org/docs/9.1/static/tutorial-window.html, have just
one word distinct on that page, and it's not
I have two tables with countries and persons living in those countries:
create table countries (
codechar(2) not null primary key,
eu boolean not null
);
insert into countries values
('AR', false),
('BE', true),
('CH',
two triggers?.
one on eu_loans... and one on persons (if valid eu_loan - cant move...)
2013/4/26 CR Lender crlen...@gmail.com
I have two tables with countries and persons living in those countries:
create table countries (
codechar(2) not null primary key,
On Fri, 26 Apr 2013 11:01:28 +0200
CR Lender crlen...@gmail.com wrote:
I have two tables with countries and persons living in those
countries:
create table countries (
codechar(2) not null primary key,
Isn't this redundant? Primary keys are always NOT NULL.
Enter
On 2013-04-26 12:17, D'Arcy J.M. Cain wrote:
On Fri, 26 Apr 2013 11:01:28 +0200
CR Lender crlen...@gmail.com wrote:
create table countries (
codechar(2) not null primary key,
Isn't this redundant? Primary keys are always NOT NULL.
Yes, I forgot to remove the NOT
On Fri, Apr 26, 2013 at 3:15 AM, Rafał Pietrak ra...@zorro.isa-geek.com wrote:
W dniu 04/26/2013 12:25 AM, Merlin Moncure pisze:
On Thu, Apr 25, 2013 at 1:30 PM, Rafał Pietrak ra...@zorro.isa-geek.com
wrote:
[--]
No, I don't (manual:
On Fri, Apr 26, 2013 at 11:01:28AM +0200, CR Lender wrote:
Is there any way to ensure that all donors and recipients in eu_loans
are in the EU, without altering the countries and persons tables?
One way to do this would be to add countries to the eu_loans table so
it looks like this:
create
Hi All,
I've come upon some very strange behaviour with an UPDATE query which
causes Postgres to consume all the disk space on the server for no
apparent reason.
Basically, I'm trying to run an UPDATE involving three medium-sized
tables (~60k rows each), which generates a query plan with
W dniu 04/26/2013 12:25 AM, Merlin Moncure pisze:
[--]
select array_agg(v order by v desc) from generate_series(1,3) v;
also, 'distinct'
select array_agg(distinct v order by v desc) from (select
generate_series(1,3) v union all select generate_series(1,3)) q;
Hi All,
I've come upon some very strange behaviour with an UPDATE query which
causes Postgres to consume all the disk space on the server for no
apparent reason.
Basically, I'm trying to run an UPDATE involving three medium-sized
tables (~60k rows each), which generates a query plan with
Hi all,
I'm trying to create a table that contains only valid table names. I'm
currently using reglass for the field type which works fine for when you
are adding to the table (i.e. you can't add invalid tablesnames to the
table). But it is still possible to leave the table in an invalid
On 26/04/13 10:01, CR Lender wrote:
I can add a trigger on eu_loans to check if Diane and Betty both live in
the EU. The problem is how to prevent one of them from moving to a
non-EU country (if they do, the loan has to be cancelled first). They
are however allowed to move to other EU countries.
On 26/04/13 16:09, Michael Graham wrote:
I'm pretty sure I can't do what I need as postgres doesn't support
triggers on DDL but maybe I'm wrong.
If you're still in development and not live, it'll be worth checking out 9.3
http://www.postgresql.org/docs/devel/static/event-triggers.html
--
On 25/04/13 18:01, Martín Marqués wrote:
Just tried upgrading and added the apt-postgresql.org repo to my
Debian server (on testing now) and I got some backages like barman
retained because some dependencies couldn't be satisfied.
Los siguientes paquetes tienen dependencias incumplidas:
=?ISO-8859-2?Q?Rafa=B3_Pietrak?= ra...@ztk-rp.eu writes:
array_agg(distinct v order by v) -- works in postgres, but actually I need:
array_agg(distinct v order by v,x) -- which doesn't. (ERROR:
expressions must appear in argument list),
Why do you think you need that? AFAICS, the extra
Hello,
You can have the list of table names from pg_class such as
SELECT c.relname as Name ,
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('r') AND n.nspname NOT IN ('pg_toast', 'pg_catalog',
'information_schema') ;
So, if you
Hi,
I'm curious what the design assumptions of the LISTEN / NOTIFY are. For
example, would it work to have a thousand LISTEN channels open at the same time
or would that be abusing the assumptions that were made? In short, I'm trying
to understand if I need a few central LISTEN / NOTIFY
On Fri, Apr 26, 2013 at 11:30 AM, Perry Smith pedz...@gmail.com wrote:
Hi,
I'm curious what the design assumptions of the LISTEN / NOTIFY are. For
example, would it work to have a thousand LISTEN channels open at the same
time or would that be abusing the assumptions that were made? In
W dniu 04/26/2013 05:25 PM, Tom Lane pisze:
=?ISO-8859-2?Q?Rafa=B3_Pietrak?= ra...@ztk-rp.eu writes:
array_agg(distinct v order by v) -- works in postgres, but actually I need:
array_agg(distinct v order by v,x) -- which doesn't. (ERROR:
expressions must appear in argument list),
Why do
Perry Smith pedz...@gmail.com writes:
I'm curious what the design assumptions of the LISTEN / NOTIFY are. For
example, would it work to have a thousand LISTEN channels open at the same
time or would that be abusing the assumptions that were made? In short, I'm
trying to understand if I
Art Ruszkowski a...@prudenttradingsystems.com writes:
I have a user defined aggregate function and in Sfunc I need to
reference current row number relative to window frame. Ideallly I would like
to have following construct:
select my_aggregate(x,current_row_number_relative_to window) over
I've have an application which uses the public schema for all of its
relations.
I want to change the name of the schema (in preparation to merging the
database into that of another application, which also uses the public
schema for its tables).
I could qualify all of the tables and sequence with
2) notify does not work with pgbouncer (yet), although I have in the
past had a private pgbouncer with functioning notify.
Is there a plan to make it work?
Actually - stupid question - probably not important... But good to know...
Listen connection doesn't need to work via pgbouncer...
SELECT DISTINCT a, b, c, array_agg(d) OVER (PARTITION BY c ) FROM
(
SELECT a, b, c, d FROM testy where e 'email' and c='1035049' ORDER BY
a, b, c, e
) t
Doesnt give u desired result?
On Friday, April 26, 2013, Rafał Pietrak wrote:
W dniu 04/26/2013 05:25 PM, Tom Lane pisze:
Jeff Janes wrote
I've have an application which uses the public schema for all of its
relations.
I want to change the name of the schema (in preparation to merging the
database into that of another application, which also uses the public
schema for its tables).
I could qualify all of the
W dniu 04/26/2013 09:54 PM, Misa Simic pisze:
SELECT DISTINCT a, b, c, array_agg(d) OVER (PARTITION BY c ) FROM
(
SELECT a, b, c, d FROM testy where e 'email' and c='1035049'
ORDER BY a, b, c, e
) t
Doesnt give u desired result?
Hmm... actualy, it looks like it does. I wouldn't
It currently takes up to 24h for us to run a large set of UPDATE
statements on a database, which are of the form:
UPDATE table SET field1 = constant1, field2 = constant2, ... WHERE
id = constid
(We're just overwriting fields of objects identified by ID.)
The tables have handfuls of
On 27/04/13 12:14, Yang Zhang wrote:
It currently takes up to 24h for us to run a large set of UPDATE
statements on a database, which are of the form:
UPDATE table SET field1 = constant1, field2 = constant2, ... WHERE
id = constid
(We're just overwriting fields of objects identified
We're using Postgresql 9.1.9 on Ubuntu 12.04 on EBS volumes on
m1.xlarge instances, which have:
15 GiB memory
8 EC2 Compute Units (4 virtual cores with 2 EC2 Compute Units each)
64-bit platform
(Yes, we're moving to EBS Optimized instances + Provisioned IOPS
volumes, but prelim. benchmarks
We're running on EBS volumes on EC2. We're interested in leveraging
EBS snapshotting for backups. However, does this mean we'd need to
ensure our pg_xlog is on the same EBS volume as our data?
(I believe) the usual reasoning for separating pg_xlog onto a separate
volume is for performance.
Please do not top post, the convention in these list are to add stuff at
the end, apart from comments interspersed to make use of appropriate
context!
On 27/04/13 13:35, Yang Zhang wrote:
We're using Postgresql 9.1.9 on Ubuntu 12.04 on EBS volumes on
m1.xlarge instances, which have:
15 GiB
On Fri, Apr 26, 2013 at 7:01 PM, Gavin Flower
gavinflo...@archidevsys.co.nz wrote:
Please do not top post, the convention in these list are to add stuff at the
end, apart from comments interspersed to make use of appropriate context!
Noted, thanks.
Anyway, any performance hints are greatly
Yang Zhang yanghates...@gmail.com writes:
It currently takes up to 24h for us to run a large set of UPDATE
statements on a database, which are of the form:
UPDATE table SET field1 = constant1, field2 = constant2, ... WHERE
id = constid
(We're just overwriting fields of objects
34 matches
Mail list logo