Hello,
for dropping all functions within the current schema I use this SQL query:
SELECT DISTINCT 'DROP FUNCTION ' || p.oid::regprocedure::text || ' CASCADE;'
FROM pg_catalog.pg_proc p LEFT JOIN pg_catalog.pg_namespace n ON n.oid =
p.pronamespace WHERE n.nspname = current_schema();
It works
Dear List,
This is my first post, I hope I am asking it on the correct list.
I changed the password for user postgres and I completely forgot about the
previous one.
The main problem is that now the postgres server fails to start when I turn
on the machine.
It used to start automatically.
To
First one, try to paste explain into http://explain.depesz.com/
select
a.id,
ident_id,
time,
customer_name,
extract('day' from timezone(e.name, to_timestamp(a.time))) as day,
category_id
from
pwreport.url_hits a left outer join
pwreport.url_hits_category_jt c on (a.id = c.url_hits_id),
Jan-Peter Seifert wrote:
Hello,
for dropping all functions within the current schema I use this SQL query:
SELECT DISTINCT 'DROP FUNCTION ' || p.oid::regprocedure::text || ' CASCADE;'
FROM pg_catalog.pg_proc p LEFT JOIN pg_catalog.pg_namespace n ON n.oid =
p.pronamespace WHERE
Jan-Peter Seifert jan-peter.seif...@gmx.de writes:
I didn't see any explicit type cast in 8.3 for regprocedure - text. Is there
a way to add it in 8.2?
You can always cast pretty much anything to anything via a variable
assignment in plpgsql...
regards, tom lane
--
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Tom Lane wrote:
Alvaro Herrera alvhe...@commandprompt.com writes:
BTW I notice that this does not work unless the client supplies the
password the first time around; psql does not retry. It only works if I
do psql -W.
Huh, that sounds like a bug someplace. Care to trace through it?
It
Alvaro Herrera alvhe...@commandprompt.com writes:
It had to do with me having a bogus password in .pgpass (so psql was
first trying empty password, then the one in .pgpass, and both failing).
Pilot error. However, I'd say that we ought to give a notice if the
password in .pgpass fails.
Can
When recover a database using a continuous archive backup, i detected some
duplicated keys. This there isn't in the production database.
I use postgres-8.3.5.
anyone know why this happens?
What about the indexes in the slave?
--
Emanuel Calvo Franco
DBA at:
Hi Everybody,
I am interested in following this particular thread,
though, yesterday our mail server went down for a few
hours and I don't have the whole account.
Can somebody please tell me how I could retrieve a
history of this particular thread?
Thank you in advance
Regards,
Tena Sakai
On Thu, 2009-08-20 at 10:31 -0700, Tena Sakai wrote:
Hi Everybody,
I am interested in following this particular thread,
though, yesterday our mail server went down for a few
hours and I don't have the whole account.
Can somebody please tell me how I could retrieve a
history of this
On Thu, Aug 20, 2009 at 10:31 AM, Tena Sakaitsa...@gallo.ucsf.edu wrote:
Can somebody please tell me how I could retrieve a
history of this particular thread?
Generally:
http://archives.postgresql.org/
Specifically:
http://archives.postgresql.org/pgsql-admin/2009-08/msg00056.php
--
Many thanks!
Tena Sakai
-Original Message-
From: Richard Broersma [mailto:richard.broer...@gmail.com]
Sent: Thu 8/20/2009 10:58 AM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Sharing /etc/passwd with PostgreSQL
On Thu, Aug 20, 2009 at 10:31 AM, Tena
Dear all,
I face this problem from last few days.
here is test2 table with only one column id
erp_test= \d test2
Table public.test2
Column | Type | Modifiers
+-+---
id | integer |
I insert 10,000,000 entries in this table.
erp_test= INSERT INTO test2 VALUES
Did you vacuum your table after the delete?
On Thu, Aug 20, 2009 at 2:36 AM, Kumar Anand kumar.an...@merceworld.comwrote:
Dear all,
I face this problem from last few days.
here is test2 table with only one column id
erp_test= \d test2
Table public.test2
Column | Type | Modifiers
VACUUM ANALYZE, rather
On Thu, Aug 20, 2009 at 2:21 PM, bricklen brick...@gmail.com wrote:
Did you vacuum your table after the delete?
On Thu, Aug 20, 2009 at 2:36 AM, Kumar Anand
kumar.an...@merceworld.comwrote:
Dear all,
I face this problem from last few days.
here is test2 table
Oliveiros wrote:
To start it, I have to login as postgres and manually start it with
postgres -D etc.
You should make a backup first (users and databases ...) .
Try unregistering/registering the service with pg_ctl.
First copy the pg_ctl command used during installation from the
service's
It would really be nice if pg_class were altered to add two new columns:
relcreatedat relmoddat.
Both would be of type timestamp. relcreatedat would contain the timestamp the
object was created. Likewise, relmoddat would contain the last timestamp the
object was altered / modified.
This would
19 matches
Mail list logo