On 02/22/2010 12:00 PM, AI Rumman wrote:
Is it possible to change the path of the file:
/tmp/.s.PGSQL.5432
I am using postgresql 8.1 and / has no space.
Somebody already answered your question. But I suggest you inspect /var/log
Logfiles can take large amounts of space if not rotated regularly
On Mon, 2010-02-22 at 12:30 +0600, AI Rumman wrote:
> Is it possible to change the path of the file:
> /tmp/.s.PGSQL.5432
see unix_socket_directory parameter.
> I am using postgresql 8.1 and / has no space.
If it is full even for a socket file, you may have more important issues
than a single s
Is it possible to change the path of the file:
/tmp/.s.PGSQL.5432
I am using postgresql 8.1 and / has no space.
Hello
2010/2/22 Yan Cheng Cheok :
> The following code snippet are picked from PostgreSQL documentation :
> http://www.postgresql.org/docs/current/static/plpgsql-declarations.html
>
> CREATE FUNCTION extended_sales(p_itemno int) RETURNS TABLE(quantity int,
> total numeric) AS $$
> BEGIN
> RETU
On Sun, Feb 21, 2010 at 9:22 PM, Tom Lane wrote:
> Merlin Moncure writes:
>> On Sat, Feb 20, 2010 at 9:38 PM, Petr Chmelar wrote:
>>> Is there a way how to listen and trigger the notify messages in the
>>> database (+-)immediately and/or to execute additional (trigger) queries
>>> in other trans
The following code snippet are picked from PostgreSQL documentation :
http://www.postgresql.org/docs/current/static/plpgsql-declarations.html
CREATE FUNCTION extended_sales(p_itemno int) RETURNS TABLE(quantity int, total
numeric) AS $$
BEGIN
RETURN QUERY SELECT quantity, quantity * price FROM
Merlin Moncure writes:
> On Sat, Feb 20, 2010 at 9:38 PM, Petr Chmelar wrote:
>> Is there a way how to listen and trigger the notify messages in the
>> database (+-)immediately and/or to execute additional (trigger) queries
>> in other transactions?
> The only way that I know of to send notify '
On Sat, Feb 20, 2010 at 9:38 PM, Petr Chmelar wrote:
> Hi there,
>
> I'd like to make a real-time enabled database and I need to process data
> asynchronously. Usually, there are many quick inserts sometimes causing
> vast updates. I can't use triggers and rules because the transactions
> are real
On Sunday 21 February 2010 10:38:18 am Dennis Gearon wrote:
> Version 8.4 on Ubuntu Linux (is this still supported?)
It is the most current stable version, so yes it is supported.
>
> I'm getting an error upon inserting a copy version of a database dump. It's
> very simple, 4 tables,
>
> TableA
Version 8.4 on Ubuntu Linux (is this still supported?)
I'm getting an error upon inserting a copy version of a database dump. It's
very simple, 4 tables,
TableA 2 records (basically a lookup table)
TableB 15 records
TableC 46 records ( many side of 'one to many')
TableD 55 records.( one side of
Hi,
Thanks for the reply.
I have done it in this way:
[code]
FOR vDISTRITOS_NA_TABELA IN
SELECT array[id_distrito] FROM am_newsletter_distritos
WHERE email = pEMAIL and id_website_recolha = pID_WEBSITE_RECOLHA
LOOP
vDISTRITOS_NA_TABELA_CONST := vDISTRITOS_NA_TABELA_CONST ||
Andre Lopes wrote:
> One more time, thanks for the reply. I'am using postgre 8.3. I think I don't
> have the array_agg(), there is another way of doing it?
Sure.
The doc contains an example for a user-defined aggregate-function:
http://www.postgresql.org/docs/8.4/interactive/xaggr.html
It work
One more time, thanks for the reply. I'am using postgre 8.3. I think I don't
have the array_agg(), there is another way of doing it?
Best Regards,
On Sun, Feb 21, 2010 at 2:46 PM, Andreas Kretschmer <
akretsch...@spamfence.net> wrote:
> Andre Lopes wrote:
>
> > Hi,
> >
> > Thanks for the repl
Andre Lopes wrote:
> Hi,
>
> Thanks for the reply.
>
> My problem is that I can't have the array with all items. I need to read from
> a
> table and store in an Array the values.
Not sure if i understand you, but how about:
test=*# select * from foo;
a
---
1
3
5
7
(4 Zeilen)
Zeit: 0,
I don't think pgpool can be compiled on Windows without heavy
modifications.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
> I tried compiling on windows. I didnt get success in that.
>
> I tried gcc 2 ways.
> 1) gcc -o pool_st
Hi,
Thanks for the reply.
My problem is that I can't have the array with all items. I need to read
from a table and store in an Array the values.
I have this:
[code]
CREATE OR REPLACE FUNCTION "public"."apr_update_newsletter_distritos"
("pEMAIL" varchar, "pID_WEBSITE_RECOLHA" varchar) RETURNS v
Andre Lopes wrote:
> Hi,
>
> I have googled, but I can't find how to count the number of items in an Array
> in Plpgsql.
>
> Someone can give me a clue on that?
Sure, you can use array_upper() - array_lower():
Zeit: 0,205 ms
test=*# select array_upper(array[1,2,3],1) - array_lower(array[1,2
17 matches
Mail list logo
