PostgreSQL Database Forum

I installed postgresql on debian and i want to run it on the terminal.some body can do me that favour

I have a weird problem.....the database iam handling has huge amount of data....when i run my program on the cursor containing the data i run into the following error: 54000 PROGRAM LIMIT EXCEEDED. I understand that in a single transaction there are too many queries being executed.I want to know if i can solve this problem by using nested...

Hi all, I'm wondering if someone could explain how can I run two different versions of Postgres (8.2 and 8.3) on the same server machine, point any websites or resources that discuss such problem. I've googled for more than two hours and could not find anything well explained. Thank you.

Hello there I have been trying to generate a dynamic querystring thats to be executed inside a trigger function and every time I use NEW.* pl/pgsql throws an error saying 'column * does not exist'. CREATE OR REPLACE FUNCTION matrix_test_insert_trigger() RETURNS trigger AS $$ BEGIN

I added the reference to Npgsql.dll and run the application. it gives this run time error Could not load file or assembly 'Mono.Security, Version=2.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT:...

Does anyone of you Experts try to change postgres source code so that it would be available to perform the undelete command (restore deleted rows when no vacumm was called)?

Hey folks! Can anyone tell me how to add data to a table using "copy" with several delimiters? Is it possible? What i mean is: Copy <table_name> from <file_directory> using delimiters <delimiters>; How its done the "<delimiters>" part? I tried several ways but i got out of ideas...

Hi All, I am not sure how to change the date format in PostgreSQL. I have the dates stored in the database as yyyy-mm-dd HH:MM:SS+TimeZone to get the GMT time (Ex: 2008-02-28 14:03:23+05:30). But I want these dates to be shown in the following format: dd/mm/yyyy HH:MM:SS TimeZone (Ex: 28/02/2008 14:03:23 IST)So now while I am trying to fetch...

Hello, I'm currently working on an order management system that uses PHP and PostgreSQL. In my situation, I'd like to be able to use a cursor in order to do pagination. My PHP script checks (by cookie status) if a cursor has or hasn't been set, or has to be changed. If one hasn't been set, or it needs to change the SELECT statement, it...

Hi, I made a blunder mistake..i have deleted some 100 rows from my table in postgres and that is very important in my project..pls give me a solution how to recover those deleted data ..i dont have any dump of that table.... thanks in advance

Hi All, Please guide us, Autobackup available in Postgresql. Thanks & Regards, PandiaRajan A

Hi, I am using c# code to connet with postgres. I have posted bit and pieces of the code NpgsqlCommand command1 = new NpgsqlCommand("INSERT INTO test(col1,col2) VALUES (:val1,:val2)", conn1); // Now add the parameter to the parameter collection of the command specifying its type. command1.Parameters.Add(new...

Hello Guys, Does any of you have a script for creating a sample database witch will include all kinds of objects that postgres suports ? I will be very glad if someone can help me! thx

Hi friends, Can you help me for how to use regular expressions in select query? with an example. Please help me.

plj help me to know how to use stored procedure in postgresql and its advantages.......

Hi guys, I have the following query: (SELECT extract(hour from request_time) || ':00-' || ((extract(hour from request_time))+1) || ':00' AS time, count(*) as hits FROM log_request GROUP BY extract(hour from request_time) ORDER BY extract(hour from request_time)) UNION ALL (SELECT 'Total', count(*)

Hi I have few questions. Pleae give me the answers. 1) In postgreSQL, how to declare and call the cursors in a stored procedural function? Ex: I want to display all the columns in a table in one cursor and also how to see the output. 2) tell me , the analytic functions in oracle connect by prior, sys_connect_by_path are existed in...

How to save bitmap image into postgreSQL this is my id........

Hi, My name is Anoop. I am working in a call center as a trainee system administrator. We are using postgresql as a database of asterisk dialer server in our center . But after every two or three months a problem comes in the database. As connections created to the database doesn't get close immediately with the request as a result of this...

is it possible to export data from a postgresql table to a excel format? tnx a lot!

Hi Where can i get the import and export software for postgreSQL(Full version) and in postgreSQL how can we write procedures and functions? and please tell me , how to import the dump file from oracle into postgreSQL.(including procedures) Thank you

Hi, I have delphi database application through delphi7 database postgresSQL8.1 and zeos6.1.I have two postgreSQL8.1 database server.One is windows server working local network another one is linux remote server.When i make the data entries want update the local and remote server.How it is possible through Zeos component.I am apperciate your...

Hi I have the postgreSQL version 8.3.0-1. When i am trying to install it on Windows XP, it giving the error as Internal account lookup failure: No mapping between account names and security IDs was done I have given the in the service configuration fields as Account name:san Account Domain:I Account password:databaseadministrator

how to prevent users to use the specific databases. i mean i have lots of databases. so i want the particular user use the specified database only. is it possible to have password in the database to lock. thanx

What Are The Features And Data Management Strategies Of Postgresql