[GENERAL] Re: [INTERFACES] threads and libpq

1999-03-11 Thread Tom Lane
PQconnectdb(). BTW this all assumes that you have a thread-safe libc; if malloc is not thread-safe then all bets are off... Is there anyone working on multi threading for libpq ? I don't really see a need for libpq to be thread-aware. regards, tom lane

[GENERAL] Re: [INTERFACES] Problem using Having in a sub-query wit the Count function.

1999-03-24 Thread Tom Lane
ames in this context... regards, tom lane

[GENERAL] Re: [HACKERS] backend dies suddenly after a lot of error messages

1999-05-12 Thread Tom Lane
2.2.8. I still see it with 6.5-current sources. Will take a look. regards, tom lane

[GENERAL] Re: [INTERFACES] large objects

1999-06-30 Thread Tom Lane
Lauri Posti [EMAIL PROTECTED] writes: I've been trying to get postgres LO interface to work with python. I think you need begin/end transaction around lo_open ... lo_close sequence. regards, tom lane

[GENERAL] Re: [SQL] Bad update performance?

1999-07-21 Thread Tom Lane
date performance? No, it would not help a query like that --- though if you added a clause like "where divis = 'oldvalue'" then an index would help to find the rows that need updated. Actually, every index you add *slows down* updates, since all the indexes must be updated along with the table. regards, tom lane

[GENERAL] Re: [HACKERS] inheritance

1999-07-21 Thread Tom Lane
if the serial column was created "by hand" with a "DEFAULT nextval('some_sequence')" clause? I suspect that any way we jump on this sort of question will be wrong for some apps, so it should be possible to suppress system copying of attributes... regards, tom lane

[GENERAL] Re: [SQL] bad select performance fixed by forbidding hash joins

1999-07-21 Thread Tom Lane
be willing to send me a database dump so that I can reproduce the problem exactly? (If the dump is no more than a few megabytes, emailing it should be OK.) No big hurry, since I probably won't be able to get to it for a week or so anyway. regards, tom lane

[GENERAL] Re: [HACKERS] getting at the actual int4 value of an abstime

1999-08-18 Thread Tom Lane
seconds with epoch 1/1/2000), so relying on the internal representation of abstime would be a bad idea... regards, tom lane

[GENERAL] Re: [HACKERS] BUG with UNIQUE clause

1999-09-15 Thread Tom Lane
ks to find the patch. regards, tom lane

[GENERAL] Re: [HACKERS] Permission problem with COPY FROM

1999-09-15 Thread Tom Lane
ql, rather than those of the Postgres server, which is usually a Good Thing. Also, if you are contacting a server on a different machine, \copy works with files in the local filesystem, not the server's filesystem. regards, tom lane

Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions

1999-11-28 Thread Tom Lane
of pg_shadow that the postmaster uses for password authentication? Then at least you'd have some shot at figuring out which file was what in extremis... regards, tom lane

Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions

1999-11-29 Thread Tom Lane
crashed in the middle of a table rename ;-) regards, tom lane

[GENERAL] Re: [HACKERS] TRANSACTIONS

2000-02-22 Thread Tom Lane
t. I see no way that allowing the transaction to commit after an overflow can be called consistent with the spec. regards, tom lane

Re: [GENERAL] 7.0RC1: possible query and backend problem

2000-04-28 Thread Tom Lane
See the difference? 120 vs 144? What's causing that I wonder... and would it explain the failure to reattach? regards, tom lane

Re: [GENERAL] 7.0RC1: possible query and backend problem

2000-04-29 Thread Tom Lane
conflicts before any shared memory segments are touched. But I'm not sure about it. regards, tom lane PS: if you don't see the connection between port number and shmem, it's this: the key numbers used for shmem segments are computed from the port number. So different pos

[GENERAL] Re: [SQL] textsubstr() ...? for postgres 7 beta5

2000-04-30 Thread Tom Lane
? regards, tom lane

Re: [HACKERS] Re: [GENERAL] Re: [SQL] textsubstr() ...? for postgres 7 beta5

2000-04-30 Thread Tom Lane
Is this in 7.0 ? Looks like it's called just plain "substr" now. See http://www.postgresql.org/docs/postgres/functions.htm regards, tom lane

Re: [GENERAL] New geographic types....

2000-05-09 Thread Tom Lane
, not working, stable enough, unstable,...) This should happen for 7.1 which we are hoping to have out circa Aug-Sep. Jan Wieck would have to be the one to give you any more-detailed projection than that. It's certainly not there yet in any usable form. regards, tom lane

Re: [GENERAL] Problems compiling version 7

2000-05-09 Thread Tom Lane
this in Red Hat 6.0 Weird. Do you not have 'tr' in your PATH? You wouldn't be running with some bizarre LOCALE setting, by any chance? regards, tom lane

Re: [GENERAL] Query bombed: why?

2000-05-09 Thread Tom Lane
unmatched entries... Certainly 70 rows are not going to strain memory ;-). My guess is that the query didn't do what you thought, but instead produced some sort of cross-product result... regards, tom lane

Re: [GENERAL] Problems compiling version 7

2000-05-09 Thread Tom Lane
or mis-extracted) here. So it kinda looks to me like we could rip out this test, hardwire the translation as tr '[a-z]' '[A-Z]' and be no worse off. Does anyone recall why this test is in there to begin with? regards, tom lane

Re: [GENERAL] textpos() function

2000-05-09 Thread Tom Lane
guess this is another one ... If you really don't want to update your app's code just yet, you can install a pg_proc entry that defines textpos() with a CREATE FUNCTION command. But the long-term answer is to fix your code to conform with the standard. regards, tom lane

Re: [GENERAL] 7.0 RPM?

2000-05-09 Thread Tom Lane
pg_upgrade to update from any 6.5-or-later version if you are feeling adventurous, but I'd definitely suggest making a backup first in case things go wrong and you have to initdb and restore. regards, tom lane

Re: [HACKERS] Re: [GENERAL] Problems compiling version 7

2000-05-10 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: On Tue, 9 May 2000, Tom Lane wrote: dnl Check tr flags to convert from lower to upper case Does anyone recall why this test is in there to begin with? I don't see the results of this test being used anywhere at all, so I'd say yank it. If your

Re: [GENERAL] backend running out of memory in v7.0

2000-05-11 Thread Tom Lane
-by-reference datatypes. There are plans on the table to fix that for 7.1. But, that might or might not be your problem. It's difficult to give any advice without some details about the queries that are giving you trouble. regards, tom lane

Re: [GENERAL] backend running out of memory in v7.0

2000-05-12 Thread Tom Lane
the archives. Basically you want to define "ndaysago(int) returns timestamp" so that the optimizer can't see that there are any uncacheable functions involved; then it'll evaluate the subexpressions just once at query start. regards, tom lane

Re: [GENERAL] int8 and hash index

2000-05-12 Thread Tom Lane
m catalogs for subreleases. Sorry. Just counting entries, that may not be the only type that has entries in pg_amop but not pg_amproc. I feel another oprsanity regression-test check coming on... regards, tom lane

Re: [GENERAL] Performance

2000-05-15 Thread Tom Lane
ds. Could be that 7.0 is less willing to use the index than 6.5 was. See thread "indexes ingnored on simple query in 7.0" over in pgsql-sql for ways to investigate the problem and one possible solution. regards, tom lane

Re: [GENERAL] Best way to add columns

2000-05-15 Thread Tom Lane
the trouble. regards, tom lane

Re: [GENERAL] Performance

2000-05-16 Thread Tom Lane
stified. As it happened they would pick an indexscan for the one-sided-inequality case even with no stats available. In some cases that was good, in others it'd lose big. regards, tom lane

Re: [GENERAL] initdb and exit_nicely...

2000-05-17 Thread Tom Lane
if initdb didn't overwrite it (nor delete it on failure), but I'm not sure it's worth the trouble. Something that would be a lot simpler is to refuse to run at all if the $PGDATA dir exists and is nonempty ;-) regards, tom lane

Re: [GENERAL] getting libperl.so

2000-05-17 Thread Tom Lane
configure script asks you if you want a shared libperl. You can probably default all the other answers, except maybe for the location you want the perl directory tree placed ... regards, tom lane PS: be careful not to lose any Perl modules you may have installed that

Re: [GENERAL] Passing arguments to and INDEX function.

2000-05-18 Thread Tom Lane
regards, tom lane

Re: [GENERAL] Error in manual

2000-05-18 Thread Tom Lane
d recreate the function. I believe there is a "LOAD" command that will reload the library without needing to restart the backend. Not sure if that's any easier than just restarting though... but this should probably be noted somewhere in the programmers manual. Agreed.

Re: [GENERAL] Columns in pg_shadow?

2000-05-21 Thread Tom Lane
. regards, tom lane

Re: [GENERAL] crash on \copy

2000-05-21 Thread Tom Lane
: arguments required regards, tom lane

Re: [GENERAL] fmgr_info error

2000-05-21 Thread Tom Lane
referencing a function whenever you remake the function. regards, tom lane

Logging (was Re: [GENERAL] PostgreSQL 7.0-2 RPMset released.)

2000-05-21 Thread Tom Lane
be a lot of code involved, we just need a well-thought-out spec for how it should work. Comments anyone? regards, tom lane

Re: [GENERAL] Explain auth/access/priv system??

2000-05-23 Thread Tom Lane
y particular users any access to particular databases, but that's about the extent of your flexibility. This is being worked on... - What do I need to do in order to allow multiple users the abililty to create tables in a single database? Nada, see above. regards, tom lane

Re: [GENERAL] Can't delete Null value from a not null field

2000-05-23 Thread Tom Lane
bad record and then reload it. Slightly faster than a dump and reload: RENAME broken table to something else; CREATE TABLE new-table; INSERT INTO new-table SELECT * FROM broken-table WHERE custid IS NOT NULL; then recreate the indexes wanted on new-table... regards, tom lane

Re: [GENERAL] Postgres Instability

2000-05-24 Thread Tom Lane
the error message then it looks like your path may be messed up... regards, tom lane

Re: [GENERAL] 7.0 installation problem, help please :-(

2000-05-24 Thread Tom Lane
, but maybe there's a screw loose somewhere... regards, tom lane

Re: [GENERAL] PG 7.0 is 2.5 times slower running a big report

2000-05-24 Thread Tom Lane
about how the queries are being executed? Do you by any chance have the 6.5.3 system still available to compare its EXPLAIN output? regards, tom lane

Re: [GENERAL] table rename oddity

2000-05-25 Thread Tom Lane
directory and rename the file. I have tested this with version 7.0. Boo hiss --- the physical file rename must be the *last* step in table rename, after all other possible errors have been checked. Evidently it's not :-(. Will fix. regards, tom lane

Re: [GENERAL] problem with NOTICE: _outNode: don't know how to print type

2000-05-25 Thread Tom Lane
underneath. Will look. regards, tom lane

Re: [GENERAL] Public Domain SQL grammars?

2000-05-25 Thread Tom Lane
ahead is needed to tell which production to use next. You might care to read the 'bison' (GNU yacc) manual on the subject of removing parse conflicts. regards, tom lane

Re: [GENERAL] Re: [ANNOUNCE] PostgreSQL 7.0 a success

2000-05-25 Thread Tom Lane
should eliminate those problems. regards, tom lane

Re: [GENERAL] PG 7.0 is 2.5 times slower running a big report

2000-05-25 Thread Tom Lane
n and sort the report gets no data for the first 30 minutes and then runs at about 4 times the rate of the index scan. Right, that's what you'd expect: the sort has to be completed before it knows which row to deliver first, but an indexscan has no such startup cost. regards, tom lane

Re: [GENERAL] problem with NOTICE: _outNode: don't know how to print type

2000-05-25 Thread Tom Lane
. regards, tom lane

Re: [GENERAL] Limits on PostgreSQL

2000-05-25 Thread Tom Lane
run them via a cursor or a plain SELECT. regards, tom lane

Re: [GENERAL] PG 7.0 vacuum problem

2000-05-25 Thread Tom Lane
reference counts. But the real question is how did it get into this state in the first place... regards, tom lane

Re: [GENERAL] initdb and exit_nicely...

2000-05-25 Thread Tom Lane
$PGDATA"` if test "x$CONTENTS" = x Are we talking 7.0.1 material, btw? Well, we would be if we were sure of the patch. I'm a little worried about portability though. Given that this isn't a very critical issue (IMHO) I'd recommend saving it for the 7.1 cycle. regards, tom lane

Re: [GENERAL] Speed of locating tables?

2000-05-26 Thread Tom Lane
Barry Lind [EMAIL PROTECTED] writes: I am curious, how does PostgreSQL support tables larger than 2Gig, given the file per table architecture? Multiple files per table ... regards, tom lane

Re: [GENERAL] Failed regression tests

2000-05-26 Thread Tom Lane
. regards, tom lane

Re: [GENERAL] SPI file locations

2000-05-26 Thread Tom Lane
nyone much noticing... regards, tom lane

Re: [GENERAL] Questions about CURSORS

2000-05-28 Thread Tom Lane
ecommended in our FAQ, I believe. (Hey Bruce, does your new book go into this stuff?) regards, tom lane

Re: [GENERAL] Arguments not being passed to a function

2000-05-28 Thread Tom Lane
ppropriate patch is #ifndef NO_FASTPATH + isNull = false; retval = fmgr_array_args(fid, nargs, arg, isNull); #else retval = NULL; #endif /* NO_FASTPATH */ regards, tom lane

Re: [GENERAL] Vacuum analyze vs just Vacuum

2000-05-28 Thread Tom Lane
backward-compatibility reasons... regards, tom lane

Re: [GENERAL] initdb and exit_nicely...

2000-05-18 Thread Tom Lane
we are doing anyone a service if we tweak initdb in a way that will make it slightly safer to keep random files in PGDATA. You shouldn't do it anyway, and modifying initdb to make it look like you can will only increase the risk of people accidentally screwing up their installation. regards, tom lane

Re: [GENERAL] lots of large objects and toast

2000-05-29 Thread Tom Lane
obviously going to be a necessary feature if we want to make the existing flavor of large objects obsolete. There have been some preliminary discussions about it --- AFAIR no one's laid out a complete proposal yet. regards, tom lane

Re: [GENERAL] Postgresql usage clip.

2000-05-29 Thread Tom Lane
se Windoze as a platform for a mission-critical application, regardless of database engine choice. So the cygwin port is pretty much a toy IMHO. If MySQL wants to have the toy-application market segment, they're welcome to it. regards, tom lane

Re: [GENERAL] Perl interfaces?

2000-05-31 Thread Tom Lane
, but you can find it if you search by module name. regards, tom lane

Re: [GENERAL] CREATE USER

2000-06-01 Thread Tom Lane
pretty silly that CREATE USER is stiffnecked about this when DROP TABLE is not --- the bad consequences of rolling back DROP TABLE are a lot worse. regards, tom lane

Re: [GENERAL] btree index and max()

2000-06-01 Thread Tom Lane
se queries. Perhaps someday we will try to convert simple uses of MIN/MAX into queries like these, but for now, you gotta do it by hand. regards, tom lane

Re: [GENERAL] Postmaster won't -HUP

2000-06-01 Thread Tom Lane
with WHERE DOB = '1999-01-01' regards, tom lane

Re: [GENERAL] index problem

2000-06-01 Thread Tom Lane
one table is better than restoring your whole DB. In the meantime, this is a high-priority bug fix... regards, tom lane

Re: [GENERAL] Postmaster won't -HUP

2000-06-01 Thread Tom Lane
so I wouldn't advise doing it during normal usage of the system.) regards, tom lane

Re: [GENERAL] query optimiser changes 6.5-7.0

2000-06-01 Thread Tom Lane
pical uses... regards, tom lane

Re: [GENERAL] interval questions

2000-06-01 Thread Tom Lane
? regards, tom lane

Re: [GENERAL] Compiling Error

2000-06-04 Thread Tom Lane
exit status You probably need an explicit "-lcrypt" in your link command. Some platforms need that, some don't... regards, tom lane

Re: [GENERAL] Vacuum Question

2000-06-06 Thread Tom Lane
m, at least not IMHO. For now, the answer is "if it hurts, don't do it ;-)" regards, tom lane

Re: [GENERAL] Precision of calculated numeric fields

2000-06-06 Thread Tom Lane
e the same value you find in atttypmod for the underlying table's field. regards, tom lane

Re: [GENERAL] Vacuum Question

2000-06-06 Thread Tom Lane
s not exist" and "init_fcache: null probin for procedure 481". This seems to be due to VACUUM (on system tables) causing syscache entries to be flushed at unexpected times. I've committed patches for the two cases I observed, but there may be more lurking... regards, tom lane

Re: [GENERAL] Vacuum Question

2000-06-06 Thread Tom Lane
Ed Loehr [EMAIL PROTECTED] writes: Tom Lane wrote: I can't reproduce any problem with just a "vacuum" (with or without analyze) and no following command. I did, however, notice that very occasionally the inserting process would spit out weird error messages like "Functio

Re: [GENERAL] Dump

2000-06-06 Thread Tom Lane
version are you using now? COPY used to have a memory leak problem according to the CVS logs, but that was long ago (pre-6.4). regards, tom lane

Re: [GENERAL] Composite Types

2000-06-06 Thread Tom Lane
querytree redesign planned for 7.2. Thoughts anyone? regards, tom lane

Re: [GENERAL] getting inet out of char?

2000-06-06 Thread Tom Lane
- retentive about type checking. Sometimes that's good, sometimes not so good. regards, tom lane

Re: [GENERAL] index problem

2000-06-07 Thread Tom Lane
ver exceed NAMEDATALEN-1. regards, tom lane

Re: [GENERAL] Dump

2000-06-07 Thread Tom Lane
he double quotes at parse time instead of run time :-(. Will fix for 7.1 ... in the meantime, don't name your sequences that way ... regards, tom lane

Re: [GENERAL] anoncvs access

2000-06-07 Thread Tom Lane
to be updated. Hey Vince, isn't that stuff supposed to be rebuilt from sources nightly? regards, tom lane

Re: [GENERAL] Dump

2000-06-07 Thread Tom Lane
.) Also, how many rows in the table? regards, tom lane

Re: [GENERAL] Dump

2000-06-07 Thread Tom Lane
connection Hmm, that looks like a backend coredump. Did you find a core file in the database directory? If so, can you get a backtrace from it? regards, tom lane

Re: [GENERAL] plpgsql question...

2000-06-07 Thread Tom Lane
of plpgsql; dunno what exactly. I'd recommend updating to 7.0.2 and then seeing if the problem persists. If it does we can dig deeper. regards, tom lane

Re: [GENERAL] make us of old database.

2000-06-07 Thread Tom Lane
. regards, tom lane

Re: [GENERAL] Column types via ODBC interface

2000-06-07 Thread Tom Lane
e the ODBC driver's SQL type = Postgres type mapping if there's a better definition than what we're using... regards, tom lane

Re: [GENERAL] Cannot INDEX an Access97 ODBC

2000-06-09 Thread Tom Lane
to quote the column name in order to refer to it. It would be useful to see the output of pg_dump -s -t tablename databasename for this table. regards, tom lane

Re: [GENERAL] Ah, yet another cause for not binding the right port....

2000-06-09 Thread Tom Lane
GSQL.5432 together with that error ought to be sufficient clue I would think... regards, tom lane

Re: [GENERAL] Problem with upper() in select statement

2000-06-12 Thread Tom Lane
John Cochran [EMAIL PROTECTED] writes: Why isn't the upper() function working in the first query? Odd. You aren't by some chance working in a non-ASCII locale where "upper('Boulevard')" yields something besides 'BOULEVARD', are you? regards, tom lane

Re: [GENERAL] Problem with upper() in select statement

2000-06-12 Thread Tom Lane
hy doesn't PostgreSQL have a SYSDUMMY table or something like it (the way Oracle or IBM's DB2 have). Don't need it, since we don't require a FROM clause. regression=# select upper('Boulevard'); upper --- BOULEVARD (1 row) regards, tom lane

