Re: [BUGS] pgsql 8.4 "not" + "is contained by" operators return wrong result

2013-07-25 Thread Tom Lane
=?ISO-8859-1?Q?L=E1szl=F3_Lajos_J=E1nszky?= writes: > The following query returns nothing, but it should return 1. > *SELECT 1 FROM NOT(ARRAY[1] <@ NULL**); * I assume you meant SELECT 1 WHERE NOT(ARRAY[1] <@ NULL) ? Because what you wrote doesn't parse. This is not a bug. "ARRAY[1] <@ NULL" y

[BUGS] pgsql 8.4 "not" + "is contained by" operators return wrong result

2013-07-25 Thread László Lajos Jánszky
*Description:* By pgsql 8.4 I have the following bug: If the haystack array is null (for example by empty result of array_agg) by is contained by, and you use it with negation, the the result is false instead of true. *Reproduce:* The following query returns nothing, but it should return 1. *

Re: [BUGS] PGSQL Bug

2013-07-18 Thread bricklen
On Thu, Jul 18, 2013 at 10:52 AM, Michael Kunzmann wrote: > Am 18.07.2013 17:33, schrieb bricklen: > > > On Wed, Jul 17, 2013 at 10:46 PM, Michael Kunzmann < > m...@michaelkunzmann.com> wrote: > >> >> I've noticed the following issue when autostarting PostgreSQL under >> Ubuntu 12.04 64bit by bo

Re: [BUGS] PGSQL Bug

2013-07-18 Thread bricklen
On Wed, Jul 17, 2013 at 10:46 PM, Michael Kunzmann wrote: > > I've noticed the following issue when autostarting PostgreSQL under > Ubuntu 12.04 64bit by bootup. I'm using PostgreSQL 9.1. > > 2013-07-18 06:44:12 CEST FATAL: could not create shared memory segment: > How much RAM do you have, and

Re: [BUGS] PGSQL Bug

2013-07-18 Thread David Johnston
Michael Kunzmann wrote > Hello, > > I've noticed the following issue when autostarting PostgreSQL under > Ubuntu 12.04 64bit by bootup. I'm using PostgreSQL 9.1. > > A manual service start works (service postgresql start). Not sure what you actually think is the bug...especially since PostgreSQL

[BUGS] PGSQL Bug

2013-07-18 Thread Michael Kunzmann
Hello, I've noticed the following issue when autostarting PostgreSQL under Ubuntu 12.04 64bit by bootup. I'm using PostgreSQL 9.1. A manual service start works (service postgresql start). 2013-07-18 06:44:12 CEST FATAL: could not create shared memory segment: Das Argument ist ung?ltig 2013-07-1

[BUGS] pgsql exception

