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

Dear All, Haveyou 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 data

Re: [HACKERS] lo function changed in PostgreSQL 8.1.1

; CAST (lo as oid) WITH FUNCTION oid(lo) AS IMPLICIT; FUNCTION lo(oid) RETURNS lo AS '$libdir/lo' LANGUAGE C IMMUTABLE STRICT; CAST (oid as lo) WITH FUNCTION lo(oid) AS IMPLICIT; FUNCTION lo_manage() RETURNS trigger AS '$libdir/lo' LANGUAGE C; Tom Lane [EMAIL PROTECTED] 12/14/2005 22:06:33 "Pr

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 I use contrib/lo type for manage lo. What is

[HACKERS] lo function changed in PostgreSQL 8.1.1

Dear All, I use '$libdir/lo' for manage myLarge 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 check

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 dev@archonet.com 12/13/2005 19:22:01 Premsun Choltanwanich wrote

[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 can

[HACKERS] How to secure PostgreSQL Data for distribute?

Dear All, Ineed todistribute my applicationthat use PostgreSQL as databaseto my customer. But I still have some questions in my mindon database security. I understand that everybody who get my application databasewill be have a full control permission on my database in case thatPostgreSQL

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

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 third-party modules that you need on the Linux box

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, /dbsize and /admin. That mean now only

[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

Re: [HACKERS] How can I use large object on PostgreSQL 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 imported to Linux version. The problem I found was shown like

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

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 restore by use files and folders that I already backup. If 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

[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