for this, in my experience. I'm not sure what to tell
you except that, perhaps, you need a Postgres consultant.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
://smarterer.com/legal/terms, item 2.D). If you placed your
content under a license similar to PostgreSQL's (like the BSD
license), that might be different.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
are supposed to be working on the non-standard
database name set PROJDB in their environment, and your problem is solved. No?
(I have reservations about this entire thing anyway. It feels to me you really
want to be using schemas here, but that's a different discussion.)
Best,
A
--
Andrew
and unless you're careful about your locale
you could end up messing that reverse operation up -- oughta be safe in
C, though. (Contrary to popular opinion, domain name labels are
not necessarily made of ASCII.) You can, of course, also force the
labels to be only LDH-labels.
Best,
A
--
Andrew
are not using any features in the
newer version.
Say from 9.2 to 9.1.
Thanks
H.F.
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
. That's what optimizing for general cases buys you.
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
of stuff;
INSERT INTO xact_log $stuff-with-money-deducted;
UPDATE account SET balance = balance-?COST WHERE customer_id = ?ID;
---ERROR here for no permission
COMMIT;
Or anyway, that's how I look at it.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql
if you want one.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
unaware, but instead
constrained by a subset of languages. That is a more tractable
problem (for instance, you may not have to worry about direction
changes, which vastly simplifies the problem).
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql
. :-/
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
You have the good fortune of being able to provide them with a hint!
I wish I were in your shoes.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
Postgres admins remains one of the
costs of using Postgres today: you add cost to your administration. I
think the cost is worth it, note.
Hope this is helpful. Good luck,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
you an IPv6 address
from one perspective and not from another. The application (Postgres
in this case) can't fix this.
Best,
A
--
Andrew Sullivan
a...@anvilwalrusden.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
luck.
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
market.
The Gartner report itself was controversial: ISC, who also promised to
use PostgreSQL for its back end, got a lower grade on the back end
than did Afilias.
Anyway, this is all an amusing walk down memory lane. Thanks for the
reminder!
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
their
implementation very dramatically (and I've no reason to believe they
have), you could not get to any web site ending in .org (or, for that
matter, .info, .in, .aero, .mobi, and a number of others) without the
services of PostgreSQL.
Best,
A
--
Andrew Sullivan
a...@anvilwalrusden.com
--
Sent
. Neustar, who run .biz and .us, bought
Ultra. Afilias does not use any Ultra servers in its systems, and
hasn't since before I quit working for Afilias.
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
to do this.
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
do, I think you
will find it is spelled emacs.
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
in Win 7.)
Because all wire protocols from the IETF use UTF-8 for Unicode
encoding, your best bet is still UTF-8 for maximal portability, so
your point about needing to make the database encoding and client
locale UTF-8 is correct.
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via
that way.
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
. New vulnerabilities in these versions are no longer patched.
See http://www.postgresql.org/support/security/. I'd plan to upgrade
soon.
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
that explaining the popularity of products is
almost always unsatisfying. Consumer behaviour, whatever a certain
strain of economics says, is not obviously rationally maximizing.
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general
example.info, Afilias has nothing to do with what software you use.
I'm sure to this audience that is self-evident, but having just
returned from an ICANN meeting I am not at all sure it is self-evident
to everyone in the world.
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql
that the
reason there's no locking overhead is because there's no lock;
basically, if you're joining a lot, you're thrown back on
old-fashioned locks of some sort. They also don't permit
in-transaction round trips to the application, so that source of lock
contention is also gone.
A
--
Andrew Sullivan
is a primary key,
however, and that's going to be faster if you build the unique index
after the data's all loaded.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
of the table, and you need
to lock it while you do that. Probably you're not getting the lock
you need granted and therefore it seems like it's taking a long time.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
for that column and do
the analyse. Have you tried that?
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
in a system that was designed to mimic a
complicated Oracle mutli-user set up. I used a number of schemas, the
search_path, and a lot of GRANTs to make everything work reliably in
the cases where there was shared data across the users. It seemed to
work for me.
A
--
Andrew Sullivan
a...@crankycanuck.ca
in a system that was designed to mimic a
complicated Oracle mutli-user set up. I used a number of schemas, the
search_path, and a lot of GRANTs to make everything work reliably in
the cases where there was shared data across the users. It seemed to
work for me.
A
--
Andrew Sullivan
on something someone
else needs, your low nice score is going to cause them problems. It
could make things worse rather than better. (This suggestion comes up
a lot, by the way, so there's been a lot of discussion of it
historically.)
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general
the
momentum of other interesting projects (and ones better suited to some
environments). Sometimes, it's better to cut off options.
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
list is in any case worth what you paid for it.
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
that COPY is going to be your friend here.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
might also want to look at your collation. Sort orders are
notorious for being surprising across collations. What's this one?
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
related to this, some users
doing this via trigger like rubyrep.
is there an easy way to do this? thanks!
Why not adjust the underlying sequences to have different start values
and to advance by 2?
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql
want is, To cancel a running query, send the
SIGINT signal to the process running that command.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
), but we're still too busy for that right now
(unless you tell me I'm going to see a night-and-day difference
regarding this particular issue).
I think it might be more dusk and day, but I have had very
impressive performance from 9.0. Haven't tried 9.1.
A
--
Andrew Sullivan
a...@crankycanuck.ca
that the vacuumed page doesn't end up being enough traffic to cause an
eviction (or, anyway, to evict for any significant time).
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
?
Not to my knowledge, although I'd expect the terminal driver to have
control over this, no?
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
is good enough for you, then
the unaccent dictionary will probably be good enough.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
LATIN1).
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
they can rely.
Best,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Sep 28, 2011 at 10:34:32AM -0400, Tom Lane wrote:
I think the true state of affairs is this: rules have a lot of
surprising behaviors, and if we could think of something that works more
straightforwardly, we'd love to replace them.
Oh. Well, _that's_ not news :-)
--
Andrew
.
There isn't an easy answer here.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Sep 07, 2011 at 11:45:11PM +0800, Lincoln Yeoh wrote:
Don't you have to block SELECTs so that the SELECTs get serialized?
If you want to do that, why wouldn't you just use serializable mode?
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql
On Wed, Sep 07, 2011 at 04:37:24PM +0200, Asia wrote:
put top-level CA cert from CA having two certs in root.crt
[. . .]
how libpq works with chained CA's.
Two certs and chained CAs are completely different problems. What
are you trying to do, exactly?
A
--
Andrew Sullivan
, since I hear people say this all
the time. (I mean, I've also seen places where 'upsert' would be
cool, but it doesn't seem trivial to do in a general way and you can
do this with catch-serialization-error-and-retry, I think?)
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general
not in the $PATH. The $PATH doesn't affect
the visibility of the string |psql|, just adds an implicit way of
finding such a string if it's on the path somewhere.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
a patch:
. . . then it is searched first (even before pg_catalog); this can
be changed by explicitly listing pg_temp in the search_path. In
any case, the temporary schema is only searched. . .
?
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql
am
trying to avoid is storing a list of columns somehere. Is there something
like
a user area in the underlying tables that define a column that could be
safely utilized for this purpose?
Sounds like you want a view, I think.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql
could be
worse than death.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-- I had to do some whacking
around of the produced files, and I had a pretty good idea of what
changes were needed in the ora2pg tool to improve things, but I didn't
have time to implement them. It was still a lot easier than trying to
do it all by hand.
A
--
Andrew Sullivan
a...@crankycanuck.ca
at the actual Oracle installation you
want to use.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I'm a real lama,
or search with wrong terms... :-)
The session timeout is defined by the TCP timeout. See the
tcp_keepalives options.
You can time out statements by statement_timeout.
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general
in their application.
A
--
Andrew Sullivan
a...@anvilwalrusden.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Jun 06, 2011 at 10:24:45PM +0200, Heine Ferreira wrote:
I basicically want to avoid using upper in comparisons.
Has anyone tried this?
Do you know if this will work?
There's a contrib module that will allow you to do this. See the
citext datatype.
A
--
Andrew Sullivan
(and different server-configred timezones) I must use (no very
intuitive)
a TIMESTAMP WITH TIMEZONE.
. . .yes. Do everything in UTC, and then you have the best of all
worlds here.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
or any of the other
trigger-based replication systems.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-- that's why you get warnings from psql when you
start up a client with a different major version number than the
server. (If you want to see this in action, try using a 7.4-era
client with 9.0, and do some tab completion or something like that.)
A
--
Andrew Sullivan
a...@crankycanuck.ca
pg_xlog partition is ~8GB and under the restore process 486 WAL
files were created in this partition. The partition got full and
everything crashed.
Disk is cheap. 8G is hardly anything any more; I'd buy some more disk for WAL.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general
of overhead for
WAL. ISTR dedicating 40G to WAL one time for a case like this.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
like your index can't actually be used to satisfy your
query. Without seeing the table definition, index definition, and
query, however, it's pretty hard to give you a real answer.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
, there is a system built atop Postgres or
SQLite: http://biblioteq.sourceforge.net/index.html. I'm unable to
find the license, though the web page says it's open source.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
it ought to
work.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
. if not, do you know what
application might create/ use them
Looks like you installed pgaccess, is my guess.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
sorting them is a bad idea. Also, if someone
imposes on you a programmer you are fairly sure doesn't understand the
problem you're working on, you should quit on the spot. (I have to
keep relearning this one, though.)
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list
to the stone tools we had for
replicating in 2001, it was a dream.
/oldtimer
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
. Generally, the
system table is good enough for that, I find. (Someone: How long
will this take? Me: There are about 400 million rows to go
through. Even if you're off by 50 million at that point, it doesn't
matter.)
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing
strongly
recomment you experiment in a test system with real data and
pathological cases in particular, in order to see what happens when
the outlier cases inevitably, Murphy willing, crop up. That's not to
say you should arrange your plans for them, but forewarned is
forearmed.
A
--
Andrew
ExtUtils::MakeMaker 6.32 not found. We have 6.30.
I don't know anything about Bucardo, but it sure looks to me like you
need to do some upgrading before continuing past this point.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
that and then compare what you get
when you look at it by hand.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
?
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
colleague want to draw from this
overwhelming (if perhaps statistically dubious) penetration? Surely
the argument doesn't conclude, Therefore we should do that too? I
seem to recall my mother making some remark about others jumping off
cliffs.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent
failover thing that blows away
your system if you sneeze wrong, or something like that.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
: [FAILED]
You probably want to look in the logs. Under /var/log there should be
something -- if nowhere else, then in syslog.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
all seemed to me to be things I've
actually done before, but not using something directly inside
Postgres.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
.
The question is: can we suppress the logging of these message .. but allow
other error messages to be logged normally?
No, but I should think grep -v is your friend here.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On Fri, Apr 15, 2011 at 02:04:49PM -0400, Jerry Sievers wrote:
set log_min_messages to fatal;
I thought changing the log_min_messages required superuser access?
(That's what the docs say, and what I'd expect too.)
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing
and suddenly you're out in the street wearing a barrel.
I can think of lots of different points to be along that continuum,
and surely nobody is suggesting that there is one right answer for
everything.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql
://www.postgresql.org/docs/9.0/interactive/sql-altertable.html)
Note that this doesn't actually update the fields that are NULL in the
column already. For that, once you had the default in place, you
could do
UPDATE table SET column = DEFAULT WHERE column IS NULL
IIRC.
A
--
Andrew Sullivan
a...@crankycanuck.ca
, and those two platforms are binary
incompatible. The manual actually warns about this.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
; [statement]; COMMIT; one after another, is that as
slow as autocommit? (My bet is yes.)
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
what they have if they were able to is slim.
So you aren't afraid your users are going to take this code, but you
want to put (relatively meaningless) protection in place anyway?
I guess maybe the security definer functions might help you.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent
pretty serious doubts you're going to
do better. Why do these two completely different styles of
interaction need to be merged anyway? I think adding forum traffic to
the mailing list will be yet another way to make the lists less
useful.)
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via
of interaction commensurate.
I don't feel strongly about any of this, note, and I'm sure not
willing to do any work. I'm merely observing that there are at least
spokes of this wheel that have been invented before.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list
connection? This sounds like under 8.0 you were
closing the connection (thereby ending a session), but that under 8.4
your connection isn't actually closing (so your session remains open,
so the temp table hangs around).
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing
something you can
calculate from other data you have.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
. Other than putting a quit inside a cfquery tag?
Is it possible that the older driver closed automatically?
Anyway, you could set a savepoint, try to create the temp table, and
then rollback to savepoint if it doesn't work or else continue if it
does.
A
--
Andrew Sullivan
Features once its
compatibility mode has been turned off. (This is at least true in my
experience. Not saying it's the cause of the present issue, though.)
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
, you have to manage that
yourself.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
priority for yourself. This is a community project, so if you think
this is an important thing from which the community could benefit,
you could volunteer to make it happen.
Best regards,
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general
one column and only 4 rows)
What new feature of Postgres 8.4 would be making the query run so much more
slowly? Is there a better way to rewrite the query for 8.4 to make it run
faster?
Many thanks,
Julie
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list
fooled with the system catalogues instead.)
You can use the replication_role control to prevent triggers firing.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
that you've done and then try something (and pursue
alternatives depending on whether you get an error), use a savepoint.
See
http://www.postgresql.org/docs/9.0/interactive/tutorial-transactions.html
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general
sharp corners it works.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, Mar 11, 2011 at 12:44:24PM -0500, runner wrote:
16 Mb is too small for our instalation.
How do you know that? (I can think of cases where this is true, but
it's rarer than you may think and it has some nasty side effects.)
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via
that it is.
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
/sql-insert.html, but
that example uses SELCT *. Perhaps an additional example would have
helped? (This is basic SQL, though, and I'm not sure the keyword
manual is the best place for such an example.)
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql
101 - 200 of 720 matches
Mail list logo