[SQL] PgAgent logging verbosity

Hi list, I would like to know if I set the debug mode to 2 (-l 2) in the pgAgent connection string it could spend much cpu processing. I have other things running in the server and I don't like to create problem to others. -- Ezequias Rodrigues da Rocha http://ezequiasrocha.blogspot.com

[SQL] PgAdmin 1.6.2 crashes when resize the collumn

e but the resize of columns are quite problematic. Regards ... -- Ezequias Rodrigues da Rocha http://ezequiasrocha.blogspot.com/ use Mozilla Firefox:http://br.mozdev.org/firefox/

Re: [SQL] There is acid without transactions ?

Sorry my mistake it was 32 minutes. I am confusing with gmail here. Anyway today is sunday and it is more difficult to have a reply from community. Anyway thanks. Ezequias 2007/3/11, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]>: Perfect. I just don't know what drivers you

Re: [SQL] There is acid without transactions ?

Perfect. I just don't know what drivers you are talking about (odbc maybe). More perfect is becouse you answare me in only 1 minute. What community don't is ? Ezequias 2007/3/11, Jonah H. Harris <[EMAIL PROTECTED]>: On 3/11/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTE

[SQL] There is acid without transactions ?

Hi list, I would like to know if an statement like. Insert into foo values (1,'Brazil'); Makes an ACID transaction. I am wondered if i must have a Begin...Commit statemnt to garantee my ACIDs transactions. Regards , -- Ezequias Rodrigues da Rocha http://ezequiasrocha.blogspo

Re: [SQL] [pgadmin-support] Alternative Serial

easy ? And about the cast I have found ? nextval('mySerial_id'::regclass) I ask again. What is regclass ? What does it really is. Ezequias 2007/3/11, Milen A. Radev <[EMAIL PROTECTED]>: Ezequias Rodrigues da Rocha написа: > Hi list, > > I know that serials must be cre

[SQL] Alternative Serial

am correct and what does it means: nextval('mySerial_id'::regclass) What is regclass ? Regards , -- Ezequias Rodrigues da Rocha http://ezequiasrocha.blogspot.com/ use Mozilla Firefox:http://br.mozdev.org/firefox/

Re: [SQL] PostgreSQL to Oracle

Thank you Jonah, That isn't a decision taken but I will need to argue with the new team of my new company. I can't see why but I will see how the things occurs. Thank you again Ezequias 2007/3/9, Jonah H. Harris <[EMAIL PROTECTED]>: On 3/9/07, Ezequias Rodrigues da Rocha &

Re: [SQL] Statistics

<[EMAIL PROTECTED]>: At 12:22 PM 3/9/07, Ezequias Rodrigues da Rocha wrote: >Does someone have statistcs from PostgreSQL ? Numbers from the list, >performance statistics. I must argue with another person the idea of do >not put Oracle in our organization. Performance should n

[SQL] PostgreSQL to Oracle

Hi list, Is it a simple action to convert a database from PostgreSQL to Oracle ? I mean a simple database with 33 tables 8 functions 31 sequencies 2 triggers 1 type 3 views Has someone any idea ? -- Ezequias Rodrigues da Rocha http://ezequiasrocha.blogspot.com/ use Mozilla Firefox:http

Re: [SQL] SHA-1 vs MD5

You are correct SH1 is supported. So I get the output size from 128 to 160 ok ? I saw at wikipedia. What does "With flaws" colisions means ? Does it means some ? in MD5 the put only "yes" Regards Ezequias 2007/3/9, Chad Wagner <[EMAIL PROTECTED]>: On 3/9/07, E

Re: [SQL] SHA-1 vs MD5

You are correct. My pg (8.1.3) Now what I do to remove it ? Just delete the functions ? Ezequias 2007/3/9, Chad Wagner <[EMAIL PROTECTED]>: On 3/9/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote: > > Thank you so much for your information. I installed the pgCr

[SQL] Statistics

Hi list, Does someone have statistcs from PostgreSQL ? Numbers from the list, performance statistics. I must argue with another person the idea of do not put Oracle in our organization. We are quite well with postgresql and I have no plans to change my plataform. Regards -- Ezequias Rodrigues

Re: [SQL] SHA-1 vs MD5

sha256": No such hash algorithm SQL state: 22023 Any suggestion Ezequias 2007/3/8, Chad Wagner <[EMAIL PROTECTED]>: On 3/8/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote: > > I really don't have the pgcrypto. It could be a nice alternative. Could > you t

