Re: [HACKERS] Any conclusion on the Xeon context-switching issue?

2006-02-27 Thread Richard Huxton
Tom Lane wrote: Richard Huxton writes: Tom Lane wrote: What's he using? 7.4.12 (.12 as of last week). I've seen context-switching peak at 8 on a quad-Xeon that really shouldn't be straining. Try 8.1.3. Thanks. I'll see if we can run a parallel installation ove

Re: [HACKERS] Any conclusion on the Xeon context-switching issue?

2006-02-27 Thread Richard Huxton
Tom Lane wrote: Richard Huxton writes: Subject says it all really. I've got a new client who seems to be suffering from it, and I'm not sure if any conclusion was reached. What's he using? 8.1 seems to have alleviated the problem somewhat, and I've done more work in CVS

[HACKERS] Any conclusion on the Xeon context-switching issue?

2006-02-27 Thread Richard Huxton
Subject says it all really. I've got a new client who seems to be suffering from it, and I'm not sure if any conclusion was reached. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner w

Re: [HACKERS] Multiple logical databases

2006-02-03 Thread Richard Huxton
e the easiest place to add some sort of "listall"/"switch todb" functionality. It also means you're not *forced* to have only one version of PG, or have them all on the same machine. -- Richard Huxton Archonet Ltd ---(end of broadcast)---

Re: [HACKERS] Want to add to contrib.... xmldbx

2006-01-31 Thread Richard Huxton
to download and install packages/plugins for PostgreSQL via the installer?" Now you've got "No" and "Yes" as your answers, but that's got nowt to do with "contrib/". Of course, there's still the small issue of implementation... -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] New project launched : PostgreSQL GUI Installer for

2006-01-31 Thread Richard Huxton
;s no package but I can't imagine most Ubuntu users bother. Now something to let you install extra modules, tune your postgresql.conf and pg_hba.conf - that's useful. If it can explain as it goes along, all the better (like "bastille linux"?) -- Richard Hu

Re: [HACKERS] Surrogate keys (Was: enums)

2006-01-20 Thread Richard Huxton
address columns in the invoice header, but it could be by some fancy temporal versioning on client details. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate s

Re: [HACKERS] Immodest Proposal: pg_catalog.pg_ddl

2005-12-14 Thread Richard Huxton
hat we have sub-transactions, we could wrap the call to the trigger function so that errors didn't abort the user setup/login etc. There's been demand for this sort of thing fairly regularly - I'd probably use it myself. -- Richard Huxton Archonet Ltd --

Re: [HACKERS] lo function changed in PostgreSQL 8.1.1

2005-12-14 Thread Richard Huxton
don't think it's been removed. The README.lo I quoted in my last email was from 8.1 source. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] lo function changed in PostgreSQL 8.1.1

2005-12-13 Thread Richard Huxton
), the ODBC driver needed a unique type. They had created an 'lo' type, but not the solution to orphaning. You don't actually have to use the 'lo' type to use the trigger, but it may be convenient to use it to keep track of which columns in your database

Re: [HACKERS] Graphics in postgress using GTK

2005-12-02 Thread Richard Huxton
splay Can someone suggest a method to integrate this GTK code into postgres and solve this problem. Um - don't you want to be doing this in the client, not in the backend? -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 3: Have

Re: [pgsql-www] [HACKERS] Upcoming PG re-releases

2005-12-01 Thread Richard Huxton
Csaba Nagy wrote: Maybe "mausoleum" would be even better name :-D Come on people, it's clearly: elephants-graveyard.postgresl.org -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 1: if posting/reading through Usen

Re: [pgsql-www] [HACKERS] Upcoming PG re-releases

2005-12-01 Thread Richard Huxton
second choice. If it's practical to keep them, I'd like to suggest doing so. If it's not practical, could we have a where_to_find_old_versions.txt file and open a project on sourceforge to keep them? -- Richard Huxton Archonet Ltd ---(end of bro

Re: [HACKERS] Improving count(*)

2005-11-18 Thread Richard Huxton
erialised_view This should allow you to have where-clauses and apply to a range of cases. What I fear is that checking to see if the rule applies will cost too much on all those queries where it doesn't apply. -- Richard Huxton Archonet Ltd ---

