On Saturday 05 Jul 2003 7:16 pm, Tom Lane wrote:
> Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
> > These warnings still come under some mysterious
> > circumstances with PostgreSQL 7.3.3 .
> >
> > is it worth investigating ,
>
> Yes.
It is the same problem , and below is the reply you gave
f
Dilan Arumainathan wrote:
I am trying to migrate a database from Oracle to Postgresql. I am using the
PgAdmin database migration wizard (1.5.60-Dev) to do this. Using ODBC I am
able to migrate small tables but I have a few tables that have over 10
million rows that are failing. I know the reason a
Hi everybody,
maybe you have followed the tread before about migratiing from Oracle
to Postgres. In there I quoted a Document from Oracle called
"Oracle Concepts". In there, Oracle explains exactly, what goes on
under the hood of Oracle.
(Like How they handle concurrency, locking...)
Is there such
PostgreSQL version 7.3.3
With reference to pl/pgsql functions.
I can declare a function to return an array type and I get no complaints when
defining or executing it.
I can declare a variable within the function as an array type and I don't get
any complaints defining or executing the function.
Wh
Hi!
I could not able to take total backup of my database:
uname -a:
Linux mail 2.4.18-3 #1 Thu Apr 18 07:37:53 EDT 2002 i686 unknown
select version(); :
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
pg_dump command:
pg_dump -d base -Fc -Z9 -b -v -f base.dmp
pg_dump abort with
I am trying to find the differences between 7.3.2 and
7.3.3. Where is the link containing this information?
Thanks.
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
---(end of broadcast)---
Donald Fraser wrote:
Could someone be please inform me what the correct syntax for accessing arrays
is or tell me if its not possible with pl/pgSQL functions.
It won't work in 7.3.x or before, as you've noted. In 7.4 this will work:
CREATE OR REPLACE FUNCTION test_arrays() RETURNS int4[] AS '
DECL
Many thanks for clearing that one up.
I have avoided using arrays for the mean time and gone for the more elegant
solution of using an additional table. More flexible and powerful but, in the
simple case that I needed, meant more work... Roll on 7.4 !
Regards
Donald Fraser.
- Original Message
"Donald Fraser" <[EMAIL PROTECTED]> writes:
> CREATE OR REPLACE FUNCTION test_arrays() RETURNS int4[] AS '
> DECLARE
> test int4[];
> BEGIN
> test[1] := 1;
> RETURN test;
> END ' LANGUAGE 'plpgsql';
> If I try to execute this function I get:
> WARNING: plpgsql: ERROR during compile o
Sergio Pili <[EMAIL PROTECTED]> writes:
> pg_dump abort with this error:
> pg_dump: dumpBlobs(): error reading large object: ERROR: cannot read block
> 6389 of pg_largeobject_loid_pn_index: Input/output error
> This error is caused by bad block on my hard drive?
Looks like it.
> How can i do t
Hello,
When I attempt to run "createlang plperlu test" I get the following error.
ERROR: stat failed on file '$libdir/plperl': No such file or directory
createlang: language installation failed
I assuming that this error is because I didn't provide the configure
option --with-perl.
If simply d
I was trying to do something like this.
Select Field1, Field2, Total
FROM
(Select Field1, Field2, SUM(Field3) as Total
From TableA
Where DateHired <= CAST('08/01/2003' AS DATE)
GROUP BY Field1) as MyTable;
The sub-select query tested alone returns me a lot of rows,
howeve
I executed the same query on a command line console and it worked
I think the problem is that I'm using EMS PostgreSQL Manager and
it does not return me anything from the SQL Editor.
Thank you for the help.
MAGO
---Mensaje original---
De: Rafael de Almeida Balthazar
Fecha: Jue
On Thu, Jul 17, 2003 at 09:14:19 -0700,
P G <[EMAIL PROTECTED]> wrote:
> I am trying to find the differences between 7.3.2 and
> 7.3.3. Where is the link containing this information?
http://developer.postgresql.org/docs/postgres/release-7-3-3.html
---(end of broadcast)-
Hi,
I have about 15 different PC's running RedHat 7.3 Linux, each running the
same database backed application (I use Postgresql 7.2.1 for the database)
on each machine.
The application essentially stores files on each of the PC's and the database
on each machine stores information relevant
>
> ERROR: stat failed on file '$libdir/plperl': No such file or directory
> createlang: language installation failed
Locate the file plperl.so and create the language with appropriate -L
option. Moreover, it may be solved by re-compiling. Before re-compling
instead of blindly giving --with-per
16 matches
Mail list logo
