Re: [BUGS] bug report

2010-10-09 Thread Peter Eisentraut
On fre, 2010-10-08 at 16:13 -0700, Bryson Holland wrote: > what other information do you need from me to make this useful? Platform, version, command line > configure: WARNING: uuid.h: present but cannot be compiled > configure: WARNING: uuid.h: check for missing prerequisite headers? > confi

[BUGS] bug report

2010-10-08 Thread Bryson Holland
what other information do you need from me to make this useful? configure: WARNING: uuid.h: present but cannot be compiled configure: WARNING: uuid.h: check for missing prerequisite headers? configure: WARNING: uuid.h: see the Autoconf documentation configure: WARNING: uuid.h: section "Pr

Re: [BUGS] Bug report (#5456) not showing up on the ML

2010-05-12 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > 2 days ago I made a bug report through the bug reporting form on > postgresql.org regarding some unusual bloat in my TOAST tables, but it still > hasn't shown up on this ML, so I guess it's stuck in the moderation queue. > Could someone look

[BUGS] Bug report (#5456) not showing up on the ML

2010-05-12 Thread Rumko
Hi! 2 days ago I made a bug report through the bug reporting form on postgresql.org regarding some unusual bloat in my TOAST tables, but it still hasn't shown up on this ML, so I guess it's stuck in the moderation queue. Could someone look at it (and hopefully approve it so it ends up here)? I

Re: [BUGS] Bug report: Wrong version in pg_config

2010-01-12 Thread Dimitri Fontaine
Tom Lane writes: > You would need to take that up with whoever packages Postgres for > Ubuntu. It sounds like they have some glitch in the package setup. > AFAIK, whoever that is doesn't read this list, which is mainly for > upstream Postgres development. I think Martin Pitt reads this list, he'

Re: [BUGS] Bug report: Wrong version in pg_config

2010-01-12 Thread Tom Lane
Adam Matan writes: > I'm using postgresql 8.3 in my Ubuntu 8.04 dekstop computer. I have tried to > install postgresql 8.4 for some testing, and removed it afterwards > using *apt-get purge*. > But still, pg_config remains with the removed version, after postresql > restart and even total reboot:

Re: [BUGS] Bug report: Wrong version in pg_config

2010-01-12 Thread Dimitri Fontaine
Adam Matan writes: > But still, pg_config remains with the removed version, after postresql > restart and even total reboot: > > $  pg_config > BINDIR = /usr/lib/postgresql/8.4/bin [...] > This creates confusion with external software packages trying to use pgxs, > for example. > Any ideas how t

[BUGS] Bug report: Wrong version in pg_config

2010-01-12 Thread Adam Matan
Hi, I'm using postgresql 8.3 in my Ubuntu 8.04 dekstop computer. I have tried to install postgresql 8.4 for some testing, and removed it afterwards using *apt-get purge*. There are currently no 8.4 packages installed: *$ dpkg --get-selections | grep postgresql* postgresql-8.3

Re: 답장: [BUGS] bug report

2009-09-16 Thread Tom Lane
Craig Ringer writes: > On Thu, 2009-09-17 at 12:06 +0900, 황수진 wrote: >> Pg version is 8.4.1. >> I am using Windows XP. > Please reply to the list, not just to me. I've cc'd the bugs list. > I don't have much idea what could be causing your issue personally, as I > have practically zero kn

Re: 답장: [BUGS] bug report

2009-09-16 Thread Craig Ringer
On Thu, 2009-09-17 at 12:06 +0900, 황수진 wrote: > Pg version is 8.4.1. > I am using Windows XP. > Please reply to the list, not just to me. I've cc'd the bugs list. I don't have much idea what could be causing your issue personally, as I have practically zero knowledge about locale handling on

Re: [BUGS] bug report

2009-09-16 Thread Craig Ringer
황수진 wrote: > > postgres=# \encoding > EUC_KR > postgres=# CREATE DATABASE 수진이_친구; > WARNING: could not determine encoding for locale "Korean_Korea.949": codeset > is > "CP949" > 상세정보: Please report this to http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] bug report

2009-09-16 Thread 황수진
postgres=# \encodingEUC_KRpostgres=# CREATE DATABASE 수진이_친구;WARNING:  could not determine encoding for locale "Korean_Korea.949": codeset is "CP949"상세정보:  Please report this to .WARNING:  could not determine encoding for locale "Korean_Korea.949": codeset is "CP949"상세정

[BUGS] bug report

2009-04-03 Thread n.franken3
Sir, I have changed Antivirus environment from AVG to Avast . After I have tried to restart my PostgreSQL Server I got 10061 error TCP/IP. Starting the server triggers err 5 ''Access denied'' After this missfaillure I have uninstalled PostgreSQL 8.3. and then I have tried to riinstall Postg

Re: [BUGS] bug report: recrods missing periodically

2006-07-12 Thread WP Goh
i discovered records in my postgresql database missing every 6 - 8 months. i supsect those not updated or amended are the ones that are gone, still wondering the real reason behind ? i doubt is lack of vaccum as my transactions are minnimal, inserting about 200 records each month and updating abou

[BUGS] Bug report regarding reconcilliation

2005-06-30 Thread Chris Travers
Summary: Under certain circumstances, the reconcilliation routine will clear more transactions than expected. Severity: Moderately Severe, not a showstopper, but impacts the consistancy of the accounting data. Frequency: Always Details: When a customer purchases an item with a split payment

Re: [BUGS] Bug Report with Postgres 7.4 on AIX 5.3

2005-05-11 Thread Andrew - Supernews
On 2005-05-11, Vincent Vanwynsberghe <[EMAIL PROTECTED]> wrote: > The AIX 5.3 provide the structure sockaddr_storage : > > struct sockaddr_storage { > ushort_t__ss_family;/* address family */ > char__ss_pad1[_SS_PAD1SIZE]; /* pad up to alignment > field */ >

Re: [BUGS] Bug Report with Postgres 7.4 on AIX 5.3

2005-05-11 Thread Tom Lane
Vincent Vanwynsberghe <[EMAIL PROTECTED]> writes: > The AIX 5.3 provide the structure sockaddr_storage : > ... > In Postgress this structure sockaddr_storage is filled with the structure > sockaddr_un but the size of sockaddr_storage > is less then the size of sockaddr_un and cause a memory overfl

Re: [BUGS] Bug Report with Postgres 7.4 on AIX 5.3

2005-05-11 Thread Vincent Vanwynsberghe
PROTECTED]; pgsql-bugs@postgresql.org > Subject: Re: [BUGS] Bug Report with Postgres 7.4 on AIX 5.3 > > > Vincent Vanwynsberghe <[EMAIL PROTECTED]> writes: > > In our platform the sizeof of struct sockaddr_un is 1025 and > the sizeof of > > SockAddr is 144. > > Doesn&#x

Re: [BUGS] Bug Report with Postgres 7.4 on AIX 5.3

2005-05-10 Thread Tom Lane
Vincent Vanwynsberghe <[EMAIL PROTECTED]> writes: > In our platform the sizeof of struct sockaddr_un is 1025 and the sizeof of > SockAddr is 144. Doesn't AIX provide struct sockaddr_storage? That struct has to be at least as large as any of the other platform-specific sockaddr structs.

[BUGS] Bug Report with Postgres 7.4 on AIX 5.3

2005-05-10 Thread Vincent Vanwynsberghe
Dear Support, We try to install Postgres 7.4 on AIX 5.3 (IBM,9111-520). The compilation is good and we are able to start the postmaster. When we try to start the psql we got the following error : FATAL: unsupported frontend protocol 0.0: server supports 1.0 to 3.0 We run the psql under the AIX d

Re: [BUGS] Bug Report

2005-01-14 Thread Alvaro Herrera
On Fri, Jan 14, 2005 at 09:50:32PM -0400, Elvis E. Henriquez A. wrote: Hi, Please keep the copy to the list when replying. > C:\Documents and Settings\Elvis>psql -h localhost -U postgres -f Update13.sql > prueba > could not find a "psql" to execute > Password: > could not find a "psql" to execu

Re: [BUGS] Bug Report

2005-01-14 Thread Alvaro Herrera
On Tue, Jan 11, 2005 at 07:27:44AM -0400, Elvis E. Henriquez A. wrote: > PostgreSQL RC4 Command prompt functions on Windows (Windows 2000 > Professional - Spanish with SP4) still displays a message in the format: > could not find a "functionname" to execute when executing a psql, pg_dump, > created

[BUGS] Bug Report

2005-01-13 Thread Elvis E. Henriquez A.
PostgreSQL RC4 Command prompt functions on Windows (Windows 2000 Professional - Spanish with SP4) still displays a message in the format: could not find a "functionname" to execute when executing a psql, pg_dump, createdb, createuser and some other functions. They work and do the required job, but

[BUGS] Bug report for Postgresql 8.0-beta1 for WINDOWS.

2004-10-31 Thread Sergey Ushakov
Hello pgsql-bugs, The bug description is as follows: Then server with running postmaster unexpectedly shut down, server cannot be started next time. I've found that manual starting of that service also unsuccessful. I investigated the bug, and found that the .pid file exists at PGDATA

Re: [BUGS] Bug report

2004-10-01 Thread Tom Lane
Andrew Grillet <[EMAIL PROTECTED]> writes: > Original bug I was trying to report is that 7.4.5 builds OK on Freebsd > 4.10 and runs fine, but if you try "createlang" (eg to install plpgsql) > it fails because of undefined symbol "downcase_truncate_identifier". I think you are trying to load a 7.

[BUGS] Bug report

2004-10-01 Thread Andrew Grillet
Hi Bug category serious: The bug report link as www.postgresql.org/bugs/bugs.php is not working. Original bug I was trying to report is that 7.4.5 builds OK on Freebsd 4.10 and runs fine, but if you try "createlang" (eg to install plpgsql) it fails because of undefined symbol "downcase_truncat

[BUGS] Bug Report PostGreSQL win32

2004-09-23 Thread M.Leondaris
Obviously there is a problem with the Potsgre Binary and Zend Optimizer working with PHP!   When uncommenting Zend Extensions in php.ini Postgre causes a child-process error and tries to restart Apache.   Enviroment:   W2K Sp 4   Apache 2.0.50 (service) PHP 5.01 MySQL (service) PostgreSQL (se

Re: [BUGS] bug-report-template

2004-09-10 Thread Tom Lane
Ralf Burger <[EMAIL PROTECTED]> writes: > ./postgresql-8.0.0beta2/bin/psql template1 > ./postgresql-8.0.0beta2/bin/psql: error while loading shared libraries: > ./postgresql-8.0.0beta2/bin/psql: undefined symbol: PQserverVersion You're linking against an old (pre-8.0) libpq. Check your ldconfig s

[BUGS] bug-report-template

2004-09-10 Thread Ralf Burger
POSTGRESQL BUG REPORT TEMPLATE Your name : Ralf Burger Your email address : [EMAIL PROTECTED] Syst

Re: [BUGS] Bug report on Solaris 8/x86

2004-08-13 Thread Tom Lane
Mark Round <[EMAIL PROTECTED]> writes: > I am trying to compile Postgres-8.0.0beta1 on Solaris 8/x86, using Sun's > C compiler, and get the following error which told me to contact you :- > "../../../../src/include/storage/s_lock.h", line 654: #error: PostgreSQL > does not have native spinlock s

[BUGS] Bug report on Solaris 8/x86

2004-08-13 Thread Mark Round
Hi, I am trying to compile Postgres-8.0.0beta1 on Solaris 8/x86, using Sun's C compiler, and get the following error which told me to contact you :- "../../../../src/include/storage/s_lock.h", line 654: #error: PostgreSQL does not have native spinlock support on this platform. To continue the

Re: [BUGS] Bug Report

2003-11-23 Thread Tom Lane
"Douglas M. Westfall" <[EMAIL PROTECTED]> writes: > 1) table contains a valid inet field > 2) query works fine in pgsql 7.2 & 7.3 > 3) query no longer works in pgsql 7.4 > select * from where ilike '%%' ; > ERROR: Unable to identify an operator '~~*' for types 'inet' and '"unknown"' >

Re: [BUGS] Bug Report

2003-11-23 Thread Stephan Szabo
On Sat, 22 Nov 2003, Douglas M. Westfall wrote: > Yes, I have searched the archives, and searches for 'inet' or 'ilike' or > 'inet+ilike' and 'inet&ilike' return 0 results each. > > Have I missed something? I believe your problem is that you were relying on a cast from inet to text (on which ilik

Re: [BUGS] Bug Report

2003-11-22 Thread Douglas M. Westfall
Yes, I have searched the archives, and searches for 'inet' or 'ilike' or 'inet+ilike' and 'inet&ilike' return 0 results each. Have I missed something? Regards, DougW On Thu, 2003-11-20 at 23:09, Douglas M. Westfall wrote: > If PostgreSQL failed to compile on your computer or you found a bug tha

[BUGS] Bug Report

2003-11-22 Thread Douglas M. Westfall
If PostgreSQL failed to compile on your computer or you found a bug that is likely to be specific to one platform then please fill out this form and e-mail it to [EMAIL PROTECTED] To report any other bug, fill out the form below and e-mail it to [EMAIL PROTECTED] If you not only found the problem

Re: [BUGS] Bug Report

2003-10-10 Thread Branden R. Williams
Nuts, my sincere apologies on this one. This is the one server in our entire farm that is not 7.3.4. I'm upgrading right now. Sorry for the inconvenience! On Wed, 8 Oct 2003, Joe Conway wrote: > Branden R. Williams wrote: > >

Re: [BUGS] Bug Report

2003-10-08 Thread Tom Lane
"Branden R. Williams" <[EMAIL PROTECTED]> writes: > When using the replace() function, it appears that some of the output is > filtered through a printf variant. This was fixed as of 7.3.3. regards, tom lane ---(end of broadcast)---

Re: [BUGS] Bug Report

2003-10-08 Thread Joe Conway
Branden R. Williams wrote: POSTGRESQL BUG REPORT TEMPLATE Your name : Branden R. Williams Your email addres

[BUGS] Bug Report

2003-10-08 Thread Branden R. Williams
POSTGRESQL BUG REPORT TEMPLATE Your name : Branden R. Williams Your email address : [EMAIL PROTECTED]

Re: [BUGS] bug report: 7.4beta3 pg_ctl log handling

2003-10-01 Thread Arguile
On Thu, 2003-10-02 at 00:54, Tom Lane wrote: > Arguile <[EMAIL PROTECTED]> writes: > > Simplest case to test is: > > pg_ctl start -D /valid/db/dir -l /invalid/dir > > pg_ctl: /invalid/dir: No such file or directory > > postmaster successfully started > > > Postmaster hasn't started and

Re: [BUGS] bug report: 7.4beta3 pg_ctl log handling

2003-10-01 Thread Tom Lane
Arguile <[EMAIL PROTECTED]> writes: > Simplest case to test is: > pg_ctl start -D /valid/db/dir -l /invalid/dir > pg_ctl: /invalid/dir: No such file or directory > postmaster successfully started > Postmaster hasn't started and the error could probably use some work. If you don't spec

[BUGS] bug report: 7.4beta3 pg_ctl log handling

2003-10-01 Thread Arguile
Simplest case to test is: pg_ctl start -D /valid/db/dir -l /invalid/dir pg_ctl: /invalid/dir: No such file or directory postmaster successfully started Postmaster hasn't started and the error could probably use some work. Perhaps some more tests after line 340 of pg_ctl would be appr

Re: [BUGS] bug report: pg_dump does not use CASCADE in DROP

2003-09-09 Thread Bruce Momjian
Added to TODO: * Have pg_dump -c clear the database using dependency information --- Preston Landers wrote: > >

[BUGS] bug report on pgadmin2 on win95b

2003-09-04 Thread Jim Michaels
POSTGRESQL BUG REPORT TEMPLATE Your name :Jim Michaels Your email address :[EMAIL PROTECTED] Syste

Re: [BUGS] bug report: pg_dump does not use CASCADE in DROP

2003-08-30 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> The correct use of dependency information would be to sort the DROPs > >> into an order that should succeed *without* CASCADE. (This will > >> actually happen for free AIUI, once pg_dump uses dependency info fully

Re: [BUGS] bug report: pg_dump does not use CASCADE in DROP

2003-08-30 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> The correct use of dependency information would be to sort the DROPs >> into an order that should succeed *without* CASCADE. (This will >> actually happen for free AIUI, once pg_dump uses dependency info fully. >> DROPping in the rever

Re: [BUGS] bug report: pg_dump does not use CASCADE in DROP

2003-08-30 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Once pg_dump starts using the dependency information, it seems it could > > do the drops in the proper order, and when it detects > > mutually-dependent tables, it can use a single DROP CASCADE to remove > > them all --- seems like tha

Re: [BUGS] bug report: pg_dump does not use CASCADE in DROP

2003-08-30 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Once pg_dump starts using the dependency information, it seems it could > do the drops in the proper order, and when it detects > mutually-dependent tables, it can use a single DROP CASCADE to remove > them all --- seems like that is a TODO. You missed m

Re: [BUGS] bug report: pg_dump does not use CASCADE in DROP

2003-08-30 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Should we be using CASCADE? Seems that is going to double-drop some > > tables. > > It kinda scares me too. If you are loading into a database that already > has stuff in it, seems like CASCADE could lead to dropping stuff that is >

Re: [BUGS] bug report: pg_dump does not use CASCADE in DROP

2003-08-30 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Should we be using CASCADE? Seems that is going to double-drop some > tables. It kinda scares me too. If you are loading into a database that already has stuff in it, seems like CASCADE could lead to dropping stuff that is not part of the dataset being

Re: [BUGS] bug report: pg_dump does not use CASCADE in DROP

2003-08-30 Thread Bruce Momjian
This is a tough one. The CASCADE shouldn't be needed because the clean should be done in an ordering so that dependency is honored. Of course, that doesn't fix problems with mutually-dependent tables. Should we be using CASCADE? Seems that is going to double-drop some tables.

[BUGS] bug report: pg_dump does not use CASCADE in DROP

2003-08-28 Thread Preston Landers
POSTGRESQL BUG REPORT TEMPLATE Your name : Preston Landers Your email address : [EMAIL PROTEC

Re: [BUGS] "Bug" report - Serious (local shell)

2003-08-14 Thread Diego Linke - GAMK
Hi Stephan, > > Only a bad database superuser should be able to do anything of the sort > because normal users shouldn't be allowed to use CREATE FUNCTION with C > language functions (it's untrusted), are you seeing something different? > I am sorry! I really did not perceive that only one adm

Re: [BUGS] "Bug" report - Serious (local shell)

2003-08-14 Thread Tom Lane
Diego Linke - GAMK <[EMAIL PROTECTED]> writes: > The problem is that postgresql when calls a function in external C, > calls with user of the postgres. The ability to create C functions is reserved to superusers, for exactly this reason. If you have the rights to make the backend execute arbitrar

Re: [BUGS] "Bug" report - Serious (local shell)

2003-08-14 Thread Stephan Szabo
On Thu, 14 Aug 2003, Diego Linke - GAMK wrote: > Your name : Diego Linke > Your email address : [EMAIL PROTECTED] > > System Configuration > - > Architecture (example: Intel Pentium) : Intel > > Operating System (example: Linux 2.0.26 ELF) : NetB

[BUGS] "Bug" report - Serious (local shell)

2003-08-14 Thread Diego Linke - GAMK
POSTGRESQL BUG REPORT TEMPLATE Your name : Diego Linke Your email address : [EMAIL PROTECTED] Syst

Re: [BUGS] Bug report

2003-03-25 Thread Robert E. Bruccoleri
Dear Tom, > > > > If I gave you access to an SGI running PostgreSQL 7.3.2, would you > > be willing to log in and explore the problem "live"? > > You bet. Do you have gdb installed? Thank you so much. WRT to gdb, it's not available. However, you can use dbx, SGI's debugger. It's similar so yo

Re: [BUGS] Bug report

2003-03-21 Thread Tom Lane
> If I gave you access to an SGI running PostgreSQL 7.3.2, would you > be willing to log in and explore the problem "live"? You bet. Do you have gdb installed? regards, tom lane ---(end of broadcast)--- TIP 5: Have you che

Re: [BUGS] Bug report

2003-03-21 Thread Robert E. Bruccoleri
Dear Tom, > > > "Robert E. Bruccoleri" <[EMAIL PROTECTED]> writes: > > The PostgreSQL backend core dumps reproducibly with a set of LOCK commands that > > would normally deadlock. > > Can't duplicate that here, using either 7.3 branch or CVS tip. You sure > you have a clean build? Oh yes, the

Re: [BUGS] Bug report

2003-03-21 Thread Robert E. Bruccoleri
Dear Neil, > > On Thu, 2003-03-20 at 19:26, Robert E. Bruccoleri wrote: > > MIPS Pro 7.4 and MIPS Pro 7.3.1.3, 64 bit compilation model. > > I've seen some other people having troubles with PostgreSQL compiled > with Mips Pro on IRIX/MIPS -- does the problem persist if you recompile > PostgreSQL

Re: [BUGS] Bug report

2003-03-20 Thread Neil Conway
On Thu, 2003-03-20 at 19:26, Robert E. Bruccoleri wrote: > MIPS Pro 7.4 and MIPS Pro 7.3.1.3, 64 bit compilation model. I've seen some other people having troubles with PostgreSQL compiled with Mips Pro on IRIX/MIPS -- does the problem persist if you recompile PostgreSQL with gcc? Cheers, Neil

Re: [BUGS] Bug report

2003-03-20 Thread Tom Lane
"Robert E. Bruccoleri" <[EMAIL PROTECTED]> writes: > The PostgreSQL backend core dumps reproducibly with a set of LOCK commands that > would normally deadlock. Can't duplicate that here, using either 7.3 branch or CVS tip. You sure you have a clean build? regards, tom lan

[BUGS] Bug report

2003-03-20 Thread Robert E. Bruccoleri
POSTGRESQL BUG REPORT TEMPLATE Your name : Robert Bruccoleri Your email address : [EMAIL

Re: [BUGS] Bug report.

2001-11-28 Thread Markus Bertheau
On Tue, 2001-11-27 at 16:39, TONY J.Y. wrote: > However, I got a fatal running error. There is an error when my SQL > string length exceeds 8190 Bytes. PostgreSQL 7.0.x and earlier have a restriction of 8k for a text field. 7.1.x doesn't. You should upgrade. Markus Bertheau msg03166/pgp00

[BUGS] Bug report.

2001-11-28 Thread TONY J.Y.
Hi, I am using the PGLIB C lib to connect to PgSql to finish the update of the GEOMETRY of a table.At first, everything is OK. I can insert, update, delete and select of whatever I want. However, I got a fatal running error.  There is an error when my SQL string length exceeds 8190 Bytes. O

[BUGS] Bug Report

2001-08-20 Thread Pedro Alves
The Database stop inserting new records The Core dump line found in postgres directory:   "FATAL: s_lock(40244634) at bufmgr.c:1257, stuck spinlock. Aborting." My Linux: Linux monitor.moebius.com.br 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686 unknow All my programs and versions (rpm -

Re: [BUGS] bug report: tuple is too big

2001-07-13 Thread Peter Eisentraut
Joel G Guevara writes: > I am using PostgreSQL version 6.5 (included in Red Hat Linux 6.2). bug report: version is too old -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/re

[BUGS] bug report: tuple is too big

2001-07-13 Thread Joel G Guevara
Sir: I was testing my php web content manager yesterday when an error suddenly popped out as I was trying to save my article to the database. The error was "PostgreSQL query failed: Error: Tuple is too big: size 8812". My table schema for the news article: neid serial ne

Re: [BUGS] BUG REPORT

2001-05-30 Thread Tom Lane
"Frank Contrepois" <[EMAIL PROTECTED]> writes: > everything work fine if the query"FOR riga IN SELECT * FROM fr_tab_conv1 > WHERE ordre >= or AND gnum = gn AND glettre = gl ORDER BY ordre DESC LOOP" > return something if not: This is fixed in 7.1.2. regards, tom lane

[BUGS] BUG REPORT

2001-05-30 Thread Frank Contrepois
Hi I use Postgresql 7.1.1 compiled on a P3 running slackware 7.1 with glibc-2.2.1 make-3.79.1 and gxx-2.95.2 and others dev tools upgraded if needed ask me for more. I create this function: DROP FUNCTION inserisci(int4,int4,char(1)); CREATE FUNCTION inserisci(int4,int4,char(1)) RETURNS int4 AS

[BUGS] Bug Report for 7.1 Beta 3

2001-02-12 Thread Josh Berkus
Folks, Please ignore this if you've already fixed these bugs in 7.1 beta 4. Also, please note that I don't subscribe to the bugs list --- sorry, but pgsql-sql is all I can keep up with! BUG REPORT Version: 7.1 beta 3 Platform: SuSE Linux 7.0 Installation: Mixed; 7.0.3 & 7.1 beta paral

[BUGS] Bug Report #25 executeUpdate returns 1

2001-02-05 Thread Davidd
Hello, I too am experiencing problem with executeUpdate returning a 1 when deleting 0 records. My platform is Corel Linux. I am using Java1.3 and JDBC.

Re: [BUGS] Bug report

2000-12-19 Thread Bruno Wolff III
I will see if I can narrow things down a bit. The advantage of the complicated query was that it was killing the backend making the problem obvious. Just using to_char with 'RN' doesn't always do that. Sometimes I get warings during the queries that hint at memory corruption. I am pretty sure tha

Re: [BUGS] Bug report

2000-12-17 Thread Karel Zak
On Fri, 15 Dec 2000, Bruce Momjian wrote: > I think this is fixed in the current snapshot. > > > I am getting problems when using to_char to convert an int4 to roman numeral > > and to_char to convert a timestamp to a string in a view. The errors > > vary, but it looks like there is some sort o

Re: [BUGS] Bug report

2000-12-15 Thread Bruce Momjian
I think this is fixed in the current snapshot. > > POSTGRESQL BUG REPORT TEMPLATE > > > > Your name :

[BUGS] Bug report

2000-12-13 Thread Bruno Wolff III
POSTGRESQL BUG REPORT TEMPLATE Your name : Bruno Wolff III Your email address : [EMAIL

Re: [BUGS] Bug report

2000-11-23 Thread Tom Lane
IIRC, the temp-table support was new and still a little flaky in 6.5.*. I'd suggest updating to 7.0.3. regards, tom lane

[BUGS] Bug report

2000-11-23 Thread Andrea Baldoni
To report any other bug, fill out the form below and e-mail it to [EMAIL PROTECTED] POSTGRESQL BUG REPORT TEMPLATE Yo

[BUGS] Bug report #53

2000-10-27 Thread rob
I am confirming this bug, though it appears that the order of creation is not the issue. If you split the dump files into schema statements and copy data statements and run them sequentially as two different jobs everything works just fine. The issue appears to be that create sequence (maybe cre

Re: [BUGS] bug-report

2000-10-16 Thread Thomas Lockhart
> to_char gives incorrect day conversion of the date 2000/03/26. This is fixed in the current (development) sources. - Thomas

[BUGS] bug-report

2000-10-16 Thread Eivind Kvedalen
POSTGRESQL BUG REPORT Your name : Eivind Kvedalen Your email address : [EMAIL PROTECTED] System C

[BUGS] Bug report: selects rope in tables they shouldn't

2000-07-02 Thread Stephen van Egmond
Sorry for the unformatted bug report, I can't find the bug form on postgresql.org. Version: 7.0 Platform: Debian Linux (woody) running kernel 2.2.14 Question: Is it valid syntax to refer to a table when it's not in the FROM of the select? It's producing awfully wierd output: CREATE TABLE A (

Re: [BUGS] bug report

2000-04-27 Thread Tom Lane
Martin Renters <[EMAIL PROTECTED]> writes: > Backend crash with attached script > The original issue that triggered this was an attempt to implement field > auditing in 7.0beta3. It worked fine as long as the fields were not NULL. > I've simplified the code as much as possible to only print valu

[BUGS] bug report

2000-04-27 Thread Martin Renters
POSTGRESQL BUG REPORT TEMPLATE Your name : Martin Renters Your email address : [EMAIL P

Re: [BUGS] Bug report

2000-04-27 Thread Tom Lane
Eko Purwanto <[EMAIL PROTECTED]> writes: > I think there is a bug when processing VIEW containing view name or > table name WITH SPACE. I believe this is fixed in current sources. regards, tom lane

[BUGS] Bug Report : updated

2000-04-26 Thread Eko Purwanto
When I used psql, I create new view, =>CREATE VIEW "teen customer" AS SELECT name FROM "latest customer" =>WHERE age < 17; CREATE but when I try to use "teen customer" view, use statement below : =>SELECT * FROM "teen customer"; ERROR: nodeRead: Badtype 0 ERROR: nodeRead: Badtype 0 I found Erro

[BUGS] Bug report

2000-04-26 Thread Eko Purwanto
When I used Psql, I create new view, =>CREATE VIEW "teen customer" AS SELECT cusname FROM "latest customer" =>WHERE age < 17; CREATE but when I try to use "teen customer" view, use statement below : =>SELECT * FROM "teen customer"; ERROR: nodeRead: Badtype 0 ERROR: nodeRead: Badtype 0 I found E