On 2012-11-13, François Beausoleil franc...@teksol.info wrote:
Hi!
I've found an old thread on OpenVZ:
(2008): http://archives.postgresql.org/pgsql-performance/2008-03/msg00076.php
And a more recent question that scared me a bit:
(2011):
Am 2012-11-13 14:53, schrieb François Beausoleil:
Hi!
I've found an old thread on OpenVZ:
(2008):
http://archives.postgresql.org/pgsql-performance/2008-03/msg00076.php
And a more recent question that scared me a bit:
(2011):
Le mardi 20 novembre 2012 à 03:54 -0800, Harry a écrit :
Hello All,
I need help to know how to get below things in Postgresql :-
1) No. of active connections?
2) No. of non-responding connections?
3) Queries which are running beyond time(i.e. time which 'll set in database
query)?
5) Dead
On 2012-11-02, dinesh kumar dineshkuma...@gmail.com wrote:
--20cf3071cc56678d5104cd82409f
Content-Type: text/plain; charset=ISO-8859-1
Hi ,
In windows we do not have SCP/RSYNC utility commands, which helps us to
send the archives to remote/slave server.
pscp (putty.org)
deltacopy
--
⚂⚃
I do have a field for which I want to perform a join with some other field
in another table using case without case sensitivity perhaps using ~*.
One of this fields may contain + characters or unbalanced parenthesis. Is
there a way or some function that may mask out the regexp awareness of any
of
On 2012-10-27, Raul Feliu raulfp...@hotmail.com wrote:
--_4c4db745-219d-4817-8789-6e7997227fee_
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
I have windows vista. I tried to run the installer in admin mode and I disa=
bled UAC. Still having the
On 2012-10-17, Vincent Veyron vv.li...@wanadoo.fr wrote:
I am surprised none of the fine contributors to this thread mentionned
an activity they practice extensively, which is reading this list's
content every day.
Best training material ever in my opinion.
Yeah, if you want to learn
t...@sss.pgh.pa.us (Tom Lane) writes:
Matthew Vernon matthew.ver...@sac.ac.uk writes:
naiively, you might try:
\set pwd '\'' `pwd` '\''
COPY table FROM :pwd || '/relative/path/to/data' ;
Umm ... why don't you just use a relative path as-is, with \copy
instead of COPY?
Thanks for the
On Wed, Nov 21, 2012 at 1:49 AM, Jasen Betts ja...@xnet.co.nz wrote:
On 2012-10-17, Vincent Veyron vv.li...@wanadoo.fr wrote:
I am surprised none of the fine contributors to this thread mentionned
an activity they practice extensively, which is reading this list's
content every day.
Hi All ,
When am trying to query a table temp_table1(sms_type varchar(20),sms_info
varchar(100),sms_id integer)
Query :: select sms_type,count(*) from temp_table1 group by 1 order by 2
desc;
Then i got following errors , i dont know whats wrong in this .
*ERROR: volatile EquivalenceClass has no
Hello,
How do I declare a variable after BEGIN?
I want to declare it in the if statement.
DROP FUNCTION IF EXISTS tmp_test(integer);
CREATE FUNCTION tmp_test(
p_id integer
)
RETURNS text
AS $$
DECLARE the_return_value text;
BEGIN
DROP TABLE IF EXISTS temp_test_table;
CREATE TEMP TABLE
On 21/11/2012 11:42, Peter Kroon wrote:
Hello,
How do I declare a variable after BEGIN?
I want to declare it in the if statement.
DROP FUNCTION IF EXISTS tmp_test(integer);
CREATE FUNCTION tmp_test(
p_id integer
)
RETURNS text
AS $$
DECLARE the_return_value text;
BEGIN
DROP TABLE
So, multiple DECLARE sections are not allowed?
2012/11/21 Raymond O'Donnell r...@iol.ie
On 21/11/2012 11:42, Peter Kroon wrote:
Hello,
How do I declare a variable after BEGIN?
I want to declare it in the if statement.
DROP FUNCTION IF EXISTS tmp_test(integer);
CREATE FUNCTION
2012/11/21 Peter Kroon plakr...@gmail.com:
So, multiple DECLARE sections are not allowed?
it is not allowed in plpgsql
resp. DECLARE is related to block - if you use nested block, then you
can use nested DECLAREs
Regards
Pavel Stehule
2012/11/21 Raymond O'Donnell r...@iol.ie
On
On 21/11/2012 12:01, Peter Kroon wrote:
So, multiple DECLARE sections are not allowed?
Actually, I just had a quick look here -
http://www.postgresql.org/docs/9.2/static/plpgsql-structure.html
- and it seems that you can have multiple declare - begin - end blocks.
Try it and see!
Ray.
--
Ranjeet Dhumal wrote:
When am trying to query a table temp_table1(sms_type
varchar(20),sms_info varchar(100),sms_id integer)
Query :: select sms_type,count(*) from temp_table1 group by 1 order
by 2 desc;
Then i got following errors , i dont know whats wrong in this .
ERROR: volatile
Hi Laurenz ,
I got this error on two different tables , first one is empty and second
one has near about 60k records , am using 9.0.1 version of postgres.
And when i dropped that both table and recreated with same data and
structure query ran successfully , am not able to understand how this is
Ranjeet Dhumal wrote:
I got this error on two different tables , first one is empty and
second one has near about 60k
records , am using 9.0.1 version of postgres.
And when i dropped that both table and recreated with same data and
structure query ran successfully
, am not able to understand
How to I output the insert in PostgreSQL?
DROP TABLE IF EXISTS a_001;
CREATE TEMP TABLE a_001(
vl text
);
DROP TABLE IF EXISTS a_002;
CREATE TEMP TABLE a_002(
vl text
);
INSERT INTO a_001
OUTPUT INSERTED.* INTO a_002 --mssql
SELECT 'text for insertion';
SELECT vl FROM a_002;
ILIKE is probably better - without an escape:
WHERE field1 ILIKE field2 ESCAPE ''
You could also try:
WHERE upper(field1) = upper(field2)
David J.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Allan Kamau
Sent: Wednesday,
On Wed, Nov 21, 2012 at 02:41:24PM +0100, Peter Kroon wrote:
How to I output the insert in PostgreSQL?
DROP TABLE IF EXISTS a_001;
CREATE TEMP TABLE a_001(
vl text
);
DROP TABLE IF EXISTS a_002;
CREATE TEMP TABLE a_002(
vl text
);
INSERT INTO a_001
OUTPUT INSERTED.* INTO a_002
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Peter Kroon
Sent: Wednesday, November 21, 2012 8:41 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] output inserted
How to I output the insert in PostgreSQL?
DROP TABLE IF EXISTS a_001;
Ranjeet Dhumal wrote:
records , am using 9.0.1 version of postgres.
This is quite possibly your problem: You're 9 bugfix releases behind
on a .0 release. You should be at 9.0.10 at least.
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.
--
Sent
Alban Hertroys haram...@gmail.com writes:
Ranjeet Dhumal wrote:
records , am using 9.0.1 version of postgres.
This is quite possibly your problem: You're 9 bugfix releases behind
on a .0 release. You should be at 9.0.10 at least.
Yes. I seem to recall fixing a bug with exactly this symptom.
Hi all,
We are currently doing a security assessment over a PostgreSQL database
sitting on a Linux server. Just wondering if anyone has a script and/or
audit program for gathering information and assessing a postgreSQL
database (similar to the oracle sql scripts that have been distributed
update on my problem: despite pgbouncer, the problem still occures on my
end.
Also, interesting observation - I ran several tests with pgbench, using
queries that I think are prone to trigger high-sys-cpu-stall. What I
noticed is when pgbench is started with prepared mode, the system
behaves
On Wed, Nov 21, 2012 at 9:29 AM, Vlad Marchenko marche...@gmail.com wrote:
update on my problem: despite pgbouncer, the problem still occures on my
end.
Also, interesting observation - I ran several tests with pgbench, using
queries that I think are prone to trigger high-sys-cpu-stall. What I
On Wed, Nov 21, 2012 at 7:29 AM, Vlad Marchenko marche...@gmail.com wrote:
update on my problem: despite pgbouncer, the problem still occures on my
end.
As Merlin asked, how big is the pool? Maybe you are using a large
enough pool so as to defeat the purpose of restricting the number of
Hi
Do you have any plans to put the Windows version of Postgresql on
the Windows 8 app store? Also for PGAdmin and database drivers?
Aparantly there are major issues with sideloading in windows 8.
Thanks
H.F.
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Gavin Flower asks:
Would it be appropriate to make it a WARNING in 9.2.2, then
increase the length in 9.3?
No: revisions are reserved for bug fixes. This would be more of
a behavior fix and as such would go into a major version.
Gavan
Hi Tom ,
Sorry but i didn't understand that If this is a bug from postgres version
then how the same query will be worked if i recreated the tables and with
same version of postgres.
On 21 November 2012 19:53, Tom Lane t...@sss.pgh.pa.us wrote:
Alban Hertroys haram...@gmail.com writes:
2012/11/21 Greg Sabino Mullane g...@turnstep.com:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Gavin Flower asks:
Would it be appropriate to make it a WARNING in 9.2.2, then
increase the length in 9.3?
No: revisions are reserved for bug fixes. This would be more of
a behavior fix
On Thu, Nov 22, 2012 at 11:08 AM, Ranjeet Dhumal jeetu.dhu...@gmail.comwrote:
Hi Tom ,
Sorry but i didn't understand that If this is a bug from postgres version
then how the same query will be worked if i recreated the tables and with
same version of postgres.
This could be related to the
33 matches
Mail list logo