[ADMIN] pitrtools package wrong dependency (binary packages)

one know how to ask for help about this? Thanks, Daniel Cristian Cruz -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction?

?column? -- t (1 registro) brd2=# SELECT 'Ã' LIKE UPPER('ã'); ?column? -- f (1 registro) brd2=# SHOW lc_collate ; lc_collate pt_BR.iso88591 (1 registro) The correct LC_COLLATE would be pt_BR.utf8 or is it a bug? -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

[ADMIN] COUNT(DISTINCT field) OVER (PARTITION BY another_field)

group_key; Regards, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

Re: [ADMIN] COUNT(DISTINCT field) OVER (PARTITION BY another_field)

... 2009/7/21 Daniel Cristian Cruz > Hi list, > > Does someone knows why this is not a supported feature? > > I was happily SQL querying when I woke up from my dreams with this message: > > ERROR: DISTINCT is not implemented for window functions > LINE 6: COUNT(DISTINCT

Re: [ADMIN] Problem with table lock within a function

Sorry... Long time not using pg_locks... My function (on pid 20125) was running, pid 25743 requested an exclusive lock and is waiting, and all others were waiting for this one. 2009/4/8 Daniel Cristian Cruz > Hi all, > > I had a big function (the same one mentioned before) which is

[ADMIN] Problem with table lock within a function

for 3 minutes and every developer is trying to kill me, because they are waiting for their results. Regards, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

[ADMIN] DEBUG message: concurrent ROOT page split

Hi all, Sometimes I use RAISE DEBUG on my functions, and it showed this message on PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian 4.3.3-5) 4.3.3. Is it normal? Could it be something wrong with my code? Regards, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

Re: [ADMIN] pgCluster and PostgreSQL

erprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 > // Keyserver: www.keyserver.net Key-ID: 1C1209B4 > > -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

Re: [ADMIN] Not so simple query and a half million loop

exceptions... It's somewhat complex but it returns slowly ok. Regards, "Alvaro Herrera" <[EMAIL PROTECTED]> escreveu: > Daniel Cristian Cruz escribió: >> No one knows why I got "actual time=0.014..0.570 rows=30 loops=511222" >> and "actual ti

Re: [ADMIN] Not so simple query and a half million loop

, 0) ~ 1 second I've tryied to increase statistics to maximum, with no success. This is the eGroupware database schema, with a few records. Regards, 2008/12/1 Daniel Cristian Cruz <[EMAIL PROTECTED]>: > Maybe someone would like to see it without broken lines (I do). > >

Re: [ADMIN] Not so simple query and a half million loop

Maybe someone would like to see it without broken lines (I do). Regards, 2008/12/1 Daniel Cristian Cruz <[EMAIL PROTECTED]>: > I've tryied 4 times to post this message to pgsql-performance without > success... No return, even an error... > > Below is my problem; a quer

[ADMIN] Not so simple query and a half million loop

ing egw_cal_dates_pkey on egw_cal_dates cd (cost=0.00..1.02 rows=1 width=20) (actual time=0.108..4.281 rows=30 loops=511222) Index Cond: (cd.cal_id = cr.cal_id) Filter: ((date_part('year'::text, ('1970-01-01 00:00:00'::timestamp without tim

[ADMIN] DROP TABLE waiting for pg_dump

tions before upgrade). Regards, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

[ADMIN] pgCluster and PostgreSQL

nd regards, -- Daniel Cristian Cruz Administrador de Banco de Dados Direção Regional - Núcleo de Tecnologia da Informação SENAI - SC Telefone: 48-3239-1422 (ramal 1422)

Re: [ADMIN] select count(*) from a large table is very slow

_class after an analyze. Oops... INSERT or DELETE... :) And remember that if using TRUNCATE, it will not run your trigger and you will need to reset the counter manually. Regards... -- Daniel Cristian Cruz ---(end of broadcast)--- TIP 7: You ca

Re: [ADMIN] Revoking usage of pg_catalog

2007/5/9, Scott Marlowe <[EMAIL PROTECTED]>: On Wed, 2007-05-09 at 08:05, Daniel Cristian Cruz wrote: > Hi there! > > Is it possible to revoke usage of pg_catalog for a specific user? > > The reason is to secure PostgreSQL. If a user can connect to a > database,

[ADMIN] Revoking usage of pg_catalog

blocked, PostgreSQL could be used? Could it be possible to made queries on allowed schemas and tables? This could be an item for the wishlist? Kind regards, -- Daniel Cristian Cruz

Re: [ADMIN] Logging just SQL commands in an SQL script format

linois 217.333.0382 http://webservices.uiuc.edu -- Daniel Cristian Cruz Analista de Sistemas Especialista postgreSQL e Linux Instrutor Certificado Mandriva ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [ADMIN] Autovacuum not running in 8.2.0

opriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Daniel Cristian Cruz Analista de Sistemas Especialista postgreSQL e Linux Instrutor Certificado Mandriva ---(end of broadca

Re: [ADMIN] Should duplicate indexes on same column and same table

make a NOTICE about this? The user could see it and take some action about it. Sincerely, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org