[BUGS] PANIC: ERRORDATA_STACK_SIZE exceeded

2004-10-07 Thread ÿffffceÿffffac
psql -f zouxian-data-bak.sql __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CRE

Re: [BUGS] BUG #1254: CIDR check for no host-bit set has off-by-1 error

2004-10-07 Thread Bruce Momjian
Nice catch. Patch attached and applied. Thanks. We will have to mention in the release notes that this as a possible bad data load problem from previous releases. I have already marked the commit message accordingly. I have also adjusted the regression tests to test for success and failure of

[BUGS]

2004-10-07 Thread Marcio Fernandes
unsubscribe pgsql-bugs ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [BUGS] BUG #1238: postgres option -Q used in src/test/bench

2004-10-07 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > I removed the -Q mention in the comments but Tom already fixed this in > > early September. > > Actually, I deliberately left that comment alone, since it appeared to > me to be a statement of historical fact --- ie, that *was* what t

Re: [BUGS] BUG #1283: Queries slow down after restoring big db

2004-10-07 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > We dumped a database with a lot of data using command pg_dump mydb > > mydb.dump > Then we reimported the data in this way: > 1- createdb anotherdb > 2- psql anotherdb < mydb.dump > After the data was restored queries(SELECT queries, with JOI

Re: [BUGS] Bug in PostrgeSQL 8.0beta

2004-10-07 Thread Tom Lane
"Alexander Zhiltsov" <[EMAIL PROTECTED]> writes: > "Tom Lane" <[EMAIL PROTECTED]> wrote: >> I'm not convinced this is really a bug, because pg_index.indexprs is not >> an expression (it's a list of expressions) and so it's not clear that >> pg_get_expr should be expected to work on it. What result

Re: [BUGS] BUG #1238: postgres option -Q used in src/test/bench

2004-10-07 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > I removed the -Q mention in the comments but Tom already fixed this in > early September. Actually, I deliberately left that comment alone, since it appeared to me to be a statement of historical fact --- ie, that *was* what they did for some now-forgott

[BUGS] BUG #1283: Queries slow down after restoring big db

2004-10-07 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1283 Logged by: Fabio Fucci Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3 Operating system: linux Description:Queries slow down after restoring big db Details: We dumped a database with a lot o

Re: [BUGS] BUG #1238: postgres option -Q used in src/test/bench

2004-10-07 Thread Bruce Momjian
I removed the -Q mention in the comments but Tom already fixed this in early September. --- PostgreSQL Bugs List wrote: > > The following bug has been logged online: > > Bug reference: 1238 > Logged by: A Wu

Re: [BUGS] BUG #1236: still in use tablespaces can be removed

2004-10-07 Thread Bruce Momjian
Added to open items list: * Fix error message when creating objects in schema that has a dropped tablespace as its default I can confirm the bug still exists in CVS. --- Fabien COELHO wrote: > > Dear Tom

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