On 07/11/2012 07:23 AM, Andy Chambers wrote:
I think I made a poor decision by having our application generate
checkbook numbers on demand using sequences.
Sure did. Sequences are exempt from most transactional rules; that's why
they're fast and lock-free.
I'm surprised to find that the on
On 07/11/2012 06:16 AM, Efraín Déctor wrote:
However, once we installed it on our production server that function
doesnt work, it keeps sending this message:
ERROR: ImportError: cannot import name SSLError
CONTEXT: Traceback (most recent call last):
The strange thing is that our server are the
On Tue, Jul 10, 2012 at 3:56 PM, Filipe Brandão wrote:
> Hi all.
> I needed to have a trigger firing after a commit, but allready realized it's
> not possible.
> As i searched upon a solution i came across the LISTEN / NOTIFY. I haven't
> yet realized exactly what i can do with it, but can i use
Hi all.
I needed to have a trigger firing after a commit, but allready realized it's
not possible.
As i searched upon a solution i came across the LISTEN / NOTIFY. I haven't yet
realized exactly what i can do with it, but can i use it to run a simple python
script located out my DB?
Can't run it
On 07/10/2012 07:30 PM, Jeff Ross wrote:
On 7/10/12 6:21 PM, Adrian Klaver wrote:
On 07/10/2012 01:06 PM, Jeff Ross wrote:
Hi all,
Thanks for any and all ideas!
For your initial attempt everything was done in one session?
All the inserts were done in one session, yes.
I am also confu
On 7/10/12 6:21 PM, Adrian Klaver wrote:
On 07/10/2012 01:06 PM, Jeff Ross wrote:
Hi all,
I have an anomaly on my hands that I'm at a loss to understand.
We recently ran a small survey where participants were required to
answer all the questions. After validation for skipped questions,
mis-ra
On 07/10/2012 05:34 PM, Efraín Déctor wrote:
We tested, the code directly into Python:
from googlemaps import GoogleMaps
gmaps= GoogleMaps()
address = gmaps.latlng_to_address(18.835124317498853,-97.11448417315677)
repr(address)
And on both servers work without a problem. My guess is that somet
We tested, the code directly into Python:
from googlemaps import GoogleMaps
gmaps= GoogleMaps()
address = gmaps.latlng_to_address(18.835124317498853,-97.11448417315677)
repr(address)
And on both servers work without a problem. My guess is that something about
OpenSSL on the production server i
On 07/10/2012 02:59 PM, Efraín Déctor wrote:
Hello.
Strange thing happening:
We rencently installed plpython in one of our test servers and installed
an extension to use the google api
(http://pypi.python.org/pypi/googlemaps) , everything went fine we
tested this function:
CREATE OR REPLACE FUNCT
On 07/10/2012 01:06 PM, Jeff Ross wrote:
Hi all,
I have an anomaly on my hands that I'm at a loss to understand.
We recently ran a small survey where participants were required to
answer all the questions. After validation for skipped questions,
mis-ranking answers that had to be ranked and so
On Tue, Jul 10, 2012 at 6:48 PM, Tom Lane wrote:
> Andy Chambers writes:
> > When testing the failover procedure, we noticed that when the new master
> > comes up, some sequences have moved forward (by between 30 and 40). I
> see
> > there's a "cache" option when creating the sequence but we're
Andy Chambers writes:
> When testing the failover procedure, we noticed that when the new master
> comes up, some sequences have moved forward (by between 30 and 40). I see
> there's a "cache" option when creating the sequence but we're not using
> that.
> Is this to be expected?
Yes. This is
On Mon, Jul 2, 2012 at 3:33 AM, Janne H wrote:
> Hi there.
>
> I'm planning on setting up a master database and multiple hot standby
> slaves using streaming replication.
>
> If I use a large(*) value on
> wal_keep_segments
> do I really need archive_mode = on then?
>
> Any potential problems wit
Hey All,
We used the linked guide to setup streaming replication.
http://wiki.postgresql.org/wiki/Streaming_Replication
When testing the failover procedure, we noticed that when the new master
comes up, some sequences have moved forward (by between 30 and 40). I see
there's a "cache" option whe
Hello.
Strange thing happening:
We rencently installed plpython in one of our test servers and installed an
extension to use the google api (http://pypi.python.org/pypi/googlemaps ) ,
everything went fine we tested this function:
CREATE OR REPLACE FUNCTION google_reverse_geocode(lat numeric, l
Viktor Rosenfeld writes:
> I've noticed that regular expressions which are anchored at the
> beginning of the text but have an optional part at the beginning
> (e.g. '^(ge)?kommen$') are not evaluated correctly if there is an
> index on the column.
I have committed fixes for this. Thanks for the
Hello.
Strange thing happening:
We rencently installed plpython in one of our test servers and installed an
extension to use the google api (http://pypi.python.org/pypi/googlemaps ) ,
everything went fine we tested this function:
CREATE OR REPLACE FUNCTION google_reverse_geocode(lat numeric, l
Hi all,
I have an anomaly on my hands that I'm at a loss to understand.
We recently ran a small survey where participants were required to
answer all the questions. After validation for skipped questions,
mis-ranking answers that had to be ranked and so on, I did all of the
inserts to the su
I'm looking for FOSS PostgreSQL CRUD software, preferably Perl-compatible,
which will enable me to design input forms which can handle input to tables
which reference other tables by foreign key. Most CRUD applications I have seen
so far only deal with direct, form field to table field input bu
I'm using Postgres hash indices on a streaming replica master.
As is documented, hash indices are not logged, so the replica does not have
access to them.
I understand that the current wisdom is "don't use hash indices", but
(unfortunately?) I have benchmarks that
show that our particular applic
20 matches
Mail list logo
