Hi,
some weeks ago I started to develop an application using Postgresql the
first time. I'm running 7.4.3 on a Linux box with a plain 2.6.7 kernel, the
storage is handled by 5 SATA disks, managed by a 3ware controller and using
a xfs filesystem. The DB server is a 3 Ghz P4 with 4 Gig of Ram, so
Hi,
> Generally you want '=' conditions on the leftmost index keys; any
> inequality or range constraint should be on the rightmost
> keys. You can see this by thinking about the range of index entries that
> the scan will have to pass over.
I see. Just like in your earlier example, where you red
elein wrote:
When creating a new data type, what are
the operators absolutely necessary for that
type to particpate in a btree index?
I know you need a "compare" that says = < or >=
so does that mean that those three operators
are the ones required?
I don't remember the details, but here is a lin
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> Today I got the error:
> ERROR: FULL JOIN is only supported with mergejoinable join conditions
> Which is really annoying since a full join is exactly what I wanted. I
> guess the alternative is to do a left join and a right join and merge
> the
When creating a new data type, what are
the operators absolutely necessary for that
type to particpate in a btree index?
I know you need a "compare" that says = < or >=
so does that mean that those three operators
are the ones required?
If you also know that answer for our implementation
of R-
Eric Wright <[EMAIL PROTECTED]> writes:
> when I run gmake I get the following error.
> gmake: Entering an unknown directory
> gmake: *** jdbc: No such file or directory. Stop.
> gmake: Leaving an unknown directory
> I know that I am missing something, can anyone help me with w
Good evening,
I am rather new to the linux world and I am diving in head first.
I am trying to set up postgres with perl, python, and java support as I
am going to be developing applications in each to access the database.
I have used the following config string (which runs with out error)
LDF
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> On Tue, Jun 29, 2004 at 10:10:18AM -0400, Tom Lane wrote:
>> Hmm. What system is this on? What errno code corresponds to
>> "Bad file descriptor"?
> That would be EBADF I think. However, my linux manpage indicates it's
> not a possible return
"Joe Maldonado" <[EMAIL PROTECTED]> writes:
> I have a seemingly corrupt row in a table and wanted to look at it's
> contents.
> when I try to query it I get the following...
> db=# select * from some_table offset 411069 limit 1;
> ERROR: invalid memory alloc request size 4294967293
> but when
Today I got the error:
ERROR: FULL JOIN is only supported with mergejoinable join conditions
Which is really annoying since a full join is exactly what I wanted. I
guess the alternative is to do a left join and a right join and merge
them? Is it just that no-one has come up with a way to code th
Hi Tom,
> Good, but you're not there yet --- the Sort step shouldn't be there at
> all. You've still got some inconsistency between the ORDER BY and the
> index. Check my example again.
yes yes I missed that, sorry. Now don't mention the performance because I
couldn' see anything but the result.
Justin Clift <[EMAIL PROTECTED]> writes:
> PL/TCL does seem to provide that extra bit of info to functions/triggers
> that I need, whereas PL/pgSQL doesn't.
It's not so much that there's more info available as that pltcl is
better suited for working with dynamically generated queries. plpgsql
is
Raymond O'Donnell wrote:
On 29 Jun 2004 at 12:59, Carlos Ojea Castro wrote:
I am trying to access a postgresql database.
I made a SQLConnection object and I got it active.
Then I made a SQLQuery object, but when I try to make it active, i get a
'access violation' message.
Probably a silly q
On 29 Jun 2004 at 12:59, Carlos Ojea Castro wrote:
> I am trying to access a postgresql database.
> I made a SQLConnection object and I got it active.
> Then I made a SQLQuery object, but when I try to make it active, i get a
> 'access violation' message.
Probably a silly question, but have you g
Hello:
I am trying to access a postgresql database.
I made a SQLConnection object and I got it active.
Then I made a SQLQuery object, but when I try to make it active, i get a
'access violation' message.
Am I missing something?
Regards,
Carlos
---(end of broadcast)---
On Mon, 28 Jun 2004, Tom Lane wrote:
> Richard Huxton <[EMAIL PROTECTED]> writes:
> > W.B.Hill wrote:
> >> SELECT d+'45 days ago'::interval FROM test;
Yep - it's the clock's going forward that does it. Doh! The quick'n'dirty
work around '45.3 days ago' was what I used but just a straight -45 is
b
> Question #3
> =
> In some places it is said that a transaction that only reads does not lock
> any table or row, and is never blocked. But if a transaction T1 modifies a
> row r, and at the same time transaction T2 selects r, then T2 need to wait
> until T1 finishes (as T1 might have dele
At startup this appears in the log:
WARNING: dup(0) failed after 3195 successes: Bad file
descriptor
What does it mean?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
Title: A few beginner's questions concerning concurrency control
I have a few questions concerning concurrency control. I shall thank whoever can help me.
Question #1
=
Assume the following (concurrent) schedule, in which both transactions run in a serializable isolation level:
T1 be
Hi
i have a table of dates let's
say:
1/1/2004
8/1/2004
15/1/2004
29/1/2004
5/2/2004
12/2/2004
I am searching for a way to have the minimum date
and maximum date for dates seperated by one week whitout gaps between
them.
which will give the
following output:
1/1/2004 , 15/1/2004
29/1/2
20 matches
Mail list logo
