From: | Jan Wieck <janwieck(at)yahoo(dot)com> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | Aasmund Midttun Godal <postgresql(at)envisity(dot)com>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: PL/pgSQL examples NOT involving functions |
Date: | 2001-12-05 21:29:04 |
Message-ID: | 200112052129.fB5LT4k02023@saturn.jw.home |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-sql |
Josh Berkus wrote:
> Aasmund,
>
> > envisity=# DROP TABLE temp ;
> > DROP
> > envisity=# create table temp (tempid integer);
> > CREATE
> > envisity=# INSERT INTO temp VALUES(3);
> > INSERT 150371 1
> > envisity=# select test3();
> > ERROR: Relation 150348 does not exist
> > envisity=#
>
> That's a new one on me. I've dropped and re-created dozens of tables,
> and while I have to re-build the views, I've never had to touch the
> functions for that reason. Either in PL/pgSQL or in SQL.
>
> What version are we talking about?
Any version. But a simple reconnect to the database fixes the
problem, because you'll have a new backend and that guy will
of course compile everything on first hit.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2001-12-05 21:44:07 | Re: Cant load pgtclsh library into application |
Previous Message | Jan Wieck | 2001-12-05 21:26:47 | Re: PL/pgSQL examples NOT involving functions |
From | Date | Subject | |
---|---|---|---|
Next Message | Roberto Mello | 2001-12-05 21:54:35 | Re: Getting matching and non-matching results (long) |
Previous Message | Jan Wieck | 2001-12-05 21:26:47 | Re: PL/pgSQL examples NOT involving functions |