Re: [BUGS] BUG #4291: Inheritance fails on column suppression

2008-07-11 Thread [EMAIL PROTECTED]
: Tom Lane <[EMAIL PROTECTED]> To : "Duprez" <[EMAIL PROTECTED]> Cc : pgsql-bugs@postgresql.org Date : Thu, 10 Jul 2008 10:34:19 -0400 Subject : Re: [BUGS] BUG #4291: Inheritance fails on column suppression "Duprez" <[EMAIL PROTECTED]>

[BUGS] Latin2 and UTF-8 encoding.

2008-08-25 Thread [EMAIL PROTECTED]
Dear Sur! My name is Peter Kovacs and I work at the National Szechenyi Library in Hunagry. The reason why im writing this letter is the follow: We are using Potgresql to store our data. We have UTF-8, LATIN1 and LATIN2 encoded databases. I haven't got any problem with database encoding before,

[BUGS] Bug to restore OID with pg_restore

2002-02-01 Thread [EMAIL PROTECTED]
Hi, My server is a postgres v7.1.3. I have a database with OID and to backup my database i use this syntaxe : pg_dump -Ft -b -o -f mydb.tar mydb when i want restore my database i use this command line: pg_restore -o -d mydb mydb.tar and i have this error : Archiver(db): Could not execute query. N

[BUGS]

2002-03-19 Thread [EMAIL PROTECTED]
If PostgreSQL failed to compile on your computer or you found a bug that is likely to be specific to one platform then please fill out this form and e-mail it to [EMAIL PROTECTED] To report any other bug, fill out the form below and e-mail it to [EMAIL PROTECTED] If you not only found the

[BUGS] Hanging queries on Windows 2003 SP1

2006-09-03 Thread [EMAIL PROTECTED]
sting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

[BUGS] Very slow bytea extraction

2007-03-21 Thread [EMAIL PROTECTED]
Hi, before writing to this list I've tried to solve the problem discussing it in the pgsql-performance mailing list but I wasn't able to solve it. The problem is as follows. My test db only contains a single table with some varying-text field and a bytea field. When inserting data into this t

Re: [BUGS] Very slow bytea extraction

2007-03-22 Thread [EMAIL PROTECTED]
>In psql the trick is to use unaligned display mode, else psql itself >eats a whole lot of time trying to nicely format those 250KB rows: Even using unaligned display mode (\a) it still takes more than 1 minute > >I surmise that your problem is likewise on the client side, but you >weren't ve

Re: [BUGS] Very slow bytea extraction

2007-03-22 Thread [EMAIL PROTECTED]
>Hmm ... what does VACUUM VERBOSE of that table show? > Here is the output of VACUUM VERBOSE INFO: vacuuming "public.FILE" INFO: scanned index "FILE_pkey" to remove 54 row versions DETAIL: CPU 0.00s/0.00u sec elapsed 0.01 sec. INFO: "FILE": removed 54 row versions in 5 pages DETAIL: CPU 0

Re: [BUGS] Very slow bytea extraction

2007-03-22 Thread [EMAIL PROTECTED]
> >Well, that eliminates the theory that you've got a lot of dead tuples >slowing it down. I come back to the conclusion that it's probably a >client-side problem. Have you tried watching with "top" or similar tool >to check which process is eating all the time? > No, actually I haven't yet

Re: [BUGS] Very slow bytea extraction

2007-03-27 Thread [EMAIL PROTECTED]
> >No, >actually I haven't yet. >I have noticed that during the time the query >executes there is neither so much CPU load nor network (communication >with db) load. The client seems to hang, then after a minute or so the >query returns data. >I also thought this problem could be related to

[BUGS] help

2007-12-26 Thread [EMAIL PROTECTED]
Hello. Can you help me? i don't know what to do with this message: ** # pg_dump -U postgres catalog Password: pg_dump: query to obtain list of schemas failed: ERROR: more than one row returned by a subq

[BUGS] help me please

2007-12-28 Thread [EMAIL PROTECTED]
hello Help me please... I have two "postgres" user. How to delete the first one ??? *** # select * from pg_shadow where usesysid=1; usename | usesysid | usecreatedb | usesuper | usecatupd | passwd| valuntil | useconfig --+--+--

[BUGS] help me plz with 2 postgres users

2008-02-26 Thread [EMAIL PROTECTED]
Hello? help me plz? i don't khow what to do... How can I delete first postgres user. template1=# select usename,passwd,valuntil,ctid,xmin,xmax,cmin,cmax from pg_shadow where usesysid=1; usename | passwd| valuntil | ctid | xmin | xmax | cmin | cmax --

[BUGS] HELP pls

2008-04-23 Thread [EMAIL PROTECTED]
Hello, help me please, I don't know how, but i got 2 postgres users. How can I delete the first one thx alot for your answers. Oleg -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] how to configure postgresql

2002-11-15 Thread [EMAIL PROTECTED]
Dear all,   I would like to know where can I get help or instructions about how to configure a database, for example size parameters etc.   Thanks,   C.Roberto Soares. Goiânia - Brasil

[BUGS] Unable to download postgre program

2003-02-21 Thread [EMAIL PROTECTED]
Thanks! Bruce Spear [EMAIL PROTECTED] mail2web - Check your email from the web at http://mail2web.com/ . ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[BUGS]

2003-03-21 Thread [EMAIL PROTECTED]
Hi, I manage several databases PostgreSQL 7.3.1 and I have noticed a problem. When I delete many rows (with OID) the free space of disk doesn't changed ! I make a vacuumdb, but I doesn't notice an increase of the free space disk. In a last step, I make a backup and a restoration but, it's the same

[BUGS] PostgreSql Server Problem

2003-03-26 Thread [EMAIL PROTECTED]
://mail2web.com/ . ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[BUGS] Problem with duplicate file.

2003-06-27 Thread [EMAIL PROTECTED]
puis Voila ! www.voila.fr ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[BUGS] pg_resetxlog and pgscripts italian translation

2003-10-08 Thread [EMAIL PROTECTED]
io Mazzoni Macron Srl http://eteampoint.com # SOME DESCRIPTIVE TITLE. # FIRST AUTHOR <[EMAIL PROTECTED]>, YEAR. # msgid "" msgstr "" "Project-Id-Version: PostgreSQL v7.4\n" "POT-Creation-Date: 2003-10-05 13:26-0300\n" "PO-Revision-Date: 2003-10-08 19:10

[BUGS] [7.4.2] Still "variable not found in subplan target lists"

2004-04-15 Thread [EMAIL PROTECTED]
Hello all.. I have a 7.4.2 pg server and the situation is the following: Table detorders with 69 columns, one of which is called docomment. There is a view based on this table called qrydorders and there are other 5 views which include qrydorders in there definitions. Today after changing (with

[BUGS] Bug with 8900 users

2004-10-01 Thread [EMAIL PROTECTED]
Dear Postgres! Sorry my bad English first. I'm found a bug in the PSQL 8 Beta2 Devel 3, and 7.4.x (x=2,3,4,5) too: - The PSQL 8 is working on Win XP. - The PSQL 7.4.x is working on SuSE and Yoper Linux distros. I have 8900 users is in 4 group. 1. I'm maked a 'pg_dumpall -c >full_dump.sql' 2. I make

[BUGS] PostgreSQL memory bug

2004-12-10 Thread [EMAIL PROTECTED]
Dear Developer Team! I use the PostgreSQL 7.4.5 on SLES9.0 and PostgreSQL 7.4.3 on SuSE 9.0 (I think this problem exists in 8.0 too). If you make 'create user' and 'alter group' sql command on existing users, and make it many times, the server doesn't release the memory. After 6-7000 calls the s

[BUGS] Out of memory problem "More detailed"

2004-12-11 Thread [EMAIL PROTECTED]
Logged by: Lutischan Ferenc Email address: yoursoft ( at ) freemail ( dot ) hu PostgreSQL version: 7.4.3, 7.4.5 Operating system: Linux: SuSE9.0, SLES9 Description:Out of memory Details: Dear Developer Team! I use the PostgreSQL 7.4.5 on SLES9.0 and PostgreSQL 7.4.3 on SuS

[BUGS] msi installer on W2K server: error while install

2005-04-27 Thread [EMAIL PROTECTED]
centre of Kola Science Centre of Russian Academy of Science mailto:[EMAIL PROTECTED] PS sorry my english... ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go

[BUGS] Bugs

2005-06-30 Thread [EMAIL PROTECTED]
pgsql-bugs,     when i install src pg ,must mkdir data1 frist,then, ./bin/initdb -D ./data can be successful,why?        [EMAIL PROTECTED]    2005-06-30

Re: [BUGS] BUG #1852: compilation failed

2005-08-29 Thread [EMAIL PROTECTED]
Tom Lane wrote: "fischer" <[EMAIL PROTECTED]> writes: c99 -O3 -mips4 -woff 1164,1171,1185,1195,1552 -I. -I../../../src/include -I/usr/local/include -I/usr/local2/include -I/usr/nekoware/include -U_NO_XOPEN4 -c -o analyze.o analyze.c Signal: Segmentation

[BUGS] On-line backup

2005-11-28 Thread [EMAIL PROTECTED]
Is it possible to do an online backup from linux to windows ? Postgres : 8.1.0 linux : Centos 4.2 , 32 bit windows : 2000 Server , 32 bit When I try to start recovery process on windows I'm getting the following error: FATAL: incorrect checksum in control file thank you -