to explain how
> to do this and that, and I think I am a bit spoiled by the easy working
> of the mysql replication :-)
>
Hmm almost sounds like what you really want is mammoth replicator... lower
level than slony, built into the db, can handle ddl (iirc) not oss
though.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
p,
PostgtreSQL has a list of users here: http://www.postgresql.org/about/users
Some limits are in the FAQ: http://www.postgresql.org/docs/faqs.FAQ.html
And anecdotaly I've run systems that maintained 1000+ simultaneous connections
on fairly modest hardware as far back as 7.3,
)
Felix, in case your still watching, a (in theory) more up to date link would
be found at http://www.postgresql.org/docs/techdocs.3. Oh, and please don't
crosspost across 3 different lists in the future, it just creates noise for
the rest of us.
--
Robert Treat
Build A Brighter LAMP :
. Unofficially that will
probably be sometime in November. HTH.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
su
the wordpress guys have basically said they do not want to support postgres,
which is mainly why we swapped to s9y on planetpg. you can read some more
info here:
http://people.planetpostgresql.org/xzilla/index.php?/archives/13-One-Good-Port.html
Robert Treat
On Saturday 21 October 2006 23:31
?/archives/133-Getting-faster-database-restores-on-postgresql-8.1.html
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
proposal or patch. Depending on what your doing there are ways to simulate
those things with more standard sql.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 9: In versions below 8.0,
On Saturday 28 October 2006 19:47, Nicolas Barbier wrote:
> 2006/10/28, Robert Treat <[EMAIL PROTECTED]>:
> > On Tuesday 10 October 2006 15:19, stig erikson wrote:
> >> Are there any plans to implement CUBE, ROLLUP and/or GROUPING SETS in
> >> future PostgreSQL ve
n read, which sounds rather tricky (when compared to doing this at
a higher level anyway). I think your best bet for learning how WAL files
work is to read the backend code and maybe take a look at
http://pgfoundry.org/projects/xlogviewer/
> This is a call for advice, as we're surely no
into postgresql. Then step by step will try to improve/change queries.
>
If you have made use of a lot of built in mysql functions, make sure to check
out the mysql compat project: http://pgfoundry.org/projects/mysqlcompat/
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware
.1 topics... 8.1 was in development at the
time of the writing, so some things are mentioned, but a lot of 8.1 didn't
really apply to PHP programmers. For example, I mention tuning
max_prepared_transactions, but the recommendation is simply to set it to 0,
since there is almost n
any view that only has a single table in it's
dependency tree. (I've really no idea if this would work, so if you try it
and it succeeds please post a note or some code back to the group!)
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
same thing, but it appears the trade-off is disk
space/update speed (GiST) vs. query times (Gin). Magnus had a couple of nice
posts in his blog you might want to check out:
http://people.planetpostgresql.org/mha/
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
believe have some pointers
to afew scripts. (Right click and save to file any pdf docs you run across)
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
--
> > regards,
> > Jaime Casanova
> >
> > "Programming today is a race between software engineers striving to
> > build bigger and better idiot-proof programs and the universe trying
> > to produce bigger and better idiots.
> > So far, the universe is winn
zilla/index.php?/archives/169-Is-lastval-evil.html
:-)
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
ted). If you running an any 8.x version, you need to be on the
most current corresponding 8.x.y release.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
> > not sure I follow - pgpool will simply replay the queries to each
> > backend-server that are going through it.
>
> I guess I'm comparing it to Slony, which has a clear delineation between
> master and slave. With pgpool, you don't have the failover procedure
>
There are several logging parameters in the postgresql.conf, including
log_duration. Logging to a file also has a bonus that you can feed it into a
query analyzing program like pgfouine or pqa.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
-
ve me "the good link"?
The main issue against using temp tables involve bloat of some of the system
catalogs, but it's no worse than doing create/drop cycles with standard
tables, and better because they don't suffer as much i/o load.
--
Robert Treat
Build A Bright
ed by other users.
>
you could try to match CURRENT_USER with the information in pg_stat_activity,
but be aware there is a reason why this functionality was made for
superusers...
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of
k at the samples database project on pgfoundry:
http://pgfoundry.org/projects/dbsamples/
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
ould be using wikipgedia, I'm sympathetic
to those who might still be stuck on it for some reason, so if you guys can
produce a patch against the wikipgedia cvs, I'd be happy to apply it.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
instances
connecting back into PostgreSQL and the results I had have been flakey at
best.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
m you're seeing?
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
> table is just two or three integers, and the PK is a multi-part key
> > of all fields, it makes sense not to store the data twice.
> > However, in Pg you can't do that since visibility is only stored in
> > the data, not the index.
>
You can achieve the same effect wit
:-P
http://sqlmanager.net/en/products/postgresql/dbcomparer
And I think there are some others floating around...
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Have you
st it in your environment.
IMHO YMMV
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
dated / recompiled against newer versions as well. HTH.
--
Robert Treat
Database Architect
OmniTI Technology Firm
http://www.omniti.com/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
ome
projects at OmniTI at least.
I've got some gin/gist information up as well at
http://people.planetpostgresql.org/xzilla/index.php?/archives/278-PostgreSQL-full-text-search-testing.html,
also be sure check the trackback links... and also I think magnus had a post
on gin/gist wrt the postgresql.org website.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
eeds... though I
should say that PostgreSQL has tremendous ability to scale up even
without getting into all the buzzword friendly schemes.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
s of the software in the past, and would not presume to know when
others won't want them in the future. We keep a link to "latest" in the
main directory, and I'm willing to believe most people are capable of
figuring out which is the latest 7.3.x branch on their own (at least
u
I missed the original post, but I think you both might want to do some
googling on nested set.
Robert Treat
On Tue, 2004-11-09 at 11:40, Garris, Nicole wrote:
> We've actually implemented this kind of thing in a different DBMS. The
> physical design consists of a single "org
ecific questions if you have
any, there are a number of oracle converts floating about.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
might want to contact is
http://www.devis.com who has done a number of different projects with the
government. Hope this helps, and if you do get a definitive answer, please
post your finding to the -advocacy group.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
-
he feeds with the
problem to [EMAIL PROTECTED] ?
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Probably just an oversight, but will be linked when we roll the new
website layout with 8.0 (crosses fingers)
Robert Treat
On Fri, 2004-12-03 at 02:07, Jim C. Nasby wrote:
> Then I guess my next question is: why isn't it linked to from
> http://postgresql.org ?
>
> On Fri, Dec
mbersome than querying across schemas. If you are not doing any cross
schema work, then it probably doesn't matter as much.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: Have
irst,
then a unique index, then look for an oid. Furthermore the really clueful
ones will check # of affected rows = 1 when modifying by oid, so its pretty
safe.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
es for music brainz might be more
applicable. I can't recall if his OSCon talk is linked from techdocs, but it
should be available on the OSCon 2004 site. Google on some of the above
words to find out more info.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
be able to help get you to a little closer to what your looking for.
If you have time please check it out and see if it can be of any help,
I'm sure many of us would be interested in hearing some feedback on it.
http://www.daffodildb.com/dbreplicator.html
Robert Treat
--
Build A Brighter La
an uptick in postgresql attendees.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
ck to this.
Robert Treat
On Tuesday 15 February 2005 16:31, Bradley D. Snobar wrote:
> The database comparer tool is one of EMS better products.
>
> http://www.sqlmanager.net/
> http://www.sqlmanager.net/products/postgresql/dbcomparer
>
> Jeff Amiel <[EMAIL PROTECTED]> wrote
py it over before start up) so
you should have a chance, but it is complicated to do in an uncontrolled
environment, which is why it doesn't work that way as of yet.
BTW, if you have a good idea of the size of your data set, you might be able
to hardcode things. Ie. a desktop app is prob
ROTECTED]
>
> Also on a couple of the others I have looked at... Is this right?
>
I forwarded this on to [EMAIL PROTECTED] and Marc is on it, though it
will take some time for the pages to regenerate. Thanks for the report
though.
--
Robert Treat
Build A Brighter Lamp :: Linu
Example command "UPDATE data where name=x and date=y;".
>
> Try using VACUUM or VACUUM FULL after those weekly updates...
Once you've updated a majority of the rows in a large tables, if your still
doing further work on that table that involves complex conditionals, you'l
ould be a wonderful product. (From this
thread it just sounds like they need a little more structure in the project)
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
provides anything like that.
Robert Treat
On Friday 06 January 2006 22:34, Ian Harding wrote:
> As I recall, the MS SQL Server draggy droppy diagrammer tool made it
> seem trivial to rearrange columns did the same thing. It just
> generated SQL statements to:
>
> Begin trans
ly ACID-incompliant anymore than how they handle timestamp fields.
That said see nearby posts about row level constraints and transactions
involving mixed table types that can't actually be rolled back if you want to
find ways that mysql breaks acid compliance.
--
Robert Treat
Build A Br
pos := pgmail(p1,p2,p3,p4);
>
>
> Can anyone help me? I'm using postgres 7.4.7 version.
Try to run pgmail by itself with those values and see what error that gives
you.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---
of cases. Last time we discussed this for
phppgadmin, the general opinion was it wasn't worth trying to work around
postgresql core's deficiency. Once the core postgresql server supports
updatable views in proper, I'd imagine this would get done.
--
On Thu, 2006-02-16 at 10:41, Tom Lane wrote:
> Martijn van Oosterhout writes:
> > On Thu, Feb 16, 2006 at 07:28:20AM -0500, Robert Treat wrote:
> >> One problem is the only way for a client tool to work generically in prov=
> > ding
> >> data entry forms would be
n. ISTM this is asking for a
lot of knowledge of mysql internals for the average front end
developer.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
structure matched that of the temp table, or use out parameters to mimic it.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
on't run any proxy so the error cannot be my end and this
> problem has been there for at least two days.
>
It's a known issue with the guides section. I had been waiting on some
activity elsewhere wrt a techdocs replacement, but have about given up
on that so am working on a plan b
ake a site
on meetup like the php folks did, or maybe make a site at the pg user group
site. http://pugs.postgresql.org/
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 3:
on top of a postgre data base.
>
> The database is called PostgreSQL or Postgres, not Postgre.
>
> Search for ERP and Postgres on http://sourceforge.net and you'll get
> some hits back. I don't know of anyone running a commercial ERP system
> on PostgreSQL, but that doesn&#x
might be able
to get something together.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
ou'll probably want something that can do connection
pooling. You can get more help on the -performance list too, just make sure
you provide specifics. You might also want to look into getting commercial
support, though choice questions to the mailing list might be enough to steer
you on t
portance of this being that there will be no way for
it to just "get all the changes"; you'll have to rebuild it. My
understanding is the same is true for replicator, but perhaps you can
elaborate on that?
--
Robert Treat
Build A Brighter Lamp :: Linux Ap
icable. That really is a
factor, most of the comments would need to be reworded to be added 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.
--
Rob
On Thursday 23 March 2006 17:46, David Fetter wrote:
> On Thu, Mar 23, 2006 at 04:46:02PM -0500, Robert Treat wrote:
> > > ...and it's unlikely that they will, now or later, without
> > > somebody whose whole job is to monitor those comments and make
> > > pat
er or possibly joomla? I think the Mambo developers
may be anti-postgresql, but Joomla should have decent postgresql support,
with the main person behind that being Mitch Pirtle of JamboWorks. You might
want to track him down.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middlewar
TABLE because it's a lot cleaner/easier. For larger tables,
> you might want to CREATE TABLE AS SELECT ..., or maybe copy out and copy
> back in.
This seems backwards to me. On larger tables I tend to favor alter table for
adding/dropping columns since the table doesn'
y this.
>
Yes, this behavior is driven by the sql standards. There is actually a very
nice paper on this subject if you are interested
http://web.onetel.com/~hughdarwen/TheThirdManifesto/Importance-of-Column-Names.pdf
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
gement" (ISBN: 0201485559)
> Feel free to reply off list to keep the clutter down - I'd be happy to
> summarize responses for the list.
>
We're all about clutter :-)
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
on support is in the plans for future
> versions of PostgreSQL?
>
Improved collation support is being worked on but it's a complex problem so
there's no realt ETA. (Developers interested in helping out our encouraged to
send a note to -hackers). In the mean time check out the citext proj
my files on the
> > server, access to create new postgres databases and a link to phpPgAdmin.
>
> Do you get the option to create a new database user? You could create
> a new user and give that user access to your database.
>
Yeah, we're just window dressing atop the
nce between your
platforms. In the above scenario you will likely have differences in
dependency information when declaring a default nextval call on a sequence
compared to declaring a true sequence type.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
--
d to use the pg_dump program, which is a seperate program from psql.
IIRC it is in your start menu, but if not you will need to access it from a
command line window.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end
x27;s called pgpedia.
>
> If I am confusing wiki's, I'm wondering if they'd be willing to
> accept patches to improve PostgreSQL support...
You are not. I dubbed the new code wikipgedia, it lives on the foundry, the
home page is at http://wikipedia.projects.postgres
ntor to help push the project along.
Robert Treat
> > -Original Message-
> > From: Tom Lane [mailto:[EMAIL PROTECTED]
> > Sent: Saturday, April 15, 2006 7:14 PM
> > To: Benjamin Arai
> > Cc: pgsql-general@postgresql.org
> > Subject: Re: [GENERAL] Googl
one system on
linux, apache, mod_foo and the other on bsd, lighty, and mod_bar ? Best to
through your support behind one complete system (sounds like postgresql from
previous postings) that can do the job and become an expert in making that
system secure.
--
Robert Treat
Build A Brighter Lam
al table.
>
> I guess what I'm asking for is a kind of "REBUILD TABLE" which is not
> MVCC by definition but it would be useful in the mentioned queue table
> case.
>
vaccum full ?
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
The best solution I have seen so far is the idea of a GUC to control
autovacuums chatter level. I hope we get that becuase the above will be a
regression imho.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 6: explain analyze is your friend
t
mysql uses to implement it (for the table types that will actually do it,
some just ignore your request silently!)
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 1: if posting/readin
also open up the amount of people who can also take said code
and run it in thier "real-world" instances and find issues or make
improvements to it. I recomend posting the code in it's current form and
letting others take a look. It can always be updated later if you find that
rather scrambled, and
> that reindexing often sorts the values and rewrites that data so that
> the indexes take less space and work faster. Is that not the case here?
>
It really isn't neccessary. That said, there is *something* going on with your
db, so it might be prudent t
On Sunday 04 June 2006 12:55, P.M wrote:
> Hi,
>
> I would like to know if it exists a good case tool for creating DB into
> PostgreSQL ? thanks a lot,
>
There are several listed at http://www.postgresql.org/docs/techdocs.54
--
Robert Treat
Build A Brighter Lamp :: Linux Apa
made available
> freely.
>
I doubt they could for open source projects, unless those projects had very
tight control over thier distribution (which is kind of self defeating).
Smaller projects on places like pgfoundry might be able to track this (slony
comes to mind), but for us it seem
ratch every time I do an
> update.
If you going through this kind of step now, why not just generate the whole
site from the pg database as html pages and then push those out to the
client? That way you eliminate any dbms overhead and reduce load on your
webservers (and eliminate the need for a 2nd db schema)
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 6: explain analyze is your friend
o let me know when somebody uses it. :)
>
So "as an empiricist", you have derived that programming in PHP, hitting a
mysql backend, atop a Windows OS, is far better than that wonky
perl/postgresql/linux stuff you normally work with, right?
--
Robert Treat
Build A Brighter Lamp ::
and
// understand how to change PostgreSQL's pg_hba.conf to enable
// passworded local connections.
$conf['extra_login_security'] = false;
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)
gt; The real question is whether the pg developers would
> object to such a feature, whatever the design is,
> or whether it's just that nobody's
> gotten around to writing it.
>
Probably more of no one getting around to it, but you need to come up with a
solution that does
session support setup in your php.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
at your postgresql.conf "listen_addresses" is properly set, also
make sure you dont have a firewall setting that is blocking connections, the
default firewall settings on FC boxes are notorious for blocking pg.
--
Robert Treat
Build A Brighter LAMP :: Beginning PHP and PostgreSQL 8 (ISBN 1590595475)
---(end of broadcast)---
TIP 6: explain analyze is your friend
ght flags,
the output is pretty good.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
gt; temporarily need up to an extra 90 MB. Use the df command to check for disk
> space.
>
> This includes space required for compiling the application. Looks like
> about 40 MB for the installation and an empty cluster.
Well, certainly you aren't going to want to be compiling from
7;t be
> found.
You know Tom, if you're interested in hacking on phpPgAdmin, I'd be happy to
send you a copy of "Beginning PHP & PostgreSQL 8 "
:-)
Darren, this is fixed in ppa's CVS HEAD. If you want a specific patch, drop
me a note off list, though I am thi
I would think .cu == spanish?
en la programa "psql" uso
\dt
también, hay una lista española: [EMAIL PROTECTED]
Robert Treat
On Sunday 06 August 2006 05:33, Marco Bizzarri wrote:
> Sorry, I will try to answer in english and in italian, if you're able
> to understand
tting a team of developers on
top of the contest so they come out shining. Too bad people in this
community don't see the value of paying people to do advocacy related
development.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(
ish this
as well, plphp for instance.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMA
I'd like to see done is to get majordomo to bounce list
> > messages containing "unsubscribe" in the subject, with an explanatory
> > message about the right way to unsubscribe. There's no reason the rest
> > of us should be bothered.
>
> I would agre
On Wednesday 30 August 2006 16:48, Joshua D. Drake wrote:
> Martijn van Oosterhout wrote:
> > On Wed, Aug 30, 2006 at 01:54:56PM -0400, Robert Treat wrote:
> >> Seems they are fast where it counts... namely getting a team of
> >> developers on top of the contest so they
only reservation I see on that is a bias toward more eloquent writers
> having disproprotionate influence. But I don't see any way to avoid that.
>
I think some members of this community confuse volunteerism with meritocracy.
--
Robert Treat
Build A Brighter LAMP ::
slides from his recent talk
showing why he came up with the statements he made
(http://talks.php.net/show/oscon06/1). Please post the info
when you get comparable performance running from PostgreSQL...
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
> "Its" is a possessive pronoun. "It's" is a contraction for "it is".
>
>
>
'tis not as simple as that my friend, 'tis really more a matter of
dialect.
http://www.word-detective.com/back-d.html#its
Robert Treat
--
Build A
ERE partno ilike '5R%';
Robert Treat
On Thu, 2003-12-11 at 01:39, Eric Holmstrom wrote:
> Hi there,
>
> Ive been reading but not getting far, so thought i would ask here. IN
> SQL im trying to do this.
>
> What its meant to do is look in Column partno. Then check if
Paul,
once you get through the book perhaps you could submit a book review to
the techdocs website, along with a pg_dump of the sample database.
Robert Treat
On Mon, 2003-12-22 at 05:50, Richard Huxton wrote:
> On Monday 22 December 2003 07:47, Paul Ganainm wrote:
> > Not really a P
ror_id, max(status_id)
FROM current ce
GROUP BY findsite(entity_id)
) AS errors ON (error_id = search_id)
WHERE
search_id = s.site_id AND s.region_id = r.region_id AND search_id =
e.entity_id
AND a.host_id = h.host_id AND h.site_id = s.site_id
)
) AS ss ORDER BY UPPER(ss.name) AS
201 - 300 of 339 matches
Mail list logo
