At 05:06 PM 10/29/03 +, Edwin Quijada wrote:
wHAT IS unconstrained varchar???
Define the column as just varchar. This allows a string of any
length. Then have a trigger truncate it after it is inserted.
--- Adam Kavan
--- [EMAIL PROTECTED]
---(end of broadcast
a way I can reorder the database without doing a
CLUSTER? It stops all insertions into the table and takes several minuets
during which time a large backlog builds up. Or should I be using some
other method of speeding up the table?
--- Adam Kavan
--- [EMAIL PROTECTED
. Anyone know what I am missing?
CREATE OR REPLACE RULE "set_changed" AS ON UPDATE TO "GameInformation"
WHERE NEW."Changed" =FALSE DO UPDATE "GameInformation" SET "Changed" = TRUE
WHERE "Location" = NEW."Location" AND "ID" =
dit your postgres.conf file and lower the
cost for a random tuple, etc.
--- Adam Kavan
--- [EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
stgreSQL was that?
On Matthew's advice I've posted my problem to Hackers.
--- Adam Kavan
--- [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
and calle = 'MALABIA' and puerta = 10
I think its because lid and puerta are int2's and 457 and 10 are
int4's. Try lid = '457'::int2 and puerta = '10'::int2. To use an index
the variables have to match types exactly.
--- Adam Kavan
--- [EMAIL PROTECT
At 09:41 PM 9/2/03 -0400, Matthew T. O'Connor wrote:
On Tue, 2003-09-02 at 20:40, Adam Kavan wrote:
> And there is the problem, all of the counts stay at 0 no matter what I do.
OK, so why is this happening... a bug in the stats system? Ignoring
pg_autovaccu, what numbers do you get from t
counts stay at 0 no matter what I do.
--- Adam Kavan
--- [EMAIL PROTECTED]
pg_autovacuum.out.bz2
Description: Binary data
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column&#
ched.
Thank you very much for taking the time to look at this for me.
--- Adam Kavan
--- [EMAIL PROTECTED]
pg_autovacuum.out.bz2
Description: Binary data
---(end of broadcast)---
TIP 8: explain analyze is your friend
do what you want to do with a column
default. Instead you want to look at the rewrite rules. You can find
information about them here:
http://www.postgresql.org/docs/7.3/interactive/sql-createrule.html
If I'm wrong I'm sure someone here will correct me :).
--- Adam Kavan
---
> Alvaro Herrera Munoz <[EMAIL PROTECTED]> writes:
> > On Wed, Jul 30, 2003 at 01:03:55PM -0500, Adam Kavan wrote:
> >> I have found the problem (I think) below is the list of all the locks
> >> pending on the relation. The relation is a hash index on the table
th
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, July 30, 2003 9:25 AM
Subject: Re: [GENERAL] Postgres Hanging on Inserts
> Adam Kavan <[EMAIL PROTECTED]> writes:
> > I lo
12 matches
Mail list logo
