LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 08-28-2002, 12:09 AM   #1
doublefailure
Member
 
Registered: Mar 2002
Location: ma
Distribution: slackware
Posts: 747

Rep: Reputation: 30
postgresql odd behavior


i have to enclose table user with " " but not for other tables..

this applies even in programs that access this database..


mydb=# \d
List of relations
Name | Type | Owner
---------------------+----------+----------
category | table | postgres
category_id_seq | sequence | postgres
content | table | postgres
content_field | table | postgres
content_type | table | postgres
content_type_id_seq | sequence | postgres
object_id_seq | sequence | postgres
rating | table | postgres
relationship | table | postgres
relationship_type | table | postgres
user | table | postgres
(11 rows)

mydb=# select * from user;
ERROR: parser: parse error at or near "user"
ERROR: parser: parse error at or near "user"
mydb=# select * from rating;
relationship_id | rating
-----------------+--------
128 | 3
(1 row)

mydb=# select * from "user";
user_id | username | first_names | last_name | email | password
---------+----------+-------------+-----------+-----------------------+----------

any idea?


k..... looks like 'user' is keyword of postgresql..
users works fine..
=)

Last edited by doublefailure; 08-28-2002 at 12:17 AM.
 
Old 08-28-2002, 12:40 AM   #2
j-ray
Senior Member
 
Registered: Jan 2002
Location: germany
Distribution: ubuntu
Posts: 1,426

Rep: Reputation: 100Reputation: 100
itīs like that, a reserved one:
http://www.postgresql.org/idocs/inde...-appendix.html
cheers, jens
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Odd Knoppix behavior Darkstar Linux - Distributions 1 06-25-2005 09:46 PM
Odd RedHat 9.0 behavior... 386 Linux - Networking 2 10-15-2004 10:00 AM
Odd Behavior of Epiphany Jeffmrg Slackware 2 09-09-2004 08:23 AM
Odd Re-Booting Behavior ....... ? justaguynsrq Slackware 2 04-16-2004 12:02 PM
RH 6.2 ... odd behavior jubal Linux - Networking 3 02-27-2001 09:04 AM


All times are GMT -5. The time now is 11:18 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration