PostgreSQL Database Forum

Say I have a table: name game score Steve Chess 50 Steve Soccer 48 Steve Football 45 Evan Chess 46 Evan Soccer 47 Evan Football 49 I want to return each column for the two highest scores for each person. Can anyone tell me how to do this?

Hello, While Performing the Online Recovery By PITR, We had a Problem as we didnt Understand the proper Way of Enabling PITR on all POSTGRES Server . again , when psql -c "select pg_start_backup('pgpool-recovery')" postgres is executed, the following msg appeared. =================== WAL archive is not active archive command...

I use poker software (HoldemManager) to keep track of the statistics (and show nice graphs) of millions of poker hand histories. This software (also PokerTracker 3) imports all the poker hands in PostgreSQL. The software runs on Windows) only. All of its users have NORMAL PCs. From single-core laptops, to a quadcore desktop at best. ...

I am developing a C# application and could not find any details on backing up the database using C#. I would like to provide the users of the application ability to save a backup of the database in case of any data lose or any other type of failures such as Hard disk failure and so on. I would really appreciate if someone could provide...

I'm a new to postgres. i have a table which is having a colomn with auto increment value. When I insert value to that table, it gives an error. First column is the auto increment one. Could some one help me?

Hi: How can solve this problem: Fatal error: Call to undefined function pg_connect() Thanks in advance

hi all. I have already read the documentation for PostgreSQL Continuous Archiving and Point-In-Time Recovery (PITR) I want to know if it is possible to take regular base backup & use smaller number of WAL files for the recovery. Please advise if this is possible. thanks.

I'm installing PostgreSQL 8.3.7(postgresql-8.3.7-1-windows) client on my windows machine. But got an error saying "Problem running post-install set up.Installation may not complete correctly Error readinf file C:/Program Files/PostgreSQL/8.3/data/postgresql.conf" Could someone help me?.

Hello I am trying to compile a query but getting inconsistent data from it. I need to make use of two tables namely: transaction_products refunds Both of the above tables contain product_id and I would like to join the tables to gather some detailed information about sales. I know it sounds like a simple job but I keep getting...

Hi, I have a problem regarding on making function in postgre. I am newbie for this. My problem is that i want to make a function in postgre that accepts the name of the table. In the processed of the function, the table name inputted should be merge to the another table. And, the result values of query returned. Any idea for this.

Hi hello, I have a task assignment regarding for the dynamic fields. My task is to create a table in postgresql database and make the fields of this table a dynamic. This means that the table can be added, renamed and deleted the fields. On ther hand, the datatype of field can be changed also. One that come up to my mind to solve this...

I want to develop windows application using C#, which will be able to list the all the Postqresql servers on the current network. Does anyone know how to do that? Thanks.

Is there any scripts or commands for installing a postgres db on a windows machine. For anyone who knows, thanks as always.

Dar Friends , what is the exact Minimum System Requirement (hardware and software ) of PostgreSQL 8.x ? thanks. Ali

Dear All, I want take a incremental backup and restore in postgres sql throught command.If you have any ideas reply me.Advance thanks to all. Kindly Regards Siva

Hi friends, I have one big doubt, when we update a table by inserting or deleting or modifying and those modifications we can store by \s <some filename>, by executing this command in the prompt of database, then it stores the commands whatever we have done till now in database prompt into that filename. But if we do...

Hi, I'm using PostgreSQL ang PHP through Codeigniter framework. I have a problem regarding on how to vacuum the database. I tried to make this code in Sql manager. VACUUM FULL VERBOSE ANALYZE It would message like this...

hi, I'm using postgreSQL and php. I am assigned for migration of data of database. I would like to ask a help if how to migrate the data from the Postgre 8.0 to the Postgre 8.3. Is there anyone know any steps on how to migrate? Is there anyone know a script for automated migration?

hi, Sorry i did not try this. I will try this and write back. Thanks

Hi, How to export a table data from one database to another in postgresql. Thanks in advance. Bye Vikas Jain

Hello everyone, I could use some help with this function I've created (see below) that runs flawlessly on PostgreSQL 8.3.6 on my development machine but ends with an error on the production server that has PostgreSQL 7.4.8 installed (see below). My function: CREATE OR REPLACE FUNCTION generate_menu(varchar(255), char(2), varchar(255), int,...

Hello I am developing an application that requires PostgreSQL connection, I have installed PostgreSQL on my development machine and using NpgSQL to connect to the database. I am able to connect to the database while the application is running on the development PC, but whenever I am on any other PC on my network I cannot connect the application...

HI, all This following procedure will cause two problems 1) If the procedure fails(which is to raise an exception inside it) and re-do again, sometimes the temp1 will exist and cause the first query fails. 2) After doing this procedure several times, it may cause an error about 2nd query said OID something could not find. But after a while...

How do I catch all the output from Raise command on PL/pgsql in PHP coding? Jack

Hello, I have created a function in Postgres. His code is : CREATE OR REPLACE FUNCTION add_one(INOUT arg1 integer, INOUT arg2 integer) RETURNS record AS '$libdir/myDLL.dll', 'add_one' LANGUAGE 'c' VOLATILE STRICT ; In the DLL, I have a function C (it's just a test function) :