PostgreSQL Database Forum

Hi all, pgdijkstra is a postgresql module to perform shortest queries. i ahve road network and associated nodes data in postgresql. i want to apply this module for shortest path. Can any one tell me how pgdijkstra organizes data.? How spatial data is managed in Postgresql if i have to use this module for shortest path. regards

I have done database work with Borland C++ Builder and Paradox, and with ..NET and SQL Server and Paradox. I am considering a new projects with ..NET in either VB.NET or C# and I want to select between either MySQL or PostgreSql as the database. I want ideas on which database would be the best choice and for which reasons. I have a...

pgdijkstra is a function of postgis. this is used to find shortest path between two nodes on a network. can any one tell if i want to read how to structure the database for pgdijkstra. OR i need simple a node table with start and end node and a road table which has polygons and distance. if some one kindly launch link for documentation. ...

Hi, I have an application written in Java that connects to PostgreSQL 8.1 through JDBC 2. It keeps firing queries to the DB every 2 minutes. After running for a while (by the time it sends some 30k-50k queries) to DB, it stops fetching data from the database. It does not throw any exception reporting the Connection has broken or anything else....

Can I have CA-Visual Objects 2.5 as frotend and the PostgreSQL as Backend? .....!!!! Hari haran

In postgres I have two database say A and B. My Application uses libpq interface to connect to the database. The application is working fine but after some point of time, one of the database(say B) is refusing the connection to my application I,e postgres does not allow my application to connect to database B. But i am manually able to login to...

How can I modify the source code of postgres 8.1 to make it enable to support multimedia (images and voices)? In fact, I have to modify the source code of postgres to support image & audio files (storing then retrieving) even if it can be done without modifing the code but first I should to write the algorithm which do that I hope that was...

hi, i am getting the following error in postgres.can anybody help me? PrivSubCategoryEntity-getSubCategories:sqlorg.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block PrivSubCategoryProcess-getSubCategories: objReturnTUVClasses.tuvhelper.ErrorObject@3f136e...

hi, i ve doubt in postgress. the following error i am getting. PrivSubCategoryEntity-getSubCategories:sqlorg.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block PrivSubCategoryProcess-getSubCategories: objReturnTUVClasses.tuvhelper.ErrorObject@3f136e...

how i can handle exception in postgresql. i have a problem to handle exception in postgres functions please reply ASAP.

dear all, i have a problem to maintain the Transaction Logging Mechanism in postgresql 8.1 so please send reply how i can maintain Rollback Segment, LogFiles, and every day transaction file . is there any facility in postgres because oracle provide archive

Hi, (I'm brand new to Postgres.) I'd like to set up a Postgres db/server on an XP machine, and develop apps in Visual C++ (.NET) that access the database. Should I do this using the Windows ODBC driver? If so, can you point me to web refs/sources that can help with the setup procedure. Will this limit me to SQL commands via ODBC only?...

Hi, I have been tesing a trigger procedure. I'd like to know how i can assgign the return value of the aggregation fuction to a user-defined variable. I have an example below. I'm trying to get st_count to have a retun value of the count(id). However, when i tested, the assignment didn't perform correctly. and the update opeartion didn't...

People, I have an old (php3?) script which does CRUD over a mySQL db. I've upgraded to php5 and PostgreSQL (on Linux), and the script bombs (multiple errors). I'm working through it at the moment, but it's slow going. I have "list display" and "editable" working, but the DB write is not working nor is it posting an error. Are there any...

US Based Internet development company seeking to establish an ongoing relationship with one programming team. You must be able to develop database driven sites from scratch. Experience in as many of the following areas as possible is needed particularly PHP, ASP, Mysql, PostgreSQL & SQL Server. Flash Actionscripting an added plus. * Adobe...

Hii All I need to write include DDL statements in function, as we used to fo in Oracle with EXECUTE IMMEDIATE command. Is there any way we can do this. Regards Sarabjeet

Hi all... i have two tables roads and routes. 1) roads table which have following columns...... id, start_point, end_point, length.................. it looks like this id + start_point + end_point + length 1 + 20 + 30 + 10 2 + 12 + 40 + 25 3 + 35 + ...

Hello, this is my first post, I´m new in C# and i´m developing a capture for a test helth for babies (tamiz), I´m making a capture screen with text box and checkbox. For databinding textbox I don´t have problems with this... DS = new DataSet(); pgDA.Fill(DS,"miCedula"); cone.Close(); tb_folio.DataBindings.Add("text",DS,"miCedula.folio");...

Firstly, I am a complete newbie. I need to make the move from MS Access and am looking at either MySQL or PostgreSQL. However I cannot get postgresql to install. I get the following error message. "failed tocreate process for InitDB. Access is denied." I have searched for and read a lot of information, I have set permissions and created users,...

dear all, i have an array which has some elements. I want to invert the sequence of elements.i.e i want that last number of array should become first number and vice versa. thnx @rtist

Dear all, can any one solve this problem..... i have a table name as course which has following columns cid as serial (PK) course_id as int student as int4 and course table looks like this

Hello, Anybody aware of a multi-threaded test suite for Postgresql? Thanks, Neelam

I have a problem when upgrade to new version Postgres (v8.x.x) on Reh HAT 9.0. i was uninstall old version (Postgres 7.x.x) package with command rpm -e postgresqlxxxxx.rpm but only one package can't to erase : postgresql-libs-7xxxx.rpm bcause there are one package need this lib : perl-DBD-xxxxx. what can i do ? erase this package...

Hi, I'm trying to put together a query that will order entries in a table by the rating values which decay over time. I'm not too well versed in the intricacies of Postgres, or complex queries, but I've cobbled the following together: select * from entries order by ( select sum(-rating_value * exp(ln(0.5)/43200 * ...

hai this archulu, i have a doubt in Mod perl programing with pgsql; plz help to me in my project i am canducting exam to students, in exam result , 1=right anwer, 0=wrong answer. $id=4; $sth1=$dbh->prepare("select SUM(result) from result_master where exam_id = '$id' and result = '1' ") or warn "Erron in prepare statemt ".$dbh->errstr;...