"Nahuel Greco" <[EMAIL PROTECTED]> writes:
> If I create a trigger for a table, the trigger works
> ok, but if I add a new column to the table, then
> the trigger receives a NEW record with the old
> structure! I can fix that only if I remove the trigger
> from the table _and_ the trigger function.
Ron Mayer <[EMAIL PROTECTED]> writes:
> I would have expected that since the CREATE OR REPLACE was
> in a separate connection, and hense a separate transaction,
> that all the results of the select() will have been processed
> by the same function.
System catalog accesses are generally done with S
"Dennis Vshivkov" <[EMAIL PROTECTED]> writes:
> Time zone component should be added, not subtracted.
Done.
regards, tom lane
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.post
"Dennis Vshivkov" <[EMAIL PROTECTED]> writes:
> [8.0.1|src/backend/utils/adt/date.c] timetz_cmp_internal():
> /* Primary sort is by true (GMT-equivalent) time */
> t1 = time1->time + time1->zone;
> t2 = time2->time + time2->zone;
> This code is only valid when HAVE_INT64_TIMESTAMP is
>Bug reference: 1613
>Logged by:
>Email address: [EMAIL PROTECTED]
>PostgreSQL version: 8.0.2
>Operating system: Windows XP
>Description:Installation flaw
>Details:
>
>Hello,
>I am a new user of PostgreSQL. However, when I went to install it on my
>Windows XP machine,
Andrew Grillet <[EMAIL PROTECTED]> writes:
> Fix is found ...
> the default .csrc file set the locale to
> en_GB.ISO_5589-1
> but the correct setting is
> en_GB.ISO5589-1
> So the locale was set to an invalid setting. This has undesirable side
> effects.
Indeed ;-)
> It might be worth addin
I wrote:
> You're right, we do cheat a little on negative numeric constants --- I
> had forgotten about the doNegate() hack in gram.y. We could conceivably
> fix it to cheat some more. Specifically it looks like make_const() in
> parse_node.c could check for the possibility that a T_Float fits in
Andrew - Supernews <[EMAIL PROTECTED]> writes:
> We were discussing this one on irc while it was presumably waiting in the
> moderation queue, and I suggested to the poster an alternative patch that
> allowed empty arrays to actually be treated as empty (your version will
> error out on int_array_e
Kris Jurka <[EMAIL PROTECTED]> writes:
> The 8.1 server doesn't work when issuing queries using the v2 protocol,
> notably the isnull bitmask in the DataRow message is incorrect. I suspect
> the problem is with this commit:
> http://archives.postgresql.org/pgsql-committers/2005-03/msg00224.php
Dennis Vshivkov <[EMAIL PROTECTED]> writes:
> On Sat, Apr 23, 2005 at 01:58:13AM -0400, Tom Lane wrote:
>>> Time zone component should be added, not subtracted.
>>> Why?
> [ good arguments snipped ]
OK, I'm convinced --- particularly by the point that no place else in
the backend thinks "timetz-
10 matches
Mail list logo
