[HACKERS] How to use VB6 for store image to postgresql?

Dear All,   Have you ever store image to postgresql using VB6? Could you give me an example?   Thank you,   Premsun NETsolutions Asia Limited +66 (2) 237 7247

[HACKERS] Slow Query problem

Dear All, I am currently using PostgreSQL database version 8.0.13.  My problem relates to a slow result when a query using a defined view joins to another table for a result. Background:  I have 7 tables of invoice transactions.  The tables are slightly different in that they record different dat

Re: [HACKERS] lo function changed in PostgreSQL 8.1.1

nage() RETURNS trigger AS '$libdir/lo' LANGUAGE C;>>> Tom Lane <[EMAIL PROTECTED]> 12/14/2005 22:06:33 >>>"Premsun Choltanwanich" <[EMAIL PROTECTED]> writes:> I think I use contrib/lo type  for manage lo. What is wrong?You need to use the 8.1 vers

Re: [HACKERS] lo function changed in PostgreSQL 8.1.1

Thank you Tom. I will test it and reply the result as information for other. But it may a week for that cause many work in end of year.>>> Tom Lane <[EMAIL PROTECTED]> 12/14/2005 22:06:33 >>>"Premsun Choltanwanich" <[EMAIL PROTECTED]> writes:> I think

Re: [HACKERS] lo function changed in PostgreSQL 8.1.1

Dear Richard,   I think I use contrib/lo type  for manage lo. What is wrong?   Now I have no idea for manage lo on PostgreSQL 8.1.1, I think I need a time to learn.   Could you give me suggestion?   Regards,   Premsun   >>> Richard Huxton 12/13/2005 19:22:01 >>>Premsun C

[HACKERS] lo function changed in PostgreSQL 8.1.1

Dear All,   I use '$libdir/lo' for manage my Large Object for PostgreSQL 8.0.4 . Now I try to up my PostgreSQL to new version as 8.1.1 but I think I got some error about lo (Large Object).   lo (Large Object) function that normally shown in function list now disappear.  I'm sure that I already ch

[HACKERS] How to delete Large Object from Database?

Dear All,   I use '$libdir/lo' for manage my PostgreSQL Large Object. It work fine for me to get and put Large Object  from and to database. However I found something that may not correct when I try to backup my data. It seem that I cannot delete Large Object from database. It seem the thing I ca

[HACKERS] How to secure PostgreSQL Data for distribute?

Dear All,   I need to distribute my application that use PostgreSQL as database to my customer. But I still have some questions in my mind on database security. I understand that everybody  who get my application database will be have a full control permission on my database in case that Pos

Re: [HACKERS] How can I use large object on PostgreSQL Linux

I don't sure. However It maybe possibled cause I use PostgreSQL 8 RC1 with pgAdmin.>>> Michael Fuhr <[EMAIL PROTECTED]> 09-Feb-05 11:22 AM >>> On Tue, Feb 08, 2005 at 02:55:01PM +0700, Premsun Choltanwanich wrote:> From my first information, I got 3 errors /lo, /d

Re: [HACKERS] How can I use large object on PostgreSQL Linux

more information about /admin (in Windows is admin.dll) please tell me.     >>> Michael Fuhr <[EMAIL PROTECTED]> 08-Feb-05 11:07:10 AM >>> On Mon, Feb 07, 2005 at 02:33:24PM +0700, Premsun Choltanwanich wrote:> > I'd guess that you haven't installed some thi

Re: [HACKERS] How can I use large object on PostgreSQL Linux

(SuSE Linux) gmake On SuSE 9.0 (follow the instruction.)   >>> Michael Fuhr <[EMAIL PROTECTED]> 07-Feb-05 1:56:23 PM >>> On Mon, Feb 07, 2005 at 11:40:41AM +0700, Premsun Choltanwanich wrote:>  > I found that at least Large Object that now failed and no data can be&g

[HACKERS] How can I use large object on PostgreSQL Linux Version?

For first information, I already have Large Object that work fine on PostgreSQL Windows Version. Now I plan to migrate all of Windows version to Linux version. But I got some problem that make it cannot work fine like on Windows version.   I found that at least Large Object that now failed and n

Re: [HACKERS] How can I recovery old Data from files and

2/2004 10:18:19 pm >>> Premsun Choltanwanich wrote: >I got some problem on PostgreSQL 8 for windows so I uninstall and >reinstall it again. Before I uninstall PostgreSQL 8 I already backup all >files and folders (copy all to other place). > >The problem is how can I

[HACKERS] How can I recovery old Data from files and folders on windows?

I got some problem on PostgreSQL 8 for windows so I uninstall and reinstall it again. Before I uninstall PostgreSQL 8 I already backup all files and folders (copy all to other place). The problem is how can I restore by use files and folders that I already backup. If I try to restore by put all of

[HACKERS] How to make lo_import and lo_export to use file on client local machine?

I try to use lo_import and lo_export for manage large object on PostgreSQL. I found that all files must be process on server with these commands. Could I make lo_import and lo_export to use file on client local machine? And How? Or Is it has other ways to manage large object that process is betwe