Hello
you used a wrong syntax
see
http://www.pgsql.cz/index.php/PL/pgSQL_%28en%29#Usage_PL.2FpgSQL_function_with_parametres_of_type_table
Regards
Pavel Stehule
2010/8/28 Jon Griffin :
> I am trying to calculate a value from a current record in a query and can't
> seem to get it working.
>
>
I am trying to calculate a value from a current record in a query and
can't seem to get it working.
Here is the shortened query;
SELECT
s.id,
r.the_date_time,
s.open_price,
s.high_price,
s.low_price,
s.close_price,
thesheet_onepair.symbol,
r.buy_l
On 08/27/10 8:43 AM, A. Kretschmer wrote:
In response to Callum Scott :
Hi All,
I am looking for a way to define where index files should be located.
I am wanting to store the index files on a separate SSD from the database
itself. I can see that there is a way to define this from within the
Early Bird Registration for Surge Scalability Conference 2010 ends next
Tuesday, August 31. We have a killer lineup of speakers and architects
from across the Internet. Listen to experts talk about the newest
methods and technologies for scaling your Web presence.
http://omniti.com/surge/2010/re
are there any documents describe the index mechanic? For example, how to
store the B tree in tables in hard disk?
thanks!
peng
Excerpts from tamanna madaan's message of vie ago 27 05:51:16 -0400 2010:
> I am using a cluster setup with two nodes in it . postgres version is 8.1.2
> and slony 1.1.5 is being used for replication.
> I have autovacuum enabled. But it was giving the following error while
> vacuuming template0
On 27 Aug 2010, at 12:43, Richard Harley wrote:
> That really helped me, thanks - although I wish someone had told me about
> that before I tried to run a nuclear reactor using MSSQL
Gosh, seems like someone picked up on my joke when the world will end - namely
at the release-date of Micros
On Fri, Aug 27, 2010 at 3:21 PM, tamanna madaan <
tamanna.ma...@globallogic.com> wrote:
> Hi All
>
> Any idea about this problem ??
>
> Thanks..
> Tamanna
>
>
> -Original Message-
> From: tamanna madaan
> Sent: Fri 8/20/2010 11:54 AM
> To: pgsql-general@postgresql.org
> Subject: error whi
In response to Callum Scott :
> Hi All,
>
> I am looking for a way to define where index files should be located.
>
> I am wanting to store the index files on a separate SSD from the database
> itself. I can see that there is a way to define this from within the
> database. Is there a way to do
Alright, well, we'll probably do something with the archive command, then,
like either echoing %f to a log file or sending that to syslog (and then,
after the echo, doing the actual cp or scp or rsync or whatever). That way,
we should be able to get some form of timestamp of when each WAL file is
Hi All,
I am looking for a way to define where index files should be located.
I am wanting to store the index files on a separate SSD from the database
itself. I can see that there is a way to define this from within the
database. Is there a way to do this at a system level within the
configura
Hi All
Any idea about this problem ??
Thanks..
Tamanna
-Original Message-
From: tamanna madaan
Sent: Fri 8/20/2010 11:54 AM
To: pgsql-general@postgresql.org
Subject: error while autovacuuming
Hi All
I am using a cluster setup with two nodes in it . postgres version is 8.1.2 and
slon
Hello -
I'm relatively new to the postgresql world - primarily using it to load up a
backup of our hosted Jive community databases (which use postgresql).
To that end, we've created and scheduled a batch file (yes, we're using a
windows server...) to download the backups (*.dmp files) from the
http://www.postgresql.org/docs/8.4/interactive/runtime-config-logging.html#GUC-LOG-STATEMENT
[...]
Valid values are none, ddl, mod, and all.
regards
andreas
On 08/27/2010 03:01 PM, Richard Harley wrote:
Won't log state = all catch everything?
Richard
On 27/08/10 10:39, Mike Christense
Hi,
Apparently scalar subquery when used as a part of SELECT statement and when
it does not depend on outer query columns
is executed only once per statement, e.g.:
postgres=# select i, (select random()) rand from generate_series(1, 3) i;
i | rand
---+---
1 | 0.99231982603
Won't log state = all catch everything?
Richard
On 27/08/10 10:39, Mike Christensen wrote:
Hi all -
I've noticed my log files for Postgres are getting way too big, since
every single SQL statement being run ends up in the log. However,
nothing I change in postgresql.conf seems to make a bit
That really helped me, thanks - although I wish someone had told me
about that/ before/ I tried to run a nuclear reactor using MSSQL
On 27/08/10 07:30, Mike Christensen wrote:
I found this tool pretty helpful for validating my architectural decisions..
http://www.howfuckedismydatabase.com/
Yup, someone emailed me privately - this fixed the problem.. Thanks!
On Fri, Aug 27, 2010 at 2:55 AM, Thomas Kellerer wrote:
> Mike Christensen, 27.08.2010 11:39:
>>
>> Hi all -
>>
>> I've noticed my log files for Postgres are getting way too big, since
>> every single SQL statement being run en
Mike Christensen, 27.08.2010 11:39:
Hi all -
I've noticed my log files for Postgres are getting way too big, since
every single SQL statement being run ends up in the log. However,
nothing I change in postgresql.conf seems to make a bit of
difference.. I've tried restarting postgres, deleting
Hi all -
I've noticed my log files for Postgres are getting way too big, since
every single SQL statement being run ends up in the log. However,
nothing I change in postgresql.conf seems to make a bit of
difference.. I've tried restarting postgres, deleting all the
existing logs, etc. No matter
20 matches
Mail list logo
