[SQL] Installing with libs of postgresql-libs

postgresql-libs-8.2.3-1PGDG.i686.rpm but I do not have the adm permissions. Any help would be glad Ezequias ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[SQL] Shared Buffers

Hi list, It is possible to find out how many of shared buffers a SQL Statement used ? I suppose my server is quite good and i am not using all it can give me. Any sugestion ? ps: My larger table has half million records. Ezequias ---(end of broadcast

Re: [SQL] Regular Expressions

t'. The commas, spaces and numbers could be forgive. I hope you could help me Regards Ezequias Em Wed, 21 Mar 2007 14:32:26 -0600 Guy Fraser <[EMAIL PROTECTED]> escreveu: On Wed, 2007-03-21 at 14:37 -0300, Ezequias R. da Rocha wrote: Guy Fraser escreveu: > On Wed, 2007-03-21 at 11:0

Re: [SQL] Regular Expressions [progress]

d someone help me in this crusade ? Regards Ezequias Em Tue, 27 Mar 2007 15:16:10 -0700 (PDT) Richard Broersma Jr <[EMAIL PROTECTED]> escreveu: Could you give me a hand ? I have a ZipCode table and my address table I just would like to find out all matches that my zipcode table has where

[SQL] Empty Table

Hi list, I have many tables with many constraints and I would like to empty all my tables. There is any simple way to do it ? I have pgAdmin here but not psql. Any help would be glad. Regards Ezequias -- Ezequias Rodrigues da Rocha ---(end of broadcast

Re: [SQL] Empty Table

when I restore from one database with a name to other with another name ? Regards Ezequias Em Thu, 29 Mar 2007 23:46:31 +0530 "Rajesh Kumar Mallah" <[EMAIL PROTECTED]> escreveu: psql> TRUNCATE TABLE ; if you have too many tables , generate the above commands by

[SQL] Maxusers MaxConnections

user spent in the server (just by the fact of been connected) ? Regards, -- Ezequias Rodrigues da Rocha ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[SQL] CPU statistics

Hi list, It is possible to retrieve information about the server hardware via postgreSQL ? Regards, -- Ezequias Rodrigues da Rocha ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[SQL] Setting high performance on huge server

ffers used by the server." "max_connections";"100";"Sets the maximum number of concurrent connections." "work_mem";"1MB";"Sets the maximum memory to be used for query workspaces." -- Ezequias Rodrigues da Rocha -

[SQL] LOG: unexpected EOF on client connection

xpected EOF on client connection LOG: unexpected EOF on client connection LOG: unexpected EOF on client connection LOG: unexpected EOF on client connection Does anyone have any suggestion ? -- Ezequias Rodrigues da Rocha http://ezequiasrocha.blogspot.com ---(end of broa

[SQL] ERROR: column "crc" does not exist

this e-mail allways appears. Any help would be great. Regards, -- Ezequias Rodrigues da Rocha http://ezequiasrocha.blogspot.com ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if y

[SQL] Triggers

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

getCardId(number: varchar)     Best regards ... Ezequias

[SQL] Trigger with Stored Procedure [Client Points]

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

[SQL] Error on function parameters

boolean What I did wrong ?Please help me.-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-   Atenciosamente (Sincerely)Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-A pior das democracias ainda é melhor do que a melhor das ditaduras The worst of dem

[SQL] ERROR: SELECT query has no destination for result data

s" line 17 at SQL statement What I did wrong ? Any suggestion is quite good please.ps: -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-      Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-

[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

[SQL] Mac Address

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

[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] 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] Group by minute

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

[SQL] Populating using Select

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

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

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

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

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

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

[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

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&#

Re: [SQL] Between and miliseconds (timestamps)

Great Joe. That is what I want.Now I can do a simple select (with between) statement.Now my query that works is:select * from base.tb1 where date(tm) between '2006-09-05' and '2006-09-06' order by 1Thank you very much Joe2006/11/10, Joe <[EMAIL PROTECTED] >:Hi Ezequias,O

[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()

Hi list, I have a bigint collumn and I would like to generate a random number within the numbers of my column. Is it possible ? =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Atenciosamente (Sincerely) Ezequias

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

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

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

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

[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

It is possible to set this up on PgAdmin ? I need to shutdown the postgresql service to change this parameters ? ps: Your information was very clear for me. Thank you very much. Ezequias 2006/11/30, Peter Childs <[EMAIL PROTECTED]>: On 30/11/06, Alvaro Herrera <[EMAIL PROTECTE

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

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

[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

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

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

Re: [SQL] Log, Logs and more Logs

So you are tell me that it is impossible to retrieve it ok ? Just by changing this values (what I did now) it is possible to get the error messages and their statements OK?. My best Regards Ezequias 2007/1/30, Andrew Sullivan <[EMAIL PROTECTED]>: On Tue, Jan 30, 2007 at 03:01:05PM

[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

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

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

# 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

this return: ERROR: insert or update on table "bil" violates foreign key constraint "fkf97242b3fa73a07c" SQL state: 23503 Detail: Key (xxx_id)=(20) is not present in table "ctrac". But the log files doesn't appears on my server. Any help Ezequias 2007

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

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, Shoaib Mir <[EMAIL PROTECTED]>: You need to set it like this: log_destination = 'syslog,stderr'

Re: [SQL] Log, Logs and more Logs

Thank you Shoiab, Now everything is working like I desire. Thank you all very much. I am notthing without Postgresql community. Ezequias 2007/1/31, Shoaib Mir <[EMAIL PROTECTED]>: No problemo :) What was the query and the statement for error? that way we might be able t

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

[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

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

Re: [SQL] Duplicate records

Thank you but are you talking of two tables ? I intent to check in only one table. Please explain to me. Ezequias 2007/2/2, Bart Degryse <[EMAIL PROTECTED]>: select * from mytable A, (select field1, field2, count(*) from mytable group by field1, field2 having count(*) > 1) B where

Re: [SQL] Duplicate records

You are correct. Sorry my mistake. The SQL statement is correct and I find the duplicate records. ps: I just think postresql could make this easyly. Don't you think ? Any function or anything else. Thank you so much. Ezequias 2007/2/2, Shoaib Mir <[EMAIL PROTECTED]>: Where do

[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

[SQL] Open a Transaction

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

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

Re: [SQL] Open a Transaction

I increase the "max_stack_depth" and the In statemen run OK. I don't know if it is good to put this variable as big as possible or as the manual report (using ulimit -s) to put the larger stack capacity of Operational System. Ezequias 2007/2/8, Andrew Sullivan <[EMAIL PRO

[SQL] Have anyone this man e-mail ?

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

[SQL] Password Policy

? Regards ... Ezequias

[SQL] Sum sets of records

with all records with type W ? Is it possible ? Ezequias

[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

Re: [SQL] [ADMIN] Deadlock on transaction

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 ? Ezequias 2007/2/12, Scott Marlowe <[EMAIL PROTECTED]>: On Mon, 2007-02-12 at 11:43, Ezequ

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

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', 

[SQL] Retrieving 'Credit' when 'C'

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

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] 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'

Perfect, I learn this lesson now. This case is quite good. My Best Regards Ezequias 2007/2/15, Phillip Smith <[EMAIL PROTECTED]>: SELECT when, CASE WHEN type = 'C' THEN 'Credit' END AS type FROMmytable; Assuming your column names are actually &q

[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

[SQL] Insert based in a select

330 It is possible to make this insert based in all records of my master table ? Any help would be very welcomed. Best Regards Ezequias ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at

[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.blogspo

Re: [SQL] Insert based in a select

The second statement works but only 1 row was affected. It do not apply to me. The first statement i didn't understand. You are adding only the first field on my base.ingresso table ? Regards Ezequias 2007/2/25, Phillip Smith <[EMAIL PROTECTED]>: (Please reply to the list wh

Re: [SQL] Insert based in a select

My best regards Ezequias 2007/2/25, Phillip Smith <[EMAIL PROTECTED]>: Apologies – the first statement should have included the column name to insert to: INSERT INTO base.ingresso (id_column) (SELECT id FROM base.cartao ORDER BY id) That will insert one row in ingresso for each row in c

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

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] Case with Char(1)

#x27;other' END FROM test; a | case ---+--- A | one B | two C | other I know from all program languages that case do not apply to noun sequencialiable (if this word exists) variable (like integers etc). Any help would be greatfull. Thanks in advance Ezequias --

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

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

John, That was what I was looking for for a long time. Now I will change my teller password account to md5. Could someone suggest me how to change all passwords (PLAIN) to md5 ? My real best regards Ezequias 2007/3/1, John DeSoi <[EMAIL PROTECTED]>: MD5 is built-in to PostgreSQL. It i

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

I am just passing the database owner password (postgresql autentication) to the statement: Select md5('the password I have in my mind') and compare with the password pgAdmin3 shows me. They are completely different. Ezequias 2007/3/1, Bart Degryse <[EMAIL PROTECTED]>: It

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

[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

I preffer that the database give me this information. I don't know if it is possible becouse if we retrieve many rows and if we want to put this result in a new column the same time will be replicated many times and consuming more processing. Any other suggestion ? Ezequias 2007/3/6,

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

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

  1   2   >