[BUGS] BUG #7906: pg_dump exits successfully after an error

2013-02-26 Thread adam . tomjack
The following bug has been logged on the website: Bug reference: 7906 Logged by: Adam Tomjack Email address: adam.tomj...@zuerchertech.com PostgreSQL version: 9.2.1 Operating system: Linux 2.6.32-39-server #86-Ubuntu SMP x86_64 Description: I have a database that

Re: [BUGS] Possible Bug in 9.2beta3

2012-08-15 Thread Adam Mackler
I can find that seems on point, so, again, my current idea of what ought to be possible is based on a rather uninformed foundation. Adam Mackler On Wed, Aug 15, 2012 at 12:53 PM, Tom Lane wrote: > Adam Mackler writes: >> WITH RECURSIVE >> tab(id_key,link) AS ( VALUES (1,17), (2,17

[BUGS] Possible Bug in 9.2beta3

2012-08-13 Thread Adam Mackler
e and would greatly appreciate any suggestions as to what I could read that would unconfuse me. Otherwise, let me know if you need any other details about my environment. Thanks very much. -Adam Mackler -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- WITH RECURSIVE tab(id_k

Re: [BUGS] BUG #6551: PL/pgSQL: GET DIAGNOSTICS not working for first OUT parameter

2012-03-22 Thread Adam Buraczewski
> Wow, that's been broken since the beginning, apparently.  There's an > entirely bogus test in exec_stmt_getdiag(): Thanks for quick fix! :) Best regards, -- Adam Buraczewski -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your su

[BUGS] BUG #6526: Intermittent connect issue

2012-03-11 Thread adam . robertson
The following bug has been logged on the website: Bug reference: 6526 Logged by: Adam Robertson Email address: adam.robert...@arvixe.com PostgreSQL version: 8.3.7 Operating system: Windows Server 2008 R2 Standard Description: I'm experiencing intermitten

Re: [BUGS] sort order (ORDER BY) hu_HU.UTF-8 locale with UTF-8 encoding is not working correctly on FreeBSD

2011-02-06 Thread Adam PAPAI
Tom Lane wrote: > Adam PAPAI writes: >> [ hu_HU.UTF-8 locale doesn't sort as expected on ] >> FreeBSD titanium 8.1-RELEASE FreeBSD 8.1-RELEASE #0: Mon Jul 19 02:36:49 >> UTC 2010 r...@mason.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC amd64 > > Do you get the

[BUGS] Re: sort order (ORDER BY) hu_HU.UTF-8 locale with UTF-8 encoding is not working correctly on FreeBSD

2011-02-06 Thread Adam PAPAI
Adam PAPAI wrote: The correct encoding of the values are: INSERT INTO test (name) values ( 'a' ); INSERT INTO test (name) values ( 'á' ); INSERT INTO test (name) values ( 'b' ); INSERT INTO test (name) values ( 'c' ); INSERT INTO test (name) values

[BUGS] sort order (ORDER BY) hu_HU.UTF-8 locale with UTF-8 encoding is not working correctly on FreeBSD

2011-02-06 Thread Adam PAPAI
AL block size: 8192 Bytes per WAL segment:16777216 Maximum length of identifiers:64 Maximum columns in an index: 32 Maximum size of a TOAST chunk:1996 Date/time type storage: 64-bit integers Float4 argument passing:

[BUGS] BUG #5605: round(attr_name,int) works bad

2010-08-06 Thread Adam Radlowski
The following bug has been logged online: Bug reference: 5605 Logged by: Adam Radlowski Email address: ad...@informatyka.gdansk.pl PostgreSQL version: 8.4.4 Operating system: Gentoo 64 bit (PSQL 8.4.4), Fedora 12 32 bit (PSQL 8.4.1) Description:round(attr_name,int

[BUGS] BUG #5292: Corrupted installer

2010-01-20 Thread Adam Rakowski
The following bug has been logged online: Bug reference: 5292 Logged by: Adam Rakowski Email address: foo-scr...@o2.pl PostgreSQL version: 8.3 Operating system: Windows Description:Corrupted installer Details: Both one-click installer and zip archive from

[BUGS] Bug report: Wrong version in pg_config

2010-01-12 Thread Adam Matan
URCE -I/usr/include/libxml2 -I/usr/include/tcl8.5 CFLAGS = -g -O2 -g -Wall -O2 -fPIC -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g CFLAGS_SL = -fpic LDFLAGS = -Wl,-Bsymbolic-functions -Wl,--as-needed -Wl,--as-needed LDFLAGS_SL = LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lkrb5 -lcom_err -lgssapi_krb5 -lz -lreadline -lcrypt -ldl -lm This creates confusion with external software packages trying to use pgxs, for example. Any ideas how to solve this? Thanks, Adam

[BUGS] BUG #4682: Control-\ segfaults psql

2009-02-27 Thread Adam Flott
The following bug has been logged online: Bug reference: 4682 Logged by: Adam Flott Email address: a...@npjh.com PostgreSQL version: 8.3.6 Operating system: Debian 5.0 Description:Control-\ segfaults psql Details: 1. psql amarok 2. enter C-\ 3. amarok=# zsh: quit

[BUGS] BUG #4573: download problem

2008-12-09 Thread Adam Pewny
The following bug has been logged online: Bug reference: 4573 Logged by: Adam Pewny Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4-1 Operating system: Windows Vista Description:download problem Details: I have an application, which runs only with this

[BUGS] BUG #4520: Cases where a forign key constraint is not inforced and when it is incorrectly inforced.

2008-11-11 Thread Adam Terrey
The following bug has been logged online: Bug reference: 4520 Logged by: Adam Terrey Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.4 Operating system: Linux Debian 2.6.18-6-amd64 Description:Cases where a forign key constraint is not inforced and when it

Re: [BUGS] BUG #3894: JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name

2008-02-13 Thread Adam Hardy
Kris Jurka on 12/02/08 16:40, wrote: On Tue, 12 Feb 2008, Adam Hardy wrote: Because this rules out certain important features of the JPA framework such as native SQL queries, you may want to prioritize this issue. I will have to use Oracle or mySQL until PostgreSQL can rectify things. I

Re: [BUGS] BUG #3894: JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name

2008-02-12 Thread Adam Hardy
Kris, thanks for the advice. Because this rules out certain important features of the JPA framework such as native SQL queries, you may want to prioritize this issue. I will have to use Oracle or mySQL until PostgreSQL can rectify things. Thanks and regards Adam Kris Jurka on 01/02/08 20:45

Re: [BUGS] BUG #3894: JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name

2008-02-01 Thread Adam Hardy
I think my message below didn't get through, according to error notifications from [EMAIL PROTECTED] Hopefully this will be successful. See copy below. Kris Jurka on 23/01/08 08:51, wrote: On Tue, 22 Jan 2008, Adam Hardy wrote: The following bug has been logged online: Bug refe

Re: [BUGS] BUG #3894: JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name

2008-01-23 Thread Adam Hardy
Kris Jurka on 23/01/08 08:51, wrote: On Tue, 22 Jan 2008, Adam Hardy wrote: The following bug has been logged online: Bug reference: 3894 Description:JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name Details: create schema DEV; but then

[BUGS] BUG #3894: JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name

2008-01-23 Thread Adam Hardy
The following bug has been logged online: Bug reference: 3894 Logged by: Adam Hardy Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Linux Description:JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name

Re: [BUGS] I incrementally altered my database into a state where backups couldn't be restored.

2007-10-31 Thread Adam Tomjack
ALTER TABLEs infrequently enough that I would prefer to spend a little extra time to make sure things are consistent. Adam Tomjack [1] $ pg_dump -U postgres -S postgres test > test.sql $ psql -U postgres -d test -c "DROP SCHEMA public CASCADE;" $ psql -U postgres -d t

[BUGS] I incrementally altered my database into a state where backups couldn't be restored.

2007-10-31 Thread Adam Tomjack
le and fix the broken SELECT. -- === I am not subscribed to this list. If you need clarification, please email me directly. Adam Tomjack Zuercher Technologies LLC 108 E. Missouri Ave. Suite 1 Pierre, SD 57501 (605) 224-4838

[BUGS] PQmakeEmptyPQresult makes my application dumps core?

2007-10-10 Thread Adam PAPAI
Adam PAPAI wooh (at) wooh (dot) hu System Configuration - Architecture: Intel(R) Xeon(TM) CPU 2.80GHz Operating System: Debian/GNU Linux i686 GNU/Linux PostgreSQL version: (PostgreSQL) 7.4.7 Compiler used: gcc 3.3.6 Problem description

[BUGS] BUG #3511: timeofday()::timestamp failing on Saturday when using australian_timezones = on

2007-08-04 Thread Adam
The following bug has been logged online: Bug reference: 3511 Logged by: Adam Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.9 Operating system: Debian etch, using postgresql-8.1:8.1.9-0etch1 Description:timeofday()::timestamp failing on Saturday when using

[BUGS] BUG #3384: Subselects on joins show columns not in the join query.

2007-06-13 Thread Adam Buchbinder
The following bug has been logged online: Bug reference: 3384 Logged by: Adam Buchbinder Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.16 Operating system: Debian GNU/Linux 4.0 Description:Subselects on joins show columns not in the join query. Details

[BUGS] Inconsistant SQL results - Suspected error with query planing or query optimisation.

2007-05-22 Thread adam terrey
"PostgreSQL 8.2.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)" Hardware: AMD Athlon(tm) 64 X2 Dual Core Processor 4400+ 2GB Mem OS: Kernel: Linux version 2.6.18-4-amd64 (Debian 2.6.18.dfsg.1-12)

Re: [BUGS] BUG #3264: SPI: int64's sometimes returned by value sometimes by reference

2007-05-09 Thread Adam Kunen
"Adam Kunen" <[EMAIL PROTECTED]> writes: > I have noticed some discrepencies with 64-bit values in tuples. > For a given row with multiple int8's I have noticed sometimes the value will > be passed by value and sometime by reference. No, int8 datums are always pas

[BUGS] BUG #3264: SPI: int64's sometimes returned by value sometimes by reference

2007-05-09 Thread Adam Kunen
The following bug has been logged online: Bug reference: 3264 Logged by: Adam Kunen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Ubuntu 7.04 - AMD64 Description:SPI: int64's sometimes returned by value sometimes by reference De

[BUGS] Problem configuring PostgreSQL 8.1.4 on Mac OS X

2006-06-07 Thread Adam
l pixel #define _Bool _Bool #define bool bool src/tools/thread/thread_test.c, fired for '--enable-thread-safety', failes for not having the correct definition for 'bool'. I would suggest using 'BOOL' for you boolean variables, instead of 'bool'. P

[BUGS] BUG #2117: inconsistency in sum

2005-12-15 Thread Adam Kolany
The following bug has been logged online: Bug reference: 2117 Logged by: Adam Kolany Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Linux, SuSe 9.2 Description:inconsistency in sum Details: can you explain this

[BUGS] a bug in libpq, PSQL 8.0.3

2005-08-04 Thread Adam Radłowski
psql" program.. I've read carefully (or mabe not ;-) ) the DOC's, but I din't find the answer, what shuld i do. What I expect ? None comments. With greetings Adam ---(end of broadcast)--- TIP 3: Have you checke

[BUGS] BUG #1731: Indexes are corrupt following an unclean shutdown

2005-06-24 Thread Adam Kruger
The following bug has been logged online: Bug reference: 1731 Logged by: Adam Kruger Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.03 Operating system: Linux Description:Indexes are corrupt following an unclean shutdown Details: I have encountered a

Re: [BUGS] BUG #1220: "alter table rename to" inside a transaction

2004-08-18 Thread Adam Sah
well, that's fine I suppose -- but then why does it work the other way for DROP TABLE? i.e. feels like we're confusing "implementation" and "desired semantics" adam Tom Lane wrote: "PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: ==> yikes!

Re: [BUGS] OSX problem with make check...

2004-08-13 Thread Adam Witney
I'm not sure I understand you, but you are saying that it is not working for you, right? Try setting it to export env DYLD_LIBRARY_PATH=/Users/postgres/software/postgresql-8.0.0beta1/src/test/re gress/tmp_check/install/usr/local/pgsql/lib/ adam > I hope we are okay with this... I tr

Re: [BUGS] OSX problem with make check...

2004-08-13 Thread Adam Witney
s post. I notice that it has never built a .dylib library before... In 7.4.x I have always had a libpq.so library. Is this new? Thanks adam -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ---

[BUGS] all 96 tested passed: fedora core 1 (2.4.22-1.2115.nptlsmp) on Intel P4 3.06

2004-08-13 Thread Adam Sah
: yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid runqueue: 0 bogomips: 6121.06 adam ---(end of broadcast)--- TIP 4: Don't &#x

[BUGS] postgres crashes

2004-05-20 Thread Adam Kempa
me, and tell me where is the source of problem: postgres or FreeBSD or both? Thanks in advance. Adam Kempa ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED]

Re: [BUGS] Notes about behaviour of SIMILAR TO operator

2003-11-21 Thread Adam Buraczewski
ssion tests for SIMILAR TO? Is there any guide how to do it (except PostgreSQL sources)? Should the changes be written for CVS HEAD only or 7.4/7.3 branches either? Regards, -- Adam Buraczewski * Linux user #165585 GCS/TW d- s-:+>+:- a C+++() UL$ P++ L E++ W+ N++ o? K w-- O M-

[BUGS] Notes about behaviour of SIMILAR TO operator

2003-11-20 Thread Adam Buraczewski
only explicitly given in ESCAPE clause) so the backslash would be treated as an ordinary character. 6. generally, pattern syntax should be checked more carefully during conversion, so users would not be surprised with error messages not connected with

Re: [BUGS] "ERROR: Query-specified return tuple and actual function

2003-01-14 Thread Adam Buraczewski
uld not take place. I can agree that one should not be able to drop columns when there are some functions using the table as an argument or return type, but it should be possible to drop these functions, then drop some columns and create completely new functions. And now it ends with an error

Re: [BUGS] contrib/adddepend does not properly re-create

2002-12-01 Thread Adam Buraczewski
sides, I generated both patches with "diff -u" command and with some context around :) Regards, -- Adam Buraczewski <[EMAIL PROTECTED]> * Linux registered user #165585 GCS/TW d- s-:+>+:- a- C+++() UL$ P++ L E++ W+ N++ o? K? w-- O M- V- PS+ !PE Y P

Re: [BUGS] contrib/adddepend does not properly re-create multi-column foreign keys.

2002-12-01 Thread Adam Buraczewski
On Sun, Dec 01, 2002 at 02:06:31PM -0500, Tom Lane wrote: > Adam Buraczewski <[EMAIL PROTECTED]> writes: > > I already notified the author of the program and attached patches to > > both original upgrade.pl and contrib/adddepend scripts. > Rod, do you concur that this

[BUGS] contrib/adddepend does not properly re-create multi-column foreign keys.

2002-12-01 Thread Adam Buraczewski
tches to both original upgrade.pl and contrib/adddepend scripts. Regards, -- Adam Buraczewski <[EMAIL PROTECTED]> * Linux registered user #165585 GCS/TW d- s-:+>+:- a- C+++() UL$ P++ L E++ W+ N++ o? K? w-- O M- V- PS+ !PE Y PGP+ t+ 5 X+ R tv- b+ DI? D G++ e+++> h r+>

Re: [BUGS] PostgreSQL 7.3rc1: initdb fais with '-W' switch given in the command line.

2002-11-26 Thread Adam Buraczewski
On Sun, Nov 24, 2002 at 06:37:09PM +0100, Adam Buraczewski wrote: > Initdb fais with '-W' switch given in the command line. Never mind, someone else found the bug as well, it is already removed in CVS tree. :) -- Adam Buraczewski <[EMAIL PROTECTED]> * Linux registered user

