Re: data not getting inserted into table - Mailing list pgsql-admin

From Rajesh Kumar Mallah
Subject Re: data not getting inserted into table
Date
Msg-id 417C95E6.8060300@trade-india.com
Whole thread Raw
In response to data not getting inserted into table  (akanksha kulkarni <akanksha_kul@yahoo.com>)
List pgsql-admin
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/                |
+---------------------------------------------------+


pgsql-admin by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: Re: Upgrading to 7.4.5
Next
From: "Vishal Kashyap @ [Sai Hertz And Control Systems]"
Date:
Subject: Re: Upgrading to 7.4.5