On Sun, 8 Feb 2004, Josh Berkus wrote:
> Marc,
>
> > now if they only had PostgreSQL on the list, it would be worth rallying
> > about ...
>
> It is on the list. Look again. We're there as Postgres.
You'd think that, of all ppl. O'Reilly would know the correct spelling ...
but, then again, you
On Mon, Feb 09, 2004 at 03:13:08PM +1300, Mark Kirkwood wrote:
> FYI - Ext3 has 3 modes :
>
> data=ordered(default) : metadata is journaled (at write time data is
> written before metadata - i.e ordered)
> data=journal: data and metadata are journaled
> data=writeback: metadata journaled (no orde
On Sun, 8 Feb 2004, Manuel Tejada wrote:
>
> > Lamar Owen wrote:
> > > Since I don't necessarily keep up with what is going on in the Python
> client
> > > world, would people enlighten me as to which python client would be best
> to
> > > build RPMs for? I'm going to pull the python subpackage
FYI - Ext3 has 3 modes :
data=ordered(default) : metadata is journaled (at write time data is
written before metadata - i.e ordered)
data=journal: data and metadata are journaled
data=writeback: metadata journaled (no ordering at write time)
The default will not help to protect database integrit
As a user of PostgreSQL I totally agree with Gaetano Mendola.
There is no reason to pull the python subpackage out of the main set,
- Original Message -
From: "Gaetano Mendola" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 06, 2004 9:24 PM
Subject: Re: [GENERAL] Postg
Alex,
[N.B. I just read the second message you sent on this question, but I have a
solution that goes in a different direction.]
I ran into the same problem after designing a system based on inheritance,
and asked a similar question a couple of weeks ago -- a couple of folks here
gave very helpfu
Stephan Szabo wrote:
This still works the same way it has.
If you look through the archives, you should hopefully be able to scrounge
up some of the workaround information that's been sent in the past.
For reference, if anyone finds this thread through Google or whatever, here is the result of som
I have some light examples in
http://www.varlena.com/GeneralBits/Tidbits
based on Stephan's.
The discussion in issue
http://www.varlena.com/GeneralBits/24.html
shows the differences between setof and rows.
--elein
On Mon, Feb 02, 2004 at 09:47:11AM -0800, Joe Conway wrote:
> Tom Lane wrote:
> >
I have a general purpose reporting engine that
is good for people who are good at HTML and SQL.
It takes in an XML-ish template and spews HTML.
There is a sample php application to provide the
glue for registering and running the reports
from a browser.
The engine has a limited distribution becaus
On Fri, Feb 06, 2004 at 12:08:16PM -0500, Tom Lane wrote:
> "Andy Kriger" <[EMAIL PROTECTED]> writes:
> > I would like to select strings from a table and return them as an array
>
> You can do that beginning in 7.4 with the ARRAY(sub-select) construct.
>
> regression=# select f1 from text_tbl;
>
On Mon, 9 Feb 2004, Alex Satrapa wrote:
> Does anyone know whether I'm just doing something wrong, or is the old documentation
> still correct?
This still works the same way it has.
If you look through the archives, you should hopefully be able to scrounge
up some of the workaround information
There's some mention in the (old!) documentation that constraints such as foreign keys won't include data from inheriting tables, eg:
CREATE TABLE foo (
id SERIAL PRIMARY KEY
);
CREATE TABLE bar (
attribute integer NOT NULL
) INHERITS (foo);
CREATE TABLE bar_widgets (
bar integer
Well, I think I go to translate... and have already POEdit downloaded...
Peter Eisentraut wrote:
W. van den Akker wrote:
Is it somehow possible to extract the transaction logging?
No.
Secondly, how can I determine which user is locking a record?
Use the system table pg_locks.
On Sunday February 8 2004 12:02, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > If we write something without sync'ing, presumably it's immediately
> > journaled?
>
> I was under the impression that ext3 journals only filesystem metadata,
> not the contents of files.
Ah, didn't know how
That would depend on the client you're using. psql can do it either
directly (using \o) or by piping its output: psql -c "select * from
mytable;" mydb > out.txt
If you're using a programming library, I think you're on your own.
Adam Ruth
On Feb 8, 2004, at 10:28 AM, Russ Schneider wrote:
Is
Marc,
> now if they only had PostgreSQL on the list, it would be worth rallying
> about ...
It is on the list. Look again. We're there as Postgres.
Amusingly, the Firebird people have really learned to rally the troops for
these online polls; they're leading this one as well. Either that, o
now if they only had PostgreSQL on the list, it would be worth rallying
about ...
On Sat, 7 Feb 2004, Josh Berkus wrote:
> Folks,
>
> We've been issued a challenge ... so Vote! Vote! Vote!
>
> -
> Hey Gents,
>
> You might want to rally the troops -> http://www.oreilly.c
On Sun, 08 Feb 2004 14:02:26 -0500 Tom Lane <[EMAIL PROTECTED]> wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > If we write something without sync'ing, presumably it's immediately
> > journaled?
> I was under the impression that ext3 journals only filesystem metadata,
> not the contents of file
Lincoln Yeoh <[EMAIL PROTECTED]> writes:
> Sorry for the repost. Just wondering if anyone has a workaround for 7.4?
Brute force way is "set enable_hashagg = off"
regards, tom lane
---(end of broadcast)---
TIP 1: subscribe an
"Ed L." <[EMAIL PROTECTED]> writes:
> If we write something without sync'ing, presumably it's immediately
> journaled?
I was under the impression that ext3 journals only filesystem metadata,
not the contents of files.
> I've been running a few pgsql clusters on ext3 with fsync =
> false, suffer
Joe Conway wrote:
--without patch
regression=# SELECT * FROM connectby('connectby_bytea', 'keyid',
'parent_keyid', 'row\\134', 0, '') AS t(keyid bytea, parent_keyid bytea,
level int, branch text);
ERROR: invalid input syntax for type bytea
--with attached patch
regression=# SELECT * FROM connec
I'm curious what the consensus is, if any, on use of fsync on ext3
filesystems with postgresql 7.3.4 or later. I did some recent performance
tests demonstrating a 45%-70% performance improvement for simple inserts
with fsync off on one particular system. Does fsync = true buy me any
addition
Is there an easy way to pipe a select statement's output to a file?
--
[ Russ Schneider (a.k.a. Sugapablo) ]
[ http://www.sugapablo.com <--music ]
[ http://www.sugapablo.net <--personal ]
[ [EMAIL PROTECTED] <--jabber IM ]
---(end of broadcast)-
On Sun, Feb 08, 2004 at 12:28:21PM -0500, Russ Schneider wrote:
> Is there an easy way to pipe a select statement's output to a file?
In psql, type \? and look at what \o and \g do. They both do it but slightly
differently.
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/klept
David Garamond wrote:
Now that I enter as an escaped string, I get this error:
db1=> SELECT * FROM connectby('treeadj1b', 'id', 'parent_id',
'\\353\\024\\257\\130\\336\\305\\061\\045\\276\\175\\106\\056\\101\\173\\217\\326',
0) AS t(keyid bytea, parent_keyid bytea, level int);
ERROR: invalid in
Sorry for the repost. Just wondering if anyone has a workaround for 7.4?
At 11:25 AM 1/27/2004 -0500, Tom Lane wrote:
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> I'm afraid I'll have to defer to someone else (Tom?) as why the
estimate was
> out by three orders of magnitude.
I'd like to
On Fri, Feb 06, 2004 at 02:31:38PM -0300, Franco Bruno Borghesi wrote:
> I think you should use a cursor; you declare it, and then you fetch the
> rows as you need them.
thanks this works really nice.. just one more question .. how do i check the
number of rows in a cursor? or do i have to do a se
Can anybody confirm whether these databases support partial indexes (and
what are their term and syntax)?
SQL Server 2000: I've glanced the T-SQL Reference and it seems it
doesn't support it, though it supports indexing views. CLUSTERED index
is not the same thing, right?
Oracle: I've glanced
Joe Conway wrote:
regression=# SELECT * FROM connectby('connectby_bytea', 'keyid',
'parent_keyid', 'row\\002', 0, '') AS t(keyid bytea, parent_keyid bytea,
level int, branch text);
Oh, I was specifying the fourth argument in BYTEA (decode('hex...','hex')).
Now that I enter as an escaped string,
Title: Bericht
I've found something
in the mailing list where it said that CREATE BLOB would be implemented. This
refered to 7.1. I'm using 7.4 now and the statement still isn't valid. Did I
have to enable something during compile?
--
Regards,
Charles.
Title: Bericht
I've been asked to
send the init-script along with the dump. Where can I find
it?
--
Regards,
Charles.
31 matches
Mail list logo
