[GENERAL] triggers

2009-04-16 Thread Gustavo Rosso
Gente, buenos dias. Como consulto lo triggers desde psql? Gracias! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] explain

2009-01-07 Thread Gustavo Rosso
Es 1.213ms un valor correcto para realizar un insert en una tabla obtenido por explain analyze. Gustavo -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] autovacuum

2009-01-06 Thread Gustavo Rosso
Buenas tardes. Cargue el parametro autovacuum_npatime en 86400, o sea cada 24 hs. deberia ejecutarse, sin embargo me encuentro en el log el mensaje WARNING: autovacuum not started because of misconfiguration Alguien tiene idea? Gracias Gustavo -- Sent via pgsql-general mailing list (pgsql-gene

[GENERAL] spanish

2008-12-04 Thread Gustavo Rosso
Please, exists postgres forum in spanish? Thanks Gustavo -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] serial

2008-12-04 Thread Gustavo Rosso
I created this table: create table se (n serial); Column | Type | Modifiers -+-+ n | integer| not null default nextval('se_n_seq'::regclass) I inserted two record, later select, but column n (

[GENERAL] Encoding

2008-11-19 Thread Gustavo Rosso
This error give me to load a file into postgres: ERROR: invalid byte sequence for encoding "UTF8": 0xa4 I must force load data. How must to do? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-ge

Re: [GENERAL] Urgent - Grant

2008-11-18 Thread Gustavo Rosso
Gustavo Rosso folgendes: People of world, help help please. I created a DB with super-user postgres, I give all privileges to DB (banco is my DB) GRANT ALL ON DATABASE banco TO PUBLIC; GRANT CREATE ON DATABASE banco TO PUBLIC But other users can't create tables in this DB ERROR:

[GENERAL] Urgent - Grant

2008-11-18 Thread Gustavo Rosso
People of world, help help please. I created a DB with super-user postgres, I give all privileges to DB (banco is my DB) GRANT ALL ON DATABASE banco TO PUBLIC; GRANT CREATE ON DATABASE banco TO PUBLIC But other users can't create tables in this DB ERROR: banco=> create table tabla (x integer)

Re: [GENERAL] ERROR

2008-11-17 Thread Gustavo Rosso
ave you made to the configuration What steps have you taken to install PostgreSQL Regards, Serge Fonville On Mon, Nov 17, 2008 at 4:08 PM, Gustavo Rosso <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: I create a db wiht user postgres, but other users can't no create

[GENERAL] ERROR

2008-11-17 Thread Gustavo Rosso
I create a db wiht user postgres, but other users can't no create tables, and I give all privileges. (banco is my db) grant all on database banco to public; grant create on database banco to public; This is the error: *ERROR: must be owner of relation (table)* Help me!!! -- Sent via pgsql-ge