Your message dated Mon, 29 Jun 2009 09:39:50 +0000
with message-id <[email protected]>
and subject line Bug#531034: fixed in pgloader 2.3.2-1
has caused the Debian Bug report #531034,
regarding pgloader: --from does not work
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
531034: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=531034
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: pgloader
Version: 2.3.1-2
Severity: normal
the manpage says:
"-F, --from
Input line number from which we begin to process (and
count). pgloader will skip all preceding lines."
but it seems --from does not work:
pgloader.conf:
[pgsql]
host = localhost
port = 5432
base = jens
user = jens
pass = None
log_file = /tmp/pgloader/pgloader.log
log_min_messages = DEBUG
client_min_messages = WARNING
#lc_messages = C
;client_encoding = 'utf-8'
client_encoding = 'latin1'
copy_every = 5
commit_every = 5
#copy_delimiter = %
null = ""
empty_string = "\ "
max_parallel_sections = 4
[csv]
table = test
format = csv
filename = test.csv
field_sep = ,
quotechar = "
columns = name, id
==
simple test table:
jens=> \d test
Tabelle »public.test«
Spalte | Typ | Attribute
--------+-------------------+-----------
id | integer |
name | character varying |
==
j...@thialfi:/tmp/pgloader$ pgloader --from=2 csv
csv WARNING COPY error, trying to find on which line
csv WARNING COPY data buffer saved in
/tmp/test.4c1khr.pgloader
csv WARNING COPY error recovery done (1/1) in 0.038s
csv ERROR 1 errors found into [csv] data
csv ERROR please read /tmp/csv.rej.log for errors log
csv ERROR and /tmp/csv.rej for data still to process
csv ERROR 1 database errors occured
j...@thialfi:/tmp/pgloader$ cat test.csv
name,id
"dkdkdk,kkk",40
j...@thialfi:/tmp/pgloader$ cat /tmp/csv.rej.log
COPY error: FEHLER: ungültige Eingabesyntax für ganze Zahl: »id«
CONTEXT: COPY test, Zeile 1, Spalte id: »id«
(sorry for the german texts but
"lc_messages = C"
did not work - maybe another bug report?
j...@thialfi:/tmp/pgloader$ export LC_ALL=C; pgloader -F2 csv
Exception in thread csv:
Traceback (most recent call last):
File "/usr/lib/python2.5/threading.py", line 486, in __bootstrap_inner
self.run()
File "/var/lib/python-support/python2.5/pgloader/pgloader.py", line
822, in run
self._postinit()
File "/var/lib/python-support/python2.5/pgloader/pgloader.py", line
212, in _postinit
self.db.reset()
File "/var/lib/python-support/python2.5/pgloader/db.py", line 215, in
reset
self.set_lc_messages()
File "/var/lib/python-support/python2.5/pgloader/db.py", line 149, in
set_lc_messages
raise PGLoader_Error, e
PGLoader_Error: FEHLER: keine Berechtigung um Parameter �lc_messages�
zu setzen
or maybe I would have to grant some rights?)
-- System Information:
Debian Release: 5.0.1
APT prefers stable
APT policy: (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.26-1-amd64 (SMP w/2 CPU cores)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages pgloader depends on:
ii python 2.5.2-3 An interactive high-level object-o
ii python-psycopg 1.1.21-17 Python module for PostgreSQL
ii python-psycopg2 2.0.7-4 Python module for PostgreSQL
pgloader recommends no packages.
pgloader suggests no packages.
-- no debconf information
--- End Message ---
--- Begin Message ---
Source: pgloader
Source-Version: 2.3.2-1
We believe that the bug you reported is fixed in the latest version of
pgloader, which is due to be installed in the Debian FTP archive:
pgloader_2.3.2-1.diff.gz
to pool/main/p/pgloader/pgloader_2.3.2-1.diff.gz
pgloader_2.3.2-1.dsc
to pool/main/p/pgloader/pgloader_2.3.2-1.dsc
pgloader_2.3.2-1_all.deb
to pool/main/p/pgloader/pgloader_2.3.2-1_all.deb
pgloader_2.3.2.orig.tar.gz
to pool/main/p/pgloader/pgloader_2.3.2.orig.tar.gz
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Dimitri Fontaine <[email protected]> (supplier of updated pgloader package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.8
Date: Mon, 29 Jun 2009 09:39:33 +0200
Source: pgloader
Binary: pgloader
Architecture: source all
Version: 2.3.2-1
Distribution: unstable
Urgency: low
Maintainer: Dimitri Fontaine <[email protected]>
Changed-By: Dimitri Fontaine <[email protected]>
Description:
pgloader - loads flat data files into PostgreSQL
Closes: 531034
Changes:
pgloader (2.3.2-1) unstable; urgency=low
.
* Implement --from support in all readers (Closes: #531034)
* Use psycopg cursor.copy_expert() when available (> 2.0.6)
* FIX fixedreader: it now know about -C
* FIX Round Robin Reader with respect to offsets in readlines()
* support python 2.3 if not using RRR (not importing collections.deque)
* change logger initialisation to support python 2.3
* FIX bad usage of STDERR in the code
* Implement skip_head_lines option in configuration (superseded by -F)
* Do not sort() section list when it's been given on command line
* Catch InterfaceError when trying to close connection
Checksums-Sha1:
8317078adad58d83ac80ef00c4b94b63cf153499 1077 pgloader_2.3.2-1.dsc
06b663070950faca559d7920bbf34256a2c29c2a 86200 pgloader_2.3.2.orig.tar.gz
661040df8bf33e4daabe08df70c6f8550c53b169 3995 pgloader_2.3.2-1.diff.gz
39e3c9f1ff6c67fef97d659015560290dd2563b8 57622 pgloader_2.3.2-1_all.deb
Checksums-Sha256:
36c8bfc49c2be313075bc89f48391bd90e0f6938029747bc499af7a670977069 1077
pgloader_2.3.2-1.dsc
43dfd6f94ba021d7bfa0668995952435a3f150d2fab073552a7779bb45f76980 86200
pgloader_2.3.2.orig.tar.gz
185052f8d7085b3ec70710624b116301139320acd418bb7758065b948a21be34 3995
pgloader_2.3.2-1.diff.gz
b4285b682d7850bce88062e696886d973cdcbcfbb319ec8ffd396513457894f9 57622
pgloader_2.3.2-1_all.deb
Files:
392f6bb4bb3da49c50ae14fd01f0bbd1 1077 misc extra pgloader_2.3.2-1.dsc
cbc549d8ed2b88ad0ddc1c0cff3efc3e 86200 misc extra pgloader_2.3.2.orig.tar.gz
6f5fcfcda66ae851a9b2ebb902ac135f 3995 misc extra pgloader_2.3.2-1.diff.gz
8ad37f5be063f172085f4e7427132d86 57622 misc extra pgloader_2.3.2-1_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
iEYEARECAAYFAkpIdUcACgkQpGK1HsL+5c3q8wCg2PCJPh7+thu3tUcMFtdMm4pV
/AUAnAlRZqG9Rc7PEzxV2BntAuLvDLQr
=79bL
-----END PGP SIGNATURE-----
--- End Message ---
