Re: [HACKERS] alpha4 bundled -- please verify

pass make check OK MacOS 10.4.11 PPC - gcc 4.0.1 -- Shane Ambler pgSQL (at) Sheeky (dot) Biz -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Odd historical fact about Bison

The real question is slow-to-upgrade OSes like HP-UX, AIX, OpenBSD and Solaris. What version of Bison are they shipping with? Mac OSX 10.4.11 - GNU Bison version 1.28 -- Shane Ambler pgSQL (at) Sheeky (dot) Biz -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] Do we really need a 7.4.22 release now?

mmon among 7.4 users. The fact that it took 5 years to find a problem to be fixed would indicate that it isn't a show stopping issue that they need fixed. Supporting old versions is a great and noble thing but there comes a time when it is a waste of resources because the effort goes unused. -

Re: [HACKERS] Some newbie questions

comes to replicating DDL changes - implemented as triggers run from INSERT/UPDATE not from CREATE/ALTER TABLE. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] Do we really want to migrate plproxy and citext into PG core distribution?

ads will help along those lines. We need to promote that postgresql isn't a one-size-fits-all solution, it is a solid product that can be customised to suite your needs. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-hackers mailing list (pg

Re: [HACKERS] A new take on the foot-gun meme

reckon it was Rodney Dangerfield that blew the golf ball down the fairway. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mail

Re: [HACKERS] Dept of ugly hacks: eliminating padding space in system indexes

is limited to system catalogs? or will this benefit char() index used on any table? The second would make it more worthwhile. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to y

Re: [HACKERS] Case-Insensitve Text Comparison

s or would it be possible to get ILIKE to use a properly configured index as well? -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.or

Re: [HACKERS] Initial max_connections for initdb on FreeBSD.

etting the max_connections configuration parameter. So I would try something like - setenv PGOPTIONS -N 2 -B 10 (or export depending on shell) initdb -D /path/to/data -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-hackers mailing list (pgs

Re: [HACKERS] Core team statement on replication in PostgreSQL

ectiveness of backups) I also think that starting with a read-only WAL slave will ease the transition between delayed slave updating and real-time slave updating. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-hackers mailing list (pgs

Re: [HACKERS] psql \? help display

s well (or maybe after the multi connection patch)? -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] we don't have a bugzilla

f an email. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] get rid of psql welcome message

settings per server? psql retrieves the welcome settings upon server connection. (as in psql requests it after connection - not returned with the initial connection request) This would be the default that is overridden by the local .psqlrc file. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Shee

Re: [HACKERS] get rid of psql welcome message

nning remotely is going to chew up anyone's bandwidth allocation. I do think that an rc file option (or even a ./configure option if you want to go that far) is fine for those in the know to adjust to their tastes - a better option than not show it once a .psql_history exists. -- Shan

Re: [HACKERS] Concurrent psql API

Tom Lane wrote: Alvaro Herrera <[EMAIL PROTECTED]> writes: Shane Ambler wrote: So I am thinking something like C-z that will allow you to switch out of a task that is waiting for results without having to stop it with C-c. I agree -- we would need to have a mode on which it is "

Re: [HACKERS] psql \du and \dg commands.

a chance of someone making a patch that would hide the two options (maybe replace them with \dr?) when connected to an 8.1 or higher server. But I wouldn't expect it any time soon. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-hackers ma

Re: [HACKERS] Concurrent psql API

Tom Lane wrote: Shane Ambler <[EMAIL PROTECTED]> writes: When switching to a conn we also need a non-destructive way out if it is busy. Uh, why? Why would you switch to a connection at all, if you didn't want its result? What if you switch to the wrong connection and it hasn

Re: [HACKERS] Concurrent psql API

rrent conns could be useful to have some status info with the list to indicate idle or running what command. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] Concurrent psql API

plicitly fork away from the async command. (Maybe c& shouldn't make the new connection foreground either?) \c& for a new foreground connection \cb& for a new background connection? -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-h

Re: [HACKERS] auto-vacuum conflicting with long running analyze

Alvaro Herrera wrote: Shane Ambler wrote: Given that the analyze will obviously take a long time, is this scenario likely to happen with 8.3.1? or has it been fixed since 8.1.x? In 8.3, autovacuum cancels itself if it sees it is conflicting with another query. Would this be the issue

[HACKERS] auto-vacuum conflicting with long running analyze

for sure. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] serial arrays?

