2013/3/13 Alexander Farber alexander.far...@gmail.com:
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,
Thank you -
On Thu, Mar 14, 2013 at 10:40 AM, Ian Lawrence Barwick
barw...@gmail.com 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
2013/3/14 Alexander Farber alexander.far...@gmail.com:
Thank you -
On Thu, Mar 14, 2013 at 10:40 AM, Ian Lawrence Barwick
barw...@gmail.com 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
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
On Thu, 14 Mar 2013 15:24:45 +0400 Aln Kapa alnk...@gmail.com 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
Kirk Wythers kirk.wyth...@gmail.com 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)
On Wed, Mar 13, 2013 at 8:08 AM, Aln Kapa alnk...@gmail.com 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
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.
Hi,
No idea what happened, but fixed. Thanks for the report.
Regards, Devrim
René Romero Benavides ichbinr...@gmail.com 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é