On Fri, Apr 20, 2007 at 06:08:36PM +0930, Shane Ambler wrote:
> If you do want 2 versions installed (both in different prefix dirs) at
> the same time then you probably want to make sure that your shell $PATH
> setting includes the path to the newer version of psql and then specify
> the full p
Karsten Hilbert wrote:
Does "psql --version" match "select version()"? There's a message in
the archive pgsql-bugs where this happened.
That was indeed part of the trouble:
Both 7.4.16 and 8.1.8 being installed on Debian I couldn't
get the default psql be 8.1 despite using
update-alternatives
On Fri, Apr 20, 2007 at 12:40:45PM +1000, Klint Gore wrote:
>> I can't spot the trouble with this function definition:
...
>> PostgreSQL 8.1.8 (Debian/Etch) is telling me:
Actually, Lenny.
>> psql:dem-identity.sql:43: ERROR: unterminated dollar-quoted string at or
>> near "$null_empty_title$
>>
On Thu, 19 Apr 2007 23:45:47 +0200, Karsten Hilbert <[EMAIL PROTECTED]> wrote:
> I can't spot the trouble with this function definition:
>
> create function dem.trf_null_empty_title()
> returns trigger
> language plpgsql
> as $null_empty_title$
> begin
> if (NEW.title is nu
Works for me on both 8.1 and 8.2. What client are you using?
John
On Apr 19, 2007, at 5:45 PM, Karsten Hilbert wrote:
I can't spot the trouble with this function definition:
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
Karsten Hilbert wrote:
> Hi all,
>
> I can't spot the trouble with this function definition:
>
> create function dem.trf_null_empty_title()
> returns trigger
> language plpgsql
> as $null_empty_title$
> begin
> if (NEW.title is null) then
> return NEW;
>
