"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> contrib/ltree includes text2ltree and ltree2text functions, but no
> implicit casts. Is there any particular reason for this?
Implicit casts to or from text are evil.
regards, tom lane
---(end of broadca
Neil Conway <[EMAIL PROTECTED]> writes:
> Someone at Fujitsu pointed out the following bug in 8.0:
> begin;
> savepoint x;
> create table abc (a int);
> insert into abc values (5);
> declare foo cursor for select * from abc;
> rollback to x;
> fetch from foo; -- hits an Assert()
Offhand I'd say th
On Mon, 24 Jan 2005 08:28:09 -0700, "Jonah H. Harris" <[EMAIL PROTECTED]>
wrote:
>UPDATE pg_user_table_counts
>SET rowcount = rowcount + 1
>WHERE schemaname = this_schemaname
>AND tablename = TG_RELNAME;
This might work for small sing
contrib/ltree includes text2ltree and ltree2text functions, but no
implicit casts. Is there any particular reason for this?
--- ltree.sql.in.orig Mon Jan 24 22:47:01 2005
+++ ltree.sql.inMon Jan 24 22:58:40 2005
@@ -155,10 +155,14 @@
AS 'MODULE_PATHNAME'
LANGUAGE 'C' WITH (isstrict,isc
On Tue, 25 Jan 2005 Neil Conway wrote :
> Amazingly, there *are* lock-free hash table
> algorithms (e.g. [1]), but at first glance they seem pretty complex, and
It is a little scary when I read the lock-free hash table algorithm
needs a theorem prover to prove its correctness. I'd guess maintainin
On Mon, Jan 24, 2005 at 10:43:40PM -0500, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > Speaking of other tricks and things missing; I'd like to see support for
> > named locks.
>
> [ yawn... ] Create a table with a "name" column, put some rows in it,
> lock the rows.
What wou
Someone at Fujitsu pointed out the following bug in 8.0:
begin;
savepoint x;
create table abc (a int);
insert into abc values (5);
declare foo cursor for select * from abc;
rollback to x;
fetch from foo; -- hits an Assert()
commit;
The stacktrace is:
#2 0x0826367b in ExceptionalCondition (condi
On Mon, Jan 24, 2005 at 08:40:30PM -0600, Jim C. Nasby wrote:
> On Mon, Jan 24, 2005 at 08:12:49AM -0800, David Fetter wrote:
> > On Sun, Jan 23, 2005 at 03:49:22PM -0600, Jim C. Nasby wrote:
> > > Sorry if this is old, but I couldn't find it in the archives...
> > >
> > > How difficult would it b
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> Speaking of other tricks and things missing; I'd like to see support for
> named locks.
[ yawn... ] Create a table with a "name" column, put some rows in it,
lock the rows.
regards, tom lane
---(end of
On Mon, 2005-01-24 at 19:36 -0600, Min Xu (Hsu) wrote:
> In any case, I think only when contention is high the non-blocking
> algorithms are worth looking at. So can someone shine some light
> on where the contention might be?
The major point of contention that has been identified in the past is
o
Speaking of other tricks and things missing; I'd like to see support for
named locks. If you're using locks for something other than row-level
locking, it's awkward at best to have to come up with an OID to identify
your lock with, and even that doesn't guarantee uniqueness. You're also
out of luck
On Mon, Jan 24, 2005 at 08:12:49AM -0800, David Fetter wrote:
> On Sun, Jan 23, 2005 at 03:49:22PM -0600, Jim C. Nasby wrote:
> > Sorry if this is old, but I couldn't find it in the archives...
> >
> > How difficult would it be to provide a means to define a trigger in
> > one statement? Something
Neil and others,
It might be interesting to look at some of the papers by Michael
Scott et al. I am not an expert on non-blocking data structures,
but the following page seems interesting:
http://www.cs.rochester.edu/u/scott/synchronization/
esp. "(7) nonblocking "dual" data structures, which co
On Mon, 2005-01-24 at 16:50 -0700, Jonah H. Harris wrote:
> Here is some pretty good info on lock-free structures... I'm pretty sure
> I tested their code in a multithreaded high-concurrency environment and
> experienced the problems I was discussing.
Fair enough, but my hope would be that those
Darcy Buskermolen <[EMAIL PROTECTED]> writes:
> If we are going to roll a 7.4.7 any chance we can roll the icc compiler fixes
> -WI (if I recall right) into there as well?
You're going to need to be a lot more specific than that if you want
something applied to 7.4.7. A patch against REL7_4_STABL
On January 24, 2005 09:58 am, Tom Lane wrote:
> Devrim GUNDUZ <[EMAIL PROTECTED]> writes:
> > Is it time for 7.4.7? I've seen many commits to 7.4 branch nowadays.
>
> I just started a discussion about that on the core list ...
If we are going to roll a 7.4.7 any chance we can roll the icc compiler
Neil,
Here is some pretty good info on lock-free structures... I'm pretty sure
I tested their code in a multithreaded high-concurrency environment and
experienced the problems I was discussing.
http://www.cl.cam.ac.uk/Research/SRG/netos/lock-free/
Neil Conway wrote:
On Mon, 2005-01-24 at 08:35 -
On Mon, 2005-01-24 at 08:35 -0700, Jonah H. Harris wrote:
> Lock free data structures are cool... but not really applicable to
> databases. They have a high maintenance overhead, severe complexity,
> and will fail when there are many concurrent inserts/deletes to the
> structure.
Can you elabo
On Sun, 23 Jan 2005, Benjamin Arai wrote:
What are the goals for 8.1?
Replace ARC ... anything else is a bonus ...
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
-
FYI, I am doing training for SRA in New York City today (Monday) until
Wednesday. I might be behind in reading email and responding.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive,
Jeff wrote:
> Is there a practical use for retrieving > 2^31 records at once?
>
> (this is a serious question, I'm not arguing that it should cause a
> syntax error)
>
> Regards,
> Jeff Davis
>
> On Mon, 2005-01-24 at 14:13 -0500, Merlin Moncure wrote:
> > I was browsing the TODO list and
Is there a practical use for retrieving > 2^31 records at once?
(this is a serious question, I'm not arguing that it should cause a
syntax error)
Regards,
Jeff Davis
On Mon, 2005-01-24 at 14:13 -0500, Merlin Moncure wrote:
> I was browsing the TODO list and I noticed the todo to bump lim
I was browsing the TODO list and I noticed the todo to bump limit/offset
to int8. IMO, the flavors of fetch that take a numeric parameter need
this as well.
FWIW, trying to pass integer > 2^31 to fetch gives a syntax error, which
is clearly wrong.
Merlin
---(end of broad
> > 3) Allow GRANT/REVOKE permissions to be applied to all schema
objects
> > with one
>
> Maybe this is "apply schema changes to several objects with one
> command". This seems reasonable.
Well, I don't know. IMO, what I would really like to see is for various
database objects to inherit permi
Ok,
With 8.0 out the door, I'd like to reopen discussion re: userlock
contrib. module and propose to get it moved into the core database
sources. This was discussed a bit a few months back but it never made
it officially to the todo list. I'm not sure what the final consensus
was on the shared
Greg Stark <[EMAIL PROTECTED]> writes:
> Tom Lane <[EMAIL PROTECTED]> writes:
>> The results were
>> In C locale, SQL_ASCII encoding: 820 ms
>> In C locale, UNICODE encoding: 825 ms
>> Using Dawid's functions: 62010 ms
>> Stripped-down functions: 21010 ms
Tom Lane <[EMAIL PROTECTED]> writes:
> Greg Stark <[EMAIL PROTECTED]> writes:
> >
> > So it's slow but not spectacularly awful.
>
> glibc is not the world.
Sorry, I should have said "It's not *necessarily* spectacularly awful"
> I tried Dawid's functions on Mac OS X, being a
> random non-glib
Devrim GUNDUZ <[EMAIL PROTECTED]> writes:
> Is it time for 7.4.7? I've seen many commits to 7.4 branch nowadays.
I just started a discussion about that on the core list ...
regards, tom lane
---(end of broadcast)---
TIP 7: d
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
Is it time for 7.4.7? I've seen many commits to 7.4 branch nowadays.
Regards, Devrim
On Mon, 24 Jan 2005, Tom Lane wrote:
Log Message:
---
Disallow LOAD to non-superusers. Per report from John Heasman.
Tags:
REL7_4_STABLE
Modified File
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Marc G. Fournier wrote:
>> I may be missing something here, but haven't we always stated that
>> using 'SELECT *' should be frown'd upon for the most part?
> No, we have never stated that.
We do however point out in the docs that SELECT * is vulnerab
Greg Stark <[EMAIL PROTECTED]> writes:
> On Sat, 22 Jan 2005 17:09:42 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
>> I would imagine that the performance is spectacularly awful :-(.
>> Have you benchmarked it? A large sort on a unitext column,
>> for instance, would be revealing.
> Why do you pers
Stephen Frost wrote:
> The other difference would seem to be that "user identifiers" can't
> be granted to users whereas "role identifiers" can be. Following
> this, "rolmembers" must be NULL if rolcanlogin is true, no? That
> breaks if roles can log in though. Or should we just allow granting
>
Marc G. Fournier wrote:
> I may be missing something here, but haven't we always stated that
> using 'SELECT *' should be frown'd upon for the most part?
No, we have never stated that.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)
On Sun, Jan 23, 2005 at 03:49:22PM -0600, Jim C. Nasby wrote:
> Sorry if this is old, but I couldn't find it in the archives...
>
> How difficult would it be to provide a means to define a trigger in
> one statement? Something like a combination of CREATE TRIGGER and
> CREATE FUNCTION? Being able
Here's a possible solution... though I'm not sure about whether you find
the pg_ prefix appropriate for this context.
-- Create a Test Relation
CREATE TABLE test_tbl (
test_id BIGINT NOT NULL,
test_value VARCHAR(128) NOT NULL,
PRIMARY KEY (test_id));
-- Create COUNT Collecto
Lock free data structures are cool... but not really applicable to
databases. They have a high maintenance overhead, severe complexity,
and will fail when there are many concurrent inserts/deletes to the
structure. I messed with them a year or so ago, and that's what I found
in every implemen
> On Sat, 22 Jan 2005 17:09:42 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> > > This time setlocale() was needed to get the behaviour
> > > I needed (database initdb'ed to 'C', my order set to 'pl_PL',
> > > or whatever locale I need at given moment).
> > I would imagine that the performance is sp
On Fri, 21 Jan 2005 23:52:51 +, Simon Riggs <[EMAIL PROTECTED]>
wrote:
>Currently, we have group commit functionality via GUC parameters
> commit_delay
>andcommit_siblings
And since 7.3 we have ganged WAL writes (c.f. the thread starting at
http://archives.postgresql.org/pgsql-hacker
Hi,
I read recently a paper
Keir Fraser & Tim Harris, Concurrent Programing without Locks, ACM
Journal Name, vol V, n° N, M 20YY, Page 1-48
About algorithm to manage structure (exemple about red-black tree, skip
list) with dead-lock free property, parallel read, etc.
Does this have been studied
Hello, Kris Jurka
Thank you for your reply, I will go to Npgsql development team for help.
>I have no idea what DataAdapter is, you will need to check your client
>interface for support (and this probably isn't the place to do that), but
>it's certainly possible. See for example "The world's mo
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Christopher Kings-Lynne
> Sent: 24 January 2005 09:41
> To: pgsql-hackers@postgresql.org
> Subject: [HACKERS] Hackers in London/Oxford
>
> I seem to remember that some of you guys were in London
I seem to remember that some of you guys were in London or Oxford? I'm
in London at the moment and will be in Oxford on the weekend if anyone
wants to catch up?
Chris
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hello Dennis,
Some french guy on IRC showed the site http://www.postgresql.fr/ that does
not contain anything about postgresql. I don't speak french so I can't
tell what the page is about. It looks linux related.
This doesn't really belong on the -hackers list but I don't know where to
send the inf
On Sun, 23 Jan 2005, Arnold.Zhu wrote:
> Can I use DataAdapter.Fill() with refcursor. :-(
I have no idea what DataAdapter is, you will need to check your client
interface for support (and this probably isn't the place to do that), but
it's certainly possible. See for example "The world's most
44 matches
Mail list logo
