Kristis Makris <[EMAIL PROTECTED]> writes:
> On 11 Jul 2001 11:21:35 -0400, Tom Lane wrote:
>> Hmm, are you trying to create triggers on pg_shadow? It's hard to see
>> how that message could come from an "UPDATE pg_shadow" otherwise.
> I'm not trying to explicitly create triggers on pg_shadow. N
Kristis Makris <[EMAIL PROTECTED]> writes:
> On 11 Jul 2001 12:07:09 -0400, Tom Lane wrote:
>> Maybe you made a table with a foreign key reference to pg_shadow?
> I suspected that, grep'ed all my sql source for "pg_shadow" and the only
> place where I use the pg_shadow table is on the "UPDATE pg_
José María Fernández González ([EMAIL PROTECTED]) reports a bug with a severity
of 2
The lower the number the more severe it is.
Short Description
PL/pgSQL triggers with parameters don't work
Long Description
The report is for PostgreSQL 7.1.2. When you create a trigger which calls a
f
> () reports a bug with a severity of 3
> The lower the number the more severe it is.
>
> Short Description
> ecpg: INITALLY DEFERRED translated into intially deferrable
>
> Long Description
> The SQL preprocessor ecpg generates "initially deferrable" from
> INITIALLY DEFERRED in source code. c
On Wed, 11 Jul 2001 [EMAIL PROTECTED] wrote:
> José María Fernández González ([EMAIL PROTECTED]) reports a bug
> with a severity of 2
> The lower the number the more severe it is.
>
> Short Description
> PL/pgSQL triggers with parameters don't work
>
> Long Description
> The report is fo
Carl Anderson writes:
> version 7.1.2
>
> using gcc3.0 under solaris 2.7
>
> Compile completes without error but the shared libraries are not realy
> shared libs.
> change section for gnu-ld and solaris to include the flag -shared.
You might want to file this as a bug report for GCC, since -G u
[EMAIL PROTECTED] writes:
> ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found
Hmm, are you trying to create triggers on pg_shadow? It's hard to see
how that message could come from an "UPDATE pg_shadow" otherwise.
Triggers on system catalogs don't work very well, because
() reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
ecpg: INITALLY DEFERRED translated into intially deferrable
Long Description
The SQL preprocessor ecpg generates "initially deferrable" from
INITIALLY DEFERRED in source code. cf. preproc.y:1455.
Kristis Makris <[EMAIL PROTECTED]> writes:
> but if I want to clear the valuntil completely, how should I issue the
> ALTER USER statement?
Offhand I don't believe ALTER USER can do that. Feel free to submit
a patch ;-).
regards, tom lane
---(end
Benoit Lion writes:
> select nmn_can,pre_can,dat_nai,dci_sai,cnd.cod_spe,cnd.cod_pa1,decision
> , cnd.cod_pa2
> >from cnd,cnd_grp, decision where cnd.cod_eta='0731043M'
> and cnd.num_can=cnd_grp.num_can and cnd_grp.typ_grp='D'
> and cnd_grp.dci_sai=decision.cod_dec
>
> union
>
> select nmn_can,p
>
> Thank _you_.
>
> I didn't see anything in the documentation under COPY TO that
> indicated it should not work with views. Since you say it should
> raise and error, the documentation should probably be updated too.
>
> -Steve Pothier-
>
>Date: Thu, 28 Jun 2001 10:56:29 -0400
>From
Bruce Momjian <[EMAIL PROTECTED]> writes:
> OK, the following patch throws an error if you try to COPY TO/FROM
> views.
This is probably the wrong direction to approach it from: rather than
disallowing wrong things one at a time, we should only allow COPY if the
relkind is plain relation. Think
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > OK, the following patch throws an error if you try to COPY TO/FROM
> > views.
>
> This is probably the wrong direction to approach it from: rather than
> disallowing wrong things one at a time, we should only allow COPY if the
> relkind is plain rel
13 matches
Mail list logo
