Greetings!
I apologize if this has been previously posted..
I run a server with multiple clients running databases on one server,
and I was wondering if there was a way to limit the list all databases
function within the pgsql program to only list databases within a
criteria, say, what they hav
Hi,
I'm am having real problems restoring a database which uses tsearch2.
I've followed the dump/restore notes in the tseach2 documents. After
much fiddling, I have managed to restore the database. However, as soon
as I call a SP which updates a table which uses ts_vector. I get the
following err
Mike,
I think the problem is that tsearch2 is referenced by your SP (stored procedure)
and your SP should be recreated *after* tsearch2 installed because functions
are referenced by OID and your SP try to lookup tsearch2 functions
using old OID.
Oleg
On Tue, 23 Mar 2004, Mike Bell wrote:
On Tue, Mar 23, 2004 at 08:32:30 -0300,
Ricardo Vaz Mannrich <[EMAIL PROTECTED]> wrote:
> Both indexed...
>
> But... When I try EXPLAIN SELECT * FROM detail WHERE master_id = XX;
> PostgreSQL uses seq scan (why?)
This has been discussed many times previously and if you want to understand
wh
I am trying to find
a way of performing something similar to the SQL-Server SQL of
IF NOT EXISTS
(SELECT id FROM a_table WHERE id='akey')
THEN INSERT INTO
a_table (id, name) values ('akey', 'adetails');
On Tue, Mar 23, 2004 at 16:41:40 -,
Rob Anderson <[EMAIL PROTECTED]> wrote:
> I am trying to find a way of performing something similar to the SQL-Server SQL of
>
> IF NOT EXISTS (SELECT id FROM a_table WHERE id='akey')
> THEN INSERT INTO a_table (id, name) values ('akey', 'adetails');
INS
Justin Camp wrote:
> Greetings!
>
> I apologize if this has been previously posted..
>
> I run a server with multiple clients running databases on one server,
> and I was wondering if there was a way to limit the list all databases
> function within the pgsql program to only list databases with
Oleg,
Thanks for your suggestion but I'm not sure how this will help. The
function is created _after_ the tsearch installation (script below). I'm
backing up on one machine and trying to restore to another.
Cheers
Mike
#!/bin/bash
createdb cms
psql cms < /var/lib/pgsql/backups/globalobjects.sq
Is there a way to temporarily disable a trigger without dropping and
re-adding it?
Thanks,
Chuck
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Charles Haron wrote:
> Is there a way to temporarily disable a trigger without dropping and
> re-adding it?
You can update the sytem tables by setting the number of triggers to
zero on the table. See the PostgreSQL cookbook for examples. We have a
TODO item to get this implemented cleanly.
--
How can i view the list of processes running in
postgresql.. is there any command for that??
Any help is appreciated.
Thanks
Priya
__
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html
ps -eaf | grep postgres | grep -v idle (the last grep will get the actual command, and
not the idle connection)
If you have the stats_command_string enabled, you can also do a
$echo "select * from pg_stat_activity" | psql dbname
Thanks,
Anjan
-Original Message-
From:
I'm not sure of the correct protocol for getting things on the "todo"
list. Whom shall we beg?
At 10:13 AM 3/22/2004, Mark M. Huber wrote:
>That sounds like a brilliant idea, who do we say it to make it so?
>
>Mark H
>
>-Original Message-
>From: Naomi Walker [mailto:[EMAIL PROTECTED]
>
Naomi Walker wrote:
>
> I'm not sure of the correct protocol for getting things on the "todo"
> list. Whom shall we beg?
>
Uh, you just ask and we discuss it on the list.
Are you using INSERTs from pg_dump? I assume so because COPY uses a
single transaction per command. Right now with pg_du
We have a similarly sized database and we went with schemas. We did
something different, though, we created one schema that contained all
of the tables (we used the public schema) and then created the hundreds
of schemas with views that access only the related rows for a
particular schema. S
>And we also created rules to allow update, delete, and insert on those
>views so that they looked like tables. The reason we did this is
>because we ran into issues with too many open files during pg_dump when
>we had thousands of tables instead of about 1 hundred tables and
>thousands of vie
16 matches
Mail list logo
