[SQL] PostgreSQL does not support updateable cursors

Dear All,   I got error message 'ERROR: column "ctid" does not exist; Error while executing the query'  when I try to query SELECT on my VIEW as 'rsSystem.Open "SELECT * FROM v_memocatlist ORDER BY memocategory", connSystem, adOpenStatic, adLockOptimistic'.   I found some information o

Re: [SQL] Slow Query problem

o, v_invtransaction_main.mbrsysid, v_invtransaction_main.particular, v_invtransaction_main.transdate, v_invtransaction_main.totamount, v_invtransaction_main.totvat, v_invtransaction_main.totservice, v_invtransaction_main.cr_dr, v_invtransaction_main.transrefno   FROM t_payment_detail   RIGHT JOIN v_invtra

Re: [SQL] Slow Query problem

o, v_invtransaction_main.mbrsysid, v_invtransaction_main.particular, v_invtransaction_main.transdate, v_invtransaction_main.totamount, v_invtransaction_main.totvat, v_invtransaction_main.totservice, v_invtransaction_main.cr_dr, v_invtransaction_main.transrefno   FROM t_payment_detail   RIGHT JOIN v_in

Re: [SQL] Slow Query problem

08 0:20 >>>Andreas Joseph Krogh <[EMAIL PROTECTED]> writes:> On Monday 28 January 2008 08:18:24 Premsun Choltanwanich wrote:>> 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

[SQL] 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

[SQL] lo function changed in PostgreSQL 8.1.1 (ask again)

From contrib/lo I found that it has something  difference between old and new version of PostgreSQL.  And I'm sure that I already tick on Large Object (lo) option when I install.   How can I manage on difference function?       :::New Version::: DOMAIN lo AS pg_catalog.oid;   FUNCTION lo_oid(lo)

Re: [SQL] lo function changed in PostgreSQL 8.1.1

t that why.   What thing I need to do for continue using lo on PostgreSQL 8.1.1   Ragards,   Premsun >>> Tom Lane <[EMAIL PROTECTED]> 12/13/2005 22:39:11 >>>"Premsun Choltanwanich" <[EMAIL PROTECTED]> writes:> lo (Large Object) function that normally show

[SQL] 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

Re: [SQL] How to delete Large Object from Database?

Sorry that I forgot to sent you trigger on my database.   CREATE OR REPLACE FUNCTION lo_manage()  RETURNS "trigger" AS'$libdir/lo', 'lo_manage'  LANGUAGE 'c' VOLATILE;ALTER FUNCTION lo_manage() OWNER TO postgres;   >>> Tom Lane <[EMAIL PROTECT

Re: [SQL] How to delete Large Object from Database?

URNS lo AS'$libdir/lo', 'lo_in'  LANGUAGE 'c' IMMUTABLE STRICT;ALTER FUNCTION lo_in(cstring) OWNER TO postgres;   CREATE OR REPLACE FUNCTION lo_out(lo)  RETURNS cstring AS'$libdir/lo', 'lo_out'  LANGUAGE 'c' IMMUTABLE STRICT;ALTER FUNCTION

Re: [SQL] How to delete Large Object from Database?

The lib I use is call lo_in and lo_out for manage BLOB.   I understand that lo_unlink be related with lo_import and lo_export so I don't think that it work.>>> Richard Huxton 07-Oct-05 14:30:05 pm >>>Premsun Choltanwanich wrote:> > Dear All,>  > I use '$l

[SQL] 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

[SQL] 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: [SQL] How can I use large object on PostgreSQL Linux

I use SuSE only.>>> K(AÖPFERL Robert <[EMAIL PROTECTED]> 07-Feb-05 4:05 PM >>> Are you using Fedora with SELinux or just SELinux? -Original Message-From: Premsun Choltanwanich [mailto:[EMAIL PROTECTED]Sent: Montag, 07. Februar 2005 05:41To: pgsql-sql@postgres

[SQL] 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: [SQL] Image Insert Postgresql DB

this problem if I can create this lo type. >>> Kenneth Gonsalves <[EMAIL PROTECTED]> 23/11/2004 4:29:29 pm >>> On Tuesday 23 November 2004 01:49 pm, Premsun Choltanwanich wrote: > I use VB as develop tool and ADO for connect. My code is show below and > for vPic

Re: [SQL] Image Insert Postgresql DB

rs!MbrPic = vPicMember.Read rs.Update rs.Close In this case, Is I must still escape the octets with \\ that is two backslashes? Could anybody has some suggestion? >>> Kenneth Gonsalves <[EMAIL PROTECTED]> 23/11/2004 2:40:27 pm >>> On Tuesday 23 November 2004 12:48 pm, Prem

Re: [SQL] Image Insert Postgresql DB

I face this same problem when I try to insert image by lo_import to database with my client files. I already change the way to bytea data type but it's not work. The error return like type mismatch when I try to insert it from Binary variable. Why I cannot insert it? If anybody found some solution

[SQL] 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