Re: [BUGS] BUG #6233: pg_dump hangs with Access Violation C0000005

2011-09-29 Thread Craig Ringer
If 64-bit, are you using a 32-bit or 64-bit build of PostgreSQL? Is there any antivirus software on the machine? If so, what type and version? Does the problem still happen if you turn it off and re-test? -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To

Re: [BUGS] BUG #6234: Memory leak from PQexec

2011-09-29 Thread Craig Ringer
"valgrind" or "SSL_config". -- Craig Ringer -- 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] BUG #6237: Hang during install database initialization

2011-10-03 Thread Craig Ringer
On Oct 4, 2011 4:30 AM, "Jim Gray" wrote: > > > The following bug has been logged online: > > Bug reference: 6237 > Logged by: Jim Gray > Email address: jim.g...@bull.com > PostgreSQL version: 9.1.1 > Operating system: Windows Vista > Description:Hang during install da

Re: [BUGS] BUG #6234: Memory leak from PQexec

2011-10-03 Thread Craig Ringer
lean it up with the rest of the process's memory. That's perfectly correct. If repeat invocations of your problem code within one program session cause the heap to grow and the reported leak to get bigger / appear more times, THEN it is a real leak and a real bug. > > -Original

Re: [BUGS] BUG #6233: pg_dump hangs with Access Violation C0000005

2011-10-03 Thread Craig Ringer
gt; >>> Is there any antivirus software on the machine? If so, what type and >>> version? Does the problem still happen if you turn it off and re-test? > >>> -- >>> Craig Ringer > > Can anybody help me please? Honestly, I haven't the foggiest.

Re: [BUGS] BUG #6239: Looking for a technical contact point for PostgreSQL compatibility issue on Windows8

2011-10-03 Thread Craig Ringer
s to worry about and new installs should be using a current patch release and preferably a more recent major version. -- Craig Ringer -- 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] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe

2011-10-04 Thread Craig Ringer
Service packs *endless* possible group policy configurations ... so it's not too surprising to see hard-to-reproduce weirdness popping up. -- Craig Ringer -- 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] BUG #6233: pg_dump hangs with Access Violation C0000005

2011-10-05 Thread Craig Ringer
m his pg_dump executable? Yeah, or if pg_dump is in a different directory to libpq with a different copy of msvcrt I think you can be bitten by this too. free()ing RAM malloc'd in a different DLL/EXE is just plain wrong in Windows anyway. If this wasn't caught by automated tests then tests

Re: [BUGS] BUG #6233: pg_dump hangs with Access Violation C0000005

2011-10-05 Thread Craig Ringer
ng as the client app uses PQfreemem to release memory allocated by libpq. -- Craig Ringer -- 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] BUG #6233: pg_dump hangs with Access Violation C0000005

2011-10-07 Thread Craig Ringer
On 10/07/2011 06:51 PM, Pavel Holec wrote: -Original Message- From: Craig Ringer [mailto:ring...@ringerc.id.au] Sent: Thursday, October 06, 2011 2:05 AM To: Pavel Holec Cc: 'Tom Lane'; 'Alvaro Herrera'; 'Pg Bugs' Subject: Re: [BUGS] BUG #6233: pg_du

Re: [BUGS] BUG #6248: Stack Builder fails

2011-10-10 Thread Craig Ringer
page but still sending a HTTP 200 OK result code, as some buggy proxy servers do, then this would be the expected behaviour. Can you supply a packet trace from Wireshark or similar, showing the attempted download and result? -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #6246: character encoding for 64 bit

2011-10-11 Thread Craig Ringer
for the working and non-working tests? Can you connect to the problem database "demo_" from PgAdmin III? Is it only psql on the Windows command line that's a problem? What's your default codepage for your windows commandline, when you change nothing? -- Craig Ringer

Re: [BUGS] BUG #6251: cannot create roles that can actually login

2011-10-11 Thread Craig Ringer
word is provided - because it's never actually used - is not very user friendly. Being able to support something like "md5,ident" as an auth type in pg_hba.conf would be great. Unfortunately, it's not currently supported. By the way, it's generally preferable to email

Re: [BUGS] BUG #6247: Freeswitch will crash after 2-3 days within odbc connection

2011-10-12 Thread Craig Ringer
psqlODBC driver, the ODBC trace logs, a query history from PostgreSQL, an explanation of your reasoning, and preferably a self-contained test case allowing others to reproduce the issue without having to have freeswitch etc. -- Craig Ringer

Re: [BUGS] BUG #6246: character encoding for 64 bit

2011-10-12 Thread Craig Ringer
nverted to LATIN1. It sounds like psql on 9.1 is correctly detecting the shell's encoding, wheras 9.0 is assuming utf-8. Whoopsie! If that's the case, try running "chcp 65001" before "psql". See if that helps. -- Craig Ringer -- Sent via pgsql-bugs mailing list (

Re: [BUGS] BUG #6252: After drop the default database 'postgres', I can not create a database by 'createdb.exe'

2011-10-12 Thread Craig Ringer
eatedb.exe the follow error message will dispaly: Can not create DB by 'createdb.exe' when database 'postgres' is droped Yep. You need to use a `CREATE DATABASE' command from psql to re-create the `postgres' database after connecting to the "template1" data

Re: [BUGS] BUG #6255: Unable to Install (Binary, One Click Installer

2011-10-17 Thread Craig Ringer
nother system? If so, using pg_restore, a sql dump, or something else? -- Craig Ringer -- 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] Can't use WITH in a PERFORM query in PL/pgSQL?

2011-10-19 Thread Craig Ringer
n then permit bare SELECTs, emitting their output as a resultset. -- Craig Ringer -- 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] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe

2011-10-20 Thread Craig Ringer
? Some "interesting" commands (I'm looking at you, rsync) are guilty of changing behavior based on that. -- Craig Ringer -- 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] BUG #6265: Installation failure at the very beginning

2011-10-24 Thread Craig Ringer
t happen on a correct Windows install. Make sure that the location pointed to by %TEMP% is writable. You can press "Start->Run" then type "%TEMP%" and press enter to open the %TEMP% folder. Which folder is it? The full path to the folder should be shown in the navigation ba

Re: [BUGS] BUG #6273: Install Error

2011-10-27 Thread Craig Ringer
installation, it throws on error stating database cluster initialization failed. I was wondering what the fix for this issue would be. Not enough information. Please try: http://wiki.postgresql.org/wiki/Troubleshooting_Installation -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] server connection

2011-10-31 Thread Craig Ringer
stance. If there is no entry for postgresql in the services list, then whatever you installed hasn't installed correctly. -- Craig Ringer -- 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] Hanging with pg_restore and large objects

2011-10-31 Thread Craig Ringer
_start_main () from /lib64/libc.so.6 > #11 0x00402f99 in PQconnectdbParams () > #12 0x7fff51ae6188 in ?? () > #13 0x in ?? () > > Does anyone know, what can be wrong? Disk issues? Have you checked dmesg, the SMART status of your disks, and syslog? Can you copy

Re: [BUGS] BUG #6281: need to remove

2011-11-02 Thread Craig Ringer
so the mailing list gets your reply. -- Craig Ringer -- 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] BUG #6281: need to remove

2011-11-05 Thread Craig Ringer
whether it's some different, custom installer made by the poker tracker people. Without that, helping you is nearly impossible. If you can find the installer file for the version of PostgreSQL you installed and can report its file name and file size along with (if possible) where you downlo

Re: [BUGS] BUG #4678: codepage UTF8 crashes psql

2011-11-07 Thread Craig Ringer
quot;Lucidia Console" ? - Does the issue happen with other unicode fonts or just this one? - Are you using the regular cmd.exe console ? -- Craig Ringer -- 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] BUG #6282: psql.exe cannot recognize specific 2byte SJIS character

2011-11-07 Thread Craig Ringer
s a directory separator instead, so try: C:\>psql --file="構築フォルダ¥A_TBL.sql" --dbname=testdb ... or use the UNIX-style path separators that Windows understands and accepts just fine: C:\>psql --file="構築フォルダ/A_TBL.sql" --dbname=testdb -- Craig Ringer -- Sent

Re: [BUGS] Add statistics_collector_listen_addresses to fix hard-coding of "localhost"

2011-11-09 Thread Craig Ringer
e the lack of them? If it should, where does it stop accomodating broken and cut-down OSes? If you want an embedded database for an extremely cut down OS, PostgreSQL isn't particularly suitable for a lot of reasons. For any other use case there's no reason to expect local DNS resolution to

Re: [BUGS] HElp

2011-11-10 Thread Craig Ringer
name ( BASETYPE = base_type, SFUNC = sfunc, STYPE = state_data_type [ , FINALFUNC = ffunc ] [ , INITCOND = initial_condition ] [ , SORTOP = sort_operator ] ) ----- -- Craig Ringer

Re: [BUGS] BUG #6289: help us

2011-11-10 Thread Craig Ringer
gsql-novice/ http://archives.postgresql.org/pgsql-general/ <http://archives.postgresql.org/pgsql-novice/> http://forums.enterprisedb.com/forums/list.page ... after reading this: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems -- Craig Ringer

Re: [BUGS] BUG #6290: converting interval from weeks to days

2011-11-10 Thread Craig Ringer
quite that range. It should probably detect overflow and fail with an error like Pg does with other overflow conditions, though. I think that was probably the point. -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.

Re: [BUGS] BUG #6305: cann't reinstall postgresql

2011-11-24 Thread Craig Ringer
you why Pg failed to start. Because you haven't provided a detailed list of all the steps you've taken, it's hard to know what state your system is in or how it's broken. Please do not reply to this message; use the resources linked to above to ask your question instead. -- C

Re: [BUGS] BUG #6308: Problem w. encoding in client

2011-11-27 Thread Craig Ringer
d error and NOTICE messages you can just set a unicode client_encoding for your restore. -- Craig Ringer -- 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] BUG #6308: Problem w. encoding in client

2011-11-28 Thread Craig Ringer
side-effect of overriding pg_restore's attempt to set the client_encoding? I'm rather surprised you only see this on x64. You're using the same Windows and Pg version for both x64 and x64 but only the x64 test fails? -- Craig Ringer

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

2011-12-04 Thread Craig Ringer
o use such a function for an index?) No, it isn't possible. Index functions must be immutable, not just stable, so their output must be determined entirely by their parameters. At least on newer versions STABLE or VOLATILE functions should be rejected in index expressions. -- Craig Ringe

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

2011-12-04 Thread Craig Ringer
On 12/05/2011 08:16 AM, Andreas Karlsson wrote: On 2011-12-04 15:02, Craig Ringer wrote: - The index isn't always updated. Check out HOT (introduced in 8.4, the release after your current one) which reduces unnecessary index updates in cases where the old and new row can fit on the same

Re: [BUGS] BUG #6331: Cross compile error/aborts. Works if '--disable-spinlock' is used

2011-12-12 Thread Craig Ringer
er way to get those kinds of errors. -- Craig Ringer -- 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] BUG #6331: Cross compile error/aborts. Works if '--disable-spinlock' is used

2011-12-12 Thread Craig Ringer
On 13/12/11 08:43, Tom Lane wrote: > Craig Ringer writes: >> because AFAIK there's no ARM asm code or ARM gcc intrinsics hidden away >> in Pg, and that'd be the only other way to get those kinds of errors. > No, you're mistaken about that: we do have inline asse

Re: [BUGS] BUG #6342: libpq blocks forever in "poll" function

2011-12-16 Thread Craig Ringer
described (thanks for all the detail!) then if client and server are on different hosts this could easily be a NIC driver or HW issue. It'd be interesting to see the output of: ps -C testprogramname -o wchan:80= -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To

Re: [BUGS] BUG #6342: libpq blocks forever in "poll" function

2011-12-16 Thread Craig Ringer
On 12/16/2011 03:45 PM, andreagra...@sogeasoft.com wrote: The following bug has been logged on the website: Bug reference: 6342 Logged by: Andrea Grassi Email address: andreagra...@sogeasoft.com PostgreSQL version: 8.4.8 Operating system: SUSE SLES 10 SP4 64 BIT Description:

Re: R: [BUGS] BUG #6342: libpq blocks forever in "poll" function

2011-12-16 Thread Craig Ringer
te stack in /proc/$pid/stack (where $pid) was the pid of my process but this file doesn't exists !! Why ? Old kernel, maybe? You're running on some kind of enterprise-y distro, so who knows how ancient half the stuff in there is. -- Craig Ringer -- Sent via pgsql-bugs mailing list (

Re: R: R: R: R: [BUGS] BUG #6342: libpq blocks forever in "poll" function

2011-12-20 Thread Craig Ringer
see Google) then using Alt-SysRq-T . This requires a physical keyboard directly connected to the server. It emits the stack information via dmesg. See: http://en.wikipedia.org/wiki/Magic_SysRq_key There's a "sysrqd" that apparently lets you use these features remotely, but I

Re: R: R: [BUGS] BUG #6342: libpq blocks forever in "poll" function

2011-12-20 Thread Craig Ringer
d update it. -- Craig Ringer -- 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] BUG #6387: eror

2012-01-08 Thread Craig Ringer
this: wiki.postgresql.org/wiki/Guide_to_reporting_problems -- Craig Ringer -- 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] BUG #6388: I can not install postgre Sql

2012-01-08 Thread Craig Ringer
WHAT CAN I DO ? At a guess, your computer has a firewall that's blocking connections to localhost. Turn off or disable your 3rd party firewall and try again. -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.po

Re: [BUGS] pltclu install problems

2012-05-21 Thread Craig Ringer
; error (126) when the library its self is missing as when a library it depends on is missing. If you can't figure out what's missing, use Dependency Walker (http://dependencywalker.com) to open pltcl.dll and see what it's looking for. -- Craig Ringer

Re: [BUGS] PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP

2012-05-21 Thread Craig Ringer
erent database in a different environment." ? It hit the list fine. -- Craig Ringer -- 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] PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP

2012-05-21 Thread Craig Ringer
re-trying with your AV disabled or removed? -- Craig Ringer -- 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] BUG #6625: not sufficient privileges to start system service

2012-05-29 Thread Craig Ringer
ave any kind of "security" software like an antivirus suite that might be screwing things up. -- Craig Ringer -- 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] BUG #6647: Password Issue

2012-05-29 Thread Craig Ringer
gres account. Try changing the password of that account to something that you know, and then using that password for the installer. I really wish EDB would add a help link to this part of the installer, it bits people all the time. -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-

Re: [BUGS] BUG #6663: 64bit *conn not handled properly by PQfinish

2012-05-29 Thread Craig Ringer
On 05/24/2012 11:14 AM, gilsonla...@yahoo.com wrote: The following bug has been logged on the website: Bug reference: 6663 Logged by: Gilson Lasco Email address: gilsonla...@yahoo.com PostgreSQL version: 9.1.3 Operating system: Linux Ubuntu 12.04 x64 Description: while PQco

Re: [BUGS] BUG #6678: error in connecting to Pgadmin

2012-06-08 Thread Craig Ringer
ndows Event Viewer (you can find it in the Start Menu by searching for Event Viewer) do you see anything related to the PostgreSQL service? Search for "postgres". In the process list in Proces Explorer or Task Manager, does the "postgres.exe" process appear? There should b

Re: [BUGS] BUG #6679: Can't connect via JDBC Driver

2012-06-08 Thread Craig Ringer
er your connection is configured to use SSL - Whether your server is requesting a client certificate - Whether you're trying to provide a client certificate - The context that surrounded those error messages -- Craig Ringer

Re: [BUGS] BUG #6683: dropping a table with a serial column from an extension needs to explicitely drop the associated seq

2012-06-09 Thread Craig Ringer
n x; ALTER TABLE regress=# \d List of relations Schema | Name | Type | Owner ----+--+---+--- public | test | table | craig (1 row) -- Craig Ringer -- 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] BUG #6685: Concurrency fault in create table

2012-06-10 Thread Craig Ringer
table child_a () inherits (parent) create table child_b () inherits (parent) concurrently (two separate connections) results in an error "concurrent tuple update". Please copy and paste the full error message. Which application are you using? psql directly? Something else? -- Craig Ringe

Re: [BUGS] BUG #6697: postgres.exe crashed

2012-06-18 Thread Craig Ringer
windows small business server 2008 problems? No known issues. Please examine the event viewer to see why the service failed to start, and post the logs from the data\pg_log folder in your PostgreSQL install directory. -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #6697: postgres.exe crashed

2012-06-18 Thread Craig Ringer
windows small business server 2008 problems? No known issues with SBS 2008 exist. It should be like any other Windows server. Please examine the event viewer to see why the service failed to start, and post the logs from the data\pg_log folder in your PostgreSQL install directory. -- Craig

Re: [BUGS] BUG #5823: launchd execution

2012-06-19 Thread Craig Ringer
PM com.apple.launchd: (com.edb.launchd.postgresql-9.1[3736]) Exited with code: 1 6/18/12 7:42:24.985 PM com.apple.launchd: (com.edb.launchd.postgresql-9.1) Throttling respawn: Will start in 10 seconds What's in the system logs (Console.app) ? The PostgreSQL logs? -- Craig Ringer

Re: [BUGS] BUG #5823: launchd execution

2012-06-20 Thread Craig Ringer
d you install a package they'd produced? If they're packaging Pg, it sounds like they need to change the paths so it doesn't tread on the standard installation. -- Craig Ringer

Re: [BUGS] BUG #6705: 32 bit

2012-06-24 Thread Craig Ringer
're ok updating the installer messages I'll collect up a sanitized version that doesn't link to other wiki pages (or make it clear they're external) and convert it for the docs. -- Craig Ringer

Re: [BUGS] BUG #6705: 32 bit

2012-06-25 Thread Craig Ringer
On 06/25/2012 11:10 PM, Dave Page wrote: On Mon, Jun 25, 2012 at 5:41 AM, Craig Ringer wrote: Dave: Is there any chance the installers link to that page from their error dialogs, or a static-and-sanitised version of it in docs? If you're ok updating the installer messages I'll co

Re: [BUGS] BUG #6705: 32 bit

2012-06-26 Thread Craig Ringer
licy, and how/if antivirus can be detected. -- Craig Ringer -- 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] BUG #6705: 32 bit

2012-06-26 Thread Craig Ringer
mitting the report with that info and have a chance to redact portions if desired. For now, though, all I'm talking about is a helping-hand web form with hints about how to find out the exact Windows version, architecture, antivirus in use, etc. Nothing but a web page with some jQuery code

Re: [BUGS] BUG #6705: 32 bit

2012-06-27 Thread Craig Ringer
never done any work in that area at all. That's what I'm hoping is possible, but like you haven't dug into it yet. -- Craig Ringer -- 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] How to run query by command prompt in Postgres

2012-06-27 Thread Craig Ringer
On 06/27/2012 07:15 PM, Kapil Kr. Khandelwal wrote: Dear Team I want to a favour from your side. I want to know, how to run sql query by command prompt in postgres sql. psql http://www.postgresql.org/docs/9.1/static/app-psql.html -- Craig Ringer

Re: [BUGS] BUG #6717: bad file

2012-07-04 Thread Craig Ringer
up and some game came up. You didn't download it from PostgreSQL.org or EnterpriseDB, then. If you did, it got intercepted by malware on your computer. Please provide the URL you downloaded PostgreSQL from and the installer file name and size. -- Craig Ringer -- Sent via pgsql-bugs ma

Re: [BUGS] BUG #6718: Cannot delete, create or check existence of extension

2012-07-04 Thread Craig Ringer
#x27;m assuming the database "development" was loaded from a dump from an older version or was binary-upgraded from an older version. If it was created anew on 9.1, how did the "hstore" type get loaded? -- Craig Ringer -- 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] BUG #6718: Cannot delete, create or check existence of extension

2012-07-05 Thread Craig Ringer
possible to make it work simply and reliably. Since it's a one-off migration during upgrade, it isn't that big a deal. If you need help doing this or you have further questions, please ask for help on the pgsql-general mailing list. -- Craig Ringer

Re: [BUGS] BUG #6718: Cannot delete, create or check existence of extension

2012-07-05 Thread Craig Ringer
On 07/05/2012 10:18 PM, Jaime Casanova wrote: On Thu, Jul 5, 2012 at 1:56 AM, Craig Ringer wrote: On 07/05/2012 02:05 AM, gary.ha...@gmail.com wrote: development=# create extension hstore; ERROR: type "hstore" already exists First, thanks for the info in the report. At a guess,

Re: [BUGS] Problem with pg_upgrade

2012-07-05 Thread Craig Ringer
again, does pg_upgrade then run? -- Craig Ringer

Re: [BUGS] BUG #6720: Its often disconnecting

2012-07-05 Thread Craig Ringer
t the same point every time, etc. Honestly, for PgAdmin you're probably better off seeking help on their mailing list: http://www.pgadmin.org/support/list.php as I'm not sure how many of the PgAdmin folks read pgsql-bugs. -- Craig Ringer

Re: [BUGS] BUG #6720: Its often disconnecting

2012-07-05 Thread Craig Ringer
it crashes, whether you can make it crash at the same point every time, etc. Honestly, for PgAdmin you're probably better off seeking help on their mailing list: http://www.pgadmin.org/support/list.php as I'm not sure how many of the PgAdmin folks read pgsql-bugs. -- Craig Ringer

Re: [BUGS] BUG #6720: Its often disconnecting

2012-07-07 Thread Craig Ringer
On 07/08/2012 08:46 AM, Balaji A wrote: Sorry if i came to wrong window ...i just posted my info on the site and thanks i will reach appropriate group. Great. Just remember to include a lot more information when you ask for help on the pgadmin mailing list. -- Craig Ringer

Re: [BUGS] BUG #6727: Column does not exist exception has no error code

2012-07-11 Thread Craig Ringer
On 07/12/2012 02:24 AM, Patrick Tucker wrote: BTW I'm using postgresql-9.1-901.jdbc4.jar Thanks again, A self-contained test case - a small Java program that connects to a test DB, runs a query, and reports the result vs what you expected the result to be - would be helpful. --

Re: [BUGS] BUG #6697: postgres.exe crashed

2012-07-13 Thread Craig Ringer
Reply-to. I've cc'd the list. -- Craig Ringer -- 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] BUG #6735: PANIC: 42501: could not open control file "global/pg_control": Permission denied

2012-07-13 Thread Craig Ringer
e contact the application's support team for more information. server starting I'm not sure why it's crashing here, but you're running such an ancient version that it's hard to care. If you can reproduce the crash with the latest 8.3 point release it might be worth a look

Re: [BUGS] BUG #6735: PANIC: 42501: could not open control file "global/pg_control": Permission denied

2012-07-13 Thread Craig Ringer
ows and see if I can reproduce it. Ideas anyone? Can someone with a Windows box use pg_ctl to try to start a new Pg instance against a datadir with an unwritable pg_control ? -- Craig Ringer -- 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] BUG #6735: PANIC: 42501: could not open control file "global/pg_control": Permission denied

2012-07-16 Thread Craig Ringer
when that's the case, but it's a good idea anyway. Personally I think Pg should let this up to the user, but that's the way it is for now. -- Craig Ringer -- 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] main log encoding problem

2012-07-18 Thread Craig Ringer
main issue is just that code needs to be prototyped, cleaned up, and submitted. So far nobody's cared enough to design it, build it, and get it through patch review. I've just foolishly volunteered myself to work on an automated crash-test system for virtual plug-pull testing, so I'm

Re: [BUGS] main log encoding problem

2012-07-19 Thread Craig Ringer
r-database is useful. I'm not convinced that a weird and uncommon encoding is the answer. I guess as an alternative for people for whom it's useful if it's low cost in terms of complexity/maintenance/etc... -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs@post

Re: [GENERAL] [BUGS] main log encoding problem

2012-07-19 Thread Craig Ringer
Encoding as a log line prefix is a terrible idea for all sorts of reasons. -- Craig Ringer -- 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] BUG #6746: feature request

2012-07-21 Thread Craig Ringer
the pgsql-general mailing list? It sounds like what you are talking about is table quotas. Try searching the mailing lists for prior discussion on the topic. -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #6763: Severe memory leak with arrays and hstore

2012-07-26 Thread Craig Ringer
grow? What's the output of: SELECT count(sub.user_id), to_char(AVG(sub.n_prefs), '9.99') FROM ( SELECT user_id, count(name) AS n_prefs FROM old_prefs GROUP BY user_id) AS sub; and SELECT pg_size_pretty(pg_total_relation_size('old_prefs')); ? -- Craig Ringe

Re: [BUGS] primary and hot standby database don' work now

2012-07-26 Thread Craig Ringer
this start happening? At random? After a server crash or power loss? After an administrative action? Are you running with fsync=off or using storage that has write caching enabled? -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscri

Re: [BUGS] BUG #6763: Severe memory leak with arrays and hstore

2012-07-26 Thread Craig Ringer
Woah. Your email client did something insane, and I cannot read your message. See below: On 07/26/2012 09:37 PM, karave...@mail.bg wrote: - Craig Ringer (ring...@ringerc.id.au), на 26.07.2012 в 11:17 - On 07/26/2012 09:32 AM, karave...@mail.bg wrote: >> Finally I have mana

Re: [BUGS] BUG #6763: Severe memory leak with arrays and hstore

2012-07-26 Thread Craig Ringer
Hi all Here's a fully self contained, automated test case that demonstrates the leak. Example output on my system, pasted as quote to stop Thunderbird mangling it: $ ./hstore-leak-demo.sh NOTICE: extension "hstore" already exists, skipping CREATE EXTENSION DROP TABLE CREATE TABLE CREATE T

Re: [BUGS] BUG #6763: Severe memory leak with arrays and hstore

2012-07-26 Thread Craig Ringer
leak, but there certainly appears to be one, and you've provided a pretty clear illustration of it. -- Craig Ringer -- 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] BUG #6763: Severe memory leak with arrays and hstore

2012-07-26 Thread Craig Ringer
On 07/27/2012 10:30 AM, Craig Ringer wrote: Hi all Here's a fully self contained, automated test case that demonstrates the leak. Gah. Except it doesn't now, as shown by the text I pasted. WTF? I was *definitely* seeing this on my system. What's changed? Will follow up. --

Re: [BUGS] BUG #6763: Severe memory leak with arrays and hstore

2012-07-26 Thread Craig Ringer
OK, it's certainly leaking, but not in the same drastic way I was able to reproduce manually a couple of times earlier. Self-contained test case attached. $ bash hstore-leak-demo.sh NOTICE: extension "hstore" already exists, skipping CREATE EXTENSION DROP TABLE CREATE TABLE CREATE TABLE INSERT

Re: [BUGS] BUG #6763: Severe memory leak with arrays and hstore

2012-07-26 Thread Craig Ringer
On 07/27/2012 01:47 PM, Tom Lane wrote: Craig Ringer writes: OK, it's certainly leaking, but not in the same drastic way I was able to reproduce manually a couple of times earlier. Self-contained test case attached. Using HEAD with stock parameters, I don't see any significant

Re: [BUGS] BUG #6763: Severe memory leak with arrays and hstore

2012-07-26 Thread Craig Ringer
On 07/27/2012 10:31 AM, Craig Ringer wrote: Ouch. Sure looks like a leak to me, yeah. ... but it turns out I'm not thinking very straight. I forgot to check the size of your `shared_buffers' or `work_mem' and forgot to get you to report `free -m' output after each run to m

Re: [BUGS] BUG #6763: Severe memory leak with arrays and hstore

2012-07-27 Thread Craig Ringer
the leak? Does the test program I posted behave differently on your system? -- Craig Ringer -- 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] BUG #6768: Failure in OBDC

2012-07-27 Thread Craig Ringer
the table-level grant is unaffected by a column-level operation. ... so I think you might need to show what's happening in a bit more detail. Beware that there isn't a big Microsoft Access community here. -- Craig Ringer

Re: [BUGS] BUG #6751: usage flaws in pg_restore

2012-07-30 Thread Craig Ringer
been using PostgreSQL for years now. It's great. Only the usage of pg_restore is annoying Yeah. pg_restore really needs some usability love. I posted a big rant about it a while ago. It's all about finding the time to actually do something about it. -- Craig Ringer -- Sent via pgs

Re: [BUGS] Error on pg_settings.bytea_output for pg9.1

2012-07-30 Thread Craig Ringer
be an option to control its preferred bytea format. It may also be worth turning on log_statement = 'all' in postgresql.conf, starting PgAdmin-III, then looking at the PostgreSQL logs to see if PgAdmin-III is in fact sending a `SET bytea_output` command. -- Craig Ringer

Re: [BUGS] BUG #6768: Failure in OBDC

2012-07-30 Thread Craig Ringer
On 07/31/2012 07:31 AM, Fábio Hentz Lunkes wrote: Sorry, all right. It was my mistake. No worries - thanks for writing back to confirm. That way anyone else having the issue later will have some idea where to look (or not look at least). -- Craig Ringer

Re: [BUGS] Error on pg_settings.bytea_output for pg9.1

2012-07-30 Thread Craig Ringer
self? -- Craig Ringer -- 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] Mac OS X "Lion" issues editing pg_hba.conf and permissions (was: Bug)

2012-08-02 Thread Craig Ringer
and after your edits, *what* permissions you changed on the datadir, etc. -- Craig Ringer

Re: [BUGS] BUG #7479: SERVICE NOT START

2012-08-03 Thread Craig Ringer
be running 8.3.0, right? It should be 8.3.something.) - The full Fedora version - information about your hardware - Your PostgreSQL server logs - Your kernel "dmesg" -- Craig Ringer

Re: [BUGS] Small bug in psqlodbc-09.01 prevents interoperability with LISTSERV

2012-08-07 Thread Craig Ringer
e psqlODBC sources, patch them to resolve your issues, and post the patch as a proposed change on the pgsql-odbc list. I don't work with ODBC (or Windows very much) so I'm not sure I can be of much direct help. -- Craig Ringer

<    1   2   3   4   5   >