Re: how do the pro's do this? (still a newbie)
От | Gunnar Lindholm |
---|---|
Тема | Re: how do the pro's do this? (still a newbie) |
Дата | |
Msg-id | 01110309360802.11809@fire обсуждение исходный текст |
Ответ на | Re: how do the pro's do this? (still a newbie) (Martijn van Oosterhout <kleptog@svana.org>) |
Ответы |
Re: how do the pro's do this? (still a newbie)
|
Список | pgsql-general |
On Saturday 03 November 2001 09:32, you wrote: > On Sat, Nov 03, 2001 at 08:34:37AM +0100, Gunnar Lindholm wrote: > > I wrote a function similar to this and when inserting > > select foo('/new.html','194.165.2.24','2001-Oct-28 10:34:25+01'); > > it complains that > > ERROR: Attribute 'vad_seq' not found > > "vad_seq" is a sequence just like "something" is in the example above. > > The code I wrote is written below... So if anybody can tell me what's > > wrong, please do so. I find the error message very strange. I can't > > believe that it can not find the sequence.... Shouldn't the sequence be > > accessible from every function in that database? > > Well, my only suggestion is: > > ivad := nextval("vad_seq"); > > ^^^^^^^^^ > > Should the name be in single quotes? Then I get this error... ERROR: parser: parse error at or near "vad_seq" so there is something I've done wrong, but I can't see....
В списке pgsql-general по дате отправления: