[ADMIN] null date fields

2002-02-12 Thread Marco Tulio
: INSERT INTO order (order_id, sales) VALUES (1,''); And I need write codes for translate the porting to: INSERT INTO order (order_id, sales) VALUES (1,NULL); Has any place to change this in configuration directory ? ((I need say that´s my English is soo poor ?? :-)) --- Marco Tul

Re: [ADMIN] How to include plpgsql in table pg_language

2002-02-15 Thread Marco Tulio
hanks > Pam > on console, as postgres user, type: createlang --dbname=dbtest --pglib=/usr/local/pgsql/lib pspgsql And have fun ! Marco Tulio Desenvolvimento de sistemas para Internet __ Quer ter seu próprio end

Re: [ADMIN] hanging psql session while granting...

2002-02-15 Thread Marco Tulio
er user to other user... > > How can i change the Grants over tables to other users ... is there any > round about way ? > Or where could be the problem. > > > Thanks > laks You can´t do that. Only the postgres super-user or the table creator can change this pe

Re: [ADMIN] How to include plpgsql in table pg_language

2002-02-17 Thread Marco Tulio
> > On Fri, 15 Feb 2002, Pam Wampler wrote: > Goods documentations are in: www.postgresql.org/idocs And the excelent book of Bruce Momjian : http://www.postgresql.org/docs/aw_pgsql_book/index.html I sugest you studie too the SPI interface, and make "C" programs to contro

[ADMIN] User Defined Function

2002-02-18 Thread Marco Tulio
, and recreate , but...) ... I have another way to use my fuctions to validate datas ? regards, Tulio Marco Tulio Desenvolvimento de sistemas para Internet __ Quer ter seu próprio endereço na Internet? Garanta já o seu e