[HACKERS added to cc:, GENERAL dropped]
On Monday 20 May 2002 11:39 pm, Tom Lane wrote:
> Lamar Owen <[EMAIL PROTECTED]> writes:
> > Well, I went to bat for this a little bit ago, relating to a bug report,
> > but I've struck out. The ISO C standard spells it out plainly that dates
> > before 197
On Monday 20 May 2002 08:08 pm, Manuel Sugawara wrote:
> > Where would we go to ferret out the source of this bug? More to the
> > point: we need a test case in C that could expose this as a glibc
> > bug.
> Seems like mktime(3) is having problems with dates before the
> epoch. Attached is the a
Lamar Owen <[EMAIL PROTECTED]> writes:
> Where would we go to ferret out the source of this bug? More to the
> point: we need a test case in C that could expose this as a glibc
> bug.
Seems like mktime(3) is having problems with dates before the
epoch. Attached is the a program to test this.
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> In ProcedureCreate() (backend/catalog/pg_proc.c) there are special cases
> for the built-in languages that check whether the to-be-created function
> has a valid body. ISTM that we could extend that for user-defined
> functions, as follows.
> When c
"Dave Page" <[EMAIL PROTECTED]> writes:
> I'm confused. Does the standalone backend not deal with schemas fully
> and is silently failing 'cos there's nothing technically wrong with the
> pg_catalog.viewname syntax?
The standalone backend does schemas just fine. What is supposed to
ensure that t
Is there an
implemented JDBC that supports SSL? How are you testing the SSL patches to
postgresql server?
There is a posting
(http://archives.postgresql.org/pgsql-jdbc/2002-02/msg00139.php)
that discusses how to add SSL sockets to the current JDBC source code. We at
nuBridges http://www.n
was Re: [PATCHES] SRF patch (was Re: [HACKERS] troubleshooting pointers)
Tom Lane wrote:
>
> Now that I think about it, it's possible that ExecFunctionReScan is
> correct now, at least given the simplistic always-materialize policy
> that we've implemented so far. But it hasn't gotten much test
Hello Mr. Lane,
I am a novice postgres developer. Can you please shed some light on this
problem I am having.
Basically, I am making a small change in executePlan() function of
executor/execMain.c. Right after a tupleslot is retrieved, I try to find
out the oid of the tuple that has been retriev
I am still on vacation but have access to an Internet connection today
and am going through as much email as I can.
For the curious, I took an 18-day cruise from New York City on April 31,
through the Panama Canal to Seattle, then a 2-day train from Seattle to
Los Angeles, which is where I am now
>
> Hmm. Which file(s) were growing, exactly? How many row updates is this
> run covering?
>
The toast table gets about 90 percent of the growth, followed by the toast
index at about 9 percent. The actual table + primary key stay at about 2M each.
I neglected to mention what the update stat
On Fri, 2002-05-17 at 16:58, Michael Meskes wrote:
> Hi,
>
> IMO the most important stuff seems to be:
>
...
> - recursive views (you know, I wanted to implement this when I started
> my work on PostgreSQL, but never found the time)
A good start would be to make the parser recognize the full
Attached is the first cut at some SSL documetation for the
PostgreSQL manual. It's in plain text, not DocBook, to make
editing easy for the first few revisions. The documentation
leads the code by a day or so.
Also, I'm still having problems with the patches list - none
of my recent submissions
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
> Sent: 17 May 2002 23:24
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] More schema queries
>
>
> > 2200 | pg_stat_all_tables
> > 2200 | pg_stat_sys_tables
>
> Bizarre. It's not th
Since we now have an official entry in /etc/services, shouldn't we be able
to make use of it, by using getservbyname() if a nonnumeric port number is
specified?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you sear
In ProcedureCreate() (backend/catalog/pg_proc.c) there are special cases
for the built-in languages that check whether the to-be-created function
has a valid body. ISTM that we could extend that for user-defined
functions, as follows.
When creating a language, the user can optionally register a
Attached is the first cut at mkcert.sh, a tool to create PostgreSQL
server certificates. It also sets up a directory suitable for the
OpenSSL CA tool, something that can be used to sign client certs.
The root cert should be added to the backend SSL cert verification
tools, and copied to user's .
Lamar Owen <[EMAIL PROTECTED]> writes:
> Filed on Red Hat's Bugzilla system as bug# 65227, as I can reliably
> reporoduce this bug here, and PostgreSQL 7.2.1 on Red Hat 6.2 on
> SPARC does not exhibit the bug.
Thanks for filling that report. I couldn't remember what had forgotten
;-)
Regards,
M
On Saturday 18 May 2002 12:34 am, Manuel Sugawara wrote:
> Something is pretty broken in redhat 7.3 but I'm not sure what and I
> don't have time to dig further
> Both cases works correctly in Redhat 7.2. Sorry if this is not the
> correct forum however an alert is nice for people planning an Red
> With CVS tip (and float-type timestamps) I get
...
> Seems to be the same result no matter what timestamp is put in.
Yup. Broken for double timestamps. Will patch...
- Thomas
---(end of broadcast)---
TIP 6: Have you searched our
With CVS tip (and float-type timestamps) I get
regression=# select date('2002-02-01 00:00:00'::timestamp);
date
2000-01-01
(1 row)
Seems to be the same result no matter what timestamp is put in.
regards, tom lane
---(end of broa
> I can see the benefit of SASL as a standard in public exposed network
> services like email servers (SMTP, POP, IMAP), where you can support
> different email clients which themselves may or may not support SASL and
> may use different SASL libraries.
>
> But for Postgresql - communications
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
> Sent: 20 May 2002 15:16
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: Re: More schema queries
>
>
> "Dave Page" <[EMAIL PROTECTED]> writes:
> > gcc -g -o postgres.exe -Wl,--base-file,postgres.base postgres.exp
>
Hannu Krosing <[EMAIL PROTECTED]> writes:
> But does PG not have a new index entry for each _version_ of table row ?
Sure, but the entries do go away during vacuum.
> Or does lack-of-btree-collapse-logic affect only keys where there are
> many _different_ keys and not many repeating keys?
The p
On Mon, 2002-05-20 at 16:08, Tom Lane wrote:
> Hannu Krosing <[EMAIL PROTECTED]> writes:
> > On Sun, 2002-05-19 at 19:37, Tom Lane wrote:
> >> I'd rather expect the toast indexes to grow given the lack-of-btree-
> >> collapse-logic issue.
>
> > Why sould the toast indexes grow significantly more
Michael Meskes <[EMAIL PROTECTED]> writes:
> [Moved to hackers}
> On Sun, May 19, 2002 at 04:14:47PM -0400, Tom Lane wrote:
>> preproc.y:5330: fatal error: maximum table size (32767) exceeded
>>
>> This is with
>> $ bison -V
>> GNU Bison version 1.28
> I'm using bison 1.35, but get the same error
On Sat, 2002-05-18 at 01:01, Tom Lane wrote:
> "Dave Page" <[EMAIL PROTECTED]> writes:
> > It doesn't work quite like that anyway.
>
> Oh, so essentially you want to simulate the namespace search on the
> application side. I see.
>
> > Anyway, current_schemas() seems ideal, thanks.
>
> It may
"Dave Page" <[EMAIL PROTECTED]> writes:
> gcc -g -o postgres.exe -Wl,--base-file,postgres.base postgres.exp
> access/SUBSYS.o bootstrap/SUBSYS.o catalog/SUBSYS.o parser/SUBSYS.o
> commands/SUBSYS.o executor /SUBSYS.o lib/SUBSYS.o libpq/SUBSYS.o
> main/SUBSYS.o nodes/SUBSYS.o optimizer/SUBSYS.o por
Hannu Krosing <[EMAIL PROTECTED]> writes:
> On Sun, 2002-05-19 at 19:37, Tom Lane wrote:
>> I'd rather expect the toast indexes to grow given the lack-of-btree-
>> collapse-logic issue.
> Why sould the toast indexes grow significantly more than the primary key
> of main table ?
Well, the toast
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
> Sent: 18 May 2002 00:01
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: Re: More schema queries
>
> I'm not sure how to do it on Cygwin, either. On Unix you'd
> build a profilable backend executable using
>
On Sun, 2002-05-19 at 19:37, Tom Lane wrote:
> Mark kirkwood <[EMAIL PROTECTED]> writes:
> > However I could not get any size stabilization in the toasted case.
>
> Hmm. Which file(s) were growing, exactly? How many row updates is this
> run covering?
>
> I'd rather expect the toast indexes to
At 01:11 AM 5/20/02 -0600, Bear Giles wrote:
> > What are the benefits of SASL+Postgresql compared to Postgresql over
> plain SSL?
>
>The anticipated benefit of SASL is that it would replace all of the
>current authetication code with a set of standard plugins. The
>authority problem would be re
[Moved to hackers}
On Sun, May 19, 2002 at 04:14:47PM -0400, Tom Lane wrote:
> [EMAIL PROTECTED] (Michael Meskes) writes:
> > - Fixed reduce/reduce conflict in parser.
> > - Synced preproc.y with gram.y.
>
> Good, but now I get:
>
> $ make
> bison -y -d preproc.y
> preproc.y:5330: fata
> > > > There are "full width alphabets" in Japanese. Thoes include not only
> > > > ASCII letters but also some European characters.
> > >
> > > Are these ASCII and European characters uppercased in some
> > > Japanese-specific way ?
> >
> > Probably not, but I'm not sure since my Linux box does
33 matches
Mail list logo
