Re: [GENERAL] Special ORDER BY

You can use something like "CASE WHEN" .. and use a number to order your data... like this SELECT *, CASE WHEN c.etiqueta = 245 THEN 1 WHEN c.etiqueta = 130 THEN 2 WHEN c.etiqueta = 240 THEN 3 WHEN c.etiqueta = 243 THEN 4 WHEN c.etiqueta = 246 THEN 5 WHEN c.eti

Re: [GENERAL] Tigger after delete with plpgsql

Hi, You're using a trigger AFTER, in your case could be BEFORE? Cause when you use AFTER the var OLD not exists... I don't know if I understand exactly what you'll do to ativate this trigger.. but I think maybe is it.. try.. Em 31/08/2012 1

Re: [GENERAL] allow servers to access to the same data

You can use a stream replication in hot standby (native) to have the same data and access in both (but not update and insert in the slave, just select) and create a virtual IP using heartbeat.. configuring a master to use some IP (virtual) and when this lost the IP, the

Re: [GENERAL] allow servers to access to the same data

r you.. I don't know to much.. cause I'm stating in DB.. (aproximately one year) but if can I help in something.. send me.. Em 17/10/2012 14:53, Daniel Serodio (lists) escreveu: Tulio wrote: You can use a stream replication

[GENERAL] parameter "vacuum_defer_cleanup_age"

Hi, I have 2 servers, working with Hot-Standby and Streaming Replication... and when we executed some query much large returns a message.. "canceling statement due to statement timeout" I want know, how can I calculate the better value to "vacuum_d

Re: [GENERAL] parameter "vacuum_defer_cleanup_age"

sion:  9.1 Em 30/01/2012 22:12, Fabrízio de Royes Mello escreveu: 2012/1/30 Tulio <tu...@informidia.com.br> Hi, I have 2 servers, working with Hot-Standby and Streaming Replication... and when we executed some

Re: [GENERAL] parameter "vacuum_defer_cleanup_age"

Hi Marti, The parameter statement_timeout isn't configured.. I'm using the value default.. 0.. And this is happening when I'm doing large querys on the slave.. thanks, Tulio Em 01/02/2012 12:33, Marti Raudsepp escreveu:

Re: [GENERAL] spanish locale question

5 | león | mendoza | jua 2 | leon | mendoza | juan 3 | león | valárd | jose 4 | león | válencia | jos 1 | león | valencia | josé 6 | leon | valencia | josie 7 | león | valencia | josie (7 rows) Is this the correct way to order in Postgresql and if it´s not Does an

Re: [GENERAL] spanish locale question

work. It assumes that leon is different from león (with accent). I was assuming the collation eliminates such difference. It isn´t that way it works? Thanks in advance for your help. Tulio Albe Laurenz *EXTERN* wrote > > Tulio wrote: >> Let me expand the collate situation. I´m from

[GENERAL] Re: Auto incrementing fields. How?

Harry Wood wrote: > > Anyone know how to create auto incrementing fields? > > -- > Harry > [EMAIL PROTECTED] > http://www.doc.ic.ac.uk/~hw97/Nojer2 > Nojer2 on chat.yahoo.com and zapidonia.com > ICQ number 18519769 CREATE TABLE test ( teste_id SERIAL PRIMARY KEY, namevarch

[GENERAL] Trigger with superuser privileges

Hi, all Anobody could tell-me how can I make a Trigger thats execute some things whith "postgres" superuser privileges (like INSERT INTO a table that the user logged in don't have access) regards, Tulio Oliveira -- == AK

[GENERAL] Possible "off-topic"

om the same notebook, the time to make de CONNECTION into Postgres is too slow. More than 30 seconds But when I access the notebook via another machine, the connection is fast. Anyone know if the X system conflicts with POSTMASTER ? I need make some presentations with this notebook. Rega

[GENERAL] Trigger and Permissions

that no normal user have INSERT PERMISSION ? Regards, Tulio

[GENERAL] PG_DUMP permissions

suggestion ??? Regards, Tulio Oliveira

[GENERAL] Problems with RAISE EXCEPTION

ables, only a CONTANT STRING. Nor strigs concatenation are supported I'm make any mistake ? Exist any way to do that ? Regards, Tulio Oliveira

[GENERAL] Re: Permission denied while insert

enzo López > are you inserting directly over the table, or in a view of this table ? I had problems inserting data in a View with no records ... regards Tulio

[GENERAL] postdrv.exe fails on 7.1

7.1, or exist a new postdrv.exe ??? I realy need its working soon Regards, Tulio Oliveira ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] Driver ODBC postdrv.exe fails on 7.1

7.1, or exist a new postdrv.exe ??? I realy need its working soon Regards, Tulio Oliveira ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] Re: I lost the pg_control file

Tom Lane wrote: > > Tulio Oliveira <[EMAIL PROTECTED]> writes: > > I just lost the pg_control file, located in /usr/local/pgsql/data/global > > How did that happen? > > > I start a new INITDB after rename the PG_DATA directory to another name, > > but if

[GENERAL] User can not create a new table

ated ? I need change this message to portuguese... regards, tulio oliveira -- Um velho homem sábio disse uma vez: "Quando você atualiza um exploit, você é bom. Quando você é o primeiro a hackear cada sucessiva versão de um produto que roda em milhões de computadores pela Interne