Re: [GENERAL] BLOBs, pg_dump pg_restore

2003-10-02 Thread Howard Lowndes
On Thu, 2 Oct 2003, Tom Lane wrote: Howard Lowndes [EMAIL PROTECTED] writes: On Wed, 1 Oct 2003, Tom Lane wrote: No, because pg_restore has logic to adjust the references to match the new BLOB OIDs. If you have a test case where this fails to work, let's see it ... No, I don't have

Re: [GENERAL] Can anyone recommend a good PostGres admin tool?

2003-10-02 Thread Thierry Missimilly
I've try the trail version of PostgreSQL Manager by EMS http://www.ems-hitec.com/pgmanager . But it is not free but not very expensive (aboot 200$). It is a good tools. I've try PgAdmin III on Windows 2000 . It's very good and free. http://www.ems-hitec.com/pgmanager You should get both and see

RE : [GENERAL] Is the use of array as PL/PGSQL function arguments ?

2003-10-02 Thread Bruno BAGUETTE
CREATE OR REPLACE FUNCTION myownfunction(members.id%TYPE[], events.id%TYPE) RETURNS BOOLEAN AS ' You can certainly use arrays as arguments, but I don't think you can combine %TYPE with [] like that. Thanks Tom for the information ! :-) When I create functions with %TYPE, PostgreSQL

[GENERAL] Type of application that use PostgreSQL

2003-10-02 Thread My Internet
Hello, I am in the process to define if our product can use PostgreSQL. Do you know what type of application use PostgreSQL, and also what is the size of the database for these projects? Our application has a table with more than 30 rows. There are complexe query with many joins. And we

Re: [GENERAL] Type of application that use PostgreSQL

2003-10-02 Thread Richard Huxton
On Thursday 02 October 2003 09:10, My Internet wrote: Hello, I am in the process to define if our product can use PostgreSQL. Do you know what type of application use PostgreSQL, and also what is the size of the database for these projects? Everything from small-business apps (which I use

Re: [GENERAL] Can anyone recommend a good PostGres admin tool?

2003-10-02 Thread Martin Marques
El Jue 02 Oct 2003 04:24, Thierry Missimilly escribió: I've try the trail version of PostgreSQL Manager by EMS http://www.ems-hitec.com/pgmanager . But it is not free but not very expensive (aboot 200$). It is a good tools. I've try PgAdmin III on Windows 2000 . It's very good and free.

Re: [GENERAL] BLOBs, pg_dump pg_restore

2003-10-02 Thread Doug McNaught
Howard Lowndes [EMAIL PROTECTED] writes: OK, I'm convinced, except for one small, but not insignificant hiccup. When you dump a database with the BLOBs, even with the -c option, and then restore that database again with the -c option, you get double the BLOBs. The original BLOBs are there

[GENERAL] Adding missing FROM-clause entry in subquery

2003-10-02 Thread btober
I run the following script to export some data from my development database and then update or insert the records into to the quality assurance testing database, but I get a warning notice that I don't understand. Aside from that notice, the script appears to work as intended, i.e., updating

Re: [GENERAL] BLOBs, pg_dump pg_restore

2003-10-02 Thread Howard Lowndes
On 2 Oct 2003, Doug McNaught wrote: Howard Lowndes [EMAIL PROTECTED] writes: OK, I'm convinced, except for one small, but not insignificant hiccup. When you dump a database with the BLOBs, even with the -c option, and then restore that database again with the -c option, you get double

[GENERAL] return next in recursive function

2003-10-02 Thread Petr Bravenec
I have found that when I use the RETURN NEXT command in recursive function, not all records are returned. The only records I can obtain from function are records from the highest level of recursion. Does exist some work-around? Thanks Petr Bravenec example: create table foo ( uid int4,