Re: [HACKERS] question about count(b) where b is a custom type

2005-11-16 Thread Richard Huxton
luded. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] Underlying view columns?

2005-11-10 Thread Richard Huxton
l: http://pgfoundry.org/projects/newsysviews -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] Accessing libq functions from UDF (shared library)

2005-11-08 Thread Richard Huxton
TE OR REPLACE FUNCTION' , i get the following error: Should you not be using SPI to run queries if this is inside PostgreSQL? See chapter 39 "Server Programming Interface" for details. -- Richard Huxton Archonet Ltd ---(end of broadcast)-

Re: [HACKERS] Copy From CSV feature request?

2005-11-08 Thread Richard Huxton
There's a sign that you've got a bug. If Crystal can't read what it writes then I'm not sure you can expect anyone else to do so reliably. If I import it into Access 2003 it ships Line 1001 and Line 1002 into an import error table. Quite right too. It's one of the areas

Re: [HACKERS] changing create table

2005-10-20 Thread Richard Huxton
://www.postgresql.org/developer/roadmap In postres for some reason its not possible to choose a file structure while we are creating tables!!! It is possibel while making an index. What do you mean by "file structure"? -- Richard Huxton Archonet Ltd ---(end of

Re: [HACKERS] 'a' == 'a ' (Was: RE: [pgsql-advocacy] [GENERAL] Oracle buysInnobase)

2005-10-20 Thread Richard Huxton
s are the same, then any function on those two values should return the same result. Otherwise what does "equals" mean? At the very least length() is broken by your argument. Here it's CHAR that's broken IMHO - spawn of some punch-card spawned data processing rules of the

Re: [HACKERS] SIGSEGV in Postgres 8.0.3 (libpq4)

2005-10-19 Thread Richard Huxton
afety turned on. http://www.postgresql.org/docs/8.0/static/libpq-threading.html -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 6: explain analyze is your friend

Resultset duplicates (was Re: [HACKERS] prefix btree implementation)

2005-10-05 Thread Richard Huxton
ating duplicate values in result-sets? I'd guess that many/most large result-sets are sorted which should make it possible to get away with a "same as last row" marker when the whole set is returned to a client. Of course, this is where someone turns around and tells me we do this alread

Re: [HACKERS] [PERFORM] Query in SQL statement

2005-10-05 Thread Richard Huxton
me), KEY Date (Date) The word "KEY" isn't valid here either - are you trying to define an index? If so, see the "CREATE INDEX" section of the SQL reference. http://www.postgresql.org/docs/8.0/static/sql-commands.html If you reply to this message

Re: [HACKERS] Solving the OID-collision problem

2005-08-10 Thread Richard Huxton
Simon Riggs wrote: On Tue, 2005-08-09 at 16:01 +0100, Richard Huxton wrote: Tom Lane wrote: What if there aren't any "untouched chunks"? With only 64K-chunk granularity, I think you'd hit that condition a lot more than you are hoping. Also, this seems to assume uniquene

Re: [HACKERS] Solving the OID-collision problem

2005-08-09 Thread Richard Huxton
as planned: CREATE FUNCTION f1()... -- oid=1234 CREATE FUNCTION f2()... -- oid=1235, calls f1() or oid=1234 DROP FUNCTION f1() CREATE FUNCTION f3()... -- re-uses oid=1234 -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] A Guide to Constraint Exclusion (Partitioning)

2005-07-13 Thread Richard Huxton
Sounds very useful - even for my small systems. Does it/would it work on an ordinary table (for those cases currently using UNION ALL)? -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 5: don't forget to increase your free

Re: [HACKERS] Strange logic for partial index proving

