query.sgml ?
TIA :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415 235 3778
Power over a man's subsistence is power over his will.
Alexander Hamilton
---(e
On Wed, Jan 07, 2004 at 09:13:47PM -0500, Bruce Momjian wrote:
> David Fetter wrote:
> > Kind people,
> >
> > I was looking over the Tutorial section, and noticed that Foreign
> > Keys is in the "Advanced" section. I believe this is a mistake,
> > and w
gives the (IME
always wrong) impression that they're optional.
Chris Browne, could you give me a pointer to your patch so we don't
step on each other's feet?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415 235 3778
--
On Thu, Jan 08, 2004 at 06:07:13PM +0100, Peter Eisentraut wrote:
> David Fetter wrote:
> > Expanding on that, putting FK's in "Advanced Features" gives the
> > (IME always wrong) impression that they're optional.
>
> They *are* optional.
I disagree.
Christopher Browne <[EMAIL PROTECTED]> wrote:
> Oops! [EMAIL PROTECTED] (David Fetter) was seen spray-painting on a wall:
>> On Thu, Jan 08, 2004 at 06:07:13PM +0100, Peter Eisentraut wrote:
>>> David Fetter wrote:
>>> > Expanding on that, putting FK's in
What *is* broken is table inheritance, and the docs need to reflect
this.
If the parent table has a foreign key to another table foo, CASCADEing
DELETEs on foo leave ghost entries in the tables with inheritance.
Please find enclosed a repro, which demonstrates the problem on CVS
tip and 7.4.3.
Jus
On Fri, Jul 23, 2004 at 03:31:47PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > What *is* broken is table inheritance, and the docs need to reflect
> > this.
>
> The combination of inheritance with certain other features is broken,
> yes, and
torial?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.or
On Fri, Jul 23, 2004 at 04:30:40PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > I don't consider the concept broken. The implementation is, in
> > fact, broken, and putting that broken piece in the tutorial is,
> > imnsho, a bad mistake.
&g
On Fri, Jul 23, 2004 at 04:58:55PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > On Fri, Jul 23, 2004 at 04:30:40PM -0400, Tom Lane wrote:
> >> If we're going to remove from the tutorial every feature for
> >> which any aspect is deemed
function index would be quite unreliable ("It's not in the
> function index, so it's not supported."). Feel free to add general
> index entries for all functions, though.
Where?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mob
On Mon, Aug 09, 2004 at 05:34:56PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > On Mon, Aug 09, 2004 at 11:20:33PM +0200, Peter Eisentraut wrote:
> >> A function index would be quite unreliable ("It's not in the
> >> function ind
Folks,
Here's a little addition to the array functions & operators section of
the manual. It adds a function array() to the list.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
Index: doc/src/sgml/
On Sun, Oct 31, 2004 at 10:40:47PM -0500, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > Here's a little addition to the array functions & operators section of
> > the manual. It adds a function array() to the list.
>
> The ARRAY() constr
On Mon, Nov 01, 2004 at 08:47:05PM +0100, Peter Eisentraut wrote:
> David Fetter wrote:
> > Please find attached a different diff :)
>
> If you want to write a note, use the element.
Thanks for the tip :)
Fixed, attaching a diff against CVS HEAD.
Cheers,
D
--
David Fetter [
On Mon, Nov 01, 2004 at 01:59:13PM -0600, Jim C. Nasby wrote:
> On Sun, Oct 31, 2004 at 04:36:14PM -0800, David Fetter wrote:
> > Folks,
> >
> > Here's a little addition to the array functions & operators
> > section of the manual. It adds a function arr
ks in some
obvious place.
I am volunteering to do said list & linking :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 5:
Folks,
Please find enclosed a patch that shows how to get a quick
approximation of count(*) on a table.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
Index: doc/src/sgml/func.sgml
On Thu, Mar 24, 2005 at 12:34:51PM -0500, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > Please find enclosed a patch that shows how to get a quick
> > approximation of count(*) on a table.
>
> I'm not sure we should be encouraging people to look
zone via a USING clause:
ALTER TABLE foo
ALTER COLUMN foo_timestamp TYPE timestamp with time zone
USING
timestamp with time zone 'epoch' + foo_timestamp * interval '1 second';
"
That is at least something, although I agree that more examples of the
exact kind of
Folks,
Please find a patch per IRC chat yesterday that clarifies how much
space a NUMERIC takes.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
Index: doc/src/sgml/datatype.sgml
Folks,
Please find enclosed a patch which adds cross-references to the CREATE
FUNCTION syntax in the PL/* docs.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
Index: doc/src/sgml/plperl.sgml
Folks,
Please find enclosed document patches for PL/Perl features recently
introduced in CVS TIP. These include:
return_next
returning PostgreSQL arrays
spi_query/spi_fetchrow
use strict
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235
On Tue, Jul 12, 2005 at 12:21:29PM -0700, David Fetter wrote:
> Folks,
>
> Please find enclosed document patches for PL/Perl features recently
> introduced in CVS TIP. These include:
>
> return_next
> returning PostgreSQL arrays
> spi_query/spi_fetchrow
> use st
a sets, you should be aware that these will all go
> into memory.
That's no longer true. Please find enclosed a new patch :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
In
On Sat, Jul 30, 2005 at 09:47:58AM -0400, Andrew Dunstan wrote:
>
>
> David Fetter wrote:
>
> You have rolled 2 problems into one - spi_query+spi_fetchrow does not
> address the issue of returning large data sets.
>
> Suggest instead:
[suggestion]
Revised pat
Folks,
I think this needs to be made explicit in the documentation. Better,
of course, would be some kind of change to the PL infrastructure that
Just Handles It, but until then
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Folks,
Please find attached a patch which tells about what the spiffy,
integrated autovacuum now does :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
? autovacuum.diff
? d0m41n_fux0r3d.diff
Index: doc/src/sgml
Folks,
Please find enclosed a patch (should work for 7.3 and up) that
illustrates a workaround for using COPY on parts of tables using
temporary tables. It's helped me, and it seems popular via a very
brief and un-scientific poll.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fette
, Oct 11, 2005 at 04:02:17PM -0700, David Fetter wrote:
> > Folks,
> >
> > Please find enclosed a patch (should work for 7.3 and up) that
> > illustrates a workaround for using COPY on parts of tables using
> > temporary tables. It's helped me, and it seems
On Tue, Oct 11, 2005 at 06:33:42PM -0500, Jim C. Nasby wrote:
> On Tue, Oct 11, 2005 at 04:22:40PM -0700, David Fetter wrote:
> > On Tue, Oct 11, 2005 at 06:12:53PM -0500, Jim C. Nasby wrote:
> > > Why the vacuum? Seems a bit sever to do a vacuum of an entire
> > >
> +
> > +
>
> The capitalization of "a_list_countries" is inconsistent -- both
> references should all be in lowercase, IMO.
Good catch :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vot
On Thu, Sep 22, 2005 at 07:57:35PM -0400, Bruce Momjian wrote:
> Patch applied. Thanks.
Could you please put fixing domains for functions on the TODO list?
Cheers,
D
>
> ---
>
>
> David Fette
ducing these PDFs something that could be
distributed? What tools actually work for this?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast)-
e these tuits, and they're round, and they're a precious
resource usually spent on writing and testing C code rather than on
improving (and helping transition adoption of) the SGML toolchain.
Maybe we can get some kind soul(s) to donate some tuits and/or pay
somebody a wage for awhile to
Folks,
Please find enclosed a doc patch that adds an example of a correllated
UPDATE.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778
Remember to vote!
Index: doc/src/sgml/ref/update.sgml
where and link to them.
http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/ has at least
the raw files. I'd be delighted to put up something more, tho :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778
Remember to vote!
--
On Fri, Mar 17, 2006 at 12:22:44PM -0600, Jim C. Nasby wrote:
> On Wed, Mar 08, 2006 at 02:05:44PM -0800, David Fetter wrote:
> > On Wed, Mar 08, 2006 at 01:50:47PM -0600, Jim C. Nasby wrote:
> > > It would be nice if there was an easy place to see the documentation
> > &
roll forward.
...and it's unlikely that they will, now or later, without somebody
whose whole job is to monitor those comments and make patches.
I'd like to make a Modest Proposalâ¢: Let's take down the interactive
documents and, in their place, put up a request that doc patches b
into the docs proper.
>
> In the past these ideas were rejected as either off-topic or that it
> would turn this list into a high traffic list... if peoples opinions
> have changed, it could be arranged.
I'm voicing a rejection for 'em again on the same grounds. Until we
ndard have anything to say about assigning identifiers
both to the entire VALUES() statement and to its columns when the
VALUES() statement is by itself?
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfett
ta) (my favorite)
Part 10: SQL/OLB (Object Language Binding)
Part 11: SQL/Schemata
Part 13: SQL/JRT (Java Routines and Types)
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
On Fri, Aug 25, 2006 at 08:37:19PM -0400, Bruce Momjian wrote:
> David Fetter wrote:
> > On Fri, Aug 25, 2006 at 07:46:57PM -0400, Bruce Momjian wrote:
> > > Here is an new XML section for our SGML documentation. It
> > > explains the various XML capabilities, if we sup
On Sat, Aug 26, 2006 at 12:48:32PM -0400, Bruce Momjian wrote:
> David Fetter wrote:
> > On Fri, Aug 25, 2006 at 08:37:19PM -0400, Bruce Momjian wrote:
> > > > Speaking of other parts of the SQL:2003 standard, how about one
> > > > section each that mentions them?
On Sat, Aug 26, 2006 at 01:16:06PM -0400, Bruce Momjian wrote:
> David Fetter wrote:
> > On Sat, Aug 26, 2006 at 12:48:32PM -0400, Bruce Momjian wrote:
> > > David Fetter wrote:
> > > > On Fri, Aug 25, 2006 at 08:37:19PM -0400, Bruce Momjian wrote:
> >
> &
On Sat, Aug 26, 2006 at 08:38:43PM +0200, Peter Eisentraut wrote:
> David Fetter wrote:
> > We claim SQL standard compliance,
>
> No, we don't. And SQL conformance doesn't require you to implement
> all parts anyway.
Right. It'd be nice to be able to tell wha
Folks,
This patch clarifies the 'predicate locking' section in the docs.
Thanks to Harrison Fisk of MySQL AB for helping.
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfet
s replication 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
--
ore I do this I am wondering if this is the right
> forum for
> having the changes vetted before submitting the patch.
>
> Please advise.
Send it to both lists, and thanks for doing this :)
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778
o it like this:
>
> $ pg_dump -s -t '"DbTranLogRecord"' dtr
>
> A bit ugly but the conflict between shell and SQL quoting rules
> sometimes forces us into compromises :-(
>
> Perhaps it's worth having an example for this in the pg_dump man page?
Please find
was a long time ago. I will try
> again this week-end.
I gave it a try post-patches, and it's still a disaster 3284 pages of
un-rendered XML.
> > There is a long standing support within the community to move to XML
> > including:
> >
> > Josh Berkus
> > Josh
can change line boundaries, and
> then diff will never be able to extract any signal from that noise.
Could post-processing with tidy clean this up? I'm pretty sure that
tidy's output is deterministic, at least if the editor hasn't mangled
tags...
Cheers,
D
--
D
l GRANT/REVOKE, which
we don't have yet.
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/a
nsider using Git, which includes a CVS interface,
starting after 8.3 gets out the door?
Cheers,
David.
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
Consider donati
Folks,
Per Neil Conway, here's some doc patches re: the autovacuum daemon's
behavior. Should this be back-patched to 8.2x?
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: david
On Sun, May 13, 2007 at 07:04:44PM -0400, Andrew Dunstan wrote:
>
>
> Tom Lane wrote:
> >David Fetter <[EMAIL PROTECTED]> writes:
> >
> >>I haven't included the customary diffs. This points me to some of
> >>the many deficiencies of CVS, nam
Folks,
Thanks to Andrew Dunstan for pointing me toward cvsutils. As not
everybody knows about them, here's a small patch which lets people
know at least in theory where they are.
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM:
On Sun, May 13, 2007 at 09:51:53PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > On Sun, May 13, 2007 at 07:04:44PM -0400, Andrew Dunstan wrote:
> >> Tom Lane wrote:
> >>> Strange, it works fine for everyone else.
> >>
> >
On Sun, May 13, 2007 at 10:06:40PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > Per Neil Conway, here's some doc patches re: the autovacuum
> > daemon's behavior. Should this be back-patched to 8.2x?
>
> This fact is already docum
On Mon, May 14, 2007 at 03:31:40PM +1200, Mark Kirkwood wrote:
> David Fetter wrote:
> >cvs diff works just great until you want to add or remove a file
> >without write permissions to the CVS repository, i.e. when you've
> >checked out as anonymous.
> >
>
>
he lines starting with '?' that diff
produces.
Lacking sophistication, I've been known to do:
cvs diff [list of files here] |grep -v '^?' > the_file.diff
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter
On Wed, May 16, 2007 at 03:53:22PM +0100, Gregory Stark wrote:
> "David Fetter" <[EMAIL PROTECTED]> writes:
>
> > On Wed, May 16, 2007 at 09:12:23AM +0100, Heikki Linnakangas wrote:
> >> Jim C. Nasby wrote:
> >> >BTW, is there some trick to gett
;list, or join us
on IRC.
Submissions containing URLs or other keywords commonly found in spam
comments may be silently discarded. Please contact the mailto:[EMAIL PROTECTED]">webmaster if you think this
is happening to you in error.
Cheers,
David.
--
David Fetter <[EMAIL PROTECTED]&
Where would you
> have expected to find it?
I'd expect to find it in an ALTER VIEW document.
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember
On Fri, Jun 29, 2007 at 11:32:19AM -0700, David Fetter wrote:
> On Thu, Jun 28, 2007 at 10:16:51AM -0400, Tom Lane wrote:
> > Susanne Ebrecht <[EMAIL PROTECTED]> writes:
> > > that works, but there is no hint at the documentation, that you
> > > can rename a vie
E TO ... ? I
suppose we could document that they're actually done by ALTER TABLE,
but that just seems like a huge POLA violation, along with assuming
way too much knowledge of how sequences and views are implemented.
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone
inology that does not require much context to understand.
>
> So I think what is being proposed is wrong and needs to be reverted.
That, or (my preference) make the change larger. I think it's
significant that the vast majority of compatible software has some
variant of Postgre
On Fri, Oct 05, 2007 at 12:17:40PM -0700, Joshua D. Drake wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> David Fetter wrote:
> > On Fri, Oct 05, 2007 at 11:43:45AM -0700, Joshua D. Drake wrote:
> >> -BEGIN PGP SIGNED MESSAGE-
> >> Has
On Fri, Oct 05, 2007 at 11:43:45AM -0700, Joshua D. Drake wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> David Fetter wrote:
> > On Fri, Oct 05, 2007 at 07:22:01PM +0200, Peter Eisentraut wrote:
> >> Some of you may have noticed that there was a move pro
Folks,
Best practices for partitioning so far have shown that TRIGGERs are
better than RULEs for most cases. Please find attached a patch which
reflects this.
Thanks to Robert Treat for help putting this together :)
Cheers,
David.
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
On Wed, Nov 28, 2007 at 03:53:04PM -0500, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > Best practices for partitioning so far have shown that TRIGGERs
> > are better than RULEs for most cases. Please find attached a
> > patch which reflects this.
On Wed, Nov 28, 2007 at 12:39:04PM -0800, Joshua D. Drake wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Wed, 28 Nov 2007 12:26:15 -0800
> David Fetter <[EMAIL PROTECTED]> wrote:
>
> > Folks,
> >
> > Best practices for partitioning so f
On Wed, Nov 28, 2007 at 12:41:20PM -0800, David Fetter wrote:
> On Wed, Nov 28, 2007 at 12:39:04PM -0800, Joshua D. Drake wrote:
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > On Wed, 28 Nov 2007 12:26:15 -0800
> > David Fetter <[EMAIL
On Wed, Nov 28, 2007 at 05:17:38PM -0500, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > On Wed, Nov 28, 2007 at 03:53:04PM -0500, Tom Lane wrote:
> >> Entirely removing the example of how to do it with rules doesn't
> >> seem like a good
On Wed, Nov 28, 2007 at 10:06:01PM -0300, Alvaro Herrera wrote:
> David Fetter wrote:
>
> > Greg Sabino Mullane managed to contrive an example where RULEs
> > might conceivably be the least-bad way to do this, that being a
> > machine where no PLs may be installed.
>
&
f one use case where using RULEs rather than
TRIGGERs is a good idea?
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:
On Thu, Nov 29, 2007 at 12:55:53AM -0500, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > On Wed, Nov 28, 2007 at 09:58:26PM -0500, Jonah H. Harris wrote:
> >> On Nov 28, 2007 3:53 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> >>> Entirely remov
are talking about partitioning. It is supposed to be narrow-minded.
>
> Sure, but look at all the confusion we have had just on this list about
> it. We had better state why triggers should be used in place of rules
> _for_ _partitioning_ or that confusion will continue.
Please find enc
> the COPY operation will not be so straightforward.
Folks,
Does my latest patch attached address this well enough?
Cheers,
David.
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROT
t;
> balanced
> gradual
> extended (I see you mention time-extended but wouldn't time be implicit
> based on the actual docs and thus we only need extended?)
How about "smoothed?"
Cheers,
David.
--
David Fetter <[EMAIL PROTECTED]> http://fet
esses on a server. If you really need to embed an
SQL engine in a binary, consider the excellent
http://www.sqlite.org/";>SQLite for the purpose.
Comments? Criticisms? Rotten tomatoes?
Cheers,
David.
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
Phone: +1 415 235 3778
column a...');
>
> (see http://dev.mysql.com/doc/refman/5.0/en/create-table.html)
>
> However, Postgres doesn't support the "comment" keyword.
Actually, it does :)
> Is there an alternative?
Cheers,
David.
--
David Fetter <[EMAIL PROTECTED]> http:/
On Wed, Mar 05, 2008 at 12:35:53PM -0500, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Richard Huxton wrote:
> >> Bruce Momjian wrote:
> > David Fetter wrote:
> >>> If you really need to embed an
> >>> SQL engine in a bina
On Wed, Mar 05, 2008 at 12:56:01PM -0500, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > On Wed, Mar 05, 2008 at 12:35:53PM -0500, Tom Lane wrote:
> >> If we need a FAQ entry on this at all, I'd stop after David's
> >> first two sentenc
dded SQL DBMSs rather than leave people with the feeling of, "It's
all up to you from here. Go away."
Cheers,
David.
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTE
;Go to Programs ->
Administrative Tools -> Data Sources and Add the PostgreSQL Unicode
driver."
Thanks to Dan Dascalescu (pidginusr) in IRC for pointing this out :)
Cheers,
David.
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Ya
one to a makefile, btw.
>
> Oh, I forgot that README talked about making TODO.html. I have
> updated the README to suggest using pgsql/src/tools/TODO2html.
I thought this was going onto the wiki so Bruce doesn't have to be the
sole maintainer :)
Cheers,
David.
--
David Fe
Y KEY(name, cod, num)
);
Cheers,
David.
--
David Fetter 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-docs
're proposing, how do
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 tha
had them, at least in some of their engines, for many years.
Cheers,
David.
--
David Fetter 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.o
On Mon, Apr 27, 2009 at 09:50:13PM +0300, Peter Eisentraut wrote:
> On Monday 27 April 2009 20:10:27 David Fetter wrote:
> > While we're at it, can we see about moving foreign keys out of the
> > "advanced" section? They've been standard for many years. He
On Mon, Apr 27, 2009 at 10:56:28PM +0300, Peter Eisentraut wrote:
> On Monday 27 April 2009 21:54:12 David Fetter wrote:
> > On Mon, Apr 27, 2009 at 09:50:13PM +0300, Peter Eisentraut wrote:
> > > On Monday 27 April 2009 20:10:27 David Fetter wrote:
> > > > While
//www.postgresql.org/docs/current/static/ddl-schemas.html
>
> Apparently the only mention of pg_temp is in the CREATE FUNCTION page.
That's probably not a good omission. Any ideas as to where further
mentions should go?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 41
them. It
> will take a long time to read as you're talking about 6 years of
> development.
It's a really, really good idea to build major version upgrades into
your development, deployment and maintenance processes.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 2
'm thinking that something along the lines of, "Expressions are
limited to those which are equivalent to an [link]IMMUTABLE[/link]
function."
Anybody have a better suggestion for wording?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter
nt out of range
> postgres=# SELECT -9223372036854775808::bigint;
> ERROR: bigint out of range
>
> I think those min values are all out by 1.
Nope. Same problem.
SELECT (-32768)::smallint;
-32768
SELECT (-9223372036854775808)::bigint;
-9223372036854775808
I agree that the appropriat
ews, it helps me *enormously* to have only one list I need to check,
so at least for me, it's an enormous help to have all patches at least
CC'd, or better still, only posted, to -hackers.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: d
On Mon, Mar 07, 2011 at 11:34:48PM +0530, Thom Brown wrote:
> On 7 March 2011 23:21, David Fetter wrote:
> > On Mon, Mar 07, 2011 at 10:53:17PM +0530, Thom Brown wrote:
> >> On 7 March 2011 22:31, Robert Haas wrote:
> >> > On Mon, Mar 7, 2011 at 6:16 AM, Thom Br
eparation
of docs from code is one that's actively unhelpful. We don't have a
separate "docs" team, and we rightly put the responsibility of
documenting changes on the person or people patching them in.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AI
On Mon, Mar 07, 2011 at 02:31:18PM -0500, Robert Haas wrote:
> On Mon, Mar 7, 2011 at 2:07 PM, David Fetter wrote:
> > Re: docs, I'd actually like to see that list gone, as the separation
> > of docs from code is one that's actively unhelpful. We don't have a
&g
1 - 100 of 102 matches
Mail list logo