[BUGS] Bug #841: SET search_path in createdb -T ... and pgdump

2002-12-09 Thread pgsql-bugs
Przemyslaw Sztoch ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description SET search_path in createdb -T ... and pgdump Long Description Database variable is not dumped in pg_dump. Database variable is not copied by cratedb with -T para

Re: [BUGS] Bug #841: SET search_path in createdb -T ... and pgdump

2002-12-09 Thread Tom Lane
[EMAIL PROTECTED] writes: > Database variable is not dumped in pg_dump. It's not supposed to be. See pg_dumpall. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[BUGS] Bug #842: pgplsql: IF-THEN-ELSIF-ELSE acts different from IF-THEN-ELSE IF

2002-12-09 Thread pgsql-bugs
Jørn Cornelius Olsen ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description pgplsql: IF-THEN-ELSIF-ELSE acts different from IF-THEN-ELSE IF Long Description 1) The 'boolean-expression' after 'ELSIF' always evaluates to FALSE. According

Re: [BUGS] Bug #842: pgplsql: IF-THEN-ELSIF-ELSE acts different from IF-THEN-ELSE IF

2002-12-09 Thread Tom Lane
[EMAIL PROTECTED] writes: > pgplsql: IF-THEN-ELSIF-ELSE acts different from IF-THEN-ELSE IF > PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96 elsif was implemented in 7.2. I'm surprised you're not getting a syntax error message; but in any case we are not revisiting 7.1 anymore...

[BUGS] ecpg Oracle compatibility issue

2002-12-09 Thread Roland Karch
Hello together, While porting my TPC-C implementation from Oracle, I discovered the attached problem with the EXEC SQL COMMIT RELEASE statement. Bye, Roland POSTGRESQL BUG REPORT TEMPLATE ==

[BUGS] cube does not compile with newer flex

2002-12-09 Thread Bartosch Pixa
Hi, first of all sorry if this is the wrong list. i was trying to install pgsql 7.3 on my system and had some problems with contrib/cube. it only compiled after i downgraded flex to a older version (in my case 2.5.23 -> 2.5.4a) seems like the the generated cubescan.c is incompatible.

Re: [BUGS] cube does not compile with newer flex

2002-12-09 Thread Tom Lane
Bartosch Pixa <[EMAIL PROTECTED]> writes: > i was trying to install pgsql 7.3 on my system and had some problems > with contrib/cube. it only compiled after i downgraded flex to a older > version (in my case 2.5.23 -> 2.5.4a) seems like the the generated > cubescan.c is incompatible. What is f

Re: [BUGS] cube does not compile with newer flex

2002-12-09 Thread Bartosch Pixa
Quoting Tom Lane <[EMAIL PROTECTED]>: ... > What is flex 2.5.23? AFAICS 2.5.4a is still the newest release version > (there's nothing newer on the GNU mirrors, nor according to freshmeat). > flex is non-gnu, the official site is afaik : http://astro.temple.edu/~john43/flex/ regar

Re: [BUGS] cube does not compile with newer flex

2002-12-09 Thread Tom Lane
Bartosch Pixa <[EMAIL PROTECTED]> writes: > Quoting Tom Lane <[EMAIL PROTECTED]>: >> What is flex 2.5.23? > flex is non-gnu, the official site is afaik : > http://astro.temple.edu/~john43/flex/ That also says: Last official release (July 1997) flex-2.5.4a.tar.gz is the most recent offi

Re: [BUGS] Bug #837: Unable to use LATIN9 (=ISO-8859-15) encoding

2002-12-09 Thread Peter Eisentraut
> >From PSQL, if I perform: > \encoding LATIN9 > insert into i18ntest(id, data) values('Euro symbol', '¤'); > > then I would expect this to insert a euro symbol into the data column > (code point 164 is Euro in ISO-8859-15). However, when I change back to > UTF-8, the UTF-8 data is "¤", which is t

Re: [BUGS] Bug #838: SSL problems in 7.3

2002-12-09 Thread Peter Eisentraut
[EMAIL PROTECTED] writes: > In 7.3 if a client exists without disconnecting from the database the > backend dumps core. I can't reproduce that. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at

Re: [BUGS] Bug #838: SSL problems in 7.3

2002-12-09 Thread Nathan Mueller
> > In 7.3 if a client exists without disconnecting from the > > database the > > backend dumps core. > > I can't reproduce that. What version of openssl are you using? --Nate ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [BUGS] O_DIRECT option used?

2002-12-09 Thread Bruce Momjian
Read the developer's FAQ on advanced features. We don't think it will be a big win. --- Ruslan A Dautkhanov wrote: > Hello, > > In the FreeBSD 4.5 appear additional O_DIRECT option for open(2), > wh

Re: [BUGS] Bug #838: SSL problems in 7.3

2002-12-09 Thread Nathan Mueller
> > In 7.3 if a client exists without disconnecting from the > > database the > > backend dumps core. > > I can't reproduce that. I'm sorry but you're going to have to send me more info about your setup. I just did a fresh build on my home machine against Red Hat's openssl and the problems got eve

Re: [BUGS] Bug #838: SSL problems in 7.3

2002-12-09 Thread Bruce Momjian
Nathan Mueller wrote: > > > In 7.3 if a client exists without disconnecting from the > > > database the > > > backend dumps core. > > > > I can't reproduce that. > > I'm sorry but you're going to have to send me more info about your > setup. I just did a fresh build on my home machine against Red

Re: [BUGS] Bug #838: SSL problems in 7.3

2002-12-09 Thread Nathan Mueller
> tested it with openssl 0.9.6e and it worked on BSD/OS 4.2. The author > is only involved intermittently. I worked with him to get it > working on > 7.3. It is certainly possible there are other bugs in there. Slow night so I learned a little about SSL and figured this out. The following patch

Re: [BUGS] 7.3 RMPS bugs ( pgdb.py and postgresql launch script )

2002-12-09 Thread Lamar Owen
On Sunday 08 December 2002 11:45, Gaetano Mendola wrote: > the file pgdb.py distribuited with Postgresql 7.3 RPM ( RedHat 8.0) > is affectd by an error that not permit anymore to use the > pgdb interface for python. Then the official 7.3 tarball is also buggy. > There is also in the script for la

Re: [ADMIN] [BUGS] 7.3 RMPS bugs ( pgdb.py and postgresql launch script

2002-12-09 Thread Jean-Luc Lachance
Lamar Owen wrote: >[...] > > 2) when postgres is launched the script do: > > echo " [ OK ] " > > but should be more correctly: > > echo_success > > Hmmm. I thought that used to work right let me check. It will work the same (if the format did not change), but I can mod

Re: [BUGS] PostgreSQL 7.3 Installation on SCO

2002-12-09 Thread Bruce Momjian
It should have worked, but edit Makefile.shlib and remove that offending export from the link line. That may fix it. --- Shibashish wrote: > Dear Sir, > > I use SCO Open Server 5.0.5 on an intel box. Although I have instal