X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4BBC452856 for ; Tue, 7 Jun 2005 03:20:33 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37034-03 for ; Tue, 7 Jun 2005 06:20:24 +0000 (GMT) Received: from delta.hssblr.co.in (delta.hssblr.co.in [203.145.155.2]) by svr1.postgresql.org (Postfix) with ESMTP id 13A5E5283A for ; Tue, 7 Jun 2005 03:20:19 -0300 (ADT) Received: from espion.blr.hss.hns.com (espion.blr.hss.hns.com [10.203.193.21]) by delta.hssblr.co.in (8.11.6/8.11.6) with ESMTP id j576KEE32498 for ; Tue, 7 Jun 2005 11:50:14 +0530 Subject: large object support in PostGres 7.4 To: pgsql-sql X-Mailer: Lotus Notes Release 6.5.1 January 21, 2004 Message-ID: From: Vadivel Subramaniam Date: Tue, 7 Jun 2005 11:50:16 +0530 X-MIMETrack: Serialize by Router on Espion/BLR/HSS(Release 6.5|September 18, 2003) at 06/07/2005 11:51:29 AM MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.093 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/94 X-Sequence-Number: 21695 Hi, We have API's in /usr/local/pgsql/include/libpq-fe.h which support large objects in PostGres extern int lo_open(PGconn *conn, Oid lobjId, int mode); extern int lo_close(PGconn *conn, int fd); extern int lo_read(PGconn *conn, int fd, char *buf, size_t len); extern int lo_write(PGconn *conn, int fd, char *buf, size_t len); extern int lo_lseek(PGconn *conn, int fd, int offset, int whence); extern Oid lo_creat(PGconn *conn, int mode); extern int lo_tell(PGconn *conn, int fd); extern int lo_unlink(PGconn *conn, Oid lobjId); extern Oid lo_import(PGconn *conn, const char *filename); extern int lo_export(PGconn *conn, Oid lobjId, const char *filename); My doubt is, do these API's operate on character data? i.e., My table schema is like this table (name varchar, script varchar). I have to store a large data(in character form) in the script column (upto 3 MB). As of my understanding the above mentioned API's work on the OID field. i.e,. table(name varchar, script oid). Is that correct? Please clarify this if anyone has already used this large object APIs and specify if this has any limitation on the size? thanks, -Vadivel *********************** FSS-Private *********************** "DISCLAIMER: This message is proprietary to Flextronics Software Systems Limited (FSS) and is intended solely for the use of the individual to whom it is addressed. It may contain privileged or confidential information and should not be circulated or used for any purpose other than for what it is intended. If you have received this message in error, please notify the originator immediately. If you are not the intended recipient, you are notified that you are strictly prohibited from using, copying, altering, or disclosing the contents of this message. FSS accepts no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus."