Re: [BUGS] BUG #6480: NLS text width problem

2012-03-07 Thread Sergey Burladyan
Tom Lane t...@sss.pgh.pa.us writes: I think it'd be better to avoid depending on %*s for the data string and instead use it (with appropriate adjustment of the calculation) for the space-separator part of the format. Since that's a constant empty string, there shouldn't be any possibility of

Re: [BUGS] Extension tracking temp table and causing update failure

2012-03-07 Thread Dimitri Fontaine
Tom Lane t...@sss.pgh.pa.us writes: However, recordDependencyOnCurrentExtension doesn't know that the table is meant to be transient and links it to the current extension; so when the table gets dropped a bit later, the dependency code complains. [...] Instead, I'm tempted to propose that

Re: [BUGS] BUG #6334: initdb not working

2012-03-07 Thread Weiss, Wilfried
Hi Alvaro, I just compiled version 9.1.3 and got quite the same error. I still do not have any clue what to change, as the compile runs successfully without any error. Regards Wilfried -Ursprüngliche Nachricht- Von: Alvaro Herrera [mailto:alvhe...@alvh.no-ip.org] Gesendet:

[BUGS] BUG #6523: Problems with dbpool()

2012-03-07 Thread pradeep . vishwakarma
The following bug has been logged on the website: Bug reference: 6523 Logged by: pradeep Email address: pradeep.vishwaka...@routesms.com PostgreSQL version: 9.1.2 Operating system: Window xp Description: Problem with COPY COMMAND in java code. File path can't read

Re: [BUGS] BUG #6523: Problems with dbpool()

2012-03-07 Thread Kevin Grittner
pradeep.vishwaka...@routesms.com wrote: Problem with COPY COMMAND in java code. File path can't read with dbpool.It require base connection(PostgreSql). It sounds like you need to investigate whether dbpool includes support for database-specific extensions like COPY; and if so whether and

Re: [BUGS] Extension tracking temp table and causing update failure

2012-03-07 Thread Tom Lane
Dimitri Fontaine dimi...@2ndquadrant.fr writes: Tom Lane t...@sss.pgh.pa.us writes: It would also have the effect that explicit DROPs of member objects in extension scripts could be done without an explicit ALTER EXTENSION DROP first. I think we'd originally decided that requiring the ALTER

Re: [BUGS] [GENERAL] Altering a table with a rowtype column

2012-03-07 Thread Merlin Moncure
On Wed, Mar 7, 2012 at 11:45 AM, Mike Blackwell mike.blackw...@rrd.com wrote: works for me -- what version are you on? merlin -- [wcs1459@aclnx-cisp01 ~]$ psql --version psql (PostgreSQL) 9.1.1 contains support for command-line editing [wcs1459@aclnx-cisp01 ~]$ cat x create table

Re: [BUGS] Extension tracking temp table and causing update failure

2012-03-07 Thread Tom Lane
I wrote: But anyway, we all seem to agree that this seems like a reasonable fix, so I will look into making it happen. The attached proposed patch fixes the symptom Phil reported. However, I think we still have some work to do. I experimented with creating temp tables within an extension

Re: [BUGS] Extension tracking temp table and causing update failure

2012-03-07 Thread Phil Sorber
On Wed, Mar 7, 2012 at 1:46 PM, Tom Lane t...@sss.pgh.pa.us wrote: The attached proposed patch fixes the symptom Phil reported.  However, I think we still have some work to do.  I experimented with creating temp tables within an extension upgrade script, and found two interesting misbehaviors

Re: [BUGS] [GENERAL] Altering a table with a rowtype column

2012-03-07 Thread Merlin Moncure
On Wed, Mar 7, 2012 at 1:17 PM, Mike Blackwell mike.blackw...@rrd.com wrote: As a followup, the workaround fails if there is data in the source table due to the initial null value placed in the existing data rows. [wcs1459@aclnx-cisp01 ~]$ psql --port=5433 -e -f x begin; BEGIN create table

Re: [BUGS] [GENERAL] Altering a table with a rowtype column

2012-03-07 Thread Tom Lane
Merlin Moncure mmonc...@gmail.com writes: On Wed, Mar 7, 2012 at 11:45 AM, Mike Blackwell mike.blackw...@rrd.com wrote: alter table a add column even_more_stuff boolean not null default false; aha! that's not what you posted last time. you appended 'not null default false'; which

Re: [BUGS] [GENERAL] Altering a table with a rowtype column

2012-03-07 Thread Alvaro Herrera
Excerpts from Tom Lane's message of mié mar 07 17:31:32 -0300 2012: This probably could be done for rowtype columns as well, but nobody has collected the necessary round tuits. I think there was some fear of locking/deadlock issues, too. It's probably easy to do if you require it to be

Re: [BUGS] [GENERAL] Altering a table with a rowtype column

2012-03-07 Thread Merlin Moncure
On Wed, Mar 7, 2012 at 2:31 PM, Tom Lane t...@sss.pgh.pa.us wrote: Merlin Moncure mmonc...@gmail.com writes: On Wed, Mar 7, 2012 at 11:45 AM, Mike Blackwell mike.blackw...@rrd.com wrote: alter table a add column even_more_stuff boolean not null default false; aha! that's not what you posted

Re: [BUGS] Extension tracking temp table and causing update failure

2012-03-07 Thread Tom Lane
Phil Sorber p...@omniti.com writes: On Wed, Mar 7, 2012 at 1:46 PM, Tom Lane t...@sss.pgh.pa.us wrote: 1. If you forget to drop the temp table before ending the script, then when the session ends and the temp table is forcibly dropped, the whole extension goes away (following the rule that a

Re: [BUGS] BUG #6480: NLS text width problem

2012-03-07 Thread Tom Lane
Sergey Burladyan eshkin...@gmail.com writes: Tom Lane t...@sss.pgh.pa.us writes: I think it'd be better to avoid depending on %*s for the data string and instead use it (with appropriate adjustment of the calculation) for the space-separator part of the format. Since that's a constant empty