[BUGS] Installer: Spurious "service account ... not removed" on uninstall

2013-06-30 Thread Craig Ringer
hat if the standard NetworkService account is used, it'd be good to suppress the user account not removed part of the message entirely. http://stackoverflow.com/q/17394116/398670 -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Trai

Re: [BUGS] BUG #7771: packaging error causes build failure

2013-01-05 Thread Craig Ringer
n: > > There are three references to the file @LongLink in the tar file : > postgresql-8.3.22.tar.bz2 Use GNU tar. Your tar doesn't understand the GNU long-filename extensions to the tar format. You'll need GNU make to compile, too. -- Craig Ringer http://www.2ndQuadran

Re: [BUGS] BUG #7760: records with duplicate primary keys

2012-12-24 Thread Craig Ringer
ckup a `pg_dump`? Or a raw copy of the database directory? The pg_dump output won't usually provide much information, it's the actual database on disk that's significant. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sen

Re: [BUGS] Prepared Statement Name Truncation

2012-11-19 Thread Craig Ringer
27;s codebase; I'm just aware it's been a reason for the use of fixed length strings in software in general. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: [BUGS] BUG #7661: pgstattuple from unpackaged fails on old installation

2012-11-15 Thread Craig Ringer
t certain that advice is sufficient for all contrib modules. Extensions were created because upgrading DBs that used contrib modules was a painful mess. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: [BUGS] BUG #7661: pgstattuple from unpackaged fails on old installation

2012-11-14 Thread Craig Ringer
s. You need to upgrade the contrib module install to the current version, *then* wrap the unpackaged contrib module into an extension with "FROM UNPACKAGED". -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Servi

Re: [BUGS] Re: BUG #7628: Installation of PostgreSQL 9.2.1 on Windows 7 may take too long

2012-11-14 Thread Craig Ringer
po in the installer. It was recognised and fixed a few weeks ago; I expect the public installers will have the fix in the next patch release. You can work around it in the mean time by editing your system environment settings to add a SYSTEMDRIVER environment variable. http://support.microso

Re: [BUGS] duplicate key value violates unique constraint "tableName_pk"

2012-11-07 Thread Craig Ringer
able, then merge the data into the target table using appropriate `UPDATE ... FROM ... WHERE` and `INSERT ... SELECT ... WHERE` statements. -- 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 #7638: postgresql taking up all my hard drive space

2012-11-02 Thread Craig Ringer
ttp://archives.postgresql.org/pgsql-general/ . I will not respond to replies that go directly to me. -- Craig Ringer

Re: [BUGS] BUG #7628: Installation of PostgreSQL 9.2.1 on Windows 7 may take too long

2012-10-31 Thread Craig Ringer
for ages on some systems? Or have there been previous problems detected and fixed too? -- 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 #7624: Misleading Log Message & Inconsistent Configuration Design

2012-10-29 Thread Craig Ringer
the CWD explicitly there's no impression given that the user ever actually specified the whole path in the configuration anywhere, so it's clearer how the path came to be. It also shows which part of the path is known-good (since it's the CWD) and which could be at issue. -- Craig

Re: [BUGS] BUG #7620: array_to_json doesn't support heterogeneous arrays

2012-10-28 Thread Craig Ringer
t is not valid to provide a scalar "to_json". I posted patches to support this functionality - as did several others as it turns out - and they've all been rejected. -- 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 #7620: array_to_json doesn't support heterogeneous arrays

2012-10-24 Thread Craig Ringer
: regress=# SELECT ROW(1,'test'); row -- (1,test) (1 row) and output the json: [1,"test"] instead of a json object: regress=# SELECT row_to_json(ROW(1,'test')); row_to_json ------ {"f1":1,"f2":"test&

Re: [BUGS] Posrgresql for Suse linux 64-bit version on OS/390

2012-10-23 Thread Craig Ringer
ing guidelines linked to on the bug report form you used. -- 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 #7619: Query cost estimate appears to not use n_distinct setting

2012-10-23 Thread Craig Ringer
netheless, thanks for writing it up in so much detail and chasing it up further - though it'd be nice if you'd mentioned your earlier post. I'd love to help, but you've clearly already done a lot of work on this and I'm not sure I have anything useful to add. If you do

Re: [BUGS] BUG #7613: INTIDB

2012-10-18 Thread Craig Ringer
ontinue to have 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: [Spam] Re: [BUGS] BUG #7577: JDBC Driver - Compiled with Java 7

2012-10-16 Thread Craig Ringer
On 10/16/2012 08:10 PM, Sean Hogan wrote: On 12-10-16 12:08 AM, Craig Ringer wrote: On 10/15/2012 11:10 PM, seancompusult wrote: Does anyone have a solution for people like me who must use Java 5? I had no problems building current git head of the JDBC driver with Java SE 5, nor the

Re: [BUGS] BUG #7577: JDBC Driver - Compiled with Java 7

2012-10-15 Thread Craig Ringer
/bin:$PATH; export JAVA_HOME=$HOME/java/jdk1.5.0_22/ ant clean jar -- 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 #7603: Application takes long time to fetch data from postgresql database

2012-10-15 Thread Craig Ringer
se patches just for fun, they're released to fix bugs and security issues. See: http://www.postgresql.org/support/versioning/ http://www.postgresql.org/docs/9.0/static/release.html -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to yo

Re: [BUGS] BUG #7602: Select with many joins against the same table is very slow compared to 9.2.0.

2012-10-15 Thread Craig Ringer
and new cases, if possible. At least for the new one. (Please reply to the mailing list, not to me). -- 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 #7600: Database crash with data corruption

2012-10-15 Thread Craig Ringer
t, eg: regress=# SELECT pg_sleep(100); ERROR: canceling statement due to user request so I agree that something isn't right here. Is this something you've been able to reproduce? Or is it a one-off incident so far? -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #7595: terminate process in an unusual way

2012-10-14 Thread Craig Ringer
out of disk space? "Invalid argument" would be an odd error message for that, but who knows with Windows. -- 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 #7592: Installation of PostGresql at c:\Progam files folder does not create right permission on data folder

2012-10-13 Thread Craig Ringer
u use a current installer - at least 9.0.10, preferably 9.2.1. -- 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 #7590: Data corruption using pg_dump only with -Z parameter

2012-10-13 Thread Craig Ringer
ork on a larger backup where some \r\n sequences will occur naturally in compressed binary data. In those you're likely to have a much, much bigger job ahead of you. -- 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 #7590: Data corruption using pg_dump only with -Z parameter

2012-10-13 Thread Craig Ringer
o stdout when in a non-plain-text mode on Windows if that's the case. -- 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 #7595: terminate process in an unusual way

2012-10-13 Thread Craig Ringer
st suspect. -- 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 #7600: Database crash with data corruption

2012-10-13 Thread Craig Ringer
y mistaken. A simple ROLLBACK throws away any IDs that were obtained from sequences in that transaction. If you're saying that the sequence is wrong in that it's LOWER than IDs present in the table, then that's a problem. -- Craig Ringer -- Sent via pgsql-bugs mailing list

Re: [BUGS] Sorry to bother you. Please tell me exactly how the compiler was built ODBC

2012-10-13 Thread Craig Ringer
iling list. It'd help to explain what *exactly* you want to know and why. Do you just need the exact compiler version? Do you need to reproduce the build? Do you need library / build environment info? -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To ma

Re: [BUGS] BUG #7597: exception 0xC0000005

2012-10-11 Thread Craig Ringer
On 10/11/2012 06:07 PM, Bo Thorbjørn Jensen wrote: Self-contained case attached. No crash here on version() = PostgreSQL 9.1.5 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 4.7.0 20120507 (Red Hat 4.7.0-5), 64-bit

Re: [BUGS] Please could you provide more specific step by step instructions to build this driver psqlodbc-09.01.0200 under Windows.

2012-10-02 Thread Craig Ringer
the steps you've followed, the exact text of the error messages, etc etc. Use a pastebin site to paste long errors and just put a link in your email. Please don't reply to me; make a new post on a more suitable list. -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #7556 addition info

2012-09-20 Thread Craig Ringer
18..76.489 rows=4 loops=1) Filter: (id < 5) Total runtime: 672.379 ms (9 rows) which, if so performs signficiantly worse. I'm struggling to understand what exactly your complaint is. It's kind of hard to work out what the intention of the query is in real-worl

Re: [BUGS] BUG #7556: "select not in sub query" plan very poor vs "not exists"

2012-09-19 Thread Craig Ringer
or with `NOT EXISTS`. See eg http://stackoverflow.com/questions/12444142/postgresql-how-to-figure-out-missing-numbers-in-a-column-using-generate-series/12444165#12444165 -- 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 #7558: Postgres service not starting.

2012-09-19 Thread Craig Ringer
x27;t open it now. - You edited pg_hba.conf incorrectly, creating syntax errors. Please do not reply to me, post on -general or SO. -- 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] Postgres JDBC-hibernate Problem

2012-09-18 Thread Craig Ringer
g clear that demonstrates a problem and helps isolate which project(s) the problem is in. -- 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 #7554: save image into database using jsp and servlet

2012-09-18 Thread Craig Ringer
that "Windows 7" doesn't explain much. You need to be specific, eg "Windows 7 Professional x64 Service Pack 1". -- 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 #7549: max_connections check should query master when starting standby

2012-09-17 Thread Craig Ringer
On 09/18/2012 07:57 AM, Fujii Masao wrote: If you change the max_connections on the master, you need to take a fresh backup from the master and start the standby from it. WTF, really? What else breaks the replication and forces a re-clone? -- Craig Ringer -- Sent via pgsql-bugs mailing

Re: [BUGS] Postgres JDBC-hibernate Problem

2012-09-17 Thread Craig Ringer
to trace if you set log_line_prefix to something like: log_line_prefix = '' which produces significantly more verbose logs but makes it easier to, using the pid and txix/vtxid info, work out how different logged statements fit into transactions. -- Craig Ringer -- Sent via pgsql

Re: [BUGS] BUG #7540: Hello. Need Help!

2012-09-16 Thread Craig Ringer
stgreSQL service. At a guess, you failed to set the permissions on the data directory to allow the "postgres" user full control or failed to apply them recursively. -- 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 #7537: Server will not start up from Windows Service Manager

2012-09-16 Thread Craig Ringer
I have no starting point for troubleshooting. Have a look in the Windows event viewer, and see if you can find anything for the PostgreSQL service there. -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.post

Re: [BUGS] Postgres JDBC-hibernate Problem

2012-09-16 Thread Craig Ringer
client library. -- 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 #7527: PgAdmin 1.14.3 fails

2012-09-16 Thread Craig Ringer
-training/pgdownload#windows -- 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 #7526: An error occured executing the Microsoft VC++ runtime installer

2012-09-16 Thread Craig Ringer
try again. Again, see http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#Common_installation_errors and http://wiki.postgresql.org/wiki/Troubleshooting_Installation -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make chang

Re: [BUGS] BUG #7513: Cluster install failed

2012-08-31 Thread Craig Ringer
/Troubleshooting_Installation and send your installer log file. Please reply to pgsql-bugs@postgresql.org not directly to me. -- 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 pgdac - C++ Builder 2007

2012-08-29 Thread Craig Ringer
e two - something funky in your OS/system setup If you were reporting a PostgreSQL bug, you'd want to include things like *version* *numbers*. See: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.or

Re: [BUGS] PostGreSQL pgdac - C++ Builder 2007

2012-08-29 Thread Craig Ringer
nal 'WSAIoctl' referenced from C:\PROGRAM FILES (X86)\CODEGEAR\RAD STUDIO\5.0\LIB\DAC105.LIB|CRVioTcp Does someone know what this could be? Nothing to do with Pg. You're better off asking somewhere specific to C++Builder or specific to this "pgdac" tool. -- Craig Ringer

Re: [BUGS] additional message to the bug #7499

2012-08-22 Thread Craig Ringer
ect queries down to make an incorrect query like yours run how you expect. -- 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 #7499 additional comments

2012-08-22 Thread Craig Ringer
sure that the sort is underspecified. It can't know that the column you've specified isn't unique, or at least unique within the subset of data you're working with. It trusts you to know what you want. The trick is to read the documentation, learn, and test your code wel

Re: [BUGS] BUG #7485: 9.2 beta3 libxml2 can't be loaded on Windows

2012-08-14 Thread Craig Ringer
On 08/14/2012 11:42 PM, Rikard Pavelic wrote: On 8.8.2012. 13:30, Craig Ringer wrote: On 08/08/2012 06:24 PM, rikard.pave...@zg.htnet.hr wrote: The following bug has been logged on the website: Bug reference: 7485 Logged by: Rikard Pavelic Email address: rikard.pave

Re: [BUGS] BUG #6722: Debugger broken?

2012-08-13 Thread Craig Ringer
to do that. Do you? pushing with --force didn't work? git push --force origin mybranch -- 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 #7485: 9.2 beta3 libxml2 can't be loaded on Windows

2012-08-08 Thread Craig Ringer
Argh. Disregard the version comments in my post, I totally failed to notice the version in the subject line. -- 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 #7485: 9.2 beta3 libxml2 can't be loaded on Windows

2012-08-08 Thread Craig Ringer
nothing to do with the problem you linked to. Please follow up with: - Your PostgreSQL version - How you installed PostgeSQL (ie the EnterpriseDB installer, from source, .zip install) - The error message you are getting and the command(s) that cause it - A description of the problem you are h

Re: [BUGS] BUG #7484: while restore database backup error is raised

2012-08-07 Thread Craig Ringer
On 08/08/2012 02:54 PM, John R Pierce wrote: On 08/07/12 11:10 PM, Craig Ringer wrote: Please examine the PostgreSQL server logs for error details. I think they're in /var/lib/pgsql/data/pg_log on CentOS, as that's where they are on Fedora. the PGDG rpm/yum repo of 9.1 defaul

Re: [BUGS] BUG #7484: while restore database backup error is raised

2012-08-07 Thread Craig Ringer
ra. It'd help to know your CentOS version, how you installed PostgreSQL, etc. Are you using any extensions? PostGIS? -- 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] 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

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] 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] 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] 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
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 #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] 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 #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 #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-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
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 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
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
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
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] 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
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] 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: [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] 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: [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] 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] 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-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 #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 #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 #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 #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-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] Problem with pg_upgrade

2012-07-05 Thread Craig Ringer
again, does pg_upgrade then run? -- 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] 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-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 #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] 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 #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] 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-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-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-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 #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 #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 #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 #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 #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 #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

  1   2   3   4   5   >