On Thu, Nov 22, 2012 at 11:08 AM, Ranjeet Dhumal wrote:
> 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 plans that are
2012/11/21 Greg Sabino Mullane :
>
> -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 a
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 wrote:
> Alban Hertroys writes:
> >> Ranjeet Dhumal wrote:
> > records ,
-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 Sc
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.
On Wed, Nov 21, 2012 at 7:29 AM, Vlad Marchenko 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
connections.
> Also,
On Wed, Nov 21, 2012 at 9:29 AM, Vlad Marchenko 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 noticed
> is w
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
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
previ
Alban Hertroys 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.
Please update
> 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.
--
Se
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;
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
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, N
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;
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 understa
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
h
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 Equiva
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.
--
2012/11/21 Peter Kroon :
> 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
>>
>> On 21/11/2012 11:42, Peter Kroo
So, multiple DECLARE sections are not allowed?
2012/11/21 Raymond O'Donnell
> 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
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
>
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 temp_test_t
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 s
On Wed, Nov 21, 2012 at 1:49 AM, Jasen Betts wrote:
> On 2012-10-17, Vincent Veyron 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
t...@sss.pgh.pa.us (Tom Lane) writes:
> Matthew Vernon 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 suggestion, but I wa
On 2012-10-17, Vincent Veyron 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 PostgreSQL this list
On 2012-10-27, Raul Feliu 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 same problem.
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 t
On 2012-11-02, dinesh kumar 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
--
⚂⚃ 100% natural
-
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)?
>
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):
http://serverfault.com/questions/281783/running-mongodb-with-open
On 2012-11-13, François Beausoleil 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): http://serverfault.com/questions/281783/running-mongodb-with-op
33 matches
Mail list logo
