I'm upgrading our database from 8.4 to 9.2 and I've run across a view that is
no longer working. When selecting from the view, I get a permission denied
error on one of the referenced tables. However, I can run the view's query
directly without problems and I have read access to all the
. I can do another
pg_restore and see if the problem is reproducible if you want.
On Aug 13, 2013, at 12:03 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Brian Hirt bh...@me.com writes:
I'm upgrading our database from 8.4 to 9.2 and I've run across a view that is
no longer working. � When selecting
Dear all,
2 days ago, I need to backup 2 databases in my Database server because I need
to format the system and reinstalls again with the back up databases.
After a fresh install of ubuntu-10.4 , I install postgreplus-8.4 binary and I
think giving the previous data directory
On Mar 13, 2011, at 12:05 PM, Dmitriy Igrishin wrote:
Hey Viktor,
2011/3/13 Viktor Nagy viktor.n...@toolpart.hu
hi,
when trying to insert a long-long value, I get the following error:
index row size 3120 exceeds maximum 2712 for index ir_translation_ltns
HINT: Values larger than 1/3
Is it possible to reference the old values in a statement trigger using
plpgsql? I'm looking for something similar to NEW and OLD that row triggers
have, but I don' see anything @
http://www.postgresql.org/docs/current/static/plpgsql-trigger.html which
doesn't really offer any examples for
Thanks Josh,
On Oct 21, 2010, at 7:49 AM, Josh Kupershmidt wrote:
2010/10/21 Grzegorz Jaśkiewicz gryz...@gmail.com:
OLD.column_name
NEW.column_name ?
I believe OP is asking specifically about statement-level triggers. As
Yup.
the docs
There are only two tables in the query.
Tim,
No, your query is written incorrectly. I don't understand why you come on to
this list all hostile and confrontational. Regardless, people still try to
help you and then you still ignore the advice of people that are giving you the
solutions
Evan,
Others can probably answer your question better about copying, but in general
we never do that but I think if you use the same arch and major release of
postgresql you will be okay.
We have used Slony successfully for all of our database upgrades, server
maintenance and database moves
Yes, we've used Slony for migrating 8.2 - 8.3 - 8.4 and plan an using it to
migrate to 9.0 in the near future. You should be able to skip releases as well
like you say 8.2 - 8.4.
You'll probably want to test out both slony and 8.4 on your development
machines first and make sure everything
| company_history
(22 rows)
On Sep 28, 2010, at 10:51 AM, Tom Lane wrote:
Brian Hirt bh...@me.com writes:
I'm testing pg_upgrade out and ran into a couple of problems. First when I
did pg_upgrade --check I got the tsearch2 tables preventing the upgrade from
happening:
Database
Is there some standard way postgresql parses integer strings? Maybe that
method should be used instead of duplicating the functionality so at least the
two behave consistently.
--brian
On Sep 28, 2010, at 2:00 PM, Bruce Momjian wrote:
Brian Hirt wrote:
Looks like pg_upgrade is using 32bit oids
Bruce,
The applied patch has the same behavior on i686 Ubuntu 10.04. It looks like
atol() is just a macro for strtol() in stdio.h. I think you want strtoul()
instead of strtol()
when i change str2uint() to use strtoul() pg_upgrade completes without a
problem (I still haven't tested the
I'm testing pg_upgrade out and ran into a couple of problems. First when I
did pg_upgrade --check I got the tsearch2 tables preventing the upgrade from
happening:
Database: testdatabase
public.pg_ts_dict.dict_init
public.pg_ts_dict.dict_lexize
public.pg_ts_parser.prs_start
I have some data that can be searched, and it looks like the parser is making
some assumptions about the data that aren't true in our case and I'm trying to
figure out how to exclude a token type. I haven't been able to find the
answer to my question so far, so I thought I would ask here.
, Tom Lane wrote:
Brian Hirt bh...@mobygames.com writes:
For example instead of the parser recognizing three asciiword it recognizes
one asciiword and one file. I'd like a way to have the / just get parsed
as blank.
AFAIK the only good way to do that is to write your own parser
I'd check in with you.
Regards,
Brian Hirt
Postgres Version 8.2 and 8.3
test=# select show_trgm('魔法門英雄無敵2:王位爭奪戰');
show_trgm
---
{ 2, 2 }
(1 row)
Postgres Version 8.4
test=# select show_trgm('魔法門英雄無敵2:王位爭奪戰
I'm a bit baffled by this, i can't drop a table and I'm getting the
most bizarre message that doesn't make sense to me. To make things
worse, I was able to drop it on my test database which is a dump of
my production database running the same version of postgresql.
The index it's
insert into blah_stats select id,count(*) from blah where id = 1 group
by id
COMMIT WORK
Regards,
Brian Hirt
---(end of broadcast)---
TIP 8: explain analyze is your friend
Joe,
I've run into this on my ibook too. The default number of files is
set very low by default. On my system 10.3.2, it's 256 for the
postgres user. You can raise it to something higher like 2048 with
the ulimit command. i have ulimit -n unlimited in my .bash_profile
ibook:~ root# su
On Feb 10, 2004, at 10:57 AM, Tom Lane wrote:
Hmm, I hadn't even thought about ulimit. I thought those settings were
per-process, not per-user. If they are per-user they could be
problematic.
not sure if it's per user or per process. after i did ulimit -n
unlimited the problem joe describes
mirror? We have a 10mbit/sec connection, but probably wouldn't
want postgresql to take up more than 1mbit/sec on average. we also
have several free gigabytes of disk.
Best Regards,
Brian Hirt
On Dec 24, 2003, at 4:46 PM, Dave Page wrote:
It's rumoured that Brian Hirt once said:
What type
Bruce,
for what it's worth, Matthew O'Connor submitted a patch which includes
my patch.
best regards,
Brian Hirt.
On Nov 29, 2003, at 10:14 PM, Bruce Momjian wrote:
[ Attachment, skipping... ]
---(end of broadcast)---
TIP 7: don't forget
I'm looking to find out how many rows were effected during an update in
a trigger. I ran across this message by jan talking about this feature
possibly being added to postgresql 6.5, but I can't find any reference
to such a feature in the current documentation. Did this ever make it
into
I got an error doing a vacuum analyze on one of our table:
MSG: 7 (S1000): ERROR: simple_heap_update: tuple concurrently updated
does anyone know what this means, and more importantly... should i be worried about this?
i'm running 7.3.2 on redhat 7.3 dual 1.8 xeon with 1gb ram.
is it possible that there are spaces on the end? what type is
stck_sym? if it's varchar or text the padding won't be removed
automatically.
example:
basement=# create table test (t varchar(6));
CREATE TABLE
basement=# INSERT into test values( 'ZRAN ');
INSERT 92249850 1
basement=# select *
How do you deal with backing up the images? Right now i can remote
backup my filesystem using rsync to an offsite location many times a
day, only taking a very small amount of I/O, bandwidth and time.
Dealing with the backup scared me away from using postgres in the first
place. The idea
I just wanted to let the developers know, i'm VERY IMPRESSED with the
7.4b1 release. I've been using it exclusively on my two development
machines since it was released without any problems at all. I was
also using cvs on and off for a while before the beta.
my development machines are an
I have a table with about 1 million rows in it. One of the columns in this
table is some sort of status (it's an int2). Out of the million rows, only
about 100 of the rows have a status that is not like the rest.
for example:
999,900 have the value 1
23 have the value 2
on game_developer
(cost=0.00..80.87 rows=48 width=46)
- Original Message -
From: Doug McNaught [EMAIL PROTECTED]
To: Brian Hirt [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; Brian A Hirt [EMAIL PROTECTED]
Sent: Sunday, September 30, 2001 7:36 PM
Subject: Re: [GENERAL] question about indexing.
Brian Hirt
29 matches
Mail list logo