2010-02-22 Thread Ravi
Method in Dao public void savePerson(Person person, List addresses, List emails, List numbers){ call.withProcedureName(" person_save1"); Map out = call.execute(new PGPerson(person),addresses,null,null); } *SP in Database* CREATE OR REPLACE FUNCTION person_save(person_to_save

Re: [BUGS] pgsql-jdbc/pgsql-odbc

2009-11-18 Thread Dave Page
On Thu, Nov 19, 2009 at 12:20 PM, Tom Lane wrote: > I'm less sure about the 1-click installer.  I suspect that a lot of the > people filing bugs here couldn't really tell whether their problem is > specific to the installer or not.  In any case, some of the relevant > EDB people (Dave Page for in

Re: [BUGS] pgsql-jdbc/pgsql-odbc

2009-11-18 Thread Kris Jurka
On Wed, 18 Nov 2009, Tom Lane wrote: Robert Haas writes: I see that there's been no response to bugs #5194, #5187, #5051. Should we consider adding a message to the bug reporting page that suggests emailing the relevant list directly for JDBC/ODBC bugs? +1. Either that or somebody takes r

Re: [BUGS] pgsql-jdbc/pgsql-odbc

2009-11-18 Thread Tom Lane
Robert Haas writes: > I see that there's been no response to bugs #5194, #5187, #5051. > Should we consider adding a message to the bug reporting page that > suggests emailing the relevant list directly for JDBC/ODBC bugs? +1. Either that or somebody takes responsibility for forwarding bug repor

[BUGS] pgsql-jdbc/pgsql-odbc

2009-11-18 Thread Robert Haas
I see that there's been no response to bugs #5194, #5187, #5051. Should we consider adding a message to the bug reporting page that suggests emailing the relevant list directly for JDBC/ODBC bugs? We seem to get a lot of those here. The other frequent one that seems to come up is the one-click in

[BUGS] pgsql problem

2008-01-20 Thread Tanasiciuc Ilie-Ovidiu
Hi. I want to make a trigger for more tables that then i try to make a update to make a new insert. i find a solution in next syntax INSERT INTO TG_RELNAME SELECT NEW.*; RETURN OLD; the problem is that the primary key is violated because NEW.id_client already exists. i try to find a solution for

Re: [BUGS] PGSQL - WARNING: 25P01: there is no transaction in progress

2007-05-04 Thread DNS
Thanks alot, log_statement = all shows where come the errors. On 4 mai, 10:49, [EMAIL PROTECTED] (Heikki Linnakangas) wrote: > DNS wrote: > > Even desactivate Auto-vacuum didn't fix my issue. Is there any place > > where I can see past transactions or transactions in queue that hasn't > > been pro

Re: [BUGS] PGSQL - WARNING: 25P01: there is no transaction in progress

2007-05-04 Thread Alvaro Herrera
DNS escribió: > Even desactivate Auto-vacuum didn't fix my issue. I don't think anybody ever suggested that autovacuum had something to do with it. > Is there any place > where I can see past transactions or transactions in queue that hasn't > been processed ? Why are you bothering with investig

Re: [BUGS] PGSQL - WARNING: 25P01: there is no transaction in progress

2007-05-04 Thread Heikki Linnakangas
DNS wrote: Even desactivate Auto-vacuum didn't fix my issue. Is there any place where I can see past transactions or transactions in queue that hasn't been processed ? You could put log_statement = all to your postgresql.conf. That'll log every statement sent to the server to the log file. T

Re: [BUGS] PGSQL - WARNING: 25P01: there is no transaction in progress

2007-05-04 Thread DNS
Even desactivate Auto-vacuum didn't fix my issue. Is there any place where I can see past transactions or transactions in queue that hasn't been processed ? Thank you, On 2 mai, 10:02, [EMAIL PROTECTED] (Alvaro Herrera) wrote: > DNS escribió: > > > On 27 avr, 19:17, [EMAIL PROTECTED] (Tom Lane)

Re: [BUGS] PGSQL - WARNING: 25P01: there is no transaction in progress

2007-05-02 Thread Alvaro Herrera
DNS escribió: > On 27 avr, 19:17, [EMAIL PROTECTED] (Tom Lane) wrote: > > > This is just a warning, which most likely is there only because somebody > > typed COMMIT or ABORT unnecessarily. What problem are you actually having? > > No one is working on the database when come up the warning. The

Re: [BUGS] PGSQL - WARNING: 25P01: there is no transaction in progress

2007-05-02 Thread DNS
On 27 avr, 19:17, [EMAIL PROTECTED] (Tom Lane) wrote: > This is just a warning, which most likely is there only because somebody > typed COMMIT or ABORT unnecessarily. What problem are you actually having? No one is working on the database when come up the warning. The warning makes us worrier a

Re: [BUGS] PGSQL - WARNING: 25P01: there is no transaction in progress

2007-04-27 Thread Tom Lane
DNS <[EMAIL PROTECTED]> writes: > 3- In pgsql log, I have this message: > 2007-04-27 14:15:05 EDT user database WARNING: 25P01: there is no > transaction in progress This is just a warning, which most likely is there only because somebody typed COMMIT or ABORT unnecessarily. What problem are yo

Re: [BUGS] PGSQL - WARNING: 25P01: there is no transaction in progress

2007-04-27 Thread DNS
I forget to add, it's PGSQL version 8.1 . Thank you! ---(end of broadcast)--- TIP 6: explain analyze is your friend

[BUGS] PGSQL - WARNING: 25P01: there is no transaction in progress

2007-04-27 Thread DNS
Hello, I have the following Warning with Postgresql, can anybody helps: 1- My server is crashing suddenbly 2- I do a cold reboot 3- In pgsql log, I have this message: 2007-04-27 14:15:05 EDT user database WARNING: 25P01: there is no transaction in progress 2007-04-27 14:15:05 EDT user database

[BUGS] PGSQL SETUP PROBLEM

2006-11-24 Thread rahman sule
Hello, I Sule Rahman from the International Institute of Tropical Agriculture, Ibadan, Nigeria( IITA). IITA is an international research organisation committed to the development and improve production of agricultural products. We recently installed PGSQL on a Redhat Linux server but each time

Re: [BUGS] pgsql on Solaris 10

2006-09-18 Thread Zdenek Kotala
[EMAIL PROTECTED] napsal(a): Compiling PostgreSQL 8.1.4 under Solaris 10, I ran into a problem documented back on 2006-05-30. Apparently in order to compile successfully, one has to remove an unreferenced function pqsignalinquire() in src/interfaces/libpq/pqsignal.c. Since I stepped into th

Re: [BUGS] pgsql on Solaris 10

2006-09-14 Thread Bruce Momjian
Based on the date of the posting, I think this will be fixed when we release 8.1.5 soon. If you want, use CVS to pull the 8_1 tag and try that. --- [EMAIL PROTECTED] wrote: > Compiling PostgreSQL 8.1.4 under Solaris 10, I r

[BUGS] pgsql on Solaris 10

2006-09-13 Thread vodhner
Compiling PostgreSQL 8.1.4 under Solaris 10, I ran into a problem documented back on 2006-05-30. Apparently in order to compile successfully, one has to remove an unreferenced function pqsignalinquire() in src/interfaces/libpq/pqsignal.c. Since I stepped into this hole, is there anything I ca

Re: [BUGS] [pgsql-www] Likely typo in FAQ_DEV.html

2005-03-11 Thread Bruce Momjian
Robert Treat wrote: > On Sunday 06 March 2005 15:25, Hashem Masoud wrote: > > Hi, > > > > I think this is a typo in: > > http://www.postgresql.org/files/documentation/faqs/FAQ_DEV.html > > > > > > lfirst(i), lfirst_int(i), lfirst_oid(i) > > return the data (a point, inteter and OID > > respecti

Re: [BUGS] [pgsql-bugs] Daily digest v1.1387 (8 messages)

2005-03-09 Thread Josh Berkus
Tom, > the issue is clearly that the known-false HAVING clause is pushed down > inside the aggregation, as though it were WHERE. ÂThe existing code > pushes down HAVING to WHERE if the clause contains no aggregates, but > evidently this is too simplistic. ÂWhat are the correct conditions for > pus

Re: [BUGS] [pgsql-www] Likely typo in FAQ_DEV.html

2005-03-08 Thread Robert Treat
On Monday 07 March 2005 16:22, Robert Treat wrote: > On Sunday 06 March 2005 15:25, Hashem Masoud wrote: > Thanks for the report! Attached patch fixes this and 3-4 other typos as > well. Hashem has kindly pointed out a few more typos in the FAQ that I have added in, please apply this patch inste

Re: [BUGS] [pgsql-www] Likely typo in FAQ_DEV.html

2005-03-07 Thread Robert Treat
On Sunday 06 March 2005 15:25, Hashem Masoud wrote: > Hi, > > I think this is a typo in: > http://www.postgresql.org/files/documentation/faqs/FAQ_DEV.html > > > lfirst(i), lfirst_int(i), lfirst_oid(i) > return the data (a point, inteter and OID > respectively) at list element i. > > > (inteter)

Re: [BUGS] [pgsql-www] Fw: typos in the docu

2005-03-02 Thread Robert Treat
patch attached. -- Forwarded Message -- Subject: [pgsql-www] Fw: typos in the docu Date: Wednesday 02 March 2005 12:44 From: "Stefan Hans" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> - Original Message - From: Stefan Hans To: pgsql-bugs@postgresql.org Sent: Wednesday,

Re: [BUGS] [pgsql-bugs] Daily digest v1.1346 (21 messages)

2005-01-20 Thread Josh Berkus
Byron, > PostgreSQL Âworks perfectly if the Win Xp does not have installed Service > Pack, the problem occurs when Win Xp has Service Pack 1 or 2. ÂPostgreSQL > does not activate Âor doesnât work Âand it presents this error: The Windows XP services packs contain a built-in firewall which autmatic

Re: [BUGS] [pgsql-bugs] Daily digest v1.1341 (25 messages)

2005-01-14 Thread Josh Berkus
Alexander, > When I add a server in Windows XP with service pack Â1 or 2 always the > connection is refused, but when I add a server in Windows XP without > service pack, I do not have any problem, so, I would like know how I could > solve this problem, or if this problem is with the S.O. or confi

Re: [BUGS] [pgsql-hackers-win32] Initdb failing for no apparent reason in

2005-01-09 Thread Andrew Dunstan
Steve McWilliams wrote: Nevermind, I found out what this was. Turned out that the customer machine in question had particularly heavy security settings and so the enetaware account did not have permission to write into the directory where it was trying to create PGDATA. Once I widened the settin

Re: [BUGS] [pgsql-hackers-win32] Initdb failing for no apparent reason in 8.0.0beta4 on windows

2005-01-07 Thread Tom Lane
"Steve McWilliams" <[EMAIL PROTECTED]> writes: > Nevermind, I found out what this was. Turned out that the customer > machine in question had particularly heavy security settings and so the > enetaware account did not have permission to write into the directory > where it was trying to create PGDA

Re: [BUGS] [pgsql-www] BUG #1356: pg_get_serial_sequence can not find a table that existing.

2004-12-24 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane > Sent: 23 December 2004 15:30 > To: Kamp Kaibo Huang > Cc: [EMAIL PROTECTED]; pgsql-bugs@postgresql.org > Subject: Re: [pgsql-www] BUG #1356: pg_get_serial_sequence > can not find a table

Re: [BUGS] [pgsql-www] BUG #1355: 8.0.0 rc2 installer fails

2004-12-24 Thread Scott Stillwell
Found the problem...it's been reported before. http://archives.postgresql.org/pgsql-bugs/2004-11/msg00195.php I was a bad boy and left off the part about the missing ordinal in libeay32.dll... Dunno if that's something that still needs to be fixed, but at least I've got a workaround. Scott -

Re: [BUGS] [pgsql-www] BUG #1355: 8.0.0 rc2 installer fails

2004-12-24 Thread Scott Stillwell
I assume the script is broken..._I_ sure didn't send it to -www :) No, no real lockdown except for the Windows Firewall that installs with SP2, but it didn't complain or offer to block or unblock as usual. The postgres account that it created was granted the 'logon as a service' right, but I have

[BUGS] [pgsql-www] BUG #1355: 8.0.0 rc2 installer fails

2004-12-24 Thread Scott Stillwell
The following bug has been logged online: Bug reference: 1355 Logged by: Scott Stillwell Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows XP Pro SP2 Description:8.0.0 rc2 installer fails Details: When installing PostgreSQL 8.0.0 rc2

Re: [BUGS] [pgsql-www] BUG #1356: pg_get_serial_sequence can not find a table that existing.

2004-12-23 Thread Tom Lane
"Kamp Kaibo Huang" <[EMAIL PROTECTED]> writes: > select pg_get_serial_sequence('tTestTableAnother','FId') > ERROR: relation "ttesttableanother" does not exist I think you need select pg_get_serial_sequence('"tTestTableAnother"','"FId"'); regards, tom lane [ could we ple

Re: [BUGS] [pgsql-www] BUG #1355: 8.0.0 rc2 installer fails

2004-12-23 Thread Magnus Hagander
(um, why was this filed to -www? Copying over to -bugs where it should be. Something wrong with the scripts, I assume) > The following bug has been logged online: > > Bug reference: 1355 > Logged by: Scott Stillwell > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0

Re: [BUGS] [pgsql-bugs] Checkpoints occur too frequently

2004-12-15 Thread Josh Berkus
Tom, > We could adjust guc.c to limit checkpoint_segments to the range 1..255 > without having to touch any translatable strings. ÂThis isn't a > necessary change but it seems harmless ... any objections? +1 in favor. We'll need to change the value in runtime-config.sgml and in pg_settings, too.

Re: [BUGS] [pgsql-bugs] pg_dumpall (7.3) 'public' schema bug

2004-11-17 Thread Bruno Wolff III
On Wed, Nov 17, 2004 at 11:53:10 -0800, Josh Berkus <[EMAIL PROTECTED]> wrote: > Karl, > > > I don't care that much about the behavior, it's easy enough > > to delete 'public'.  I do think that a note should be > > made in the administrator manual regards system upgrades > > where pg_dump(all) s

Re: [BUGS] [pgsql-bugs] pg_dumpall (7.3) 'public' schema bug

2004-11-17 Thread Josh Berkus
Karl, > I don't care that much about the behavior, it's easy enough > to delete 'public'. ÂI do think that a note should be > made in the administrator manual regards system upgrades > where pg_dump(all) scripts are given if this is going to be > the behavior. This isn't isolated to the "public"

Re: [BUGS] [pgsql-bugs] Daily digest v1.1282 (5 messages)

2004-11-03 Thread Josh Berkus
Brendan, > Description: Â Â Â Âupdate does not honor order of subselect > > Details: > > SQL Update command does not follow the order of a WHERE field IN subselect. > > In the following code, I try to reset the order of rows in a column by > updating an order field. ÂUpdate does not honor the orde

Re: [BUGS] [pgsql-bugs] Daily digest v1.1281 (14 messages)

2004-11-02 Thread Josh Berkus
Michael, Ralph, etc.: > Rules are macros, so when you refer to NEW.storage_id in the rule > then the default expression "nextval('tmp_storage_id_seq')" is > evaluated again. ÂIf you don't want that to happen then use a > trigger. > > This comes up often -- maybe somebody could add it to the FAQ.

[BUGS] pgsql 8.0 beta 4 - Win32 psql client problem

2004-10-27 Thread John Browne
-- Originally posted to pgsql-general, but no replies -- I was attempting to set up my psql client on the Win32 version of postgres 8.0 beta 4 to be able to use an external editor. I set the environment variable in windows like so: PSQL_EDITOR="c:\progra~1\Textpa~1\Textpad.exe" which does appea

Re: [BUGS] pgsql 8.0 beta1 patch for token and timezone

2004-10-07 Thread Bruce Momjian
OK, fixed. --- Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > + /* > > + * Escape any single quotes or backslashes in locale > > + */ > > + static void > > + escape_locale(char **locale) > > + { > > + in

Re: [BUGS] pgsql 8.0 beta1 patch for token and timezone

2004-10-07 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > + /* > + * Escape any single quotes or backslashes in locale > + */ > + static void > + escape_locale(char **locale) > + { > + int len = strlen(*locale), > + i, j; > + char*loc_temp = x

Re: [BUGS] pgsql 8.0 beta1 patch for token and timezone

2004-10-07 Thread Bruce Momjian
I have reviewed your patch. I found that the first patch was definitely needed. Your code adds escapes for single quotes in locale names placed in postgresql.conf. I also added code to escape a literal backslash as well. I re-factored your code and applied the attached patch. Your second patc

[BUGS] pgsql 8.0 beta1 patch for token and timezone

2004-08-29 Thread zhongxb
Hi pgsql-bugs, I'm a Chinese and I am using WinXp Chs to compile pgsql 8.0 beta 1 in the MinGW environment. I found 2 bugs and fix them, maybe you can merge the patch into the offical release, thanks. Part A) Below is the two bugs occur when we run initdb under WinXp Chs. 1) FATAL: syn

Re: [BUGS] pgsql 8.0 beta1 patch for token and timezone

2004-08-28 Thread Bruce Momjian
I do not see a patch. Did you forget to attach it? --- Zhong Jacky wrote: > Hi pgsql-bugs, > >I'm a Chinese and I am using WinXp Chs to compile pgsql 8.0 beta 1 > in the MinGW environment. I found 2 bugs and fix them,

[BUGS] pgsql 8.0 beta1 patch for token and timezone

2004-08-27 Thread Zhong Xubin
Hi pgsql-bugs-owner, I want to join the bug mailing list cauz I found 2 bugs and fixed them. Regards, Jacky -> From: [EMAIL PROTECTED] To: "Zhong Jacky" <[EMAIL PROTECTED]> Subject: Stalled post to pgsql-bugs Date: Wed, 25 Aug 2004 23:43:48 -0300 Your message t

[BUGS] pgsql 8.0 beta1 patch for token and timezone

2004-08-27 Thread Zhong Jacky
Hi pgsql-bugs, I'm a Chinese and I am using WinXp Chs to compile pgsql 8.0 beta 1 in the MinGW environment. I found 2 bugs and fix them, maybe you can merge the patch into the offical release, thanks. Part A) Below is the two bugs occur when we run initdb under WinXp Chs. 1) FATAL: syntax er

[BUGS] pgsql 8 beta - Service fails to start after system crash

2004-08-25 Thread Sean Murphy
Using pgsql 8.0.0 beta 1 installed via PGInstaller 08092004 release on Windows 2000 SP4 build 5.00.2195, Dell Precision 360 single Pentium 4 After a power cutoff and reboot, the db service will not start, either automatically or manually. Two incidents; after the first I reinstalled before it wou

[BUGS] pgsql 8 beta - Service fails... problem found

2004-08-25 Thread Sean Murphy
The postmaster.pid file from the pre-crash instance remained in the data directory. Deleted it and started fine. >Using pgsql 8.0.0 beta 1 installed via PGInstaller 08092004 release >on Windows 2000 SP4 build 5.00.2195, Dell Precision 360 single Pentium 4 > >After a power cutoff and reboot, the d

Re: [BUGS] pgsql 8.0.0b1 - openssl detection

2004-08-20 Thread Stefanos Harhalakis
On Friday 20 August 2004 03:52, Tom Lane wrote: > Stefanos Harhalakis <[EMAIL PROTECTED]> writes: > > It seems that the problem is in src/template/linux: > > > > $ cat src/template/linux=20 > > # Force _GNU_SOURCE on; plperl is broken with Perl 5.8.0 otherwise > > CPPFLAGS="-D_GNU_SOURCE" > > > > w

Re: [BUGS] pgsql 8.0.0b1 - openssl detection

2004-08-19 Thread Tom Lane
Stefanos Harhalakis <[EMAIL PROTECTED]> writes: > It seems that the problem is in src/template/linux: > $ cat src/template/linux=20 > # Force _GNU_SOURCE on; plperl is broken with Perl 5.8.0 otherwise > CPPFLAGS="-D_GNU_SOURCE" > which is beeing sourced by configure.in. Changing this to > CPPFLAG

Re: [BUGS] pgsql 8.0.0b1 - openssl detection

2004-08-19 Thread Stefanos Harhalakis
On Wednesday 18 August 2004 23:09, Peter Eisentraut wrote: > Stefanos Harhalakis wrote: > > This happens because AC_CHECK_HEADERSis implemented using the > > preprocessor (cpp/gcc -E) without adding CFLAGS/CXXFLAGS: > > The correct variable is CPPFLAGS. Actually, you can also use > --with-includes

Re: [BUGS] pgsql 8.0.0b1 - openssl detection

2004-08-19 Thread Stefanos Harhalakis
On Wednesday 18 August 2004 20:14, Peter Eisentraut wrote: > Stefanos Harhalakis wrote: > > It seems that you've removed the possibility to add an argument to > > --with-openssl option of the configure script. Currently I'm > > maintaining two systems where the openssl is not somewhere in the > >

Re: [BUGS] pgsql 8.0.0b1 - openssl detection

2004-08-18 Thread Peter Eisentraut
Stefanos Harhalakis wrote: > This happens because AC_CHECK_HEADERSis implemented using the > preprocessor (cpp/gcc -E) without adding CFLAGS/CXXFLAGS: The correct variable is CPPFLAGS. Actually, you can also use --with-includes, but this is only in PostgreSQL, so I suggest you get used to CPPFL

Re: [BUGS] pgsql 8.0.0b1 - openssl detection

2004-08-18 Thread Peter Eisentraut
Stefanos Harhalakis wrote: > It seems that you've removed the possibility to add an argument to > --with-openssl option of the configure script. Currently I'm > maintaining two systems where the openssl is not somewhere in the > standard paths and thus the only way to compile with SSL seems to be

[BUGS] pgsql 8.0.0b1 - openssl detection

2004-08-18 Thread Stefanos Harhalakis
Hi there... I'm trying to compile pgsql 8.0.0b1. It seems that you've removed the possibility to add an argument to --with-openssl option of the configure script. Currently I'm maintaining two systems where the openssl is not somewhere in the standard paths and thus the only way to compile

[BUGS] pgsql + psql + su

2004-04-05 Thread rajesh k
hi , i'm workin with rh9 (just a beginner). I'v installed postgreSQL 7.3.6 on location /usr/local/pgsql but there is also a default pgsql (i think of rh9) at location /var/lib/pgsql (this is 7.3.2) what i did -- [EMAIL PROTECTED] root]# cd /usr/local/pgsql/bin

Re: [BUGS] PgSQL Down

2004-01-27 Thread Tom Lane
"Cavit Keskin" <[EMAIL PROTECTED]> writes: > Postgresql often stops after a time (unknown, changing). You haven't given any information that would allow anyone to help :-( > Below is the log file just after Postgresql database server is started > manually. Log can't record the cause of this probl

[BUGS] PgSQL Down

2004-01-27 Thread Cavit Keskin
Using Postgresql's source files I compiled postgresql 7.4.1 on a dedicated machine with a customized Redhat 7.2 system. Postgresql often stops after a time (unknown, changing). Below is the log file just after Postgresql database server is started manually. Log can't record the cause of this probl

[BUGS] pgsql inserts problem

2003-08-28 Thread Tarhon-Onu Victor
Hi, I have a (big) problem with postgresql when making lots of inserts per second. I have a tool that is generating an output of ~2500 lines per seconds. I write a script in PERL that opens a pipe to that tool, reads every line and inserts data. I tryed both commited an

[BUGS] pgsql-bugs ¤Ñ¨Ïªº¬G¨Æ~~

2003-03-09 Thread pgsql-bugs
Title: ¤Ñ¨Ïªº¬G¨Æ    ¤Ñ¨Ïªº¬G¨Æ    ¤Ñ¨Ïªº¬G¨Æ [EMAIL PROTECTED]   [EMAIL PROTECTED]¤¤«×±J¡C ³o®a¤H¹ï¤Ñ¨Ï­Ì«Ü¤£«È®ð¡A¤S¤£­ã¥L­Ì¦í¦b¤j¦vªº«È©Ð¡C ©ó¬O¡A¥L­Ì°ß¦³¦í¦b¦B§Nªº¦a¨c¡C ·í¤Ñ¨Ï­Ì¦b°íµwªº¦a¤W·Ç³Æ§ÉçE®É¡A ¤j¤Ñ¨Ïµo²{Àð¤W¦³­Ó¬}¡A´N§â­×

Re: [BUGS] PGSQL no IP-port assigned

2003-02-13 Thread Lamar Owen
On Thursday 13 February 2003 05:06, Pablo Capeluto wrote: > Your name : Pablo Capeluto > Your email address : [EMAIL PROTECTED] > Mi comando para correr PostgreSQL es rcpostgresql start, funciona bien, > postgresql status me dice "runing" pero las aplicaciones que uso para > hace

[BUGS] PGSQL no IP-port assigned

2003-02-13 Thread Pablo Capeluto
Your name : Pablo Capeluto Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : AMD K6-2 400Mhz, 396Mb-RAM 800Mb Free Hdd (4.2Gb Total) Operating System (example: Linux 2

Re: [BUGS] [pgsql-bugs] Daily Digest V1 #784

2003-01-30 Thread Vincent Janelle
Currency is always going to depend on the cost of who you are buying it from, no? On Wed, 29 Jan 2003 14:14:02 +0100 [EMAIL PROTECTED] wrote: > > Come to think of it, even the point in time isn't enough (I remember > times where you got more Deutsche Mark for an US dollar in the Soviet > Union t

Re: [BUGS] [pgsql-bugs] Daily Digest V1 #784

2003-01-29 Thread tomas
On Tue, Jan 28, 2003 at 17:47:14 -0500, tom lane wrote: [...] > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > How would the new "money" be different from "numeric"? > > [ temporarily re-dons currency-trader hat... ] > > What would actually be useful is a money type that carries along an > in

[BUGS] Pgsql question

2001-12-11 Thread Ken Mathieu
Hi there,     First i must say that iv started using pgsql recently(on a linux redhat apache server with mod perl "DBI").  I have this problem after a little while there is too many pgsql process hanging "idle" and when we try to connect the server say: psql: Sorry, too many clients already

Re: [BUGS] pgsql

2001-07-16 Thread Tom Lane
"Darko Prenosil" <[EMAIL PROTECTED]> writes: > Here is changed fe-connect.c Could we see a "diff -c" against what you started from, rather than trying to intuit what changes you want to make? regards, tom lane ---(end of broadcast)

Re: [BUGS] pgsql

2001-07-16 Thread Bruce Momjian
> Non-Blocking Connection is not working under WIN32 build of PGSQL interface. > I Spend some time to make it work. > Here is changed fe-connect.c > > I did not check if all of non-blocking functions are working, > but I checked PQsetnonblocking,PQisnonblocking, > PQsendQuery, PQgetResult and fe

[BUGS] pgsql 7.1 beta.4,5,6. NOT USE Delphi "Ttable" component

2001-03-22 Thread guard
pgsql 7.1 beta.. NOT USE Delphi "Ttable" component

Re: [BUGS] PgSQL 7.1 beta 3 breaks ODBC

2001-02-14 Thread Josh Berkus
Tom, Thanks for the quick response. > Try it with the beta version's ODBC driver ... How do I get it? I looked through the Development version FTP filetree, and can't find the ODBC driver anywhere. Link ... pretty please? Second, I've also discovered that Pos

Re: [BUGS] PgSQL 7.1 beta 3 breaks ODBC

2001-02-13 Thread Tom Lane
>> Try it with the beta version's ODBC driver ... > How do I get it? I looked through the Development > version FTP filetree, and can't find the ODBC driver > anywhere. Link ... pretty please? Darn if I know, I don't do Windows. Dave Page might have a precompiled .dll available.

Re: [BUGS] PgSQL 7.1 beta 3 breaks ODBC

2001-02-13 Thread Tom Lane
[EMAIL PROTECTED] writes: > Windows 98 O.E. > MS Access 97 SR 2a > MDAC 2.5 and DCOM 98 > Postgres ODBC 6.50.00 ^ > on two workstations. > Postgres ODBC, whcih workes fine when the Postgres server runs 7.0.3, > does not work when the server runs 7.1 beta 3. Try it with the

[BUGS] PgSQL 7.1 beta 3 breaks ODBC

2001-02-13 Thread pgsql-bugs
Josh Berkus ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description PgSQL 7.1 beta 3 breaks ODBC Long Description I'm running: Postgres 7.1 beta 3 on SuSE Linux 7.0 on the server, and Windows 98 O.E. MS Access 97 SR 2a MDAC 2.5 and DC

Re: [BUGS] pgsql-loophole-request@postgresql.org does not exist

2001-01-18 Thread The Hermit Hacker
long ago gone ... if you want to get on a list to post to, without being swamped with email, send a 'subscribe-nomail' to the -request address for the list ... especially great for those using news to post to the lists :) On Wed, 17 Jan 2001, Jason Schroeder wrote: > http://www.postgresql.org/

[BUGS] pgsql-loophole-request@postgresql.org does not exist

2001-01-17 Thread Jason Schroeder
http://www.postgresql.org/bugs/index.php indicates that the address [EMAIL PROTECTED] exists. It does not. ;-) The original message was received at Wed, 17 Jan 2001 19:00:28 -0500 (EST) from [209.43.202.2] - The following addresses had permanent fatal errors - <[EMAIL PROTECTED]>

Re: [BUGS] pgsql 7.1: int4out() brokeness?

2001-01-11 Thread Tom Lane
James Troup <[EMAIL PROTECTED]> writes: > | template1=# create table x (y int4); insert into x values (31); select y, >int4out(y) from x; > | CREATE > | INSERT 34029 1 > | y | int4out > | +--- > | 31 | 136420312 > | (1 row) The bug here is that the system allows you to inv

[BUGS] pgsql 7.1: int4out() brokeness?

2001-01-10 Thread James Troup
POSTGRESQL BUG REPORT TEMPLATE Your name : James Troup Your email address : [EMAIL PROTECTED] Sys

[BUGS] pgsql-bugs should be live now ...

2000-10-29 Thread The Hermit Hacker
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org