From sandhyar@amiindia.co.in Thu Feb 23 08:21:21 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 9EB1A9DC868 for ; Thu, 23 Feb 2006 04:21:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 97456-09 for ; Thu, 23 Feb 2006 04:21:21 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id 85F379DC872 for ; Thu, 23 Feb 2006 04:21:12 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with SMTP id k1N8FOkU025271 for ; Thu, 23 Feb 2006 13:45:28 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 8A13B33266D; Thu, 23 Feb 2006 13:14:02 +0530 (IST) Message-ID: <00ce01c6384e$68e3c540$cd00000a@sandhyar> From: "sandhya" To: "Postgres" Cc: "sandhya" Subject: large object unlinking Date: Thu, 23 Feb 2006 13:24:43 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00CB_01C6387C.821D8270" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:69.62515 C:21 M:1 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.079 required=5 tests=[AWL=0.077, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.079 X-Spam-Level: X-Archive-Number: 200602/270 X-Sequence-Number: 20691 This is a multi-part message in MIME format. ------=_NextPart_000_00CB_01C6387C.821D8270 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi... Is there any possibility to delete /Unlink a group of large objects at = a time? Please tell me .To test my application i have loaded somany files into = database.Now i want to unlink all those objects. Please help me in doing this....... Thanks, Sandhya ------=_NextPart_000_00CB_01C6387C.821D8270 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
hi...
 
Is there any possibility to delete /Unlink  a = group of=20 large objects at a time?
Please tell me .To test my application i have loaded = somany=20 files into database.Now i want to unlink all those objects.
Please help me in doing this.......
 
Thanks,
Sandhya
------=_NextPart_000_00CB_01C6387C.821D8270-- From mike@fuhr.org Thu Feb 23 15:28:49 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 1C6FA9DC809 for ; Thu, 23 Feb 2006 11:28:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 76699-07 for ; Thu, 23 Feb 2006 11:28:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by postgresql.org (Postfix) with ESMTP id BC0B99DC806 for ; Thu, 23 Feb 2006 11:28:46 -0400 (AST) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id k1NFSg1b069463 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Thu, 23 Feb 2006 08:28:45 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.4/8.13.4) with ESMTP id k1NFSgCO036877; Thu, 23 Feb 2006 08:28:42 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.4/8.13.4/Submit) id k1NFSc5a036876; Thu, 23 Feb 2006 08:28:38 -0700 (MST) (envelope-from mfuhr) Date: Thu, 23 Feb 2006 08:28:38 -0700 From: Michael Fuhr To: sandhya Cc: Postgres Subject: Re: large object unlinking Message-ID: <20060223152838.GA36720@winnie.fuhr.org> References: <00ce01c6384e$68e3c540$cd00000a@sandhyar> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <00ce01c6384e$68e3c540$cd00000a@sandhyar> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.122 required=5 tests=[AWL=0.122] X-Spam-Score: 0.122 X-Spam-Level: X-Archive-Number: 200602/274 X-Sequence-Number: 20695 On Thu, Feb 23, 2006 at 01:24:43PM +0530, sandhya wrote: > Is there any possibility to delete /Unlink a group of large objects at a time? > Please tell me .To test my application i have loaded somany files into database. > Now i want to unlink all those objects. You could call lo_unlink() in a query. Example: SELECT lo_unlink(loid) FROM (SELECT DISTINCT loid FROM foo) AS s; See also contrib/vacuumlo, which will automatically remove large objects that aren't referenced anywhere. -- Michael Fuhr From sandhyar@amiindia.co.in Fri Feb 24 06:22:59 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 86D169DC874 for ; Fri, 24 Feb 2006 02:22:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 57739-05 for ; Fri, 24 Feb 2006 02:22:58 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id 55ADD9DC840 for ; Fri, 24 Feb 2006 02:22:48 -0400 (AST) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k1O6HC6f012811; Fri, 24 Feb 2006 11:47:12 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 05117332665; Fri, 24 Feb 2006 11:47:12 +0530 (IST) Message-ID: <013d01c6390b$73cf5970$cd00000a@sandhyar> From: "sandhya" To: "Michael Fuhr" Cc: "Postgres" References: <00ce01c6384e$68e3c540$cd00000a@sandhyar> <20060223152838.GA36720@winnie.fuhr.org> Subject: Re: large object unlinking Date: Fri, 24 Feb 2006 11:57:57 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:21 M:2 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.078 required=5 tests=[AWL=0.077, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.078 X-Spam-Level: X-Archive-Number: 200602/306 X-Sequence-Number: 20727 Thank You Fuhr. In select lo_unlink(objid) from (select distinct objid from filetbl)AS s; the above query what is that 'S' stands for in AS 'S' Can u pls explain me..... ----- Original Message ----- From: "Michael Fuhr" To: "sandhya" Cc: "Postgres" Sent: Thursday, February 23, 2006 8:58 PM Subject: Re: [ADMIN] large object unlinking > On Thu, Feb 23, 2006 at 01:24:43PM +0530, sandhya wrote: > > Is there any possibility to delete /Unlink a group of large objects at a time? > > Please tell me .To test my application i have loaded somany files into database. > > Now i want to unlink all those objects. > > You could call lo_unlink() in a query. Example: > > SELECT lo_unlink(loid) FROM (SELECT DISTINCT loid FROM foo) AS s; > > See also contrib/vacuumlo, which will automatically remove large > objects that aren't referenced anywhere. > > -- > Michael Fuhr > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > From mike@fuhr.org Fri Feb 24 07:14:42 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 6F3709DC840 for ; Fri, 24 Feb 2006 03:14:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66970-03 for ; Fri, 24 Feb 2006 03:14:39 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by postgresql.org (Postfix) with ESMTP id 76D5B9DC83C for ; Fri, 24 Feb 2006 03:14:37 -0400 (AST) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id k1O7ETou070244 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Fri, 24 Feb 2006 00:14:31 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.4/8.13.4) with ESMTP id k1O7ESxu005174; Fri, 24 Feb 2006 00:14:28 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.4/8.13.4/Submit) id k1O7ESQQ005137; Fri, 24 Feb 2006 00:14:28 -0700 (MST) (envelope-from mfuhr) Date: Fri, 24 Feb 2006 00:14:28 -0700 From: Michael Fuhr To: sandhya Cc: Postgres Subject: Re: large object unlinking Message-ID: <20060224071428.GA78523@winnie.fuhr.org> References: <00ce01c6384e$68e3c540$cd00000a@sandhyar> <20060223152838.GA36720@winnie.fuhr.org> <013d01c6390b$73cf5970$cd00000a@sandhyar> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <013d01c6390b$73cf5970$cd00000a@sandhyar> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.122 required=5 tests=[AWL=0.122] X-Spam-Score: 0.122 X-Spam-Level: X-Archive-Number: 200602/307 X-Sequence-Number: 20728 On Fri, Feb 24, 2006 at 11:57:57AM +0530, sandhya wrote: > In select lo_unlink(objid) from (select distinct objid from filetbl)AS s; > the above query what is that 'S' stands for in AS 'S' "s" is a table alias, which is required for a subquery. The choice of "s" is arbitrary; it can be any valid label. http://www.postgresql.org/docs/8.1/interactive/queries-table-expressions.html#QUERIES-SUBQUERIES -- Michael Fuhr