rom 0-9 then a-z before rolling back to 0? Guess I got too much time on my hands... I'll go find something better to do now. ;-) > Sane? None. We should throw an error. +1 for the error -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via p

Re: [HACKERS] Skytools committed without hackers discussion/review

s" just doesn't make sense. +1 -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAI

Re: [HACKERS] Skytools committed without hackers discussion/review

y can discuss getting the change accepted into core or contrib for the next pg release. just my .02c -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 5: don't forget to increase your free

Re: [HACKERS] [SQL] Why does the sequence skip a number with generate_series?

Tom Lane wrote: Alvaro Herrera <[EMAIL PROTECTED]> writes: Shane Ambler wrote: CREATE TABLE jefftest ( id serial, num int ); INSERT INTO jefftest (num) values (generate_series(1,10)); INSERT INTO jefftest (num) values (generate_series(11,20)); INSERT INTO jefftest (num) values (generate_

Re: [HACKERS] [SQL] Why does the sequence skip a number with generate_series?

be the planner or the generate series function could use a temporary table to give the same results as select from generate_series() -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] Money type todos?

re with the total being rounded to a whole cent when payment is made. And our smallest coin is 5 cents so cash paying customers are also rounded to 5 cent increments. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)-

Re: [HACKERS] PostgreSQL - 'SKYLINE OF' clause added!

than one way, while others are limited in ways to coherently express what you want to achieve. If we consider this thoroughly and compile a suitable syntax that covers all bases it could be used as the basis of the standard definition or be close to what ends up in the standard. --

Re: [HACKERS] Auto creation of Partitions

d as needed, then the auto dropping of empty partitions would also not apply. Leaving us with only specific add partition / drop partition commands. And have the parent table pick up rows not matching any partition check criteria. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://S

Re: [HACKERS] Auto creation of Partitions

ITION partition_name CHECK(...) [USING TABLESPACE tblspcname]; Of course ALTER TABLE childtable SET TABLESPACE tblspcname; should not cause any probs. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 6: ex

Re: [HACKERS] PostgreSQL - 'SKYLINE OF' clause added!

the implementation offered worth considering? Has it been developed to meet the PostgreSQL developer guidelines? Is it reasonable to work on it to reach a level of quality/performance that we will be happy to include? Can we implement this feature better ourselves? Do we want to start this feature fro

Re: [HACKERS] Auto creation of Partitions

on year and day of year. Another syntax possibility - range(myserialcol of 50) where new child tables are created every 50 rows? Maybe I'm looking at auto-maintenance which is beyond any current planning? -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz -

Re: [HACKERS] ERROR: operator does not exist: integer !=- integer

ssume you are looking to achieve. The negation operator goes with the int being negated and is not part of the comparison operator != the space is needed there to separate the two. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz

Re: [HACKERS] PostgreSQL - 'SKYLINE OF' clause added!

-- http://students.iiit.ac.in/~nikita/ http://students.iiit.ac.in/~ranbeer/ -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] Erronous sort used in query plan

Tom Lane wrote: Shane Ambler <[EMAIL PROTECTED]> writes: I am putting together searches on the catalog info and came up with a select that was rather slow and I noticed that in the explain analyze there is a sort step on one of the left joins which I don't think belongs there.

[HACKERS] Erronous sort used in query plan

t join pg_catalog.pg_operator oltcm on oltcm.oid=o.oprltcmpop left join pg_catalog.pg_operator ogtcm on ogtcm.oid=o.oprgtcmpop left join pg_catalog.pg_proc pcode on pcode.oid=o.oprcode left join pg_catalog.pg_proc prest on prest.oid=o.oprrest left join pg_catalog.pg_proc pjoin on pjoin.oid=o.oprjoin

Re: [HACKERS] Strange pgsql crash on MacOSX

Shane Ambler wrote: Tom Lane wrote: Shane Ambler <[EMAIL PROTECTED]> writes: postgres=# \q psql(24931) malloc: *** error for object 0x180a800: incorrect checksum for freed object - object was probably modified after being freed, break at szone_error to debug psql(24931) malloc: ***

