On 25/07/13 08:14, Vincenzo Romano wrote:
2013/7/25 Luca Ferrari :
On Thu, Jul 25, 2013 at 2:57 AM, Some Developer
wrote:
The added advantage of removing load from the app servers so they can
actually deal with serving the app is a bonus.
Uhm...I don't know what application yo
On 25/07/13 07:57, Luca Ferrari wrote:
On Thu, Jul 25, 2013 at 2:57 AM, Some Developer
wrote:
The added advantage of removing load from the app servers so they can
actually deal with serving the app is a bonus.
Uhm...I don't know what application you are developing, but I don'
On 24/07/13 20:33, Jeff Janes wrote:
On Tue, Jul 23, 2013 at 5:29 PM, Some Developer
wrote:
I've done quite a bit of reading on stored procedures recently and the
consensus seems to be that you shouldn't use them unless you really must.
I think that mostly speaks to the method yo
On 24/07/2013 14:58, Merlin Moncure wrote:
On Wed, Jul 24, 2013 at 8:31 AM, Some Developer
wrote:
On 24/07/13 14:21, Gauthier, Dave wrote:
I find stored procedures to be a God-send. The alternative, external
code, is the risky, difficult and often poorer performing approach to the
problems
On 24/07/13 02:56, Andrew Sullivan wrote:
On Tue, Jul 23, 2013 at 06:55:56PM -0600, John Meyer wrote:
are accessing your database at one time? And most importantly, what
are you best at?
That is one of the most important questions, for sure, but there's a
close second that I'd suggest: what a
On 24/07/13 01:55, John Meyer wrote:
Taking an absolutist position either way is pretty blind. What is the
purpose of the procedure? Is it enforcing business rules? Are these
rules that must be enforced against already existing data or are they
more akin to validation of a credit card. How m
I've done quite a bit of reading on stored procedures recently and the
consensus seems to be that you shouldn't use them unless you really must.
I don't understand this argument. If you implement all of your logic in
the application then you need to make a network request to the database
serve
IN (SELECT random_id_sample())
FOR UPDATE
--
Sincerely,
Yngve N. Pettersen
****
Senior Developer Email: yn...@opera.com
Opera Software ASA http://www.opera.com/
Phone: +47 23 69 32 60
improve the predictability of FOR
UPDATE's
interactions with LIMIT/OFFSET, and indeed it's improved the
predictability
of the behavior for you, just not in the direction you'd like :-(
regards, tom lane
--
Sincerely,
Yngve N. Pettersen
**
Hello,
I can not find configuration option to set init_children_process.
Where I can do it?
--
--
--
Publicidad y Servicios http://www.pas-world.com
Directorio http://www.precioventa.com
Tienda http://informatica.precioventa.com/es/
Autoridad certificadora http://ca.precioventa.co
Hello,
In config:
> # - Connection Settings -
>
> #listen_addresses = 'localhost' # what IP address(es) to listen on;
> # comma-separated list of addresses;
> # defaults to 'localhost', '*' = all
>
> [EMAIL PROTECTED] writes:
>> My database has shutdown several times in the last couple days. I have
>> no
>> idea why. I am running centos and I have not rebooted the server or
>> made
>> any configuration changes.
>
> So in particular, you didn't disable memory overcommit?
>
>> LOG: server pr
> <[EMAIL PROTECTED]> writes:
>
>> My database has shutdown several times in the last couple days. I have
>> no
>> idea why. I am running centos and I have not rebooted the server or
>> made
>> any configuration changes. I am running postgres 8.2 and it has been
>> stable since I installed it ab
My database has shutdown several times in the last couple days. I have no
idea why. I am running centos and I have not rebooted the server or made
any configuration changes. I am running postgres 8.2 and it has been
stable since I installed it about 5 months ago. The databases crashes and
so my
> [EMAIL PROTECTED] wrote:
>>> I believe you are wrong. the EXECUTE is being given 11 columns, it
>>> expects 1. I think you need to form your execute query like;
>>>
>>> EXECUTE 'INSERT INTO payment (
>>> id,amount,accepted_date, company_id , date ,
>>> patient_responsible_party_id patient_c
> [EMAIL PROTECTED] wrote:
>> I am trying to loop through some data and then run insert some of the
>> resulting data into a new table. I can create the function but when I
>> run
>> it i get the error:
>>
>> ERROR: query "SELECT 'INSERT INTO payment (
>> id,amount,accepted_date, company_id , d
> On Wednesday 20 December 2006 7:36 pm, [EMAIL PROTECTED] wrote:
>> I am trying to loop through some data and then run insert some of the
>> resulting data into a new table. I can create the function but when I
>> run
>> it i get the error:
>>
>> ERROR: query "SELECT 'INSERT INTO payment (
>> id
I am trying to loop through some data and then run insert some of the
resulting data into a new table. I can create the function but when I run
it i get the error:
ERROR: query "SELECT 'INSERT INTO payment (
id,amount,accepted_date, company_id , date ,
patient_responsible_party_id , patient_c
grant all privileges on database test to auser
As far as I can tell this does nothing. Intuitively this command suggests
that the auser would be able to access and modify the database test in
anyway. It would also suggest that as new tables for the database auser
would automatically have access
Awesome. Thanks tom.
By the way I am still trying to find a yum install for 8.2 for
centos...anyone?
> [EMAIL PROTECTED] writes:
>> Is there a way to set it up so it knows to skip past existing ids?
>
> Usually you do something like
>
> select setval('seq_name', (select max(idcol) from tab
I am migrating a system from hsqldb to postgresql. I have a bunch of
installs of this system live so moving the data is a headache. I was
using identities in hsqldb and now I am using sequences. I was able to
move all my data over however I am having an issue with the sequences. I
default them
Are there any negatives to not specifying the length variable of a
character varying data type?
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Excellent, thanks
> Hi,
>
> On Wed, 2006-12-06 at 23:32 -0800, [EMAIL PROTECTED] wrote:
>> I got installed on my windows box and my debian box. But is there a
>> way
>> to install 8.2 on centos 4 using yum?
>
> I am about to create a yum repo for PGDG RPM sets. Clodoaldo Pinto Neto
> sent me th
I got installed on my windows box and my debian box. But is there a way
to install 8.2 on centos 4 using yum? I am fairly ignorant about yum but
am trying to figure this out.
---(end of broadcast)---
TIP 4: Have you searched our list archives
I got installed on my windows box and my debian box. But is there a way
to install 8.2 on centos 4 using yum? I am fairly ignorant about yum but
am trying to figure this out.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Thanks for the reply.
> [EMAIL PROTECTED] writes:
>> 1)Do I run these old versions on my linux servers and the new version
>> 8.1x
>> for development? If I do this will I have to constantly battle
>> compatibility issues when going from development to the production
>> servers? Will it be a big
I use to use postgres quite a bit but have been working on a project for a
couple years that does not use it. I have finally convinced them to make
the switch after our current database hsqldb couldn't keep up with the
task.
So, for this project I will need postgres working on a debian server
(2.
27 matches
Mail list logo
