[postgresql] Forum Topics

Hello, I am thinking about making one small project with PHP, javascript, becasue I don't have experience in other languages too much. It would be something like addition to a windows program which uses postgre sql database. I see that I can make one feature from that database. For me …

I'm almost done with college and I want to work on a side project that I could use to show case my skills. I'm looking for something that I can combine a bunch of different aspect into one. I know this will be a big project and won't be able …

Hi. I installed postgreSQL-7.4.6, apache2 and PHP-4.3.9 on Fedora Core 2. I wanna access postgreSQL from php, but got such an error: Fatal error: Call to undefined function: pg_connect(). And then I try to reinstall php: ./configure --with-pgsql=[pgsql DIR] make; make install; cp php.ini-dist [php DIR] set extensions directory and …

Hi Thgin i seek is to create a connection (android) to the latest postgresql 9.2 database. Theat is running on a distant server. Can i Do it? Is postgre 9.2 JDBC driver fro andoid out? & little bit distant question. If the prevous is doable. How i an write tet …

Hello, i would like to know what happens at the backend(access to remote database), when someone clicks check availability on a, say an online travels, hotels, flights booking page, and he gets informations like if the rooms or flights are available on so and so dates and things. I would …

I have a Delphi 2010 DLL using AnyDAC (version 6.0.2 (build 2653)) TADTable components. When I SetRange on any table in a PostgreSQL database, I get "Assertion Failure" error. This only happens in the dll - copying the code to a simple exe, I don't get the error. I am …

Hi There; I have a ASPX file and a code-behind cs file. I try to connect to a postgresql, perfom some database issue, and disconnect from it finally. To name a few, I print all records of database to the html file, add some new records. All these operations are …

Hi everyone, Im new to web programming and i need some help, I have something like this: <td><label>User (Login): </label></td> <td><input class="textbox" autofocus="true" type="text" maxLength="7" name="cUser" id="cUser" /></td> </tr><tr></tr> <td><label>First Name: </label></td> <td><input class="textbox" type="text" maxLength="20" name="cFname" id='cFname' value=""/></td> </tr><tr></tr><tr> <td><label>Last Name: </label></td> <td><input class="textbox" type="text" maxLength="30" name="cLName" id="cLName" /></td> …

Hi, I am in urgent need for converting sql procedure to postgre sql procedure.Please help me ASAP. CREATE FUNCTION sp_get_id_des (IN cellid INT, IN mcc VARCHAR(3), IN mnc VARCHAR(3), IN nwtype INT, IN mlac INT , IN mrac INT ) returns SETOF record AS' declare pscnt int ; declare cscnt …

I am developing an sql query to use to grab information from a postgres db. The scenario is as follows: the database I am grabbing information is the backend postgres database of an application (Tableau). My objective is to pull all of the workbooks, views, and datasources (considered objects) that …

Hi everyone, I'm going to start using PostgreSQL, but I'm a newbie, never used it before. I have only "played" a little bit with MySQL. I was wondering if besides de online documentation you would recommend a good book on PostgreSQL 9.1.4? Thank you very much, Ricardo,

I did a page for adding and viewing activities in a project. The table linked with that page has an UNIQUE constraint for the activity code. As a result of which when i add a new activity with existing Activity code, it is not accepted and gives a runtime error …

I need query tool, which has one simple function - to be able to execute different queries not commending out another queries. This is so annoying, how those another software can not have this simple feature, like pgadmn does not have (I guess), dreamcoder does not have, have just tried …

Hello there! I've been trying to import data from csv file to remote postgre database with no luck. Locally i can do it with simple COPY query, but that only works because i'm superuser. \COPY command also works when i run it in psql. So the question is: how can …

I want to output results from a postgresql table into a csv file. I can do this however its also copying over headers and a row count. Im using \o /path then my sql query; Is there a way to get rid of the headers so i just have the …

I'm stumped on a query filter I'm trying to put together. Here's what I need it to do: 1. Run a query that populates a table with order information to be gathered for regular invoices. 2. A user can filter date ranges, location, client and payment status. The options in …

Hello , i am working on a section of a project, that parses Logs from Postgres Database Server. The application is developed in C sharp Framework 4.0. A log is produced and displayed on a DataGridView with the following columns resultCode Statement Starttime Duration XT001 select * from PizzaMade 01-02-2012 …

Hi I am interseted in designing web sites but i dont want to learn 5 different scripting languages. Is it possiable to create a good working web site just by ruby and sql?

Hello friends, I am working an a section of application which needs to Parse CSV Logs generated by PostgreSql server. - The Logs are stored C:\Program Files\PostgreSQL\9.0\data\pg_log - The Server version in 9.0.4 - The application is developed in C Sharp * The basic utility after Parse the Log is …

I'm trying to connect a DB from Postgres with a program in Java. I'm including this code: Class.forName(driver); Connection con = DriverManager.getConnection(connectString, user , password); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM students"); But I'm getting this erros in Statemen and stmt.excuteQuery: With Statement: *incompatible types. Required: …

Hi, We are developing a software in j2ee/jboss appserver. I have designed a login page the source code of which is given below, loginpage.jsp <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>index of third eye</title> <link rel="stylesheet" href="stylepage.css"> <meta http-equiv="Content-Type" content="text/html; …

I have this Code... ifsDAO.java [CODE]package source; import java.sql.*; import java.sql.SQLException; import java.util.*; public class ifsDAO { private Database database; public ifsDAO(Database database) { this.database = database; } public List<ifsBean> list() throws SQLException { Connection connection = null; PreparedStatement statement = null; ResultSet resultSet = null; List<ifsBean> ifs_array = new …

How to connect postgresql database using eclipse in java. i can able to connect with using "localhost" or "127.0.0.1" but I am not able to connect with "IP address" or "host name(system name)" on the same machine(local system). Please do this needful request. Thanks in advance!!!

Hello, I want to reinstall postgreSQL. I uninstaled via control panel and then try to run the installer. I get error meesage that the service name postgresql 8.4 already exists, try diffrernt name. But I don't know how to change the name, it does not give any field to enter …

Dear All, I am currently working on a small project whereby I want to use a SOAP client to insert Customer Values in a database. The connection to database class is working, the only problem is that it seems that the Web Service wont communicate with this class. In the …

Hi everyone. Suppose I have my database in postgresql, with around 100 tables. I would like to know if there is any way to know which table(s) is affected after running a specific query. For example, if I add a new row, that software for example, should be able to …

Hi, I am facing issue while connecting to sqlplus in perl script. Following is my perl script code. It didn't execute properly & it take too much time to run very short sql. #!/usr/bin/perl $sql_return = `sqlplus -s user/password << SQL_END set linesize 80 set pagesize 10 set heading off …

hi i want to use hibernate in java+postgresql but when i run it receive NullPointerException [code]import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; import org.postgresql.Driver; public class FirstExample { public static void main(String[] args) { Session session = null; try{ SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory(); session =sessionFactory.openSession(); Transaction tx = …

Hello , i'm new in web devellopement , u just could make a web page using kompozer called testconnexionpage1.php (this page contain entries to input name, date ... , and i created a database in PostgreSQL , i just know how could i insert my datas into my database from …

Hi guys, I think I need a help. My teacher gave us a activity on Postgres and PHP to query what's inside the database file and code it to PHP to view the results. I have a screenshot on the Database of the Postgre. [URL="http://theoutdatedblogger.com/Email-Newsletters-Template/database.png"]http://theoutdatedblogger.com/Email-Newsletters-Template/database.png[/URL] What I need to do …

A new version (9.0) of [URL="http://www.postgresql.org"]PostgreSQL[/URL] is in beta and ready for public testing. If version 9.0 lives up to its proposed [URL="http://www.postgresql.org/about/featurematrix"]feature list[/URL], then it is serious competition for MySQL. PostgreSQL proponents have long suggested that PostgreSQL has always enjoyed superiority over MySQL. I beg to differ but that …

Ok so i have a little problem which i cant seem to figure out this is what i have: The constructor loads my method that loads a list of employee to show in jTable, but when i place that method in my button it doesn't do anything This is my …

I have run into an interesting problem. I have inherited a database for daemon process that polls and accepts reports from remote embedded systems. Each site that has one of these systems can monitor over a dozen different fuel tanks. (In practice, most monitor 2, 3 or 4 tanks.) When …

I have 3 tables. [CODE]product ----------------------------------------------- product_code | product_header ----------------------------------------------- 12345 | Wilson Pro-staff Grip plus Glove product_attribute --------------------------- product_code | attribute_id --------------------------- 12345 | 1 12345 | 2 product_attribute_types ----------------------------- attribute_id | attribute_name ----------------------------- 1 | Size 2 | Colour[/CODE] This is the output that I would like to …

Ive been working on a web map application with OpenLayers as a client side library, geoserver and Postgresql as database.I am a newbie in OpenLayers and javascript as well.I need to commit the features added on the map into the database.Is there a way i can specify the table in …

Does postgreSQL-IE perform indexing before searching for IMAGE data type? I am developing a CBIR system for social media. i have xml files of about 1 million flickr images. if i get to know of a DBMS supporting indexing on searches my work would become alot easier. kindly help me …

I hope the title made sense. ok ive got a table in a PostgreSQL database that has a few coloumns in it. What im tryting to do is the following: [CODE]<?php $totaltimetodayresult = pg_query($link, "SELECT SUM(acctsessiontime) AS totaltime FROM radacct WHERE acctstarttime LIKE '%".$today."%'"); while($totaltimetodayarray = pgfetch_array($totaltimemonthresult)){ $totaltimetoday = $totaltimetodayarray['acctsessiontime']; …

Hey, I have some background with db creation and have done lot's of work creating and programming with RDBs. I am currently working on a huge website and I am curious about cost/benifits of using a json array vs a relational table. My gut says I should be using a …

Hi all. my code is below: [code] <script type="text/javascript"> function gu_gid() { var ggid = document.getElementById("gid"); if(ggid.value != "" && ggid.value != "select") { $().ready(function() { $("#autocomplete").autocomplete("test.jsp?gid=" + ggid.value, { max: 50, width: 300, matchContains: true, selectFirst: false }); }); } } </script> . . . <form action="#" autocomplete="on"> <div> …

I have follwed the tutorial on [I]JSP database connectivity according to Model View Controller (MVC) Model 2[/I] for login servlet. I use ServletConfig servlet and init- parameters from web.xml according to the tutorial. I am using Netbeans IDE. Bu I receive this exception whan I try to use login form. …

Hi, I have virtual server in EC2 Amazon. Currently I'm using pgadmin to connect to postgres db in my server. Problem : Whenever I execute any queries (e.g DELETE), it will go on endlessly. But If you SSH into the server and check the result, the DELETE query has been …

kindly give vb.net code samples for connecting crystal report and postgresql Also give information about how to add tables to a crystal report from a postgresql database using ODBC or any other method.

Basically, I want to make a windows form application to be able to view and/or manipulate a postgres database. My first question is if using c#/winforms is an okay way to do this? If not, any suggestions? One of my co-workers suggested using drubal to make an interface to do …

i want to create a moblie application that consits of a form which user can fill and it can be submitted to a online postgres sql database it must be for s40 phones i am using netbeans mobility can some one tell me how should i proceed and it possible …

i am creating a midp 2.0 s40 mobile application s40 that will post some data in to a postgres sql server i have created a form with text boxes and selection list can some one please tell me a way how do i post an sql query i have the …

Hi,i am looking for a light relational database server with the ability to recover after a crash.I am not looking for sqlite or any other single file db system.

I am Rishikeshan :) I am 14 years old. :) I am a student. :) I live in Trincomalee, Sri Lanka. Hair : Black. Eyes : Black. I know to program using c (opengl, libcurl, stdlib, tinythreads++), c++ (opengl, libcurl, stdlib, tinythreads++), vb, vbdos, vb.net, sql (postgresql, mysql), apache web …

I have no idea what's wrong, I googled but I couldn't find the answer :/ it's probably really obvious but i'm rather new to PSQL Statement: [CODE] INSERT INTO drop_users VALUES ('John_Bucky','John_Bucky','a83b3735814aa577651a55b7c838a6a0',02-04-2011_02:20:55,'object', DEFAULT,DEFAULT,13,DEFAULT,DEFAULT[/CODE] Thanks for your time! ~Josh

I am working on a application for which i need to connect it to a database. I have chosen postgreSQL. But i cannot connect it to java. Can somebody help. I tried this [url]http://www.faqs.org/docs/ppbook/x20856.htm[/url] but i don't know how to set classpath.I am currently working with windows xp.

I am working on a psycopg2 application for a customer. I first used: SELECT * from table which worked fine with 'cursor.fetchone()'. But due to some technical details between the customer's database and the database on my company's side where I could not depend on the order of the fields, …