Re: New ID - Mailing list pgsql-novice

From Josh Berkus
Subject Re: New ID
Date
Msg-id web-694343@davinci.ethosmedia.com
Whole thread Raw
List pgsql-novice
Brian,

> Anyway, I found out with pgaccess that my sequence id that increments
>  the
> record id is called phpgw_notes_note_id_seq so my SQL statement was
> SELECT CURRVAL( "phpgw_notes_note_id_seq" )
>
> and the error I got was
> failed : Attribute 'phpgw_notes_note_id_seq' not found
>
> Any ideas?

SINGLE quotes, Brian.  Not double quotes.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

pgsql-novice by date:

Previous
From: arifin purba
Date:
Subject: Re: Peer authentication problem in CGI-Perl
Next
From: "Rob Arnold"
Date:
Subject: Re: Function Hangs