[GENERAL] Repercussions of Cancelled Autovacuum

2012-01-15 Thread Andrew Hannon
Hello, We have a large(ish) table that had a series of delete statements executed against it (culling most of the rows in the table). This triggered a time consuming autovacuum, which we allowed to run for 2+ days (and were planning to allow to run to completion). However, it ended up getting c

Re: [GENERAL] How to return latest results without a polygon intersect?

2012-01-15 Thread David Waddy
Thank-you for the help. I defined the problem a little better and took your advice and asked in postgis users: http://www.postgis.org/pipermail/postgis-users/2012-January/032056.html Dave On Wed, Jan 11, 2012 at 11:20 PM, Andy Colson wrote: > On 01/11/2012 07:14 PM, David Waddy wrote: > >> I

Re: [GENERAL] HELP, how to make this query.

2012-01-15 Thread Raghavendra
On Sun, Jan 15, 2012 at 12:17 PM, plasmasoftware net < administra...@plasmasoftware.net> wrote: > *select j.kode_barang kode_barang,j.isi_Satuan from J_master_barang j **order > by j.kode_barang asc* > *display * > kode isi > 01 24 > 01B 12 > 01C

[GENERAL] HELP, how to make this query.

2012-01-15 Thread plasmasoftware net
*select j.kode_barang kode_barang,j.isi_Satuan from J_master_barang j **order by j.kode_barang asc* *display * kode isi 01 24 01B 12 01C 1 i want to make that become when i select my table.how to make this. kode isi_A i

Re: [GENERAL] -devel files

2012-01-15 Thread Adrian Klaver
On Sunday, January 15, 2012 8:17:19 am Graeme Gemmill wrote: > I intend to compile Postgresql 9.1.2 for my particular machine and also > need the -devel files. > I can't see any reference to them in the download libraries. Could sone > kind soul tell me where they are please? Are you downloading t

Re: [GENERAL] how to make select for multiunit

2012-01-15 Thread Misa Simic
Hi, I have understood he does not want to round... I would make custom type myUofM KRT int, PAK int, PCS int Then function to_myUofM which has 1 input parametar as int, and returns myUofM, (imutable func) so SELECT to_myUofM(25) returns 0,2,5 25 PCS is 0 KRT, 2 PAK and 5 PCS Then query: SEL

[GENERAL] -devel files

2012-01-15 Thread Graeme Gemmill
I intend to compile Postgresql 9.1.2 for my particular machine and also need the -devel files. I can't see any reference to them in the download libraries. Could sone kind soul tell me where they are please? Thanks -- Grimble Registered Linux User #450547 Running KDE 4.6.5 on 2.6.39.4-4.2-deskt