Simple (I think) question ... is there a way of having an application
attempt to acquire a LOCK on a table *without* it blocking? Right now, if
you try to LOCK a table that another process has LOCKed, it will hang
indefinitely waiting for the other LOCK to drop ... is there a way of
setting a 'ti
perfect, its one of those that I've used so rarely, I never thought about
it ... thanks :)
On Sat, 15 Jun 2003, deststar wrote:
> Isn't that what the having clause is about?
> - Stuart
>
> On Sun, 2003-06-15 at 00:31, The Hermit Hacker wrote:
> > I
I have a query that looks like:
SELECT SUM(bytes) AS traffic
FROM traffic_table
GROUP BY ip;
I want to narrow that SELECT down to a subset, like:
SELECT SUM(bytes) AS traffic
FROM traffic_table
WHERE traffic < ( 100 * 1024 * 1024 )
GROUP BY ip;
which, of course, won't work,
Perfect, thank you ... i knew I was overlooking something obvious ... the
query just flies now ...
On Mon, 18 Jun 2001, Tom Lane wrote:
> The Hermit Hacker <[EMAIL PROTECTED]> writes:
> >> Try adding ... AND n.nid = 15748 ... to the WHERE.
>
> > n.nid is the note
On Mon, 18 Jun 2001, Josh Berkus wrote:
> HH:
>
> > Will try and get some time this week to do a major overhaul of the
> > mhonarc
> > side of the lists, as it looks like hell right now :(
> >
>
> Why not just link to Oleg's version? It seems to work pretty well.
Oleg's version is searchable,
On Mon, 18 Jun 2001, Tom Lane wrote:
> The Hermit Hacker <[EMAIL PROTECTED]> writes:
> > FROM note_links nl, notes n LEFT JOIN calendar c ON (n.nid = c.nid)
> > WHERE (n.type = 'A' OR n.type = 'N' OR n.type = 'H' OR n.type =
Okay, I *really* have to dive into the mhonarc archives and clean it out,
but I just went through and added a link to fts from the 'head' pages for
each list, so that ppl know where to go to search ...
Will try and get some time this week to do a major overhaul of the mhonarc
side of the lists,
Morning ...
I'm trying to wrack my brain over something here, and no matter
how I try and look at it, I'm drawing a blank ...
I have two tables that are dependent on each other:
notes (86736 tuples) and note_links (173473 tuples)
The relationship is that one no
= pd.gid AND pd.gender = 0)
AND (s.gid = rw.gid AND rw.gender = 0 )
GROUP BY s.gid,s.created
ORDER BY images desc;
The part that had confused me was the whole 'ON' part ... once I clued in
that that is essentially a WHERE, it actually made sense ...
On Sat, 12 May 2001, The Her
Okay, not sure best way to try and describe this ... have multiple tables,
of a form like:
table a
gid int
data text
table b
gid int
data text
table c
gid int
data text
table d
gid int
data text
I want to return:
a.gid,a.data,b
Can someone suggest how to improve the following query, so as to make the
LIKE section operate on the results found by the = one?
SELECT ndict.url_id,ndict.intag
FROM ndict,url
WHERE ndict.word_id=-720551816
AND url.rec_id=ndict.url_id
AND ((url.url || '') LIKE '%http://www.postgresql.o
On Wed, 7 Mar 2001, Xu Yifeng wrote:
> do you really know the problem of PGSQL storage manager? it DOES NOT
> reuse deleted record space. it also grows database size when you just
> update but not insert record. it is a MS ACCESS like storage manager.
> it is a functional bug. there is logic bug,
v7.1's contrib directory has the mysql->pgsql script that was used for the
SourceForge migration ... its also downloadable at
http://www.pgsql.com->Downloads
On Tue, 6 Mar 2001, Brett W. McCoy wrote:
> On Tue, 6 Mar 2001, Josh Berkus wrote:
>
> > Just a quick question ... I need to do a r
On Sun, 4 Mar 2001, xuyifeng wrote:
>
> - Original Message -
> From: The Hermit Hacker <[EMAIL PROTECTED]>
> To: Jaruwan Laongmal <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Friday, March 02, 2001 8:04 PM
> Sub
On Fri, 2 Mar 2001, Jaruwan Laongmal wrote:
> I had deleted a very large number of records out of my SQL table in order to
> decrease the harddisk space. But after I use command 'ls -l
> /usr/local/pgsql/data/base/', it is found that the size of concerning files
> do not reduce due to the effect
the LDP project doesn't allow for 'taking over' someone elses work, but
Thomas is working the sites maintainer on an appropriate solution for the
problem, as even though its removed, it will come back again *groan*
On Tue, 6 Feb 2001, Thomas Swan wrote:
> > Has been removed from the LDP websit
Error on pgsql.com ... I was nowhere near Las Vegas on Dec 12th ...
On Tue, 9 Jan 2001, Kaare Rasmussen wrote:
>
> > Looks OK here. Maybe a bad mirror. Do:
>
> Nope. But I must admit that the item about the award is there - it's just
> dated November 16, where the date on pgsql.com is Dec. 12
Erk, ookay, didn't think of that ... Kaare, what URL/mirror are you
hitting? Can you email Vince and let him know, so taht he can get that
removed?
Thanks ...
On Tue, 9 Jan 2001, Bruce Momjian wrote:
> > I have no graphical browser right now, and lynx isn't installed, so I'm a
> > bit at a di
On Tue, 9 Jan 2001, Kaare Rasmussen wrote:
> I wonder why http://www.postgresql.org is not updated with news. The
> latest "Latest News" is from Nov 16. I have to go to
> http://www.pgsql.com to find some interesting news later than that:
> 2000-12-22 PostgreSQL, Inc. Releases Open Source Replica
On Tue, 2 Jan 2001, Diehl, Jeffrey wrote:
> Hi all.
>
> I'm hoping to migrate from mysql to postgresql but need some of the features
> in 7.5. Any idea when it will be out?
well, we have to get through 7.1, 7.2, 7.3 and 7.4 first ... at a 6mo
turnaround on each release, sometime in '03? :)
ser
oh, wait, you didn't want me to remove dana from all lists? :) if
offensive on one, I figure its offensive on all ... saves time, no?
On Thu, 14 Dec 2000, Tom Lane wrote:
> As of a few moments ago, Dana Reed is an ex-subscriber to pgsql-general.
> Evidently he/she is about to be an ex-subscrib
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
On Tue, 24 Oct 2000, Craig May wrote:
>
> Considering postgresql performs so well for me here, why is the
> postgres site search so fucking slow??
The search engine used (udmsearch) isn't written to be the most efficient
as far as making use of SQL features are concerned (ie. it was designed
wi
On Sun, 20 Aug 2000, Franz J Fortuny wrote:
>
>
>
> "What version of Postgres are you using, and what does
> EXPLAIN show
> as the query plan for this query? How many tableY rows
> is the sub-
> query likely to produce, and how many matches do you
> expect to get
> from tableX?"
>
> Version:
UPDATE SET field1=,field2=
On Tue, 15 Aug 2000, k.c. hemelstrand wrote:
> Can anybody help with why I am receiving the error below?
>
> Thanks
> K.C.
>
>
> parts=# \d av_parts
> Table "av_parts"
> Attribute |Type |
On Sun, 20 Aug 2000, Franz J Fortuny wrote:
> At our company we are presently using a commercial
> database that generates results from this query:
>
> select xx1,xx2,xx3 from tableX
> where field1 in
> (select field1 from tableY where
> field2=NNN and field3=NNN2 and field4=NNN4)
>
> tableX ha
On Thu, 3 Aug 2000, Carolyn Lu Wong wrote:
> I was trying to dump data, drop then recreate table, and import data
> back to the table. There were errors during the process and the
> transaction was not committed.
>
> The table is there when I do '\d' and the table definition is there.
> However,
On Thu, 15 Jun 2000, Karel Zak wrote:
>
> On Thu, 15 Jun 2000, The Hermit Hacker wrote:
>
> > On Thu, 15 Jun 2000, Karel Zak wrote:
> >
> > >
> > >
> > > The PostgreSQL pg_dumplo 0.0.5; in brief:
> > >
> > > --- ava
On Thu, 15 Jun 2000, Karel Zak wrote:
>
>
> The PostgreSQL pg_dumplo 0.0.5; in brief:
>
> --- available at:
>
> * ftp://ftp2.zf.jcu.cz/users/zakkr/pg/pg_dumplo-0.0.5.tar.gz
>
> * or will available in the PostgreSQL contrib tree in the CVS
What license is it under?
29 matches
Mail list logo
