pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
SQL 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