Hello,
I found strange PostgreSQL 9.3 behavior:
select now()::timestamp, 'now()'::timestamp;
now | timestamp
+
2014-08-22 08:34:00.883268 | 2014-08-22 08:34:00.883268
Second column is now() in single
On 14/08/22 15:40, Piotr Gasidło wrote:
Hello,
I found strange PostgreSQL 9.3 behavior:
select now()::timestamp, 'now()'::timestamp;
now | timestamp
+
2014-08-22 08:34:00.883268 |
Piotr Gasidło wrote
Hello,
I found strange PostgreSQL 9.3 behavior:
select now()::timestamp, 'now()'::timestamp;
now | timestamp
+
2014-08-22 08:34:00.883268 | 2014-08-22 08:34:00.883268
Second
Hi
2014-08-22 9:05 GMT+02:00 David G Johnston david.g.johns...@gmail.com:
Piotr Gasidło wrote
Hello,
I found strange PostgreSQL 9.3 behavior:
select now()::timestamp, 'now()'::timestamp;
now | timestamp
On 21 August 2014 11:36, Patrick Dung patrick_...@yahoo.com.hk wrote:
2.
now() is dynamic but it scan all the partitioned tables.
Most likely you partitioned on a timestamp without time zone, while now()
returns a timestamp with time zone. The possible time zone difference
causes that the
On 20/08/2014 23:27, Julien Rouhaud wrote:
On Wed, Aug 20, 2014 at 6:46 PM, Thomas Kellerer spam_ea...@gmx.net
mailto:spam_ea...@gmx.net wrote:
Ramesh T schrieb am 20.08.2014 um 17:41:
Hello,
when i ran following query,
postgres=# SELECT *
On 22/08/2014 13:08, Birta Levente wrote:
On 20/08/2014 23:27, Julien Rouhaud wrote:
On Wed, Aug 20, 2014 at 6:46 PM, Thomas Kellerer spam_ea...@gmx.net
mailto:spam_ea...@gmx.net wrote:
Ramesh T schrieb am 20.08.2014 um 17:41:
Hello,
when i ran following
On Thu, Aug 21, 2014 at 9:26 AM, David G Johnston
david.g.johns...@gmail.com wrote:
Soni M wrote
Hi Everyone,
I have this query :
select t.ticket_id ,
tb.transmission_id
from ticket t,
transmission_base tb
where t.latest_transmission_id = tb.transmission_id
and
Hi everyone,
Are 'wal_level = archive' vs 'wal_level = hot_standby' ok to mix? For
example, let's say I had a PostgreSQL database running and creating WAL
logs in the archive level. Then we switch to the hot standby level to
support a hot standby, then go back to the archive level, all while
How to include pg_stat_statements in postgres.conf.powa is need it.
any help..
thanks,
On Wed, Aug 20, 2014 at 11:51 PM, Ramesh T rameshparnandit...@gmail.com
wrote:
yes,
in my postgres.conf pg_stat_statements is not their needs powa is
released 19 aug.
On Wed, Aug 20, 2014 at 10:17
On 22 August 2014 14:26, Soni M diptat...@gmail.com wrote:
Currently we have only latest_transmission_id as FK, described here :
TABLE ticket CONSTRAINT fkcbe86b0c6ddac9e FOREIGN KEY
(latest_transmission_id) REFERENCES transmission_base(transmission_id)
Change the query to include only FK
Hi Tom,
I realize that postgres_fdw on 9.3 doesn’t support default expressions that run
on the foreign server. In my case, I have a unique, auto-incrementing ID column
that the remote server keeps track of in a sequence. The local foreign table
doesn’t have access to this and tries to INSERT
On Fri, Aug 22, 2014 at 6:15 AM, Tommy Duek tad...@gmail.com wrote:
Hi Tom,
I realize that postgres_fdw on 9.3 doesn't support default expressions
that run on the foreign server. In my case, I have a unique,
auto-incrementing ID column that the remote server keeps track of in a
sequence.
Tommy Duek tad...@gmail.com writes:
Im working on a project now that uses the postgres_fdw extensively. Do you
know if this will be fixed in 9.4? I figure its worth checking since 9.4 is
scheduled to be released any day now, before I start rewriting the whole
project.
No, there's no
Hi,
Currently I am doing asynchronous replication from master to slave. Now if
I restart the slave it will fall out of sync with the master. Is there a
correct procedure or set of steps to avoid this? I am looking for best
practices or suggestions. Whenever my slave fell out of sync I would
I have developer with pg 9.3.5, which is reporing something really strange.
He runs importer, which does, in single transaction:
begin;
select * from table where pkey = value limit 1 for update;
update table set ... where pkey = the same_value;
commit;
and two backends running the same
On 08/22/2014 09:29 AM, hubert depesz lubaczewski wrote:
I have developer with pg 9.3.5, which is reporing something really strange.
He runs importer, which does, in single transaction:
begin;
select * from table where pkey = value limit 1 for update;
update table set ... where pkey = the
On Fri, Aug 22, 2014 at 9:29 AM, hubert depesz lubaczewski dep...@gmail.com
wrote:
I have developer with pg 9.3.5, which is reporing something really strange.
He runs importer, which does, in single transaction:
begin;
select * from table where pkey = value limit 1 for update;
update
On Fri, Aug 22, 2014 at 6:45 PM, Adrian Klaver adrian.kla...@aklaver.com
wrote:
So process 66017 and 66014 are blocking each because they are running the
exact same queries. The interesting part is the process with the lower pid
is starting later then the none with the higher pid.
Locking is
On 08/22/2014 10:15 AM, hubert depesz lubaczewski wrote:
On Fri, Aug 22, 2014 at 6:45 PM, Adrian Klaver
adrian.kla...@aklaver.com mailto:adrian.kla...@aklaver.com wrote:
So process 66017 and 66014 are blocking each because they are
running the exact same queries. The interesting part is
On 8/22/2014 9:29 AM, hubert depesz lubaczewski wrote:
select * from table where pkey = value limit 1 for update;
why is there a limit 1 in there?pkey=somevalue should only return a
single row. if it DID return multiple rows, you don't have an ORDER
BY, so the limit 1 would be
Hello,
we are setting up a partitioned table based on tstzrange in PG 9.3,
something like:
create table offer (
during tstzrange not null,
...
constraint virtual check (false) no inherit
);
create table offer_201408 (
check (during @
On Fri, Aug 22, 2014 at 7:29 PM, John R Pierce pie...@hogranch.com wrote:
On 8/22/2014 9:29 AM, hubert depesz lubaczewski wrote:
select * from table where pkey = value limit 1 for update;
why is there a limit 1 in there?pkey=somevalue should only return a
single row. if it DID return
On Fri, Aug 22, 2014 at 7:20 PM, Adrian Klaver adrian.kla...@aklaver.com
wrote:
So why are different processes running the exact same queries coming in on
different ports?
the importer is parallelized, and sometimes two processes handle batches of
data that happen to update the same top level
On 08/22/2014 10:36 AM, hubert depesz lubaczewski wrote:
On Fri, Aug 22, 2014 at 7:20 PM, Adrian Klaver
adrian.kla...@aklaver.com mailto:adrian.kla...@aklaver.com wrote:
So why are different processes running the exact same queries coming
in on different ports?
the importer is
hubert depesz lubaczewski dep...@gmail.com writes:
On Fri, Aug 22, 2014 at 6:45 PM, Adrian Klaver adrian.kla...@aklaver.com
wrote:
So process 66017 and 66014 are blocking each because they are running the
exact same queries. The interesting part is the process with the lower pid
is starting
On Fri, Aug 22, 2014 at 7:43 PM, Adrian Klaver adrian.kla...@aklaver.com
wrote:
Which begs the question, what is different about that machine?
No idea. I can pass all the question you might have, but I'm ~ 6000 miles
away from any machine running this code.
depesz
On Fri, Aug 22, 2014 at 7:49 PM, Tom Lane t...@sss.pgh.pa.us wrote:
You have not shown us the full sequence of events leading up to the
deadlock failure, but I hypothesize that there were yet other transactions
that updated that same row in the very recent past. That might allow
there to be
On 08/22/2014 10:50 AM, hubert depesz lubaczewski wrote:
On Fri, Aug 22, 2014 at 7:43 PM, Adrian Klaver
adrian.kla...@aklaver.com mailto:adrian.kla...@aklaver.com wrote:
Which begs the question, what is different about that machine?
No idea. I can pass all the question you might have, but
On Fri, Aug 22, 2014 at 7:54 PM, Adrian Klaver adrian.kla...@aklaver.com
wrote:
Which in itself might be a clue.
Is all the code/data running on/coming from that machine or is some coming
in remotely?
Where network latency might be an issue?
All locally, but hey - how could network
Joseph Kregloh jkreg...@sproutloud.com writes:
Hi,
Currently I am doing asynchronous replication from master to
slave. Now if I restart the slave it will fall out of sync with the
master. Is there a correct procedure or set of steps to avoid this? I
am looking for best practices or
On 08/22/2014 11:14 AM, hubert depesz lubaczewski wrote:
On Fri, Aug 22, 2014 at 7:54 PM, Adrian Klaver
adrian.kla...@aklaver.com mailto:adrian.kla...@aklaver.com wrote:
Which in itself might be a clue.
Is all the code/data running on/coming from that machine or is some
coming in
On Fri, Aug 22, 2014 at 2:21 PM, Jerry Sievers gsiever...@comcast.net
wrote:
Joseph Kregloh jkreg...@sproutloud.com writes:
Hi,
Currently I am doing asynchronous replication from master to
slave. Now if I restart the slave it will fall out of sync with the
master. Is there a correct
hubert depesz lubaczewski wrote:
I have developer with pg 9.3.5, which is reporing something really strange.
He runs importer, which does, in single transaction:
begin;
select * from table where pkey = value limit 1 for update;
update table set ... where pkey = the same_value;
commit;
On Thu, Aug 21, 2014 at 11:26:39PM +, Andy Lau wrote:
Hi everyone,
Are 'wal_level = archive' vs 'wal_level = hot_standby' ok to mix? For example,
let's say I had a PostgreSQL database running and creating WAL logs in the
archive level. Then we switch to the hot standby level to support a
I'm using the installer
On Tue, Aug 19, 2014 at 3:53 PM, Adrian Klaver adrian.kla...@aklaver.com
wrote:
On 08/19/2014 11:03 AM, Brodie S wrote:
I am trying to install PostgreSQL on my OS X Mavericks Server.
Installing with what?
I am installing the Data directory on a NAS server.
On Fri, Aug 22, 2014 at 3:47 PM, Jerry Sievers jerry.siev...@comcast.net
wrote:
Yes, changing archive_command to '' or something that returns false will
let you queue the WALs until reverting the change.
I am assuming you run a version where the archive_mode setting exists
which will be set
One column in a table has values for the attribute 'stream'. Some queries
return some rows where a stream name (only identified one so far) has an
appended '+'. I cannot update the table to remove that appended character,
and I've not seen this before.
Example:
2220 | STV |
On 08/22/2014 12:31 PM, Brodie S wrote:
I'm using the installer
Well this page:
http://www.postgresql.org/download/macosx/
lists quite a few things that could be construed as installers. Also
given that there is Poker in the path I would not be surprised if you
where talking about:
On Fri, Aug 22, 2014 at 02:46:46PM -0700, Rich Shepard wrote:
One column in a table has values for the attribute 'stream'. Some queries
return some rows where a stream name (only identified one so far) has an
appended '+'. I cannot update the table to remove that appended character,
and
On 14/08/23 6:46, Rich Shepard wrote:
One column in a table has values for the attribute 'stream'. Some queries
return some rows where a stream name (only identified one so far) has an
appended '+'. I cannot update the table to remove that appended character,
and I've not seen this before.
On 08/22/2014 02:46 PM, Rich Shepard wrote:
One column in a table has values for the attribute 'stream'. Some
queries
return some rows where a stream name (only identified one so far) has an
appended '+'. I cannot update the table to remove that appended character,
and I've not seen this
On Sat, 23 Aug 2014, Ian Barwick wrote:
You have a newline character. Try:
select count(*) from benthos where stream = E'StarvationCrk\n';
Ian,
Interesting; that query returned 202 of 204 rows.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On Fri, 22 Aug 2014, Adrian Klaver wrote:
Is this only in psql?
Adrian,
Yes.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 08/22/2014 03:03 PM, Rich Shepard wrote:
On Sat, 23 Aug 2014, Ian Barwick wrote:
You have a newline character. Try:
select count(*) from benthos where stream = E'StarvationCrk\n';
Ian,
Interesting; that query returned 202 of 204 rows.
Yeah, means either whoever inputted the data
Adrian Klaver adrian.kla...@aklaver.com writes:
On 08/22/2014 03:03 PM, Rich Shepard wrote:
On Sat, 23 Aug 2014, Ian Barwick wrote:
You have a newline character. Try:
select count(*) from benthos where stream = E'StarvationCrk\n';
Yeah, means either whoever inputted the data kept hitting
I am using the 9.0.18 version of the installer found
here:http://www.enterprisedb.com/products-services-training/pgdownload#osx
During the installation, everything stays as the default except the path to the
data folder
The databases will be used by poker tracker but they will be
On 08/22/2014 03:47 PM, Brodie S wrote:
I am using the 9.0.18 version of the installer found here:
http://www.enterprisedb.com/products-services-training/pgdownload#osx
During the installation, everything stays as the default except the path
to the data folder
Are you installing as the
On 8/19/2014 11:03 AM, Brodie S wrote:
I am installing the Data directory on a NAS server.
what NAS file sharing protocol? (choices include SMB/CIFS, AFP, NFS,
and probably others).Network file shares are generally NOT
considered 'safe' for relational database storage as many have very
I've been installing as the Postgres user. I've also ensured that the
permission on the data folder is RW for every user
I did a chmod 777 on the data folder
On Fri, Aug 22, 2014 at 5:00 PM, Adrian Klaver adrian.kla...@aklaver.com
wrote:
On 08/22/2014 03:47 PM, Brodie S wrote:
I am using
On 08/22/2014 04:14 PM, Brodie S wrote:
I've been installing as the Postgres user. I've also ensured that the
permission on the data folder is RW for every user
Just for reference have you tried installing without changing the $DATA
directory just to see if it works?
Well that exhausted my
I have installed with the default data directory with success. Sadly,
thats not an option for me
I made this post 4 days ago and sadly, have yet to get a response:
http://forums.enterprisedb.com/posts/list/4000.page
On Fri, Aug 22, 2014 at 5:25 PM, Adrian Klaver adrian.kla...@aklaver.com
On 08/22/2014 04:34 PM, Brodie S wrote:
I have installed with the default data directory with success. Sadly,
thats not an option for me
Hmmm, so the installer is basically working, just not to that directory.
I made this post 4 days ago and sadly, have yet to get a response:
On Fri, Aug 22, 2014 at 9:10 PM, Alban Hertroys haram...@gmail.com wrote:
On 22 August 2014 14:26, Soni M diptat...@gmail.com wrote:
Currently we have only latest_transmission_id as FK, described here :
TABLE ticket CONSTRAINT fkcbe86b0c6ddac9e FOREIGN KEY
(latest_transmission_id)
Soni M wrote
On Fri, Aug 22, 2014 at 9:10 PM, Alban Hertroys lt;
haramrae@
gt; wrote:
On 22 August 2014 14:26, Soni M lt;
diptatapa@
gt; wrote:
Currently we have only latest_transmission_id as FK, described here :
TABLE ticket CONSTRAINT fkcbe86b0c6ddac9e FOREIGN KEY
55 matches
Mail list logo