[GENERAL] Retrieving Data from table based on Date and Time.

2014-10-31 Thread VENKTESH GUTTEDAR
Hello, I have a table in which i have some few fields, in that few, one field is of date type and second one is of time data type, so now my question is how can i fetch the data with latest date and time, or the last inserted value from the PostgreSQL Table.? -- Regards : Venktesh Guttedar.

Re: [GENERAL] LOADing functions

2014-10-31 Thread Adrian Klaver
On 10/31/2014 03:00 PM, Andrew Becker wrote: Hi - I seem to be unable to reLOAD a shared library within the session that I LOADed it. I am developing a UDF and my debugging changes do not appear to take until I quit psql and restart. The following code sequence demonstrates the issue |kbmod=#

Re: [GENERAL] LOADing functions

2014-10-31 Thread Tom Lane
Andrew Becker writes: > Hi - I seem to be unable to reLOAD a shared library within the session > that I LOADed it. Nope, you can't, there's no such functionality. > Hints as to what is going wrong here? I would certainly expect to be > able to re-load a shared library while debugging my UDF.

[GENERAL] LOADing functions

2014-10-31 Thread Andrew Becker
Hi - I seem to be unable to reLOAD a shared library within the session that I LOADed it. I am developing a UDF and my debugging changes do not appear to take until I quit psql and restart. The following code sequence demonstrates the issue |kbmod=# CREATE OR REPLACE FUNCTION hello(TEXT) RET

Re: [GENERAL] Query planning

2014-10-31 Thread Emanuel Calvo
El 31/10/14 a las 04:46, Jayadevan M escibió: > Hi all, > > I am going through PostgreSQL documentation on how row estimation is > done in PostgreSQL. > http://www.postgresql.org/docs/current/static/row-estimation-examples.html > There is a reference to cardinality (rel_cardinality) there. But tha

Re: [GENERAL] Basic question regarding insert

2014-10-31 Thread John R Pierce
On 10/31/2014 3:24 AM, Anil Menon wrote: I have a very basic question on inserts - I tried to get a good authoritative answer but could not really find one to my satisfaction in the usual places. TLDR : can (after) insert trigger be run in parallel? the trigger is run in the context of the c

Re: [GENERAL] Basic question regarding insert

2014-10-31 Thread Adrian Klaver
On 10/31/2014 03:24 AM, Anil Menon wrote: Hi, I have a very basic question on inserts - I tried to get a good authoritative answer but could not really find one to my satisfaction in the usual places. TLDR : can (after) insert trigger be run in parallel? Assume an OLTP environment were a lots

[GENERAL] Basic question regarding insert

2014-10-31 Thread Anil Menon
Hi, I have a very basic question on inserts - I tried to get a good authoritative answer but could not really find one to my satisfaction in the usual places. TLDR : can (after) insert trigger be run in parallel? Assume an OLTP environment were a lots of inserts are happening to a transaction (T

Re: [GENERAL] PostgreSQL on tablet grade SSD ?

2014-10-31 Thread David Boreham
On 10/31/2014 7:31 AM, Merlin Moncure wrote: Can anyone share any experiences with running PostgreSQL on a tablet ? (Surface Pro 3, ASUS Transformer) The SSD in a modern tablet is considerably faster than a hard drive in a high-end server from the era when PG was originally developed so fr

Re: [GENERAL] PostgreSQL on tablet grade SSD ?

2014-10-31 Thread Merlin Moncure
On Thu, Oct 30, 2014 at 4:30 AM, Karsten Hilbert wrote: > Hi ! > > Can anyone share any experiences with running PostgreSQL on a > tablet ? (Surface Pro 3, ASUS Transformer) > > (or point to things I should read, searching the web didn't > turn up anything that seemed relevant to *tablets*) I c

Re: [GENERAL] Planet Postgres

2014-10-31 Thread Torsten Förtsch
On 31/10/14 09:38, Magnus Hagander wrote: > I think in this particular case, much of the blame can be placed on > "everybody" being at pgconf.eu last week, and struggling under > backlogs. But as Stephen says, the backlog will eventually get worked > through, and the moderation happen. I see. No p

Re: [GENERAL] Planet Postgres

2014-10-31 Thread Magnus Hagander
On Thu, Oct 30, 2014 at 8:31 PM, Stephen Frost wrote: > * Adrian Klaver (adrian.kla...@aklaver.com) wrote: >> On 10/30/2014 12:02 PM, Torsten Förtsch wrote: >> >I don't know if this is the right mailing list for my question but I >> >have already emailed pla...@postgresql.org without any response.

[GENERAL] Query planning

2014-10-31 Thread Jayadevan M
Hi all, I am going through PostgreSQL documentation on how row estimation is done in PostgreSQL. http://www.postgresql.org/docs/current/static/row-estimation-examples.html There is a reference to cardinality (rel_cardinality) there. But that is an estimate of the number of rows in the table, right