[HACKERS] Strange pgsql crash on MacOSX

07-0, 115.04 GB USB Device: Apple Pro Keyboard, Mitsumi Electric, Up to 1.5 Mb/sec, 500 mA USB Device: i350, Canon, Up to 12 Mb/sec, 500 mA FireWire Device: unknown_device, unknown_value, Up to 400 Mb/sec -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---

Re: [HACKERS] effective_cache_size vs units

r only megabyte? I would say bits would be clearly specified as such (bit instead of b) Let's skip any flame wars on this and concentrate on the humorous future storage sizes. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)

Re: [HACKERS] libpq.a in a universal binary

Dave Page wrote: Shane Ambler wrote: # make distclean # CFLAGS="-isysroot /Developer/SDKs/MacOSX10.4u.sdk -arch ppc -arch i386" LDFLAGS="-Wl,-syslibroot,/Developer/SDKs/MacOSX10.4u.sdk -arch ppc -arch i386" ./configure --with-openssl --prefix=/usr/local # make all Aft

Re: [HACKERS] Help me pack up postgresDB with my windows application.

suspectingly. I just want to reduce steps, config-operation and keep database password when our user install applications. http://pgfoundry.org/projects/pginstaller/ contains a link to the source used to build the windows binary installer - what you want will be in there. -- Shane Amb

Re: [DOCS] [HACKERS] Replication documentation addition

they will look further if they want that feature. something like "There are currently no open source solutions available for this option but there are some commercial offerings. More details of some available solutions can be found at postgresql.org/support/" -- Shane Ambl

Re: [HACKERS] Mirror problems for download

ticed any torrent files for postgreSQL releases - maybe we can look into setting this up to share the load, particularly around release times. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 4: Hav

Re: [HACKERS] 8.1.4 verified on Intel Mac OS 10.4.8

wouldn't say you are behind yet. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] Syntax bug? Group by?

GROUP columns is illegal if there is no GROUP BY clause I found one that actually returns the desired result - SQLite3. sqlite> select * from test; 15|20 15|10 sqlite> select ycis_id,min(tindex),avg(tindex) from test where ycis_id=15; 15|10|15 sqlite> -- Shane Ambler [EMAI

Re: [HACKERS] Syntax bug? Group by?

e group by to unify all returned results as being aggregates. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index sc

Re: [HACKERS] Syntax bug? Group by?

d the same min() and avg() values for each row. Removing the ycis_id after the select will return the aggregate values you want without the group by. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 4

Re: [HACKERS] Postgresql Caching

Harvell F wrote: Getting back to the original posting, as I remember it, the question was about seldom changed information. In that case, and assuming a repetitive query as above, a simple query results cache that is keyed on the passed SQL statement string and that simply returns the previ

Re: [HACKERS] Postgresql Caching

[EMAIL PROTECTED] wrote: As a thought experiment, I'm not seeing the benefit. I think if you could prove a benefit, then any proof you provided could be used to improve the already existing caching layers, and would apply equally to read-only or read-write pages. For example, why not be able to h

Re: [HACKERS] Postgresql Caching

[EMAIL PROTECTED] wrote: On Mon, Oct 16, 2006 at 03:08:39AM +0930, Shane Ambler wrote: You could setup a table in memory to contain known popular data, you could also use this to create a temporary table in memory to speed up multiple intermediate calculations without touching disks. I&#

Re: [HACKERS] Postgresql Caching

Merlin Moncure wrote: On 10/15/06, Anon Mous <[EMAIL PROTECTED]> wrote: Would it be possible to combine a special memcache implementation of memcache with a Postgresql interface wrapper? have you seen http://people.freebsd.org/~seanc/pgmemcache/ merlin Now you got me thinkin ;-P Just thr

Re: [HACKERS] Casting to money

Tom Lane wrote: "Dave Page" writes: select '$123.45'::money ERROR: invalid input syntax for type money: "$123.45" select '£123.00'::money ERROR: invalid input syntax for type money: "£123.00" So ... what locale are you trying this in? I get the following from 8.2beta1 - looks like it doesn't