Re: [BUGS] 7.2.1 backend crash (convert_string_datum, locale)

2002-07-11 Thread Bruce Momjian
Tom Lane wrote: > Mats Lofkvist <[EMAIL PROTECTED]> writes: > > When testing postgres 7.2.1 on a sparc/solaris8 box with > > --enable-locale --enable-multibyte I get a crash in > > convert_string_datum. > > This smells like a problem that we chased down awhile back, that > snprintf on Solaris is

Re: [BUGS] Bug #710: Fail To Create/Drop Temporary Table IN PL/PGSQL

2002-07-11 Thread Stephan Szabo
On Thu, 11 Jul 2002 [EMAIL PROTECTED] wrote: > CNLIOU ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is. > > Short Description > Fail To Create/Drop Temporary Table IN PL/PGSQL > > Long Description > Hi! > > In TODO list, it reads in sub section

Re: [BUGS] 7.2.1 backend crash (convert_string_datum, locale)

2002-07-11 Thread Tom Lane
Mats Lofkvist <[EMAIL PROTECTED]> writes: > When testing postgres 7.2.1 on a sparc/solaris8 box with > --enable-locale --enable-multibyte I get a crash in > convert_string_datum. This smells like a problem that we chased down awhile back, that snprintf on Solaris is broken (it will write past the

[BUGS] Bug #710: Fail To Create/Drop Temporary Table IN PL/PGSQL

2002-07-11 Thread pgsql-bugs
CNLIOU ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Fail To Create/Drop Temporary Table IN PL/PGSQL Long Description Hi! In TODO list, it reads in sub section "Fix problems with complex temporary table creation/destruction

[BUGS] Bug #709: PL/pgSQL Parameter Of Composite Type

2002-07-11 Thread pgsql-bugs
CNLIOU ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description PL/pgSQL Parameter Of Composite Type Long Description Hello! "Example 23-4. A PL/pgSQL Function on Composite Type" says that we are allowed to pass record to pl/pgsql, bu

Re: [BUGS] Bug #708: PgTransaction class is broken since 7.2

2002-07-11 Thread Bruce Momjian
OK, would you send us a correcting patch? Thanks. --- [EMAIL PROTECTED] wrote: > Piotr Klaban ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is. > > Short Description > Pg

Re: [BUGS] pg_dumpall forces plain text format

2002-07-11 Thread Joe Conway
grant wrote: > You could fake some of this (select only) by using the dblink stuff in > contrib. You could link back to yourself and make it work. Maybe if > you REALLY need it, you could modify dblink to allow updates as well as > selects. If you really need it that bad, you have the sourc

[BUGS] 7.2.1 backend crash (convert_string_datum, locale)

2002-07-11 Thread Mats Lofkvist
Hi, When testing postgres 7.2.1 on a sparc/solaris8 box with --enable-locale --enable-multibyte I get a crash in convert_string_datum. The backend just dies when doing an select. With casserts and debug configured in I got the following in the log: NOTICE: AllocSetFree: detected write past c

Re: [BUGS] pg_dumpall forces plain text format

2002-07-11 Thread grant
You could fake some of this (select only) by using the dblink stuff in contrib. You could link back to yourself and make it work. Maybe if you REALLY need it, you could modify dblink to allow updates as well as selects. If you really need it that bad, you have the source, write it. --

Re: [BUGS] pg_dumpall forces plain text format

2002-07-11 Thread Tom Lane
Andrew Kohlsmith <[EMAIL PROTECTED]> writes: > Is there a way to start a transaction at the start of > the dump and hold it throughout successive connections, finally releasing it > at the end? No, and since one backend can only talk to one database, I don't foresee that changing. > Or is that

Re: [BUGS] pg_dumpall forces plain text format

2002-07-11 Thread Tom Lane
Andrew Kohlsmith <[EMAIL PROTECTED]> writes: > Is there a particular reason why plain text is forced? Because pg_dumpall is producing a script file. This is obviously not optimal, but it's not very clear how to do better. regards, tom lane ---(en

Re: [BUGS] Postgres with IBM ????????

2002-07-11 Thread Justin Clift
Hi Prison, I've created Web Sphere packages for Solaria 8, and had to install Web Sphere numerous times in the process of getting it right (learning curve thing). For getting Web Sphere to work with PostgreSQL... it doesn't work right out of the box. When you install Web Sphere 4.0x (not sure a

[BUGS] Postgres with IBM ????????

2002-07-11 Thread Prinson
Hi friends, Can any body help me , whether postgres work with IBM websphere ? if pls kindly give me the details regarding this. thanx and regards, prinson. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [BUGS] Bug #706: Wrong shlib flag for GCC compilation on Solaris

2002-07-11 Thread Richard Cook x261
Bruce, My apologies. The file I worked with was from the postgresql-7.1.3.tar.gz. I had started out with the latest (7.2.1) tar, but after various failures rolled back to the 7.1.3 source, since I found evidence on the net that somebody had succeeded in building that on Solaris. I lost track o

[BUGS] pg_dumpall forces plain text format

2002-07-11 Thread Andrew Kohlsmith
I was trying to do a data+lo dump using pg_dumpall: pg_dumpall -C -a -b -o -Ft > dumptest.data Unfortunately I kept getting this error: pg_dump: large object output is not supported for plain text dump files. pg_dump: (Use a different output format.) Upon looking at the pg_dumpall shell script

[BUGS] Bug #708: PgTransaction class is broken since 7.2

2002-07-11 Thread pgsql-bugs
Piotr Klaban ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description PgTransaction class is broken since 7.2 Long Description Hi, You have introduced the patch http://www.geocrawler.com/archives/3/105/2001/2/0/5248369/ that broke my