Re: [SQL] SHA-1 vs MD5

em of MD5 and know it is very good too. If someone could tell me where MD5 is used I could be more relaxed. My best regards to all -- Ezequias Rodrigues da Rocha http://ezequiasrocha.blogspot.com/ use Mozilla Firefox:http://br.mozdev.org/firefox/ 2007/3/7, Chad Wagner <[EMAIL PROTECTED]>:

[SQL] SHA-1 vs MD5

Hi list, I know that there is a md5 internal function on postgresql, but I noticed that it isn't the more secure today. I would like to know if there is a SHA-1 function implemented yet of, if not, if the team has plan to introduce it on PostgreSQL. Regards ... -- Ezequias Rodrigues da

Re: [SQL] Inc

I did like this: update base.destinationTable set MyCountField = MyCountField + 1 where id = new.keyField_ID; I think it works becouse my tests are ok. My really thank you all. Ezequias 2007/3/6, Richard Huxton : Ezequias Rodrigues da Rocha wrote: > Thank you but I must inc an specific

Re: [SQL] Inc

Now that's ok. Thank you all. I just thought that there was a function to inc an integer field in postgresql. Best regards Ezequias 2007/3/6, Andreas Kretschmer <[EMAIL PROTECTED]>: Richard Broersma Jr <[EMAIL PROTECTED]> schrieb: > --- Ezequias Rodrigues da Rocha <[

Re: [SQL] Inc

Thank you but I must inc an specific row. How to do that ? Ezequias 2007/3/6, Richard Huxton : Ezequias Rodrigues da Rocha wrote: > Hi list, > > There is any function to increment with 1 some field. > > For example. I have a table with a field that on each update it > increm

[SQL] Inc

Hi list, There is any function to increment with 1 some field. For example. I have a table with a field that on each update it incrementes a field that is allways configured to 0 before the starting of updates. Regards -- Ezequias Rodrigues da Rocha http://ezequiasrocha.blogspot.com/ use

Re: [SQL] Time of executed query

EXPLAIN ANALYZE Is perfect but i have no idea of how to use it. My resultset is retrieving my rows. Another question that cames with the Analyze. PgAdmin return the time to retrieve the data or all time to fill the grid on the "SQL Editor". -- Ezequias Rodrigues da

Re: [SQL] Time of executed query

Bart Degryse <[EMAIL PROTECTED]>: note the time just before your operation starts note the time just after it ends show timeafter - timebefore >>> "Ezequias Rodrigues da Rocha" <[EMAIL PROTECTED]> 2007-03-06 14:20 >>> Hi list, It is possible to retrieve the

[SQL] Time of executed query

Hi list, It is possible to retrieve the time of a SQL statement leads to execute ? I would like to put in my application how much time each operation leads to finish. Any suggestion ? -- Ezequias Rodrigues da Rocha http://ezequiasrocha.blogspot.com/ use Mozilla Firefox:http://br.mozdev.org

Re: [SQL] How to store a password encripted in a userdefinedtable

Perfect ! That's it. Another information I doesn't have. Great to be part of this list. Thank you Adrian 2007/3/1, Adrian Klaver <[EMAIL PROTECTED]>: On Thursday 01 March 2007 8:53 am, Ezequias Rodrigues da Rocha wrote: > I am just passing the database owner p

Re: [SQL] How to store a password encripted in a userdefinedtable

82cf99 current_usermd5 bigdbsys5f4dcc3b5aa765d61d8327deb882cf99 current_usermd5 logstocksys 5f4dcc3b5aa765d61d8327deb882cf99 Show us some statements. >>> "Ezequias Rodrigues da Rocha" <[EMAIL PROTECTED]> 2007-03-01 16:02 >>> Just another thing. Why md5

Re: [SQL] How to store a password encripted in a user definedtable

Just another thing. Why md5 function return a different string from user role of postgresql ? It allways put an md5 string concated with another sequence of string. Why does it occurs ? Ezequias 2007/3/1, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]>: I know it. Thank you s

Re: [SQL] How to store a password encripted in a user definedtable

I know it. Thank you so much. Ezequias Grettings from Brazil. 2007/3/1, Bart Degryse <[EMAIL PROTECTED]>: update yourtable set passwordfield = md5(passwordfield) watch out: md5 is irreversable! you can't "un_md5" >>> "Ezequias Rodrigues da Rocha&qu

Re: [SQL] How to store a password encripted in a user defined table

ely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das democracias ainda é melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.c

Re: [SQL] Case with Char(1)

Now it is working. Thank you for your interest. Ezequias 2007/2/28, Andrew Sullivan <[EMAIL PROTECTED]>: On Wed, Feb 28, 2007 at 10:02:38AM -0300, Ezequias Rodrigues da Rocha wrote: > Hi list, > > it is possible to use case with character (1) ? > > I am having proble

[SQL] Case with Char(1)

Hi list, it is possible to use case with character (1) ? I am having problems to formate the SQL statement. I have: SELECT * FROM test; a --- A B C SELECT a, CASE WHEN a='A' THEN 'one' WHEN a='B' THEN 'two' ELSE 'other' END FROM test; a | case ---+-

Re: [SQL] Position of a field

ating) that was not good for me. Regards Ezequias 2007/2/27, A. Kretschmer <[EMAIL PROTECTED]>: am Tue, dem 27.02.2007, um 8:51:27 -0300 mailte Ezequias Rodrigues da Rocha folgendes: > Hi list, > > I just would like to know if it is possible to change the position of > a field i

[SQL] Position of a field

Hi list, I just would like to know if it is possible to change the position of a field in a table. I am seen in pgAdmin3 that there is a position but on th is application I can't see if there is a place to do that. Regards Ezequias ---(end of broadcast)--

Re: [SQL] Insert based in a select

se.cartao); Hope this makes sense, ~p -Original Message- *From:* [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] *On Behalf Of *Ezequias Rodrigues da Rocha *Sent:* Monday, 26 February 2007 10:58 *To:* Phillip Smith *Cc:* pgsql-sql@postgresql.org *Subject:* Re: [SQL] Insert based in a select

Re: [SQL] Insert based in a select

will create one row in base.ingresso for each row in base.cartao. You will then need to use UPDATE to adjust the values in each of those rows to the other values you want. Number 2 would need to be run over and over again – not a practical option I imagine… ~p -Original Message-

[SQL] Insert based in a select

Hi list, Could someone help me with this problem I have a table like this Master table id number 10 9898398398 20 9938378390 30 9873636736 and I want to make an insert into a table with this structure: Secondary table id(sequence), master_id 110 220 3

[SQL] Change a field to sequence (serial)

Hi lists, Is there possible to change a bigint field (primary key) to a serial ? If yes how it is possible ? I was trying to do that but the pgadmin don't enable the change to sequence. What is the problem my friends ? Regards Ezequias http://ezequiasrocha.blogspot.com/ --

[SQL] Debug (is it PostgreSQL?)

My Linux is reporting the following message: DEBUG: Connection stats: total - 1, free - 0, deleted - 0 DEBUG: Checking for jobs to run DEBUG: Sleeping... DEBUG: Clearing inactive connections DEBUG: Connection stats: total - 1, free - 0, deleted - 0 DEBUG: Checking for jobs to run DEBUG: Sleeping

Re: [SQL] Retrieving 'Credit' when 'C'

uot;when" and "type" you should just have to change "mytable" to the correct table name and run in psql or the SQL Window of pgAdmin or wherever you usually run your SQL queries to get what you want. -Original Message- *From:* [EMAIL PROTECTED] [mailto: [EMAIL PRO

[SQL] There is a different cast than ::MyOtherType() ?

lp me ? *-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das democracias ainda é melhor do que a melhor das ditadura

Re: [SQL] Retrieving 'Credit' when 'C'

Just a question, where to put it ? I didn't notice yet. Ezequias 2007/2/15, Alvaro Herrera <[EMAIL PROTECTED]>: Ezequias Rodrigues da Rocha escribió: > Hello, > > Does anyone know how to make a Select that even having a Char(1) with the > letter C the statement m

[SQL] Retrieving 'Credit' when 'C'

2007-01-02CREDIT 2007-01-03CREDIT Thanks in advande, -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Re: [SQL] [ADMIN] Deadlock on transaction

Ok you teach me. Thank you and sorry. :( I just want to know why is it occuring. I am pretty sad. Ezequias 2007/2/12, Reinoud van Leeuwen <[EMAIL PROTECTED]>: On Mon, Feb 12, 2007 at 03:08:27PM -0300, Ezequias Rodrigues da Rocha wrote: > I mean really deadlock. Other transacti

Re: [SQL] [ADMIN] Deadlock on transaction

Insert into base.bilhete (id, estado, uso_sequencia, promocao_documento, assento_id, cartao_id, ingresso_id, promocao_id, sessao_id, vendedor_venda_id )')); dm.qQ1.SQL.add(Concat('values(', BilheteID, ',' , QuotedStr(EstadoID), ',' , '0,0', 

Re: [SQL] [ADMIN] Deadlock on transaction

2007/2/12, Richard Huxton : Ezequias Rodrigues da Rocha wrote: > I mean really deadlock. Other transactions can't access the database until > the main transaction is complete. A question: > > PostgreSQL doesn't permit multiple transactions concurrently ? PG has quite good

Re: [SQL] [ADMIN] Deadlock on transaction

-=-=-=-= Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das democracias ainda é melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com/

[SQL] Deadlock on transaction

? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das democracias ainda é melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http

[SQL] Sum sets of records

Hi list, I would like a little help from you to get the sum value of various subsets of my table. My table is like this id | type | value 1 C 10.00 2 C 15.00 3 W5.00 4 W3.00 Where C is credit and w is witdraw. How do I sum all records with C and subtract with

[SQL] Password Policy

Hi list, Is there any password polity that postgresql implement ? It is possible to put a set all no administrators passwords to = '123456' from times and times ? Has anyone implement a dinamic password autentication (the password changes according the date/month etc of a day ) ? Regards ... E

[SQL] Have anyone this man e-mail ?

url=aHR0cDovL3Blb3BsZS5wbGFuZXRwb3N0Z3Jlc3FsLm9yZy94emlsbGEvaW5kZXgucGhwPy9wYWdlcy9yb2J0cmVhdC5odG1s> Any information would be glad. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincerely) Ezequias Rodrigues da

Re: [SQL] Open a Transaction

TECTED]>: On Thu, Feb 08, 2007 at 03:13:16PM -0200, Ezequias Rodrigues da Rocha wrote: > > Any suggestion instead of change my max_stack_depth ? Well, I suppose you could put the numbers in a temp table an NOT IN on that. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technolog

Re: [SQL] Open a Transaction

subsets of my IN statement. :\ Any suggestion instead of change my max_stack_depth ? Regards Ezequias 2007/2/8, Joe <[EMAIL PROTECTED] >: Hi Ezequias, On Thu, 2007-02-08 at 14:50 -0200, Ezequias Rodrigues da Rocha wrote: > Hi list, > > Could someone tell me what is wrong on t

[SQL] Open a Transaction

, 41527, 41528, ) end; Commit; -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das

[SQL] to_chat(bigint)

. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das democracias ainda é melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http

Re: [SQL] Duplicate records

t; > select * > > from mytable A, (select field1, field2, count(*) from mytable group by > > field1, field2 having count(*) > 1) B > > where A.field1 = B.field1 and A.field2 = B.field2 > > > > >>> "Ezequias Rodrigues da Rocha" < [EMAIL PRO

Re: [SQL] Duplicate records

A.field1 = B.field1 and A.field2 = B.field2 >>> "Ezequias Rodrigues da Rocha" <[EMAIL PROTECTED]> 2007-02-02 14:48 >>> Hi list, I am making some data minning and would like to know if someone tell me how to retrieve the duplicate records based in one or two fiel

Re: [SQL] Insert into a date field

ostgres=# select * from testing; a 1963-09-01 (1 row) -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 2/2/07, Richard Huxton wrote: > Ezequias Rodrigues da Rocha wrote: > > Hi list, > > > > I am trying to insert a record in a table with a date field b

[SQL] Duplicate records

. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das democracias ainda é melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http

[SQL] Insert into a date field

like this: '1963-09-01' '1963-09-01'::date 1963-09-01 And notthing Thanks in advance. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincerely)

Re: [SQL] Log, Logs and more Logs

o help... - Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 1/31/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote: > > Great. Now the log is working. Thank you, Thank you, Thank you, > > But my statement does not report an error anymore. I really confused &

Re: [SQL] Log, Logs and more Logs

redirect_stderr = on and then restart the server. It should show up the log from then onwards --- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 1/31/07, Ezequias Rodrigues da Rocha < [EMAIL PROTECTED]> wrote: > > I really don't know how to set it. I created my

Re: [SQL] Log, Logs and more Logs

uring of stderr into log # files Ezequias 2007/1/31, Joe <[EMAIL PROTECTED]>: On Wed, 2007-01-31 at 10:12 -0200, Ezequias Rodrigues da Rocha wrote: > I restart the server but the pg_log folder doesn't appears. > > My log session is like this on postgresql

Re: [SQL] Log, Logs and more Logs

