Kevin,
it looks like you use UTF-8, so the problem in .aff file, which contains
cyrillic comments :) I converted files into UTF-8 encoding using iconv.
Oleg
On Thu, 3 Apr 2008, Kevin Reynolds wrote:
I'm using Postgresql version 8.3.1 on CentOS 5 and am following the steps in
section 12.7 of
"Joey K." <[EMAIL PROTECTED]> writes:
> So, is it possible to kill a query thats running for x minutes with 50%+ CPU
> load and using y MB of memory?
There's statement_timeout ...
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
On Fri, Apr 04, 2008 at 12:02:20PM -0700, Frank Miles wrote:
I have a moderately DB-ignorant question: is there a "built-in" way for an
application to receive the message emitted by a RAISE in a PgSQL function?
Context: I have a moderately complex application (in python, using psycopg2)
Not with 8.3.
I finally did get a few earlier versions to install. I am not very familiar
with windows 2000 administration, so it took some doing ;) Here is what I did
http://archives.postgresql.org/pgsql-general/2008-03/msg00904.php
At that point I stopped looking into version 8.3. Since I wa
Andrus wrote:
I have table
create Document ( docdate date, docorder integer )
I need update docorder column with numbers 1,2 in docdate date order
Something like
i = 1;
UPDATE Document SET docorder = i++
ORDER BY docdate;
How to do this is PostgreSQL 8.2 ?
ALTER TABLE DROP COLUMN docord
Hello,
Is it possible to limit cpu/memory resources to queries on postgres
something akin to limits.conf on Linux?
We have a couple of databases (pg 8.2.7) serving 500K - 1M records. For
various reasons, users are allowed to run queries against the database via a
web based query interface. These
On Thu, Apr 3, 2008 at 2:34 PM, Dan99 <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am having some troubles with a select group of tables in a database
> which are acting unacceptably slow. For example a table with
> approximately < 10,000 rows took about 3,500ms to extract a single row
> using the f
On 4/5/2008 11:02 AM, Glyn Astill wrote:
Hi Jan,
Is that still true for 1.2.12? As that's the version I'm using.. Also any ideas
on where I start to sort it out? I just want to drop the old table now I've
removed it from replication, but the error mentioned previously is stopping me.
Yes, th
Kevin Reynolds <[EMAIL PROTECTED]> writes:
> I get the following error:
> ERROR: invalid byte sequence for encoding "UTF8": 0xe0c020
> HINT: This error can also happen if the byte sequence does not match the
> encoding expected by the server, which is controlled by "client_encoding".
Chad <[EMAIL PROTECTED]> writes:
> export:
> pg_dump forums --data-only --no-owner -t foo >
> The load step seems really slow.
Don't use --data-only. Or if you must, look into dropping and
recreating indexes and foreign keys. See
http://www.postgresql.org/docs/8.3/static/populate.html
(or t
Hi everyone,
I'd like to drop a database to which users have idle connections. I'm
running pgsql 8.2 on win32, soon 8.3, using mod_perl2 and
connect_cached.
I know this issue has been brought up several times over the past few
years, but I don't quite understand the reason for it not being
suppo
Hello,
With the postgresql-8.2-int.msi, i used to do a succesful install with the
following options
BASEDIR=C:\Postgres
DATADIR=D:\PostgresData
INTERNALLAUNCH=1
DOSERVICE=1
CREATESERVICEUSER=1
SERVICEACCOUNT=postgres
SERVICEDOMAIN=%COMPUTERNAME%
SERVICEPASSWORD=123qwe-.
DOINITDB=1 ENCODING
Howdy!
I'm trying to build some fixture (test) data for a webapp I'm building
for my company. To do this I've taken a dump of data from production,
exported it using pg_dump, and load it via psql <
The data that is exported from production is about 25K rows and 12MB.
The dump takes less than a
I'm using Postgresql version 8.3.1 on CentOS 5 and am following the steps in
section 12.7 of the documentation for creating a custom text search
configuration.
When I get to the step that says:
CREATE TEXT SEARCH DICTIONARY english_ispell (
TEMPLATE = ispell,
DictFile = englis
Hi,
I am having some troubles with a select group of tables in a database
which are acting unacceptably slow. For example a table with
approximately < 10,000 rows took about 3,500ms to extract a single row
using the following select statement:
SELECT * FROM table WHERE column = 'value'
I have p
On Apr 3, 9:02 pm, [EMAIL PROTECTED] (Justin) wrote:
> Have a select statement with a where clause using datestamp with
> timezone column compared to a date
>
> Select * from sometable where DateStampColumn > '2008-03-31'
>
> this returns records that are equal 2008-03-31
>
> but when the query inc
Hi all, i'm newby to postgresql: really great product.
I'm trying to understand exactly how to set up WAL archiving.
I read the doc ( by the way i'm running postgresql-8.1.11 ): i need some
explanation on how are created and recycled theWAL bacause i cannot
understand, for example, how is fill
No luck here and can and no one responded to my post. It is a mystery.
did you have any luck?
thx
Ron Tyndall
IT Tools Sr. Systems Analyst
Nortel
[EMAIL PROTECTED]
Office 919-905-2793 ESN 355 2793
-Original Message-
From: Dee [mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2008
I have table
create Document ( docdate date, docorder integer )
I need update docorder column with numbers 1,2 in docdate date order
Something like
i = 1;
UPDATE Document SET docorder = i++
ORDER BY docdate;
How to do this is PostgreSQL 8.2 ?
Andrus.
--
Sent via pgsql-general mailing li
Dear all,
Benetl, a free ETL tool for files using postgreSQL is out, in version 1.7 !!!
It is correcting a trouble with part formula, and brings six new
functionalities.
Benetl is now much more compliant with Linux (should be tested).
It is available at : www.benetl.net
Thanks for your interest
On Friday 04 April 2008 16:36, Tom Lane wrote:
> Terry Lee Tucker <[EMAIL PROTECTED]> writes:
> > I am converting our application from 7.4.19 to 8.3.1. In the old scheme
> > of things, I was generating an interval between two timestamps and
> > evaluating the interval string in another set of trigg
Hi Rusty,
In which case can you not include the text around the schema & table creation
commands to ensure other instances of "public" do not match the string?
I'm not sure exactly what the pg_dump output contains, but you could use
something like:
cat pg_dump.sql | sed 's/CREATE SCHEMA "publi
Stephan Szabo wrote:
On Sat, 5 Apr 2008, Tom Allison wrote:
If it doesn't remove the 8.2 then I guess I can migrate it.
But that requires that I still need to get 8.2 running.
Right now it complains that it can't find a listening socket at /tmp/...
(localhost mode). And I can't find the conf
On Sat, 5 Apr 2008, Tom Allison wrote:
> If it doesn't remove the 8.2 then I guess I can migrate it.
> But that requires that I still need to get 8.2 running.
>
>
> Right now it complains that it can't find a listening socket at /tmp/...
> (localhost mode). And I can't find the configuration file
If it doesn't remove the 8.2 then I guess I can migrate it.
But that requires that I still need to get 8.2 running.
Right now it complains that it can't find a listening socket at /tmp/...
(localhost mode). And I can't find the configuration files in this set-up.
I do have this running:
/opt
On Sat, 5 Apr 2008, Tom Allison wrote:
> I ran into a problem today where somewhere my port of postgresql82 just
> stopped working. I'm largely an idiot on Mac because I use is as a
> workstation/development box and do most of the real system related work
> on my debian boxes.
>
> But I don't kno
> I am still trying to figure out if the database was getting any
> automatic vacuuming at all. The Postgres documentation (the database is
> 8.2, though I'm moving to 8.3 soon) sounds as if it's on automatically,
> but the Debian-specific documentation suggests I may need to do some
> additi
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> what type is new.ontime ?? timestamp or interval. I would expect it
> to be an interval. But intervals are either negative or positive, not
> "ago" unless that's something peculiar to 7.4 that I've long since
> forgotten.
No, it's still around:
re
Hi Jan,
Is that still true for 1.2.12? As that's the version I'm using.. Also any ideas
on where I start to sort it out? I just want to drop the old table now I've
removed it from replication, but the error mentioned previously is stopping me.
Thanks
- Original Message
> From: Jan Wi
On 4/5/2008 7:47 AM, Glyn Astill wrote:
Hi chaps,
I know there's been a bit of "activity" on this listrecently - but does anyone
know where I should start looking to resolvethe below?
Yes, a "SET DROP TABLE" is mandatory prior to dropping the table itself.
This is because up to version 1.2.x
On Sat, Apr 5, 2008 at 4:05 PM, Pavel Stehule <[EMAIL PROTECTED]> wrote:
> Hello
>
>
>
>
> On 05/04/2008, Guillaume Bog <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > I'm writing a trigger in pl/pgSQL and I'd like to pass one column name as
> > argument to the trigger function.
> >
> > Provided my
Hi Brent,
It's not he best solution, because we could have fields containing
"public" in their names and sed would happily change those to test1 as
well.
I'm looking for a safer solution, thats why it should be a part of
pg_dump.
Rusty
On Apr 5, 2008, at 12:41 AM, Brent Wood wrote:
H
I ran into a problem today where somewhere my port of postgresql82 just
stopped working. I'm largely an idiot on Mac because I use is as a
workstation/development box and do most of the real system related work
on my debian boxes.
But I don't know how to get the port working again.
Then I sa
Hi chaps,
I know there's been a bit of "activity" on this listrecently - but does anyone
know where I should start looking to resolvethe below?
- Original Message
> From: Glyn Astill <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-general@postgresql.org
> Sent: Friday, 4 April,
On Sat, 5 Apr 2008, Pedro Doria Meunier <[EMAIL PROTECTED]> writes:
> The record being created has a column with an Id that has to be passed as an
> argument to the function that, in turn, fills the other column in the same
> record.
Doesn't BEFORE INSERT/UPDATE trigger solve this problem? (If n
Pavel and Volkan
Thank you for your kind (and prompt) replies.
Let me try to better explain my needs:
The record being created has a column with an Id that has to be passed as an
argument to the function that, in turn, fills the other column in the same
record.
Does this even make sense? :)
K
On Sat, 5 Apr 2008, Pedro Doria Meunier <[EMAIL PROTECTED]> writes:
> Is it possible to have a table's column default value set to some form of
> select?
AFAIK, you cannot provide sub-selects in the default values of a
field. E.g.
CREATE TABLE foo (bar int DEFAULTS (SELECT ...), ...);
For thi
Hello
On 05/04/2008, Pedro Doria Meunier <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is it possible to have a table's column default value set to some form of
> select?
>
directly no, but you can use function
postgres=# create table a(a integer);
CREATE TABLE
postgres=# create function mx() returns
Hi,
Is it possible to have a table's column default value set to some form of
select?
e.g. picking another table's value for a given SELECT ... WHERE ...
Already thankful for any insight,
--
Pedro Doria Meunier
Ips. da Olaria, Edf. Jardins do Garajau, 4, r/c Y
9125-162 Caniço
Madeira - Portuga
On 04/04/2008 05:43 PM, mark wrote:
stats with new settings are below..
These stats look good for me.
but even with this sometimes update queries take more than coupla
seconds sometimes...
checkpoint_completion_target = 0.8
It looks like that this is set too high for your workload. If y
Hello
On 05/04/2008, Guillaume Bog <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I'm writing a trigger in pl/pgSQL and I'd like to pass one column name as
> argument to the trigger function.
>
> Provided my table has only one column named 'id', I can do easilly
>
> CREATE FUNCTION ft() RETURNS trigger A
Troy Rasiah schrieb:
Apologies if this has been posted somewhere else but what is the
equivalent of perl's \b in postgres regular expressions ?
I think you are looking for \m and \M.
See
http://www.postgresql.org/docs/8.3/interactive/functions-matching.html#FUNCTIONS-POSIX-REGEXP
Ciao,
Thom
Hello,
I'm writing a trigger in pl/pgSQL and I'd like to pass one column name as
argument to the trigger function.
Provided my table has only one column named 'id', I can do easilly
CREATE FUNCTION ft() RETURNS trigger AS $$
BEGIN
RAISE NOTICE 'It works:%', OLD.id;
END
$$ LANGUAGE plpgsql;
43 matches
Mail list logo