"scott.marlowe" <[EMAIL PROTECTED]> writes:
> The optimizations made for in() queries in the 7.4 branch only really work
> when there's a subselect / table in the in. You could try inserting those
> numbers into a temp table and subselecting it.
I'll second this option.
But the other choic
I'm trying to get sql-ledger up and running.
(I sent some earlier email's but I can't tell if they were received because
I'm note receiving any posts from this list in my mailbox even though I am
subscribed. I sent an email to the listmaster but it was returned.)
So I deleted /sql-ledger and r
On Thu, Jan 29, 2004 at 08:50:47PM -0500, Manuel Tejada wrote:
> By the way, what does mean RHEL3?
"Red Hat Entreprise Linux", a commercial Linux distribution (meaning you
shouldn't use it unless you pay for it).
> Is it a new version of Red Hat?
You mean Red Hat as in "Red Hat Linux"? That pr
You are right, I installed PostgreSQL 7.4.1 rpms from directory RHEL3 on Red
Hat 9.0 and the new version works OK.
The only extrange thing I noticed after the installation is when I press the
rigth button on any file from any directory to select an editor (for example
vim) the editor doesn't respon
CSN wrote:
Is there much difference between using subqueries and
separating out them into separate queries?
That would depend on what results your expecting, and how you intend on using the results.
For example if you want all the data in a single statement, you can't break it up, but
the req
Is there much difference between using subqueries and
separating out them into separate queries?
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
---(end of broadcast)
Randolf Richardson wrote:
In dealing with web applications and frontends to database or
even just a dynamic web site PHP has every bit the power and ability that
Java does and the development time is way down.
Uh, how about threads. I know that you don't need them much but it sure
would be nice to
Martin Marques <[EMAIL PROTECTED]> writes:
> I was reading the section about Planner Method Configuration, and I just don't
> get why all the options have this message: "This is used for debugging the
> query planner". Are they all debugging options, because they don't look like.
The enable_xxx
El Jue 29 Ene 2004 16:26, Barbara Lindsey escribió:
> What permission does a user need to have to query the pg_ tables
> (pg_attribute, pg_class, etc) ? Do they require special permissions?
What kind of queries? Read or Write?
Users have permission to read from most catalog tables. One they can'
Tom Lane wrote:
Brendan Jurd <[EMAIL PROTECTED]> writes:
I think the idea of the update default has interesting possbilities.
Perhaps what is needed is two classes of defaults.
1. "implicit default" -- any updates to a tuple either not specifying a
value
What permission does a user need to have to query the pg_ tables
(pg_attribute, pg_class, etc) ? Do they require special permissions?
arbara Lindsey wrote:
What kind of grant do you need to give a user so that they can have
permission to do a "SELECT nextval(ID)" on a sequence?
I granted the us
I was reading the section about Planner Method Configuration, and I just don't
get why all the options have this message: "This is used for debugging the
query planner". Are they all debugging options, because they don't look like.
http://www.postgresql.org/docs/current/interactive/
-> runti
"W. van den Akker" <[EMAIL PROTECTED]> writes:
> I have a little test program (see at the end of the message). The program
> crashes when PQTrace is called (instruction referenced memory at
> "0x0010", the
> memory could not be written" (obvious ... )
> I use the library libpqdll.lib and
Dave Smith <[EMAIL PROTECTED]> writes:
> I am running 7.2.4 and when running a vacuum on my database I get
> NOTICE: Child itemid in update-chain marked as unused - can't continue
> repair_frag
> ERROR: No one parent tuple was found
> vacuumdb: vacuum import failed
> How do I fix this?
I beli
I think you should provide an explicit grant (all) on the sequence as
well. The Sequence is an object that is distinct from the table that uses
it.
John Sidney-Woollett
Barbara Lindsey said:
> What kind of grant do you need to give a user so that they can have
> permission to do a "SELECT nextval
Yay! It works.
Thank you.
Bruno Wolff III wrote:
On Thu, Jan 29, 2004 at 09:52:56 -0500,
Barbara Lindsey <[EMAIL PROTECTED]> wrote:
What kind of grant do you need to give a user so that they can have
permission to do a "SELECT nextval(ID)" on a sequence?
I granted the user SELECT,UPDATE,INSERT,
On Thu, Jan 29, 2004 at 09:52:56 -0500,
Barbara Lindsey <[EMAIL PROTECTED]> wrote:
> What kind of grant do you need to give a user so that they can have
> permission to do a "SELECT nextval(ID)" on a sequence?
> I granted the user SELECT,UPDATE,INSERT,DELETE on all the tables,
> including the o
Mensaje citado por Barbara Lindsey <[EMAIL PROTECTED]>:
> What kind of grant do you need to give a user so that they can have
> permission to do a "SELECT nextval(ID)" on a sequence?
> I granted the user SELECT,UPDATE,INSERT,DELETE on all the tables,
> including the one that has the sequence, bu
What kind of grant do you need to give a user so that they can have
permission to do a "SELECT nextval(ID)" on a sequence?
I granted the user SELECT,UPDATE,INSERT,DELETE on all the tables,
including the one that has the sequence, but the sequence query is
failing on permissions.
--
Barbara E. L
Hello,
I have a little test program (see at the end of the message). The program
crashes when PQTrace is called (instruction referenced memory at
"0x0010", the
memory could not be written" (obvious ... )
I use the library libpqdll.lib and postgresql v7.3.4. When I comment the
line the p
I am running 7.2.4 and when running a vacuum on my database I get
NOTICE: Child itemid in update-chain marked as unused - can't continue
repair_frag
ERROR: No one parent tuple was found
vacuumdb: vacuum import failed
How do I fix this?
--
Dave Smith
CANdata Systems Ltd
416-493-9020
--
Hi guys,
> =?iso-8859-1?q?MaRCeLO=20PeReiRA?=
> <[EMAIL PROTECTED]> writes:
> > And, yes, I was receiving "connection refused" in
> the
> > cases when the postmaster was gone!
>
> You didn't say that, you said it froze. Please be
> more accurate about
> your bug reports in future. A minimum req
22 matches
Mail list logo
