Tom Lane wrote:
Glyn Astill <[EMAIL PROTECTED]> writes:
No. Will recompile with debug info and post back when done.
FWIW, the most likely issue here is the MIPS-specific assembly code in
src/include/storage/s_lock.h --- I'm not sure how many MIPS platforms
that's really been exercised on, but
On Fri, 2008-07-18 at 20:25 -0400, Francisco Reyes wrote:
> Does pg_snapclone works mostly on large rows or will it also be faster
> than pg_dump for narrow tables?
It allows you to run your dump in multiple pieces. Thats got nothing to
do with narrow or wide.
--
Simon Riggs www.2n
On Fri, Jul 18, 2008 at 04:48:26PM -0400, Francisco Reyes wrote:
> On 3:55 pm 07/18/08 Tom Lane <[EMAIL PROTECTED]> wrote:
> > > AfterTriggerEvents: 10553909248 total in 1268 blocks; 20432 free (6
> > > chunks); 1055316 used
> >
> > Well, that's definitely your problem ...
>
> What is the ov
Martijn van Oosterhout wrote:
Can you make them not deferred?
How?
I found the issue.
I had the foreign key in the master table instead of the children.
Deleted RI from master table and put into the inherited partitions.
My whole 230 million rows merged in about an hour!
And I even had two of
> From: Stefan Kaltenbrunner <[EMAIL PROTECTED]>
> Tom Lane wrote:
> > Glyn Astill writes:
> >> No. Will recompile with debug info and post back when done.
> >
> > FWIW, the most likely issue here is the MIPS-specific assembly code in
> > src/include/storage/s_lock.h --- I'm not sure how many MIP
Glyn Astill <[EMAIL PROTECTED]> writes:
> Would the mips specific code behave differently on different oses?
I'm more worried about there being more than one type of MIPS CPU out
there. Do all qubes contain exactly the same sub-architecture?
The references to "mips2" in s_lock.h are attention-get
I think so yes.
Qube/Raq2's have a RM5231 in them, whereas the Qube/Raq had a slowere RM5230
with less cache. Then the 3's moved on to the x86 platform.
A recompile with --enable-debug, then rerunning the make check gave me the same
backtrace from gdb
- Original Message
> From: Tom
Hello
http://www.postgresql.org/docs/8.3/interactive/plpgsql-cursors.html#PLPGSQL-CURSOR-USING
regards
Pavel Stehule
2008/7/18 dfx <[EMAIL PROTECTED]>:
> Hi Guru,
>
> can a function returns a cursor?
>
> Thank you!
>
> Domenico
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgre
Francisco Reyes wrote:
> I had the foreign key in the master table instead of the children.
> Deleted RI from master table and put into the inherited partitions.
> My whole 230 million rows merged in about an hour!
Heh -- but are the FKs now checked? Try inserting something that
violates the con
Alvaro Herrera writes:
Heh -- but are the FKs now checked? Try inserting something that
violates the constraints and see if they are rejected.
I knew it sounded too good to be true.
1- The trigger was not set in the master (ie nothing went to the children).
2- The master had no index and no R
Francisco Reyes wrote:
> I knew it sounded too good to be true.
> 1- The trigger was not set in the master (ie nothing went to the children).
> 2- The master had no index and no RI.. so it was a straight insert.
>
> I corrected (ie set the trigger in the master and RI in the children).
> Has been
childrensjustice=# create table petition_bail like petition_white;
ERROR: syntax error at or near "like"
LINE 1: create table petition_bail like petition_white;
Huh?
Yes, the source table exists and obviously as postgres superuser
("pgsql") I have select permission on the parent.
--
Karl Den
>
> childrensjustice=# create table petition_bail like petition_white;
> ERROR: syntax error at or near "like"
> LINE 1: create table petition_bail like petition_white;
>
> Huh?
>
> Yes, the source table exists and obviously as postgres superuser
> ("pgsql") I have select permission on the par
On Sat, Jul 19, 2008 at 9:02 PM, Karl Denninger <[EMAIL PROTECTED]> wrote:
> childrensjustice=# create table petition_bail like petition_white;
> ERROR: syntax error at or near "like"
> LINE 1: create table petition_bail like petition_white;
It's not super-easy to see from the docs, but I think y
Douglas McNaught wrote:
On Sat, Jul 19, 2008 at 9:02 PM, Karl Denninger <[EMAIL PROTECTED]> wrote:
childrensjustice=# create table petition_bail like petition_white;
ERROR: syntax error at or near "like"
LINE 1: create table petition_bail like petition_white;
It's not super-easy to s
Glyn Astill <[EMAIL PROTECTED]> writes:
> A recompile with --enable-debug, then rerunning the make check gave me the
> same backtrace from gdb
Did you actually give a "bt" command, or was that just the initial
output from gdb?
Another thing to try is looking around the current instruction pointe
I get this error
ERROR: syntax error at or near "cursor"
CONTEXT: invalid type name "scroll cursor for select * from tpcd.customer"
compile of PL/pgSQL function "udf" near line 5
Douglas McNaught wrote:
>
> On Fri, Jul 18, 2008 at 12:07 PM, Suresh_ <[EMAIL PROTECTED]> wrote:
>>
>> Hello,
>>
17 matches
Mail list logo
