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
>
>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?
>
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
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
> 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
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
===
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