2005-06-23 Thread Richard Huxton
Tom Lane wrote: Richard Huxton writes: laser wrote: Aggregate (cost=19638.60..19638.60 rows=1 width=0) (actual time=1567.317..1567.318 rows=1 loops=1) -> Seq Scan on partial_idx_t (cost=1.00..18327.88 rows=524288 width=0) (actual time=0.046..906.747 rows=524288 loop

Re: [HACKERS] Strange logic for partial index proving

2005-06-23 Thread Richard Huxton
find a row, go to the table and check that row is visible. With the seq-scan it just works through the table. > but the cost field of the explain result that used partial index is really > lower. but the runtime been much more high (I'm with default planner > setting). I'd say you

[HACKERS] Strange transaction-id behaviour? (was Re: [GENERAL] Two updates problem)

2005-06-09 Thread Richard Huxton
RETURN 2; END; ' LANGUAGE plpgsql; -- UPDATE foo SET b = b || 'Y' WHERE a <= (SELECT foo_func()); UPDATE foo SET b = b || 'Y' WHERE a <= (SELECT foo_func()); SELECT * FROM foo; SELECT * FROM bar; ROLLBACK; -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] thw rewriter and default values, again

2005-06-06 Thread Richard Huxton
any way to have something like ...SET DEFAULT pg_same_as('public','foo','col1'). Hmm - you'd need pg_same_as_int/text/etc. depending on the return-type - still not ideal. -- Richard Huxton Archonet Ltd ---(end of broadcast)-

Re: [HACKERS] subquery returning array

2005-05-23 Thread Richard Huxton
ith a bit of tuning and see if that will work for you. If you really want to use arrays, perhaps see if the contrib/intarray module can help you. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 3: if posting/reading through Usen

Re: [HACKERS] Views update ?

2005-05-18 Thread Richard Huxton
arly testing. It's a feature that will be appreciated by many users. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [HACKERS] [PATCHES] Continue transactions after errors in psql

2005-04-26 Thread Richard Huxton
7;t see why non-interactive mode does need such a switch because there is no way to check if there was an error. So just put two queries there and hope one will work? DROP TABLE foo; CREATE TABLE foo... -- Richard Huxton Archonet Ltd ---(end of broadcast)

Re: [HACKERS] Help - Urgent

2005-04-15 Thread Richard Huxton
: cannot start postmaster Examine the log output. You have two versions of PostgreSQL installed (possibly one from RPM one from source). You presumably have two data directories and it is picking up the wrong one. Check $PGDATA etc. -- Richard Huxton Archonet Ltd ---(end

Re: [HACKERS] Name change proposal

2005-04-01 Thread Richard Huxton
Thomas Hallgren wrote: Richard Huxton wrote: Michael Fuhr wrote: I'd like to propose that we abandon the name "PostgreSQL" and rename the project "Postgre", to be pronounced either "post-greh" or "post-gree". This change would have a twofold purpos

Re: [HACKERS] Name change proposal

2005-04-01 Thread Richard Huxton
lect my next proposal, that we abandon SQL as the query language and replace it with Tutorial D. You forgot to suggest switching to GPL and rewriting in Java :-) -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] help with corrupted database

2005-03-23 Thread Richard Huxton
strk wrote: On Wed, Mar 23, 2005 at 01:48:11PM +, Richard Huxton wrote: strk wrote: Hello. A memory fault in a trigger left my database in a corrupted state: - I can't create temporary tables anymore (restart/vacuum full don't help) ERROR: cache lookup

Re: [HACKERS] help with corrupted database

2005-03-23 Thread Richard Huxton
be holding onto a reference to (at a guess) your temporary table. Can you identify what? -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Erratic error message "ERROR: column "id_compte" does

2005-03-16 Thread Richard Huxton
a WHERE (a1,a2) IN (SELECT a1,b3 FROM b ...) If that's legal, then so is your query. On Wed, Mar 16, 2005 at 02:24:48PM +, Richard Huxton wrote: David Pradier wrote: Actually, the column "id_compte" is the primary key of the table "compte". The column "id_compte&q

Re: [HACKERS] Erratic error message "ERROR: column "id_compte" does

2005-03-16 Thread Richard Huxton
more ? I think it's intended for use in the WHERE clause: SELECT a.* FROM a WHERE a1 IN (SELECT b3 FROM b WHERE b2=a2) -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Erratic error message "ERROR: column "id_compte" does

2005-03-16 Thread Richard Huxton
ry - where you seem to have an id_compte. -- Richard Huxton Archonet Ltd ---(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

Re: [HACKERS] fool-toleranced optimizer

2005-03-11 Thread Richard Huxton
not sure how practical/efficient it is to detect a resultset growing beyond that size. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] serial as FK ?

