[SQL] my rules wont execute

2008-10-20 Thread aldy
hai all, please help me, i've made a view named bpbkain CREATE OR REPLACE VIEW gmt.bpbkain AS SELECT bpb.tanggal AS tgl_bukti, n.supplier, bpb.nobukti, n.no_po, n.jenis_kain, n.gramasi, n.warna, n.lebar, n.no_inv, n.harga, n.sat_harga, COALESCE(sum(netto2.netto), 0::double precision)::numeric

Re: [SQL] i can't connect after some periode

2008-07-10 Thread aldy
ration in postgresql which can auto close for connection that idle for some minutes thanks before am Thu, dem 10.07.2008, um 13:57:15 +0700 mailte aldy folgendes: hi all, i have some problems with my postgresql database server : i develop some client-server program using postgre as

[SQL] i can't connect after some periode

2008-07-10 Thread aldy
must restart the server and everything back to normal ( im using Win XP as its OS and postgre 8.2) is there any suggetions for me, please?? Thanks regards, Aldy -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/