On Wed, 3 Sep 2003, Tom Lane wrote:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
> > Replying to myself again:
> > In DCH_processor (formatting.c), it doesn't seem to stop if it's in the
> > middle of processing nodes but runs off the inout string, should the for
> > loop be something like:
> > fo
Stephan Szabo <[EMAIL PROTECTED]> writes:
> Replying to myself again:
> In DCH_processor (formatting.c), it doesn't seem to stop if it's in the
> middle of processing nodes but runs off the inout string, should the for
> loop be something like:
> for (n=node,s=inout;n->type!=NODE_TYPE_END && *s!='
Stephan Szabo <[EMAIL PROTECTED]> writes:
> I don't entirely understand all of what that code is doing, but I think
> there's something in there that needs to get fixed.
Oh-ho, this is interesting:
Build CVS tip on RHL 8.0 with --enable-cassert: no bug.
Build CVS tip on RHL 8.0 without --enable-
On Tue, Sep 02, 2003 at 12:17:28AM -0400, Tom Lane wrote:
> Guy Thornley <[EMAIL PROTECTED]> writes:
> > What sort of performance numbers are you looking for? Without the throttle,
> > I/O is nuked and other database activity takes an age, and with it, its much
> > happier?
>
> Some people say tha
On Tue, 2 Sep 2003, Stephan Szabo wrote:
> On Tue, 2 Sep 2003, Stephan Szabo wrote:
>
> >
> > On Tue, 2 Sep 2003, Tom Lane wrote:
> >
> > > "Stacy White" <[EMAIL PROTECTED]> writes:
> > > > to_timestamp appears to pick up the time-of-day from the previous call's
> > > > return value if a date stri
On Tue, 2 Sep 2003, Stephan Szabo wrote:
>
> On Tue, 2 Sep 2003, Tom Lane wrote:
>
> > "Stacy White" <[EMAIL PROTECTED]> writes:
> > > to_timestamp appears to pick up the time-of-day from the previous call's
> > > return value if a date string has no time component. For example:
> >
> > Weird. I
See the attached file for details
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
On Tue, 2 Sep 2003, Tom Lane wrote:
> "Stacy White" <[EMAIL PROTECTED]> writes:
> > to_timestamp appears to pick up the time-of-day from the previous call's
> > return value if a date string has no time component. For example:
>
> Weird. I do not see that here, on either 7.3.4 or current source
Mincu Alexandru <[EMAIL PROTECTED]> writes:
> server segfaults when trying to move backward in a cursor.
This is fixed for 7.4. Previous releases do not support moving backward
in any query more complex than a single table scan.
regards, tom lane
"Stacy White" <[EMAIL PROTECTED]> writes:
> to_timestamp appears to pick up the time-of-day from the previous call's
> return value if a date string has no time component. For example:
Weird. I do not see that here, on either 7.3.4 or current sources.
Can anyone else reproduce it?
For the recor
Bupp Phillips wrote:
Could you possible have some type of variable (preferably the Transaction
ID) that can identify an individual process?
There's pg_backend_pid() for 7.4 and backend_pid() as contrib module for
earlier releases.
Regards,
Andreas
---(end of broadcast)
Your name : Mincu Alexandru
Your email address : [EMAIL PROTECTED]
Architecture: Intel Pentium
Operating System: Redhat 7.2 (Linux 2.4.17)
PostgreSQL version: PostgreSQL-7.3.4
Compiler used: gcc 3.01
to_timestamp appears to pick up the time-of-day from the previous call's
return value if a date string has no time component. For example:
# select to_timestamp('2
Could you possible have some type of variable (preferably the Transaction
ID) that can identify an individual process?
If something like this already exist, then disregard this post.
"Bruce Momjian" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> sad wrote:
> > Good day
> >
> > is
Dinar <[EMAIL PROTECTED]> writes:
> I thought that explain analyze doesn't execute query
You thought wrong. Is the manual's explanation not clear enough?
regards, tom lane
---(end of broadcast)---
TIP 9: the planner will ig
Kenji Sugita wrote:
Attached is compilation error messages of current CVS:
gcc -traditional-cpp -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
-I../../../src/include -c -o pqcomm.o pqcomm.c
pqcomm.c: In function `StreamServerPort':
pqcomm.c:280: parse error before '<<' token
pqcomm.c:29
Attached is compilation error messages of current CVS:
gcc -traditional-cpp -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
-I../../../src/include -c -o pqcomm.o pqcomm.c
pqcomm.c: In function `StreamServerPort':
pqcomm.c:280: parse error before '<<' token
pqcomm.c:291: case label not wit
sad wrote:
is it possible to define user variables in session ?
If not then is it planned to implement ?
or it is principially impossible in PosqtgreSQL
psql has variables, but in general we don't support session varibles.
You could create a temp table and put a value in there easily.
On Monday 01 September 2003 20:57, you wrote:
> sad wrote:
> > Good day
> >
> > is it possible to define user variables in session ?
> > If not then is it planned to implement ?
> > or it is principially impossible in PosqtgreSQL
>
> psql has variables, but in general we don't support session varib
Guy Thornley <[EMAIL PROTECTED]> writes:
> What sort of performance numbers are you looking for? Without the throttle,
> I/O is nuked and other database activity takes an age, and with it, its much
> happier?
Some people say that VACUUM nukes their performance, and some don't
find it to be a probl
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello All,
I'm using postgresql 7.3.2
And noticed strange bahaviour of
explain analyze command.
I use it to see how pl/pgsql function is executed:
Here is the function:
CREATE or replace FUNCTION flow1() RETURNS setof cidr
AS 'declare
clientnets
21 matches
Mail list logo