2005-02-28 Thread Richard Huxton
g with it when those notes were written (and I need to update them, clearly). Back then SERIAL implied UNIQUE too, but that was changed (in 7.3 I believe). -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 9: the planner will ignor

Re: [HACKERS] win32 performance - fsync question

2005-02-17 Thread Richard Huxton
ally being written to disk. That's what fsync does for you. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] Design notes for BufMgrLock rewrite

2005-02-17 Thread Richard Huxton
s with count zero are taken by the sweep for recycling. Would there be any value in incrementing by 2 for index accesses and 1 for seq-scans/vacuums? Actually, it should probably be a ratio based on random_page_cost shouldn't it? -- Richard Huxton Archonet Ltd --

Re: [HACKERS] Strange RETURN NEXT behaviour in Postgres 8.0

2005-02-16 Thread Richard Huxton
? I seem to remember some subtle problems with dropped columns and plpgsql functions - could be one of those still left. It'd look like tablesize was the problem because of course no-one's got time to test with 500 million test rows. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] Help me recovering data

2005-02-16 Thread Richard Huxton
oo? Pro: Teaches the lesson straight away. Con: Irritating Con: Might not be enough time for automated installers -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [HACKERS] Dealing with network-dead clients

2005-02-14 Thread Richard Huxton
and transaction timeouts have been suggested before, but there seems to be some resistance to them. Have you come across the pgpool connection-pooling project? http://pgpool.projects.postgresql.org/ Might be easier to put a timeout+disconnect in there. -- Richard Huxton Archonet Ltd -

Re: [HACKERS] Allow GRANT/REVOKE permissions to be applied to all

2005-02-01 Thread Richard Huxton
at you see posted above is the full extent of the idea. If there's a feeling it'd be useful I could pull my finger out and have a working prototype ready in Perl fairly quickly. It'd take me a while to get something decent in C though. -- Richard Huxton Archonet Ltd

Re: [HACKERS] Allow GRANT/REVOKE permissions to be applied to all

2005-02-01 Thread Richard Huxton
istinction if it was available. I don't know about other users. Do we perhaps want a pg_find tool instead, rather than getting too clever inside the backend? pg_find --type=table --schema=foo --name='system_*' --execute='GRANT ALL ON % TO myuser'

Re: [HACKERS] Permissions on aggregate component functions

2005-01-28 Thread Richard Huxton
ld be required. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-20 Thread Richard Huxton
Mark Cave-Ayland wrote: -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: 20 January 2005 12:45 To: D'Arcy J.M. Cain Cc: Mark Cave-Ayland; [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Much Ado About COUNT(*) D

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-20 Thread Richard Huxton
for you anyway. Well, it looks like ROW_COUNT isn't set in a statement-level trigger function (GET DIAGNOSTICS myvar=ROW_COUNT). Which is a shame, otherwise it would be easy to handle. It should be possible to expose this information though, since it gets reported at the command conclu

Re: [HACKERS] ARC patent

2005-01-17 Thread Richard Huxton
t;best of my knowledge...covered by no patents/claims/...". It's like having a bowl of sweets labelled "help yourself" and putting the price sticker inside the wrapper. -- Richard Huxton Archonet Ltd ---(end of broadcast)--

[HACKERS] Happy Christmas and thanks...

2004-12-23 Thread Richard Huxton
for all the hard work on 8.0, not to mention the new-look website. It's all shaping up to be a good new year. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Thoughts about updateable views

2004-12-22 Thread Richard Huxton
Tom Lane wrote: Richard Huxton writes: Tom Lane wrote: No; you'd also have to have some guarantee that a given underlying table row gives rise to at most one join row. If the same table row gives rise to multiple join rows, then a request specifying an UPDATE of just one of those join rows

Re: [HACKERS] Thoughts about updateable views

2004-12-22 Thread Richard Huxton
Tom Lane wrote: Richard Huxton writes: Yann Michel wrote: I think you mean UNION ALL, i.e. the set addition, don't you? Not if you can identify the underlying table(s) and key(s). If the UNION hides that information, then you are correct. If a unique key of the underlying table is includ

Re: [HACKERS] Thoughts about updateable views

2004-12-22 Thread Richard Huxton
Tom Lane wrote: Richard Huxton writes: There are two things (AFAICT) you need to be able to do to update (NOTE - not insert) a view. 1. Identify the underlying table(s) for the updated column(s) 2. Identify (primary) key values for the table(s) being updated. So - I could have a join listing

Re: [HACKERS] Thoughts about updateable views

2004-12-22 Thread Richard Huxton
Yann Michel wrote: Hi, On Wed, Dec 22, 2004 at 09:41:40AM +, Richard Huxton wrote: UNION etc doesn't necessarily mean you can't update, so long as the underlying table/key can be identified. I think you mean UNION ALL, i.e. the set addition, don't you? Otherwise UNION (wotho

Re: [HACKERS] Thoughts about updateable views

2004-12-22 Thread Richard Huxton
certain special cases). UNION etc doesn't necessarily mean you can't update, so long as the underlying table/key can be identified. For INSERTing to a view, the same rules apply, but obviously you need to be able to identify table/keys for all columns in the view. This clearly rules

Re: [HACKERS] RC2 and open issues

2004-12-21 Thread Richard Huxton
again :-) Any blocks written to would move up the cache, effectively moving the bookmark lower. Enough activity would cause the bookmark to drop off the end. If that isn't the case though, we know we can safely skip any blocks older than the bookmark. -- Richard Huxto

Re: [HACKERS] [Testperf-general] BufferSync and bgwriter

2004-12-16 Thread Richard Huxton
;s impractical / will never work, then don't be afraid to step up and let me know. If it helps, you could always think of me as an idiot savant who failed his savant exams :-) -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Error handling in plperl and pltcl

2004-12-01 Thread Richard Huxton
Thomas Hallgren wrote: Richard Huxton wrote: But is the problem not that forgetting to use SAVEPOINT can get us in trouble with clearing up after an exception? I fail to see how that's different from forgetting to use pgtry instead of try. It feels more distinct to me. I'll grant you

Re: [HACKERS] Error handling in plperl and pltcl

2004-12-01 Thread Richard Huxton
Thomas Hallgren wrote: Richard Huxton wrote: Can I make some counter-proposals? 1. Wrap each function body/call (same thing here afaict) in a sub-transaction. An exception can be caught within that function, and all the spi in that function is then rolled back. This is rubbish, but at least

Re: [HACKERS] createdb failed

2004-12-01 Thread Richard Huxton
d choice. Things to check: 1. You are starting PG as the right user 2. Permissions are correct 3. The directory exists 4. Have you done anything with tablespaces? -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Error handling in plperl and pltcl

2004-12-01 Thread Richard Huxton
es standard try/catch. I don't use TCL, but from the little I know this should be straightforward. 3. We can do something similar with a pgeval() in plperl. Don't know enough to say about Python. Basically, if exception handling doesn't work the way it should intuitively work (IM

Re: [HACKERS] Error handling in plperl and pltcl

2004-11-30 Thread Richard Huxton
originally either. Why a subtransaction per command rather than one per function? If I've got this right, this is so the PL can tidy up behind itself and report/log an appropriate error? -- Richard Huxton Archonet Ltd ---(end of broadcast)-

[HACKERS] Possible TODO item? VACUUM on empty table

2004-11-26 Thread Richard Huxton
e's a work-around (unless you're running pg_autovacuum I'd guess) 2. We perhaps want a more general table description (this is a bulk-loading table, this is a log table, this is a mostly static lookup table) -- Richard Huxton Archonet Ltd ---(end of broadcast

Re: [HACKERS] Getting Unicode characters greater than or equal to

2004-11-26 Thread Richard Huxton
ing UTF-8 but some other character set. Certainly that is what the error message implies. Note PG handles UTF-8 but not UTF-16 or other encodings. HTH -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] Help!

2004-11-25 Thread Richard Huxton
refused Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? This isn't really the right list - I'll repost onto the General list for you now. Please join me there, and don't reply to this message. -- Rich

Re: [HACKERS] Fwd: SELECT MAX with char => BUG?

