Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> On Thu, May 06, 2004 at 09:02:21PM -0400, Tom Lane wrote:
>> Doubtless you could do it. The problem with the idea is that those
>> inference tests are pretty expensive.
> Is it really that expensive?
I'm afraid it would be. You're correct tha
[EMAIL PROTECTED] (Jared Evans) writes:
> I will be installing Debian distro soon at my company. I'll be
> storing critical data and am wondering if I should go with stable 7.2
> version or use the 7.4 version (for all the latest features and bug
> fixes). I'm currently doing the research for the
On Thu, May 06, 2004 at 09:02:21PM -0400, Tom Lane wrote:
> Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> > I can't see why this wouldn't work.
>
> Doubtless you could do it. The problem with the idea is that those
> inference tests are pretty expensive. I think that any such thing would
Razvan Surdulescu <[EMAIL PROTECTED]> writes:
>>> cspan=> update contact set gender = 'M';
>>> ERROR: cache lookup failed for function 70529
>>> The database has a few GIST (full-search, tsearch2) indices, but
>>> otherwise is pretty ordinary.
>> Any of those on "contact"?
> Yes, one of them, se
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bastian,
warum die Tabelle nicht so aufbauen:
create table jadajada (
internal_number serial primary key,
nr int4,
testdaten varchar(254)
);
die "internal_number" wird dann automatisch von postgres vergeben. Dann kannst
du
Kevin DeGraaf <[EMAIL PROTECTED]> writes:
> Restoring from [ajp.tar] ...
> pg_restore: [archiver (db)] could not execute query: ERROR:
> permission denied to create database
> Given that (a) I'm using PGUSER=postgres and (b) my pg_hba.conf should be
> sufficiently liberal anyway, I'm wonderi
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> I can't see why this wouldn't work.
Doubtless you could do it. The problem with the idea is that those
inference tests are pretty expensive. I think that any such thing would
waste significant numbers of cycles on ordinary queries while only b
Bastian
you are misunderstanding the difference between the "row
number" (there is no such thing inherent in relational
databases) and the primary key (or any other explicitely
numbering column).
The "row number" would be moving when deleting some records --
if it existed. It doesn't exist, howev
On Tue, Apr 20, 2004 at 01:06:18AM -0400, Tom Lane wrote:
> 3. I have noticed that bouncing any machine that sends "HELO
> sss.pgh.pa.us" gets rid of a ton of spam and viruses. I don't know of
> any real clean way to do this, but I have a sendmail.cf hack for it.
By the way, thanks very much for
Hello all,
I will be installing Debian distro soon at my company. I'll be
storing critical data and am wondering if I should go with stable 7.2
version or use the 7.4 version (for all the latest features and bug
fixes). I'm currently doing the research for the management here.
I have checked t
On Thu, 6 May 2004, Alvaro Herrera wrote:
> Do any of you have ICQ or some other IM so we can inspect the problem
> more closely? I'm ICQ 57064581 and [EMAIL PROTECTED] on Jabber. I'm
> hesitant to post several message headers on the list.
Actually, a trace of the Received headers for one of the
On Thu, May 06, 2004 at 08:30:55PM -0300, Marc G. Fournier wrote:
>
> Joshua and I checked things over, and we can't find any errors on his side
> to indicate a problem with their servers :( And I checked through the log
> files on the postgresql.org server itself, and nadda there ... is it
> poss
Dardo D Kleiner - CONTRACTOR said:
> http://c-jdbc.objectweb.org/
If you're not using java, this may be an interesting alternative solution
which was recently announced (on this list). It seems to meet quite a few
of your requirements.
John Sidney-Woollett
pgpool 1.0, yet another open source re
Hallo Uwe,
zunächst einmal danke für die schnelle Antwort und den Tipp meine
Anfrage auf Englisch zu stellen. Ich werde das beim nächsten Mal
berücksichtigen.
Zum Problem: Wenn ich die Datensätze eindeutig identifiziere, kann ich
das Problem nicht beheben.
Beispiel:
Ausgangstabelle:
Nr date
Eric Ridge <[EMAIL PROTECTED]> writes:
> Using PG 7.3.x, how stupid is this:
> UPDATE pg_attribute SET atttypmod= WHERE ;
It'll work okay for a varchar column (not char) at least as far as the
table itself is concerned. I think there are some issues for views
referencing the column, pos
Using PG 7.3.x, how stupid is this:
UPDATE pg_attribute SET atttypmod= WHERE ;
I had to do this on a database, and surprisingly it seems to have
worked just fine. The columns accept a larger value, the existing
values are still intact, and I've seen no other strange errors...
Am I l
Steve Atkins wrote:
On Fri, Apr 30, 2004 at 01:17:16PM -0400, CS Wagner wrote:
What I would most desire is a program that pretends to be a postgres
server. I can log into it with psql, a jdbc driver, or php's
pg_connect. When I do a select (no update) command, it will send that
off to the leas
17 matches
Mail list logo
