On Thu, Apr 14, 2011 at 22:57, qintao wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5979
> Logged by: qintao
> Email address: qin...@huaweisymantec.com
> PostgreSQL version: 8.4.7
> Operating system: windows server 2008
> Description: postgres
On Fri, Apr 15, 2011 at 2:16 AM, Chris Price wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5981
> Logged by: Chris Price
> Email address: cjpr...@bigpond.net.au
> PostgreSQL version: 9.0.3
> Operating system: Winders Server 2008 R2 Standard
> Descript
Mark Kirkwood wrote:
> Here's a simplified example using synthetic data (see attached to
> generate if desired):
Doesn't work for me:
kgrittn@kgrittn-desktop:~/work/starjoin$ ./gendata.pl
generate cat
cannot open cat.dat: No such file or directory at ./gendata.pl line
17.
> Here's what a p
"Kevin Grittner" wrote:
> Mark Kirkwood wrote:
>
>> Here's a simplified example using synthetic data (see attached to
>> generate if desired):
>
> Doesn't work for me:
Edited scripts to change hard-coded directory. Issue confirmed.
> If you run pmap -d on the pid, what does the last line
Mark Kirkwood writes:
> I've recently seen examples of star-like queries using vast amounts of
> memory in one of our production systems. Here's a simplified example
> using synthetic data (see attached to generate if desired):
> SET geqo_threshold = 14;
> SET from_collapse_limit = 14;
> SET jo
The following bug has been logged online:
Bug reference: 5982
Logged by: Rikard Pavelic
Email address: rikard.pave...@zg.htnet.hr
PostgreSQL version: 9.1.alpha5
Operating system: Windows XP SP3
Description:recursive type crashes postgres
Details:
CREATE TYPE turtle
On Fri, Apr 15, 2011 at 1:34 PM, Rikard Pavelic
wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5982
> Logged by: Rikard Pavelic
> Email address: rikard.pave...@zg.htnet.hr
> PostgreSQL version: 9.1.alpha5
> Operating system: Windows XP SP3
> Descriptio
Merlin Moncure writes:
> On Fri, Apr 15, 2011 at 1:34 PM, Rikard Pavelic
> wrote:
>> CREATE TYPE turtle AS
>> (
>>name varchar
>> );
>> ALTER TYPE turtle ADD ATTRIBUTE offspring turtle;
> This is a duplicate: see Mar 28 thread 'Recursive containment of
> composite types'. Was it decided
On 15.4.2011 21:06, Tom Lane wrote:
> The former.
>
> regression=# CREATE TYPE turtle AS
> (
> name varchar
> );
> CREATE TYPE
> regression=# ALTER TYPE turtle ADD ATTRIBUTE offspring turtle;
> ERROR: composite type turtle cannot be made a member of itself
> regression=#
>
>
Rikard Pavelic wrote:
> On 15.4.2011 21:06, Tom Lane wrote:
>> The former.
>>
>> regression=# CREATE TYPE turtle AS
>> (
>> name varchar
>> );
>> CREATE TYPE
>> regression=# ALTER TYPE turtle ADD ATTRIBUTE offspring turtle;
>> ERROR: composite type turtle cannot be made a member of itself
>> reg
On 15.4.2011 22:49, Kevin Grittner wrote:
> Rikard Pavelic wrote:
>> On 15.4.2011 21:06, Tom Lane wrote:
>>> The former.
>>>
>>> regression=# CREATE TYPE turtle AS
>>> (
>>> name varchar
>>> );
>>> CREATE TYPE
>>> regression=# ALTER TYPE turtle ADD ATTRIBUTE offspring turtle;
>>> ERROR: composit
On Fri, Apr 15, 2011 at 3:49 PM, Kevin Grittner
wrote:
> I haven't seen anything which seems like a reasonable use case yet,
> myself. If you were *actually* tracking turtles and their
> offspring, that would be a completely worthless data structure. Is
> there really a case where a reference to
On 04/15/11 2:04 PM, Rikard Pavelic wrote:
This feature would reduce object-relational impedance mismatch in DDD,
objects aren't relational.deal with it. OOPS may be a reasonable
methodology for coding, however its purely hierarchical, and doesn't map
at all well to relational calculus.
=?utf-8?Q?=D0=90=D0=BD=D1=82=D0=BE=D0=BD_=D0=9A=D1=83=D0=B7=D0=BD=D0=B5=D1=86=D0=BE=D0=B2?=
writes:
> TRAP: FailesAssertion("!(outerstartsel <= outerendsel)", File:
> "costsize.c", String: 1540)
On reflection it seems the only way you could get past the preceding
"Assert(outer_skip_rows <= oute
Merlin Moncure wrote:
> There are lots of use cases for this. I use composite types to
> marshal data to the client all the time, and recursive structures
> are fairly common in many classic problems. Recursive composites
> fit the bill perfectly.
I'm trying to get my head around why SQL com
On Fri, Apr 15, 2011 at 4:27 PM, Kevin Grittner
wrote:
> Merlin Moncure wrote:
>
>> There are lots of use cases for this. I use composite types to
>> marshal data to the client all the time, and recursive structures
>> are fairly common in many classic problems. Recursive composites
>> fit the
Merlin Moncure wrote:
> Consider we also have to send data to the database. I can
> recursively wrap up data in the client using libpqtypes, fire it
> to a receiving function which unnests it and processes it. This
> is a couple of orders of magnitude faster than streaming it in
> over multipl
On 4/15/2011 6:14 PM, Kevin Grittner wrote:
Merlin Moncure wrote:
Consider we also have to send data to the database. I can
recursively wrap up data in the client using libpqtypes, fire it
to a receiving function which unnests it and processes it. This
is a couple of orders of magnitude fast
18 matches
Mail list logo
