Re: [SQL] queries problems

2005-09-08 Thread Joÿffffffffffe3o Carvalho
The problem here is to compare int2vector with int2.   Regards João Carvalho Michael Fuhr <[EMAIL PROTECTED]> escreveu: [Please copy the mailing list on replies so others can contributeto and learn from the discussion.]On Thu, Sep 01, 2005 at 10:33:44PM -0300, João Carvalho wrote:> Michael Fuhr <[E

Re: [SQL] Statistics from Sequences

2005-09-08 Thread Joÿffffffffffe3o Carvalho
Michael Fuhr <[EMAIL PROTECTED]> escreveu: [Please copy the mailing list on replies so others can participatein and learn from the discussion.]On Thu, Sep 08, 2005 at 02:32:12PM -0300, Joÿffffffe3o Carvalho wrote:> Can you give me a help about:> > > The min value> &

[SQL] Statistics from Sequences

2005-09-06 Thread Joÿffffffffffe3o Carvalho
Is it possible to get from a sequence: The sequence owner The min value The max value The increment value The last used number ??? Regards Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. Participe!

[SQL] SQL queries

2005-09-05 Thread Joÿffffffffffe3o Carvalho
HiIm having problems doing some SQL queries, they are this ones:-List lock users-Show schema owners-Check if a certain table has a toast tableIf any one could help that would be good.Regards__Converse com seus amigos em tempo real com o Yahoo! Messeng

[SQL] Turn off auto-commit

2005-09-02 Thread Joÿffffffffffe3o Carvalho
Im working in postgresql 8.0 in windows XP. How can I turn off auto-commit. I already tried a few things but it didn't worked.Regards João Carvalho Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. Participe!

[SQL] queries problems

2005-09-01 Thread Joÿffffffffffe3o Carvalho
HiIm having problems doing some SQL queries. I want information about the following statistics:-List lock users-Show schema owners, it may also so more schema information-Check if a certain table has a toast tableIf any one could help that would be very good.Regards_