I work with a system designed as lots of little cooperating worker
programs, with boss programs that... well, boss the worker programs
around.
Boss and workers all use the same database.
Sometimes it would be convenient to have a boss start a transaction
and then have the workers do their work in
On Wed, Sep 06, 2006 at 12:04:18AM -0700, George Pavlov wrote:
> I have two columns, both individually nullable, but a row needs to have
> a value in one or the other. What is the best way to implement the
> constraints?
check (a is null != b is null);
---(end of broadcast
If you need to run two separate databases on the same box, each with
its own port, then having two clusters would be one way to go. Each
cluster has its own postgresql.conf and so each cluster can be (must
be, if I'm not mistaken) configured to listen on a separate port.
-
On Fri, Aug 04, 2006 at 11:04:03AM -0400, Matthew T. O'Connor wrote:
> Wayne Conrad wrote:
> >Are you also doing the dance with pg_start_backup(), doing a file copy
>
> Yes, of course. Is there another way?
Not that I know of. I'm embarassed I ask, since y
kup(), doing a file copy
of main, and then pg_stop_backup()? That's your full backup; the PITR
files are something like incremental backups and need the copy of main
to play against.
Wayne Conrad
---(end of broadcast)---
TIP 5: don'
On Mon, Jul 31, 2006 at 10:18:31PM +0200, Christian Kastner wrote:
> After the online backup script runs, all subsequent attempts to run
> archive_command fail because the first thing it tries to archive away is
> the still-existing *.backup file. This fails because a copy already
> exists in the
On Mon, Jul 31, 2006 at 10:18:31PM +0200, Christian Kastner wrote:
> After the online backup script runs, all subsequent attempts to run
> archive_command fail because the first thing it tries to archive away is
> the still-existing *.backup file. This fails because a copy already
> exists in the
NULL on the program end would be
torture if the database itself did not support NULL.
There's plenty of nits to pick here, I think. But it's clear to me
that practice has proven NULL to be too useful to ditch.
Wayne Conrad
---(end of broadcast)
On Tue, Jun 13, 2006 at 05:01:01PM +0200, Daniel McBrearty wrote:
> create table translations (
> id serial primary key
> );
> insert into table translations ... insert what?
insert into translations default values;
> The other way to do this that I see is to lose the link table
> translations_
Daniel's answer reflects our experience with large objects.
We recently switch our 50-or-so G of stored postscript documents from
large objects to bytea, but only because we're going to use Slony for
our "more-availability" setup and Slony doesn't replicate large
objects.
t returned by PQerrorMessage still include the character
position?
Wayne Conrad
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
> tagged_type int -- points to the table this tag is tagging
My head exploded right about here. Is the schema written in stone, or
can it change?
What is the use case for this schema? What's it for? What is a "tag"
about?
Best Regards,
Wayne Conrad
-
the rare resource that
the libraries don't know about, but it's seldom more than a few lines
of code. We don't have to think about it much.
Best Regards,
Wayne Conrad
---(end of broadcast)---
TIP 1: if posting/reading thro
On Wed, May 03, 2006 at 09:38:47AM +0200, Magnus Hagander wrote:
> SELECT regexp_replace(your_string,'[aeiou]','','g') ...
I'll be darned. I've been looking for that function. I expected to
find it in the docs under "String Functions" with the other replace
functions. I'm surprised to find it u
Tom, You bet. I'll give it a go and report back.
On Tue, Apr 25, 2006 at 08:39:46PM -0400, Tom Lane wrote:
> I've applied the attached patch to 8.1.*,
> but it could use more testing --- do you want to patch locally and
> confirm it's OK for you?
---(end of broadcast)
On Tue, Apr 25, 2006 at 02:27:23PM -0700, Bert wrote:
> I have a table construction like the one seen below, when i am updating
> or inserting i get a recurion, logical. But how to manage it that the
> rule is just doing it one time. Or is it possible to do the sum of a
> and b in an other way?
> .
iled on request of size 80.
What other information can I supply? What experiments should I do?
Thanks in advance for any help you can offer.
Wayne Conrad
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
17 matches
Mail list logo
