Re: [SQL] database & table size

2003-06-24 Thread Frankie Lam
tuple is no longer of interest to any transaction. The space it occupies must be reclaimed for reuse by new tuples, to avoid infinite growth of disk space requirements. This is done by running VACUUM. ->8---   Frankie - Original Message - From: Anag

[SQL] Is it possible to select encoding in PLPGSQL function?

2003-03-19 Thread Frankie Lam
Is it possible? Thank you! ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] PL/PGSQL EDITOR

2003-02-13 Thread Frankie Lam
You can try Crimson Editor, a free powerful editor. http://www.crimsoneditor.com/ Regards Frankie "Eduardo" <[EMAIL PROTECTED]> wrote in message news:b2h2b0$uqd$[EMAIL PROTECTED]... > Do exists a PL/PGSQL editor? > > Thanks. > > > --

Re: [SQL] dblink question please

2003-02-13 Thread Frankie Lam
of status table, just don't wanna wait too long.) I wanna say thanks again here, for reading through this long and clumsy text by me. Regards, Frankie "Joe Conway" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > Frankie Lam wrote: > > Now I use only p

[SQL] plpgsql + dblink() question

2003-02-07 Thread Frankie
I have a problem with (plpgsql + dblink) function call to another postgresql database server. The case is when I call a function (from Server 1 at psql prompt) that will call dblink to do some operation on another server(it will take certain time), i.e. Server 2, and meanwhile I just unplug the ne