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 pe
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 conne
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)---
TI
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.3&idoc=0&file=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 opt
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:
http://www.postgresql.org/docs/view.ph
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_statemen
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 mod
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
http://momjian.postgresql.org/main/writings/pgsql/wi
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)-
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
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 pro
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.p
--- 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
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 to
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 b
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
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]
Nigel J. Andrews wrote:
On Fri, 16 Jan 2004, Jeff Bowden wrote:
So maybe this is a packaging issue. On Debian when I install postgres
it is necessary to do root shit in order to enable non-priveledged users
to create and destroy databases. My understanding has alwasy been that
these operat
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 efficient
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/
Sincerely,
Joshua Drake
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
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
alw
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;
toc
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 AS
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 O
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'# c
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 compatible,
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 th
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
kill
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:
http://
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,
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
41 matches
Mail list logo
