[GENERAL] I can't drop view?!

1999-03-04 Thread V. A.
Hi! I created a couple of views with the purpose of showing only results of the current date. By mistake, I used 'current_date' which always keeps its creation date rather than the date of execution. Therefor I wanted to drop these views, and redo them with 'date(text 'now')'. When I tried to dr

Re: [GENERAL] I can't drop view?!

1999-03-04 Thread Viktor A.
> >When I tried to drop it: >drop view view_anrufe_gesamt_tn11_1tag > >It stated: >ERROR: RewriteGetRuleEventRel: rule "_RETview_anrufe_gesamt_tn11_1tag" not >found > >Needless to say, that it is still there. >How can I get rid of it? Is there a reason for this? Maybe a workaround? >

[GENERAL] doing SQL lookup to postgres from Foxpro

1999-03-04 Thread William J. Stotts
Newbie question: I am in a situation where I may need to be able to interface to a postgres table from wihtin a foxpro 2.6 application. The maintainers fo the foxpro app say they can use SQL statements to access my postgres table. What interface to postgres allows this? Can anyone out there give

[GENERAL] Problem - Error: Cannot create table

1999-03-04 Thread Jens Niehaus
Hello, i've problems creating a table which was already created in an earlier transaction which crashed before completion (PostgreSQL 6.4.0, linux 2.0.36, libc-5.4): >postgres:> psql example >[...] >example=> BEGIN TRANSACTION; >BEGIN >example=> CREATE TABLE corrupt (name int4); >CREATE now the

[GENERAL] Re: [HACKERS] PostgreSQL 6.4.2 on AIX 4.3.2: typeidTypeRelid error

1999-03-04 Thread Thomas G. Lockhart
> I've seen several postings about this, but no resolution. I've > filed another bug report. > Problem Description: > > template1=> create database foo; > CREATEDB > template1=> drop database foo; > ERROR: typeidTypeRelid: Invalid type - oid = 0 > ERROR: typeidTypeRelid: Inv

[GENERAL] PostgreSQL 6.4.2 on AIX 4.3.2: typeidTypeRelid error

1999-03-04 Thread David R. Favor
I've seen several postings about this, but no resolution. I've filed another bug report. If someone has a fix for this, let me know. Thanks. ___ POSTGRESQL BUG REPORT TEMPLATE ===

[GENERAL] information about primary key from sys tabs

1999-03-04 Thread Ulf Mehlig
Hello out there, am I wrong in assuming that you can't find out the attributes of a relation which were defined as it's 'primary key' when executing 'create table'? If I'm not misinterpreting the docs, 'primary key' is changed to 'create unique index ...', and accordingly the columns concerned w