Re: [GENERAL] item descriptions in psql

> Hi, > > I just found a reference to descriptions to functions/tables/...etc. > and am now wondering how to add them myself? > > Joost Roeleveld not sure if there is a shortcut to this (it's short enough already): INSERT INTO pg_description (objoid, description) SELECT oid, 'your descripti

[GENERAL] Re: [INTERFACES] Announce: PostgreSQL-6.5.3 binaries available forWindows NT

Tusar wrote: > Does the binary contain sql server with it? Sure. Please run "psql -h hostName template1". > Tusarkanti Nayak > @Communicators > Phone: 91 - 11 - 5535770(O) > Phone: 91 - 11 - 5613992(O) > Phone: 91 - 11 - 5528098(R) > Fax: 91 - 11 - 5613991 > URL: http://tusar.netshooter.com > M

Re: [GENERAL] Index pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (1071)ISNOT THE SAME AS HEAP' (1070)

Bruce Momjian wrote: > > > Bruce Momjian wrote: > > > > > > Anyone seen this message or know what it means? > > > > > > > > NOTICE: Index pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (1071) IS > > > > NOT THE SAME AS HEAP' (1070) > > > > > > Drop index and recreate. Next release will be more s

Re: [GENERAL] item descriptions in psql

"Gene Selkov, Jr." wrote: > > > Hi, > > > > I just found a reference to descriptions to functions/tables/...etc. > > and am now wondering how to add them myself? > > > > Joost Roeleveld > > not sure if there is a shortcut to this (it's short enough already): > > INSERT INTO pg_description (objo

[GENERAL] getting user-list

Hi, I would like to know if, and how, I can find out who's logged into the database at any given time. And is it possible to maintain a connection-log of log-ins and log-outs? with kind regards, Joost Roeleveld

[GENERAL] Postgres performance problems.

Hi, We have developed an application using PG 6.5.1, DBI-1.13 and DBD-0.92 with perl5. We have a small db with a query with 5 joins and other smaller singleton selects. Now this query will be executed about 50 times a second. While doing a load test to find performance we find that for 100 para

[GENERAL] Interbase replacement

Hi, We use Postgresql, but we also use Interbase. However, at present there is a question mark over the future of Interbase (the top people have all resigned and we do not yet know what inprise will do with the product, there are rumours it will be dropped). Many users of Interbase are currently

Re: [GENERAL] copy command -- foiled by pg_atoi

Folks-- Thanks for the ideas. But bisection just seemed too cumbersome. In the end I decided to write a data filter in perl which checks all the data for valid types before putting it into the DB! Mike Ed Loehr wrote: > > I have found that judicious placement of a few queries (selects, inten

[GENERAL] creating trigger

Hi all, I'm trying to create a trigger. I created a function which returns a count of the rows. I used this procedure while creating the trigger. But, I get an error stating SQL must return opaque. I tried the same with returning a varchar. I get the same error again. In simple words, I ne

Re: [GENERAL] Getting value of SERIAL column after insert from libpq?

Thanks for the help, it works great! However, there is a problem with performance. I am moving from MySQL to Postgres, and to test performance I am inserting a large row (30 fields) into a table from my C program. I am running this program 50 times, and timing the results. The MySQL version of th

Re: [GENERAL] Getting value of SERIAL column after insert from libpq?

Mark Alliban wrote: > > Thanks for the help, it works great! > > However, there is a problem with performance. > I am moving from MySQL to Postgres, and to test performance I am inserting a > large row (30 fields) into a table from my C program. I am running this > program 50 times, and timing t