Tom Lane 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 libc doing som
Tom Lane 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 dependency.c
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: Mittwoch,
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 wit
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 how the PostgreSQL COPY command
Dimitri Fontaine writes:
> Tom Lane 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 was a
>> good safety feature, but i
On Wed, Mar 7, 2012 at 11:45 AM, Mike Blackwell 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 a (
>
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 upg
On Wed, Mar 7, 2012 at 1:46 PM, Tom Lane 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 that the patch
On Wed, Mar 7, 2012 at 1:17 PM, Mike Blackwell 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 a (
> id seria
Merlin Moncure writes:
> On Wed, Mar 7, 2012 at 11:45 AM, Mike Blackwell
> 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 inexplicably breaks the ALTER.
> try this:
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 ma
On Wed, Mar 7, 2012 at 2:31 PM, Tom Lane wrote:
> Merlin Moncure writes:
>> On Wed, Mar 7, 2012 at 11:45 AM, Mike Blackwell
>> 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 f
Phil Sorber writes:
> On Wed, Mar 7, 2012 at 1:46 PM, Tom Lane 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 forced drop
>> of an extensi
Sergey Burladyan writes:
> Tom Lane 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 an
15 matches
Mail list logo
