Re: [BUGS] Command-line client sometimes misinterprets tabs for nulls

2002-08-27 Thread Tom Lane
Casey Allen Shobe <[EMAIL PROTECTED]> writes: > Can tab completion be disabled without disabling command line history? Get out the readline man page. I believe you can configure it six ways from Sunday, but I've never tried myself ... regards, tom lane -

Re: [BUGS] Command-line client sometimes misinterprets tabs for nulls

2002-08-27 Thread Casey Allen Shobe
On Tuesday 27 August 2002 01:48 am, Tom Lane wrote: > Turn off readline (psql -n). For someone accustomed to tab completion, > the above is about as sensible as demanding we disable backspace. Right, my original build of postgres did not have tab completion support as I did not have readline (a

[BUGS] Potential buffer overflow in contrib/cube/cubeparse.y

2002-08-27 Thread Bruno Wolff III
In the function cube_yyerror an output buffer of 256 bytes is allocated to be used for an error message that outputs some of the input buffer. I think the portion of the input buffer that is echod can potentially be longer than this. ---(end of broadcast)--

Re: [BUGS] cube bug accepting -.1

2002-08-27 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://candle.pha.pa.us/cgi-bin/pgpatches I will try to apply it within the next 48 hours. --- Bruno Wolff III wrote: > The lex scanner for t

Re: [BUGS] Bug #743: pg_dump -a -c without DELETE FROM

2002-08-27 Thread Bruce Momjian
The following patch disables use of -a and -c together. This will appear in the next release. --- [EMAIL PROTECTED] wrote: > Przemyslaw Sztoch ([EMAIL PROTECTED]) reports a bug with a severity of 3 > The lower the number t

Re: [BUGS] Bug #741: postgresql and cygwin

2002-08-27 Thread Peter Eisentraut
> Przemyslaw Sztoch ([EMAIL PROTECTED]) reports a bug with a severity of 3 > 1. If you use "-boot" then argv[0] in BootstrapMain is equal "-boot", but should be >equal e.g. "/pgsql/postmaster". > 2. Under cygwin symlink support is strange. It will be very nice to don't use it. I >propose add "-

Re: [BUGS] cube bug accepting -.1

2002-08-27 Thread Tom Lane
Bruno Wolff III <[EMAIL PROTECTED]> writes: > The lex scanner for the cube package has an apparent error in its > pattern for matching floating point numbers. It doesn't except cases > where there is no digit between a sign and a decimal point. For example > -.1 is not matched by the pattern. I t

Re: [BUGS] JDBC timestamp does not understand [-]infinity

2002-08-27 Thread Bruce Momjian
This code doesn't exist in the jdbc driver anymore. They must have already fixed it. --- Dmitry Tkach wrote: > The attached patch fixes 'Bad Timestamp format' exception when timestamp value is >'ininity' or '-ininity'. >

Re: [BUGS] Bug found in psql interface

2002-08-27 Thread Bruce Momjian
In 7.3, NAMEDATALEN is going to be 64, and your example does work there: test=> create table City_setregions_bds_regions_ass_rel(x int); CREATE TABLE test=> \d City_setregions_bds_regions_ass_rel Table "public.city_setregions_bds_regions_ass_rel" Column |

Re: [BUGS] Bug #749: one NULL function parameter makes all other

2002-08-27 Thread Stephan Szabo
On Tue, 27 Aug 2002 [EMAIL PROTECTED] wrote: > Laurent HERVE ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is. > > Short Description > one NULL function parameter makes all other NULL > > Long Description I don't know if this is really a bug but

[BUGS] Bug #750: dumping/restoring database with custom languages does not work

2002-08-27 Thread pgsql-bugs
Mathieu Arnold ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description dumping/restoring database with custom languages does not work Long Description When adding a plpgsql to one of my database, I ran pg_dump, and I discovered that th

[BUGS] cube bug accepting -.1

2002-08-27 Thread Bruno Wolff III
The lex scanner for the cube package has an apparent error in its pattern for matching floating point numbers. It doesn't except cases where there is no digit between a sign and a decimal point. For example -.1 is not matched by the pattern. I have attached a patch to cubeparse.l and the regressi

[BUGS] Bug #749: one NULL function parameter makes all other NULL

2002-08-27 Thread pgsql-bugs
Laurent HERVE ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description one NULL function parameter makes all other NULL Long Description I don't know if this is really a bug but it seems like for me and it is very annoying. I checked a

Re: [BUGS] Bug #748: Temp tables don't work in functions

2002-08-27 Thread Bruce Momjian
The workaround is now in the FAQ, use pl/pgsql EXECUTE on any query dealing with the temp table. --- [EMAIL PROTECTED] wrote: > Matt Sergeant ([EMAIL PROTECTED]) reports a bug with a severity of 1 > The lower the number the

[BUGS] Bug #748: Temp tables don't work in functions

2002-08-27 Thread pgsql-bugs
Matt Sergeant ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Temp tables don't work in functions Long Description When you use a temporary table in a function, the first time through it compiles the temporary table into an id