Re: [BUGS] BUG #2645: pg_restore crashes

2006-09-24 Thread Tom Lane
"Thomas Verchow" <[EMAIL PROTECTED]> writes: > pg_restore ends with ,,Segmentation fault'' or ,,out of memory'' while > trying to restore a large custom-archive-backup (~ 30 GB). Can you provide a test case for this? Perhaps a SQL script to generate a database full of junk data, which when dumped

Re: [BUGS] BUG #2643: Auto trim on insert and update

2006-09-24 Thread Tom Lane
"Gene Neely" <[EMAIL PROTECTED]> writes: > I have found no way to automatically trim fields to the length of the > varchar or char on inserts and updates. Write an explicit cast to varchar(N) or whatever it is. > Can this become a Configuration option??? No, because the behavior is required by t

Re: [BUGS] BUG #2648: I can not create table name with capital and

2006-09-24 Thread Richard Troy
Asaf, quote them and it will work. Richard On Sun, 24 Sep 2006, Asaf Avraham wrote: > Date: Sun, 24 Sep 2006 06:18:38 GMT > From: Asaf Avraham <[EMAIL PROTECTED]> > To: pgsql-bugs@postgresql.org > Subject: [BUGS] BUG #2648: I can not create table name with capital and > small characters >

Re: [BUGS] BUG #2649: wish: provide multi-row INSERT with

2006-09-24 Thread Bruce Momjian
Maciej Pilichowski wrote: > > The following bug has been logged online: > > Bug reference: 2649 > Logged by: Maciej Pilichowski > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.3 > Operating system: opensuse 10.0 > Description:wish: provide multi-row INSER

[BUGS] BUG #2645: pg_restore crashes

2006-09-24 Thread Thomas Verchow
The following bug has been logged online: Bug reference: 2645 Logged by: Thomas Verchow Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: GNU/Linux, Debian sarge Description:pg_restore crashes Details: pg_restore ends with ,,Segmentation f

[BUGS] BUG #2647: Atomicity issues when using rules

2006-09-24 Thread
The following bug has been logged online: Bug reference: 2647 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Debian GNU/Linux Description:Atomicity issues when using rules Details: When I ensure atomicity by locking tables in

[BUGS] BUG #2649: wish: provide multi-row INSERT with VALUES

2006-09-24 Thread Maciej Pilichowski
The following bug has been logged online: Bug reference: 2649 Logged by: Maciej Pilichowski Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: opensuse 10.0 Description:wish: provide multi-row INSERT with VALUES Details: There is: INSERT .

[BUGS] BUG #2643: Auto trim on insert and update

2006-09-24 Thread Gene Neely
The following bug has been logged online: Bug reference: 2643 Logged by: Gene Neely Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.x 8.1.x Operating system: Linux Description:Auto trim on insert and update Details: THIS IS NOT A BUG, but a request. Found n

[BUGS] BUG #2648: I can not create table name with capital and small characters

2006-09-24 Thread Asaf Avraham
The following bug has been logged online: Bug reference: 2648 Logged by: Asaf Avraham Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4.2 Operating system: win Description:I can not create table name with capital and small characters Details: I have table t

[BUGS] BUG #2644: pgadmin III foreign key

2006-09-24 Thread Massimiliano Citterio
The following bug has been logged online: Bug reference: 2644 Logged by: Massimiliano Citterio Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Windows 2003 Description:pgadmin III foreign key Details: The referencing column dropdown lis

[BUGS] BUG #2646: Installation Failed due to Permissions

2006-09-24 Thread Willa Wei
The following bug has been logged online: Bug reference: 2646 Logged by: Willa Wei Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Windows XP Pro Description:Installation Failed due to Permissions Details: Dear support, I tried to insta

Re: [BUGS] Out of memory error during large hashagg

2006-09-24 Thread Tom Lane
Casey Duncan <[EMAIL PROTECTED]> writes: > seed | st_id | 164656 > I ran analyze after this, but the results were roughly the same. What's the statistics target set to, and did you try increasing it? Can we see the rest of the pg_stats row for this column (I'm mainly interested in