Re: [BUGS] Behaviour of triggers on replicated and non replicated tables

2011-06-17 Thread Robert Haas
2011/6/16 Luiz K. Matsumura : > Em 16/06/2011 16:39, Robert Haas escreveu: > > 2011/6/10 Luiz K. Matsumura : > > I need help to know if the follow scenario is a expected behaviour, a bug of > postgres or a bug of slony: > > Postgres v8.4.8 > Slony-I v 2.0.5 > > I have table replicated with slony an

Re: [BUGS] Behaviour of triggers on replicated and non replicated tables

2011-06-16 Thread Luiz K. Matsumura
Em 16/06/2011 16:39, Robert Haas escreveu: 2011/6/10 Luiz K. Matsumura: I need help to know if the follow scenario is a expected behaviour, a bug of postgres or a bug of slony: Postgres v8.4.8 Slony-I v 2.0.5 I have table replicated with slony and that do some updates in another table not re

Re: [BUGS] Behaviour of triggers on replicated and non replicated tables

2011-06-16 Thread Luiz K. Matsumura
Em 16/06/2011 19:17, Christopher Browne escreveu: 2011/6/10 Luiz K. Matsumura: Hi, I need help to know if the follow scenario is a expected behaviour, a bug of postgres or a bug of slony: Postgres v8.4.8 Slony-I v 2.0.5 I have table replicated with slony and that do some updates in another t

Fwd: [BUGS] Behaviour of triggers on replicated and non replicated tables

2011-06-16 Thread Christopher Browne
2011/6/10 Luiz K. Matsumura : > Hi, > I need help to know if the follow scenario is a expected behaviour, a bug of > postgres or a bug of slony: > > Postgres v8.4.8 > Slony-I v 2.0.5 > > I have table replicated with slony and that do some updates in another table > not replicated. > > The trigger o

Re: [BUGS] Behaviour of triggers on replicated and non replicated tables

2011-06-16 Thread Robert Haas
2011/6/10 Luiz K. Matsumura : > I need help to know if the follow scenario is a expected behaviour, a bug of > postgres or a bug of slony: > > Postgres v8.4.8 > Slony-I v 2.0.5 > > I have table replicated with slony and that do some updates in another table > not replicated. > > The trigger on repl

[BUGS] Behaviour of triggers on replicated and non replicated tables

2011-06-10 Thread Luiz K. Matsumura
Hi, I need help to know if the follow scenario is a expected behaviour, a bug of postgres or a bug of slony: Postgres v8.4.8 Slony-I v 2.0.5 I have table replicated with slony and that do some updates in another table not replicated. The trigger on replicated table was enabled on the slave

Re: [BUGS] behaviour of inequalities with row constructors

2003-04-03 Thread Tom Lane
Chris Studholme <[EMAIL PROTECTED]> writes: > What follows is not necessarily a bug, but may be a misinterpretation of > the SQL standard. Yeah, it's a bug; the implementation of row comparisons in PG is completely bogus. (The parser just expands it out to an AND clause of scalar comparisons, whi

[BUGS] behaviour of inequalities with row constructors

2003-04-03 Thread Chris Studholme
Hi, What follows is not necessarily a bug, but may be a misinterpretation of the SQL standard. I don't actually have a copy of the SQL standard, but I am working from the book "A Guide to The SQL Standard, Fourth Edition" by C.J. Date and Hugh Darwen. If you have this book handy, please refer to

Re: [BUGS] Behaviour

2002-07-18 Thread Stephan Szabo
On 18 Jul 2002, [ISO-8859-1] Stéphane Raimbault wrote: > Hi, > > I have the following tables : > CREATE TABLE tournee ( >no_tournee SERIAL PRIMARY KEY); > > CREATE TABLE fab_tournee ( >id SERIAL PRIMARY KEY, >id_fab INTEGER REFERENCES fabrication ON DELETE CASCADE, >

[BUGS] Behaviour

2002-07-18 Thread Stéphane Raimbault
Hi, I have the following tables : CREATE TABLE tournee ( no_tournee SERIAL PRIMARY KEY); CREATE TABLE fab_tournee ( id SERIAL PRIMARY KEY, id_fab INTEGER REFERENCES fabrication ON DELETE CASCADE, no_tournee INTEGER REFERENCES tournee ON DELETE CASCADE); When I insert