On Wed, Mar 11, 2009 at 12:11 AM, Joseph S j...@selectacast.net wrote:
After adding a date column to a table, I started getting these errors from
my triggers:
ERROR: table row type and query-specified row type do not match
DETAIL: Query has too few columns.
The triggers just did simple
After adding a date column to a table, I started getting these errors
from my triggers:
ERROR: table row type and query-specified row type do not match
DETAIL: Query has too few columns.
The triggers just did simple UPDATEs on table2 when table1 was
updated/inserted
A db restart solved
Hi Tom,
we are running PostgreSQL 8.2.4.
Tom Lane wrote:
Patryk Kordylewski [EMAIL PROTECTED] writes:
can someone help/explain me why i get this error when i try to make an
update on that view? It seems that something is wrong with the subselect.
http://fooby.imosnet.de/error.txt
AFAICT,
Patryk Kordylewski wrote:
Hi Tom,
we are running PostgreSQL 8.2.4.
Maybe this has something to do with dropped columns?
Patryk: please run
select * from pg_attribute where attrelid = 'foo'::regclass and attisdropped;
Replacing 'foo' with the names of all the tables and views involved in
the
Patryk Kordylewski wrote:
Hi Tom,
we are running PostgreSQL 8.2.4.
Tom Lane wrote:
Patryk Kordylewski [EMAIL PROTECTED] writes:
can someone help/explain me why i get this error when i try to make
an update on that view? It seems that something is wrong with the
subselect.
Patryk Kordylewski wrote:
I made a test-case which is not working for me. Perhaps something wrong
with the SELECT DISTINCT ON () syntax when i specify more then 1 column?
At first this was working when i specified only one column in the SELECT
DISTINCT ON-clause, then i inserted a dummy
Patryk Kordylewski [EMAIL PROTECTED] writes:
I think i found the problem and made 2 sql files to reproduce it. The
only difference between this 2 files is the order by-clause of the view...
http://fooby.imosnet.de/order_by_working.txt
http://fooby.imosnet.de/order_by_not_working.txt
Hmm,
Hi,
can someone help/explain me why i get this error when i try to make an
update on that view? It seems that something is wrong with the subselect.
http://fooby.imosnet.de/error.txt
Thanks,
Patryk
---(end of broadcast)---
TIP 1: if
Patryk Kordylewski [EMAIL PROTECTED] writes:
can someone help/explain me why i get this error when i try to make an
update on that view? It seems that something is wrong with the subselect.
http://fooby.imosnet.de/error.txt
AFAICT, this works for me, so either you left something important out