Skip site navigation (1) Skip section navigation (2)

my schema + sql function

From: Marek "Wrbel" <netim(at)icentrum(dot)pl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: my schema + sql function
Date: 2003-02-18 08:40:31
Message-ID: 20030218084031.24027.qmail@icentrum.pl (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi,

In my schema : "my" I create sql function

CREATE OR REPLACE FUNCTION my.my_foo(int4) RETURNS varchar AS '
    select k.k_dupa ||coalesce( '' ['' || k.k_number || '']'' ,'''')
    from kont k
    where k_id = $1;
' LANGUAGE 'sql';

table kont is in schema public.

Everythink working ok, but when I try to restore backup system write :

pg_restore: [archiver (db)] could not execute query: ERROR:  Relation "kont" does not exist
pg_restore: *** aborted because of error


Marek Wróbel



	
>From pgsql-bugs-owner(at)postgresql(dot)org  Tue Feb 18 13:56:02 2003
X-Original-To: pgsql-bugs(at)postgresql(dot)org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id C96B347580B
	for <pgsql-bugs(at)postgresql(dot)org>; Tue, 18 Feb 2003 13:56:01 -0500 (EST)
Received: from mail.gmx.net (mail.gmx.net [213.165.65.60])
	by postgresql.org (Postfix) with SMTP id EC12B475458
	for <pgsql-bugs(at)postgresql(dot)org>; Tue, 18 Feb 2003 13:56:00 -0500 (EST)
Received: (qmail 5899 invoked by uid 0); 18 Feb 2003 18:55:59 -0000
Received: from p3E990A98.dip0.t-ipconnect.de (62.153.10.152)
  by mail.gmx.net (mp002-rz3) with SMTP; 18 Feb 2003 18:55:59 -0000
Date: Tue, 18 Feb 2003 20:06:11 +0100 (CET)
From: Peter Eisentraut <peter_e(at)gmx(dot)net>
X-X-Sender: peter(at)peter(dot)localdomain
To: Brian Catlin <BrianC(at)sannas(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Windows binaries for 7.3.2?
In-Reply-To: <001b01c2d625$f66cba90$c301a8c0(at)tyrannosaurus>
Message-ID: <Pine(dot)LNX(dot)4(dot)44(dot)0302182005540(dot)1644-100000(at)peter(dot)localdomain>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/84
X-Sequence-Number: 5500

Brian Catlin writes:

> The Windows binaries for 7.3.2 are not on the FTP site.  Where can I get
> them?

http://www.cygwin.com

-- 
Peter Eisentraut   peter_e(at)gmx(dot)net


Responses

pgsql-bugs by date

Next:From: Phillip C.DibnerDate: 2003-02-19 00:30:02
Subject: MacOS X build --with-pam - bad directory for pam_appl.h
Previous:From: Regan, KevinDate: 2003-02-17 19:45:41
Subject: Re: Problem with configure script in 7.3.2.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group