Re: [HACKERS] Open Sourcing pgManage

2003-11-04 Thread Christopher Kings-Lynne
D'oh, just clued into the 'java' aspect ... Joshua, will this run as a JSP, remotely, through Jakarta-Tomcat? One of the limitations of pgAdmin, as far as I'm concerned, is the fact that you can run it remotely Then use phpPgAdmin... Chris ---(end of

[HACKERS] weird regression test issue CVS HEAD

2003-11-04 Thread Christopher Kings-Lynne
I keep getting this: pg_regress: initdb failed Examine ./log/initdb.log for the reason. rm regress.o gmake[2]: Leaving directory `/home/chriskl/pgsql/src/test/regress' gmake[1]: Leaving directory `/home/chriskl/pgsql/src/test' -bash-2.05b$ more src/test/regress/log/initdb.log Running in noclean

Re: [HACKERS] \xDD patch for 7.5devel

2003-11-05 Thread Christopher Kings-Lynne
This is my first patch for PostgreSQL against the 7.5devel cvs (please advise if this is the wrong place to post patches). This patch simply enables the \xDD (or \XDD) hexadecimal import in the copy command (im starting with the simple stuff first). I did notice that there may be a need to issue

Re: [HACKERS] Open Issues for 7.4

2003-11-05 Thread Christopher Kings-Lynne
* Fix uselessly executable files in the source tree. See my recent post. Any ideas on that? As far as I'm aware, the only way to fix this is to get into the cvsroot and chmod them by hand. Chris ---(end of broadcast)--- TIP 5: Have you

Re: [pgsql-www] [HACKERS] Changes to Contributor List

2003-11-05 Thread Christopher Kings-Lynne
I think we had agreed that formerly-listed contributors would not be deleted, but would be moved to a new section titled Contributors Emeritus or some such. Please make sure that Tom Lockhart and Vadim get listed that way, at least. I think the Emeritus word might be too hard for non-native

Re: [HACKERS] pg_stat

2003-11-06 Thread Christopher Kings-Lynne
Just wondering how often the stats collector resets it self. Is this a parameter i can change? At my knowledge each time that you do an analyze on your db your statistics are changed ( are not incremental I mean), anyway you can set to reset statistics at the start of postgres. I think you're

[HACKERS] CVS open for development?

2003-11-06 Thread Christopher Kings-Lynne
Hey - now that we have a branch, is Bruce going to start committed the pgpatches2 list? Chris ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL

Re: [HACKERS] Timestamps on schema objects

2003-11-07 Thread Christopher Kings-Lynne
People occasionally seem to ask for keeping time stamps on schema objects (tables, functions, etc.) about when they were created and last altered (in their structure, not the data in the tables). I think that this would be a relatively useful and painless feature. What do others think? It has

Re: [HACKERS] bugzilla (Was: What do you want me to do?)

2003-11-07 Thread Christopher Kings-Lynne
The doesn't quite make the best use of PG quote is one of the best examples of buck-passing I've seen in awhile. If Bugzilla had been designed with some thought to DB independence to start with, we'd not be having this discussion. You have to laugh at an app that actually uses MySQL's

Re: [HACKERS] bugzilla (Was: What do you want me to do?)

2003-11-09 Thread Christopher Kings-Lynne
Seriously, I have wondered if it might be a good idea to assemble a small hit team that would take some high profile open source projects and make sure they worked with Postgres. Bugzilla would be the most obvious candidate, but there are certainly others. I suspect that could be quite

Re: [HACKERS] Coding help

2003-11-09 Thread Christopher Kings-Lynne
The only idea I have is to call oidin() to do the conversion from string to oid. I see this in copy.c: loaded_oid = DatumGetObjectId(DirectFunctionCall1(oidin, CStringGetDatum(string))); if (loaded_oid ==

Re: [HACKERS] Coding help

2003-11-09 Thread Christopher Kings-Lynne
| COMMENT ON LARGE OBJECT NumericOnly IS comment_text n-objname = makeList1(makeAConst($5)); Forget the makeAConst step --- it's just wasted cycles. In the execution routine, you can use code comparable to define.c's defGetInt64() to convert the Value node into a numeric OID, ie, either do

Re: [HACKERS] Coding help

2003-11-09 Thread Christopher Kings-Lynne
I thought the whole problem here is that OIDs are unsigned ints, hence intVal() won't allow the highest OIDs? Exactly. That's why you need to handle T_Float too. See the int8 example, which has just the same problem. It occurs to me then that I could just then use FloatOnly in the grammar

Re: [HACKERS] PostgreSQL Backup problems with tsearch2

2003-11-10 Thread Christopher Kings-Lynne
Is the problem with backing up and restoring a database which has tsearch2 installed and enabled delt with in Version 7.4 of PostgreSQL? If it's the problem with restoring the tsearch2-related functions, then no, and I'm not sure whether it's fixable (in the sense that a tsearch2 enabled

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Christopher Kings-Lynne
Even if they weren't useful for anything else, I think there's value in the developers having to consider what is optional and what is not. This need for constant review probably reduces the chance of bloat, over time even in the full tarball. How about dropping the partial tarballs and using the

Re: [HACKERS] cvs head? initdb?

2003-11-13 Thread Christopher Kings-Lynne
Jan checked in the ARC changes last night, and he and Tom ran into some problems, leading to that being pulled back out, while he revisits the code. It's back in again, and appears to work now (at least the regression tests pass ... no idea about performance ...) I actually managed to hang my

[HACKERS] conversion dumping patch

2003-11-13 Thread Christopher Kings-Lynne
Hey Bruce, When you get around to it, can you commit the patch I submitted that dumps conversions in pg_dump. I need that in to complete my COMMENT ON patch. I think it's pretty safe to apply, and I'm not 100% sure I still have a local copy of the patch, so I can't let it drift too much :(

Re: [HACKERS] [CORE] 7.4RC2 regression failur and not running stats

2003-11-14 Thread Christopher Kings-Lynne
Check that you don't need to use the -p option at all. Also, make sure you remove any ^M (DOS CR) characters from the line endings. That always happens to me if I receive the emailon a windows machine and save the attachment, windows sometimes likes to rewrite all the line endings, causing

Re: [HACKERS] oh dear ...

2003-11-14 Thread Christopher Kings-Lynne
I propose the attached patch to fix the problem. It doesn't break any regression tests, and it appears to fix the cases noted in its comment. Opinions on whether to apply this to 7.4? I think it should be fixed, since it could cause applications to break. Shouldn't you also add a regression

Re: [HACKERS] oh dear ...

2003-11-15 Thread Christopher Kings-Lynne
I made up a more thorough regression test for date input formats, and found that there were still some cases that were rejected :-(. Attached is a more complete patch that handles all month-name cases, and explicitly can not change the behavior when there's not a textual month name.

[HACKERS] commenting on polymorphic aggregates possible?

2003-11-17 Thread Christopher Kings-Lynne
-- value-independent transition function CREATE AGGREGATE newcnt ( sfunc = int4inc, basetype = 'any', stype = int4, initcond = '0' ); COMMENT ON AGGREGATE newcnt (any) IS 'an any agg comment'; ERROR: syntax error at or near any at character 30 COMMENT ON AGGREGATE newcnt (any) IS NULL;

Re: [HACKERS] logical column position

2003-11-17 Thread Christopher Kings-Lynne
Right -- AFAICS, the only change in COPY compatibility would be if you COPY TO'd a table and then changed the logical column order in some fashion, you would no longer be able to restore the dump (unless you specified a column list for the COPY FROM -- which, btw, pg_dump does). I don't think it

Re: [HACKERS] Release cycle length

2003-11-17 Thread Christopher Kings-Lynne
The time from release 7.3 to release 7.4 was 355 days, an all-time high. We really need to shorten that. We already have a number of significant improvements in 7.5 now, and several good ones coming up in the next few weeks. We cannot let people wait 1 year for that. I suggest that we aim for a

Re: [HACKERS] Release cycle length

2003-11-17 Thread Christopher Kings-Lynne
Everyone on -hackers should have been aware of it, as its always discussed at the end of the previous release cycle ... and I don't think we've hit a release cycle yet that has actually stayed in the 4 month period :( Someone is always 'just sitting on something that is almost done' at the end

Re: [HACKERS] help!

2003-11-17 Thread Christopher Kings-Lynne
Wait for confirmation from at least one other developer perhaps, buy you can try this: 1. Set attisdropped to false for the attribute 2. Set the atttypid back to whatever the oid of the type of that column is/was (Compare to an undropped similar column) 3. Use ALTER TABLE/SET NOT NULL on

Re: [HACKERS] Release cycle length

2003-11-17 Thread Christopher Kings-Lynne
Right now, I believe we are looking at an April 1st beta, and a May 1st related ... those are, as always, *tentative* dates that will become more fine-tuned as those dates become nearer ... April 1st, or 4 mos from last release, tends to be what we aim for with all releases ... as everyone knows,

Re: [HACKERS] logical column position

2003-11-17 Thread Christopher Kings-Lynne
BTW, one main consideration is that all the postgres admin apps will now need to support ORDER BY attlognum for 7.5+. But that is only really important if they've also used the ALTER TABLE RESHUFFLE COLUMNS feature. So if they make one alteration for 7.5, they need to do another. That seems

Re: [HACKERS] Release cycle length

2003-11-17 Thread Christopher Kings-Lynne
That said, I'm not really sure how we can make better use of the beta period. One obvious improvement would be making the beta announcements more visible: the obscurity of the beta process on www.postgresql.org for 7.4 was pretty ridiculous. Does anyone else have a suggestion on what we can do to

Re: [HACKERS] Release cycle length

2003-11-17 Thread Christopher Kings-Lynne
eg. Someone who just knows how to use postgres could test my upcoming COMMENT ON patch. (It's best if I myself do not test it) Someone with more skill with a debugger can be asked to test unique hash indexes by playing with concurrency, etc. I forgot to mention that people who just have

Re: [HACKERS] [pgsql-advocacy] Not 7.5, but 8.0 ?

2003-11-17 Thread Christopher Kings-Lynne
Oh, and yeah, a win32 port. Yay, another OS port. Postgres runs on dozens of OSes already. What's so exciting about one more? Even if it is a pathologically hard OS to port to. Just because it was hard doesn't mean it's useful. I don't call porting Postgres to run well on something like 40% of the

Re: [HACKERS] logical column position

2003-11-18 Thread Christopher Kings-Lynne
Will adding the logical attribute number break all of the external tools? pg_dump, etc are all dependent on attnum now? Would it be possible to keep the meaning of attnum the same externally and add another column internally to represent the physical number? Interesting idea. It would require

Re: [pgsql-www] [HACKERS] Release cycle length

2003-11-18 Thread Christopher Kings-Lynne
HOWEVER, a release cycle of *less than 6 months* would kill the advocacy vols if we wanted the same level of publicity. I do support the idea of dev releases. For example, if there was a dev release of PG+ARC as soon as Jan is done with it, I have one client would would be willing to test it

Re: [HACKERS] Is there going to be a port to Solaris 9 x86 in the

2003-11-18 Thread Christopher Kings-Lynne
PostgreSQL most definitely works great on Solaris x86 ! At UC Berkeley, we have our undergraduate students hack on the internals of PostgreSQL in the upper-division Introduction to Database Systems class .. http://www-inst.eecs.berkeley.edu/~cs186/ Hi Sailesh, You know what would be kind of

Re: [HACKERS] Is there going to be a port to Solaris 9 x86 in the

2003-11-19 Thread Christopher Kings-Lynne
Marcel Kornacker did implement concurrency for GiST - I confirmed as much with Joe Hellerstein (his advisor). I know there's a paper he wrote with C.Mohan on it. I don't know which version his implementation was for. The 7.4 GiST docs have a link to Kornacker's thesis that details how to

Re: [HACKERS] logical column position

2003-11-19 Thread Christopher Kings-Lynne
Why should ALTER COLUMN change the column number, i.e. position? Because it creates a NEW column. It may be that programmers should not rely on this, but it happens, and in very large projects. If we can avoid unexpected side-affects like moving the columns position, then I think we should.

Re: [HACKERS] Release cycle length

2003-11-20 Thread Christopher Kings-Lynne
Yeah, I think the main issue in all this is that for real production sites, upgrading Postgres across major releases is *painful*. We have to find a solution to that before it makes sense to speed up the major-release cycle. Well, I think one of the simplest is to do a topological sort of objects

Re: [HACKERS] Anyone working on pg_dump dependency ordering?

2003-11-21 Thread Christopher Kings-Lynne
I'm thinking about attacking pg_dump's lack of knowledge about using dependencies to determine a safe dump order. But if there's someone out there actively working on the problem, I don't want to tread on your toes ... anyone? I've done a whole lot of _thinking_, but basically no _doing_, so go

Re: [HACKERS] Executable files in CVS

2003-11-23 Thread Christopher Kings-Lynne
The other things that are executable look like they legitimately are scripts. If we consider that group-writability is bad (which ISTM we ought to) then there are a *ton* of files with the wrong permissions. I'd recommend getting Marc to fix it instead of hacking about with a one-file-at-a-time

[HACKERS] ALTER SEQUENCE enchancement

2003-11-23 Thread Christopher Kings-Lynne
Hi, Is there demand for this syntax: ALTER SEQUENCE ON table(col) CYCLE 100; It would allow us to become sequence-name independent... Chris ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send

Re: [HACKERS] ALTER SEQUENCE enchancement

2003-11-23 Thread Christopher Kings-Lynne
Is there demand for this syntax: ALTER SEQUENCE ON table(col) CYCLE 100; It would allow us to become sequence-name independent... The above is an operation that would not help me a lot, but a way of performing currval() without knowing the sequence name would be good. It will help in cases

Re: [HACKERS] Build farm

2003-11-24 Thread Christopher Kings-Lynne
Would it be reasonable to promote users testing daily snapshots with popular applications? I'm guessing there's not many applications that have automated test frameworks, but any that do would theoretically provide another good test of PGSQL changes. May I quote Joel on Software here?

Re: [HACKERS] A rough roadmap for internationalization fixes

2003-11-25 Thread Christopher Kings-Lynne
About storing data in the database, I would expect it to work with any encoding, just like I would expect pg to be able to store images in any format. What's stopping us supporting the other Unicode encodings, eg. UCS-16 which could save Japansese storage space. Chris

Re: [HACKERS] pg_restore and create FK without verification check

2003-11-26 Thread Christopher Kings-Lynne
A common mistake, can't count how often I created this one... And not easy to find, because EXPLAIN won't explain triggers. I'm planning to create some kind of fk index wizard in pgAdmin3, which finds out about fks using columns that aren't covered by an appropriate index. Maybe this check

[HACKERS] 7.5 Plans

2003-11-26 Thread Christopher Kings-Lynne
Hi everyone, I'm just interested in what everyone's personal plans for 7.5 development are? Shridar, Gavin and myself are trying to get the tablespaces stuff off the ground. Hopefully we'll have a CVS set up for us to work in at some point (we didn't think getting a branch and commit privs

Re: [HACKERS] Encoding problem with 7.4

2003-11-27 Thread Christopher Kings-Lynne
After installing 7.4 I created database completely from scratch with cyrillic locale: su postgres export LC_CTYPE=ru_RU.KOI8-R export LC_COLLATE=ru_RU.KOI8-R /usr/local/pgsql/bin/initdb -D /db2/pgdata You need to go: /usr/local/pgsql/bin/initdb -D /db2/pgdata -E KOI8 To set the default encoding

Re: [HACKERS] Call for pg_dump testing

2003-12-07 Thread Christopher Kings-Lynne
Hey Tom, I have committed some fairly wide-ranging revisions to pg_dump to make it dump database objects in a safe order according to the dependency information available from pg_depend. While I know that I have fixed a lot of previously-broken cases, it's hardly unlikely that I've broken some

[HACKERS] Build error?

2003-12-07 Thread Christopher Kings-Lynne
I just made distclean and then reconfigured with --with-openssl and I get this in HEAD: gcc -O2 -fno-strict-aliasing -g -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../src/interfaces/libpq -I../../../src/include -DBINDIR=\/home/chriskl/local/bin\ -c -o common.o common.c -MMD In

Re: [HACKERS] Call for pg_dump testing

2003-12-07 Thread Christopher Kings-Lynne
There's not currently any code for that, though I imagine we could invent some at need. Please provide example cases. create view v1 as select 1; create view v2 as select 1 + (select * from v1); create or replace view v1 as select * from v2; It seems to me that the only way to solve that one is

Re: [HACKERS] Call for pg_dump testing

2003-12-07 Thread Christopher Kings-Lynne
and a dump that orders the two views arbitrarily. We can certainly add code to do something different, but are there any real-world cases where this is needed? The above example seems more than slightly made-up. The views aren't actually functional anyway (trying to use either would result in an

Re: [HACKERS] ERROR: Index pg_toast_8443892_index is not a btree

2003-12-08 Thread Christopher Kings-Lynne
I get the following error when vacuuming a db or inserting a big value in a column of a toastable datatype (GEOMETRY). ERROR: Index pg_toast_8443892_index is not a btree My last action has been killing a psql that was getting mad about receiving too much input and beeping as hell (readline

Re: [HACKERS] ERROR: Index pg_toast_8443892_index is not a btree

2003-12-09 Thread Christopher Kings-Lynne
I couldn't agree more. Look at this very instance. He now found the right reindex command and the corrupted file is gone. We don't have the slightest clue what happened to that file. Was it truncated? Did some other process scribble around in the shared memory? How do you tell now? The end user

Re: [HACKERS] Resurrecting pg_upgrade

2003-12-14 Thread Christopher Kings-Lynne
Per prior discussion, we will enforce some sort of limit on how often the representation of user tables/indexes can be changed. The idea will be to batch such changes so that you only have to do a dump/reload every N major releases instead of every one. In other words, pg_upgrade will work for

Re: [HACKERS] Resurrecting pg_upgrade

2003-12-14 Thread Christopher Kings-Lynne
No. The proposed pg_upgrade procedure doesn't try to reproduce OIDs of catalog entries (other than toast-table OIDs, which are never preassigned anyway), so there's no issue. Good point though --- thanks for thinking about it. What about cached OIDs in view and function definitions, etc...? Like

Re: [HACKERS] Resurrecting pg_upgrade

2003-12-14 Thread Christopher Kings-Lynne
No. Large object OIDs are preserved in the given proposal. (Note to self: I wonder whether the recently-added COMMENT ON LARGE OBJECT facility works at all over dump/reload...) How do you mean? pg_dump never writes out the COMMENT ON commands... Chris ---(end of

Re: [HACKERS] Resurrecting pg_upgrade

2003-12-14 Thread Christopher Kings-Lynne
How do you mean? pg_dump never writes out the COMMENT ON commands... Oh, okay, it doesn't work. Care to think about how to fix that? I think you're going to have to explain the exact problem to me - I don't quite get what you mean? Do you mean using pg_dump with the '-b' option? How does

Re: [HACKERS] Resurrecting pg_upgrade

2003-12-14 Thread Christopher Kings-Lynne
Yeah. Don't you think that should preserve comments on large objects, now that such comments are alleged to be a supported facility? How does pg_dump dump the blobs? It dumps them, reloads them (which causes them to be assigned new OIDs) and then runs around and tries to fix up references to

[HACKERS] Oddness 7.3 vs 7.4

2003-12-15 Thread Christopher Kings-Lynne
I notice this in 7.3.4: test=# create table test (a int4, b int4); CREATE TABLE test=# create index idx on test(a) where b is null; CREATE INDEX test=# \d test Table public.test Column | Type | Modifiers +-+--- a | integer | b | integer | Indexes: idx

[HACKERS] Full text search reference

2003-12-18 Thread Christopher Kings-Lynne
For those working on search features, here's a new collection of essays on full text indexing mentioned on slashdot: http://www.tbray.org/ongoing/When/200x/2003/07/30/OnSearchTOC Chris ---(end of broadcast)--- TIP 2: you can get off all lists at

Re: [HACKERS] [pgsql-advocacy] PostgreSQL speakers needed for OSCON 2004

2003-12-20 Thread Christopher Kings-Lynne
Alternately, maybe it's time to try to get the fundraising operation into gear. Greg? What's our status for setup? My goal is to have everything done by January 31st. Speaking of fund raising, SourceForge has just started a 'donations' system whereby people can donate money to projects.

[HACKERS] cascading column drop to index predicates

2003-12-21 Thread Christopher Kings-Lynne
Hey Tom, With regards to our previous conversation about dropping columns now properly dropping indexes that contain predicates that reference that column, I now find it a bit disconcerting that such indexes are automatically removed when the column is dropped, instead of requiring a

Re: [HACKERS] Permissions and PGSQL

2003-12-23 Thread Christopher Kings-Lynne
I use PgSql for a lot of our company's need and I lack some features. I would like to know if there is plans to implement: - User permissions based on columns? (Ex: User1 has Select on Column CompayName but User2 has update on column CompanyName while User3 has create new row on table). These do

Re: [HACKERS] select from table with unique values

2003-12-28 Thread Christopher Kings-Lynne
how to do select from same table to get only unique values from same column(s) ? SELECT DISTINCT a, b FROM tab; or even: SELECT DISTINCT ON (a) a, b FROM tab; Chris ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] sticky sequence

2003-12-30 Thread Christopher Kings-Lynne
I cannot get rid of a sequence: gis=# drop sequence geopol.geology_gid_seq; ERROR: cache lookup of relation 8511697 failed Yes, geology_gid_seq have been created as a consequence of a geology.gid attribute of type serial. And.. yes, I've removed the relation with a delete on

[HACKERS] Objects in schemas question

2003-12-30 Thread Christopher Kings-Lynne
Hi, quick questions related to phpPgAdmin development. 1. What objects can possibly appear in the pg_temp* schemas? Is it just tables, views and sequences? 2. As above, but the pg_toast schema. Tables only here? 3. Am I guaranteed that a temp schema is 'pg_temp_*' and a toast one is

Re: Postgres + Xapian (was Re: [HACKERS] fulltext searching via a

2004-01-02 Thread Christopher Kings-Lynne
I think one way of attacking the problem would be using the existing nbtree by allowing it to store the five btrees. First read the README in the nbtree dir, and then poke at the metapage's only structure. You will see that it has a BlockNumber to the root page of the index. Try modifying that

Re: [HACKERS] time format

2004-01-02 Thread Christopher Kings-Lynne
Create table with type TIMESTAMP(0) Chris ivan wrote: how can i change default time format because now i have for example 2004-01-01 16:51:46.995927 but i want only 2004-01-01 16:51:46, with out millisec. a tryed with Data-Style but there arent custom style :/ ---(end

Re: [HACKERS] Anything akin to an Evaluate Statement in Postgresql?

2004-01-04 Thread Christopher Kings-Lynne
Was wondering if there was anything akin to an evaluate statement in Postgresql for dynamic strings? By dint of tricky programming you can a function that can generate and execute arbitrary strings. I believe there's even an example of this in the docs. Chris ---(end

Re: [HACKERS] Remote Procedures

2004-01-04 Thread Christopher Kings-Lynne
Try the contrib/dblink module. Chris A E wrote: Hi, I was wondering is there or will there be support for remote procedures/functions in Postgresql? Not only server to server, but database to database? Such as calling a function in DB B from DB A or Server Gaia DB B from Server Zeus DB A?

[HACKERS] Composite GiST indexes?

2004-01-04 Thread Christopher Kings-Lynne
Is it possible to make a composite GiST index? I want to create an index on a txtidx and a timestamp column - is that at all possible? Chris ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Composite GiST indexes?

2004-01-05 Thread Christopher Kings-Lynne
Is it possible to make a composite GiST index? I want to create an index on a txtidx and a timestamp column - is that at all possible? OK, this is what I'm trying (7.3.4): create index blah on forums_posts using gist(ftiidx, datetime); ERROR: data type timestamp with time zone has no default

Re: [HACKERS] [COMMITTERS] pgsql-server/ oc/src/sgml/catalogs.sgml

2004-01-07 Thread Christopher Kings-Lynne
AFAICS, you're sending From: =?ISO-8859-1?Q?Dennis_Bj=F6rklund?= [EMAIL PROTECTED] which is an instance of the encoding scheme Bruno mentioned. I have never heard that it is only supposed to be used in Subject: ... certainly there are a ton of people besides you who use it in From:. So I

Re: [HACKERS] Reserved words and named function parameters

2004-01-13 Thread Christopher Kings-Lynne
Any opinions which to do, or alternate proposals? I'm leaning slightly to #2, since I doubt anyone is trying to use IN as a function name, but ... One addition. The information_schema.parameters view will need to be updated to reflect parameter names.

[HACKERS] Using storage MAIN

2004-01-15 Thread Christopher Kings-Lynne
Hi guys, Quick question about how column storage works. If you set a TEXT field to be storage MAIN, does this place a limit on the amount of data that can be stored in the row (eg. 8k?) Chris ---(end of broadcast)--- TIP 2: you can get off all

[HACKERS] Make SHOW command subqueriable?

2004-01-15 Thread Christopher Kings-Lynne
Is this a neat idea? SELECT * FROM (SHOW ALL); eg. SELECT * FROM tab WHERE character_length(f) (SHOW block_size); etc. Chris ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining

Re: [HACKERS] Make SHOW command subqueriable?

2004-01-15 Thread Christopher Kings-Lynne
So neat in fact that it has been implemented. SELECT * FROM pg_settings; Damn! I knew that as well! *sigh* I'm not thinking right from my current 'shocking postgres performance problems nightmare day' today :( Think massively concurrent table that almost everything on the site relates to

[HACKERS] Log rotation for pg_autovacuum

2004-01-15 Thread Christopher Kings-Lynne
Hi, What's the best way to do log rolling with pg_autovacuum? It doesn't seem to have any syslog options, etc. Using 'tee' maybe? Chris ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [HACKERS] User Defined Functions/AM's inherently slow?

2004-01-17 Thread Christopher Kings-Lynne
Theory B would be that there's some huge overhead in calling non-built-in functions on your platform. We do know that looking up a C function is significantly more expensive than looking up a builtin function, but there should only be half a dozen such calls involved in this test case; it's hard

Re: [HACKERS] [7.4] permissions problem with pl/pgsql function

2004-01-19 Thread Christopher Kings-Lynne
420_test= select dropgeometrycolumn('420_test','lroadline61','roads61_geom'); ERROR: permission denied for relation pg_attribute CONTEXT: PL/pgSQL function dropgeometrycolumn line 19 at execute statement the database was created as: CREATE DATABASE db WITH OWNER = owner and I'm connected to

[HACKERS] [Fwd: plpgsql and booleans?]

2004-01-19 Thread Christopher Kings-Lynne
Hi guys, When writing a PL/pgSQL trigger function how do you handle the case : EXECUTE ''UPDATE test_table SET test_col '' || quote_literal(NEW.test_col2) || '';''; where test_col and test_col2 are boolean fields? The case above gives : ERROR: function quote_literal(boolean) does not exist

Re: [HACKERS] [Fwd: plpgsql and booleans?]

2004-01-20 Thread Christopher Kings-Lynne
EXECUTE ''UPDATE test_table SET test_col '' || quote_literal(NEW.test_col2) || '';''; Seems it'd be easier without EXECUTE: UPDATE test_table SET test_col = NEW.test_col2; Actually, yes you're right - we don't need EXECUTE in our case. However, it still doesn't answer the question of how you

[HACKERS] SET WITHOUT OIDS and VACUUM badness?

2004-01-21 Thread Christopher Kings-Lynne
This is what we did: 0. BEGIN; 1. ALTER TABLE ... SET WITHOUT OIDS 2. A bunch of things are selected out of this table and inserted into another (using INSERT ... SELECT) 3. An index is created on a timestamp field on this table 4. Then there's an update on a related table, that selects

Re: [HACKERS] Permissions and PGSQL

2004-01-22 Thread Christopher Kings-Lynne
Well, I have about half a patch for column privileges lying around, but I've never had enough motivation to do the other, more complicated half... Is there a TODO and TODO.detail warrented here? I thought views took care of this. Comments? They're needed for SQL99 anyway I think. Chris

[HACKERS] Disaster!

2004-01-23 Thread Christopher Kings-Lynne
We ran out of disk space on our main server, and now I've freed up space, we cannot start postgres! Jan 23 12:18:50 canaveral postgres[563]: [2-1] LOG: checkpoint record is at 2/96500B94 Jan 23 12:18:50 canaveral postgres[563]: [3-1] LOG: redo record is at 2/964BD23C; undo record is at 0/0;

Re: [HACKERS] Disaster!

2004-01-23 Thread Christopher Kings-Lynne
time :( ) Thanks, Chris Christopher Kings-Lynne wrote: We ran out of disk space on our main server, and now I've freed up space, we cannot start postgres! Jan 23 12:18:50 canaveral postgres[563]: [2-1] LOG: checkpoint record is at 2/96500B94 Jan 23 12:18:50 canaveral postgres[563]: [3-1

Re: [HACKERS] Disaster!

2004-01-23 Thread Christopher Kings-Lynne
I'd suggest extending that file with 8K of zeroes (might need more than that, but probably not). How do I do that? Sorry - I'm not sure of the quickest way, and I'm reading man pages as we speak! Thanks Tom, Chris ---(end of broadcast)--- TIP 4:

Re: [HACKERS] Disaster!

2004-01-23 Thread Christopher Kings-Lynne
I'd suggest extending that file with 8K of zeroes (might need more than that, but probably not). OK, I've done dd if=/dev/zero of=zeros count=16 Then cat zero 000D Now I can start it up! Thanks! What should I do now? Chris ---(end of

Re: [HACKERS] Disaster!

2004-01-23 Thread Christopher Kings-Lynne
What should I do now? Go home and get some sleep ;-). If the WAL replay succeeded, you're up and running, nothing else to do. Cool, thanks heaps Tom. Are you interested in real backtraces, any of the old data directory, etc. to debug the problem? Obviously it ran out of disk space, but

Re: [HACKERS] What's planned for 7.5?

2004-01-24 Thread Christopher Kings-Lynne
-COMMENT ON [ CAST | CONVERSION | OPERATOR CLASS | LARGE OBJECT | LANGUAGE ] (Christopher) Hey Bruce, You probably should add 'Dump LOB comments in custom dump format' to the todo. That's the last part of that task above which I haven't done yet, and for various reasons probably won't have

Re: [HACKERS] Disaster!

2004-01-24 Thread Christopher Kings-Lynne
After more staring at the code, I have a theory. SlruPhysicalWritePage and SlruPhysicalReadPage are coded on the assumption that close() can never return any interesting failure. However, it now occurs to me that there are some filesystem implementations wherein ENOSPC could be returned at

Re: [HACKERS] Disaster!

2004-01-24 Thread Christopher Kings-Lynne
That request to look at your WAL files is still open ... I've sent you it privately - let me know how it goes. Chris ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Disaster!

2004-01-26 Thread Christopher Kings-Lynne
Awesome Tom :) I'm glad I happened to have all the data required on hand to fully analyze the problem. Let's hope this make this failure condition go away for all future postgresql users :) Chris On Mon, 26 Jan 2004, Tom Lane wrote: Okay ... Chris was kind enough to let me examine the WAL

Re: [HACKERS] Disaster!

2004-01-26 Thread Christopher Kings-Lynne
Just for the record, the Canaveral you are thinking about is derived from the spanish word Cañaveral, which is a place where cañas grow (canes or stems, according to my dictionary -- some sort of vegetal living form anyway). I suppose Cape Kennedy was filled with those plants and that's what the

Re: [HACKERS] Idea about better configuration options for sort memory

2004-02-01 Thread Christopher Kings-Lynne
Seems OK to me, in fact maybe preferred. But I wonder if we should emit a NOTICE when old names are used with SHOW and SET commands? A WARNING should be issued. Chris ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

[HACKERS] pg_stat_activity

2004-02-02 Thread Christopher Kings-Lynne
Hi guys, In what version of Postgres did the pg_stat_activity view appear? Chris ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[HACKERS] Recursive queries?

2004-02-03 Thread Christopher Kings-Lynne
Is there anyone working on recursive queries for 7.5? I know there is a patch that implements it on 7.4 (I can't seem to find the guy's webpage), but that uses Oracle syntax. Wasn't there some guy at RedHat doing it? Is RedHat working on PITR? Chris ---(end of

Re: [HACKERS] Recursive queries?

2004-02-03 Thread Christopher Kings-Lynne
Andrew Overholt did some work on SQL99 recursive queries, but went back to university without having gotten to the point where it actually worked. One of the many things on my to-do list is to pick up and finish Andrew's work on this. If someone has time to work on it, let me know and I'll try

Re: [HACKERS] Recursive queries?

2004-02-03 Thread Christopher Kings-Lynne
There is a website somewhere where a guy posts his patch he is maintaining that does it. I'll try to find it... Found it. Check it out: http://gppl.terminal.ru/index.eng.html Patch is current for 7.4, Oracle syntax. Chris ---(end of

Re: [HACKERS] PostGIS Integration

2004-02-04 Thread Christopher Kings-Lynne
I can't see any way to handle parameterized types without extending the grammar individually for each one --- otherwise it's too hard to tell them apart from function calls. That makes it a bit hard to do 'em as plug-ins :-(. The grammar hacks are certainly ugly though, and if someone could

Re: [HACKERS] PostGIS Integration

2004-02-04 Thread Christopher Kings-Lynne
Those two cases are not hard, because in those scenarios the parser knows it is expecting a type specification. The real problem is this syntax for typed literals: typename 'string' which occurs in ordinary expressions. So when you see name( you aren't real sure if you're seeing

Re: [HACKERS] It's past time to redo the smgr API

2004-02-05 Thread Christopher Kings-Lynne
* AFAICS the only downside of not having a Relation available in smgr.c and md.c is that error messages could only refer to the RelFileNode numbers and not to the relation name. I'm not sure this is bad, since in my experience what you want to know about such errors is the actual disk filename,

  1   2   3   4   5   6   7   8   9   10   >