On Sun, 26 Sep 2004, Aleksey Fedorchenko wrote:
> As i told, under pgAdmin's console and PHP it fails anyway but psql
> falls only with function invocation.
Hmm, for PHP was it sent as one big string with all the statements or a
separate statements? There's a side issue that I believe you can s
On Sun, 26 Sep 2004, Stephan Szabo wrote:
> What I'm saying is that, constraints are checked at end of statement. In
> current releases (8.0b2 included I believe but not 8.0b3) functions are
> considered part of the statement that called them, so the constraints are
> check at the end of the ful
Stephan!
> This is a known issue with the unique constraint.
Ok. Do you know any plans on this issue fix?
> > --case 2 prepare
> > --case 3 prepare
>
> I seem to get foreign key violations on both of these on both 7.4.x and
> 8.0 cvs using the scripts you provided just by running them in psql.
> I was on linux, although I just installed 8.0b2 dev 3 to my windows box
> and tried #2 and still got a success.
Let me guess - did you use psql? I found that mentioned scenarios run successfuly
under psql but pgAdmin's console and PHP driven invocation lead to fail (even with own
Slackware 10
Excuse me, i forgot to bind attatcments with previous letter.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Excuse me, i forgot to bind attachments with previous letter.
PS: In pgsql_bug_result.txt there is a output that shows behavior that i described in
first message.
PPS: check_uq.sh is the script to execute.
#!/bin/sh
clear
su - postgres -c "/usr/local/pgsql/bin/createdb test_uq" > /dev/null
su
