Re: [GENERAL] application for postgres Log

2012-09-10 Thread Ireneusz Pluta
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

Re: [GENERAL] pg_class.relnamespace NOT IN pg_namespace.oid

2012-02-28 Thread Ireneusz Pluta
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

Re: [GENERAL] pg_class.relnamespace NOT IN pg_namespace.oid

2012-02-27 Thread Ireneusz Pluta
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

Re: [GENERAL] pg_class.relnamespace NOT IN pg_namespace.oid

2012-02-27 Thread Ireneusz Pluta
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

[GENERAL] pg_class.relnamespace NOT IN pg_namespace.oid

2012-02-27 Thread Ireneusz Pluta
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

Re: [GENERAL] Can we use dblink for insert and update of dynamic values

2011-08-18 Thread Ireneusz Pluta
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

[GENERAL] Timestamp parsing with blanked time part

2011-07-22 Thread Ireneusz Pluta
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

[GENERAL] Timestamp parsing with blanked time part

2011-07-22 Thread Ireneusz Pluta
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

Re: [GENERAL] How to create "auto-increment" field WITHOUT a sequence object?

2011-07-03 Thread Ireneusz Pluta
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

Re: [GENERAL] question about readonly instances

2011-05-18 Thread Ireneusz Pluta
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

Re: [GENERAL] psql problem

2010-07-24 Thread Ireneusz Pluta
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

Re: [GENERAL] Question about SCO openserver and postgres...

2010-07-23 Thread Ireneusz Pluta
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

Re: [GENERAL] Excell

2007-06-20 Thread Ireneusz Pluta
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

Re: [GENERAL] Moving the database from winxp to linux

2007-01-11 Thread Ireneusz Pluta
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

Re: [GENERAL] How to use Php connecting to pgsql

2006-12-29 Thread Ireneusz Pluta
马庆 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