ry Douglas's book titled "PostgreSQL" from
the same publisher must be somewhat similar.
http://www.amazon.com/exec/obidos/ASIN/0735712573/qid=1072831905/sr=2-1/ref=sr_2_1/002-2846574-6863256
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
It comes with the distribution (assuming by distribution you mean the main
tarball, some "distributions" package it seperatly i think). You can view
the contents on the web via webcvs:
http://developer.postgresql.org/cvsweb.cgi/pgsql-server/contrib/
Robert Treat
On Tuesday 30 Dec
enses and think about
spending that money to hire someone to develop those features in PostgreSQL,
I'm thinking you'd save money in the long run.
Robert Treat
On Friday 09 January 2004 14:48, [EMAIL PROTECTED] wrote:
> I write this to tell you why we won't use postgresql ev
the moment). An error terminates a transaction immediately in
> PG's current model.
>
Didn't someone say this could be implemented in some of the other
pl's... plpython maybe? Or maybe they were using dblink to make a
separate connection/query... ?
Robert Treat
--
Build A
techdocs.postgresql.org/hosting.php) but
barring that I think your going to have to turn to the mysql community
for information about their database.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
i On Mon, 2004-02-16 at 14:26, Simone Crider wrote:
> Could you please tell me where I would find the GPG MD5 Checksum values
> for the postgres 7.4?
>
http://www.gtsm.com/postgres_sigs.html
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} P
tion, "troll" ???
>
http://info.astrian.net/jargon/terms/t/troll.html
:-)
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
m full on your cluster to see
if their filesizes change at all... but if you've got that cowboy
feeling going i'd say shutdown the database, backup the directory,
delete the files, and fire it back up...
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
ry snapshot inside plpgsql whenever a lock
table in exclusive access is issued follows along this line and would
seem like one way to help most people get around this problem since it's
hard to imagine any real world scenario where one would want to lock a
table exclusively and still see ro
r;
> >
> > done by software.
>
> I recommend they keep clinging. :-)
>
Should we recommend they submit a patch instead? :-)
Seriously though this sounds like it could be an extension of the
tablespaces implementation couldn't it?
Robert Treat
--
Build A Brighter Lamp :
that the OP is not
likely to ever need such a high connection count, there's no reason that
PostgreSQL can't support it given you have enough RAM, fast enough
disks, and you don't shoot yourself in the foot with FK/Locking issues
in the app.
Robert Treat
--
Build A Brighter Lamp :: L
style
benchmarks on the system, check the archives or the osdl site for more info
on getting these up and running.
Robert Treat
On Monday 24 May 2004 09:59, Greg Spiegelberg wrote:
> Robert,
>
> I am currently evaluating PolyServe Matrix Server which is a clustering
> solution incl
ndows and gui tools up on techdocs. I plan to do that as well,
just need to find time to work it into the schedule.
Robert Treat
On Tue, 2004-06-08 at 08:46, Jan Wieck wrote:
> I guess I have to address a slightly broader audience, or do I conclude
> from the total lack of interest in this
collector daemon.
I'm curious if anyone knows if this was fixed in 7.4, and perhaps more
importantly if there is a way to clear these entries in 7.3.4. (I was
thinking perhaps some entries in the stats tables but didn't find
anything...)
Robert Treat
--
Build A Brighter Lamp :: Li
apps but would be frowned upon by most postgresql
users.
Robert Treat
On Fri, 2004-06-18 at 15:00, Duane Lee - EGOVX wrote:
> I agree. You could always do a SELECT and if the record was found then
> UPDATE otherwise INSERT. A little more effort than MYSQL but again I
> don't belie
n I can't create
the Key.
Have anybody an solution?
I think the way you are "supposed to do this" is by using the
CURRENT_USER variable to get the current user name for the person
connected. If you are stuck on using the system id's you could create
your own triggers to
We wont update the website docs at least until
the packages are officially announced, and even then might be a few days
later. Oh, you'll know it has been officially released when you see Marc
post an email to -announce telling everyone.
Robert Treat
--
Build A
acle like task schedular in postgresql. not sure how
mature it is but might be worth a look for those interested in this.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 3: if posting/readin
new column and then use a view with some coalesce
magic to combine the two columns into one. HTH
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 9: the planner will ignore your desire
I am trying to use the following trigger:
CREATE TRIGGER formatname BEFORE update OR insert ON mytable FOR EACH row
EXECUTE PROCEDURE lower(name);
however, it gives me the message:
ERROR: CreateTrigger: function lower() does not exist
obviously this does exist, since I can do inserts/updates/
://www.sql-ledger.com/ double entry accounting system
http://openacs.org/ enterprise level web community system
Robert Treat
--
PostgreSQL :: The Enterprise Open Source Database
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
to suppress column names for COPY only
dumps. I also checked the message archives, but the only thing relevant
seemed to be the original patch which didn't appear to allow for a way
to suppress the column names, am I completely missing something here or
did we los
r the weekend, the trigger
feature seemed to work, and the complex array example function seemed to
work ok, but the basic simple echo example failed. I've subscribed to
the mailing lists, so we'll see if I can figure out where I went wrong.
Robert Treat
--
Build A Brighter L
On Wed, 2003-08-06 at 09:22, The Hermit Hacker wrote:
> On Wed, 6 Aug 2003, Robert Treat wrote:
>
> > depends on what you mean by any. I believe that the standard tarball
> > will compile under windows, but to what extent it will actually run I
> > couldn't say. Thi
On Wed, 2003-08-06 at 11:17, scott.marlowe wrote:
> On 6 Aug 2003, Robert Treat wrote:
>
> > On Tue, 2003-08-05 at 20:18, Dann Corbit wrote:
>
> > > For me, I can only find these directories:
> > > ftp://ftp8.us.postgresql.org/pub/pgsql/source/v7.4/
>
ll compile under windows, but to what extent it will actually run I
couldn't say. This release is not intended for native use on windows
(that had to be pushed back to 7.5), though it will certainly run via
cygwin.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
eturn $workable
' language 'pltclu';
Robert Treat
On Fri, 2003-08-08 at 20:04, Robby Russell wrote:
> Should be a simple question.
>
> When selecting a field that is of type money, how can I remove the $
> when selected?
>
> example: $10.00 would return as 10.0
unsuccessful
> so far.
>
Well, some folks are certainly doing it, check out this blog entry:
http://www.redev.org/archives/23.cfm#more
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 8: explain analyze is your friend
ever see a recommendation from the development group to run postgresql
on windows over a *nix OS for production purposes (even when native
win32 comes about, theres just too much lacking in windows) however for
development purposes it should be more than fine.
Robert Treat
--
Build A Brighter Lamp :: Li
;) {
> fileinto "INBOX.garbage";
> }
>
> I can't think of anyone using anything but *maybe* the Approved one in
> their Subject, so there shouldn't be too many false positives ...
> hopefully hear something from the mj2 guys relatively soon ...
Little does Ma
This sounds an awful lot like crosstab functionality, Check out the
tablefunc module in contrib, I think there is something in there that
will help you with this.
Robert Treat
On Thu, 2003-08-21 at 16:11, Stephan Szabo wrote:
>
> On Thu, 21 Aug 2003, Egor Shipovalov wrote:
>
> &g
t; something very simple but I don't know TCL (and I'm planning to keep
> the serverside programming on pl'pgsql as much as possible).
>
You'll need a function a bit more complex than this, but to do what your
trying to do in the function above the function would be writ
http://developer.postgresql.org/ftpsite/binary/v7.3.4/RPMS/
Robert Treat
On Thu, 2003-08-28 at 11:18, Marie G. Tuite wrote:
> Same issue - are there rpms anywhere for 7.3.4?
>
> Thanks.
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTE
On Wed, 2003-09-24 at 13:50, Jan Wieck wrote:
>
>
> Robert Treat wrote:
> > On Tue, 2003-09-23 at 17:49, Christopher Browne wrote:
> >> It would be most interesting if the makers of other GPLed software
> >> such as Linux were to apply the same rule themselves.
he place, and has been since the beginning.
Or sign up for -announce and read the weekly news, which gives a summary
of each weeks developments* and updates some other ancillary information
about the project.
* save last week, which seems to have gotten lost in virtual space, but
come Wednesday
is there some way to determine the query that creates the file
pgsql_tmp15041.0? i thought maybe 15041 was the procpid but apparently
not... anyone know?
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast
and let's gloss over whether their implementation is acid compliant)
so just be prepared if your going to do it. also, if you do do it, i'd
like to see a feature comparison against some more interesting
candidates, like oracle or informix
Robert Treat
On Thu, 2003-11-20 at 11:12, Jeff
nce. Can you send your info 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
r they spoke with was... well, this is a
family newsgroup so let's just say I don't feel his opinion is very
credible. It would have been very easy for them to indemnify themselves
had they wanted to, to not even try to sort this out speaks of some
other agenda on their part IMHO.
Robert
301 - 339 of 339 matches
Mail list logo
