Re: [GENERAL] Fedora 18 x86_64 repodata/repomd.xml: [Errno 14] curl#22 - "The requested URL returned error: 404 Not Found" on PostgreSQL 9.2

2013-03-14 Thread Devrim Gündüz
Hi, No idea what happened, but fixed. Thanks for the report. Regards, Devrim "René Romero Benavides" wrote: >Using the yum repository for PostgreSQL 9.2, does anybody know what >happened >to >http://yum.postgresql.org/9.2/fedora/fedora-18-x86_64/repodata/repomd.xml? > >-- >René Romero Benav

[GENERAL] Fedora 18 x86_64 repodata/repomd.xml: [Errno 14] curl#22 - "The requested URL returned error: 404 Not Found" on PostgreSQL 9.2

2013-03-14 Thread René Romero Benavides
Using the yum repository for PostgreSQL 9.2, does anybody know what happened to http://yum.postgresql.org/9.2/fedora/fedora-18-x86_64/repodata/repomd.xml? -- René Romero Benavides @iCodeiExist @PgsqlMx Postgresql Tips en español para la comunidad de México e Hispanoamérica. http://postgresql.

Re: [GENERAL] Do not understand why this happens

2013-03-14 Thread Vick Khera
On Wed, Mar 13, 2013 at 8:08 AM, Aln Kapa wrote: > 2013-03-10 14:27:43 19797 LOG: could not receive data from client: > Connection reset by peer > 2013-03-10 14:27:43 19797 LOG: unexpected EOF on client connection > > Tell me what's the problem? > Your client closed the socket without cleanly

Re: [GENERAL] big un stacking query - help save me from myself

2013-03-14 Thread Kevin Grittner
Kirk Wythers wrote: > I hace a fairly large table with two columns that I need to > "de-normalize" (235 million rows) There has got to be a better > (i.e. faster) approach than what I am doing. I am using a MAX > CASE on each of the 24 variables (column names variable and > value) that I want to

Re: [GENERAL] Do not understand why this happens

2013-03-14 Thread Bill Moran
On Thu, 14 Mar 2013 15:24:45 +0400 Aln Kapa wrote: > > I connect to the database using the PGDAC, and then send a NOTIFY to > myself every minute. In this case, the logs get that. > > 2013-03-10 10:34:36 19797 LOG: process 19797 still waiting for > AccessExclusiveLock on object 0 of class 1262

[GENERAL] Do not understand why this happens

2013-03-14 Thread Aln Kapa
HI. I connect to the database using the PGDAC, and then send a NOTIFY to myself every minute. In this case, the logs get that. 2013-03-10 10:34:36 19797 LOG: process 19797 still waiting for AccessExclusiveLock on object 0 of class 1262 of database 0 after 3000.100 ms 2013-03-10 10:34:36 19797 S

Re: [GENERAL] Using psql to feed a file line by line to a table column

2013-03-14 Thread Ian Lawrence Barwick
2013/3/14 Alexander Farber : > Thank you - > > On Thu, Mar 14, 2013 at 10:40 AM, Ian Lawrence Barwick > wrote: >>> I also have an INSERT trigger on my table, >>> can I return a NULL from it or something similar? >> >> Yes, if you test for the presence of the word you can return NULL >> and the row

Re: [GENERAL] Using psql to feed a file line by line to a table column

2013-03-14 Thread Alexander Farber
Thank you - On Thu, Mar 14, 2013 at 10:40 AM, Ian Lawrence Barwick wrote: >> I also have an INSERT trigger on my table, >> can I return a NULL from it or something similar? > > Yes, if you test for the presence of the word you can return NULL > and the row will be discarded. See example below. >

Re: [GENERAL] Using psql to feed a file line by line to a table column

2013-03-14 Thread Ian Lawrence Barwick
2013/3/13 Alexander Farber : > Thank you, this was indeed the > (uneeded) semicolon at end of the COPY line. > > May I ask another question - (...) > When I add few more words to my text file > and then try to load it into my table again, > then the COPY command will fail, > because of the already