On Friday 16 January 2004 05:14, Michael Glaesemann wrote:
That said, I haven't been successful finding which functions accept
tinterval as arguments, though this is probably because I don't know
how to handle where clauses involving arrays, or perhaps its because
the pg_proc.proargtypes
On Friday 16 January 2004 09:18, Ritu Khetan wrote:
Hello all,
I am trying to use DBI in perl to connect to my Postgres database. I
am able to connect to the database but when any further queries are made
using the database handle, I see the following message in my error logs
and no
On Jan 16, 2004, at 6:46 PM, Richard Huxton wrote:
On Friday 16 January 2004 05:14, Michael Glaesemann wrote:
That said, I haven't been successful finding which functions accept
tinterval as arguments, though this is probably because I don't know
how to handle where clauses involving arrays, or
Hi all,
I would be interested in playing around with the beta version for the
Windows native port - where can I get it?
TIA.
Paul...
--
plinehan y_a_h_o_o and d_o_t com
C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro
Please do not top-post.
XML avoids the fundamental question
Hello Richard,
How do I switch on statement logging...?
postmaster --help doesn't talk of any such switch.
Regards,
Ritu
On Fri, 2004-01-16 at 15:25, Richard Huxton wrote:
On Friday 16 January 2004 09:18, Ritu Khetan wrote:
Hello all,
I am trying to use DBI in perl to connect to
On Friday 16 January 2004 16:03, Ritu Khetan wrote:
Hello Richard,
How do I switch on statement logging...?
postmaster --help doesn't talk of any such switch.
Check options in postgresql.conf.
Shridhar
---(end of broadcast)---
TIP 1:
Hi,
No such option found. There is the S switch for silent mode which is off by default anyways.
Regards,
Ritu
On Fri, 2004-01-16 at 16:34, Shridhar Daithankar wrote:
On Friday 16 January 2004 16:03, Ritu Khetan wrote:
Hello Richard,
How do I switch on statement logging...?
David Helgason wrote:
I'm switching right away. The notation doesn't really do anything for
me, but that's fine. I've been using bit(128), but always suspected that
of being unoptimal (for no particular reason).
I think bit(128) is quite efficient (OCTET_LENGTH() function shows me
it's using 16
Have you read the documentation about configuring the postgres server:
http://www.postgresql.org/docs/view.php?version=7.3idoc=0file=runtime.html
Actually there is a very fine suite of documentation on that site.
HTH,
Csaba.
On Fri, 2004-01-16 at 12:13, Ritu Khetan wrote:
Hi,
No such option
Hi all,
I discovered the problem, AutoCommit is off by default and I did not commit the transaction..it works fine now.
Thanks,
Ritu
On Fri, 2004-01-16 at 16:56, Csaba Nagy wrote:
Have you read the documentation about configuring the postgres server:
On Friday 16 January 2004 16:43, Ritu Khetan wrote:
Hi,
No such option found. There is the S switch for silent mode which is
off by default anyways.
In my local installation I have following relevant options.
#log_connections = false
#log_duration = false
#log_pid = false
#log_statement =
Hi,
Oh ok..my conf didnt show the log_statement option. Thanks, should be helpful some other time.
Regards,
Ritu
On Fri, 2004-01-16 at 17:39, Shridhar Daithankar wrote:
On Friday 16 January 2004 16:43, Ritu Khetan wrote:
Hi,
No such option found. There is the S switch for silent mode
On Friday 16 January 2004 10:35, Paul Ganainm wrote:
Hi all,
I would be interested in playing around with the beta version for the
Windows native port - where can I get it?
I don't think there is a beta yet. There is a status page here
Hi,
How to generate GUID(f741d0ce-351c-4c8d-9625-d23765ca7f45) values in
postgre ?
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
You want
http://gborg.postgresql.org/project/uniqueidentifier/projdisplay.php
CG
--- Ivar [EMAIL PROTECTED] wrote:
Hi,
How to generate GUID(f741d0ce-351c-4c8d-9625-d23765ca7f45) values in
postgre ?
---(end of broadcast)---
TIP 4:
On Fri, 2004-01-16 at 04:41, Richard Huxton wrote:
On Friday 16 January 2004 04:50, LitelWang wrote:
I need catch the error when my insert clause violate the
primary key .How to write in the server function ?
Thanks for any advice .
You can't (at the moment). An error terminates a
Chris Gamache wrote:
You want
http://gborg.postgresql.org/project/uniqueidentifier/projdisplay.php
Another alternative:
http://gborg.postgresql.org/project/pguuid/projdisplay.php
(How do the two compare, aside from uniqueidentifier seeming to be
Linux-only? Should I use one of the above for
Seems that none of them is same as MS GUID.
Linux-only?
Seems so, damn currently use windows for developement.
David Garamond [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Chris Gamache wrote:
You want
http://gborg.postgresql.org/project/uniqueidentifier/projdisplay.php
--- Harald Fuchs [EMAIL PROTECTED] wrote:
In article
[EMAIL PROTECTED],
LitelWang [EMAIL PROTECTED] writes:
I need this function :
CheckDate('2002-02-29') return false
CheckDate('2002-02-28') return true
Why would you want to do that? Just try to insert
'2002-02-29' into
your DATE
Richard Huxton wrote:
On Thursday 15 January 2004 15:02, Bill Moran wrote:
I'm having a little trouble understanding how to do something. I assume
I'm just missing it in the documentation, so a pointer to relevent docs
would be as welcome as a direct answer.
I have a project in which I'll need
Tom,
Actually, I've never had a corrupted firebird database. There were
two bugs in an older version of InterBase that produced income for me.
The first was a failure to realize that a file had just gone over 4Gb
and therefore the word holding the offset had rolled over and the system
had
OK boys, i've made a mistake by using the term register. What i meant is
record.
Could you please tell me if there's a limit in the amount of records that
the database can handle?
Thanks... Ruby
Martin: why do you say i meant tuple?
From: Martin Marques [EMAIL PROTECTED]
To: Doug McNaught
On Fri, 16 Jan 2004, Jeff Bowden wrote:
Tom Lane wrote:
Jeff Bowden [EMAIL PROTECTED] writes:
Still, the main problem I, and I suspect others, would like to solve is
installation/configuration. For my app I don't want the user to have to
understand anything about how keeping data
What's the best way to ease development of plpgsql.
My largest issues with plpgsql pertain to the quoting of course.
Bill McMilleon
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On 16. jan 2004, at 12:18, David Garamond wrote:
David Helgason wrote:
I'm switching right away. The notation doesn't really do anything for
me, but that's fine. I've been using bit(128), but always suspected
that of being unoptimal (for no particular reason).
I think bit(128) is quite
I still have to respectfully disagree. Postgresql is IMO just the wrong
software for the job, and given that there are still a number of really
important things that postgresql lacks, it should concentrate on those.I
am not against it however for technical reasons, because those things can
I was trying to create a sql function today (see below) using
postgresql 7.3.3. I don't see how to get around this error, anyone
have any suggestions?
Thanks much,
Matthew
tocr=# CREATE OR REPLACE FUNCTION public.update_dncl(bpchar, bpchar)
tocr-# RETURNS void AS
tocr-# '
tocr'# begin;
Matthew T. O'Connor wrote:
I was trying to create a sql function today (see below) using
postgresql 7.3.3. I don't see how to get around this error, anyone
have any suggestions?
Thanks much,
Matthew
tocr=# CREATE OR REPLACE FUNCTION public.update_dncl(bpchar, bpchar)
tocr-# RETURNS void
On Fri, 16 Jan 2004, Joshua D. Drake wrote:
Hello,
Took an hour today and made the 7.3.4, 7.4.1 and Practical PostgreSQL
documentation
all searchable using OpenFTS and Tsearch2. You can take a look at:
http://www.commandprompt.com/community/
I'd appreciate if you mention somewhere OpenFTS
http://www.commandprompt.com/community/
I'd appreciate if you mention somewhere OpenFTS utilization, so people
could recognize it. But I'm not insisting ;)
Full intent to do so... want to get it finished up first. :)
Sincerely,
Joshua Drake
Matthew T. O'Connor [EMAIL PROTECTED] writes:
I was trying to create a sql function today (see below) using
postgresql 7.3.3. I don't see how to get around this error, anyone
have any suggestions?
tocr=# CREATE OR REPLACE FUNCTION public.update_dncl(bpchar, bpchar)
...
tocr'# copy
David Helgason wrote:
I'm already using 'real' GUIDs, which in my case means that the database
never generates them (since I don't have a generate_real_guid() function
in the database (and don't need to).
Neither GUID project on gborg (mentioned in another thread) seem to be
Mac OSX
Chris Ochs wrote:
I still have to respectfully disagree. Postgresql is IMO just the wrong
software for the job, and given that there are still a number of really
important things that postgresql lacks, it should concentrate on those.I
am not against it however for technical reasons, because
I installed 7.4 from the FreeBSD ports collection (I'm running 4.9-RELEASE).
Did nothing special, just make make install and all was well.
I now have updated my ports collection via cvsup and see that the 7.4.1 port
is available. So now I have several, very specific needs:
1) having now done
I know Tom would like a definitive and thorough testing to determine the
proper GEQO threshold limit , and that is the right thing to do, of course.
But just as a quick notice to those upgrading from 7.3 to 7.4 with fully
normalized databases requiring 11 joins, the GEQO setting can be a
Folks,
While debugging a wireless card, I came across this interesting bit:
http://portal.suse.com/sdb/en/2003/10/pohletz_desktop_90.html
What it indicates is that by default SuSE 9.0 plays with the timeslice values
for the Linux kernel in order to provide a smoother user experience. In
my
Along similar lines - have generally obtained better server performance
(and stability) from most Linux distros after replacing their supplied
kernel with one from kernel.org .
regards
Mark
Josh Berkus wrote:
Folks,
While debugging a wireless card, I came across this interesting bit:
Mike Mascari [EMAIL PROTECTED] writes:
But just as a quick notice to those upgrading from 7.3 to 7.4 with fully
normalized databases requiring 11 joins, the GEQO setting can be a
killer...
Uh ... dare I ask whether you think it's too high? Or too low?
regards, tom
Mike Mascari [EMAIL PROTECTED] writes:
But just as a quick notice to those upgrading from 7.3 to 7.4 with
fully
normalized databases requiring 11 joins, the GEQO setting can be a
killer...
Uh ... dare I ask whether you think it's too high? Or too low?
Just a data point: With a fresh 7.4 and
39 matches
Mail list logo