Re: [HACKERS] [GENERAL] plPHP in core?

On Sat, 2005-04-02 at 21:48 +0200, Peter Eisentraut wrote: > Marc G. Fournier wrote: > > > d) Bringing PL/Java into core will force a consistent documentation > > > and, I imagine, a chapter of it's own in the main docs. I'm happy > > > to write most of it but English is not my native language. Wha

Re: [GENERAL] why does explain tell me I'm using a seq scan?

gnificant portion of the table where an index scan would be a loss based on current tuning parameters. -- Rod Taylor Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] OSDL DBT-2 for PostgreSQL

On Fri, 2003-08-01 at 20:32, Mark Wong wrote: > On Fri, Aug 01, 2003 at 05:05:18PM -0700, Josh Berkus wrote: > > Mark, > > > > > I've just got our DBT-2 workload (TPC-C derivate) working with > > > PostgreSQL using C stored functions and libpq. I'd love to get some > > > feedback. > > > > I'm co

Re: [GENERAL] last comma inside "CREATE TABLE ()" statements

and off by default. -- Rod Taylor There are always four sides to every story: your side, their side, the truth, and what really happened. - Original Message - From: "will trillich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 27, 2001 12:56 AM Subject:

Re: [GENERAL] index not used with subselect in where clause ?

Adding a LIMIT 1 in the subplan may also help -- as you only need a single match to make it true so additional finds are useless -- it'll stop sooner or will be more likely to use an index than a full table scan. -- Rod Taylor There are always four sides to every story: your side, their

Re: [GENERAL] update tables in remote db using trigger

to the database. A middle man shell script ensures that only a few specific requests can be made (one is actually creating a system user with very specific parameters). -- Rod Taylor There are always four sides to every story: your side, their side, the truth, and what really happened. - Orig

[GENERAL] Lost Trigger(s)?

name = 'user'; (gives 32 triggers). All are in pg_trigger. \d user -> Shows me Indicies, Constraints, lack of rules (all properly). Doesn't show any triggers.. But have come up with no obvious inconsistencies which would cause this. 7.1 Beta 5 is the version. -- Rod Taylor Ther

Re: [GENERAL] Re: serial properties

, and inter-server cache of several hundred. Rules apply as normal from there -- of course this breaks down when the master goes down... -- Rod Taylor There are always four sides to every story: your side, their side, the truth, and what really happened. - Original Message - From: "adb&

Re: [GENERAL] Re: Thought on OIDs

e the last PRIMARY KEY entry. Getting this key before sometimes isn't an option (triggers handle them sometimes). If I could have a pg_getlastprimarykey() function which returns a hash of name / value pairs of the new key without using the OID it would be ideal. -- Rod Taylor There are al

Re: [GENERAL] Convert to upper

rigger overhead does no matter how small the operation its doing. --Rod Taylor   There are always four sides to every story: your side, their side, the truth, and what really happened. - Original Message - From: Trewern, Ben To: [EMAIL PROTECTED] Sent: Friday, March 02, 2

Re: [GENERAL] 7.0 vs 7.1 running select count(*) FROM table WHERE (SELECT count(*) ) > 0;

Sorry... Exact same data. Did a pg_dumpall from one to the other first, then analyzed. -- Rod Taylor There are always four sides to every story: your side, their side, the truth, and what really happened. - Original Message - From: "Joseph Shraibman" <[EMAIL PROTECTED]&g

Re: [GENERAL] strategies for keeping an audit trail of UPDATEs

since). -- Rod Taylor There are always four sides to every story: your side, their side, the truth, and what really happened. - Original Message - From: "Louis-David Mitterrand" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 20, 2001 12:2

[GENERAL] Arbitrary table joins.

m table natural join table2; I could do this with a plpgsql function using EXECUTE but returning the full result set will be troublesome for a while. Till then, 2 queries... -- Rod Taylor There are always four sides to every story: your side, their side, the truth, and what really happened.

[GENERAL] SPI_finish()

about connections already having been established. Is there a known way to make SPI_Finish() crash that I could have run into? Function consists of a couple selects and a couple inserts. Of course, removing both SPI_Connect() doesn't allow the queries to be performed. -- Rod Taylor Ther

[GENERAL] Re: [HACKERS] Merry X-Mass

Little early aren't you? select now()::date gives me 2000-12-22 Hmm.. only one digit is odd. -- Rod Taylor There are always four sides to every story: your side, their side, the truth, and what really happened. - Original Message - From: "Partyka Robert" <[EMAIL PROTE