Hi,
I would like recreate all indexes on a database, the command reindex
is exclusive lock on table so I prefer the method drop index and
create index. Is there a script for extract the command for the create
index? I see pg_dump but it extract all object definitions. I see the
source of pgAdmin f
On Tue, Jul 22, 2008 at 1:39 AM, Giovanni Nervi
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> I would like recreate all indexes on a database, the command reindex
> is exclusive lock on table so I prefer the method drop index and
> create index. Is there a script for extract the command for the create
> ind
Hi everybody.
Well... I have a problem when trying to install and use an ISpell
dictionary (the Thai one to be more precise) with the tsearch feature.
_What I am trying to do_
I have a table containing a "title" field, and I want to fill a "vector"
field with the following command:
*UPDATE t
Hi,
is it possible to make a SELECT query with some nasty follow up commands,
which damages the database.
Something like:
SELECT *,(DROP DATABASE enterprise) AS roger FROM sales WHERE sales >
(UPDATE order SET order=1);
I know this wont work, but is there some possibility to modify databas
am Tue, dem 22.07.2008, um 12:50:31 +0300 mailte Teemu Juntunen folgendes:
> Hi,
First, don't hijack other threads!
>
> is it possible to make a SELECT query with some nasty follow up commands,
> which damages the database.
>
> Something like:
>
> SELECT *,(DROP DATABASE enterprise) AS roge
Daniel,
early versions of tsearch doesn't support directly OpenOffice dictionaries.
Oleg
On Tue, 22 Jul 2008, Daniel Chiaramello wrote:
Hi everybody.
Well... I have a problem when trying to install and use an ISpell dictionary
(the Thai one to be more precise) with the tsearch feature.
_Wh
I've been able to find a couple of packages, but wondering if there is
a good system out there what will create an ER diagram of an existing
PostgreSQL DB. Open source would be nice.
Thanks.
--
Brandon
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to yo
On Tue, 22 Jul 2008, Brandon Metcalf wrote:
I've been able to find a couple of packages, but wondering if there is
a good system out there what will create an ER diagram of an existing
PostgreSQL DB. Open source would be nice.
I use dbwrench.com. It's not opensource, but is inexpensive and ha
Brandon Metcalf, 22.07.2008 12:36:
I've been able to find a couple of packages, but wondering if there is
a good system out there what will create an ER diagram of an existing
PostgreSQL DB. Open source would be nice.
Thanks.
Try Power*Architect, so far the best open source solution I have se
I have done some research recently and found on acceptable:
- DBdesigner4, which is depreceated and replaced by MySQL workbench. Is
OSS, but no linux version yet. Also has clunky pgsql support
- Aqua data studio (www.aquafold.com). It's java app which I am using for
some time already. Origin
In response to "Teemu Juntunen" <[EMAIL PROTECTED]>:
> Hi,
>
> is it possible to make a SELECT query with some nasty follow up commands,
> which damages the database.
>
> Something like:
>
> SELECT *,(DROP DATABASE enterprise) AS roger FROM sales WHERE sales >
> (UPDATE order SET order=1);
>
Hello.
Have I an opportunity to get working dll using MSVC2005 (full edition) for
compilation at all?
I just tried to compile the following code. This is full text. Project options
are below in the letter.
-
#include "postgres.h"
#include "fmgr.h"
#include
b == [EMAIL PROTECTED] writes:
b> I've been able to find a couple of packages, but wondering if there is
b> a good system out there what will create an ER diagram of an existing
b> PostgreSQL DB. Open source would be nice.
Thanks for all that have responded so far. I'm looking at
Power*Arch
On Tue, Jul 22, 2008 at 12:20:46PM +0200, A. Kretschmer wrote:
> > is it possible to make a SELECT query with some nasty follow up commands,
> > which damages the database.
> >
> > Something like:
> >
> > SELECT *,(DROP DATABASE enterprise) AS roger FROM sales WHERE sales >
> > (UPDATE order S
My server is rebooted infrequently, usually after a kernel upgrade and
on very rare occasions when something causes it to hang. After rebooting I
always have serious issues getting postgresql running again, even though the
startup script is part of the boot sequence. Yesterday was one of those
h
Rich Shepard <[EMAIL PROTECTED]> writes:
>My server is rebooted infrequently, usually after a kernel upgrade and
> on very rare occasions when something causes it to hang. After rebooting I
> always have serious issues getting postgresql running again, even though the
> startup script is part o
On Tue, 22 Jul 2008 05:36:39 -0500 (CDT)
"Brandon Metcalf" <[EMAIL PROTECTED]> wrote:
> I've been able to find a couple of packages, but wondering if there
> is a good system out there what will create an ER diagram of an
> existing PostgreSQL DB. Open source would be nice.
For reverse engineeri
>
> Did you actually give a "bt" command, or was that
> just the initial
> output from gdb?
>
Yeah I used the bt command, which gave exactly the same output as the initial
output. However you'll have to bear with me here, as I am new to gdb, so there
is the possibility I'm just not doing thin
Glyn Astill <[EMAIL PROTECTED]> writes:
> I've just recompiled again after configuring with --enable-debug, and for
> completeness here's all the output from gdb:
> # gdb
> /usr/pgsql_src/postgresql-8.3.3/src/test/regress/tmp_check/install/usr/local/pgsql/bin/initdb
> core
Well, there's part o
On Tue, Jul 22, 2008 at 5:36 AM, Brandon Metcalf <[EMAIL PROTECTED]> wrote:
> I've been able to find a couple of packages, but wondering if there is
> a good system out there what will create an ER diagram of an existing
> PostgreSQL DB. Open source would be nice.
PostgreSQL Autodoc: http://www.r
Hi,
I am trying to create a PL/PGSQL function to return the values of the
fields in a record, e.g. 1 value per row in the output of the function.
How do you substitute a variable?
Test case:
CREATE TABLE test(col1 text, col2 text, col3 text, col4 text, col5 text,
col6 text, col7 text, col8
> Well, there's part of your problem: the program that is
> crashing is not
> initdb. Specify the postgres executable, instead. Note
> the
>
> > warning: core file may not match specified executable
> file.
> > Core was generated by
> `/usr/pgsql_src/postgresql-8.3.3/src/test/regress/tmp_check/i
minor refinement on suggestion:
-- CTAS (create table as) is easiest way to create table with same
structure
create table foo as select * from orig_table;
-- truncate is much more efficient than delete
truncate orig_table;
-- unchanged
insert into orig_table select * from foo;
-- recompute statist
el dorado wrote:
Have I forget some important option? Or I can't use the FULL version for
compilation at all - only express edition?
They use the same compiler, and will produce compatible object code, so
the full or express editions will be fine.
By the way - there is a directory 'D:\pgs
On Tue, 22 Jul 2008, Tom Lane wrote:
The short answer is probably "don't use Slackware's startup script". Some
distros have PG start scripts that have had the bugs beaten out of them,
and others not so much.
Excellent advice, Tom. I'll take it.
Have you read the script to see what conditio
It *may* be because I'm using psql 8.0.3 and not the latest version (but
I'm stucked with that version), i'm just hoping that one of you have met
Upgrade to 8.0.17 - there was a several fixes in ISpell code.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
And which are the types of argument and returning values of a pl/sql
function which preprocess de text?
I have been searching that, for example, something like this works fine:
CREATE INDEX textindex ON document USING
gin(to_tsvector('english',upper(text)));
where text is the text column of docu
> The only
> thought that
> comes to mind is that the branch is being attempted but
> there's garbage
> at InitializeGUCOptions+1092 ? Try "x/32i
> InitializeGUCOptions+1092"
>
> What ulimit settings are operative anyway? (ulimit -a
> might tell you)
>
(gdb) x/32i InitializeGUCOptions+1092
0x75
>
> The stack size rlimit looks normal, which makes a crash in
> this spot
> look even less probable. I think maybe you are looking at
> a stale
> corefile that doesn't quite correspond to this postgres
> executable.
>
You are correct. I just checked and the core file was created on the 18th, t
Rich Shepard <[EMAIL PROTECTED]> writes:
>I tried following the logic, and it appears the issue now is 'invalid data
> in PID file "/var/lib/pgsql/data/postmaster.pid" '. If I delete that file,
> is it automatically recreated? I'm using /usr/bin/pg_ctl as user postgres.
If you're certain there
Glyn Astill <[EMAIL PROTECTED]> writes:
>> What ulimit settings are operative anyway? (ulimit -a
>> might tell you)
> deb:/usr/pgsql_src/postgresql-8.3.3/src/test/regress# ulimit -a
> core file size (blocks, -c) 0
Hmm, are you sure the core actually corresponds to your failure?
Because
On Tue, 22 Jul 2008, Tom Lane wrote:
If you're certain there's no postmaster running, it's safe to remove
postmaster.pid. However you really shouldn't have to; the postmaster is
generally able to figure out whether a pidfile is live or not.
Tom,
I thought the postmaster knew what was curren
> I tried following the logic, and it appears the issue now is 'invalid data
> in PID file "/var/lib/pgsql/data/postmaster.pid" '. If I delete that file,
> is it automatically recreated?
Why not just move it and rename it? If it's recreated, great; if not,
you still have the corrupted file on ha
Hello,
I'm developing a autocomplete Feature using php and PostgreSQL 8.3.
To fill the autocomplete box I use the following SQL Statement:
select * from _table_ where upper( _field_ ) like '%STRING%';
This SQL Statement takes 900 ms on a Table with 300.000 entries.
What can I do to speed up the
Glyn Astill <[EMAIL PROTECTED]> writes:
> And, the instruction pointer info:
> (gdb) x/i $pc
> 0x7572d0 :
> beqzv0,0x75748c
Huh. The pc could possibly be a bit off from reality in this type of
error, but none of the instructions immediately around it look like they
could be making a
...resending, email didn't go through.
On Tue, Jul 22, 2008 at 1:02 PM, Bill Wordsworth
<[EMAIL PROTECTED]> wrote:
> Is this recommended?
>
> pg_query("begin transaction read write;", $connection);
> if(pg_transaction_status($connection) == 2) {
>pg_query("insert...;", $connection);
>
On 23/07/2008, Rich Shepard <[EMAIL PROTECTED]> wrote:
> When I run the Slackware script, '/etc/rc.d/rc.postgresql start' (script
> attached), I'm shown a process ID and told the daemon is already running.
> For example:
Since there are no official Slackware postgres packages
I'd like to ask w
On Tue, 22 Jul 2008, Brandon Metcalf wrote:
Thanks for all that have responded so far. I'm looking at
Power*Architect which looks very cool and is Open Source.
I looked in vain at this very question recently. Power*Architect was nice,
but didn't seem to be able to display updates to the diag
Is this recommended?
pg_query("begin transaction read write;", $connection);
if(pg_transaction_status($connection) == 2) {
pg_query("insert...;", $connection);
pg_query("insert...;", $connection);
pg_query("insert...;", $connection);
}
pg_query("commit transaction;", $conne
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stefan Sturm
Sent: Tuesday, July 22, 2008 11:31 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Optimizing a like-cause
Hello,
I'm developing a autocomplete Feature using php and PostgreSQL 8.3.
To fi
On Tuesday 22 July 2008, Stefan Sturm <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I'm developing a autocomplete Feature using php and PostgreSQL 8.3.
> To fill the autocomplete box I use the following SQL Statement:
> select * from _table_ where upper( _field_ ) like '%STRING%';
>
> This SQL Statement
>
> Hello,
>
> I'm developing a autocomplete Feature using php and PostgreSQL 8.3.
> To fill the autocomplete box I use the following SQL Statement:
> select * from _table_ where upper( _field_ ) like '%STRING%';
>
> This SQL Statement takes 900 ms on a Table with 300.000 entries.
>
> What can
Rich Shepard <[EMAIL PROTECTED]> writes:
> On Tue, 22 Jul 2008, Tom Lane wrote:
>> The "invalid data" bit is interesting though. It looks like pg_ctl would
>> produce that error if the pidfile exists but is empty when it looks. This
>> seems like a race condition hazard, though the odds of hittin
On Wed, 23 Jul 2008, Andrej Ricnik-Bay wrote:
Since there are no official Slackware postgres packages I'd like to ask
where that script came from :) and how you installed postges in the first
place. Happy to communicate of the list if you prefer that.
Andrej,
Unless others consider this to
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dann Corbit
Sent: Tuesday, July 22, 2008 1:30 PM
To: Stefan Sturm; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Optimizing a like-cause
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
"Dann Corbit" <[EMAIL PROTECTED]> writes:
>>> I'm developing a autocomplete Feature using php and PostgreSQL 8.3.
>>> To fill the autocomplete box I use the following SQL Statement:
>>> select * from _table_ where upper( _field_ ) like '%STRING%';
>>> This SQL Statement takes 900 ms on a Table with
On 12:33 am 07/22/08 Steve Martin <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am trying to create a PL/PGSQL function to return the values of the
> fields in a record, e.g. 1 value per row in the output of the
> function.
Are you trying to do a generic function that would work for any table or
for just
We have contrib/wildspeed extension which uses new partial
match feature of GIN index. See our presentation
http://www.pgcon.org/2008/schedule/events/58.en.html
It index all permutations, so index is very big, but for not
long read-only sstring it works fast.
Oleg
On Tue, 22 Jul 2008, Stefan St
On 6:01 pm 07/21/08 Jack Orenstein <[EMAIL PROTECTED]> wrote:
> to this:
> psql -h $SOURCE_HOST ... -c "copy binary $SOURCE_SCHEMA.$SOURCE_T
> ABLE to
> stdout" |\
> psql ... -c "copy binary $TARGET_SCHEMA.$TARGET_TABLE from stdin"
http://www.postgresql.org/docs/8.3/interactive/sql-copy.html
Here is an example
CREATE FUNCTION dropatsymbol(text) RETURNS text
AS 'select replace($1, ''@'', '' '');'
LANGUAGE SQL;
arxiv=# select to_tsvector('english',dropatsymbol('[EMAIL PROTECTED]'));
to_tsvector
-
'oleg':1 'sai.msu.su':2
On Tue, 22 Jul 2008, Fco. Mario
On 23/07/2008, Rich Shepard <[EMAIL PROTECTED]> wrote:
> Andrej,
Hi Rich,
> Unless others consider this topic to be not appropriate for the list, I
> don't mind a public conversation. I thought that I attached the script to
> my original message; regardless, here's the attribution:
You did
On Wed, 23 Jul 2008, Andrej Ricnik-Bay wrote:
Now there's an interesting piece of information :) How long
ago did you upgrade it?
Andrej,
A month ago; June 17th to be exact.
From which version of pg to which version did you upgrade,
From 8.1.13 to 8.3.3.
and how did you go about i
On Tue, 2008-07-22 at 18:05 -0700, Rich Shepard wrote:
> On Wed, 23 Jul 2008, Andrej Ricnik-Bay wrote:
>
> > Now there's an interesting piece of information :) How long
> > ago did you upgrade it?
>
> ... something broke during the reboot. From /var/log/postgresql:
>
> FATAL: database file
Bill Wordsworth wrote:
> ...resending, email didn't go through.
>
> On Tue, Jul 22, 2008 at 1:02 PM, Bill Wordsworth
> <[EMAIL PROTECTED]> wrote:
>> Is this recommended?
>>
>> pg_query("begin transaction read write;", $connection);
>> if(pg_transaction_status($connection) == 2) {
>>pg_quer
You can do it in straight sql like so.
SELECT (array[col1, col2, col3, col4, col5, col6, col7, col8, col9, col10])[i]
FROM test t, generate_series(1,10) i
Art
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/ma
55 matches
Mail list logo
