Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 343F0182A953 for ; Mon, 6 Aug 2012 06:15:21 -0300 (ADT) Received: from mail-gh0-f174.google.com ([209.85.160.174]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SyJPC-0005Dh-8s for pgsql-admin@postgresql.org; Mon, 06 Aug 2012 09:15:20 +0000 Received: by ghrr11 with SMTP id r11so2250157ghr.19 for ; Mon, 06 Aug 2012 02:15:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:content-type:content-transfer-encoding:subject:message-id:date :to:mime-version:x-mailer; bh=rU+blIJoQAOBWZoIKgE5o1JJ6dkdcmwHgZu4eX4yYx4=; b=thHvQU/gJaJQ3mpenS3yhN6Z+XNQSIpvBbGsQmjWpYxzUUOu1wgU9SMEj7snD5Ejng wfnpNj0wW/o3y0AxuQXr2p2Um9uPRzAt12nfBQUOZ1BgImzajLHo2hZd5iapLxHG5nS5 DAyLYaCIN1FF4ut+6MbB6seUtKECZFBv2uFYbALhGj03vcofnQem2cEuw8Gbpj3UmJ/c gtr+UoF9jTIDPknqiTchSAhDkCkZ8Cmp54+lPK/o2IGj0UgaMtVUTE7IXqioR/OlOZeU 8sM6WiPPwTomdNSSJUYoV4GIl+C4pyfowFXGUhc+04W3mLbASx6jhB5ENf3h2mXy26fH kn3A== Received: by 10.66.74.100 with SMTP id s4mr16616694pav.27.1344244503946; Mon, 06 Aug 2012 02:15:03 -0700 (PDT) Received: from [172.16.224.42] ([61.170.249.130]) by mx.google.com with ESMTPS id or1sm3448277pbb.10.2012.08.06.02.14.57 (version=TLSv1/SSLv3 cipher=OTHER); Mon, 06 Aug 2012 02:15:03 -0700 (PDT) From: haifeng liu Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Subject: How to make the row changes inside trigger function visible to the top level sql statement? Message-Id: <571AFDFA-85FB-4EF4-B811-F7722DE28F10@gmail.com> Date: Mon, 6 Aug 2012 17:14:34 +0800 To: pgsql-admin@postgresql.org Mime-Version: 1.0 (Mac OS X Mail 6.0 \(1485\)) X-Mailer: Apple Mail (2.1485) X-Pg-Spam-Score: -2.5 (--) X-Archive-Number: 201208/51 X-Sequence-Number: 39872 Hello, I am doing table partitioning, all is ok except that after executing 'inser= t' sql statement I can't get affected rows, it always be 0. After searching= on the documents, I found that row changes inside trigger function is not = visible to the top level statement. Partition table using a trigger function to redirect insertion to the corre= ct partition is the recommend way, and test affected rows is also used freq= uently. pgAdmin do test the affected rows too, thus when I type a new row a= nd click save button, it seems failed but actually succeed. How can I make the row changes inside the trigger function visible to the t= op level statement? Thank all in advance! From pgsql-admin-owner@postgresql.org Wed Aug 8 03:13:13 2012 Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 369218820F3 for ; Tue, 7 Aug 2012 08:06:31 -0300 (ADT) Received: from mail-lpp01m010-f46.google.com ([209.85.215.46]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SyhcM-0003OL-9h for pgsql-admin@postgresql.org; Tue, 07 Aug 2012 11:06:30 +0000 Received: by lagy9 with SMTP id y9so1289957lag.19 for ; Tue, 07 Aug 2012 04:06:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=5J92jwEYzXyV3aEpfl125DPwOtIqkwojhRdoLgtf4wQ=; b=gvGLrr+BEfh9MDxnM9I4+hAllvY1T33JdrLY1ODydafBi/519P1CJLNIQVrsRMI7VG DlXjPOxM02i7qFioISJ5muOC9BWmz9XCHH/Y44+o8ffYnyUlCY3s9YTdb3e3RlJNooSv ZfMpT8i6H7PV6TcPLF5Zpduyp20EvARcVjKyQsyhYDQc72+XNfvCbJU9atbvo1dYc9ze SJ71R4l0+wF498S8RLo+Cg3YjVhyoXf/FksTdAr2+2nGtIcGjWGLb+DH01hovHIvo0oB OaLA6YZkTceqyTR8NFFXQn48g8PbBBHe5QCSMQ9+jPUPl08x5sj4AWnhrViwJ5Y/rxI2 SCRw== MIME-Version: 1.0 Received: by 10.152.132.40 with SMTP id or8mr14120981lab.24.1344337576648; Tue, 07 Aug 2012 04:06:16 -0700 (PDT) Received: by 10.112.129.167 with HTTP; Tue, 7 Aug 2012 04:06:16 -0700 (PDT) Date: Tue, 7 Aug 2012 16:36:16 +0530 Message-ID: Subject: Data migration to sql server 2008 From: karthi keyan To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=f46d042c5ed7b6deb404c6aafb13 X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201208/52 X-Sequence-Number: 39873 --f46d042c5ed7b6deb404c6aafb13 Content-Type: text/plain; charset=ISO-8859-1 hello admin, I am using Postgresql for my application development, which is very robust and secure to use. For some interlink application purpose , i need to *migrate data into Sql server 2008*. So please refer me, or give some samples, how i can migrate the data Regards Karthik --f46d042c5ed7b6deb404c6aafb13 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable hello admin,
I am using Postgresql for my application development, which is very= robust and secure to use.

For some interlink application purpose , i need to migr= ate data into Sql server 2008.
So please refer me, or give = some samples, how i can migrate the data

Regards
Karthik

--f46d042c5ed7b6deb404c6aafb13--