to this or logged at all.
Kris Jurka
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
not be found in the specified
path
[where I checked out the
source]\src\test\regress\tmp_check\install\home\mingfarm\tmp\inst\bin;
.;C:\WINNT\system; C:\WINNT; C:\cygwin\usr\local\bin; C:\cygwin\bin;
C:\cygwin\usr\usr\X11R6\bin; [The rest of my %PATH% environment setting]
Kris Jurka
for every
build for unknown reasons while succeeding if not run from cron. That
further demotivated me from scheduling mingw builds. Perhaps snake's
maintainer could share his configuration?
Kris Jurka
---(end of broadcast)---
TIP 1: if posting
easier to
find.
Kris Jurka
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
when a
clean build came through.
Kris Jurka
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
NetBSD doesn't offer pl/java now so I'm not sure what point you are
trying to make. Sure it would be nice if every OS provided every version
of every package, but when they don't what are you going to do about it?
Provide a complete package or require manual assembly?
Kris Jurka
platform
are you using?
I tested on Solaris 9 with Sun compiler and Debian unstable with
gcc-4.1.1. Debian only failed on contrib while Solaris failed on both
core and contrib.
Kris Jurka
---(end of broadcast)---
TIP 1: if posting/reading
was no different than any other day. As to whether it's a
real issue or not I have no idea. It is a virtual machine that is subject
to the load on other VMs, but none of them were scheduled to do
anything at the time.
Kris Jurka
---(end of broadcast
/05/18
Kris Jurka
---(end of broadcast)---
TIP 6: explain analyze is your friend
at ./s_lock.c:402.
Kris Jurka? src/backend/storage/lmgr/s_lock_test
Index: src/backend/storage/lmgr/Makefile
===
RCS file: /projects/cvsroot/pgsql/src/backend/storage/lmgr/Makefile,v
retrieving revision 1.20
diff -c -r1.20 Makefile
*** src
On Fri, 28 Apr 2006, Theo Schlossnagle wrote:
Kris Jurka wrote:
Anyway the test exits with
Stuck spinlock (80618e9) detected at ./s_lock.c:355.
on a linux gcc build this exits with
Stuck spinlock (0x5013ad) detected at ./s_lock.c:402.
This seems like a different problem, no? The patch I
On Mon, 24 Apr 2006, Gevik Babakhani wrote:
I noticed the following compile warnings. Perhaps someone is interested
to know about them.
Also I was testing a gcc 4.2 snapshot (20060419) and it has a whole lot of
warnings stemming from heap_getattr's isnull check:
aclchk.c:791: warning:
), \
(Datum)NULL \
removes the warning. It seems silly for the GCC people to add warnings
for this kind of stuff without a simple way to bypass it...
Yes, this coding removes the warning.
Kris Jurka
---(end of broadcast)---
TIP 1: if posting
On Mon, 24 Apr 2006, Bruce Momjian wrote:
Great, fix attached and applied.
You also need to change lines 48 and 64 of heapam.h to use the same
coding.
Kris Jurka
---(end of broadcast)---
TIP 5: don't forget to increase your free space map
key difference would be that synonyms track schema updates, like
adding a column, to the referenced object that a view would not.
Kris Jurka
---(end of broadcast)---
TIP 6: explain analyze is your friend
?
I still think this should be applied to back branches. The patches queue
is really quite a bit behind.
http://archives.postgresql.org/pgsql-hackers/2006-01/msg00175.php
Kris Jurka
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
, not stable.
Kris Jurka
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
not convert UTF8 character 0x00e6 to ISO8859-1
Kris Jurka
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
://archives.postgresql.org/pgsql-bugs/2005-12/msg00048.php
Kris Jurka
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
is getting confused because it uses
a named statement, but the unnamed portal.
Kris Jurka
---(end of broadcast)---
TIP 6: explain analyze is your friend
is
not a reasonable thing to do.
Kris Jurka
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
-hackers/2002-04/msg01461.php
Although I'm not sure people want GSSAPI support in the backend given
the comments on adding SASL support here:
http://archives.postgresql.org/pgsql-hackers/2002-05/msg00760.php
Kris Jurka
---(end of broadcast)---
TIP 6
running on other machines if you'd like me
to test something specific.
Kris Jurka
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ctids matching the index
before accessing the heap rows.
This is done (see bitmap index scans).
Will the optimizer ever choose this plan when dealing with only one index?
Kris Jurka
---(end of broadcast)---
TIP 1: if posting/reading through
more knowledge of the
machines and their other workloads.
Kris Jurka
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get
On Sun, 17 Jul 2005, Tom Lane wrote:
The short answer is that you should install flex 2.5.4, or else forget
about testing the 7.2 branch. I don't think anyone will be very
interested in making 7.2 work with flex 2.5.31.
Actually there are problems in the 7.3 branch as well in the cube,
previously and further what type it has been prepared for so that it can
cast the 71 or prepare a new statement.
Kris Jurka
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
as I see it is that gcc is choosing to link libz.a rather than
libz.so --- why is that happening?
The link line says -L/usr/local/lib -lz and libz.a is in /usr/local/lib
while libz.so is in /usr/lib.
Kris Jurka
---(end of broadcast)---
TIP 6
On Sat, 16 Jul 2005, Tom Lane wrote:
Kris Jurka [EMAIL PROTECTED] writes:
The link line says -L/usr/local/lib -lz and libz.a is in /usr/local/lib
while libz.so is in /usr/lib.
Well, that is a flat-out configuration error on the local sysadmin's
part. I can't think of any good
On Fri, 15 Jul 2005, Marko Kreen wrote:
[buildfarm machine dragonfly]
On Tue, Jul 12, 2005 at 01:06:46PM -0500, Kris Jurka wrote:
Well the buildfarm machine kudu is actually the same machine just building
with the Sun compiler and it works fine. It links all of libz.a
On Tue, 12 Jul 2005, Marko Kreen wrote:
On Mon, Jul 11, 2005 at 04:47:18PM -0700, Kris Jurka wrote:
Marko Kreen wrote:
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=dragonflydt=2005-07-11%2003:30:04
Linking problem with zlib on Solaris 9/x86. I am clueless about
this. I can
/lib/libz.so.
Kris Jurka
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
On Tue, 28 Jun 2005, Josh Berkus wrote:
The TODO: add an --encoding=[encoding name] option to pg_dump. This would
set client_encoding for pg_dump's session(s).
What about just using the PGCLIENTENCODING environment variable?
Kris Jurka
---(end of broadcast
Workshop 6 update 2 C 5.3, gcc 3.2.3
gcc -O1 crctest.c .251422
gcc -O3 crctest.c .240223
gcc -O1 crctest64.c.281369
gcc -O3 crctest64.c.631290
cc -O crctest.c.268905
cc -fast crctest.c .242429
cc -O crctest64.c .283278
cc -fast crctest64.c .255560
Kris Jurka
On Mon, 2 May 2005, Jim C. Nasby wrote:
FWIW, I've found myself wishing I could set statement_timeout on a per user
or per group basis. Likewise for log_min_duration_statement.
See ALTER USER ... SET
Kris Jurka
---(end of broadcast)---
TIP
the PostgreSQL Foundation
http://thepostgresqlfoundation.org/ would step in and do, but we seem much
more focused on advocacy efforts rather than developemnt ones.
Kris Jurka
---(end of broadcast)---
TIP 3: if posting/reading through Usenet
don't seem to produce results, largely from a lack of cash.
(Here's $500 for two weeks of work).
Anyone care to shed some light on how it works now?
Kris Jurka
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send
advanced
PostgreSQL client interface
http://jdbc.postgresql.org/documentation/80/ch06.html#callproc-resultset-refcursor
Kris Jurka
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
, but it does allow for more return
flexibility.
Kris Jurka
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
On Sat, 15 Jan 2005, Brendan Jurd wrote:
SELECT time_span( 'minute', now(), interval '10:43:55' );
643
The timestamp argument to this version of the function seems completely
irrelevent.
Kris Jurka
---(end of broadcast)---
TIP 2: you can
,fe626a7cc9021d12,4f1d0575be60c26f,5c44463d8ef0e1ef,ceff42f0dae09272,dc9da98adcb6142c,7f34133e99b38825,28b43c5e79924da6,98be76099ea6513f,5d3f19a69e3b5a93?thread_id=7d35d3eb00ffd0e8mode=threadnoheader=1q=oleg+limit+sort#doc_7f34133e99b38825
Kris Jurka
---(end of broadcast)---
TIP 1
information on what your actual problem is,
no one will be able to help you.
Kris Jurka
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
owns in other databases.
What about Alvaro's shared dependencies work:
http://archives.postgresql.org/pgsql-hackers/2004-10/msg00963.php
Kris Jurka
---(end of broadcast)---
TIP 8: explain analyze is your friend
(or
whatever objects) on other databases.
Kris Jurka
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
mentioned earlier
are found in both libtermcap and libcurses, so I imagine linking to curses
is still the correct thing to do.
Kris Jurka
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org
reference to `tgetent'
/usr/lib/libedit.so: undefined reference to `tgetstr'
This is on x86 NetBSD 1.6.
Kris Jurka
---(end of broadcast)---
TIP 8: explain analyze is your friend
, but with a buffered stream
nothing happens until a Sync message is sent and the stream is flushed.
Then it collects the results of all of the executes.
Kris Jurka
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
formats
- ignoring duplicates
- outputting an arbitrary SELECT statement
Kris Jurka
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
you think 31 is the failure case your
thinking of or whether 31 might help.
Kris Jurka
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
4.5
Kris Jurka
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
with LATIN1 data into a table whose name contained UNICODE characters
could not be done. Does this seem like a reasonable thing to do?
Kris Jurka
On Mon, 8 Nov 2004, Barry Lind wrote:
I am assuming this will get addressed in the backend in 8.1 and that
would be the upgrade path. (I agree
thing is NULL when you introduce a NULL element:
# select array[1,2,3,null,4,5];
array
---
(1 row)
or
# select array[1,2,3,null,4,5] IS NULL;
?column?
--
t
(1 row)
Kris Jurka
---(end of broadcast)---
TIP 5: Have you checked
difference.
Kris Jurka
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
on the server side. Also the server doesn't have a Ref
datatype, so you really can't implement get/setRef without it.
Kris Jurka
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
to scrollable cursors without other major changes as the Execute
protocol message assumes forward only operation.
Kris Jurka
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
to the backend. From a driver
perspective it has no idea what the end user's intention is and
therefore cannot do things like transform a query to a cursor based
statement or even use the V3 protocol because it has no idea if the caller
is going to use a subtransaction at some point.
Kris Jurka
();
stmt.executeUpdate(INSERT INTO t VALUES (1));
long oid = ((org.postgresql.PGStatement)stmt).getLastOID();
Kris Jurka
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do
; will do what you were expecting.
Kris Jurka
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
the
statement removes this valuable data. Any insight on why it isn't there
or how to fix it?
Kris Jurka
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
) into one of the fields. The database replies
with an error message:
This has been fixed in the 7.4 driver which is compatible with 7.3
servers. Try downloading it from http://jdbc.postgresql.org/download.html
Kris Jurka
---(end of broadcast
, and I'm stuck on this issue.
CREATE TABLE t (a int);
INSERT INTO t VALUES (1);
INSERT INTO t VALUES (2);
PREPARE mystatement AS DELETE FROM t;
EXECUTE mystatement;
would ideally return EXECUTE 2
Kris Jurka
---(end of broadcast)---
TIP 9: the planner
On Sun, 21 Mar 2004, Tom Lane wrote:
On 21-Mar-04, at 11:39 AM, Kris Jurka wrote:
Would it be possible to have the command completion tag for EXECUTE
return
the affected row count?
However, does this really solve Kris' problem? JDBC generally likes to
think that it works with old
is
dropped and recreated, the grants must be done again. The real use of a
SELECT ANY TABLE permission is ignorance of schema updates.
Kris Jurka
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send
On Wed, 10 Mar 2004, Andreas Pflug wrote:
Kris Jurka wrote:
On Wed, 10 Mar 2004, Andreas Pflug wrote:
The problem that cannot be solved with either this or a function that
loops and grants on each table is that it is not a permanent grant of what
the admin had in mind. If a new
if it
happened to be the one to hit an exhausted cache.
Kris Jurka
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
the
permissions on the directories in the path.
Kris Jurka
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
a ResultSet object which it does. As you note using
executeQuery works, but won't if there isn't a rule. Perhaps using plain
execute() would be the most appropriate thing to do.
Kris Jurka
---(end of broadcast)---
TIP 9: the planner will ignore your
On Fri, 16 Jan 2004, Christopher Kings-Lynne wrote:
Is this a neat idea?
SELECT * FROM (SHOW ALL);
So neat in fact that it has been implemented.
SELECT * FROM pg_settings;
Kris Jurka
---(end of broadcast)---
TIP 4: Don't 'kill -9
questions to the pgsql-jdbc list.
You may not set the client encoding from JDBC. The JDBC driver requires a
unicode client encoding to work properly. You may then reencode the data
in your charset of preference using the standard java APIs.
Kris Jurka
---(end
out with varchar2 which they've maintained every since valuing backwards
compatability more than the sql standard.
Kris Jurka
---(end of broadcast)---
TIP 8: explain analyze is your friend
trying to match
pg_constraint.conkey to pg_index.indkey (for which no default operator
exists), but even this can fail if you have the unlikely situation of two
unique indexes covering the same columns.
Kris Jurka
---(end of broadcast)---
TIP 1
isn't from having to prepare the query each time,
it's from having to start psql and open a new connection each time.
Perhaps you need to rethink your design and go with something that will
maintain a persistent connection.
Kris Jurka
---(end of broadcast
at the moment.
Kris Jurka
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
REFERENCES t3 ON DELETE CASCADE);
INSERT INTO t3 VALUES(1);
INSERT INTO t4 VALUES(1);
COMMIT;
SELECT * FROM t4 WHERE a NOT IN (SELECT a FROM t3);
Kris Jurka
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
I don't see a tag for in cvs for the 7.3.3 release.
Kris Jurka
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
I'm guessing his problem is that he's expecting this to come out of psql
and not go to the backend's stdout.
Kris Jurka
On Wed, 28 May 2003, Christopher Kings-Lynne wrote:
Hi,
This is a much better way than printf:
elog(NOTICE, this is my test: %s, string);
Chris
- Original
the response as suggested by Hiroshi.
Is zeroing the pages the only / best option? Hiroshi suggested skipping
the pages as I recall. Is there any chance of recovering data from a
trashed page manually? If so perhaps the GUC variable should allow three
options: error, zero, and skip.
Kris Jurka
On Wed, 19 Mar 2003, Bruce Momjian wrote:
Here are a list of features that might be in 7.4. I know there are
several people involved in each of these items.
Tablespaces
I haven't seen any proposal for tablespaces recently. Is this something
that is actively being worked on?
Kris Jurka
a dump from 7.2 is loaded into 7.3
no foreign keys are listed in pg_constraint, so some backwards
compatibility will be required because even if the 7.3 server supports
this functionality it does not mean it is being used.
Kris Jurka
---(end of broadcast
On Mon, 2 Dec 2002, Henner Zeller wrote:
Hi,
Just compiled the 7.3 branch from source and made some tests using the
JDBC driver coming with it. I did some tests with the henplus
JDBC-shell and noticed some problems quering the database meta data:
o the foreign key name is 'wierd'
Apparently only some settings are adjustable.
root@dev:~# uname -smr
FreeBSD 4.2-RELEASE i386
root@dev:~# sysctl -a | grep kern.ipc.semm
kern.ipc.semmap: 30
kern.ipc.semmni: 10
kern.ipc.semmns: 60
kern.ipc.semmnu: 30
kern.ipc.semmsl: 60
root@dev:~# sysctl -w kern.ipc.semmap=50
kern.ipc.semmap:
). That would imply that login is unique as well. Any
function which returns different results given the same input is no good
for a functional index anyway.
http://archives.postgresql.org/pgsql-committers/2002-09/msg00293.php
Kris Jurka
---(end of broadcast
On Thu, 19 Sep 2002, Kris Jurka wrote:
On Thu, 19 Sep 2002, Tom Lane wrote:
Kris Jurka [EMAIL PROTECTED] writes:
While adding schema support to the JDBC Driver, I came across a query
which occasionally generates some spectacularly bad plans.
Hm, does an ANALYZE help?
Yes
a reasonable join order using explicit JOINs, but I thought
someone might be interested in a test case for the optimizer.
Kris Jurka
The query tries to determine what foreign keys exists between the
following tables.
create table people (id int4 primary key, name text);
create table policy (id
On Thu, 19 Sep 2002, Tom Lane wrote:
Kris Jurka [EMAIL PROTECTED] writes:
While adding schema support to the JDBC Driver, I came across a query
which occasionally generates some spectacularly bad plans.
Hm, does an ANALYZE help?
Yes, it does, but I don't understand why. The query
that
supports a given foreign key constraint.
See my post to bugs:
http://fts.postgresql.org/db/mw/msg.html?mid=1074855
Kris Jurka
On Thu, 19 Sep 2002, Bruce Momjian wrote:
Congratulations. That is the largest plan I have ever seen
101 - 186 of 186 matches
Mail list logo