pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSQL Problem: ERROR: ExecEvalExpr: unknown expression type 108
3+ messages / 3 participants
[nested] [flat]
* SQL Problem: ERROR: ExecEvalExpr: unknown expression type 108
@ 1999-06-04 12:14 Michael Klemme <mklemme@gmx.de>
0 siblings, 0 replies; 3+ messages in thread
From: Michael Klemme @ 1999-06-04 12:14 UTC (permalink / raw)
To: pgsql-sql; +Cc: Christoph Konnertz <christoph@inm.de>
Hallo!
I try to create a web server authentification database for our Apache
using PostgreSQL.
Students will be added to certain groups, group entries need to be
invalidated once in a while.
klemme@moa:~/Postgres/auth> psql -d authentify -f auth-create-test.sql
DROP TABLE user;
DROP
DROP TABLE ugroup;
DROP
-- user entries
CREATE TABLE user(
vorname char(20) NOT NULL, --Vorname des Benutzers
name char(20) NOT NULL, --Name des Benutzers
uname char(10) PRIMARY KEY, --eindeutiger Benutzername des Benutzers im Server';
pass char(16) NOT NULL, --Paßwort des Benutzers
changed date NOT NULL
);
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index user_pkey for table userCREATE
-- group entries
CREATE TABLE ugroup
(
uname char(10) NOT NULL, --Zeiger auf user
ugroup char(10) NOT NULL, --Name der Gruppe
expires date NOT NULL, --Verfallsdatum
changed date NOT NULL);
CREATE
CREATE UNIQUE INDEX ugroup_idx ON ugroup (uname,ugroup);
CREATE
vacuum;
VACUUM
--- Test entries
insert into user values ('Michael', 'Klemme', 'mklemme', 'xxxx', '04-06-1999');
INSERT 24895 1
insert into user values ('Michaela','Klemme','maklemme', 'xxxx', '04-06-1999');
INSERT 24896 1
insert into ugroup values ('mklemme', 'Physics', '31-12-1999', '04-06-1999');
INSERT 24897 1
insert into ugroup values ('mklemme', 'Math', '31-12-1999', '04-06-1999');
INSERT 24898 1
insert into ugroup values ('maklemme', 'Math', '31-12-1998', '04-06-1999');
INSERT 24899 1
--I need to create a view for the Apache module that only returns user
--entries if a non-expired group entry exists.
--The SELECT Statement below works okay.
SELECT uname, pass FROM user
WHERE UNAME IN
(SELECT uname FROM ugroup WHERE expires >= datetime_date('now'));
uname |pass
----------+----------------
mklemme |xxxx
(1 row)
--However, if I use the same statment in a view, I get this error message
-- view to be accessed by Apache
DROP VIEW legal_user;
DROP
CREATE VIEW legal_user AS
SELECT uname, pass FROM user
WHERE UNAME IN
(SELECT uname FROM ugroup WHERE expires >= datetime_date('now'));
CREATE
SELECT * FROM legal_user;
ERROR: ExecEvalExpr: unknown expression type 108
EOF
ANy help would be greatly appreciated!
Thanks,
Grüße
Michael
--
Michael Klemme
@home mklemme@gmx.de /
klemme@bankakademie.de / klemme@acm.org
PGP: http://www.hmu.auckland.ac.nz/~michael-k/pgp
Attachments:
auth-create-test.sql (text/plain, 1.6K) download
DROP TABLE user;
DROP TABLE ugroup;
-- user entries
CREATE TABLE user
(
vorname char(20) NOT NULL, --Vorname des Benutzers
name char(20) NOT NULL, --Name des Benutzers
uname char(10) PRIMARY KEY,
--eindeutiger Benutzername des Benutzers im Server';
pass char(16) NOT NULL, --Paßwort des Benutzers
changed date NOT NULL
);
-- group entries
CREATE TABLE ugroup
(
uname char(10) NOT NULL, --Zeiger auf user
ugroup char(10) NOT NULL, --Name der Gruppe
expires date NOT NULL, --Verfallsdatum
changed date NOT NULL
);
CREATE UNIQUE INDEX ugroup_idx ON ugroup (uname,ugroup);
vacuum;
--- Test entries
insert into user values ('Michael', 'Klemme', 'mklemme', 'xxxx', '04-06-1999');
insert into user values ('Michaela','Klemme','maklemme', 'xxxx', '04-06-1999');
insert into ugroup values ('mklemme', 'Physics', '31-12-1999', '04-06-1999');
insert into ugroup values ('mklemme', 'Math', '31-12-1999', '04-06-1999');
insert into ugroup values ('maklemme', 'Math', '31-12-1998', '04-06-1999');
--I need to create a view for the Apache module that only returns user
--entries if a non-expired group entry exists.
--The SELECT Statement below works okay.
SELECT uname, pass FROM user
WHERE UNAME IN
(SELECT uname FROM ugroup WHERE expires >= datetime_date('now'));
--However, if I use the same statment in a view, I get this error message
-- view to be accessed by Apache
DROP VIEW legal_user;
CREATE VIEW legal_user AS
SELECT uname, pass FROM user
WHERE UNAME IN
(SELECT uname FROM ugroup WHERE expires >= datetime_date('now'));
SELECT * FROM legal_user;
^ permalink raw reply [nested|flat] 3+ messages in thread
* SQL Problem: ERROR: ExecEvalExpr: unknown expression type 108
@ 1999-06-09 08:28 Michael Klemme <klemme@bankakademie.de>
0 siblings, 1 reply; 3+ messages in thread
From: Michael Klemme @ 1999-06-09 08:28 UTC (permalink / raw)
To: pgsql-sql
Hallo!
I try to create a web server authentification database for our Apache
using PostgreSQL.
Students will be added to certain groups, group entries need to be
invalidated once in a while.
klemme@moa:~/Postgres/auth> psql -d authentify -f
auth-create-test.sql
DROP TABLE user;
DROP
DROP TABLE ugroup;
DROP
-- user entries
CREATE TABLE user(
vorname char(20) NOT NULL, --Vorname des Benutzers
name char(20) NOT NULL, --Name des Benutzers
uname char(10) PRIMARY KEY, --eindeutiger Benutzername des
Benutzers im Server';
pass char(16) NOT NULL, --Paßwort des Benutzers
changed date NOT NULL
);
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index
user_pkey for table userCREATE
-- group entries
CREATE TABLE ugroup
(
uname char(10) NOT NULL, --Zeiger auf user
ugroup char(10) NOT NULL, --Name der Gruppe
expires date NOT NULL, --Verfallsdatum
changed date NOT NULL);
CREATE
CREATE UNIQUE INDEX ugroup_idx ON ugroup (uname,ugroup);
CREATE
vacuum;
VACUUM
--- Test entries
insert into user values ('Michael', 'Klemme', 'mklemme', 'xxxx',
'04-06-1999');
INSERT 24895 1
insert into user values ('Michaela','Klemme','maklemme', 'xxxx',
'04-06-1999');
INSERT 24896 1
insert into ugroup values ('mklemme', 'Physics', '31-12-1999',
'04-06-1999');
INSERT 24897 1
insert into ugroup values ('mklemme', 'Math', '31-12-1999',
'04-06-1999');
INSERT 24898 1
insert into ugroup values ('maklemme', 'Math', '31-12-1998',
'04-06-1999');
INSERT 24899 1
--I need to create a view for the Apache module that only returns
user
--entries if a non-expired group entry exists.
--The SELECT Statement below works okay.
SELECT uname, pass FROM user
WHERE UNAME IN
(SELECT uname FROM ugroup WHERE expires >= datetime_date('now'));
uname |pass
----------+----------------
mklemme |xxxx
(1 row)
--However, if I use the same statment in a view, I get this error
message
-- view to be accessed by Apache
DROP VIEW legal_user;
DROP
CREATE VIEW legal_user AS
SELECT uname, pass FROM user
WHERE UNAME IN
(SELECT uname FROM ugroup WHERE expires >= datetime_date('now'));
CREATE
SELECT * FROM legal_user;
ERROR: ExecEvalExpr: unknown expression type 108
EOF
ANy help would be greatly appreciated!
Thanks,
Grüße
Michael
--
Michael Klemme
@home mklemme@gmx.de /
klemme@bankakademie.de / klemme@acm.org
PGP: http://www.hmu.auckland.ac.nz/~michael-k/pgp
Attachments:
auth-create-test.sql (text/plain, 1.6K) download
DROP TABLE user;
DROP TABLE ugroup;
-- user entries
CREATE TABLE user
(
vorname char(20) NOT NULL, --Vorname des Benutzers
name char(20) NOT NULL, --Name des Benutzers
uname char(10) PRIMARY KEY,
--eindeutiger Benutzername des Benutzers im Server';
pass char(16) NOT NULL, --Paßwort des Benutzers
changed date NOT NULL
);
-- group entries
CREATE TABLE ugroup
(
uname char(10) NOT NULL, --Zeiger auf user
ugroup char(10) NOT NULL, --Name der Gruppe
expires date NOT NULL, --Verfallsdatum
changed date NOT NULL
);
CREATE UNIQUE INDEX ugroup_idx ON ugroup (uname,ugroup);
vacuum;
--- Test entries
insert into user values ('Michael', 'Klemme', 'mklemme', 'xxxx', '04-06-1999');
insert into user values ('Michaela','Klemme','maklemme', 'xxxx', '04-06-1999');
insert into ugroup values ('mklemme', 'Physics', '31-12-1999', '04-06-1999');
insert into ugroup values ('mklemme', 'Math', '31-12-1999', '04-06-1999');
insert into ugroup values ('maklemme', 'Math', '31-12-1998', '04-06-1999');
--I need to create a view for the Apache module that only returns user
--entries if a non-expired group entry exists.
--The SELECT Statement below works okay.
SELECT uname, pass FROM user
WHERE UNAME IN
(SELECT uname FROM ugroup WHERE expires >= datetime_date('now'));
--However, if I use the same statment in a view, I get this error message
-- view to be accessed by Apache
DROP VIEW legal_user;
CREATE VIEW legal_user AS
SELECT uname, pass FROM user
WHERE UNAME IN
(SELECT uname FROM ugroup WHERE expires >= datetime_date('now'));
SELECT * FROM legal_user;
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] SQL Problem: ERROR: ExecEvalExpr: unknown expression type 108
@ 1999-06-10 23:14 Tom Lane <tgl@sss.pgh.pa.us>
parent: Michael Klemme <klemme@bankakademie.de>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 1999-06-10 23:14 UTC (permalink / raw)
To: mklemme@gmx.de; +Cc: pgsql-sql
Michael Klemme <klemme@bankakademie.de> writes:
> --However, if I use the same statment in a view, I get this error
> message
> SELECT * FROM legal_user;
> ERROR: ExecEvalExpr: unknown expression type 108
This seems to be fixed in 6.5-current. There's probably not any
good workaround for the bug as long as you are using 6.4 ...
BTW, it appears that "user" is a reserved word in 6.5; I had to
choose a different table name to test this.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-06-10 23:14 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-06-04 12:14 SQL Problem: ERROR: ExecEvalExpr: unknown expression type 108 Michael Klemme <mklemme@gmx.de>
1999-06-09 08:28 SQL Problem: ERROR: ExecEvalExpr: unknown expression type 108 Michael Klemme <klemme@bankakademie.de>
1999-06-10 23:14 ` Re: [SQL] SQL Problem: ERROR: ExecEvalExpr: unknown expression type 108 Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox