On Thu, Feb 19, 2009 at 01:50:55PM -0700, Josh Tolley wrote:
(my new daughter will be 24 hours old in a little bit, though, so it
might be a while!)
Pics!
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype
(and the feature) use WITH RECURSIVE in order to get
the entire tree?
Cheers,
David (yes, I know it's predictable from me, but WITH RECURSIVE really
is a neat new toy ;)
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP
On Wed, Feb 25, 2009 at 07:30:30PM -0500, Tom Lane wrote:
David Fetter da...@fetter.org writes:
Should the patch (and the feature) use WITH RECURSIVE in order to
get the entire tree?
See the note at the top of that file that all queries are expected
to work with server versions back
have a more general usage, too. Does SQL:2008 have
anything to say about such a capability, or is it already in the
column-level privileges, or...?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter
, starting with 8.5.
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
the same thing.
+1, that sounds like a very good idea.
FWIW, +1 from me for removing the -i and -d options, leaving only long
versions of what they used to do.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype
8.1 came out.
I think it's time to bring it in from the cold. Call the new schema
pg_sysviews, plop it in there, and call it done :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet
, it would
still be too late on grounds of its size and invasiveness.
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
, no doubt, but so is use of
Gregorian counting. So I suggest the attached fix. Does this make
anyone unhappy?
Works for me :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet
at
the last commit fest, and increase it to linearly to, say, twice the
size of the largest patch proposed at the first commit fest.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet
list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
--
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
be distributed?
I agree if we had said no to those patches we could be farther
now, but I am not sure how much farther.
One way to find out is to make a list of all the things that happen
and see how to get more people, productively, on it :)
Cheers,
David.
--
David Fetter da...@fetter.org
my suggestion
yesterday.
By my count, this was the last patch left for 8.4. No?
One more patch left according to the Commitfest wiki: B-Tree emulation
for GIN.
http://wiki.postgresql.org/wiki/CommitFestInProgress
Cheers,
David whisperbeta/
--
David Fetter da...@fetter.org http://fetter.org
into a table containing OIDs.
The idea that fetch/move should _intentionally_ not set ROW_COUNT is
beyond ludicrous.
It's a flat-out bug not to have FETCH/MOVE set this.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype
for
windowing, or...?
Any ideas?
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
On Mon, Mar 30, 2009 at 01:31:23PM -0400, Tom Lane wrote:
David Fetter da...@fetter.org writes:
SELECT
i,
t,
RANK() OVER (
PARTITION BY i
ORDER BY random()
)
FROM foo;
ERROR: ORDER/GROUP BY expression not found in targetlist
Fixed.
Thanks
only
\dtS lists system tables only
All of the S ones should probably mean, include system objects
rather than only system objects.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP
RETURNING results,
etc.)?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
---(end of broadcast)---
TIP 1: if posting
AUTOCOMMIT on?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
---(end of broadcast)---
TIP 2: Don't 'kill -9
On Thu, Oct 12, 2006 at 02:07:28PM -0500, Jim C. Nasby wrote:
On Thu, Oct 12, 2006 at 12:01:12PM -0700, David Fetter wrote:
On Thu, Oct 12, 2006 at 03:51:39PM +0400, Teodor Sigaev wrote:
You're running in auto-commit, mode. An implicit commit
happens after this statement. Which clears
that adding per-query hints would take less
time and be less work, even in the short term, than the current
strategy of continuously improving the planner and optimizer?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
;' is tricky at best
in 5.6.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
---(end of broadcast)---
TIP 1: if posting
for a
'Shared Disk Fail Over'. It's not replication, because there's no replica.
As you point out, there is no replica of the data, but there is some
protection against machine failure, which puts it firmly in the
Fail-over part above.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1
would be more
likely to go into the core if it were made compatible with this
standard.
Regards,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote
screen space, a [*] for enabled and [x] for disabled, or something
similar.
For this case, I think clarity is more important than saving screen
space.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype
deleting unknown files you deserve
everything you get. Especially if you are in the middle of a
PostgreSQL cluster tree.
A mention in the README in that directory wouldn't hurt, tho.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
.
Is it surmountable? Of course, that isn't the point. The point is
that it is not painless.
Nothing is painless.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote
on their own, and the wasted effort of them having to make
adjustments.
Would it really hurt to touch on some of the whys of this?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote
|DELETE) ... RETURNING.
Cheers,
D (SQL/MED, anybody?)
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
---(end of broadcast)---
TIP
are the relevant ones. In China, it's powers of 10
divisible by 4, and in India, it's 0, 1, 2, 3, followed by odd numbers
up through 19.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember
---
Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
On Fri, Sep 29, 2006 at 05:41:35PM -0400, Tom Lane wrote:
Yeah. ISTM the correct generalization is per-user per-database
default GUC settings, which has nothing to do with superuserness.
This sounds like
operation so that the
following would work?
CREATE TYPE foo AS (
a INT4,
b INT8,
c POINT,
d TEXT
);
CREATE FUNCTION bar(output_type TEXT)
RETURNS SETOF RECORD
...
SELECT * FROM bar('foo') AS foo;
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778
On Wed, Dec 27, 2006 at 06:22:17PM -0500, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
What would be involved in fixing the casting operation so that the
following would work?
CREATE TYPE foo AS (
a INT4,
b INT8,
c POINT,
d TEXT
);
CREATE FUNCTION
On Wed, Dec 27, 2006 at 06:36:56PM -0500, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
On Wed, Dec 27, 2006 at 06:22:17PM -0500, Tom Lane wrote:
The problem with that is that AS foo already has a meaning, and it's
not this one.
How about AS (foo) ?
What if you want
On Wed, Dec 27, 2006 at 06:11:55PM -0600, Andrew Dunstan wrote:
Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
On Wed, Dec 27, 2006 at 06:22:17PM -0500, Tom Lane wrote:
The problem with that is that AS foo already has a meaning, and it's
not this one.
How about AS (foo
? :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
---(end of broadcast)---
TIP 5: don't forget to increase your free space
on the MIT Kerberos for Windows service currently). Supporting
SSPI/GSSAPI and then writing a small document on how to generate
Windows keytabs for Postgres would mean single-sign-on for Windows
users using applications which use libpq...
Sounds like a nice feature :)
Cheers,
D
--
David Fetter
list cleanly
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
On Wed, Jan 03, 2007 at 12:36:27PM -0800, David Fetter wrote:
On Wed, Jan 03, 2007 at 06:30:48PM +0100, Pavel Stehule wrote:
Hello,
I am working on support scrollable cursors in plpgpsm. Scrollable cursors
are in ToDo for plpgsql too. I need new function
in.
As I recall, it was decided long ago, and the conclusions were:
* Only BSD-compatibly licensed code goes in PostgreSQL's code base,
and
* PostgreSQL will only support the SQL:2003 standard WITH (RECURSIVE)
syntax in the main line code.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http
it would be nice.
+1 on all of this :)
Cheers,
D (who can contribute code once we've agreed on what it should do)
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote
the validate of this certification for the
clients. Make difference to be certified?
Clueful clients will look unfavorably on any PostgreSQL
certification you have. They will instead insist on experience and
references, as clueful clients do. :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http
On Tue, Jan 23, 2007 at 04:41:03PM -0500, Theo Schlossnagle wrote:
On Jan 23, 2007, at 4:33 PM, David Fetter wrote:
On Tue, Jan 23, 2007 at 11:52:08AM -0200, Iannsp wrote:
Hello,
I did like to know what you think about the postgresql
certifications provided for
PostgreSQL CE http
increase overall PostgreSQL adoption. That's
a good thing.
When you're getting this together, by all means let me know so I can
trumpet it all over the PostgreSQL Weekly News :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
on this?
Greetings and Thanks...
8.2 has (INSERT/UPDATE/DELETE) ... RETURNING. Perhaps you could use
the 8.2 series instead :)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember
is a horrible misnomer. Can we maybe bite the bullet and
call it something else?
Some version of version-dependent plugins?
Cheers,
D (who hasn't come up with anything shorter just yet)
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
with the global make file stuff however so that is one dependency.
Add directory /modules
Not so great. SQL:2003 has a special meaning for the word module.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
straight-forward to remove
the thing simply by dropping the schema cascade.
Obviously the initdb switch could also be selective:
initdb --enable-extensions
If it were an initdb switch, I'd want to have something more like
--enable-extension=earthdistance
Cheers,
D
--
David Fetter [EMAIL PROTECTED
On Sun, Jan 28, 2007 at 10:10:14AM -0800, Joshua D. Drake wrote:
David Fetter wrote:
On Sat, Jan 27, 2007 at 09:49:25PM -0800, Joshua D. Drake wrote:
Tom Lane wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
So what are we thinking here? Along with my suggestion of
extensions / contrib
On Sun, Jan 28, 2007 at 04:52:27PM -0500, Andrew Dunstan wrote:
Michael Glaesemann wrote:
On Jan 28, 2007, at 11:25 , Joshua D. Drake wrote:
David Fetter wrote:
Not so great. SQL:2003 has a special meaning for the word module.
Yeah I saw mention of that in another thread, but I
not a huge one, is to modify the
postgresql.conf to have the correct default search_path.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
---(end
didn't say it was hard. I said I wasn't interested :)
I think it's necessary to get each in its own schema whether we have
an initdb flag or not.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype
(string_to_array(setting, ','))
THEN setting
ELSE setting || ',foo'
END
WHERE
name = 'search_path'
;
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember
$.02 :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
On Wed, Jan 31, 2007 at 09:31:00AM -0500, Andrew Dunstan wrote:
David Fetter wrote:
On Tue, Jan 30, 2007 at 03:49:14PM -0500, Andrew Dunstan wrote:
4. visibility/searchpath issues. I don't think long search paths
are a huge issue, but I think we can make life a bit easier by
tweaking
languages like Perl would
feel much more at home having access to all the matches. While you're
at it, could you could make pre-match and post-match (optionally--I
know it's expensive) available?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM
On Thu, Feb 01, 2007 at 10:16:54PM -0800, Jeremy Drake wrote:
On Thu, 1 Feb 2007, David Fetter wrote:
On Thu, Feb 01, 2007 at 05:11:30PM -0800, Jeremy Drake wrote:
Anyway, the particular thing I was writing was a function like
substring(str FROM pattern) which instead of returning just
, the postmatch
is an empty string.
Reasonable?
This is great :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
---(end of broadcast
. And besides, when
people really need Perl, they can pull it in as a PL :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
---(end of broadcast
in a transaction :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
---(end of broadcast)---
TIP 9: In versions below
if there are any functions currently
in core with OUT parameters.
As of 8.2 there are.
If we are going to include these I would vote for core not contrib
status, exactly to avoid having to export those functions.
+1 for core. :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone
else,
short of the moon, let me know.
Integrated, native XML support can only help PostgreSQL. IMO, I want
this in core.
+1 :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
been started as a replication hooks project,
although I'm unsure of its current status.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
---(end
for table partitioning?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
---(end of broadcast)---
TIP 1: if posting
wouldn't be the only possible uses
of such machinery. A data-changing function in a subquery could be
another. Maybe there could be some way to mark functions as execute
once per subquery.
/
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
WITH without RECURSIVE? That would be very
handy all by itself.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org
?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate
---(end of broadcast
a polymorphic
function like
pg_catalog.array_for(typepoid OID)
pg_catalog.array_for(typename NAME)
pg_catalog.array_for(typenamespace NAME, typename NAME)
I don't see a good reason to allow putting array types in a different
schema from their base types.
Cheers,
D
--
David Fetter [EMAIL PROTECTED
persistence
mechanism which is distinct from GUC, so we don't have to keep
reinventing the wheel (YAML anyone?).
YAML could work, but JSON http://www.json.org/ is a lot less
sensitive to what should be trivial matters of whitespace.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org
PROTECTED] so that your
message can get through to the mailing list cleanly
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
Consider donating to PostgreSQL: http
On Fri, Mar 02, 2007 at 06:59:50PM -0500, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
1. In src/backend/commands/tablecmds.c, change DefineRelation as
follows:
* After the first call to heap_create_with_catalog, construct and
do another call to for the array type
On Tue, Mar 06, 2007 at 04:14:07PM -0500, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
I noticed something in src/backend/commands/tablecmds.c which
worries me, namely that it ignores functions and views.
What?
The it in question is, find_composite_type_dependencies()
Cheers,
D
On Tue, Mar 06, 2007 at 04:24:36PM -0500, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
On Tue, Mar 06, 2007 at 04:14:07PM -0500, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
I noticed something in src/backend/commands/tablecmds.c which
worries me, namely
;-)
For the record, I'm in the ag'in column.
* Another good example is the questionnaire.
With all due respect, this is a solved problem *without EAV or
run-time DDL*. The URL below has one excellent approach to this.
http://www.varlena.com/GeneralBits/110.php
Cheers,
D
--
David Fetter
On Tue, Mar 13, 2007 at 02:21:37PM +, Richard Huxton wrote:
David Fetter wrote:
On Tue, Mar 13, 2007 at 09:31:45AM +, Richard Huxton wrote:
* Another good example is the questionnaire.
With all due respect, this is a solved problem *without EAV or
run-time DDL*. The URL below has
On Tue, Mar 13, 2007 at 05:54:34PM +, Richard Huxton wrote:
David Fetter wrote:
On Tue, Mar 13, 2007 at 02:21:37PM +, Richard Huxton wrote:
David Fetter wrote:
On Tue, Mar 13, 2007 at 09:31:45AM +, Richard Huxton wrote:
* Another good example is the questionnaire.
With all due
On Wed, Mar 14, 2007 at 12:07:45PM +1300, Edward Stanley wrote:
On Wed, 14 Mar 2007, David Fetter wrote:
On Tue, Mar 13, 2007 at 05:54:34PM +, Richard Huxton wrote:
David Fetter wrote:
On Tue, Mar 13, 2007 at 02:21:37PM +, Richard Huxton wrote:
David Fetter wrote:
On Tue
On Wed, Mar 14, 2007 at 02:28:03PM +, Gregory Stark wrote:
David Fetter [EMAIL PROTECTED] writes:
CREATE TABLE symptom (
symptom_id SERIAL PRIMARY KEY, /* See above. */
...
);
CREATE TABLE patient_presents_with (
patient_id INTEGER NOT NULL REFERENCES patient
to for the array type.
* Add an appropriate pg_depend entry.
2. Change RemoveRelation to reflect the above.
3. Change TypeRename appropriately, whatever that turns out to be.
Does the above make sense? Have I missed anything critical?
Cheers,
D
--
David Fetter [EMAIL PROTECTED
-licensed widget that requires javascript for this.
http://kryogenix.org/code/browser/sorttable/
Cheers,
D (Let's hear it for not reinventing the wheel!)
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
when Disney is lobbying them.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate
On Sun, Mar 25, 2007 at 10:18:14PM -0400, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
I've written up a patch intended to implement this on the
non-pg_catalog tables and VIEWs, but while it builds, it doesn't
initdb. Enclosed are the patch and the error log.
Any hints
,
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-hackers mailing list
On Sun, Apr 05, 2009 at 12:21:41PM -0400, Tom Lane wrote:
I will leave that item on the Open Items list. I take it no one's
excited about the others?
When the windowing functions become a pain point, let's revisit :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone
On Sun, Apr 05, 2009 at 02:07:32PM -0400, Tom Lane wrote:
David Fetter da...@fetter.org writes:
On Sun, Apr 05, 2009 at 12:21:41PM -0400, Tom Lane wrote:
I will leave that item on the Open Items list. I take it no one's
excited about the others?
When the windowing functions become
On Sun, Apr 05, 2009 at 08:55:07PM -0400, Tom Lane wrote:
David Fetter da...@fetter.org writes:
On Sun, Apr 05, 2009 at 02:07:32PM -0400, Tom Lane wrote:
The \df thing? That's something it'd be okay to revisit during
beta, IMHO.
OK, I'll work on this tomorrow :)
I think what we were
On Sun, Apr 05, 2009 at 05:57:46PM -0700, David Fetter wrote:
On Sun, Apr 05, 2009 at 08:55:07PM -0400, Tom Lane wrote:
David Fetter da...@fetter.org writes:
On Sun, Apr 05, 2009 at 02:07:32PM -0400, Tom Lane wrote:
The \df thing? That's something it'd be okay to revisit during
beta
it in the queue for 8.5,
go right ahead.
There's really no point, and a lot of good stuff lost, in leaving this
thing out. It's not like the few kilobytes it takes up could possibly
matter in the grand scheme of things.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778
On Mon, Apr 06, 2009 at 10:51:22PM -0700, David Fetter wrote:
On Sun, Apr 05, 2009 at 05:57:46PM -0700, David Fetter wrote:
On Sun, Apr 05, 2009 at 08:55:07PM -0400, Tom Lane wrote:
David Fetter da...@fetter.org writes:
On Sun, Apr 05, 2009 at 02:07:32PM -0400, Tom Lane wrote
be changed
Also, Fetter is currently working on a \dw for 8.5.
I sent it, targeted for 8.4 :) Windowing functions are new in 8.4, so
I'm thinking it should go into the front-end tools, too.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666
On Tue, Apr 07, 2009 at 07:28:25PM -0700, David Fetter wrote:
On Mon, Apr 06, 2009 at 10:51:22PM -0700, David Fetter wrote:
On Sun, Apr 05, 2009 at 05:57:46PM -0700, David Fetter wrote:
On Sun, Apr 05, 2009 at 08:55:07PM -0400, Tom Lane wrote:
David Fetter da...@fetter.org writes
On Fri, Apr 10, 2009 at 11:30:30AM -0400, Tom Lane wrote:
David Fetter da...@fetter.org writes:
Revised patch attached. \dw does not need an 'S' decorator,
Yes it does. We have only painfully gotten to the point of having
consistent behavior across all the \d commands. We are not going
open source
GIS database, I expect that a *lot* of people want this.
Surely we'd have seen more complaints, then.
You're setting a pretty high bar here for a pretty small change which
will cause a pretty large increase in convenience. What is the actual
problem here?
Cheers,
David.
--
David
:)
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-hackers
from
user perspective, that also understands where your opinion comes
from.
The amount of code I've gotten into the back end is absolutely
minuscule. It's psql where I can currently help people see a new
feature.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235
On Sat, Apr 11, 2009 at 08:52:31AM -0400, Robert Haas wrote:
On Sat, Apr 11, 2009 at 5:06 AM, Grzegorz Jaskiewicz
g...@pointblue.com.pl wrote:
On 11 Apr 2009, at 08:01, Hitoshi Harada wrote:
2009/4/11 David Fetter da...@fetter.org:
On Sat, Apr 11, 2009 at 03:48:33PM +0900, Hitoshi Harada
On Sat, Apr 11, 2009 at 10:32:14AM -0400, Tom Lane wrote:
David Fetter da...@fetter.org writes:
On Sat, Apr 11, 2009 at 08:52:31AM -0400, Robert Haas wrote:
We're up to at least four different categories of functions that
people think might require special treatment: window, trigger,
I/O
-critical and automated that depends on \da, although we could
have it rewritten as an alias for convenience.
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
On Sat, Apr 11, 2009 at 03:34:31PM -0400, Bruce Momjian wrote:
David Fetter wrote:
On Sat, Apr 11, 2009 at 03:12:39PM -0400, Tom Lane wrote:
Josh Berkus j...@agliodbs.com writes:
Tom, It fits into 80 columns if you don't have any functions with
11 parameters. ;-)
Well, yeah
--- is there consensus for that?
I'd throw 'em in.
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
901 - 1000 of 2065 matches
Mail list logo
