[GENERAL] How to delete rows number 2,3,4...

Hello. I have a table create table foo ( a serial, b int, c int, more fields ...); and now I wish to remove for each combination of b and c, all the rows except the one with the highest value of a. For example a b c other fields = 1 5 5 . 2 5 5 3 2 3 4 2 2

Re: [GENERAL] postgreSQL for Windows 7

On Thu, Oct 7, 2010 at 12:28 PM, quickinfo quickinfo quickinfo...@gmail.com wrote: Dear Friends, I have installed windows 7 on my system. Previous I used postgreSQL 8.0 on XP. I tried install postgres 8.3 on windows 7. but it is not installing properly. After installtion am not able to find

Re: [GENERAL] How to delete rows number 2,3,4...

On 8 Oct 2010, at 8:59, A B wrote: Hello. I have a table create table foo ( a serial, b int, c int, more fields ...); and now I wish to remove for each combination of b and c, all the rows except the one with the highest value of a. Or said differently: Delete all the rows

Re: [GENERAL] How to delete rows number 2,3,4...

Thank you all for your replies. 2010/10/8 Alban Hertroys dal...@solfertje.student.utwente.nl: On 8 Oct 2010, at 8:59, A B wrote: Hello. I have a table create table foo ( a serial, b int, c int, more fields ...); and now I wish to remove for each combination of b and c,  all the

[GENERAL] Internationalisation of database content (text columns)

(Since I got no replies on the novice list, I repost this question here) Hello, I'm working on a database schema which contains lots of type code lookup tables. The entries of these tables are also hierarchically related among themselves (subtype/supertype), to store rather large and quite

Re: [GENERAL] PostgreSQL 7.4.16 is creating strange files under /var/lib/pgsql

On Oct 7, 2010, at 9:02 PM, Craig Ringer wrote: Where? They can't be in /var/lib/pgsql if there are four of them, so they must be in subdirectories, right? Which ones? Or they're created with odd characters which the user's shell/terminal/UI cannot display. -- Scott Ribe

[GENERAL] LOG: unexpected EOF on client connection

Hi all - I am seeing lot of these records in the log file. Not able to find why I get this in log file. Is there a way to find out info about this ? Thanks for your help LOG: unexpected EOF on client connection LOG: unexpected EOF on client connection LOG: unexpected EOF on

Re: [GENERAL] LOG: unexpected EOF on client connection

Hi all - I am seeing lot of these records in the log file. Not able to find why I get this in log file. Is there a way to find out info about this ? Thanks for your help LOG: unexpected EOF on client connection LOG: unexpected EOF on client connection This means the

[GENERAL] Optimization of FK creation

Hello. It's often neccessary to create empty table and FK to some existing table from this newly created table. However, even newly created (empty) table requires lock on parent table it wants refer to. On large production DBs with high load on parent table it's almost neverending operation. For

Re: [GENERAL] Optimization of FK creation

Robert Ayrapetyan robert.ayrapet...@comodo.com writes: I think it's very easy to check if table_foo is empty and therefore not requires any locks on parent_table and generate FK immediately without acquiring the lock on parent table. Unfortunately, that's complete nonsense. The reason for

[GENERAL] Segfault : PostgreSQL 9.0.0 and PgPool-II.

Hello, I'm having issues trying to set up PgPool-II with PostgreSQL 9.0.0 (for HA reasons with Streaming Replication). PgPool end up with a SIGSEV whenever I have a correct authentification. To try my set up, I've installed a default PgSQL 9.0.0 server, where I can connect without a single

Re: [GENERAL] Segfault : PostgreSQL 9.0.0 and PgPool-II.

On 10/08/2010 09:47 AM, Ugo PARSI wrote: Hello, I'm having issues trying to set up PgPool-II with PostgreSQL 9.0.0 (for HA reasons with Streaming Replication). PgPool end up with a SIGSEV whenever I have a correct authentification. To try my set up, I've installed a default PgSQL 9.0.0 server,

[GENERAL] Wrong starting value of sequences after doing pg_dump

I did a pg_dump of a database. All the sequences ended up with starting values of 1. Since this is not an empty database, this is all wrong. Is there anything I need to do at command time to change that or is it a bug? \set in psql gives: PostgreSQL 8.4.5 on x86_64-pc-linux-gnu, compiled by

Re: [GENERAL] Wrong starting value of sequences after doing pg_dump

On 10/08/2010 11:17 AM, Dennis Gearon wrote: I did a pg_dump of a database. All the sequences ended up with starting values of 1. Since this is not an empty database, this is all wrong. Is there anything I need to do at command time to change that or is it a bug? \set in psql gives:

Re: [GENERAL] LOG: unexpected EOF on client connection

On Fri, Oct 8, 2010 at 8:11 AM, t...@fuzzy.cz wrote: Hi all -               I am seeing lot of these records in the log file. Not able to find why I get this in log file. Is there a way to find out info about this ? Thanks for your help LOG:  unexpected EOF on client connection LOG:  

[GENERAL] anyone have Movable Type 5 working with Postgres?

Even though Movable Type 5 has dropped official support for Postgres it still comes with the drivers in order for it to work. I've gotten it setup and working with Postgres, but there is one problem that keeps me from being able to use it. That issue I've explained over on the MT forums:

[GENERAL] Understanding PostgreSQL Storage Engines

I know that MySQL uses MyISAM storage engine by default and was just trying to look on Google to try and see if I could understand what storage engine does PostgreSQL use by default when I generate a database / table. Is there some way someone (me) who knows nothing about how a ORDBMS works

Re: [GENERAL] Understanding PostgreSQL Storage Engines

Hello 2010/10/8 Carlos Mennens carlos.menn...@gmail.com: I know that MySQL uses MyISAM storage engine by default and was just trying to look on Google to try and see if I could understand what storage engine does PostgreSQL use by default when I generate a database / table. Is there some way

Re: [GENERAL] Understanding PostgreSQL Storage Engines

Hey, 2010/10/9 Pavel Stehule pavel.steh...@gmail.com Hello 2010/10/8 Carlos Mennens carlos.menn...@gmail.com: I know that MySQL uses MyISAM storage engine by default and was just trying to look on Google to try and see if I could understand what storage engine does PostgreSQL use by

Re: [GENERAL] Understanding PostgreSQL Storage Engines

On Friday 08 October 2010 2:30:40 pm Carlos Mennens wrote: I know that MySQL uses MyISAM storage engine by default and was just trying to look on Google to try and see if I could understand what storage engine does PostgreSQL use by default when I generate a database / table. Is there some way

[GENERAL] Another PostgreSQL Diff Tool 2.2.2 released

Another PostgreSQL Diff Tool 2.2.2 released --- Another PostgreSQL Diff Tool (also known as apgdiff) is free PostgreSQL database schema diff tool. Release information --- This is a bugfix release. Also Czech localization was added in

Re: [GENERAL] Understanding PostgreSQL Storage Engines

On 10/08/2010 03:39 PM, Adrian Klaver wrote: On Friday 08 October 2010 2:30:40 pm Carlos Mennens wrote: I know that MySQL uses MyISAM storage engine by default and was just trying to look on Google to try and see if I could understand what storage engine does PostgreSQL use by default when I

Re: [GENERAL] Understanding PostgreSQL Storage Engines

On 10/09/2010 05:30 AM, Carlos Mennens wrote: I know that MySQL uses MyISAM storage engine by default and was just trying to look on Google to try and see if I could understand what storage engine does PostgreSQL use by default when I generate a database / table. Is there some way someone (me)