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 .
On Thu, Oct 7, 2010 at 12:28 PM, quickinfo quickinfo
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 out pg_hba.conf fil
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
Thank you all for your replies.
2010/10/8 Alban Hertroys :
> 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 exc
(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 co
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
scott_r...@elevat
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 clie
> 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 mea
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
Robert Ayrapetyan 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 the lock on the
paren
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 proble
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,
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 GC
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:
PostgreS
On Fri, Oct 8, 2010 at 8:11 AM, 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
>>
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:
http
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 underst
Hello
2010/10/8 Carlos Mennens :
> 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 know
Hey,
2010/10/9 Pavel Stehule
> Hello
>
> 2010/10/8 Carlos Mennens :
> > 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 / t
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
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 this
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
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) wh
23 matches
Mail list logo
