pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rajesh Kumar Mallah <mallah@trade-india.com>
To: akanksha kulkarni <akanksha_kul@yahoo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: data not getting inserted into table
Date: Mon, 25 Oct 2004 11:27:58 +0530
Message-ID: <417C95E6.8060300@trade-india.com> (raw)
In-Reply-To: <20041021135156.67661.qmail@web52907.mail.yahoo.com>
References: <20041021135156.67661.qmail@web52907.mail.yahoo.com>


Are all the insert operations inside a transaction?
ie do you notice a

begin ; or
begin work;

line in the initial part of the .sql file
then there shud be a commit; line in the
end of the sql file otherwise the transaction
will rollback.


in case you are inserting from a program you
must send commit instruction to the server.
in DBI/perl eg its $dbh -> commit()


regds
mallah.

akanksha kulkarni wrote:

>Hi,
>
>I am trying a simple insert command with select
>statement (Insert into <table> (<column list>) select
><column list> from <table>).
>The data to be inserted is around 1 GB.
>The problem is that at the end of the insert
>operation, data is NOT inserted.
>
>I was monitoring target table file size and it was
>getting increased during the operation. However at the
>end of insert operation, the size has returned to old
>size.
>I changed some parameters in postgres configuration
>file which are as follows: 
>checkpoint_segments=20
>sort_mem = 16384
>checkpoint_timeout=500
>This I did because during earlier operations, I was
>getting message "too many checkpoints. Consider
>increasing checkpoints_segments"
>
>So please can someone tell me why data is not getting
>inserted in table?
>
>Thanks,
>Akanksha Kulkarni
>
>
>
>
>
>
>
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam?  Yahoo! Mail has the best spam protection around 
>http://mail.yahoo.com 
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>  
>


-- 

regds
Mallah.

Rajesh Kumar Mallah
+---------------------------------------------------+
| Tradeindia.com  (3,11,246) Registered Users 	    | 
| Indias' Leading B2B eMarketPlace                  |
| http://www.tradeindia.com/			    |
+---------------------------------------------------+




view thread (3+ messages)

Message-ID: <417C95E6.8060300@trade-india.com>
Permalink:  ../417C95E6.8060300@trade-india.com/
Also on:    postgresql.org/message-id/417C95E6.8060300@trade-india.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: mallah@trade-india.com, akanksha_kul@yahoo.com
  Subject: Re: data not getting inserted into table
  In-Reply-To: <417C95E6.8060300@trade-india.com>
  References: <20041021135156.67661.qmail@web52907.mail.yahoo.com> <417C95E6.8060300@trade-india.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox