[BUGS] BUG #7652: Documentation index lacks functions from "Additional Supplied Modules"

2012-11-11 Thread Andreas . Heiduk
The following bug has been logged on the website: Bug reference: 7652 Logged by: Andreas H. Email address: andreas.hei...@web.de PostgreSQL version: 9.2.1 Operating system: any Description: It seems, that none of the functions in the section "Additional Sup

Re: [BUGS] BUG #6325: Useless Index updates

2011-12-04 Thread Andreas Karlsson
n 8.3. http://www.postgresql.org/docs/9.1/static/release-8-3.html -- Andreas Karlsson -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] Cannot dump 8.4.8 database using later versions

2011-11-15 Thread Andreas Lange
/interactive/sql-keywords-appendix.html) You can have a 8.4 DB with a 'new' column and dump it with 8.4 tools. You can have a 9.x DB with a 'new' column and dump it with 9.x tools. However, it fails when you use 9.x pg_dump against 8.4 with a 'new' column

Re: [BUGS] char(0)

2011-10-17 Thread Andreas Pflug
ration and use a > "boolean not null"? Sounds much too straight forward, not mysql-ish artistic enough... Regards, Andreas -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] BUG #5843: documentation error

2011-01-19 Thread Andreas Kretschmer
The following bug has been logged online: Bug reference: 5843 Logged by: Andreas Kretschmer Email address: akretsch...@spamfence.net PostgreSQL version: 9.1 Operating system: all Description:documentation error Details: the doku contains a bug: http

Re: [BUGS] BUG #5705: btree_gist: Index on inet changes query result

2010-10-21 Thread andreas
to try to change it. I'd be willing to take responsibility for ripping > out btree_gist's inet support altogether ... > > regards, tom lane That is the reason why I just reported it instead of trying to fix it myself first. Since I could not understand why

[BUGS] BUG #5705: btree_gist: Index on inet changes query result

2010-10-11 Thread Andreas Karlsson
The following bug has been logged online: Bug reference: 5705 Logged by: Andreas Karlsson Email address: andr...@proxel.se PostgreSQL version: 9.1 Operating system: Linux Description:btree_gist: Index on inet changes query result Details: Hi, I was looking at the

[BUGS] BUG #5695: select into duplicates oid when using order by int

2010-10-06 Thread Andreas Barth
The following bug has been logged online: Bug reference: 5695 Logged by: Andreas Barth Email address: aba+postgre...@not.so.argh.org PostgreSQL version: 8.3.11 Operating system: Debian Linux (amd64) Description:select into duplicates oid when using order by int

Re: [BUGS] BUG #5675: out of memory at request size 32Mb

2010-09-24 Thread Andreas Pflug
Am 24.09.10 14:54, schrieb Robert Haas: On Fri, Sep 24, 2010 at 8:42 AM, Andreas Pflug wrote: The following bug has been logged online: Bug reference: 5675 Logged by: Andreas Pflug Email address: pgad...@pse-consulting.de PostgreSQL version: 8.4.4 Operating system

[BUGS] BUG #5675: out of memory at request size 32Mb

2010-09-24 Thread Andreas Pflug
The following bug has been logged online: Bug reference: 5675 Logged by: Andreas Pflug Email address: pgad...@pse-consulting.de PostgreSQL version: 8.4.4 Operating system: Linux 2.6.26 i686 Description:out of memory at request size 32Mb Details: A slony 2.0 cluster

[BUGS] BUG #5057: Binaries missing

2009-09-15 Thread Andreas Kuckartz
The following bug has been logged online: Bug reference: 5057 Logged by: Andreas Kuckartz Email address: a.kucka...@ping.de PostgreSQL version: 8.2.14 Operating system: Windows Description:Binaries missing Details: "Only PostgreSQL 8.2 and above are support

Re: [BUGS] 1-Click 8.4 win32 fails to run scripts

2009-07-15 Thread Andreas Pflug
This issue still seems unaddressed. Andreas Pflug wrote: > The installer claimed a non-fatal problem, cluster is up and running. > Excerpt from install-postgresql.log > > Installing pl/pgsql in the template1 databases... > psql: Warnung: berflssiges Kommandozeilenargument ¯

