On Tue, Sep 18, 2012 at 07:22:39PM -0400, Bruce Momjian wrote:
> > Based on the fact that sql_features exists in the information_schema
> > schema, I don't think 'sql_features' table is actually being processed
> > by pg_upgrade, but I think its TOAST table, because it has a high oid,
> > is being
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> I wrote:
> > "Etsuro Fujita" writes:
> >> I have a question. I think it would be also better to extend the syntax
> >> for the SQL COPY command in the same way, ie,
> >> COPY foo from '/home/pgsql/decompress.sh /home/pgsql/foo.csv.gz |' with
> >> fo
I wrote:
> "Etsuro Fujita" writes:
>> I have a question. I think it would be also better to extend the syntax for
>> the
>> SQL COPY command in the same way, ie,
>> COPY foo from '/home/pgsql/decompress.sh /home/pgsql/foo.csv.gz |' with
>> format
>> 'csv'
> Yeah, sure --- that case is already
"Etsuro Fujita" writes:
>> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
>> I think it would be better to present this as something like
>> \copy foo from '/home/pgsql/decompress.sh /home/pgsql/foo.csv.gz |' with
>> format 'csv'
> I have a question. I think it would be also better to extend the syn
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> "Etsuro Fujita" writes:
> > Maybe my explanation was insufficient. Let me add one thing to my earlier
> > explanation. The submitted patch allows the psql \copy instruction to be
> > executed like:
>
> > $ echo '/bin/gunzip -c $1' > decompress.sh
On Mon, Sep 17, 2012 at 05:07:23PM -0400, Bruce Momjian wrote:
> > # select * from pg_tables where tablename='sql_features';
> > schemaname | tablename | tableowner | tablespace |
> > hasindexes | hasrules | hastriggers
> > +--+++--
I got interested in this problem again now that we have a user complaint
about it (bug #7553).
Ashutosh Bapat writes:
> On Wed, Feb 1, 2012 at 11:01 PM, Robert Haas wrote:
>> On Wed, Feb 1, 2012 at 12:23 PM, Tom Lane wrote:
>>> ... It seems
>>> reasonable to me to try to handle relation renames
Hi,
please find attached the refreshed v1 patch.
Regards,
Marco
--
Marco Nenciarini - 2ndQuadrant Italy
PostgreSQL Training, Services and Support
marco.nenciar...@2ndquadrant.it | www.2ndQuadrant.it
Array-ELEMENT-foreign-key-v1-refreshed.patch.bz2
Description: application/bzip
--
Sent
"Etsuro Fujita" writes:
> Maybe my explanation was insufficient. Let me add one thing to my earlier
> explanation. The submitted patch allows the psql \copy instruction to be
> executed like:
> $ echo '/bin/gunzip -c $1' > decompress.sh
> $ chmod +x decompress.sh
> postgres=# \copy foo FROM '/
On 31 August 2012 07:59, Dean Rasheed
wrote:
> On 30 August 2012 20:05, Robert Haas wrote:
>> On Sun, Aug 12, 2012 at 5:14 PM, Dean Rasheed
>> wrote:
> Here's an updated patch for the base feature (without support for
> security barrier views) with updated docs and regression tests.
Please
On Tuesday, September 18, 2012 6:03 PM Fujii Masao wrote:
On Mon, Sep 17, 2012 at 4:03 PM, Amit Kapila wrote:
>> To define the behavior correctly, according to me there are 2 options
now:
>
>> Approach-1 :
>> Document that both(sender and receiver) the timeout parameters should be
>> greater than
On Mon, Sep 17, 2012 at 4:03 PM, Amit Kapila wrote:
> To define the behavior correctly, according to me there are 2 options now:
>
> Approach-1 :
> Document that both(sender and receiver) the timeout parameters should be
> greater than wal_receiver_status_interval.
> If both are greater, then I th
On Tue, Aug 21, 2012 at 8:08 AM, Qi Huang wrote:
>> Please add your patch here:
>>
>> https://commitfest.postgresql.org/action/commitfest_view/open
>>
>> --
>> Robert Haas
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>
> Hi, Robert
> I added it under "Misce
> From: Craig Ringer [mailto:ring...@ringerc.id.au]
> On 09/13/2012 10:25 PM, Tom Lane wrote:
> > I think it would be a lot better if this were designed so that the
> > processor programs executed on client side. Which would probably make
> > it not a COPY patch at all, but something in psql.
Ma
Hi all,
In PostgreSQL 9.1 and 9.2 (possibly also in earlier versions), the query
--8<--
WITH source AS (
SELECT i FROM generate_series(1,10) AS i
)
SELECT
i
FROM
source, (
SELECT
count(*) AS _n
FROM source
) AS _stats
WHERE
random() < 5::DOUBLE PREC
On 09/13/2012 10:25 PM, Tom Lane wrote:
I think it would be a lot better if this were designed so that the
processor programs executed on client side. Which would probably make
it not a COPY patch at all, but something in psql.
Either that, or allow the pre- and post- processors to be programs
16 matches
Mail list logo
