agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedcreate: syntax error
2+ messages / 2 participants
[nested] [flat]
* create: syntax error
@ 1994-06-29 15:36 J.Plewe <joerg.plewe@mpi-dortmund.mpg.de>
1994-06-29 17:33 ` Re: create: syntax error avi pfeffer <avi@postgres.Berkeley.EDU>
0 siblings, 1 reply; 2+ messages in thread
From: J.Plewe @ 1994-06-29 15:36 UTC (permalink / raw)
To: legacy
Sigh,
I'm quite new to Postgres and this may be the reason for having
so much problems. Sorry.
Now I failed with a create-statement and don't know why:
/* Definition der Klasse mvd_visfunc */
destroy mvd_visfunc
\g
create mvd_visfunc (
classid = int4,
function = text,
classname = text,
attribute = text
)
\g
Query sent to backend is "create mvd_visfunc ( classid = int4, function = text, classname = text, attribute = text ) "
WARN:Jun 29 15:25:33:parser: syntax error at or near "function"
When I replace 'function' against 'funcname' it works. Why??
- Joerg
*********************************************************************
Dipl. Phys. Joerg Plewe joerg.plewe@mpi-dortmund.mpg.de
MPI fuer molekulare Physiologie
Rheinlanddamm 201
44139 Dortmund
Germany +49 (0)231 1206 384
*********************************************************************
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: create: syntax error
1994-06-29 15:36 create: syntax error J.Plewe <joerg.plewe@mpi-dortmund.mpg.de>
@ 1994-06-29 17:33 ` avi pfeffer <avi@postgres.Berkeley.EDU>
0 siblings, 0 replies; 2+ messages in thread
From: avi pfeffer @ 1994-06-29 17:33 UTC (permalink / raw)
To: J.Plewe <joerg.plewe@mpi-dortmund.mpg.de>; +Cc: legacy
> create mvd_visfunc (
> classid = int4,
> function = text,
> classname = text,
> attribute = text
> )
> \g
>
>
> Query sent to backend is "create mvd_visfunc ( classid = int4, functio
> n = text, classname = text, attribute = text ) "
> WARN:Jun 29 15:25:33:parser: syntax error at or near "function"
>
>
> When I replace 'function' against 'funcname' it works. Why??
"function" is a reserved word in POSTQUEL so the parser chokes when
you try to use it as an attribute name.
Avi
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1994-06-29 17:33 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1994-06-29 15:36 create: syntax error J.Plewe <joerg.plewe@mpi-dortmund.mpg.de>
1994-06-29 17:33 ` Re: create: syntax error avi pfeffer <avi@postgres.Berkeley.EDU>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox