[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

Hello, ALL I'm making a simple log system where all the users (each one have a different login and password) will be logged all your actions. When a user delete, insert ou update any data in a table, the trigger will log the operation in another table. Until this point, all OK. I made this tr

[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

Jose Manuel Lorenzo Lopez wrote: > Hi folks, > > I noticed a strange behavior of my DB. Let me explain: > > I created a table bdf_users as admin user 'postgres' and granted insert > access for this table to public. > > Now I want to insert a line as user 'jose' (That's me!) and got the > foll

[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