2004-11-20 Thread Richard Huxton
Crazy. And posting to the wrong list - try the general/sql lists for this sort of thing. teste=# CREATE TABLE test ( id char(15), name char(80) ); CREATE You've defined "id" as char - so it's sorting alphabetically, not numerically, so < 2 Just defined "id&q

Re: [HACKERS] Increasing the length of

2004-11-10 Thread Richard Huxton
le, if you set it to 250 then all SQL statements that run 250ms or longer will be logged. Enabling this option can be useful in tracking down unoptimized queries in your applications. Only superusers can increase this or set it to minus-one if this option is set by the administrator. -- Rich

Re: [HACKERS] [GENERAL] Networking feature for postgresql...

2004-10-14 Thread Richard Huxton
you'd need to fork the backend itself. On Thu, 2004-10-14 at 11:15, Richard Huxton wrote: Katsaros Kwn/nos wrote: Hi, I'm trying to add a -project specific- networking feature to my postgres build (or database as function). What I want to do is to send a Query instance (as a String-retr

Re: [HACKERS] [GENERAL] Networking feature for postgresql...

2004-10-14 Thread Richard Huxton
r SPI calls are made. Have you looked at the dblink code? -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: RE : [HACKERS] Record unassigned yet

2004-10-01 Thread Richard Huxton
Tmp; END LOOP; RETURN true; END ' LANGUAGE 'plpgsql'; SELECT emp_test_fn(); === END test === PS - please reply to the -general list not -hackers. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] [PERFORM] [ADMIN] slower every day

2004-09-01 Thread Richard Huxton
G u i d o B a r o s i o wrote: Conclusion: If you comment a line on the conf file, and reload it, will remain in the last state. (either wast true or false, while I expected a default) Yes, that's correct. No, you're not the only one to have been caught out by this. -- Rich

Re: [HACKERS] Resurrecting pg_upgrade

2004-09-01 Thread Richard Huxton
Serguei A. Mokhov wrote: Hello, Just poking around to see if anyone is working on resurrecting the concept of pg_upgrade after all these years? You probably want to join the (very recent) thread subject = "version upgrade" started by Andrew Rawnsley. -- Richard Huxton Ar

Re: [HACKERS] Win32 release warning

2004-08-26 Thread Richard Huxton
't have an extended track-record on this platform". -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] [COMMITTERS] pgsql-server: Rearrange pg_subtrans handling

2004-08-24 Thread Richard Huxton
stored next to the count so that in the event of backend crashes the lock will eventually be released. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] select function & search_path problem/bug?

2004-08-20 Thread Richard Huxton
ve the problem here is that exists is a reserved word (as in SELECT ... FROM ... WHERE EXISTS ...) I think you should be ok if you quote your function name SELECT "exists"(...) Personally, I'd change it's name. -- Richard Huxton Archonet Ltd ---(

Re: [HACKERS] postgres uptime

2004-08-20 Thread Richard Huxton
d, couldn't you just hack the startup script(s) to insert a timestamp in a suitable table? Or am I missing something here (as usual)? -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Point in Time Recovery

2004-07-06 Thread Richard Huxton
ed (or on pitr_id if they record it). IMHO time is seldom relevant, event boundaries are. If you want to add special syntax for this, fine. If not, an INSERT statement is a convenient way to do this anyway. -- Richard Huxton Archonet Ltd ---(end of broadcast)

Re: [HACKERS] Postgresql on SAN

2004-07-06 Thread Richard Huxton
rd server boxes. There is a company offering specialised high-bandwidth hardware that is supposed to offer PG clustering, but I'm afraid I know no more about it. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] [GENERAL] creating a complex aggregate function

2004-07-05 Thread Richard Huxton
plpgsql syntax. text * concat(,){} // NOT IMPLEMENTED (HOW TO DO IT ??) The function you want is textcat(text,text). I believe all of the operators (|| + - etc) have equivalent functions. They're not listed in the user documentation, but "\df text*" will show you

Re: [HACKERS] PREPARE and transactions

2004-06-24 Thread Richard Huxton
make my report code handle prepare directly, then I'd know if I'd defined it or not. As it happens, that's not the way things stand though. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Weird NOT IN condition in SELECT (PostgreSQL 7.4.3

2004-06-23 Thread Richard Huxton
pia integer NOT NULL references copie(id), Are you sure you don't have any null values in prestiti.id_copia? -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe

[HACKERS] Putting OIDs etc back into pg_dump?

2004-06-23 Thread Richard Huxton
on 4. Not stored at all, it's pointless. 5. Not stored at all, PITR means this is academic now. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Accelerating aggregates

2004-06-11 Thread Richard Huxton
Isn't this going to have visibility issues wrt other backends? How do I know what transactions have updated the global and what haven't and which I should currently be seeing? I'm not sure that there is a solution simpler than the "insert +1/-1 into summary table" that g

Re: [HACKERS] Call for 7.5 feature completion

2004-05-19 Thread Richard Huxton
cry if (e.g.) nested transactions didn't work with system tables. Is that a plausible situation, or madness from a developer-resources point of view? -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 9: the planner will ignore you

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Richard Huxton
a production system on day 1 anyway. Perhaps this is the best way to look at it - when the .rpm's/.deb's are put together what does the community want in them? -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 3: if p

Re: [HACKERS] [PATCHES] Current-stream read for psql's \copy

2004-05-18 Thread Richard Huxton
n"; Where commands.sql contains the \copy. I'm not saying that was the original intention, but someone pointed out you could do things that way, and I can see it might (rarely) be useful. -- Richard Huxton Archonet Ltd ---(end of broadcast)--

Re: [HACKERS] ALTER TABLE TODO items

2004-05-07 Thread Richard Huxton
ooking, you can't necessarily. What if I'm building a query with EXECUTE or for that matter, what if I've written it in C? -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 5: Have you checked our extensi

Re: [HACKERS] ALTER TABLE TODO items

2004-05-06 Thread Richard Huxton
Bruce Momjian wrote: Tom Lane wrote: Richard Huxton <[EMAIL PROTECTED]> writes: Does that mean I'll want to disable triggers while I do this? Hrm. Right now the code does not fire triggers at all, but that seems wrong. However, I doubt that very many triggers could cope with updat

Re: [HACKERS] ALTER TABLE TODO items

2004-05-05 Thread Richard Huxton
UPDATE operation that folds in possible column type changes. Does that mean I'll want to disable triggers while I do this? Actually, if the structure's changing I presume I'll want to drop/recreate my triggers anyway (even if they get reparsed like view definitions). -- Richard

Re: [HACKERS] PostgreSQL pre-fork speedup

2004-05-05 Thread Richard Huxton
condary server. If that's not what you're after, then it must be fairly close. Check the mailing list archives - the download URL is on the "announce" list April 2004. I'm sure any real figures from your testing will be of much interest to

Re: [HACKERS] 7.5 features

2004-04-27 Thread Richard Huxton
he moment before he goes to feature-freeze. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

How to Welcome Windows Users (was Re: [HACKERS] 7.5 features)

2004-04-27 Thread Richard Huxton
the niggles in it will generate a flood of support messages as Windows users test it out. Basically, I'm asking what would need to be done technically for the ODBC driver, and is there anything a non-hacker can do to help? -- Richard Huxton Archonet Ltd ---(en

Re: [HACKERS] PITR Phase 2 - Design Planning

2004-04-27 Thread Richard Huxton
do that too. >From a usability point of view you might want to automatically insert rows on client connection/table creation etc. You could also delete any rows more than a week old when archiving WAL files. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] pg_hba.conf view from the database?

2004-04-06 Thread Richard Huxton
ch a view? I believe the thinking is that you want to check whether someone is allowed to connect to the database without having to connect to the database. If someone were to make bad connection attempts, they could easily run a denial of service against your DB (whether intentionally or just d

Re: [HACKERS] Per database users/admins,

2004-03-26 Thread Richard Huxton
> Richard Huxton <[EMAIL PROTECTED]> writes: >> Maybe it's me being slow, but are we not being over-complicated here? >> What's >> wrong with saying "database D1 looks up users in local table, D2 in the >> global table". If you are connected

<    1   2   3   4   >