[BUGS] PostgreSQL 7.3rc1: initdb fais with '-W' switch given in the command line.

2002-11-26 Thread Adam Buraczewski
Name: Adam Buraczewski Email address : [EMAIL PROTECTED] System Configuration - Architecture : Intel Pentium II Operating System : Linux 2.4.19, glibc 3.2.1 (i686-pc-linux-gnu) PostgreSQL version: PostgreSQL 7.3 RC1 Compiler used

[BUGS] Nie ma mnie w biurze

2002-09-27 Thread Adam Doligalski
W dniu dzisiejszym jestem na urlopie. Jesli sa jakies sprawy nie cierpiace zwloki - prosze skontaktowac sie ze mna pod numerem telefonu 607225738. Adam Doligalski ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

[BUGS] Nie ma mnie w biurze

2002-09-27 Thread Adam Doligalski
W dniu dzisiejszym jestem na urlopie. Jesli sa jakies sprawy nie cierpiace zwloki - prosze skontaktowac sie ze mna pod numerem telefonu 607225738. Adam Doligalski ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL

[BUGS] Nie ma mnie w biurze

2002-09-27 Thread Adam Doligalski
W dniu dzisiejszym jestem na urlopie. Jesli sa jakies sprawy nie cierpiace zwloki - prosze skontaktowac sie ze mna pod numerem telefonu 607225738. Adam Doligalski ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [BUGS] INSERT doesn't like (.)

2000-10-09 Thread Adam Levine
as widely supported as Dynamo that they would have encountered this problem before now. --- adam From: Tom Lane <[EMAIL PROTECTED]> To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: [BUGS] INSERT doesn't like (.) Date: Mon, 09 Oct 2000 10:20:23 -0400 [EMAIL PROTECTED] writes