2013/1/16 Edson Richter edsonrich...@hotmail.com:
I was wondering, would be a nice addition the ability to read the chain of
triggers (may be another trigger variable like TG_OP, called TG_CHAIN or
something else that will be an array with the name of the triggers called
before current
On Sun, Jan 13, 2013 at 08:46:58PM -0700, Scott Marlowe wrote:
The reasons to NOT use ubuntu under PostgreSQL are primarily that 1:
they often choose a pretty meh grade kernel with performance
regressions for their initial LTS release. I.e. they'll choose a
3.4.0 kernel over a very stable
On Wed, Jan 16, 2013 at 08:10:26AM +1100, Chris Angelico wrote:
On Tue, Jan 15, 2013 at 4:55 AM, Brian Sutherland
br...@vanguardistas.net wrote:
I'm guessing that it's some kind of race condition, but I wouldn't know
where to start looking.
Look for a recursive import (A imports B, B
- Original Message -
From: Stuart Bishop stu...@stuartbishop.net
To: Bruce Momjian br...@momjian.us
Cc: Scott Marlowe scott.marl...@gmail.com, SUNDAY A. OLUTAYO
olut...@sadeeb.com, Gavin Flower gavinflo...@archidevsys.co.nz, Chris
Ernst cer...@zvelo.com, pgsql-general@postgresql.org
On 01/15/2013 09:16 PM, John R Pierce wrote:
On 1/15/2013 9:02 PM, Robert James wrote:
I would do this as actual databases, but Postgres doesn't allow JOINs
and FKs between different databases. Can I use schema for the above?
How? How do I backup and restore schema independently?
pg_dump
Is there a good sample database (with decent data volumes) for
postgresql? I am interested in one for learning and automated testing.
I looked at http://pgfoundry.org/projects/dbsamples/ (specifically at
pagila), but it seemed incomplete and not maintained,
I also looked at
On Wed, Jan 16, 2013 at 9:53 AM, Vraj Mohan r.vrajmo...@gmail.com wrote:
Is there a good sample database (with decent data volumes) for
postgresql? I am interested in one for learning and automated testing.
I looked at http://pgfoundry.org/projects/dbsamples/ (specifically at
pagila), but it
Hi!
I'm debugging few triggers I wrote these days, and I can't see the
triggers statements being logged.
Probably I'm doing something wrong.
I just enabled
log_statement = 'all'
In postgresql.conf, but I can see all statements issued by my
application, but the statements in trigger don't
Pavel Stehule pavel.steh...@gmail.com writes:
2013/1/16 Edson Richter edsonrich...@hotmail.com:
I was wondering, would be a nice addition the ability to read the chain of
triggers (may be another trigger variable like TG_OP, called TG_CHAIN or
something else that will be an array with the name
On 01/15/2013 07:08 PM, Meta Seller Dev/Admin wrote:
On Wed, Jan 16, 2013 at 11:45 AM, Rob Sargent robjsarg...@gmail.com wrote:
What environment are you in. In jdbc you can address the resultset by
column name.
C++, so it's quite inefficient to always use names.
Chris Angelico
Craft
On Mon, Jan 14, 2013 at 09:05:09AM -0800, Adrian Klaver wrote:
On 01/14/2013 08:30 AM, Brian Sutherland wrote:
Hi,
I have a plpython stored procedure which sometimes fails when I run my
applications automated test suite. The procedure is called hundreds of
times during the tests but only
Em 16/01/2013 14:18, Tom Lane escreveu:
Pavel Stehule pavel.steh...@gmail.com writes:
2013/1/16 Edson Richter edsonrich...@hotmail.com:
I was wondering, would be a nice addition the ability to read the chain of
triggers (may be another trigger variable like TG_OP, called TG_CHAIN or
something
On 01/16/2013 08:20 AM, Brian Sutherland wrote:
On Mon, Jan 14, 2013 at 09:05:09AM -0800, Adrian Klaver wrote:
On 01/14/2013 08:30 AM, Brian Sutherland wrote:
I had a look at the files open by the process, there were not that many,
so no leaks or anything. Just an utterly insane OSX default
The subject has been discussed on this mailing list before, recently.
To be able to switch from SQL Server to Postgresql, for me this is
essential.
Therefore the question: are there plans to create a set of case
insensitive, and maybe also accent insensitive collations in the near
future?
I have
Marcel van Pinxteren marcel.van.pinxte...@gmail.com writes:
Therefore the question: are there plans to create a set of case
insensitive, and maybe also accent insensitive collations in the near
future?
Not from the Postgres project -- we just use the collations supplied by
the operating
From the Microsoft site I learned
http://msdn.microsoft.com/en-us/library/ms188046(v=sql.105).aspx
that they combine collation and ComparisonStyle to a collation name.
I thought that case insensitivity had to be built into the collation, but
apparently MS built case sensitivity in the database
On Wed, Jan 16, 2013 at 03:23:30PM -0500, Robert James wrote:
Is there a recommended, high performance method to check for subdomains?
Something like:
- www.google.com is subdomain of google.com
- ilikegoogle.com is not subdomain of google.com
There are many ways to do this (lowercase and
I've been getting a funny SQL error, which I've boiled down to this case.
SELECT (regexp_matches('abc', '(.)b(.)'))[1] IS NOT NULL
-- Returns true, as expected
SELECT (regexp_matches('abc', '(.)b(.)'))[1] IS NOT NULL AND true
-- Gives this error:
ERROR: argument of AND must not return a set
SQL
On 15.01.2013, at 16:36, Tom Lane t...@sss.pgh.pa.us wrote:
T. E. Lawrence t.e.lawre...@icloud.com
CAMkU=1y6UuxPYbf_ky8DVDsJi=g=uQ1t0B6kwLEtdc7NLxB_-
So, apparently, we need to interrupt the heavy imports on some reasonable
intervals and do manual VACUUM ANALYZE?
Data import as such, no
On 15.01.2013, at 17:32, Jeff Janes jeff.ja...@gmail.com wrote:
T.E., Fortunately in point releases from August 2012 (9.0.9, 9.1.5,
etc.), the default server log settings will log both the cancel and
the command triggering the cancel. So if you are running an up to
date server, you can just
On Jan 16, 2013, at 12:23 PM, Robert James srobertja...@gmail.com wrote:
Is there a recommended, high performance method to check for subdomains?
Something like:
- www.google.com is subdomain of google.com
- ilikegoogle.com is not subdomain of google.com
There are many ways to do this
I am trying to migrate from 8.4 to 9.2 on OSX 10.8 (Mountain Lion)
Both 8.4 and 9.2 have been installed with the installers for OSX from
EnterpriseDB
Both have been stopped.
As user postgres, I run the pg_upgrade command and get the error
'old and new pg_controldata alignments are invalid or do
Robert James srobertja...@gmail.com writes:
SELECT (regexp_matches('abc', '(.)b(.)'))[1] IS NOT NULL AND true
-- Gives this error:
ERROR: argument of AND must not return a set
SQL state: 42804
Can anyone make heads or tails of it? Is it a real bug? Is there a work
around?
It's not a bug:
Robert James wrote
On 1/13/13, Chris Angelico lt;
rosuav@
gt; wrote:
On Mon, Jan 14, 2013 at 3:37 PM, Robert James lt;
srobertjames@
gt;
wrote:
Thanks. But how do I do that where I have many literals? Something
like:
INSERT INTO seltest (id, a, b) SELECT (1,2,3),(4,5,6),(7,8,9)
It is not possible because connection is local variable in both thread
functions, no common variables are used.
I checked that it also crashes without SSL. Two threads connecting to the same
server, different databases.
Joanna
--
Sent via pgsql-general mailing list
convert it into a heatmap at the end of each day.
How to do it with Postgresql?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-store-clickmap-points-tp5739121p5740076.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via
Instead of storing x/y, have you considered referencing a region of pixels?
The bigger the region, the larger your possible savings.
Good idea, but I don't always have all points and regions will not be fully
filled
--
View this message in context:
On Wed, Jan 16, 2013 at 03:06:41PM -0800, Charles Porter wrote:
I am trying to migrate from 8.4 to 9.2 on OSX 10.8 (Mountain Lion)
Both 8.4 and 9.2 have been installed with the installers for OSX from
EnterpriseDB
Both have been stopped.
As user postgres, I run the pg_upgrade command
Em 16/01/2013 13:56, Edson Richter escreveu:
Hi!
I'm debugging few triggers I wrote these days, and I can't see the
triggers statements being logged.
Probably I'm doing something wrong.
I just enabled
log_statement = 'all'
In postgresql.conf, but I can see all statements issued by my
Whatever you did to get 1 million points a day on your site.. I want in..
the name of your marketer please!
I agree with condensing this into a heatmap or a set of RRDs.. one for X..
one for Y.. one for x * (y * max_height)). You can easily query RRDs later
on.. even multiple RRD files at once.
On Wednesday, January 16, 2013, Vraj Mohan wrote:
Is there a good sample database (with decent data volumes) for
postgresql? I am interested in one for learning and automated testing.
What do you mean by decent data volumes? Numbers and units are wonderful
things!
What things are you
I am looking for advice on a performance problem. I'm pretty sure that the
culprit of my slow performance is a view that is several hundred million
records in size. Because it is a view, I can only index the underlying table,
but because the view generates an un-pivoted version of the
Hi,
I have a cluster of 3 nodes Primary is connected by StandbyA (streaming),
Standby A is connected by Standby B (streaming).
I failed over the cluster
1) stop primary
2) promoted StandbyA
Now i see from syslog on Standby B that it is complaining about the
timeline mismatch.
Replication Status
33 matches
Mail list logo