PostgreSQL Database Forum

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...

Hi everyone Is there any way to make INSERT statement more general by placing a variable as a parameter for VALUE word? In other words I need to use the following statement instead of the later on. String vval=”xx,yy”; Sql= INSERT INTO “tablename” VALUES (vval); The original statement is: Sql= INSERT INTO “tablename” VALUES (xx,yy);

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?...

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 all, II am facing some problem in connecting the DB from non-local systems. I am using Windows Xp and PostGre SQl 7.3.6. I have made " tcpip_socket" to "true" in the postgresql.conf file. But still it is giving error while connecting from non-local system. In the local system, where the DB is installed; it is successfully connecting...

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

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 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...

We have a PostgreSQL database that contains several linking tables (all they contain is two foreign keys to link 2 other tables together). Is it necessary and/or advisable to specify the two attributes in these tables as a joint primary key? There is some disagreement among our team members and I'd like to get some more opinions. Thanks,...

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...

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

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....

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. ...

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...

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

Hi I run postgreSQL from a remote server like this SSH -X cnguyen_db@okaram.spsu.edu ....enter the password Then I run bluefish& and psql The problem I'm having is that I can't copy and paste my code from bluefish to psql in the Xterm window. When I click middle click, it didn't do anything, when do Ctrl V, it didn't do anything neither....

i have a table of car. In my table there is a column of time which stores traveling time of individual car in "HH:MM:SS" format. I write a query and get time in the same format. i will write my problem below. Can i write a function for this table that whenever i select this column, i must get time in seconds i.e integers. thnx @rtist

I have created a user interface using mozilla programming(XUl and Css) Now i ahve to connect a database with the user interface.. as iama starter i just dont know how to install postgresql and link the userinterface with it.. can anybody please help me in this regard

Hello, I created the following table: CREATE TABLE ttable ( z int4, pos point ) WITH OIDS;

i have time column in my database whose data type is "time" i.e 00:00:00. in python i make a query and get this table as string. I want this time only in seconds i.e. integers. What i have to do???

i have two tables in my database say A and B. Table A has two columns. Id and name. Id is the PK of A is a serial number. Table B has three columns. Id, Path and start position. Data type of pth is int. This path column also has FK constraint with id of table A through a function. i want to write a query so that i can have id of two...

I am apparently not qualified to drive this car. I am running Debian Linux 2.6.8-2-686, PHP4, and PostGreSQL. I have been working on this project for almost 15 years. Recently I converted my trade-secret database from C-ISAM to PGSQL using flat files, and it apparently worked. My master file has only one field as its key - project number - up...

I have a requirement of migration database from postgresql to oracle. Please send me a scripts to migrate database.. It's urgent for me..

hi all, I am new to post gresql,don't mind if its a simple one , I need to collect the values from the flat table and insert it into relational tables,i am just wondering if you guys can help me on how to insert the values onto main tables using the ID's as central key..