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

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

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

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

Thank you very much Joe. Ezequias Joe escreveu: Hi Ezequias, On Thu, 2007-03-22 at 16:43 -0300, Ezequias R. da Rocha wrote: I must use a select * from some table but i must do a join and it must be in the were clause. I can't put select * from tabel1 as tb1, table2 as tb2 where t

[SQL] Dummy question

th columns (all columns) of both tables. ps: I don't want to put all fields names too. Can someone tell me if there is any way to put on the select only the fields of my first table ? Regards... -- Atenciosamente Ezequias Rodrigues da Rocha ---(e

Re: [SQL] Subqueryes

Perfect quite nice. I am doing things that I could not believe I could do without the community. Thank you so much. -- Atenciosamente Ezequias Rodrigues da Rocha Richard Broersma Jr escreveu: update myTable set date = (current_date + (Select daysToAdd from base.Table1 where myFKey_id

[SQL] Subqueryes

+ (Select daysToAdd from base.Table1 where myFKey_id = Table1Id) ) where Expire_Date = now()::Date; -- Atenciosamente Ezequias Rodrigues da Rocha ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choos

Re: [SQL] Regular Expressions

Guy Fraser escreveu: On Wed, 2007-03-21 at 11:04 -0300, Ezequias R. da Rocha wrote: Hi list, I would like to know if postgresql has a Regular Expressions (Regex) implemented already. With it we could implement queries like Select * from myClientes where name = 'E[zs]equias'

[SQL] Regular Expressions

Hi list, I would like to know if postgresql has a Regular Expressions (Regex) implemented already. With it we could implement queries like Select * from myClientes where name = 'E[zs]equias' where the result occurs even if the field has Ezequias or Esequias. Regard

[SQL] Encode

Hi list, It is possible to change the Encode of one database while it is on ? Sincerely Ezequias ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[SQL] Maintence DB

Hi list, Could someone tell me in a simple way what does Maintence DB means ? Regards Ezequias ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [SQL] [ADMIN] [GENERAL] PgAgent logging verbosity

Ok I will use only on error ok ? -l 0 :) Thank you Dave Page escreveu: Ezequias Rodrigues da Rocha wrote: 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

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

scricao) VALUES ('2007-03-13 10:20:20','CardPass'); And it was in: 19485ms Great don't you ? Ezequias Alvaro Herrera escreveu: Ezequias R. da Rocha wrote: Thank you all. The function from Jonah solves my problem. Just a simple question: One million of inserct

Re: [SQL] For loop

Thank you all. The function from Jonah solves my problem. Just a simple question: One million of inserctions in *28,8* seconds with this kind of data (timestamp|character varring (50)) is a good performance ? I let my questions to DBAs from PostgreSQL. Sincerely Ezequias Adrian Klaver

[SQL] For loop

Hi list, I would like to test the power of processing of postgresql (and my server) by insert a large ammount of data on a table I have. I would like to know how to implement a For... loop . With it I think I could check the real power of my server. Ezequias

Re: [SQL] For loop

I quetion one more time. I must have a function ? Isn't another way to implement it without using functions ? Ezequias Bart Degryse escreveu: Please post your complete CREATE FUNCTION statement. Error code 42601 refers to some syntax error which probably occurs just before you start lo

Re: [SQL] For loop

QL state: 42601 Character: 1 I installed the pgsql but I don't think it is a problem of language. What could be wrong ? I am not using functions too. I am using the SQL tool of PgAdmin III. Any help would be glad. Ezequias Bart Degryse escreveu: As you can see in the manual (http://www.

Re: [SQL] For loop

Ezequias R. da Rocha escreveu: Hi list, I would like to test the power of processing of postgresql (and my server) by insert a large ammount of data on a table I have. I would like to know how to implement a For... loop . With it I think I could check the real power of my server. Ezequias

[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

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

Thank you all. Those are quite important questions to considerate. About the late time of requisitions. I allways have replyes becouse 3:00 am in brazil does not means 3:00 in many other countries. I experiment it in other free communities too. My Brat Regards Ezequias 2007/3/9, Frank Bax

[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

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,

[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

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

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

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

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

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

[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

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

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

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

[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

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

[SQL] Password Policy

? Regards ... Ezequias

[SQL] Have anyone this man e-mail ?

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

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

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

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

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

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

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

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

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

# 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

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

[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

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

  1   2   >