Re: [GENERAL] does vacuum rebuild index?

2000-06-12 Thread Tom Lane
. regards, tom lane

Re: [GENERAL] rules on INSERT can't UPDATE new instance?

2000-06-13 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Is the INSERT rule re-ordering mentioned a TODO item? Darn if I know. I threw the thought out for discussion, but didn't see any comments. I'm not in a hurry to change it, unless there's consensus that we should. regards, tom

Re: [GENERAL] Backend died while dropping index

2000-06-17 Thread Tom Lane
sure to the hundreds of bugs we've swatted since 6.5. regards, tom lane

Re: [GENERAL] int8 and hash index

2000-06-18 Thread Tom Lane
ase you do it in, not others in the same installation ... but if you do it in template1 then subsequently-created databases will have the entry too. regards, tom lane

Re: [GENERAL] libpq error codes

2000-06-22 Thread Tom Lane
error message? On my system errno 32 is EPIPE, but surely read() should never return EPIPE. regards, tom lane

Re: [GENERAL] Conversion from MS Access to Postgresql

2000-06-27 Thread Tom Lane
k with 7.0. regards, tom lane

Re: [GENERAL] Why isn't that null

2000-06-27 Thread Tom Lane
Shouldn't that give a type error of some sort? You didn't say what type vkp is, but if it's a string type then comparing it against a numeric shouldn't work IMHO. regards, tom lane

Re: [GENERAL] puzzled by the docs

2000-06-27 Thread Tom Lane
, and the development snapshot appears someplace else, but I guess Vince hasn't got round to it yet ... regards, tom lane

Re: [GENERAL] trigger question

2000-06-27 Thread Tom Lane
rtainly do at the price of losing some error detection capability --- ie, if that really had been a typo as I first thought, the system wouldn't flag it for you. Not sure which way is better. Comments anyone? regards, tom lane

Re: [GENERAL] Lingering Backend Processes

2000-06-28 Thread Tom Lane
... check with netstat or lsof or something like that. regards, tom lane

Re: Re[2]: [GENERAL] Restricting queries by the presence of a WHERE clause

2000-06-28 Thread Tom Lane
clause (or whatever it's called in the parse tree) and select triggers be hacked into the database? No. If there were, what makes you think that it'd be easier to security-audit it than a standalone proxy? regards, tom lane

  1   2   3   4   5   6   7   8   9   10   >