Re: [GENERAL] Feature proposal

Le 25.08.2010 09:15, wstrzalka a écrit : I'm currently playing with very large data import using COPY from file. As this can be extremely long operation (hours in my case) the nice feature would be some option to show operation progress - how many rows were already imported. Or maybe there is s

Re: [GENERAL] recovery fail

Le 25.08.2010 15:15, Łukasz Bieniek a écrit : I'have made a backup my DB with pg_dump its (' pg_dump -U username dbname>backupfilename.sql.gz. When i want to restore it ( I drop the old database ,creaete new and language to it and i type a command 'cat backupfilename.sql.gz|gunzip|/usr/local/p

[GENERAL] Unable to stop postgresql ("failed") -> [SOLVED]

Dear all, For once, I will simply publish a solution instead of asking a question. Let's hope it will be useful to someone. I was unable to stop postgres, I always got "[FAILED] : * /etc/init.d/postgresql stop * service postgresql stop * /sbin/service postgresql stop The only solution that

Re: [GENERAL] Strange "bug" in dump ?

Rikard Bosnjakovic a écrit : >> There is a "E" before the street field ! >> >> This is an extract of the dump : >> >> 'ST311PHANIE ROBERT', NULL, E'RTE DES TATTES D\\''OIE 5', > > Sounds like escape quoting to me. You can read about it at >

[GENERAL] Strange "bug" in dump ?

Dear all, When doing a dump of a 8.1.17, database (that I have to reimport daily into a 7.4.6), I have a strange bugs with accents... First point, I had to add --insert. But there is still a problem with accents. If I say nothing the dump is utf8, or I can add -E=latin1. But in both cases it f

Re: [GENERAL] Invalid Page Header Error

Hello Richard, Just to keep you informed... Richard Huxton a écrit : >> We had a server crash and when restarting postgres it works, except some >> "Invalid Page Header Error" : > > Data corrupted on disk. Either: > 1. You have bad hardware > 2. You have disks lying about fsync > 3. You have fsy

[GENERAL] Invalid Page Header Error

Hello, We had a server crash and when restarting postgres it works, except some "Invalid Page Header Error" : I already try VACUUM / FULL / ANALYSE but same error Even when doing a pg_dumpall, we have this problem. $ pg_dumpall >/dev/null pg_dump: ERREUR: en-tête de page invalide dans le bloc

Re: [GENERAL] How to GRANT rights to modify a table ???

Denis BUCHER a écrit : > Tom Lane a écrit : >> "Raymond O'Donnell" writes: >>> On 12/09/2009 16:44, Denis BUCHER wrote: >>>> ERROR: must be the owner of the mytable relation >>> The clue is in the error message :-) GRANTing ALL doesn&#x

Re: [GENERAL] How to GRANT rights to modify a table ???

Hello, Tom Lane a écrit : > "Raymond O'Donnell" writes: >> On 12/09/2009 16:44, Denis BUCHER wrote: >>> ERROR: must be the owner of the mytable relation > >> The clue is in the error message :-) GRANTing ALL doesn't make them >> the own

Re: [GENERAL] How to GRANT rights to modify a table ???

Tom Lane a écrit : >>> ERROR: must be the owner of the mytable relation > >> The clue is in the error message :-) GRANTing ALL doesn't make them >> the owner of the object as well. > >> For that, you have to do something like >> ALTER TABLE mytable OWNER TO mycolleague; > > What might be

[GENERAL] How to GRANT rights to modify a table ???

Hello, A very annoying problem with Postgres is the following one : As postgres user, I give all rights to all objects of a database or schema to a colleague : GRANT ALL ON mytable TO mycolleague; But when he tries to modify something, even something really small like adding a column to a table

Re: [GENERAL] Strange "missing tables" problem

Tom Lane a écrit : > Denis BUCHER writes: >> Yes that's correct. Therefore my "problem" is the "normal" behavior of >> \dt. But "normal" means "expected". But I don't find it very >> secure/handy, because you expect to see a

Re: [GENERAL] Strange "missing tables" problem

Hello, Guillaume Lelarge a écrit : >> I have a strange problem since I moved some tables to a schema, some >> tables are missing from the list (with \d or \dt) but they are still >> present anyway ???! >> >> Example : >>> $ psql mybase >>> Bienvenue dans psql 8.1.17, l'interface interactive de

Re: [GENERAL] Strange "missing tables" problem

Hello Tom, Tom Lane a écrit : > Denis BUCHER writes: >> I really don't understand what's happening here ? > > "\dt customers" will show you the customers table that's visible > according to your search_path setting. Apparently schema "import

Re: [GENERAL] Strange "missing tables" problem

nd pg_catalog.pg_tables > tables, > do the proper rows come back? > > - Bill > >> -Original Message- >> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- >> ow...@postgresql.org] On Behalf Of Denis BUCHER >> Sent: Sunday, August 23

Re: [GENERAL] Strange "missing tables" problem

Hello, Wojtek a écrit : >> It's even more strange : >> > why, looks logical to me :) >> # \dt customers >>Liste des relations >> Schéma | Nom | Type | Propriétaire >> +-+---+-- >> rma| customers | table | postgres >> (1 ligne) >> > yo

Re: [GENERAL] Strange "missing tables" problem

nis > > Wojtek a écrit : >> hi, >> >> You may try checking: >> SELECT * FROM pg_catalog.pg_class WHERE relname = 'customers' >> SELECT * FROM pg_catalog.pg_tables WHERE tablename = 'customers' >> to what's the status of your table. >&

Re: [GENERAL] Strange "missing tables" problem

: > hi, > > You may try checking: > SELECT * FROM pg_catalog.pg_class WHERE relname = 'customers' > SELECT * FROM pg_catalog.pg_tables WHERE tablename = 'customers' > to what's the status of your table. > > Regards, > foo > > Denis BUCHER

Re: [GENERAL] Strange "missing tables" problem

Hello, Small correction to my previous email : > I have a strange problem since I moved some tables to a schema, some > tables are missing from the list (with \d or \dt) but they are still > present anyway ???! > > Example : >> $ psql mybase >> Bienvenue dans psql 8.1.17, l'interface interac

[GENERAL] Strange "missing tables" problem

Hello, I have a strange problem since I moved some tables to a schema, some tables are missing from the list (with \d or \dt) but they are still present anyway ???! Example : > $ psql mybase > Bienvenue dans psql 8.1.17, l'interface interactive de PostgreSQL. > Saisissez: > mybase=# > bw_rma=

Re: [GENERAL] How to execute external script from a TRIGGER or FUNCTION ?

Andy Colson a écrit : >>> I need to execute an external script from Postgresql, it could be in >>> perl, in bash/shell, in whatever... >>> >>> Any help would be appreciated ! I just need a very simple example if >>> possible... >>> >>> I already searched on the web but found nothing... >> >> After

Re: [GENERAL] How to execute external script from a TRIGGER or FUNCTION ?

Hello, Denis BUCHER a écrit : > I need to execute an external script from Postgresql, it could be in > perl, in bash/shell, in whatever... > > Any help would be appreciated ! I just need a very simple example if > possible... > > I already searched on the web but found no

[GENERAL] How to execute external script from a TRIGGER or FUNCTION ?

Hello everyone, I need to execute an external script from Postgresql, it could be in perl, in bash/shell, in whatever... Any help would be appreciated ! I just need a very simple example if possible... I already searched on the web but found nothing... Denis -- Sent via pgsql-general mailin

Re: [GENERAL] Best way to import data in postgresl (not "COPY")

Hello everyone, Denis BUCHER a écrit : > I have a system that must each day import lots of data from another one. > Our system is in postgresql and we connect to the other via ODBC. > > Currently we do something like : > > SELECT ... FROM ODBC source > foreach row { >

[GENERAL] Best way to import data in postgresl (not "COPY")

Hello, I have a system that must each day import lots of data from another one. Our system is in postgresql and we connect to the other via ODBC. Currently we do something like : SELECT ... FROM ODBC source foreach row { INSERT INTO postgresql } The problem is that this method is very slow...

Re: [GENERAL] URGENT ! Nouveau virus

At 12:46 19.09.01 -0700, Roderick A. Anderson wrote: To everyone : > Who are you and how did you get this e-mail address? Why are you >sending me this stuff? Postgres mailling-list was inserted by error in my mailing and I don't know why ?! Of course I certainly made a mistake... All my apol

[GENERAL] URGENT ! Nouveau virus

Hello ! Ok... I wrote a small text against that virus just in case you need it ! http://www.horus.ch/virus180901.txt A bientôt ! Denis Bucher ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate