that best fits your needs
rather than being tied to one company whose support options may not.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider
the order well enough :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via
On Fri, May 08, 2009 at 06:40:33PM -0300, Emanuel Calvo Franco wrote:
2009/5/8 David Fetter da...@fetter.org:
On Fri, May 08, 2009 at 06:10:18PM -0300, Emanuel Calvo Franco wrote:
Hi all.
I'll make this faster.
I hace this table and this function:
You should only ever assume
. :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-general mailing
On Fri, May 08, 2009 at 01:02:04AM +0100, Tim Bunce wrote:
On Thu, May 07, 2009 at 06:50:11AM -0700, David Fetter wrote:
On Thu, May 07, 2009 at 02:31:08PM +0100, Tim Bunce wrote:
On Thu, May 07, 2009 at 04:54:06AM +1200, Andrej wrote:
WARNING: DBD::Pg now (as of version 1.40) uses
to the right place on this mailing
list. If you want help on other terms--say, non-disclosure
agreement--there are plenty of companies including mine,
http://www.pgexperts.com/, that will be happy to work with you.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415
, but i come
from mysql.. and in mysql that query works...
For small values of, works. ;)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider
that trick is.
Well, you can add in piles of COALESCE, but that way madness lies.
Instead, use dollar quoting, the appropriate quote_*() functions, and
this:
http://wiki.postgresql.org/wiki/PL/pgSQL_Dynamic_Triggers
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235
On Tue, Apr 21, 2009 at 08:15:00PM +0100, Peter Childs wrote:
Hmm Interestingly OSM have just switched from MySQL to PostgreSQL.
Can we get somebody from OSM to talk about this on the record?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM
you find all the people who have a common prefix? Answer: Normalize.
If you need that answer quickly, you're looking at down time and DDL
changes. The questions you ask about the data are impossible to know
in advance, so normalized data helps you deal with that.
Cheers,
David.
--
David Fetter da
)
);
CREATE TABLE person (
name varchar,
PRIMARY KEY(name)
)
CREATE TABLE person_phone (
name VARCHAR NOT NULL REFERENCES person(name),
cod VARCHAR,
num VARCHAR,
FOREIGN KEY(cod, num) REFERENCES phone(cod, num),
PRIMARY KEY(name, cod, num)
);
Cheers,
David.
--
David Fetter
the now-fixed 7.4.25 database
* Load that into 8.3.7, and, most importantly,
* Build in and enforce upgrades as part of your maintenance cycle.
You never want to have to do *anything* like this again.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM
,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-general mailing list
space that will anoy
me later on?
Are there any other clever solutions of this problem?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
David Fetter da...@fetter.org http
of snapshot cloning, I can see, at least in broad brush
strokes, how this would work for read queries, but I'm curious how (or
if) it could work for writes like, for example, updates of many
partitions at once. Could it?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP
,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-general mailing list
. :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-general mailing
as
illustrated below:
http://xkcd.com/327/
Instead, use pg_prepare() and pg_execute() for this kind of thing.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember
-
ERROR: syntax error at or near RETURN
Line: 2
Thanks
Sharmila
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
David Fetter da...@fetter.org http
On Thu, Feb 19, 2009 at 11:43:19PM +, Sam Mason wrote:
I was just reading over a reply from David Fetter from a couple of
days ago; the thread is archived[1] but this question doesn't really
relate to it much. The a question about how to arrange tables and
David make the following
check or maybe '-infinity' would
be better.
Either require a created_date and make the default
sane--CURRENT_TIMESTAMP, e.g.--or don't require one, but making a
nonsense date is Bad(TM).
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666
: COPY delimiter must be a single character
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org
On Tue, Feb 03, 2009 at 05:48:51PM +, Greg Stark wrote:
On Thu, Jan 29, 2009 at 5:43 PM, David Fetter da...@fetter.org wrote:
* CTEs not yet integrated into the adjacency lists in pg_catalog,
etc.
I'm not sure what you're referring to here either.
The DAG structures
. That should scrub
everything :)
Cheers,
David.
Thanks folks --
-- Eric Brown / Director of IT / www.mediweightlossclinics.com
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember
(or any other replication
system) to start with.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about
On Thu, Jan 29, 2009 at 05:18:17PM +, Dave Page wrote:
On Thu, Jan 29, 2009 at 4:57 PM, David Fetter da...@fetter.org wrote:
* Neither of them let you set up Slony (or any other replication
system) to start with.
^
pgAdmin does (well, barring installation
On Thu, Jan 29, 2009 at 05:18:19PM +, Gregory Stark wrote:
David Fetter da...@fetter.org writes:
* No built-in ways to get the information psql gets. See what
psql is doing isn't an option when somebody doesn't have psql on
hand.
Uhm, what information are you referring to here
.
I don't have too much else to add to what was already said, except
to reinforce the advice to test your applications before you do the
live migration. You're almost certain to hit some compatibility
issues.
+1
+1 from here, too.
Cheers,
David.
--
David Fetter da...@fetter.org http
On Wed, Jan 21, 2009 at 05:18:57AM +0100, Együd Csaba wrote:
From: David Fetter [mailto:da...@fetter.org]
On Tue, Jan 20, 2009 at 03:03:33PM +0100, Csaba Együd wrote:
Hi,
I'd like to ask your suggestions about a reliable admin software
which is able to compare two dabases and generate
should definitely do that and store the scripts to do it in
your source code management system along with all the rest of the
deploy and upgrade scripts. They can't be generated automatically
either.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM
On Tue, Jan 20, 2009 at 09:51:25PM -0500, Robert Treat wrote:
On Tuesday 20 January 2009 10:44:06 David Fetter wrote:
On Tue, Jan 20, 2009 at 03:03:33PM +0100, Csaba Együd wrote:
Hi,
I'd like to ask your suggestions about a reliable admin software
which is able to compare two dabases
by typ order by ts desc)
WHERE
typ 4;
ERROR: syntax error at or near WHERE
LINE 8: WHERE
^
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember
On Fri, Jan 16, 2009 at 12:23:16PM -0500, Jaime Casanova wrote:
On Fri, Jan 16, 2009 at 12:07 PM, David Fetter da...@fetter.org wrote:
Now i want only 3 records for every typ:
test=# select typ, ts, rank() over (partition by typ order by ts desc )
from foo where rank = 3;
ERROR
On Fri, Jan 16, 2009 at 12:34:34PM -0500, Tom Lane wrote:
David Fetter da...@fetter.org writes:
I tried this:
SELECT
typ,
ts,
rank() over w AS foo_rank
FROM
foo
WINDOW w AS (partition by typ order by ts desc)
WHERE
foo_rank 4;
ERROR: syntax
On Fri, Jan 16, 2009 at 12:41:59PM -0500, Tom Lane wrote:
David Fetter da...@fetter.org writes:
We don't appear to be able to use the actual thing in the target list
either.
Would you translate that into English? Or at least an example without
trivial syntax errors?
This works:
SELECT
,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-general mailing list
-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet
On Fri, Dec 26, 2008 at 08:03:30PM +0100, Ivan Sergio Borgonovo wrote:
On Fri, 26 Dec 2008 10:43:25 -0800
David Fetter da...@fetter.org wrote:
On Fri, Dec 26, 2008 at 03:34:33PM +0100, Ivan Sergio Borgonovo
wrote:
I noticed that starting from 8.2 the documentation at
http
On Fri, Dec 26, 2008 at 07:13:48PM -0500, Tom Lane wrote:
Ivan Sergio Borgonovo m...@webthatworks.it writes:
David Fetter da...@fetter.org wrote:
In 8.4, you'll be able to do:
WITH d AS (
SELECT DISTINCT c1, c2 FROM table1
)
SELECT count(*) FROM d;
Nice, but what
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres
implausibly, I might add, to have Oracle (8i, even!) blowing
PostgreSQL's doors off for weeks now.
Put up, or shut up.
Regards,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
, and dynamic
querying will only lead you further down this rat-hole.
The answer to, how do I shoot myself in the foot? is Don't.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet
right.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-general
will go away :)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql
SQL support for this using OLAP a.k.a.
windowing functions, so don't build too many of these dodgy hacks into
your application.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL
suggestions, feedbacks, clarfications @ [EMAIL PROTECTED]
Note: This is to propagate the open source which can help for postgres
users.
This is not a spam, or advertisement.
Regards
SathiyaMoorthy
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666
:)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-general mailing list
by looking at the diff.
No. Really, no. You need to create the upgrade script by creating
upgrade scripts, not by reverse engineering.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL
doing this in the first place? Autovacuum works just
great for modern PostgreSQL versions, and if you're not using one of
those, you should be planning your migration, not propping up the old
one :)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM
it, as in:
INSERT INTO clients (name, status)
VALUES
('Donda', 'inserted_no_directory'),
('Eonda', 'inserted_no_directory'),
('Fonda', 'inserted_no_directory'),
...
Once you're done loading, sweep through the ones so marked.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http
function which takes some of the predicate, limit, and
offset info to build a dynamic sql query against the remote database
using dblink.
That's one way. For others, I can help out on a consulting basis :)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235
actually tested that solution with many massive
questionnaires for its query performance.
I pretty much have my answer. Thanks for your input guys.
Happy to help :)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter
application and DB can be placed on diferent hosts.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
there :)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-general
. But there *are* some very real and legitimate needs for this,
though it's a small minority of those who think they do.
Please elucidate those needs in detail, then explain why it might be
PostgreSQL's job to meet them.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1
-impossible problems like the halting problem.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org
they do that's not one of your scripts will break it. Explicitly
disclaim any responsibility for such meddling. :)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember
://wiki.postgresql.org/wiki/CTEReadme
The lack of windowing functions is a bit frustrating as I'm
otherwise a big Postgres fan!
Those will both be fixed, at least to a large degree, in 8.4 :)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM
On Mon, Sep 01, 2008 at 04:39:09PM +0200, Thomas Kellerer wrote:
David Fetter, 01.09.2008 16:08:
because we are making extensive usage of Oracle's windowing
functions
http://umitanuki.net/pgsql/wfv04/design.html
I knew there was work going on regarding this, but I didn't know how
definite
.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-general mailing list (pgsql-general
is a huge entity they can blame when everything
goes wrong. They're not interested in the actual response times or
even in the much more important time-to-fix because once they've
blamed Oracle, they know the responsibility is no longer on their
shoulders.
Cheers,
David.
--
David Fetter [EMAIL
into 8.4,
so don't put too, too much effort into this. :)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http
the main table contain 600-800K records.
the
explain delete p;
doesn't give any clue.
Any hint to track down the problem?
BEGIN;
EXPLAIN ANALYZE DELETE ...
ROLLBACK;
Lack of indexes on the referencing tables might be an issue, as might
any triggers.
Cheers,
David.
--
David Fetter [EMAIL
, of the major version, in this case
8.3, that the bug appears in.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http
restart from 1 every year.
Here's a backward-compatible way to do this:
http://www.varlena.com/GeneralBits/130.php
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember
.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-general mailing list (pgsql-general
to
rewrite large parts of Postgres's code which checks referential
integrity, and there would still be things that deliberately wrong
DDL, triggers, rules, etc. could do.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype
there.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-general mailing
could be in SQL, with one minor bit in PL/PgSQL. File
attached.
I couldn't find a generally accepted way to do this, although I'm sure
someone must have done something like this before.
There's stuff in the aforementioned lock.c, but I don't see anything
visible to SQL.
Cheers,
David.
--
David
is pointless because the newly added field is nothing but NULLs.
This is version 8.1.mumble.
Have you tried making the FK constraint INITIALLY DEFERRED?
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter
On Tue, May 13, 2008 at 10:47:40AM -0400, Alvaro Herrera wrote:
Tom Lane escribió:
Alvaro Herrera [EMAIL PROTECTED] writes:
David Fetter escribi?:
Thanks for the heads-up :)
Second patch attached, this time with some docs.
Added to July commitfest.
Surely this is merely
On Tue, May 13, 2008 at 08:14:51AM -0700, David Fetter wrote:
On Tue, May 13, 2008 at 10:47:40AM -0400, Alvaro Herrera wrote:
Tom Lane escribió:
Alvaro Herrera [EMAIL PROTECTED] writes:
David Fetter escribi?:
Thanks for the heads-up :)
Second patch attached, this time
On Tue, May 13, 2008 at 11:36:57AM -0400, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
Surely this is merely proof of concept and not a complete patch.
Next patch attached :)
Uh, my point was that the agreement was to do this to *all* of
psql's toggling backslash commands
On Tue, May 13, 2008 at 01:53:33PM -0700, David Fetter wrote:
On Tue, May 13, 2008 at 11:36:57AM -0400, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
Surely this is merely proof of concept and not a complete patch.
Next patch attached :)
Uh, my point
.
The command without an argument should certainly keep the old toggle
behavior, for backwards compatibility.
Attached patch does some of the right thing, but doesn't yet handle
error cases. How liberal should we be about capitalization, spelling,
etc.?
Cheers,
David.
--
David Fetter [EMAIL
On Mon, May 12, 2008 at 05:30:48PM -0400, Bruce Momjian wrote:
David Fetter wrote:
On Sun, May 11, 2008 at 11:48:29PM -0400, Tom Lane wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
Is it reasonable behavior to have \timing along toggle and \timing on
/ \timing off be a forced switch
and Datatypes.
That technical debt is a risk to your whole project, and you need to
dedicate resources to paying it down.
http://en.wikipedia.org/wiki/Technical_debt
There are ways to get those automated casts, but they will only make
your situation worse in the long run.
Cheers,
David.
--
David
On Mon, May 05, 2008 at 05:26:40PM +0200, Daniel Schuchardt wrote:
David Fetter schrieb:
That technical debt is a risk to your whole project, and you need
to dedicate resources to paying it down.
http://en.wikipedia.org/wiki/Technical_debt
There are ways to get those automated casts
of developer related links here, and info to use the
/contrib pgcrypto, but I'm not a PG developer and I failed to find any
info on HOW TO USE that library function...
Thanks all,
Ralph Smith
[EMAIL PROTECTED]
=
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1
it automatically.
4) How do you perform VACUUM?
-
a) vacuumdb - shell command
b) VACUUM - SQL command
c) autovacuum
c)
d) What is vacuum?
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
);
$$;
SELECT array_undup(array_cat(ARRAY[1,2], ARRAY[2,3]));
array_undup
-
{1,2,3}
(1 row)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote
On Sat, Mar 08, 2008 at 10:49:02AM -0800, Colin Fox wrote:
David Fetter wrote:
On Fri, Mar 07, 2008 at 01:22:49PM -0800, Colin Fox wrote:
I've created a pg_foundry project for this.
Assuming the project gets approved, I'll post the link here.
Wouldn't it be better just
pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL
a postgres database.
If anyone's interested, I can make this available. It works quite
well. It uses a postgres-to-xml extractor that someone wrote (I
don't know who - their name is not in the file) and then I convert
the xml to graphviz.
Sounds good :)
Cheers,
David.
--
David Fetter [EMAIL
-table.html)
However, Postgres doesn't support the comment keyword.
Actually, it does :)
Is there an alternative?
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED
to increase your free space map settings
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
rows? Is that possible?
One hack I've used in the past to get those is serializing the rows:
XML, YAML and most recently JSON.
It would be really neat if you didn't have to specify the return
type in the query that invoked the crosstab.
It would be handy :)
Cheers,
David.
--
David Fetter [EMAIL
On Mon, Feb 18, 2008 at 05:45:05PM +0530, Kakoli Sen wrote:
Hi,
I install PostgreSQL 7.3.21 successfully with sudo and could start
the postmaster as sudo.
The 7.3 series is no longer supported. Use 8.3 instead.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1
on a land mine and hoping it won't go off.
Imho, don't use it with a complex database structure; as a minimum,
use lookup tables for Value (to avoid uncontrolled new parameters)
and add a column to store the attribute type.
Putting lipstick on the EAV pig does not help.
Cheers,
David.
--
David
.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
---(end
its uses cases.
Why, yes. I encourage all my competitors to use it. ;)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres
.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
---(end of broadcast
as good (or rather, no more broken) for
PostgreSQL with a minimum of effort.
In that case, use one of the existing solutions. They're all way
easier than re-inventing the wheel.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo
On Mon, Jan 14, 2008 at 11:42:50AM -0500, Josh Harrison wrote:
Thanks
On Jan 12, 2008 9:19 AM, David Fetter [EMAIL PROTECTED] wrote:
On Fri, Jan 11, 2008 at 01:02:01PM -0500, Josh Harrison wrote:
Hi
We have an Oracle production database with some terbytes of data. We
wanted
,
foo_2_id,
foo_3_id,
foo_4_id,
foo_5_id
) AS id
FROM
refs_all_foo;
You can then make this VIEW writeable by the usual methods.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter
and
then standardize on 8.3 as a minimum version.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
---(end of broadcast
.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
---(end of broadcast
201 - 300 of 558 matches
Mail list logo
