Hello:
>You must send either Flush or Sync after the Parse to force the backend
>to emit its response to Parse. The assumption is that in many cases
>you'll be sending Parse as part of a batch of commands, and the backend
>should batch its responses to minimize the number of network packets
>sent
Bruce Momjian wrote:
See my recent commit of src/tools/pgtest. It might be a good start.
I was wondering if some existing framework, like from the Apache Xalan
package, would be a better point to start from? I hate to say it, Bruce,
but you try to reinvent the wheel by starting with a sled.
Jan
Here's another example of domain casting not working right:
create domain foo as varchar;
select cast(x.y as foo) from (select 'foo') as x(y);
ERROR: coerce_type: no conversion function from "unknown" to foo
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)
Joe Conway writes:
> I don't see anything about multidimensional arrays at all. I take it
> this is SQL99 (ISO/IEC 9075-2:1999 (E))? Can you point to a more
> specific paragraph?
It doesn't say anything specifically about multidimensional arrays, but
the grammar clearly allows declaring arrays of
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Here's another example of domain casting not working right:
> create domain foo as varchar;
> select cast(x.y as foo) from (select 'foo') as x(y);
> ERROR: coerce_type: no conversion function from "unknown" to foo
Not the domain's fault. You get the
On Sat, 28 Jun 2003, Jan Wieck wrote:
> Bruce Momjian wrote:
> > See my recent commit of src/tools/pgtest. It might be a good start.
>
> I was wondering if some existing framework, like from the Apache Xalan
> package, would be a better point to start from? I hate to say it, Bruce,
> but you try
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I am seeing this assembler warning using gcc version 2.95.3 20010315:
> > {standard input}:332: Warning: using `%si' instead of `%esi' due to `w' uffix
> > {standard input}:332: Warning: using `%ax' instead of `%eax' due to `w' suffi
The cited error message appears when loading the attached file (a cut-down
version of a local development version of the information schema) and then
running
select * from problem_schema.element_types;
On the last seven lines of the file I've marked a part that, when removed,
makes the problem di
Darko Prenosil writes:
> Can anyone send a "Hint" to translators, so they can start on time to finish
> the work before final 7.4 release ? There is no point to start translating
> now, because as You said, to much messages will be changed in next two
> weeks. Simple message to HACKERS would be en
Rod Taylor writes:
> Attached is a 7.2.4 dump (loads without error) and a 7.4 dump (loads
> with error).
OK, pg_dump wasn't taking into account that earlier versions didn't have
grant options. I'll fix it.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)-
On Sat, Jun 28, 2003 at 01:25:12AM -0400, Tom Lane wrote:
> Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> >>> Will I destroy things if I execute
> >>> update pg_proc set probin = '/usr/lib/pgsql/plpgsql.so' where proname =
> >>> 'plpgsql_call_handler';
> >>
> >> Nope ... that's what I'd p
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> On the last seven lines of the file I've marked a part that, when removed,
> makes the problem disappear, which might give a hint. Besides that, I'm
> clueless.
Looks like I must have broken this as a side-effect of IN-subselect
optimizations --- 7.3
The documentation build on developer.postgresql.org is working again.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere"
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> The documentation build on developer.postgresql.org is working again.
Good.
Where is the build log for that build kept now? My bookmark is
http://developer.postgresql.org/docs/postgres/buildlog.html
but that doesn't seem to work.
I wrote:
> * Using an array as a table source using UNNEST, something like:
>
> select * from unnest(test.b);
Btw., it would be really nice if some limited form of this could get done,
so I could finish the information schema views pertaining to group
privileges. I'd just need a way to find out
Tom Lane writes:
> Where is the build log for that build kept now? My bookmark is
> http://developer.postgresql.org/docs/postgres/buildlog.html
> but that doesn't seem to work.
Well, I did the first build manually so the build log wasn't saved, and
the next build will only happen when something
Peter Eisentraut wrote:
Btw., it would be really nice if some limited form of this could get done,
so I could finish the information schema views pertaining to group
privileges. I'd just need a way to find out what users are in what
groups. If unnest() would work for locally constant arguments, I
Another way is to put a little shim between the fifo and psql. Here's one I
quickly whipped up in perl (code stolen shamelessly from the perl man
pages). To run in background, invoke thus
( perl myperlfile myfifo | psql gatabase ) &
The only wrinkle I found was that I had to send the \q twice to
Bruce Momjian wrote:
OK, added to TODO:
Modify pg_get_triggerdef() to take a boolean to pretty-print,
and use that as part of pg_dump along with psql
Andreas, can you work on this? I like the idea of removing extra
parens, and merging it into the existing code rather than into co
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Btw., it would be really nice if some limited form of this could get done,
> so I could finish the information schema views pertaining to group
> privileges. I'd just need a way to find out what users are in what
> groups.
As of a few minutes ago,
S
Tom Lane wrote:
Peter Eisentraut <[EMAIL PROTECTED]> writes:
Btw., it would be really nice if some limited form of this could get done,
so I could finish the information schema views pertaining to group
privileges. I'd just need a way to find out what users are in what
groups.
As of a few minutes
Joe Conway wrote:
Hmmm, I just updated to cvs tip (so I could try this), did `configure`,
`make clean`, and `make all` and I'm getting this failure:
make[2]: Leaving directory `/opt/src/pgsql/src/port'
make -C backend all
make[2]: Entering directory `/opt/src/pgsql/src/backend'
msgfmt -o po/cs.mo
Joe Conway wrote:
FWIW, I find that if I remove "hr" and "tr" from this line in
/opt/src/pgsql/src/backend/nls.mk, everything goes fine:
AVAIL_LANGUAGES := cs de es hu ru sv zh_CN zh_TW
Do I need to do something to get new language files?
Replying to myself again ;-)
I was a bit too quick to sa
Tom Lane wrote:
"Francisco Figueiredo Jr." <[EMAIL PROTECTED]> writes:
I'm implementing the 3.0 protocol version in Npgsql, a .Net Data
provider for postgresql.
I stopped in the first message: Parse :(
I send the parse message but I don't receive the ParseComplete or the
ErrorResponse. My code
Carlos Guzman Alvarez wrote:
Hello:
>You must send either Flush or Sync after the Parse to force the backend
>to emit its response to Parse. The assumption is that in many cases
>you'll be sending Parse as part of a batch of commands, and the backend
>should batch its responses to minimize t
Peter Eisentraut wrote:
It doesn't say anything specifically about multidimensional arrays, but
the grammar clearly allows declaring arrays of arrays.
::=
|
|
|
|
::=
::=
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> The cited error message appears when loading the attached file (a cut-down
> version of a local development version of the information schema)
I've been able to reduce the problem to this test case:
drop view x1;
CREATE VIEW x1 AS
SELECT 1
F
On Tue, 24 Jun 2003 [EMAIL PROTECTED] wrote:
> I was researching on cache replacement strategy as well. 2Q has one
> disadvantage see this exellent paper:
> http://www.almaden.ibm.com/cs/people/dmodha/#ARC see the paper
> "ARC: A Self-Tuning, Low Overhead Replacement Cache" for theory and "One
> U
A minor feature request:
PostgreSQL supports ISO-8601 week numbers with the syntax EXTRACT(WEEK FROM
timestamp) or TO_CHAR(timestamp,'IW'). There is, however, no easy way to
extract the year corresponding to the week number.
Since ISO weeks may overlap year boundaries, this makes the week number
On Tue, 24 Jun 2003, Tom Lane wrote:
> Yutaka tanida <[EMAIL PROTECTED]> writes:
> > [EMAIL PROTECTED] wrote:
> >> does pgbench test with relatively large sequential scans?
>
> > Probably no.
>
> pgbench tries to avoid any seqscans at all, I believe, so it wouldn't be
> very useful for testing
On Tue, 24 Jun 2003 10:27:09 -0400
Tom Lane <[EMAIL PROTECTED]> wrote:
> I tried to implement LRU-2 awhile ago, and got discouraged when I
> couldn't see any performance improvement. But I was using pgbench as
> the test case, and failed to think about its lack of seqscans.
How about cache hit
I'm not subscribed to this list, so please CC me on replies.
I wanted to know when table partitioning was supposed to be completed. I
was under the impression that work had been done about 5 months ago or
more and that all that was needed was testing. Could someone please
advise?
We're looking at
Hi
Can someone give me the email ID of Jan Wieck who has written that
code in ruleutils.c? It is urgent.
Sumit
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's d
[EMAIL PROTECTED] wrote:
> > I tried to implement LRU-2 awhile ago, and got discouraged when I
> > couldn't see any performance improvement. But I was using pgbench as
> > the test case, and failed to think about its lack of seqscans.
>
> Yes , lru-2 will behave like LRU under 'normal' load. it w
ftp://ftp.kame.net/pub/kame/misc/
has IPv6 datatype patch (makes "inet" type handle both IPv4 and IPv6)
for 7.3.2. let me know how i can proceed/help.
itojun
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ
On Wed, 25 Jun 2003, Robert Treat wrote:
> Seems like we should also allow for a windows specific distribution of libpq
> as well.
I thought that the win32 stuff was being included as part of the base
distribution? IF so, wouldn't such already be included in any
libpq.tar.gz we created? Is ther
My solution did not involve tablespaces, but was more of a quick solution
to make it easier for admins to do _some_ sort of physical configuration.
The idea is that the developer could do something like
'create alternate location ALTERNATE_LOCATION_NAME for
DATABASE_OBJECT_NAME at "/PATH/TO/PHYSI
How come you didn't get a "No such function with those arguments" error that I always
get when I do that?
planning=# create function oops (integer) returns int language pltcl as '
planning'# elog NOTICE "blah"
planning'# ';
CREATE FUNCTION
planning=# select oops (cast('duh' as varchar));
ERROR:
> Well, correct solution is to implement tablespaces on which objects like
> databases, tables and indexes can be put.
I've not looked at the SQL standard, but it seems to me like the order
should be:
Databases
Tablespaces
Schemas
Objects (tables, indexes, functions, etc.)
A
Tatsuo Ishii wrote:
>
> > > > I reported bug #943 (I found in 7.3.2) and you checked in some change against
> > > > integer overflow.
> > > > Now I upgraded to 7.3.3 and I'm not happy with this.
> > > > The exact error as I described is fixed, but I found new errors in conversion
> > > > UTF-8 <
On Sat, 28 Jun 2003, Joe Conway wrote:
> > Do I need to do something to get new language files?
>
> causing me problems. Did a "cvs add" get missed somewhere, or am I doing
> something wrong?
Yes, a couple of cvs add was forgotten.
Peter made an update with the comment "Merge PO file updates f
41 matches
Mail list logo
