LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 09-02-2010, 02:21 PM   #1
roqarg
LQ Newbie
 
Registered: May 2010
Posts: 14

Rep: Reputation: 0
Angry Can't insert a record in a table on Postgresql database


Hay gays I'm in seriosily problem. my database (PostgreSQL) has ever funtioned OK, but today don't let me insert a new row in a table and the record itsn't duplicated. I did a vacuum full and reindex the database and the problem continue. I don't know what the fuck is happening. Please any sugestion
 
Old 09-02-2010, 02:57 PM   #2
roqarg
LQ Newbie
 
Registered: May 2010
Posts: 14

Original Poster
Rep: Reputation: 0
Help me please!!!
 
Old 09-03-2010, 07:36 AM   #3
roqarg
LQ Newbie
 
Registered: May 2010
Posts: 14

Original Poster
Rep: Reputation: 0
Problem resolved

Hello all, yesterday at night I resolved the problem. Here is the solution for someone that could have the same problem:
I have a method in PL-SQL that receive a group of records from a query and insert those records in a table. If the process don't receive any record it still waiting infinitely and lock the table. For this reason when I trait to INSERT, UPDATE or DELETE something in that table the system don't let me did it, I needed restart PostgreSQL to continue working with the table.
Remember every you implement a method check every possible problem or error that can occurrence.
Thanks for all and God Bless You!!!
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
unable to insert data into the table vinaytp Linux - Newbie 2 04-27-2009 01:44 AM
How do I INSERT IGNORE the current date into a table in MYSQL? resetreset Programming 9 12-15-2008 01:39 AM
LXer: PostgreSQL packs record punch LXer Syndicated Linux News 0 02-04-2008 09:40 PM
PostgreSQL insert command djgerbavore Programming 9 02-01-2005 07:27 PM
postgresql php insert problem BobNz Linux - General 3 05-19-2004 10:46 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 09:29 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration