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
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
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
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
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
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
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
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
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.
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)
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
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
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
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: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:
> 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 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
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
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
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
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
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
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
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
> 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
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
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
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
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
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
> 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
> 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
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
"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 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
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
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 '
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
> 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
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
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
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
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]
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
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 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
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:
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
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
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
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
51 matches
Mail list logo