W dniu 2012-09-10 08:19, Arvind Singh pisze:
I need some help or even a simple link that is related to this subject
you might be interested in reading this: http://bucardo.org/wiki/Tail_n_mail
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subs
W dniu 2012-02-27 23:57, Tom Lane pisze:
Hm. We've seen occasional reports of this sort of behavior (that is,
DROP of a schema failing to cascade to all the contained objects) but
never been able to reproduce it. If you do see it happen again, and
can work out a scenario that causes it (even on
W dniu 2012-02-27 23:57, Tom Lane pisze:
One possible theory for cascaded drops to fail like that is that the indexes on pg_depend are
corrupt, so you might want to consider REINDEXing that catalog, just in case.
so before reindexing it would be worth veryfing the theory and check indexes for c
W dniu 2012-02-27 21:59, Tom Lane pisze:
Ireneusz Pluta writes:
It apperas that I have some entries in pg_class that have relnamespace not
appearing in
pg_namespace. So pg_dump fails with "pg_dump: schema with OID 52072764 does not
exist", I guess.
That's a bit disturbing
Hello,
It apperas that I have some entries in pg_class that have relnamespace not appearing in
pg_namespace. So pg_dump fails with "pg_dump: schema with OID 52072764 does not exist", I guess.
Like the schema in question was dropped, but not cascading to all its members?
How to get rid of or f
W dniu 2011-08-18 16:26, Jenish Vyas pisze:
Hi All,
Can we user dblink for insert and update of dynamic values??
Sample function :
CREATE OR REPLACE FUNCTION dblink_test()
RETURNS boolean AS
$BODY$
DECLARE
v1 numeric;
v2 character varying(50);
BEGIN
v1 := 123; v2 := 'asdasdasd';
select
Hi,
consider the following:
select quote_literal(blank_hms) as "quote_literal(blank_hms)", blank_hms::timestamp as
"blank_hms::timestamp" from (select unnest(array['2011-07-22 :', '2011-07-22 : ', '2011-07-22 : :
']::text[]) as blank_hms) a; select version();
quote_literal(blank_hms) | blan
Hi,
consider the following:
select quote_literal(blank_hms) as "quote_literal(blank_hms)", blank_hms::timestamp as
"blank_hms::timestamp" from (select unnest(array['2011-07-22 :', '2011-07-22 : ', '2011-07-22 : :
']::text[]) as blank_hms) a; select version();
quote_literal(blank_hms) | blan
W dniu 2011-06-30 20:20, Dmitry Koterov pisze:
And I need as compact uniq_id generation (with minimum "holes") as it possible - this is a VERY
important requirement (to export these values into external systems which accepts only IDs limited
from 1 to 10).
So I cannot use sequences: sequen
W dniu 2011-05-18 13:21, Szymon Guz pisze:
Hi,
I've got a question about quite a strange configuration.
I was asked if we can have one storage, with one data directory where one postgresql instance
writes data, and many other instances read those.
Is that possible without any replication and co
Gary Fu pisze:
I have a script to create a table with some comments in front. When I
use the command 'psql -f script.sql' to load it, it hangs. However,
if I remove the comments, OR remove some of the columns from the
table, it works okay. It looks like to me, the psql will hang with
lar
Edmundo Robles L. pisze:
On 07/22/2010 05:39 PM, Scott Marlowe wrote:
On Thu, Jul 22, 2010 at 3:24 PM, Edmundo Robles L.
wrote:
Hi!
I have a problem with the max postgres connections on SCO
Openserver 5.0.7, so ...my boss decided to buy the SCO Openserver 6.0
but this vers
Bob Pawley napisał(a):
Thanks
Does one version of ODBC work for all versions of Excel and Postgresql.
I am wanting to transfer one or two tables from Excel and manipulate the
information in Postgresql then transfer the results back to Excel as a
single table.
I am using Excel 2000 and Pos
Tomas Lanczos napisał(a):
Thanks. No complications due the move to the higher version (8.2)?
Tomas
Per usual remarks about upgrading found in installation instructions of
every release, you will need to use pg_dump that comes with the new
version to connect to the old database and run your
马庆 napisał(a):
Dear All:
I come across a problem that I can't solve it, Can anyone help me,
Thanks.
My configuration is RedHat AS4 + php5.0 + pgsql 8.1. When I finish
install php, I install php_pgsql module in order to use php connecting pgsql.
To my surprised , I can't get ac
15 matches
Mail list logo