[BUGS] 1-Click 8.4 win32 fails to run scripts

2009-07-07 Thread Andreas Pflug
with de_DE). Regards, Andreas -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] BUG #4881: KDE 4.2 not running any more when installing one click installer from Enterprise DB

2009-06-25 Thread Andreas Wenk
The following bug has been logged online: Bug reference: 4881 Logged by: Andreas Wenk Email address: a.w...@netzmeister-st-pauli.de PostgreSQL version: 8.4 RC1 Operating system: Linux Kubuntu 9.04 Jaunty Description:KDE 4.2 not running any more when installing one

[BUGS] Postgres

2009-06-10 Thread Andreas Mutota
could create database and tables but I cannot populate data into any of the tables. How would I make this possible. Best regards, Andreas Mutota GIS Analyst Programmer Nationl Planning Commission Central Bureau of Statistics Private Bag 13356, Windhoek Republic of Namibia TeL: +264 61

[BUGS] Bug in pg_dump.exe/pg_restore (Version 8.4 beta 2)

2009-06-09 Thread Andreas Nolte
.sp_pp_set(@ppnr integer, @JobID character varying) OWNER TO sa; It fails to restore the parameters of a lot of functions... only 2 functions (without any parameter) are restored fine. Beste Gruesse / best regards Andreas Nolte Manz Automation AG Andreas Nolte Entwicklung / Appl

Re: [BUGS] data loss with pg_standby when doing a controlled failover

2009-04-06 Thread Andreas Pflug
Guillaume Smet wrote: > On Mon, Apr 6, 2009 at 1:37 PM, Andreas Pflug > wrote: > >> IMHO this should be mentioned in the docs explicitly (I find it quite >> surprising that data can be lost even if the system is shutdown >> correctly), or better when shutting down

Re: [BUGS] data loss with pg_standby when doing a controlled failover

2009-04-06 Thread Andreas Pflug
Scott Mead wrote: > > > > On Mon, Apr 6, 2009 at 7:37 AM, Andreas Pflug > mailto:pgad...@pse-consulting.de>> wrote: > > Running 8.3.7, I have a warm standby configuration with a > archive_timeout of 10min. > > It's obvious that there's a

[BUGS] data loss with pg_standby when doing a controlled failover

2009-04-06 Thread Andreas Pflug
uite surprising that data can be lost even if the system is shutdown correctly), or better when shutting down the postmaster should spit all log segments containing all changes when archiving is on so the warm standby server can catch up. Regards. Andreas -- Sent via pgsql-bugs mailing l

Re: [BUGS] BUG #4684: lastval in function

2009-03-02 Thread Andreas
Heikki Linnakangas schrieb: andreas wrote: if nextval is used inside a function in a insertstatement, you get always the value from inside the last function. but i expected, that lastval() deliver the value from the insertstatement. i think, this should clearify in the documentation, or better

[BUGS] BUG #4684: lastval in function

2009-02-28 Thread andreas
The following bug has been logged online: Bug reference: 4684 Logged by: andreas Email address: postgre...@elbrief.de PostgreSQL version: 8.3.6 Operating system: linux Description:lastval in function Details: create table bla ( id serial primary key , name text not

Re: [BUGS] BUG #4421: convert_to() should be immutable

2008-09-19 Thread Andreas Peer
Tom Lane schrieb: > Andreas Peer <[EMAIL PROTECTED]> writes: > >> Well, the use case is a strange one... I would like to use a varchar() >> column for storing a variable-length vector of integers. The numbers are >> represented by the codepoints. Therefore,

Re: [BUGS] BUG #4421: convert_to() should be immutable

2008-09-18 Thread Andreas Peer
ary" index. And the code should be as database independent as possible, therefore I cannot use an array or another data type that may not be supported by other DBMS. Regards, Andreas Peer -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] BUG #4290: wrong double subselect with aggregate function

2008-07-09 Thread Andreas
The following bug has been logged online: Bug reference: 4290 Logged by: Andreas Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Linux Description:wrong double subselect with aggregate function Details: select version

[BUGS] BUG #4252: SQL stops my graic cards

2008-06-18 Thread Andreas Andersson
The following bug has been logged online: Bug reference: 4252 Logged by: Andreas Andersson Email address: [EMAIL PROTECTED] PostgreSQL version: SQL 2.8 Operating system: Vista SP1 Description:SQL stops my graic cards Details: Post this bug on pockertracker forum

Re: [BUGS] [PATCH] Don't bail with legitimate -N/-B options

2008-02-16 Thread Andreas Kling
be an error message at all. ;-) Cheers, Andreas ---(end of broadcast)--- TIP 1: if posting/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] [PATCH] Don't bail with legitimate -N/-B options

2008-02-16 Thread Andreas Kling
ually "max autovacuum connections" + NBuffers. My attached patch fixes this by adding "max autovacuum connections" * 2 to NBuffers before the check. Best regards, Andreas Kling ACG Nyström AB Index: src/b

[BUGS] BUG #3926: Typo in documentation

2008-02-03 Thread Andreas
The following bug has been logged online: Bug reference: 3926 Logged by: Andreas Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: All Description:Typo in documentation Details: There is a typo in http://www.postgresql.org/docs/8.3/static

[BUGS] BUG #3741: translation mistake

2007-11-10 Thread Andreas
The following bug has been logged online: Bug reference: 3741 Logged by: Andreas Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4/8.3.beta2 Operating system: debian gnu linux Description:translation mistake Details: FEHLER: Spalte »...« muss in der

Re: [BUGS] BUG #3716: utf8 crash with replace

2007-11-08 Thread Andreas Pflug
Tom Lane wrote: > "Andreas Pflug" <[EMAIL PROTECTED]> writes: > >> If replace is used with UTF8 client_encoding, searching for a malformed >> string, the backend will crash. >> > > >> SELECT replace('Ärger', chr(195), '

[BUGS] BUG #3716: utf8 crash with replace

2007-11-02 Thread Andreas Pflug
The following bug has been logged online: Bug reference: 3716 Logged by: Andreas Pflug Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Linux,Windows Description:utf8 crash with replace Details: If replace is used with UTF8

[BUGS] BUG #3280: wrong german-translation

2007-05-15 Thread Andreas Sakowski
The following bug has been logged online: Bug reference: 3280 Logged by: Andreas Sakowski Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: debian-linux Description:wrong german-translation Details: If you truncate a table with a foreign

[BUGS] BUG #3246: User "name" could not be created.

2007-04-20 Thread Andreas
The following bug has been logged online: Bug reference: 3246 Logged by: Andreas Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows Vista Description:User "name" could not be created. Details: Hi I can not install postgre

Re: [BUGS] 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio

2006-11-14 Thread Andreas Lange
-native -xdepend -xlibmil -xlibmopt -xO5 -xregs=frameptr I do understand the recomendation to avoid -fast, the tweaking is both compiler version and hardware architecture dependant. Doing a make check is always advisable. regards, Andreas ---(end of broadcast)

Re: [BUGS] 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio

2006-11-03 Thread Andreas Lange
: test -z              || test ! -s conftest.err configure:5211: $? = 0 configure:5214: test -s conftest configure:5217: $? = 0 configure:5287: result: none required   regards, Andreas Lange

Re: [BUGS] 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio

2006-11-03 Thread Andreas Lange
Alvaro Herrera wrote: Andreas Lange wrote: configure:13462: checking for cbrt configure:13519: /sw/sun-studio-11/SUNWspro/bin/cc -Xa -o conftest -fast -fns=no -fsimple=1 -xtarget=opteron -xarch=amd64a conftest.c -lz -lrt -lsocket >&5 "conftest.c",

Re: [BUGS] 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio

2006-11-03 Thread Andreas Lange
Alvaro Herrera wrote: Andreas Lange wrote: And here is from configure: checking whether gettimeofday takes only one argument... no checking for cbrt... no Undoubtely this is the problem. Can you show the relevant config.log extract? Ok, here we go: configure

[BUGS] 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio 11

2006-11-03 Thread Andreas Lange
k backported) on the same machine finds cbrt and passes the 'gmake check' just fine. Is this a known error or due to some intentional change that I've missed? Regards, Andreas ---(end of broadcast)--- TIP 7: You can help su

Re: [BUGS] backup + restore fails

2006-10-20 Thread Andreas Seltenreich
Win32's strftime be an acceptable solution? elog.c is already doing this, however because of the length of the zone names, not the localization problem. The attached patch is completely untested because I don't have access to a win32 box. regards, andreas Index: src/bin

Re: [BUGS] BUG #2598: Columns named R are not accessible - although

2006-08-30 Thread Andreas Langegger
key, date, time, remarks, R) values (9, '2006-08-30', '12:00:00', 'no comments', 30); causes: ERROR: column "r" of relation "sunspots" does not exist regards, Andy Tom Lane wrote: > "Andreas Langegger" <[EMAIL PROTECTED]>

[BUGS] BUG #2598: Columns named R are not accessible - although R is not a keyword

2006-08-30 Thread Andreas Langegger
The following bug has been logged online: Bug reference: 2598 Logged by: Andreas Langegger Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Gentoo Linux 3.3.6, Kernel 2.6.16 Description:Columns named R are not accessible - although R is not

Re: [BUGS] Restoring 7.4 "pg_dumpall -o" output in 8.1 fails

2006-08-07 Thread Andreas Gustafsson
t looking for support or workarounds, but simply to have the bug fixed. Whether or not I need to preserve OIDs, the documented upgrade procedure for the case where OIDs do need to preserved is not working, and that clearly is a bug in either PostgreSQL itself or the documentation. -- A

[BUGS] Restoring 7.4 "pg_dumpall -o" output in 8.1 fails

2006-08-04 Thread Andreas Gustafsson
dfec250 psql:backup:845: ^ psql:backup:846: invalid command \N psql:backup:847: invalid command \N psql:backup:848: invalid command \N This is on NetBSD-current, i386. -- Andreas Gustafsson, [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [BUGS] Too many function calls in view with LEFT JOIN

2006-06-01 Thread Andreas Heiduk
Hello! Tom Lane <[EMAIL PROTECTED]> wrote > > Andreas Heiduk <[EMAIL PROTECTED]> writes: > > If a view which calls a function is LEFT JOINed to a table but not all > > result rows are matched by some criteria, then the function is called > > for each row o

[BUGS] Too many function calls in view with LEFT JOIN

2006-05-30 Thread Andreas Heiduk
I hope, this is really a bug and not something I didn't understand :-) Best Regards Andreas Heiduk __ Verschicken Sie romantische, coole und witzige Bilder per SMS! Jetzt bei WE

Re: [BUGS] BUG #2386: pg_restore doesn't restore large objects

2006-04-14 Thread Andreas Pflug
e restored. This is the original output from pg_restore. pgAdmin will also log the precise parameters used to restore in the first log line, it might help to see those. Regards, Andreas ---(end of broadcast)--- TIP 9: In versions below 8.0, the pl

[BUGS] BUG #2390: check constraint

2006-04-13 Thread Andreas Kretschmer
The following bug has been logged online: Bug reference: 2390 Logged by: Andreas Kretschmer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Debian Linux Description:check constraint Details: i want to add a check constraint like

Re: [BUGS] BUG #2318: language

2006-03-16 Thread Andreas Pflug
type export LANG=C pgadmin & This is a wrong advice. Mete, use the option dialog to select your favourite language. Don't touch the environment. Regards, Andreas ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

[BUGS] BUG #2306: Duplicate primary key

2006-03-08 Thread Andreas Jung
The following bug has been logged online: Bug reference: 2306 Logged by: Andreas Jung Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.9 Operating system: Linux Description:Duplicate primary key Details: Ihave the following table (with 'id' as p

Re: [BUGS] BUG #2240: length() with geometric types

2006-02-07 Thread Andreas Erber
more useful. Thx CU ae James William Pye schrieb: > On Mon, Feb 06, 2006 at 02:41:39PM +, Andreas Erber wrote: >> Hi, >> >> I discovered some strange behaviour: >> The length() function returns different results depending on the geometric >> data type used as arg

[BUGS] BUG #2240: length() with geometric types

2006-02-06 Thread Andreas Erber
The following bug has been logged online: Bug reference: 2240 Logged by: Andreas Erber Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.2 Operating system: Windows XP Description:length() with geometric types Details: Hi, I discovered some strange

[BUGS] BUG #2152: psql crash reproducible

2006-01-06 Thread Andreas Kretschmer
The following bug has been logged online: Bug reference: 2152 Logged by: Andreas Kretschmer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: Debian/Linux Description:psql crash reproducible Details: i wrote a wrong query, and psql crash

Re: [BUGS] BUG #2116: Searching text fields does not work in EUC_JP

2005-12-16 Thread Andreas Pflug
Jon Keating wrote: I have a database with the default encoding set to EUC_JP and the client (using pgAdmin III) is set to EUC_JP as well. pgAdmin uses Unicode (unless the DB is SQL_ASCII or MULE_INTERNAL), you won't get happy if you change it using a SET command. Regards, An

Re: [BUGS] COPY TO STDOUT BINARY

2005-12-13 Thread Andreas Pflug
Tom Lane wrote: Andreas Pflug <[EMAIL PROTECTED]> writes: Is COPY foo TO STDOUT BINARY supposed to work? I don't think psql will do anything particularly sane with binary copy data, if that's what you meant. echo "COPY foo TO STDOUT BINARY;" | psql >ba

[BUGS] COPY TO STDOUT BINARY

2005-12-13 Thread Andreas Pflug
Is COPY foo TO STDOUT BINARY supposed to work? The query will run some time, but won't give a result. I couldn't see any mentioning in the COPY command docs that would prohibit use of this combination. Tested with psql on 8.0.5 and 8.1.1. Regards, Andreas

[BUGS] BUG #2090: error in man-page of postmaster

2005-12-02 Thread Andreas Schmidt
The following bug has been logged online: Bug reference: 2090 Logged by: Andreas Schmidt Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: Linux Description:error in man-page of postmaster Details: 'man postmaster' describes the

Re: [BUGS] BUG #1982: pgAdmin 1.2.2 crash when refreshing objects

2005-10-21 Thread Andreas Pflug
ow This is a known problem, not easily solved (not in 1.4.0). When refreshing, you're destroying program structures used by the open dialog. Advice: don't do this. Regards, Andreas ---(end of broadcast)--- TIP 4: Have

Re: [BUGS] BUG #1945: pgAdmin Crash when adding user

2005-10-08 Thread Andreas Pflug
Details: I was able to crash pgAdmin III when I attempted to add a Login Role. Which pgAdmin version is that? I can't reproduce this with pgAdmin 1.4Beta1. Please post reply and further pgAdmin related stuff to pgadmin-support. Regards, Andreas ---(end of broa

Re: [BUGS] Sorting Problem in UNICODE/german

2005-09-02 Thread Andreas Seltenreich
Sorry, I just reread your mail: Your MUA is declaring it with > Content-Type: text/plain; charset=unknown-8bit This makes it even harder to discuss problems with Umlauts :-). Andreas Seltenreich schrob: > Klaus Ita schrob: > >> another "funny" thing is: >> >&

Re: [BUGS] Sorting Problem in UNICODE/german

2005-09-02 Thread Andreas Seltenreich
> [Überflieger]). so is this a libc bug? The sort order is correct, so libc did succeed in its part. Maybe your terminal is having issues with utf-8? If you're using xterm: Did you run it with -u8 or some utf-8-enabling X-resource? To verify that the terminal is working properly, typing

Re: [BUGS] BUG #1847: Error in some kind of UNION query.

2005-08-25 Thread Andreas Pflug
mined from the first SELECT. Changing the order to have SELECT 1 does the job too. Regards, Andreas ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [BUGS] row number -1 is out of range 0..-1

2005-06-28 Thread Andreas Pflug
be reported on the pgAdmin mailing lists --- I'm not sure that any of the pgAdmin hackers read this list. I do read the list, though I missed it initially. I doubt it's a pgadmin bug, but let's see the query first. Regards, Andreas ---(end of broadcast)-

Re: [BUGS] BUG #1735: row number -1 is out of range 0..-1 error

2005-06-28 Thread Andreas Pflug
"3";"12";"0";"7 days is the result I'm getting in pgadmin. Regards, Andreas ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [BUGS] BUG #1707: statistics collector starts with stats_start_collector

2005-06-14 Thread Andreas Pflug
hat examine the pids known to the postmaster (pg_get_collector_pid, pg_get_logger_pid, ...) Regards, Andreas ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [BUGS] request

2005-05-07 Thread Andreas Pflug
/robustness), unfortunately programmers are seduced by MySQL to work like that.. B) is this any sort of SQL standard? Definitely no. Do not use SELECT * if you need a specific column ordering, *that* is SQL standard. Regards, Andreas ---(end of broadcast

Re: [BUGS] [HACKERS] We are not following the spec for HAVING without GROUP BY

2005-03-13 Thread Zeugswetter Andreas DAZ SD
the GROUP BY list. select tabname from systables group by 1 having 2 > 1; all rows returned select tabname from systables group by 1 having 1 > 2; no rows found Andreas ---(end of broadcast)--- TIP 2: you can get off all lists at

Re: [BUGS] PGPASSWORD

2005-02-27 Thread Andreas Pflug
handle of an inherited pipe. Regards, Andreas ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [BUGS] Minor bug in pgAdmin III

2005-02-09 Thread Andreas Pflug
Lucas Galfaso wrote: Create a trigger using capitalized letters. Whenever you select the trigger, the name of the trigger appears without quotes. Fixed for 1.2.1, thanks for reporting. Regards, Andreas ---(end of broadcast)--- TIP 7: don't forg

[BUGS] pg_dump table ordering bug [8.0.1]

2005-02-07 Thread Andreas Lange
finstance) REFERENCES debug.form_instance(finstance) ON UPDATE CASCADE ON DELETE CASCADE And the dump data order is: -- Data for Name: form_a_int; -- Data for Name: form_instance; -- Data for Name: form_q; Regards, Andreas (Not a subscriber of this list) begin; --drop schema debug cascad

Re: [BUGS] Template1 is locked when pgAdminIII is open

2005-01-31 Thread Andreas Pflug
d it be possible to teach pgAdmin to close extra connections to template1 whenever it's doing CREATE DATABASE? If those connections were guaranteed to be idle, we wouldn't need them. They are independent windows, so we can't kill the conn. Regards, Andreas

Re: [BUGS] Template1 is locked when pgAdminIII is open

2005-01-31 Thread Andreas Pflug
copies of pgAdmin at once". Which is still not the whole truth. pgAdmin may open more connections to the "initial database", e.g. to show the server status. So the advice is "don't use the template1 database for pgadmin connections if you're creating databases frequentl

Re: [BUGS] 22021: invalid byte sequence for encoding \"UNICODE\":

2004-10-29 Thread Andreas Pflug
the same through a C# App connecting to the database through an ODBC driver I get the following error: *"ERROR: 22021: invalid byte sequence for encoding \"UNICODE\": 0xe16d61"* Sounds as if you're not using the correct client encoding; your app is probably non-uni

Re: [BUGS] [pgadmin-support] Bug: PGAdmin + plpythonu + windows

2004-10-20 Thread Andreas Pflug
O any pgsql language should handle cr, crlf and lf equally as line feed, to avoid client/server eol interpretation discrepancies. Regards, Andreas ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [BUGS] Money type not gone?

2004-09-21 Thread Andreas Pflug
re a query to money.yahoo.com to establish. It's even more complicated. In practice, real time rates of exchanges are much less frequent than point in time rates. Regards, Andreas ---(end of broadcast)--- TIP 5: Have you checked our extensive

Re: [BUGS] psql can not connect to the server on Win2000 NT

2004-09-20 Thread Andreas Pflug
ing tool that I have installed is NetLimiter This is a good example of a misleading error message, probably resulting from examining errno. Using GetLastError() on those socket calls might help reducing support requests. Regards, Andreas ---(end of broadcast)--

Re: [BUGS] Money type not gone?

2004-09-20 Thread Andreas Pflug
Karel Zak wrote: On Mon, 2004-09-20 at 08:36 +, Andreas Pflug wrote: Karel Zak wrote: On Sun, 2004-09-19 at 15:29 -0400, Tom Lane wrote: I want to rewrite it for 8.1 as numeric based datetype with some formatting extension probably with some internal stuff from to_char() familly. How about a

Re: [BUGS] Money type not gone?

2004-09-20 Thread Andreas Pflug
period of work on multi currency applications, I found out that adding 1 USD and 1 EUR won't give a good result... Regards, Andreas ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [BUGS] Sugestion

2004-09-02 Thread Andreas Pflug
up the tray with colourful useless stuff). Usually a server process is started when the machine starts, and stopped when switched off. To control the pgsql service, you can do this in pgAdmin III, in addition to the usual services applet. Regards, Andreas ---(end of

Re: [BUGS] BUG #1229: memory leak in backend with COPY and FOREIGN KEY

2004-08-25 Thread Andreas Heiduk
section "13.4.2 Use COPY FROM" within "Performance Tips" would prevent other people like me doing such bad things. Many thanks for the fast help. Andreas Heiduk Stephan Szabo <[EMAIL PROTECTED]> schrieb am 24.08.04 19:25:56: > > > On Tue, 24 Aug 2004, Pos

Re: [BUGS] 8.0.0 beta 1, contrib/dbsize, GetDatabasePath wrong

2004-08-17 Thread Andreas Pflug
Bruce Momjian wrote: Andreas Pflug wrote: Bruce Momjian wrote: Andreas Pflug wrote: Bruce Momjian wrote: This has been corrected in current CVS. But it still fails for tables in tablespaces. That's why I posted all new functions a while ago. Yes, you posted the functions, but I

Re: [BUGS] 8.0.0 beta 1, contrib/dbsize, GetDatabasePath wrong

2004-08-17 Thread Andreas Pflug
Bruce Momjian wrote: Andreas Pflug wrote: Bruce Momjian wrote: This has been corrected in current CVS. But it still fails for tables in tablespaces. That's why I posted all new functions a while ago. Yes, you posted the functions, but I don't understand how to integrate that into dbsi

Re: [BUGS] 8.0.0 beta 1, contrib/dbsize, GetDatabasePath wrong

2004-08-17 Thread Andreas Pflug
Bruce Momjian wrote: This has been corrected in current CVS. But it still fails for tables in tablespaces. That's why I posted all new functions a while ago. Regards, Andreas ---(end of broadcast)--- TIP 7: don't forget to increase your

Re: [BUGS] postgresql 8 (pgAdminIII) crashes when login form X is

2004-08-15 Thread Andreas Pflug
te a connection dialogue!" Known and already fixed. Regards, Andreas ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [BUGS] PostgreSQL 8.0

2004-08-13 Thread Andreas Pflug
Andras Kutrovics wrote: LOG: select() failed in statistics collector: An operation was attempted on something that is not a socket. What's your operating system platform? Regards, Andreas ---(end of broadcast)--- TIP 7: don't forget t

Re: [BUGS] pgAdmin III edit grid on empty Table

2004-08-13 Thread Andreas Pflug
a. Nathan, please post pgadmin related stuff at pgadmin-support. You probably didn't assign a primary key to that table, pgadmin3 will refuse to edit tables on which it can't identify rows uniquely. Regards, Andreas ---(end of broadcast)

Re: [BUGS] broken contrib/dbsize in cvs head?

2004-08-11 Thread Andreas Pflug
h offer tablespace size as well. Regards, Andreas ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [BUGS] BUG #1199: pgAdmin problem

2004-07-21 Thread Andreas Pflug
following error message: column "datpath" does not exist pgAdmin III V1.0.2 is for PostgreSQL 7.3 and 7.4 only, use a V1.1 snapshot. Regards, Andreas ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [BUGS] Bug in concat operator for Char? -- More Info

2004-07-21 Thread Andreas Pflug
DY$ LANGUAGE 'plpgsql' I find the result of this function quite surprising, and certainly not yielding what was intended (yes, this can avoided, I know). Surprise is getting bigger, if fullname is declared as text... IMHO the bottom line here is that the SQL-spec behavior of type ch

Re: [BUGS] UNIQUE not honoured for NULL

2004-07-12 Thread Andreas Pflug
not TRUE. Yes, that it's better. Still not precise. NULL = NULL is NULL (which is neither TRUE nor FALSE) while (NULL = NULL) IS NULL is TRUE... Regards, Andreas ---(end of broadcast)--- TIP 6: Have you searched our list archives?

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

2004-04-18 Thread Andreas Pflug
a limited class of changes exist that can be done without deep impact, namely changing between binary compatible types and extending the length. This is what pgadmin3 does, but apparently this wasn't correct. Regards, Andreas ---(end of broadcast)-

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

2004-04-16 Thread Andreas Pflug
2500 bytes. Please let me know what's wrong with that. Regards, Andreas ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [BUGS] BUG #1082: Order by doesn't sort correctly.

2004-02-24 Thread Andreas Pflug
Cymbal #2 Cymbal - 18 inch [EMAIL PROTECTED] tgl]$ LC_ALL=en_GB sort zzz Cymbal #1 Cymbal - 18 inch Cymbal #2 [EMAIL PROTECTED] tgl]$ I verified this, and it's not GB specific as one might suggest... Same with en_US, de_DE, fr_FR, af_ZA. Does this behaviour really make sense

Re: [BUGS] [pgadmin-hackers] Degrade(character conversion problem) pga3?

2003-10-08 Thread Andreas Pflug
Hiroshi Saito wrote: Hi Andreas. I have a problem. It is a happening within this week. See below. http://cre-ent.skcapi.co.jp/~saito/pgadmin3/20030922_1.jpg http://cre-ent.skcapi.co.jp/~saito/pgadmin3/20031007_1.jpg Tonight, let me know it if you know something though it will be examined. Thank

Re: [BUGS] bug reporting

2003-10-03 Thread Andreas Pflug
ated questions. Which tool did you use to insert the data? Regards, Andreas ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [BUGS] Postgresql 'eats' all mi data partition

2003-09-25 Thread Andreas Pflug
p until fill all my partition (from 1GB grows up to 15GB !!!). This is by design, you need to VACUUM regularly to keep your db healthy as pointed out in the documentation. Regards, Andreas ---(end of broadcast)--- TIP 3: if posting/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

Re: [BUGS] pgadmin 3 bug - crash on start, win95b

2003-09-05 Thread Andreas Pflug
Jim, first of all, this is the wrong mailing list. Use pgadmin-support for pgadmin related questions. The binary win32 release of pgAdmin3 is unicode enabled, which requires Windows NT, 2000 or XP, 95 and 98 are too old. Regards, Andreas ---(end of broadcast

Re: [BUGS] session variable

2003-09-02 Thread Andreas Pflug
Bupp Phillips wrote: Could you possible have some type of variable (preferably the Transaction ID) that can identify an individual process? There's pg_backend_pid() for 7.4 and backend_pid() as contrib module for earlier releases. Regards, Andreas ---(end of broa

Re: [BUGS] Cannot compile CVS current on Mac OS X 10.2.6

2003-09-02 Thread Andreas Pflug
[EMAIL PROTECTED]) Looks like a cvs conflict because you changed something in pqcomm.c. Remove pqcomm* and cvs update again. Regards, Andreas ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [BUGS] session variable

2003-09-02 Thread Andreas Pflug
n? i think mailing such questions to "BUGS" is not a good idea. Just use the pgsql-sql and pgsql-performance mailing lists. Regards, Andreas ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [BUGS] can't link the libpq.dll for bcc32.mak

2003-08-26 Thread Andreas Pflug
e are already patches for this on the way; please look at pgsql-patches of the last days. Regards, Andreas ---(end of broadcast)--- TIP 8: explain analyze is your friend

  1   2   >