[SQL] PgAdmin 1.6.2 crashes when resize the collumn

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/

[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/ use

[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] [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 created like this. Actually

[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.blogspot.com/ use

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 PROTECTED] wrote: Insert

[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

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 pgCrypto. Now I have more than

[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] 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 not be the *only

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 [EMAIL PROTECTED] wrote

Re: [SQL] SHA-1 vs MD5

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]: On 3/7/07

[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 Rocha

[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] Time of executed query

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 time of a SQL statement leads to execute ? I would like

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 Rocha http

[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] Inc

Thank you but I must inc an specific row. How to do that ? Ezequias 2007/3/6, Richard Huxton dev@archonet.com: 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 incrementes

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 [EMAIL PROTECTED] wrote: Thank

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 dev@archonet.com: Ezequias Rodrigues da Rocha wrote: Thank you but I must inc

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

8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincerely) Ezequias Rodrigues

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 [EMAIL PROTECTED] 2007-03-01 15:08 John

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 so much. Ezequias

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

5f4dcc3b5aa765d61d8327deb882cf99 current_usermd5 logstocksys 5f4dcc3b5aa765d61d8327deb882cf99 Show us some statements. Ezequias Rodrigues da Rocha [EMAIL PROTECTED] 2007-03-01 16:02 Just another thing. Why md5 function return a different string from user role of postgresql ? It allways put

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 password (postgresql autentication

[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] 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 problems to formate the SQL statement

[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

Re: [SQL] Position of a field

) 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 in a table. I am seen

Re: [SQL] Insert based in a select

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- *From:* Ezequias Rodrigues da Rocha [mailto

Re: [SQL] Insert based in a select

-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 The second statement works but only 1 row

[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

[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/

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

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 PROTECTED] *On Behalf Of *Ezequias Rodrigues da Rocha *Sent

[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:

[SQL] Retrieving 'Credit' when 'C'

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

[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

[SQL] Deadlock on transaction

with it ? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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] [ADMIN] Deadlock on transaction

) 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] [ADMIN] Deadlock on transaction

2007/2/12, Richard Huxton dev@archonet.com: 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

da Rocha wrote: 2007/2/12, Richard Huxton dev@archonet.com: 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

[SQL] Have anyone this man e-mail ?

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

[SQL] Open a Transaction

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

Re: [SQL] Open a Transaction

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 this statement ? Start

Re: [SQL] Open a Transaction

, 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 technology doesn't work is no bar to success

[SQL] Insert into a date field

this: '1963-09-01' '1963-09-01'::date 1963-09-01 And notthing Thanks in advance. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha

[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

Re: [SQL] Insert into a date field

; a 1963-09-01 (1 row) -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 2/2/07, Richard Huxton dev@archonet.com wrote: Ezequias Rodrigues da Rocha wrote: Hi list, I am trying to insert a record in a table with a date field but the postgresql reports me the following

Re: [SQL] Duplicate records

= 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 fields of my table. Any help would be welcomed

Re: [SQL] Duplicate records

by field1, field2 having count(*) 1) B where 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

[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] Log, Logs and more Logs

45 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 is impossible

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 [EMAIL

Re: [SQL] Log, Logs and more Logs

. 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 postgresql.conf file... - Shoaib Mir

Re: [SQL] Log, Logs and more Logs

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) On 1/31/07, Ezequias Rodrigues da Rocha [EMAIL

Re: [SQL] Log, Logs and more Logs

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.conf: # These are only used

Re: [SQL] Log, Logs and more Logs

= 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 pg_log on: /var/lib/pgsql/data

Re: [SQL] Log, Logs and more Logs

... - 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 now. Any suggestion ? Ezequias 2007/1/31

[SQL] Linked Databases

) 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] Log, Logs and more Logs

, 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 whether you want only ERRORS

[SQL] Log, Logs and more Logs

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

[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

-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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

Re: [SQL] Grants

. :( 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: Hi list, I am having problem with grants

[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

Re: [SQL] Autovaccum

: 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 autovaccum ok ? You need to vacuum from time to time anyway, even if you

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 matthew@zeut.net: Ezequias Rodrigues da Rocha wrote: It is possible to set this up on PgAdmin ? I don't know. I need to shutdown the postgresql service

[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] 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 Rodrigues da Rocha

[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

[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

[SQL] PgAgent [where is it?]

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

[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

[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/

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 a random number within

Re: [SQL] Random()

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 numbers of my column

Re: [SQL] Between and miliseconds (timestamps)

-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 you want to cast the field, not the constant, e.g

[SQL] Between and miliseconds (timestamps)

:00.00' and'2006-09-06 23:59:59.99'order by 2Is there a simplest way or not ? =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Atenciosamente (Sincerely)Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-A pior das

Re: [SQL] Between and miliseconds (timestamps)

to bothEzequias2006/11/10, A. Kretschmer [EMAIL PROTECTED]:amFri, 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' and '2006-09-06 23:59:59.99' order by 2 Is there a simplest way

[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 of dictatorships http://ezequiasrocha.blogspot.com/

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 = 0.5 so postgresql puts 1 If 0.5 so

[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

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://ezequiasrocha.blogspot.com/

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

...-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-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

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

. Is it correct ? Regards...-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Atenciosamente (Sincerely)Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-A pior das democracias ainda é melhor do que a melhor das ditadurasThe worst

[SQL] Doubt with Joins

parameter passed ?I don't know I I made myself clear.RegardsEzequias-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-A pior das democracias ainda é

[SQL] Populating using Select

base.clients).I didn't try it but I suppose it will not work.Regards ...-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Atenciosamente (Sincerely)Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-A pior das democracias ainda é

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.neigborhood values (nextval

[SQL] Group by minute

/ HH24:MI')order by 1Regards ...-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Atenciosamente (Sincerely)Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-A pior das democracias ainda é melhor do que a melhor das

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

...-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-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

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

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

[SQL] Mac Address

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

[SQL] Checking types

Hi list,I would like to check if the types passed are of the same time of my declaration and not report an error.Is that possible ?How to do that ?is there any statement like is numeric or is varchar(12) ? RegardsEzequias

[SQL] How to get the row that start a trigger

-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-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] Function to retrieve the Id column

Hi list, I have Id field that is used in all my database but my more often used parameter is a column called number that I have in more than 5000 magnetic cards, my question is. How could I make a function to retrieve this Id just passing the number as parameter, just like: getCardId(number:

[SQL] Triggers

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://ezequiasrocha.blogspot.com/