On Mon, Dec 21, 2015 at 11:51 AM, sri harsha
wrote:
> Hi,
>
>Is it possible to use threads in Postgresql ?? I am using threads in my
> foreign data wrapper and i get the following error when i use the threads .
>
> *ERROR: stack depth limit exceeded*
> *HINT: Increase the configuration para
On Friday, December 12, 2014, Bruce Momjian wrote:
> On Fri, Dec 12, 2014 at 09:18:53AM -0500, Peter Eisentraut wrote:
> > pgsql-hackers are discussing some housekeeping in contrib.
> >
> > Is anyone using the oid2name tool?
> >
> > Otherwise, we might deprecate and eventually remove it.
>
> Uh,
On Tue, Oct 14, 2014 at 3:12 PM, Jonathan Neve wrote:
> Hello Amit,
>
> I tried pg-announce as well, but my message didn't go through…
>
> Jonathan
>
> Le mardi 14 octobre 2014 11:38:02, Amit Langote a écrit :
>
> On Tue, Oct 14, 2014 at 4:58 PM, Jonathan Neve
>> wrote:
>>
>>> Hello,
>>>
>>> I
On Fri, Jun 27, 2014 at 11:53 AM, Ravi Kiran
wrote:
> hi,
>
> I am using the environment Eclipse for the execution of the programs in
> the executor, whenever I give break points to specific program in eclipse ,
> the control goes to main.c and finally the process never comes back to the
> actual
On Fri, Jun 6, 2014 at 4:22 PM, Ravi Kiran wrote:
> Hello, I am Ravikiran, pursuing my third year BITS Pilani, India, I am
> doing my thesis in postgress technology,
>
> The project is about implementing new join algorithms in postgres, Since I
> am new to postgress, could you help me in which pa
On Mon, Apr 7, 2014 at 3:02 PM, Rebecca Clarke wrote:
> Hi all.
>
> I'm a bit stumped. At present I'm finding that queries to my database,
> that normally execute promptly, are taking a long time when they are
> executed first thing in the morning (after the database has been inactive
> for sever
On Wed, Mar 19, 2014 at 7:45 PM, Alvaro Herrera wrote:
> Andy Colson escribió:
>
> > I dunno. I'm new at conspiracy theories :-). I hoped, by some
> > stretch, Oracle was feeling the heat of competition from PG ... and
> > decided to "solve" the problem. See?
>
> If Oracle decided to solve the
Sent from my iPad
> On 10-Jan-2014, at 19:42, "ygnhzeus" wrote:
>
> Thanks for your reply.
> So correlation is not related to the calculation of selectivity right? If I
> force PostgreSQL not to optimize the join order (by setting
> join_collapse_limit and from_collapse_limit to 1) , is the
On Wed, Sep 18, 2013 at 12:11 AM, Igor Neyman wrote:
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Agustin Larreinegabe
> Sent: Tuesday, September 17, 2013 2:06 PM
> To: PostgreSQL mailing lists
> Subject: [GENERAL] Connect postgres to SQLSE
On Fri, Sep 6, 2013 at 12:35 AM, Marc Balmer wrote:
> ACID. Actually Coffee Inside, Drinkable.
>
> Am 05.09.2013 um 20:49 schrieb Steve Crawford
> :
>
>> org)
Something of the lines of evolution?
A small elephant, growing more powerful?
--
Regards,
Atri
l'apprenant
--
Sent via pgsql-gener
Sent from my iPad
On 05-Sep-2013, at 13:28, Alban Hertroys wrote:
> What about "Don't ignore the elephant in the room"?
>
>
> On 5 September 2013 09:24, Atri Sharma wrote:
>> On Thu, Sep 5, 2013 at 12:51 PM, Jean-Paul Argudo
>> wrote:
>> >
On Thu, Sep 5, 2013 at 12:51 PM, Jean-Paul Argudo
wrote:
> Hi,
>
> Le jeudi 05 septembre 2013 à 12:33 +0530, Atri Sharma a écrit :
>> Make an elephant in a space suit, or with lots of equipments. Text:
>> 'Ready for mission critical systems'
>
> Despite I li
Make an elephant in a space suit, or with lots of equipments. Text:
'Ready for mission critical systems'
On Thu, Sep 5, 2013 at 12:30 PM, Heikki Linnakangas
wrote:
> Put a small elephant logo *inside* the mug. With a text: "also for embedded
> systems"
>
> - Heikki
>
>
> --
> Sent via pgsql-gener
On Fri, Jul 26, 2013 at 7:21 AM, devonline wrote:
> Thanks for the in formation. Can you please tell me what would be a scalable
> architecture? (using pg_default) or separate custom tablespaces
Putting too may tables in one tablespace can lead to confusion, to say
the least. Keeping logically s
On Mon, Jul 8, 2013 at 6:39 PM, Robert James wrote:
> I have two relations, where each relation has two fields, one
> indicating a name and one indicating a position. That is, each
> relation defines a sequence.
>
> I need to determine their longest common subsequence. Yes, I can do
> this by fe
On Fri, Jun 28, 2013 at 2:07 PM, hubert depesz lubaczewski
wrote:
> Hi,
> while working on removing bloat from some table, I had to use ltos of
> logic simply because there are no (idnexable) inequality scans for
> ctids.
>
> Is it because just noone thought about adding them, or are there some
>
On Tue, Jun 25, 2013 at 10:46 AM, kathyn wrote:
> Hello,
>
> I am researching about a Data Minning and analisys tool for Postgres (or
> even Mysql).
>
> Do you know any tool for relational data mining?
>
What exactly are your goals here exactly?
If there is a specific goal you are trying to achi
>
>
> "Ms. Gelhausen is quite correct that these are important
> capabilities, finally available with the release of Oracle9i. We
> applaud Oracle's continued efforts to close the gap and stay
> competitive with this, and other open source database features."
>
> Burrrn!
>
Apply ice to a
Sent from my iPad
On 21-May-2013, at 11:24, John R Pierce wrote:
> libpq lets you talk directly to postgres in its native tongue.
>
> ODBC implements a sort of abstraction. IMHO, its like trying to type with
> mittens on.
>
Also,I see no point in working using ODBC with Postgres if you
Sent from my iPad
On 21-May-2013, at 6:15, Dev Kumkar wrote:
> Hello,
>
> My objective is to work with postgres from my linux box using C. Am not sure
> whether psqlODBC or libpq should be used.
> I was playing and used libpq successfully but not sure which route to go and
> whats the diffe
Sent from my iPad
On 21-Apr-2013, at 16:47, Thomas Kellerer wrote:
> Hi,
>
> I recently stumbled upon a really cool feature in DB2: distinct types.
>
> DB2 lets you define your own types (just as Postgres) but with the added
> benefit that you can mark them such that they are _not_ comparab
> Why you just create your track function and a view to call it?
>
> Example:
>
> BEGIN;
>
> CREATE TABLE foo (id SERIAL PRIMARY KEY, data TEXT);
> CREATE TABLE foo_track(tracktime TIMESTAMP DEFAULT now(), foo_row foo);
>
> INSERT INTO foo (data) SELECT 'Some Data'||id FROM generate_series(1,10) AS
>
> So what would you run the SELECT against, another view or table?
No, what I meant was:
SELECT on main table: fires a rule which updates a view V1
Now, essentially, view V1 has the data I was trying to acquire
originally through BEFORE INSERT trigger.
When I need the data, I can query view V
> How about a RULE:
>
> http://www.postgresql.org/docs/9.2/interactive/sql-createrule.html
>
> Rules can be tricky, so I would at least skim through:
>
> http://www.postgresql.org/docs/9.2/interactive/rules.html
Thanks.
It looks like that it is another way to create a view, which is
probably not
On Thu, Apr 18, 2013 at 5:35 PM, Alfonso Afonso wrote:
> Hi Atri
>
> Maybe you could think different and, instead of do a "before select trigger",
> you can:
>
> - create a store procedure with result is a recordset
> - create a view
>
> If you can't... could you please explain us a bit more abou
Hi all,
I need a tool which allows me to do a task before every SELECT on a
table. Specifically,the behavior I would get with a BEFORE SELECT
trigger.
Please advice me on this.
Regards,
Atri
--
Regards,
Atri
l'apprenant
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Sent from my iPad
On 10-Apr-2013, at 17:01, Zahid Quadri wrote:
> hi,,
>
> please suggest if there is any way which i can find which tables need indexes
> in postgresql.
>
>
>
>
If the table under consideration has lots of data,and queries on it are very
slow,you could consider addin
Sent from my iPad
On 07-Apr-2013, at 23:44, Gavin Flower
>
>
> Not to mention that it appears that Postgres runs better on Linux than on
> Microsoft. Linux skills are increasingly in demand, while MIcrosoft's market
> share is dropping (partly as a result of the Metro fiasco).
True that
Hi all,
A couple of folks in my college are doing a review of security
features in various databases present today. Specifically, how these
features measure up against each other.
Can anyone please give me a few pointers on the features we have that
MySQL doesnt?
Thanks,
Atri
--
Regards,
Atr
Sent from my iPad
On 18-Feb-2013, at 23:39, Bruce Momjian wrote:
> On Mon, Feb 18, 2013 at 11:25:44PM +0530, Atri Sharma wrote:
>>>>>> Is there any way to locally synchronise the threads in my code,and
>>>>>> send the requests to the PostgreSQ
Sent from my iPad
On 18-Feb-2013, at 22:58, Bruce Momjian wrote:
> On Mon, Feb 18, 2013 at 10:46:39PM +0530, Atri Sharma wrote:
>>
>>
>> Sent from my iPad
>>
>> On 18-Feb-2013, at 22:38, Bruce Momjian wrote:
>>
>>> On Mon, Feb 18, 2013 at 1
Sent from my iPad
On 18-Feb-2013, at 22:38, Bruce Momjian wrote:
> On Mon, Feb 18, 2013 at 10:33:26PM +0530, Atri Sharma wrote:
>>>> While your threads are executing, your query can't be cancelled --
>>>> only a hard kill will take the database down. If you
Sent from my iPad
On 18-Feb-2013, at 22:27, Bruce Momjian wrote:
> On Mon, Feb 18, 2013 at 09:56:22AM -0600, Merlin Moncure wrote:
>> On Mon, Feb 18, 2013 at 5:10 AM, Seref Arikan
>> wrote:
>>> Greetings,
>>> What would happen if I create multiple threads from within a postgresql
>>> function
Sent from my iPad
On 24-Dec-2012, at 17:15, Georges Racinet wrote:
> On 12/24/2012 12:32 PM, John R Pierce wrote:
>> On 12/24/2012 2:43 AM, Georges Racinet wrote:
>>> Make sure both servers aren't running at the same time
>>
>> why? its perfectly OK to ahve severla postgres servers running at
On Mon, Dec 24, 2012 at 4:13 PM, Georges Racinet wrote:
> On 12/24/2012 08:50 AM, Atri Sharma wrote:
>> I have two 9.2 servers running in different data directories and
>> installation directories. One of them(the main one) has its bin in the
>> path of my system.The other o
Hi all,
I have two 9.2 servers running in different data directories and
installation directories. One of them(the main one) has its bin in the
path of my system.The other one does not, hence, I need to use the
complete path(/usr/local/pgsql/...).
I want to run pgbench on the second server. How s
On Tue, Dec 11, 2012 at 6:37 PM, Rajesh Aldarthi
wrote:
> Dear all,
>
> I'm getting this below error while installing postgre sql. I have tried
> most of versions available online.
>
>
>
>
> When i continue, i'm unable to connect the sever.
>
> Please help
>
> -- **
>
The error message?
Atri
On Fri, Dec 14, 2012 at 9:47 PM, Edson Richter wrote:
> Em 14/12/2012 12:21, Merlin Moncure escreveu:
>
> On Thu, Dec 13, 2012 at 5:52 PM, Edson Richter
>> wrote:
>>
>>> Em 13/12/2012 20:10, Merlin Moncure escreveu:
>>>
>>> On Thu, Dec 13, 2012 at 1:54 PM, Edson Richter <
edsonrich...@hotm
On Thu, Jul 19, 2012 at 2:47 PM, younus wrote:
> Hi,
>
> First :
>ps -ef | grep postgres
> and kill -9 (PID of your query)
>
> Sec :
> select procpid, datname, usename, client_addr, current_query from
> pg_stat_activity where current_query!='';
>
> and
>
> SELECT pg_cancel_backend(procpi
On Fri, Jun 29, 2012 at 7:05 PM, Atri Sharma wrote:
> On Fri, Jun 29, 2012 at 7:01 PM, Merlin Moncure wrote:
>> On Fri, Jun 29, 2012 at 6:57 AM, Atri Sharma wrote:
>>> On Fri, Jun 29, 2012 at 5:12 PM, Albe Laurenz
>>> wrote:
>>>> Atri Sharma wrote:
>
On Fri, Jun 29, 2012 at 7:01 PM, Merlin Moncure wrote:
> On Fri, Jun 29, 2012 at 6:57 AM, Atri Sharma wrote:
>> On Fri, Jun 29, 2012 at 5:12 PM, Albe Laurenz
>> wrote:
>>> Atri Sharma wrote:
>>>> I am running PostgreSQL 9.1 currently and I want to run 9.2bet
On Fri, Jun 29, 2012 at 5:12 PM, Albe Laurenz wrote:
> Atri Sharma wrote:
>> I am running PostgreSQL 9.1 currently and I want to run 9.2beta2
>> simultaneously with it.Is it possible?
>>
>> I downloaded the 9.2beta2 sources,untared them and ran
>> ./config
On Fri, Jun 29, 2012 at 4:21 PM, Atri Sharma wrote:
> On Fri, Jun 29, 2012 at 4:20 PM, raghu ram wrote:
>>> Thanks Raghu.
>>>
>>> BTW,could you solve my other(makefile) issue please?
>>>
>>> Atri
>>>
>>>
>> Sorry about Mak
On Fri, Jun 29, 2012 at 4:20 PM, raghu ram wrote:
>> Thanks Raghu.
>>
>> BTW,could you solve my other(makefile) issue please?
>>
>> Atri
>>
>>
> Sorry about Makefile issue, someone would have better solution on it..
>
> -Raghu Ram
>
>
>
No problem,thanks a lot for your help!
Atri
--
Regards,
On Fri, Jun 29, 2012 at 3:36 PM, raghu ram wrote:
>>
>> Hi John,
>>
>> What values should I be setting in PGDATA and PGPORT?
>>
>
> Below URL provides more information on this:
>
> http://www.postgresql.org/docs/9.1/static/libpq-envars.html
>
> --
>
> Thanks & Regards,
>
> Raghu Ram
>
>
>
Thanks R
On Fri, Jun 29, 2012 at 3:14 PM, Atri Sharma wrote:
> On Fri, Jun 29, 2012 at 2:37 PM, John R Pierce wrote:
>> On 06/29/12 1:43 AM, raghu ram wrote:
>>>
>>>
>>> and then you can build both from scratch and install them independently
>>
>>
>&g
On Fri, Jun 29, 2012 at 2:37 PM, John R Pierce wrote:
> On 06/29/12 1:43 AM, raghu ram wrote:
>>
>>
>> and then you can build both from scratch and install them independently
>
>
>
> in case noone has made this clear, use different --prefix= paths on the
> ./configure line, and when you're running
On Fri, Jun 29, 2012 at 2:02 PM, raghu ram wrote:
>
>
> On Fri, Jun 29, 2012 at 1:47 PM, Atri Sharma wrote:
>>
>> Hi,
>>
>> I am running PostgreSQL 9.1 currently and I want to run 9.2beta2
>> simultaneously with it.Is it possible?
>>
>
> Yes,
Hi,
I am running PostgreSQL 9.1 currently and I want to run 9.2beta2
simultaneously with it.Is it possible?
I downloaded the 9.2beta2 sources,untared them and ran
./configure,make and make install without uninstalling 9.1.
Now,when I am running pg_ctl start,I am getting the following error:
pg
49 matches
Mail list logo