PostgreSQL Database Forum

Hi all This is my Query select m1.msgid as readstatus,Message.msgid,msgrecdate as sentdate,msgsubject as subject,message, userdetails.name as sender from message inner join userdetails on userdetails.id = Message.msgfromusrid left outer join (select distinct messagelog.msgid from messagelog inner join message on

Hi people. I'm connecting to a PostreSql database trough ADO. Sometimes I issue the command to begin a transaction, and it works perfectly. But, i want to rollback a transaction, looking for it in a table. For example, in SQL Server i used to issue "select @@trancount", but how can i get all active transactions in Postgres. Thanks.

I wrote C-program for connecting to postgresSQL server and get the data from the database. The program is as fallows:- #include <stdio.h> #include <stdlib.h> #include "libpq-fe.h" /* libpq header file */ int main() {

Hi, Postgresql/PostGIS Guru I am new for both Postgresql/PostGIS and need help for converting point () to latitude and longitude degrees using some kind of PostGIS functions. I have a ship's point position in my postsql table as: ship-name POINT(-43.18375956 -0.87618425) and want to get the position in degrees. An example will be greatly...

Hi all, I want to import data from an xml file into postgresql database. Can I do that? Please help me how to do that?

I want to get a query executed everyday at a perticular time. What is the way of doing it??

hi all, anybody knows how to get datamodel for a database in postgresql..... please help me immediately..... Thanks in advance..... priyan.....

Hi all, I am having a table, in that a column called code contains a character varying datatype and has subject code in it..... subject code will be in the form 001 001.01 001.02 02345.01 002.01 001.01.01

hi all, i am trying to backup and restore Postgre database. At server i can do them perfectly but i couldn't find how can i do this from client? the system is as below i am using postgresql 8.2 at windows xp sp2, i am installing postgres only to the server computer. i am only installing .dll files to connect to server to the clients.Connecting...

CREATE OR REPLACE FUNCTION efi_etl.AAA(in SYSID varchar, in periods varchar) RETURNS VOID AS ' DECLARE walker integer; startPeriod integer; endPeriod integer; tmpStr varchar; periodStr varchar; periodLabel varchar; BEGIN periodStr = periods; if (periodStr != '''') AND (substr(periodStr, 1, 1) != ''0'') then periodStr = ''0;''...

Hello, I got this error message when I tried to get a backup of postgresql DB in a Fedora machine. The command that was used is: pg_dump /var/lib/pgsql/data/warranty_1_9 > /var/www/1.9/dump/test_warranty_1_9.sql The error message is: pg_dump: connection to database "/var/lib/pgsql/data/warranty_1_9" failed: FATAL: password...

Hello everyone, I am really in a great problem. I have been using dbmirror as the replication method for postgresql. But now the requirement is it has to be both way (i.e. from the primary server to the secodary and vice-versa). Dbmirror is one way and if we have to make it two way replication, we have to install in both the primary and secondary...

Hi Experts, I am new to PostgreSQL. I got a task to optimize quries which are executed in my database. My frontend is Java and the middleware is hybernate. The queries are automatically created and executed from the database. 1) How can I check what all quries are getting executed. 2) Is there anything in postgreSQL like SQL profiler...

Hi I am trying to reinstall postgresql on windows.During the installtion it is showing the following error. The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale C. fixing permissions on existing directory C:/Program...

Hi all, I am having a table in which a column should have unicode text....... i dono what datatype to use....so please help me to do so.. Thanks in advance priyan

hi ,all why did not suppert Rollback? postgresql update user_t where user_id=103 set user_name='henry' but can not rollback . why , how to rollabck and do not suppert the delete from user_t where user_id=105 cascade;

hello, ive just started using postgresql cud any1 plz explain wat i need to put in the name, host fields and whcih server i need to connect to

hello, ive just started using postgresql cud any1 plz explain wat i need to put in the name, host and whcih server i need to connect to

Hi all, I need to update field three of first table with field three of second tables for all records that match field one of first table with field one of second table (both are primary key for each table and are same). I need to write an ANSI sql query to do this job. I tried follwing , but it didn't work.

Could anybody tell me with a program, how to replicate database with a master and a slave, using postgresql 8.1.0 and slony. I have surfed thru the net, but i could not gather enough information. I have collected some information which is vague. So please reply me and also give some URL regarding the same.

could anybody tell me what is the difference between pgbench database and an ordinary database?

How can I make postscript reports from postgresql. And I am using Gtk as programming tool

Hello! I have VPS. I asked to VPS controllers change my VPS locale, but they do: update pg_database set encoding = pg_char_to_encoding('en_GB.UTF-8'); As I know pg_char_to_encoding('en_GB.UTF-8')= -1 :( Therefore my DB is damaged...

I've been making a program for inventory system using java with a database using postgresql. My problem is, when I query the 20,000 data from my database at one time is slow or it will took 3-5 seconds to retrieve the data. What is the best way or solution to optimize my query? Any suggestion. Thanks ps. I am just using a single pc for my...

I'm stack with this problem with some time now. Here is my problem. CREATE TABLE category ( catdb_id bigserial NOT NULL, catdb_name character varying, catdb_remarks character varying, CONSTRAINT catdb_id_pk PRIMARY KEY (catdb_id)