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
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
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:
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
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
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
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
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
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
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
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
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
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
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
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
15 matches
Mail list logo