[BUGS] BUG #8525: using ltree <@ ltree[] leads too very bad cost estimates

2013-10-14 Thread pavel . rosputko
The following bug has been logged on the website: Bug reference: 8525 Logged by: Pavel Rosputko Email address: pavel.rospu...@gmail.com PostgreSQL version: 9.3.0 Operating system: Linux Description: postgres@a2access=# explain (analyze) select * from locations where t

[BUGS] BUG #8524: PQsendQueryParams with RETURNING clause on a INSERT

2013-10-14 Thread peter . reijnders
The following bug has been logged on the website: Bug reference: 8524 Logged by: Peter Reijnders Email address: peter.reijnd...@verpeteren.nl PostgreSQL version: 9.1.9 Operating system: Debian Wheezy Description: Hai I am implementing a postgresql database interface

Re: [BUGS] BUG #8461: PostgreSQL 9.3 pg_dump heap corruptions

2013-10-14 Thread Marko Tiikkaja
On 10/14/13 2:31 PM, Benjamin Wassermann wrote: but the PG_dump.exe cant free memory which is allocated by libpq.dll. To fix this problem the "libpq.dll" need a new function named "deletePQCharPointer()" libpq already provides that functionality in PQfreemem(): http://www.postgresql.org/docs/

Re: [BUGS] BUG #8461: PostgreSQL 9.3 pg_dump heap corruptions

2013-10-14 Thread Benjamin Wassermann
We finally find out why this problem occurs. PG_dump use some Functions like initPQExpBuffer(..) from the libpq.dll. In this function "initPQExpBuffer(...)" are some memory allocated with malloc(...). (File: "pg_dump.c", line 9366) After the function is successfully dumped to backup file, there

Re: [BUGS] BUG #8515: Random 'relation "..." does not exist'

2013-10-13 Thread Greg Stark
Try SHOW search_path; On both the good and bad connection. Is it possible you have some code setting it and leaving it set incorrectly? -- greg On 12 Oct 2013 23:17, "John R Pierce" wrote: > On 10/9/2013 10:35 AM, nbudu...@gmail.com wrote: > >> Basically, at some point a query, update or inser

Re: [BUGS] BUG #8515: Random 'relation "..." does not exist'

2013-10-12 Thread John R Pierce
On 10/9/2013 10:35 AM, nbudu...@gmail.com wrote: Basically, at some point a query, update or insert will not work and complain about a table not existing, but that table was used without any issue previously. Closing the running connection to the database and reconnecting make that error disappea

Re: [BUGS] BUG #8515: Random 'relation "..." does not exist'

2013-10-12 Thread Tomas Vondra
On 9.10.2013 19:35, nbudu...@gmail.com wrote: > The following bug has been logged on the website: > > Bug reference: 8515 > Logged by: Nicolas Buduroi > Email address: nbudu...@gmail.com > PostgreSQL version: 9.2.4 > Operating system: ArchLinux > Description: > > We'v

Re: [BUGS] BUG #8514: cache lookup failed for relation 421062806

2013-10-12 Thread Tomas Vondra
On 11.10.2013 08:14, Michael Paquier wrote: > On Thu, Oct 10, 2013 at 1:24 AM, wrote: >> my postgresql running file . but sometime i found cache lookup >> failed for relation 421062806 error in postgresql log. can anyone >> tell me significant of this error. > > A relation has disappeared even

Re: [BUGS] BUG #8516: Calling VOLATILE from STABLE function

2013-10-11 Thread Dwayne Towell
> According to the documentation, f() should be marked VOLATILE also, since > calling f() produces side effects. PostgreSQL does not give a warning (or > better yet, an error); I think it should. I think the answer is that function authors are required to prevent functions they mark as STABLE from

[BUGS] BUG #8518: FreeBSD usage in 9.3.1

2013-10-11 Thread david . kumar
The following bug has been logged on the website: Bug reference: 8518 Logged by: david Email address: david.ku...@vsoftcorp.com PostgreSQL version: 9.3.1 Operating system: Windows 7 Description: Hi All, I had tried using FreeBSD disk encryption but unable to find to

Re: [BUGS] BUG #8516: Calling VOLATILE from STABLE function

2013-10-11 Thread Tom Lane
Terje Elde writes: > Would it be possible (and make sense) to solve this in a completely different > way, not walking the function tree or doing static analysis, but simply > setting and checking a bit during execution? While it's possible that we could do something like that, I think it's fair

Re: [BUGS] BUG #8516: Calling VOLATILE from STABLE function

2013-10-11 Thread Terje Elde
On Oct 11, 2013, at 9:21 AM, Dimitri Fontaine wrote: > Inter function dependencies is a hard topic indeed. I still would like > to see some kind of progress being made someday. The general case is > turing complete tho, because you can use EXECUTE against programatically > generated SQL. > > You

Re: [BUGS] BUG #8516: Calling VOLATILE from STABLE function

2013-10-11 Thread Dimitri Fontaine
'Bruce Momjian' writes: > Well, we can't walk the function tree to know all called functions, and > those they call, so we don't even try. Inter function dependencies is a hard topic indeed. I still would like to see some kind of progress being made someday. The general case is turing complete th

Re: [BUGS] BUG #8514: cache lookup failed for relation 421062806

2013-10-10 Thread Michael Paquier
On Thu, Oct 10, 2013 at 1:24 AM, wrote: > my postgresql running file . but sometime i found cache lookup failed for > relation 421062806 error in postgresql log. can anyone tell me significant > of this error. A relation has disappeared even if the session hold a sufficient lock on it, ensuring t

Re: [BUGS] BUG #8467: Slightly confusing pgcrypto example in docs

2013-10-10 Thread Bruce Momjian
On Thu, Oct 10, 2013 at 08:32:32PM -0400, Bruce Momjian wrote: > > > How can the later entry not be MD5 hash? > > > > Because what you pass to the functions is 'md5', not 'md5 hash', which > > is what the new text appears to indicate. > > So if we revert, will it still be clear what is MD5 and w

Re: [BUGS] BUG #8467: Slightly confusing pgcrypto example in docs

2013-10-10 Thread Bruce Momjian
On Thu, Oct 10, 2013 at 08:22:30PM -0400, Peter Eisentraut wrote: > On Thu, 2013-10-10 at 19:14 -0400, Bruce Momjian wrote: > > > The changes shown below are incorrect, I think. > > > > > > > > > On 10/2/13 12:00 PM, Bruce Momjian wrote: > > > > *** gen_salt(type text [, iter_count in

Re: [BUGS] BUG #8467: Slightly confusing pgcrypto example in docs

2013-10-10 Thread Peter Eisentraut
On Thu, 2013-10-10 at 19:14 -0400, Bruce Momjian wrote: > > The changes shown below are incorrect, I think. > > > > > > On 10/2/13 12:00 PM, Bruce Momjian wrote: > > > *** gen_salt(type text [, iter_count integer > > > *** 353,359 > > > 12 years > > > > > >

Re: [BUGS] BUG #8516: Calling VOLATILE from STABLE function

2013-10-10 Thread 'Bruce Momjian'
On Thu, Oct 10, 2013 at 04:10:35PM -0700, Dwayne Towell wrote: > > According to the documentation, f() should be marked VOLATILE also, since > > calling f() produces side effects. PostgreSQL does not give a warning (or > > better yet, an error); I think it should. > > I think the answer is that fu

Re: [BUGS] BUG #8467: Slightly confusing pgcrypto example in docs

2013-10-10 Thread Bruce Momjian
On Thu, Oct 10, 2013 at 04:05:50PM -0400, Peter Eisentraut wrote: > The changes shown below are incorrect, I think. > > > On 10/2/13 12:00 PM, Bruce Momjian wrote: > > *** gen_salt(type text [, iter_count integer > > *** 353,359 > > 12 years > > > > > >

Re: [BUGS] BUG #8516: Calling VOLATILE from STABLE function

2013-10-10 Thread Bruce Momjian
On Wed, Oct 9, 2013 at 08:58:46PM +, dwa...@docketnavigator.com wrote: > The following bug has been logged on the website: > > Bug reference: 8516 > Logged by: Dwayne Towell > Email address: dwa...@docketnavigator.com > PostgreSQL version: 9.2.4 > Operating system: CentOS

Re: [BUGS] BUG #8517: Problem due to libeay32.dll about ordinal

2013-10-10 Thread John R Pierce
On 10/10/2013 6:27 AM, s.mech...@gmail.com wrote: I'm trying since yesterday to install a software which needs to install postgreSQL 8.4 aswell. When the installation is finished, a message appears a few times which says "The 3873 ordinal can't be find in the LIBEAY32.dll dynamic library" (in fre

[BUGS] BUG #8517: Problem due to libeay32.dll about ordinal

2013-10-10 Thread s . mechaab
The following bug has been logged on the website: Bug reference: 8517 Logged by: Sémy Email address: s.mech...@gmail.com PostgreSQL version: 8.4.0 Operating system: Windows 7 - 32bits Description: Hello, I'm trying since yesterday to install a software which needs t

[BUGS] BUG #8516: Calling VOLATILE from STABLE function

2013-10-10 Thread dwayne
The following bug has been logged on the website: Bug reference: 8516 Logged by: Dwayne Towell Email address: dwa...@docketnavigator.com PostgreSQL version: 9.2.4 Operating system: CentOS Description: Why doesn't PostgreSQL give a warning when calling a volatile funct

Re: [BUGS] BUG #8467: Slightly confusing pgcrypto example in docs

2013-10-10 Thread Peter Eisentraut
The changes shown below are incorrect, I think. On 10/2/13 12:00 PM, Bruce Momjian wrote: > *** gen_salt(type text [, iter_count integer > *** 353,359 > 12 years > > > !md5 > 2345086 > 1 day > 3 years > --- 358,364 ---

[BUGS] BUG #8515: Random 'relation "..." does not exist'

2013-10-09 Thread nbuduroi
The following bug has been logged on the website: Bug reference: 8515 Logged by: Nicolas Buduroi Email address: nbudu...@gmail.com PostgreSQL version: 9.2.4 Operating system: ArchLinux Description: We've recently migrated an application from MySQL to Postgres and I've

[BUGS] BUG #8514: cache lookup failed for relation 421062806

2013-10-09 Thread shahtejas2811
The following bug has been logged on the website: Bug reference: 8514 Logged by: Tejas Email address: shahtejas2...@gmail.com PostgreSQL version: 8.4.0 Operating system: Linux 7.2 Description: my postgresql running file . but sometime i found cache lookup failed for

Re: [BUGS] BUG #8500: Upgrade to postgis 2.1 breaks existing databases

2013-10-09 Thread Devrim GÜNDÜZ
Hi, I *think* I fixed this problem. We will release updated packages tomorrow, along with the PostgreSQL minor release updates. Please let me know if they still don't work. :) Regards, Devrim On Fri, 2013-10-04 at 13:26 +, kyri...@alumni.princeton.edu wrote: > The following bug has been log

[BUGS] BUG #8513: Error recognizing data type in union

2013-10-09 Thread tommi . korhonen
The following bug has been logged on the website: Bug reference: 8513 Logged by: Tommi Korhonen Email address: tommi.korho...@thl.fi PostgreSQL version: 8.4.17 Operating system: Redhat Linux Description: Example: create table t1(a integer); create table t2(b integer

Re: [BUGS] BUG #8512: Can't use columns I can't read in the where clause of a select

2013-10-08 Thread Stephen Frost
* k...@roeckx.be (k...@roeckx.be) wrote: > Allows SELECT from any column, or the specific columns listed, of the > specified table, view, or sequence. Also allows the use of COPY TO. This > privilege is also needed to reference existing column values in UPDATE or > DELETE. > > > I read that a

[BUGS] BUG #8512: Can't use columns I can't read in the where clause of a select

2013-10-08 Thread kurt
The following bug has been logged on the website: Bug reference: 8512 Logged by: Kurt Roeckx Email address: k...@roeckx.be PostgreSQL version: 9.0.6 Operating system: Linux Description: Hi, When I read the documentation for GRANT, I see: SELECT Allows SELECT f

Re: [BUGS] BUG #8467: Slightly confusing pgcrypto example in docs

2013-10-08 Thread Bruce Momjian
On Wed, Oct 2, 2013 at 12:00:44PM -0400, Bruce Momjian wrote: > Based on your report, I have developed the attached doc patch which > clarifies when MD5 hash is being referenced, and when MD5 crypt is. I > have also added your other suggestions. Patch applied, and backpatched to 9.3.X. Thanks f

Re: [BUGS] BUG #8511: some of object dont drop

2013-10-08 Thread Pavan Deolasee
On Tue, Oct 8, 2013 at 1:32 PM, wrote: > The following bug has been logged on the website: > > Bug reference: 8511 > Logged by: Tejas > Email address: shahtejas2...@gmail.com > PostgreSQL version: Unsupported/Unknown > Operating system: Linux > Description: > > cache lookup f

Re: [BUGS] BUG #8511: some of object dont drop

2013-10-08 Thread John R Pierce
On 10/8/2013 1:02 AM, shahtejas2...@gmail.com wrote: The following bug has been logged on the website: Bug reference: 8511 Logged by: Tejas Email address: shahtejas2...@gmail.com PostgreSQL version: Unsupported/Unknown Operating system: Linux Description: cache lookup faile

[BUGS] BUG #8511: some of object dont drop

2013-10-08 Thread shahtejas2811
The following bug has been logged on the website: Bug reference: 8511 Logged by: Tejas Email address: shahtejas2...@gmail.com PostgreSQL version: Unsupported/Unknown Operating system: Linux Description: cache lookup failed for relation 421062806 -- Sent via pgsql

Re: [BUGS] BUG #8493: Changing file permissions on all files during install

2013-10-07 Thread Sandeep Thakkar
Hi Installer does not change the permissions on all files.. it just changes the permissions on the folders mentioned in the data directory path (except C:\ and C:\Program Files).. It may be because of the inheritance that icacls just scans through all the files.. Anyways, in 9.3.1, by default the

Re: [BUGS] BUG #8470: 9.3 locking/subtransaction performance regression

2013-10-06 Thread Alvaro Herrera
Alvaro Herrera wrote: > AFAICS the problem here is that this test doesn't use MultiXactIds at > all in 9.2, but it does in 9.3. I vaguely recall Noah tried to convince > me to put in an optimization which would have avoided this issue; I will > give that a thought. I don't think I will be able to

[BUGS] bug fixing request

2013-10-05 Thread Aditya srivastava
sir, I want to do bug fixing for your project.At present i am pursuing b.tech in computer science.c and c++ are the languages of my interest. i would be very delightful if i could work for your company. Thank you Aditya srivastava regards

Re: [BUGS] BUG #8470: 9.3 locking/subtransaction performance regression

2013-10-05 Thread Alvaro Herrera
Oskari Saarenmaa wrote: > 05.10.2013 01:31, Alvaro Herrera kirjoitti: > > AFAICS the problem here is that this test doesn't use MultiXactIds at > > all in 9.2, but it does in 9.3. I vaguely recall Noah tried to convince > > me to put in an optimization which would have avoided this issue; I will >

Re: [BUGS] BUG #8470: 9.3 locking/subtransaction performance regression

2013-10-05 Thread Alvaro Herrera
Oskari Saarenmaa wrote: > 05.10.2013 01:31, Alvaro Herrera kirjoitti: > > AFAICS the problem here is that this test doesn't use MultiXactIds at > > all in 9.2, but it does in 9.3. I vaguely recall Noah tried to convince > > me to put in an optimization which would have avoided this issue; I will >

Re: [BUGS] BUG #8498: pg_trgm is missing from windows edb package

2013-10-05 Thread Michael Paquier
On Sat, Oct 5, 2013 at 9:38 PM, Dave Page wrote: > > >> On 5 Oct 2013, at 13:21, Michael Paquier wrote: >> >>> On Fri, Oct 4, 2013 at 11:36 AM, Paragon Corporation wrote: >>> Disregard my bug complaint. Stupid user error. >> Btw, the next time you find an error with this installer, you should >

Re: [BUGS] BUG #8469: Xpath behaviour unintuitive / arguably wrong

2013-10-05 Thread Bruce Momjian
On Fri, Oct 4, 2013 at 10:20:46PM +0200, Stefan Kaltenbrunner wrote: > >> http://www.postgresql.org/message-id/201106291934.23089.rsmog...@softperience.eu > > > > There are two other similar bug reports on this from February and March > > of this year: > > > > > > http://www.postgresql.org/

Re: [BUGS] BUG #8498: pg_trgm is missing from windows edb package

2013-10-05 Thread Dave Page
> On 5 Oct 2013, at 13:21, Michael Paquier wrote: > >> On Fri, Oct 4, 2013 at 11:36 AM, Paragon Corporation wrote: >> Disregard my bug complaint. Stupid user error. > Btw, the next time you find an error with this installer, you should > not use this mailing list for this purpose but contact

Re: [BUGS] BUG #8498: pg_trgm is missing from windows edb package

2013-10-05 Thread Michael Paquier
On Fri, Oct 4, 2013 at 11:36 AM, Paragon Corporation wrote: > Disregard my bug complaint. Stupid user error. Btw, the next time you find an error with this installer, you should not use this mailing list for this purpose but contact directly EDB as this installer is maintained by them and not by

Re: [BUGS] BUG #8470: 9.3 locking/subtransaction performance regression

2013-10-05 Thread Oskari Saarenmaa
05.10.2013 01:31, Alvaro Herrera kirjoitti: > AFAICS the problem here is that this test doesn't use MultiXactIds at > all in 9.2, but it does in 9.3. I vaguely recall Noah tried to convince > me to put in an optimization which would have avoided this issue; I will > give that a thought. I don't t

Re: [BUGS] BUG #8470: 9.3 locking/subtransaction performance regression

2013-10-04 Thread Alvaro Herrera
AFAICS the problem here is that this test doesn't use MultiXactIds at all in 9.2, but it does in 9.3. I vaguely recall Noah tried to convince me to put in an optimization which would have avoided this issue; I will give that a thought. I don't think I will be able to get it done for 9.3.1 though.

Re: [BUGS] BUG #8469: Xpath behaviour unintuitive / arguably wrong

2013-10-04 Thread Stefan Kaltenbrunner
On 10/02/2013 06:19 PM, Bruce Momjian wrote: > On Tue, Sep 24, 2013 at 06:43:19PM +, dennis.noord...@helsinki.fi wrote: >> The following bug has been logged on the website: >> >> Bug reference: 8469 >> Logged by: Dennis >> Email address: dennis.noord...@helsinki.fi >> Postgre

[BUGS] BUG #8500: Upgrade to postgis 2.1 breaks existing databases

2013-10-04 Thread kyrimis
The following bug has been logged on the website: Bug reference: 8500 Logged by: Kriton Kyrimis Email address: kyri...@alumni.princeton.edu PostgreSQL version: 9.2.4 Operating system: Scientific Linux 6.4 Description: The version of postgis, available in the postgresq

Re: [BUGS] BUG #8434: Why does dead lock occur many times ?

2013-10-04 Thread Alvaro Herrera
I spent a lot of time looking at this issue. Your problem scenario can be reduced to the following test case: CREATE TABLE t (a INT); INSERT INTO t VALUES (1); The three sessions need to execute the following commands, in this sequence: -- Session 1 /* 1 */ BEGIN; SELECT * FROM t FOR UPDATE; -

Re: [BUGS] BUG #8496: psqlODBC driver does not work well via Excel

2013-10-04 Thread Pavel Stehule
2013/10/4 Heikki Linnakangas > On 02.10.2013 14:57, > manindra.sarkar@brightnorth.**co.ukwrote: > >> Excel does not seem to respond with any data - but does give an idea that >> it >> has made some sort of a connection with the database. SQL commands fail >> from >> being executed. >> > It is st

Re: [BUGS] BUG #8496: psqlODBC driver does not work well via Excel

2013-10-04 Thread Heikki Linnakangas
On 02.10.2013 14:57, manindra.sar...@brightnorth.co.uk wrote: Excel does not seem to respond with any data - but does give an idea that it has made some sort of a connection with the database. SQL commands fail from being executed. I'm afraid you'll have to provide a lot more details for anyone

Re: [BUGS] BUG #8498: pg_trgm is missing from windows edb package

2013-10-03 Thread Paragon Corporation
Disregard my bug complaint. Stupid user error. Thanks, Regina -- 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 #8498: pg_trgm is missing from windows edb package

2013-10-03 Thread lr
The following bug has been logged on the website: Bug reference: 8498 Logged by: Regina Obe Email address: l...@pcorp.us PostgreSQL version: 9.3.0 Operating system: Windows 2003 x 64-bit Description: I noticed when restoring my 9.2 databases to 9.3 that my pg_trgm ext

Re: [BUGS] BUG #8469: Xpath behaviour unintuitive / arguably wrong

2013-10-02 Thread Bruce Momjian
On Tue, Sep 24, 2013 at 06:43:19PM +, dennis.noord...@helsinki.fi wrote: > The following bug has been logged on the website: > > Bug reference: 8469 > Logged by: Dennis > Email address: dennis.noord...@helsinki.fi > PostgreSQL version: 9.3.0 > Operating system: FreeBSD 9.2

Re: [BUGS] BUG #8467: Slightly confusing pgcrypto example in docs

2013-10-02 Thread Bruce Momjian
On Tue, Sep 24, 2013 at 11:20:55PM +0100, Richard Neill wrote: > I'm sorry about that: I think I need to correct my proposed > correction! I think I've been writing too much C recently, and so I > foolishly mis-read that as returning pswhash, rather than returning > the truth of the comparison. >

[BUGS] BUG #8496: psqlODBC driver does not work well via Excel

2013-10-02 Thread manindra . sarkar
The following bug has been logged on the website: Bug reference: 8496 Logged by: Mani Email address: manindra.sar...@brightnorth.co.uk PostgreSQL version: 9.2.0 Operating system: MacOS 10.8 ML Description: I have tried using the psqlODBC driver with Excel but it does

Re: [BUGS] BUG #8494: Cannot Backup / Restore

2013-10-01 Thread Mark Kirkwood
On 01/10/13 15:17, h...@canwrx.com wrote: a) My version is Postgres Enterprise Manager version 3.0.0, copyright 2002-2012, the pgAdmin Development Team; and Postgres Plus Advanced Server 9.2 Hi - your product is supported by Enterprisedb (http://www.enterprisedb.com/). I think you would

Re: [BUGS] BUG #8495: PLSQL PG Terrible performance by using two-dimensional arrays.

2013-10-01 Thread Pavel Stehule
Hello 2013/10/1 > The following bug has been logged on the website: > > Bug reference: 8495 > Logged by: Miguel A. Manso Callejo > Email address: m.ma...@upm.es > PostgreSQL version: 9.1.9 > Operating system: Ubuntu 12.04LTS > Description: > > I'm trying to random access to

[BUGS] BUG #8495: PLSQL PG Terrible performance by using two-dimensional arrays.

2013-10-01 Thread m . manso
The following bug has been logged on the website: Bug reference: 8495 Logged by: Miguel A. Manso Callejo Email address: m.ma...@upm.es PostgreSQL version: 9.1.9 Operating system: Ubuntu 12.04LTS Description: I'm trying to random access to a 2-dimensional array of doub

[BUGS] BUG #8494: Cannot Backup / Restore

2013-10-01 Thread ha
The following bug has been logged on the website: Bug reference: 8494 Logged by: Le Quan Ha Email address: h...@canwrx.com PostgreSQL version: 9.2.0 Operating system: Windows Server 2012 Description: Dear PostgreSQL, I would like to introduce myself: my name is Le Q

[BUGS] BUG #8492: problem with bigint datatype

2013-09-30 Thread v-alfiya
The following bug has been logged on the website: Bug reference: 8492 Logged by: Alfiya Email address: v-alf...@mail.ru PostgreSQL version: Unsupported/Unknown Operating system: Linux Description: Hello! I used OTL and DataDirect driver- ODBC PostgreSQL Wire Protocol

[BUGS] BUG #8493: Changing file permissions on all files during install

2013-09-30 Thread m8000
The following bug has been logged on the website: Bug reference: 8493 Logged by: Ronny Email address: m8...@abc.se PostgreSQL version: 9.3.0 Operating system: Win 7 Description: Hi Postgresql install is running this command during install: icacls E:\ /grant "NT AU

[BUGS] BUG #8485: Cannot Backup / Restore

2013-09-28 Thread ha
The following bug has been logged on the website: Bug reference: 8485 Logged by: Le Quan Ha Email address: h...@canwrx.com PostgreSQL version: Unsupported/Unknown Operating system: Windows Server 2012 Description: Dear PostgreSQL, I would like to introduce myself: m

[BUGS] BUG #8491: Spanish Interface Language Missing

2013-09-28 Thread ddmartinez
The following bug has been logged on the website: Bug reference: 8491 Logged by: Daniel David Martínez Romera Email address: ddmarti...@geografos.org PostgreSQL version: 9.3.0 Operating system: Windows 7 Description: postgresql-9.3.0-1-windows-x64.exe Installing thi

[BUGS] BUG #8484: Cannot Backup / Restore

2013-09-28 Thread ha
The following bug has been logged on the website: Bug reference: 8484 Logged by: Le Quan Ha Email address: h...@canwrx.com PostgreSQL version: Unsupported/Unknown Operating system: Windows Server 2012 Description: Dear PostgreSQL, I would like to introduce myself: m

Re: [BUGS] BUG #8434: Why does dead lock occur many times ?

2013-09-27 Thread Alvaro Herrera
Hi, Sorry I hadn't noticed this thread. Tomonari Katsumata escribió: > It seems to be related to some changes in > the [Improve concurrency of foreign key locking] commit(*). > (*) commitid : 0ac5ad5134f2769ccbaefec73844f8504c4d6182 > Because I could not reproduce "dead lock" before the commit.

Re: [BUGS] BUG #8434: Why does dead lock occur many times ?

2013-09-27 Thread Tomonari Katsumata
Hi, Thanks to your info, otsuka-san. It seems to be related to some changes in the [Improve concurrency of foreign key locking] commit(*). (*) commitid : 0ac5ad5134f2769ccbaefec73844f8504c4d6182 Because I could not reproduce "dead lock" before the commit. And I'm thinking that also this commit is

[BUGS] BUG #8483: Text lengths issue

2013-09-27 Thread crush6655
The following bug has been logged on the website: Bug reference: 8483 Logged by: Miko Email address: crush6...@gmail.com PostgreSQL version: 9.3.0 Operating system: windows 8 Description: Hello, I have a table with a 'text' column. When I insert a 'short' (lengt

Re: [BUGS] BUG #8455: spanish pgadmin3.mo

2013-09-27 Thread Guillaume Lelarge
On Thu, 2013-09-26 at 21:18 -0400, Bruce Momjian wrote: > On Mon, Sep 16, 2013 at 08:40:57AM +, j.rom...@salsa.es wrote: > > The following bug has been logged on the website: > > > > Bug reference: 8455 > > Logged by: Jesus Romero > > Email address: j.rom...@salsa.es > > Pos

[BUGS] BUG #8472: could not find a \"%s\" to execute. When Directory On %PATH% Has Double Quotes.

2013-09-26 Thread goncons
The following bug has been logged on the website: Bug reference: 8472 Logged by: Luis Gonzalo Constantini Rickel Email address: gonc...@gmail.com PostgreSQL version: 9.2.4 Operating system: Windows Description: Hi, I think that I found the reason why in Windows yo

Re: [BUGS] BUG #8455: spanish pgadmin3.mo

2013-09-26 Thread Bruce Momjian
On Mon, Sep 16, 2013 at 08:40:57AM +, j.rom...@salsa.es wrote: > The following bug has been logged on the website: > > Bug reference: 8455 > Logged by: Jesus Romero > Email address: j.rom...@salsa.es > PostgreSQL version: 9.1.9 > Operating system: Ubuntu server 12.04 > Des

[BUGS] BUG #8471: subquery where not being applied until outer query

2013-09-26 Thread dnrickner
The following bug has been logged on the website: Bug reference: 8471 Logged by: Dan Rickner Email address: dnrick...@taylor.edu PostgreSQL version: 9.2.4 Operating system: CentOS Description: Our ERP stores student GPA values as a text string. I am trying to select

Re: [BUGS] BUG #8450: pg_basebackup blocks until WAL archiving successful

2013-09-25 Thread Stuart Bishop
On Mon, Sep 23, 2013 at 3:33 PM, Heikki Linnakangas > I can see why you'd want that, but it seems equally problematic to let > pg_basebackup return, when the WAL files haven't been archived yet and you > therefore don't in fact have valid, restorable backup yet. Have you > considered using the --x

Re: [BUGS] BUG #8470: 9.3 locking/subtransaction performance regression

2013-09-25 Thread Alvaro Herrera
o...@ohmu.fi wrote: > The following code performs a lot slower on PostgreSQL 9.3.0 than on > PostgreSQL 9.2.4: > > DROP TABLE IF EXISTS tmp; > CREATE TABLE tmp (id BIGSERIAL, vals BIGINT[]); > DO $$ > DECLARE > r_id BIGINT; > n BIGINT; > BEGIN > FOR n IN 1..1000 LOOP > BEGIN

[BUGS] BUG #8470: 9.3 locking/subtransaction performance regression

2013-09-25 Thread os
The following bug has been logged on the website: Bug reference: 8470 Logged by: Oskari Saarenmaa Email address: o...@ohmu.fi PostgreSQL version: 9.3.0 Operating system: Linux Description: The following code performs a lot slower on PostgreSQL 9.3.0 than on PostgreSQL

Re: [BUGS] BUG #8468: Create index on type tstzrange fail

2013-09-25 Thread Heikki Linnakangas
On 24.09.2013 14:42, marian.kruc...@gmail.com wrote: CREATE INDEX ON tstzrange fail on 9.3.0 and 9.2.4 - default postgres configuration. It ate whole memory and was killed by oom. Example: postgres=# CREATE TABLE range_test AS SELECT tstzrange(t, t+'1min') tr FROM generate_series('2000-1-1'::TI

Re: [BUGS] BUG #8467: Slightly confusing pgcrypto example in docs

2013-09-24 Thread Richard Neill
Dear Magnus, Thanks for your reply. On 24/09/13 18:31, Magnus Hagander wrote: The following bug has been logged on the website: Bug reference: 8467 The documentation for pgcrypto: http://www.postgresql.org/docs/current/static/pgcrypto.html (and indeed all versions from 8.3-9.3) contains

[BUGS] BUG #8469: Xpath behaviour unintuitive / arguably wrong

2013-09-24 Thread dennis . noordsij
The following bug has been logged on the website: Bug reference: 8469 Logged by: Dennis Email address: dennis.noord...@helsinki.fi PostgreSQL version: 9.3.0 Operating system: FreeBSD 9.2-RC4 Description: Hi, After upgrading an 8.1 version to 9.3.0 I am suddenly seei

Re: [BUGS] BUG #8467: Slightly confusing pgcrypto example in docs

2013-09-24 Thread Magnus Hagander
On Tue, Sep 24, 2013 at 1:11 AM, wrote: > The following bug has been logged on the website: > > Bug reference: 8467 > Logged by: Richard Neill > Email address: postgre...@richardneill.org > PostgreSQL version: 9.3.0 > Operating system: Documentation bug > Description: > > The

[BUGS] BUG #8468: Create index on type tstzrange fail

2013-09-24 Thread marian . krucina
The following bug has been logged on the website: Bug reference: 8468 Logged by: marian Email address: marian.kruc...@gmail.com PostgreSQL version: 9.3.0 Operating system: Linux Description: CREATE INDEX ON tstzrange fail on 9.3.0 and 9.2.4 - default postgres configur

[BUGS] BUG #8467: Slightly confusing pgcrypto example in docs

2013-09-24 Thread postgresql
The following bug has been logged on the website: Bug reference: 8467 Logged by: Richard Neill Email address: postgre...@richardneill.org PostgreSQL version: 9.3.0 Operating system: Documentation bug Description: The documentation for pgcrypto: http://www.postgresql.

Re: [BUGS] BUG #8463: Packaging problem with postgis rpms

2013-09-23 Thread Devrim GÜNDÜZ
Hi, Updated packages will be in the repo in the next hour or so. Apologies for the inconvenience. Regards, Devrim On Wed, 2013-09-18 at 13:56 +, kyri...@alumni.princeton.edu wrote: > The following bug has been logged on the website: > > Bug reference: 8463 > Logged by: Kriton

Re: [BUGS] BUG #8465: major dump/reload problem

2013-09-23 Thread Ján Máté
Hi Keikki, it is clear what causes this problem, but pg_upgradecluster is an operation which simply MUST work (if you have several hundred of user databases, it is not an option to check all of them for this kind of error before the cluster upgrade). Database upgrade is performed by the server

Re: [BUGS] BUG #8450: pg_basebackup blocks until WAL archiving successful

2013-09-23 Thread Heikki Linnakangas
On 13.09.2013 15:13, stu...@stuartbishop.net wrote: pg_basebackup blocks until all necessary WAL files have been archived by archive_command. This can take a few minutes under normal circumstances, and indefinitely if archive_command is failing. I would like to be able to disable this check, as

Re: [BUGS] BUG #8465: major dump/reload problem

2013-09-23 Thread Heikki Linnakangas
On 21.09.2013 20:16, jan.m...@inf-it.com wrote: today I tried to upgrade from 9.2 to 9.3 (pg_upgradecluster 9.2 main) and the upgrade of one of my databases failed with the following error: "ERROR: new row for relation ... violates check constraint ...". I created an example to reproduce this bu

Re: [BUGS] BUG #8453: uninitialized memory access in pg_receivexlog and other bugs

2013-09-23 Thread Heikki Linnakangas
On 16.09.2013 22:59, Andrew Gierth wrote: "Heikki" == Heikki Linnakangas writes: Heikki> Attached is a patch to fix both of these issues. I'm too Heikki> tired right now to thoroughly test it and commit, so I'll get Heikki> back to this tomorrow. Meanwhile, please take a look and let

[BUGS] BUG #8465: major dump/reload problem

2013-09-22 Thread jan . mate
The following bug has been logged on the website: Bug reference: 8465 Logged by: Jan Mate Email address: jan.m...@inf-it.com PostgreSQL version: 9.3.0 Operating system: all Description: Hi PostgreSQL team, today I tried to upgrade from 9.2 to 9.3 (pg_upgradecluste

[BUGS] BUG #8466: pg_basebackup backup database is not ok

2013-09-22 Thread liuguanhu
The following bug has been logged on the website: Bug reference: 8466 Logged by: liuguanhu Email address: liugua...@gmail.com PostgreSQL version: 9.1.6 Operating system: CentOS 5.9 Description: hi: I try use pg_basebackup backup my postgresql cluster database,when I u

[BUGS] BUG #8464: Update with subquery with limit occasionally updates too many rows

2013-09-20 Thread jturkel
The following bug has been logged on the website: Bug reference: 8464 Logged by: Joel Turkel Email address: jtur...@salsify.com PostgreSQL version: 9.2.4 Operating system: Ubunutu 12.04 (64-bit)/Kernel version 3.2 Description: An update statement in my application tha

Re: [BUGS] BUG #8449: ODBC Failure with Access 10

2013-09-19 Thread Michael Paquier
On Thu, Sep 12, 2013 at 10:21 AM, wrote: > Bug reference: 8449 > I'm not able to link in Access to the table "map". I get an ODBC error and > in the table fields are no data, it returns "#Name?". > > Any idea what is wrong ? You should be more precise here: - What is the version of ODBC driv

Re: [BUGS] BUG #8452: COPY command pgadmin

2013-09-19 Thread Michael Paquier
On Sat, Sep 14, 2013 at 4:15 PM, wrote: > in short, for pgadmin... This feature request is related to PGAdmin and not Postgres core. You should send such requests to the PGAdmin mailing lists which are listed here: http://www.pgadmin.org/support/list.php Regards, -- Michael -- Sent via pgsql

Re: [BUGS] BUG #8463: Packaging problem with postgis rpms

2013-09-18 Thread Devrim GÜNDÜZ
Hi, Thanks for the report. I created http://wiki.pgrpms.org/ticket/141 to track this bug. There is another critical ticket pending for RHEL 6 packages, so expect the new package pretty soon. Regards, Devrim On Wed, 2013-09-18 at 13:56 +, kyri...@alumni.princeton.edu wrote: > The followin

[BUGS] BUG #8462: psql is trying to access the unix socket in wrong directory

2013-09-18 Thread felipe . diefenbach
The following bug has been logged on the website: Bug reference: 8462 Logged by: Felipe Diefenbach Email address: felipe.diefenb...@dbseller.com.br PostgreSQL version: 9.2.4 Operating system: Ubuntu 12.04 LTS Description: installed postgres apt repositories for the s

[BUGS] BUG #8461: PostgreSQL 9.3 pg_dump heap corruptions

2013-09-18 Thread benny
The following bug has been logged on the website: Bug reference: 8461 Logged by: Benjamin Wassermann Email address: be...@hegne.de PostgreSQL version: 9.3.0 Operating system: Windows Description: Hi! We are trying to build our own PostgreSQL 9.3 using Visual Studio

[BUGS] BUG #8463: Packaging problem with postgis rpms

2013-09-18 Thread kyrimis
The following bug has been logged on the website: Bug reference: 8463 Logged by: Kriton Kyrimis Email address: kyri...@alumni.princeton.edu PostgreSQL version: 9.2.4 Operating system: Scientific Linux 6.4 Description: (I am submitting this report here, as I assume th

[BUGS] BUG #8460: Stack Builder fails to parse http://www.postgresql.org/applications-v2.xml

2013-09-17 Thread sstewart . fr
The following bug has been logged on the website: Bug reference: 8460 Logged by: Stephen Stewart Email address: sstewart...@gmail.com PostgreSQL version: 9.3.0 Operating system: Windows XP SP3 Description: I have a fresh install of WinXP running in a VirtualBox VM. I

Re: [BUGS] BUG #8458: Missing Fedora RPMs

2013-09-17 Thread Devrim GÜNDÜZ
Hi, On Mon, 2013-09-16 at 16:51 +, l...@cert.org wrote: > > The 9.3 non-RC1 RPMs are missing for Fedora 17 and 18 for i386. My bad, uploaded. > > If those will not be made available, I'd be happy to rebuild from source > once you release the SRPM for 9.3 There are some build issues in F

Re: [BUGS] BUG #8453: uninitialized memory access in pg_receivexlog and other bugs

2013-09-16 Thread Andrew Gierth
> "Heikki" == Heikki Linnakangas writes: >> Also, receivexlog is ignoring .partial and .history files when >> determining which timeline to start streaming from, which means >> that if there are two timeline changes that are not separated by a >> WAL segment switch, it will fail to operat

[BUGS] BUG #8457: Ldap connection with accents

2013-09-16 Thread yoann . perollet
The following bug has been logged on the website: Bug reference: 8457 Logged by: yoann perollet Email address: yoann.perol...@veremes.com PostgreSQL version: 9.0.6 Operating system: Windows 8 x64 Description: I use LDAP authentification with postgres to connect. Bei

[BUGS] BUG #8458: Missing Fedora RPMs

2013-09-16 Thread lrr
The following bug has been logged on the website: Bug reference: 8458 Logged by: Larry Rogers Email address: l...@cert.org PostgreSQL version: 9.3.0 Operating system: Linux Description: Hi: The 9.3 non-RC1 RPMs are missing for Fedora 17 and 18 for i386. If those w

Re: [BUGS] BUG #8453: uninitialized memory access in pg_receivexlog and other bugs

2013-09-16 Thread Heikki Linnakangas
On 15.09.2013 15:02, and...@tao11.riddles.org.uk wrote: The following bug has been logged on the website: Bug reference: 8453 Logged by: Andrew Gierth Email address: and...@tao11.riddles.org.uk PostgreSQL version: 9.3.0 Operating system: any Description: The first snprintf

  1   2   3   4   5   6   7   8   9   10   >