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 4AA329DC9FC for ; Sat, 18 Mar 2006 21:14:26 -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 61015-08 for ; Sat, 18 Mar 2006 21:14:29 -0400 (AST) Received: from hub.org (hub.org [200.46.204.220]) by postgresql.org (Postfix) with ESMTP id 783199DC85B for ; Sat, 18 Mar 2006 21:14:24 -0400 (AST) Received: from localhost (unknown [200.46.204.144]) by hub.org (Postfix) with ESMTP id 7078762CA1C for ; Sat, 18 Mar 2006 21:14:29 -0400 (AST) Received: from hub.org ([200.46.204.220]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 61873-05 for ; Sat, 18 Mar 2006 21:14:27 -0400 (AST) Received: from ganymede.hub.org (blk-222-82-85.eastlink.ca [24.222.82.85]) by hub.org (Postfix) with ESMTP id 4A11062C7E0 for ; Sat, 18 Mar 2006 21:14:27 -0400 (AST) Received: by ganymede.hub.org (Postfix, from userid 1000) id 2C0A65CD47; Sat, 18 Mar 2006 21:14:31 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 2B28C5C5F0 for ; Sat, 18 Mar 2006 21:14:31 -0400 (AST) X-Return-Path: X-Received: from ganymede.hub.org ([unix socket]) by ganymede.hub.org (Cyrus v2.2.12) with LMTPA; Sat, 18 Mar 2006 02:20:22 -0400 X-Sieve: CMU Sieve 2.2 X-Received: from ganymede.hub.org (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 9F8185CD65 for ; Sat, 18 Mar 2006 02:20:22 -0400 (AST) X-Received: from mail.postgresql.org [200.46.204.71] by ganymede.hub.org with IMAP (fetchmail-6.3.2) for (single-drop); Sat, 18 Mar 2006 02:20:22 -0400 (AST) X-Received: from postgresql.org ([unix socket]) by postgresql.org (Cyrus v2.2.12) with LMTPA; Sat, 18 Mar 2006 02:17:08 -0400 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E16A39DCA10 for ; Sat, 18 Mar 2006 02:17:07 -0400 (AST) X-Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26337-09 for ; Sat, 18 Mar 2006 02:17:07 -0400 (AST) X-Received: from postgresql.org (postgresql.org [200.46.204.71]) by postgresql.org (Postfix) with ESMTP id D7B169DCAC1 for ; Sat, 18 Mar 2006 02:17:05 -0400 (AST) X-Original-To: pgsql-admin-postgresql.org-owner@localhost.postgresql.org X-Delivered-To: pgsql-admin-postgresql.org-owner@localhost.postgresql.org X-Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 94FF09DCA31 for ; Sat, 18 Mar 2006 02:17:05 -0400 (AST) X-Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28516-04 for ; Sat, 18 Mar 2006 02:17:04 -0400 (AST) X-Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 688E59DC87B for ; Sat, 18 Mar 2006 02:17:03 -0400 (AST) X-Received: from smtp-out.fr.clara.net (smtp-out.fr.clara.net [212.43.194.59]) by svr4.postgresql.org (Postfix) with ESMTP id 068715AF841 for ; Sat, 18 Mar 2006 06:17:03 +0000 (GMT) X-Received: from localhost (localhost [127.0.0.1]) by smtp-out.fr.clara.net (Postfix) with ESMTP id E851BB19C3 for ; Sat, 18 Mar 2006 07:16:59 +0100 (CET) X-Received: from isod18 (ras-Chn-static-037.227.95.61.touchtelindia.net [61.95.227.37]) by antivirus-out.fr.clara.net (Postfix) with ESMTP id 23428B1981 for ; Sat, 18 Mar 2006 07:16:56 +0100 (CET) Message-ID: <000801c64a53$8fe86170$1602a8c0@isod18> From: "Babu" To: Subject: Doubt Date: Sat, 18 Mar 2006 11:46:52 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0005_01C64A81.A5FC4D90" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.3790.1830 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 X-Virus-Scanned: by Claranet FR Antivirus X-Virus-Scanned: by amavisd-new at hub.org X-Virus-Scanned: by amavisd-new at hub.org ReSent-Date: Sat, 18 Mar 2006 21:14:27 -0400 (AST) ReSent-From: "Marc G. Fournier" ReSent-To: pgsql-admin@postgresql.org ReSent-Subject: Doubt ReSent-Message-ID: <20060318211427.N1178@ganymede.hub.org> X-Virus-Scanned: by amavisd-new at hub.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.851 required=5 tests=[AWL=1.851, HTML_MESSAGE=0.001] X-Spam-Score: 1.851 X-Spam-Level: * X-Archive-Number: 200603/149 X-Sequence-Number: 20906 This is a multi-part message in MIME format. ------=_NextPart_000_0005_01C64A81.A5FC4D90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi=20 =20 i have create one table and view., but i have not able to = insert,update and delete view., how to solve this. Pls send me on = example. =20 =20 Table :=20 =20 =20 Create Table Test (eno int,ename varchar(10)); =20 View : =20 =20 Create or Replace view TestView as Select * from Test; =20 Regards =20 Babu.B ------=_NextPart_000_0005_01C64A81.A5FC4D90 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi=20
 
         i have = create one=20 table and view., but i have not able to insert,update and delete view., = how to=20 solve this. Pls send me on example.
 
 
 Table : =
 
 
   Create Table Test (eno int,ename=20 varchar(10));
 
 View = :
 
 
  =20 Create or Replace view TestView as Select * from=20 Test;
 
 Regards
 
 Babu.B
------=_NextPart_000_0005_01C64A81.A5FC4D90--