/1/31, Shoaib Mir <[EMAIL PROTECTED]>: You need to create the folder manually, give the postgres user permission for write on it and then restart the database server. This way you should be able to set the log files in pg_log folder... Shoaib Mir EnterpriseDB (www.enterprisedb.com)

Re: [SQL] Log, Logs and more Logs

# output. 0 to disable. Regards... Ezequias 2007/1/31, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]>: It was commented. Thank you Shoaib Mir I must restart my server ? Ezequias 2007/1/31, Shoaib Mir < [EMAIL PROTECTED]>: > > Check for log_directory setting in your postgre

Re: [SQL] Log, Logs and more Logs

It was commented. Thank you Shoaib Mir I must restart my server ? Ezequias 2007/1/31, Shoaib Mir <[EMAIL PROTECTED]>: Check for log_directory setting in your postgresql.conf file... - Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 1/31/07, Ezequias Rodrigues da Rocha &

Re: [SQL] Log, Logs and more Logs

tgres45 Jan 31 08:36 postmaster.pid [EMAIL PROTECTED] data]# Can someone tell me how to solve this kind of problem ? Ezequias 2007/1/30, Andrew Sullivan <[EMAIL PROTECTED]>: On Tue, Jan 30, 2007 at 04:41:13PM -0200, Ezequias Rodrigues da Rocha wrote: > So you are tell me that it

Re: [SQL] Log, Logs and more Logs

-0200, Ezequias Rodrigues da Rocha wrote: > I know there are many logs in postgresql but I don't have many > familiarity with all them. It's not totally plain what you want to have happen -- whether you want all queries, whether you merely want ERRORs to show up in your logs, or whethe

[SQL] Log, Logs and more Logs

postgresql but I don't have many familiarity with all them. Any help would be glad. Regards ... -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincerely) Ezequias Rodrigues da

[SQL] Linked Databases

iosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das democracias ainda é melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequi

[SQL] Odbc configuration on Localhost

(Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das democracias ainda é melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http

[SQL] Schema sample

... -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das democracias ainda é melhor do que a melhor das ditaduras The worst of democracies is still better than the better

[SQL] Changing point for commas and commas for point

o make this happens ? Regards -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das democracias ainda é melhor do que a melhor das ditaduras The worst of de

Re: [SQL] Grants

ors; Still the same problem. :( 2006/11/30, imad <[EMAIL PROTECTED]>: You did not grant access privileges to schema. Also GRANT administrators on the base schema as you did for the table. --Imad www.EnterpriseDB.com On 12/1/06, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote: &g

[SQL] Grants

Hi list, I am having problem with grants and users on PostgreSQL. I am using pgAdmin to connect like other user to test my permissions. As the owner of the database I have criated two roles: administrators (cannot connect) ezequias (can connect) I give permissions to a table I have: GRANT SEL

Re: [SQL] Select (1-3)

Uow ! 1 to one m select * from generate_series(1, 100); In 5203 miliseconds (that's a great performmance). My server is not quite good but the performance was great for me. Thank you so much Ezequias 2006/11/30, Aaron Bono <[EMAIL PROTECTED]>: On 11/30/06, Ezequias Rodrigu

[SQL] Select (1-3)

(Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das democracias ainda é melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http

Re: [SQL] Autovaccum

Just a little question. What is the interval of time the vacuum will run on my database ? Ezequias 2006/11/30, Matthew T. O'Connor : Ezequias Rodrigues da Rocha wrote: > It is possible to set this up on PgAdmin ? I don't know. > I need to shutdown the postgresql servic

Re: [SQL] Autovaccum

D]> wrote: > Ezequias Rodrigues da Rocha wrote: > > Hi list, > > > > I would like to know if it is necessary to set my database to > > autovaccum if the intent of my DB Manager is do not make any deletion > > in any time. > > > > If there is no deletions why

[SQL] Autovaccum

Hi list, I would like to know if it is necessary to set my database to autovaccum if the intent of my DB Manager is do not make any deletion in any time. If there is no deletions why autovaccum ok ? Regards Ezequias ---(end of broadcast)--- TIP

[SQL] PgAgent [where is it?]

gards ... -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das democracias ainda é melhor do que a melhor das dita

[SQL] Numbers

) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das democracias ainda é melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com

Re: [SQL] Random()

real random (used like lottery). Regards Ezequias 2006/11/16, A. Kretschmer <[EMAIL PROTECTED]>: am Thu, dem 16.11.2006, um 16:31:14 -0200 mailte Ezequias Rodrigues da Rocha folgendes: > Hi list, > > I have a bigint collumn and I would like to generate a random number within the &g

Re: [SQL] Random()

Thank you so much andreas. Regards http://ezequiasrocha.blogspot.com 2006/11/16, A. Kretschmer <[EMAIL PROTECTED]>: am Thu, dem 16.11.2006, um 16:31:14 -0200 mailte Ezequias Rodrigues da Rocha folgendes: > Hi list, > > I have a bigint collumn and I would like to generate

[SQL] Random()

Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das democracias ainda é melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com/

[SQL] Apoie o estudo das células tronco

Visitem: http://www.michaeljfox.org/ http://www.youtube.com/watch?v=DKVfsjIp98w =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha

Re: [SQL] Between and miliseconds (timestamps)

n Fri, 2006-11-10 at 16:34 -0200, Ezequias Rodrigues da Rocha wrote: > Ok thank you very much, but the suggestion (SQL:when field => '2006-09-06'::date) does not retrieve any row. It does not retrive any> error too, but the suggestion does not applied to my requisition. I think

Re: [SQL] Between and miliseconds (timestamps)

st regards to bothEzequias2006/11/10, A. Kretschmer < [EMAIL PROTECTED]>:am  Fri, dem 10.11.2006, um 12:50:38 -0200 mailte Ezequias Rodrigues da Rocha folgendes: > > select * from base.table> > where when> > between> > '2006-09-06 00:00: 00.00&#

[SQL] Between and miliseconds (timestamps)

00:00:00.00' and'2006-09-06 23:59:59.99'order by 2Is there a simplest way or not ? =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-   Atenciosamente (Sincerely)    Ezequia

[SQL] Groups and Roles and Users

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-  Atenciosamente (Sincerely)Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das democracias ainda é melhor do que a melhor das ditadurasThe worst of democracies is still better than the better

Re: [SQL] Round Numeric Type

Numeric(9,2)2006/10/31, Andrew Sullivan <[EMAIL PROTECTED]>: On Tue, Oct 31, 2006 at 05:35:17PM -0200, Ezequias Rodrigues da Rocha wrote:> Hi list,>> I did a trigger to update a points on a table but in some cases the> PostgreSQL does a round of my Numeric like. >> If >

[SQL] Round Numeric Type

Hi list,I did a trigger to update a points on a table but in some cases the PostgreSQL does a round of my Numeric like.If >= 0.5 so postgresql puts 1If < 0.5 so postgresql puts 0Did anybody knows if it is possible to control this matter ? RegardsEzequias

[SQL] Too much time to delete 19000 rows

-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-  Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-A pior das democracias ainda é melhor do que a melhor das ditadurasThe worst of democracies is still better than the better of dictatorships http

[SQL] On Rollback my sequency does not back the initial value

t ?Regards ...-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-  Atenciosamente (Sincerely)     Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-A pior das democracias ainda é melhor do que a melhor das ditadurasTh

[SQL] How to overwrite a table [only data]?

Is it correct ? Regards...-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-  Atenciosamente (Sincerely)    Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-A pior das democr

[SQL] Doubt with Joins

" ? (event e and session s)It is a case of an outer join ? What should I do if I only have a cli.Nome parameter passed ?I don't know I I made myself clear.RegardsEzequias-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-        

Re: [SQL] Populating using Select

Thank you very much Andrew. Now I learned.Best regardsFrom BrazilEzequias R. da Rocha2006/9/26, Andrew Sullivan <[EMAIL PROTECTED] >:On Tue, Sep 26, 2006 at 09:35:18AM -0300, Ezequias Rodrigues da Rocha wrote: > I was trying to make something like this:>> Insert into base.nei

[SQL] Populating using Select

base.clients).I didn't try it but I suppose it will not work.Regards ...-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-   Atenciosamente (Sincerely)    Ezequias Rodrigues da

[SQL] Group by minute

UP BY to_char(quando,'dd/MM/ HH24:MI')order by 1Regards ...-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-   Atenciosamente (Sincerely)         

[SQL] Count and list only where count is bigger than 1

o do ?Regards ...-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-   Atenciosamente (Sincerely)    Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-A pior das democracias a

[SQL] Borland Database Engine assumes Varchar(255) as Memo

gards ...-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-  Atenciosamente (Sincerely)     Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-A pior das democracias ainda é melhor do que a melho

[SQL] Mac Address

quias-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-   Atenciosamente (Sincerely)    Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-A pior das democracias ainda é melhor d

  1   2   >