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
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
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
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
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
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.
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
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
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
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,
10 matches
Mail list logo