Trying again, since it appears that my mail never reached the list...
Original Message
Subject: Logging prepared statements in 8.1?
Date: Wed, 23 Nov 2005 07:32:37 +0100
From: Bjørn T Johansen <[EMAIL PROTECTED]>
To: pgsql-general@postgresql.org
I am upgrading from 7.4 to 8.1 an
I am upgrading from 7.4 to 8.1 and there seems to have been a change in how
postgresql log prepared
sql statements.. Before I could see the actual statements (i.e. after every
parameters had been
changed with real values) but now I see the sql statements before the change
(i.e with $1, $2 as
par
Dear all,
I've written a bash script that looks like the one below:
#!/bin/bash
DBuser='root'
DBname='test'
psql -q --username=$DBuser --dbname=$DBname -c "prepare test_statement
(integer) as insert into tbl_test (col_test) values (\\$1)";
tail -f /root/testfile | while read a;
do
Hi,
I'm on PG 8.0.4, initDB and locale set to de_DE.UTF-8, FreeBSD.
My TSearch config is based on "Tsearch2 and Unicode/UTF-8" by Markus
Wollny (http://tinyurl.com/a6po4).
The following files are used:
http://hannes.imos.net/german.med [UTF-8]
http://hannes.imos.net/german.aff
On Tuesday 22 November 2005 21:45, Rick Schumeyer wrote:
> Is there something in tsearch2 that prevents more than one index per table?
>
> I would like an index on field A, and a separate index on field B.
>
> The index builds fine for A, but gives an error for B. The error text is
>
>
>
> ERROR:
On Wed, Nov 23, 2005 at 10:38:03AM +0100, A.j. Langereis wrote:
> Dear all,
>
> I've written a bash script that looks like the one below:
> Note that this is very stripped version of the real script, but it gives the
> same errors:
>
> ERROR: prepared statement "test_statement" does not exist
Another UTF-8 thing I forgot:
fts=# SELECT * FROM stat('SELECT to_tsvector(''simple'', line) FROM fts;');
ERROR: invalid byte sequence for encoding "UNICODE": 0xe2a7
The query inside the stat() function alone works fine. I have not set
any client encoding. What breaks it? It works as long the
On Tue, 22 Nov 2005, Andrew J. Kopciuch wrote:
This is not a problem with the index creation ... your tsearch2 installation
is not configured for the locale your server is running.
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html
See the section "TSEARCH2 CONFI
Tsearch/isepll is not able to break this word into parts, because of the
"s" in "Produktion/s/intervall". Misspelling the word as
"Produktionintervall" fixes it:
It should be affixes marked as 'affix in middle of compound word',
Flag is '~', example look in norsk dictionary:
flag ~\\:
[^S]
I am running PostgreSQL 8.1 on Windows
Server 2003. Our setup should allow a normal (non-administrator) user to
start the database. Since the user is not allowed to start services, I
am trying a direct "pg_ctl start" approach. However, running
this from a shortcut, leaves a dos window open with th
On Wed, 23 Nov 2005, Hannes Dorbath wrote:
Hi,
I'm on PG 8.0.4, initDB and locale set to de_DE.UTF-8, FreeBSD.
My TSearch config is based on "Tsearch2 and Unicode/UTF-8" by Markus Wollny
(http://tinyurl.com/a6po4).
The following files are used:
http://hannes.imos.net/german.med [U
Dear Martijn,
The problem with your solution is that the script is meant to process a
log-file real-time.
Therefore the insert should be done immediately, however it is the same
statement over and over agian, just with different parameters i.e. an ideal
case fore PREPARE.
Yours,
Aarjan Langereis
> I am running PostgreSQL 8.1 on Windows Server 2003. Our setup
> should allow a normal (non-administrator) user to start the
> database. Since the user is not allowed to start services, I
> am trying a direct "pg_ctl start" approach. However, running
> this from a shortcut, leaves a dos window
On Wed, Nov 23, 2005 at 12:07:01PM +0100, A.j. Langereis wrote:
> Dear Martijn,
>
> The problem with your solution is that the script is meant to process a
> log-file real-time.
> Therefore the insert should be done immediately, however it is the same
> statement over and over agian, just with dif
Script Head wrote:
I am a newbie to the stored proc. game and this is eating my brain.
The error message is accurate but not useful...
CREATE TABLE name(first VARCHAR(32) NULL,last VARCHAR(32) NULL, extra
VARCHAR(32) NULL );
CREATE OR REPLACE FUNCTION update_name() RETURNS opaque AS '
I apologize if I'm being dense, but I'm not completely following the
explanation. It is true that my pg_ts_cfg.locale is set to en_US.UTF-8.
It was my understanding that specifying "default" as in
UPDATE t SET idxB=to_tsvector('default', b);
should give tsearch enough information.
It is not cl
On Wed, 23 Nov 2005, Rick Schumeyer wrote:
I apologize if I'm being dense, but I'm not completely following the
explanation. It is true that my pg_ts_cfg.locale is set to en_US.UTF-8.
It was my understanding that specifying "default" as in
UPDATE t SET idxB=to_tsvector('default', b);
should
"Magnus Hagander" <[EMAIL PROTECTED]>
wrote:
> > 1) Users *can* start and stop services, if you just give them
> > permissions to do so. This can be done on an individual service
basis.
> > You use the security configuration editor for that.
Thanks for the hint. I've found how to do that at:
http
On Wednesday 23 November 2005 06:55, Rick Schumeyer wrote:
> I apologize if I'm being dense, but I'm not completely following the
> explanation. It is true that my pg_ts_cfg.locale is set to en_US.UTF-8.
>
> It was my understanding that specifying "default" as in
>
That takes the locale that is s
> I agree that the "processing database" message isn't too exciting, but
> it seems that forcing per-table messages up to LOG level would create
> even more log clutter. I could support "processing table" at level
> DEBUG1 and "processing database" at DEBUG2. Or maybe we should think
> harder abo
> FWIW, people generally refer to that as 'loading data'; I've never heard
> of 'upsizing' before, which is why I was somewhat confused.
I'm sorry.
I defined upsizing as creating new postgres database from some other
database data.
Google search for upsize returns the titles :
Upsize your Acces
On top of that... "name" is a postgreSQL internal data type --
essentially -- you need to treat it as if it is an SQL "reserved word"
Therefore::I strongly recommend that you name your table something other
than "name"... for the same reasons you wouldn't name a table "select" (the
example
I need to start Postgres 8.1 database in XP without any user intervention
even when Postgres is not installed.
I have implemented this for Apache2 by running the following commands:
Apache.exe -k stop
Apache.exe -k uninstall
Apache.exe -k install
Apache.exe -k start
@rem if user has no privi
Andrus wrote:
How to force Postgres to install itself as service running under SYSTEM or
under LOCAL SERVICE account?
You can download the source, take out the check for non-administrator
accounts and recompile.
The core developers have made it pretty clear that they don't hold with
runnin
My primary question: is this the correct interest list for questions
about installation? I'll stop there until someone confirms for me that
I'm doing the right thing -- if you would be so kind, please cc me at my
email since I'm not signed up to receive interest-list messages...
Thanks -
Gary
On Wed, 2005-11-23 at 12:39, Gary Horton wrote:
> My primary question: is this the correct interest list for questions
> about installation? I'll stop there until someone confirms for me that
> I'm doing the right thing -- if you would be so kind, please cc me at my
> email since I'm not signed
> This causes Apache to run under SYSTEM account .
>
> Trying to use same approach with Postgres fails. Postgres
> requires special user account and is not capable to create
> this account without user intervention.
Sure, it's very much capable of diong that. See
http://pginstaller.projects.pos
Scott Marlowe wrote:
On Wed, 2005-11-23 at 12:39, Gary Horton wrote:
My primary question: is this the correct interest list for questions
about installation? I'll stop there until someone confirms for me that
I'm doing the right thing -- if you would be so kind, please cc me at m
Evandro's mailing lists (Please, don't send personal messages to this
address) wrote:
Yes it is exactly that. I will follow you advice and create a
abstraction layer for the data access that will return the sparse
dataset using the standard dataset as input.
There is just one thing I disagre
Thanks, Wes. Yes, we know about this Sol-10/PG thing, and eventually we
hope to leverage it...but we also have customers with sol-8 and sol-9
that we can't assume will migrate to sol-10, so unfortunately we have
to deal with both situations.
-gh
Wes Williams wrote:
FYI Gary, if ca
Hi,
I just had this error in my database:
bugasbase2=# SELECT count(*) from mba_data_base;
ERROR: invalid page header in block 597621 of relation "mba_data_base"
Any ideas whats going on? Am a bit worried as this is my production
database.
Thanks for any assistance
Adam
--
This message ha
Adam Witney <[EMAIL PROTECTED]> writes:
> bugasbase2=# SELECT count(*) from mba_data_base;
> ERROR: invalid page header in block 597621 of relation "mba_data_base"
Sounds like a data corruption problem :-(. Do you want to pull out that
page and see what's in it? Something like
dd bs=8k
In PL/pgSQL the round() function seem to round a number down all the
time. Is there something like ceil() that would round it up?
ScriptHead
Script Head wrote:
> In PL/pgSQL the round() function seem to round a number down all the
> time. Is there something like ceil() that would round it up?
>
> ScriptHead
Yup, it's called ceil(). Oh! You just said that ;)
Can also use ceiling()
--
___
This e-mail may
On 23/11/05 8:55 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Adam Witney <[EMAIL PROTECTED]> writes:
>> bugasbase2=# SELECT count(*) from mba_data_base;
>> ERROR: invalid page header in block 597621 of relation "mba_data_base"
>
> Sounds like a data corruption problem :-(. Do you want to pull o
Adam Witney <[EMAIL PROTECTED]> writes:
> Thanks for the help Here is the output:
> [EMAIL PROTECTED]:/opt$ dd bs=8k skip=7 count=1 if=134401991.4 | od -x
> 000
> *
> 001 1d9e 201c 0fa0 0010 000b
> 0010020 0ca6 19fb 1797 0ab4 0
On 23/11/05 9:36 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Adam Witney <[EMAIL PROTECTED]> writes:
>> Thanks for the help Here is the output:
>
>> [EMAIL PROTECTED]:/opt$ dd bs=8k skip=7 count=1 if=134401991.4 | od -x
>> 000
>> *
>> 001 1d
Adam Witney <[EMAIL PROTECTED]> writes:
> This table is only ever COPY'd to from data files, no updates or deletes, if
> I could find out which data file this bit comes from I could just reupload
> that file... Is it possible to tell what the data actually is from the data
> I sent?
You might try
On 23/11/05 9:55 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Adam Witney <[EMAIL PROTECTED]> writes:
>> This table is only ever COPY'd to from data files, no updates or deletes, if
>> I could find out which data file this bit comes from I could just reupload
>> that file... Is it possible to tell
Bob Pawley wrote:
> Bruno
>
> The table I previously sent came through distorted and probabley
> caused misunderstanding.
>
> The table control and auto_control are both permanent table. I want to
> reshuffle how the information is associated from one table to another
> with the link between tabl
Adam Witney <[EMAIL PROTECTED]> writes:
> Whats the best way to zero the bad block?
Probably dd from /dev/zero, along the lines of
dd bs=8k seek=597621 count=1 conv=notrunc if=/dev/zero of=relation
(check this before you apply it ;-)). You probably should stop the
postmaster while doing
Guy
Sorry about the chart. It held together when I sent it to myself.
I'll try to make it clear in the way you suggest, by a truncated example.
Create table control (device_id serial, type varchar, association int4)
Create table auto_control (loop_id serial, monitor int4, valve int4)
Hi Everyone Please any one provide me the details of creating dblink ibetween two server n postgress. Regards Asfar
To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre.
I am not really sure wether I MUST use it or not, but I think it is a
nice feature to be utilized.
What I want is a long running producing up to hundred of thousands
results which have to undergo a computationally expensive
postprocessing step which needs to be execeuted in parallel. By using
pipe
I suggest you look at PostGIS to store 2D & 3D geometric (spatial) data,
it may solve some of your problems
You can store a vertical line as a well, and segments of that line which
represent the layers you are describing.
Brent Wood
On Tue, 22 Nov 2005, Dennis Veatch wrote:
> On Tuesday
Hi,
I have just today installed the new version of PostgreSQL (8.1.0),
and my old code seems to have stopped working.
I am basically trying to delete a row from a table:
DELETE FROM "CON" WHERE "ref"='CON5';
I have checked and CON5 is definitively in the CON table. I tried
using JDBC, pgA
On Wednesday 23 November 2005 17:15, Brent Wood wrote:
> I suggest you look at PostGIS to store 2D & 3D geometric (spatial) data,
> it may solve some of your problems
>
> You can store a vertical line as a well, and segments of that line which
> represent the layers you are describing.
>
> Bren
Janet Bagg wrote:
> Please could somebody give me advice on settings for PGSQL with a database
> with UTF-8 strings in a large number of languages? I've had no problems so
> far in storing/retrieving UTF-8 strings but can't find clear answers to
> other issues.
>
> What locale would be best for s
I often get private requests from users for answers to questions.
Instead of replying with the answer, I send this reply, which I keep in
a file that can be easily included in an email message. The only
replies I have gotten to it are thanks (no complaints). Feel free to
use this idea for privat
Is there any way to get pg_dump to run a statement before dumping?
I'd like to do something like
pg_dump -a -c "create temp table params as select * from params where
key=blah;" -d dev_db -t params -f /svn/db/params.blah
svn commit /svn/db/params.blah
I'd rather avoid doing
psql -c "create tabl
Bruce,
list,
I translated that part to german, I know the source is strong in
Germany - maybe it can be a helpfull addition - even if most speak
English, they are even more happy to read sth. in German.
Harald
Due to time constraints, I do not directly answer general PostgreSQLquestions. For a
51 matches
Mail list logo
