Re: [HACKERS] Column storage positions

2007-02-21 Thread elein
can be handled in attnum and the new storage order can be the new column. --elein ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] New feature request: FlashBack Query

2007-02-17 Thread elein
recent time travel ideas see: http://www.varlena.com/GeneralBits/122.php Time travel is not cheap, though. --elein [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Variable length varlena headers redux

2007-02-14 Thread elein
On Tue, Feb 13, 2007 at 01:32:11PM -0500, Bruce Momjian wrote: Gregory Stark wrote: Alternatively, what does the trailing a in varlena signify? Would this be varlenb? attribute -- Actually varlena stands for variable length array. elein [EMAIL PROTECTED

Re: [HACKERS] Variable length varlena headers redux

2007-02-14 Thread elein
will. Be careful out there. elein [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through

[HACKERS] [GENERAL] 8.2.1 Compiling Error

2007-01-31 Thread elein
- Forwarded message from elein [EMAIL PROTECTED] - To: pgsql-general@postgresql.org Cc: elein [EMAIL PROTECTED] Subject: [GENERAL] 8.2.1 Compiling Error Mail-Followup-To: pgsql-general@postgresql.org From: elein [EMAIL PROTECTED] Debian Linux. Have always built from scratch

Re: [HACKERS] [GENERAL] 8.2.1 Compiling Error

2007-01-31 Thread elein
On Wed, Jan 31, 2007 at 03:41:31PM -0500, Tom Lane wrote: elein [EMAIL PROTECTED] writes: gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wendif-labels -fno-strict-aliasing -g -Wno-error -L../../../../src/port -Wl,-rpath,'/local/pgsql82/lib' preproc.o type.o ecpg.o

Re: [HACKERS] -f output file option for pg_dumpall

2007-01-22 Thread elein
of this to psql \ commands, without having to replicate the underlying logic. Don't we already do this with the .psqlrc file? --elein ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http

Re: [HACKERS] [GENERAL] Autovacuum Improvements

2007-01-13 Thread elein
feedback on autovacuum to users? Right now we don't even know what tables were vacuumed when and what was reaped. This might actually be another topic. ---elein [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] InitPostgres and flatfiles question

2007-01-06 Thread elein
statement in the line. Since it is the shell, I want quick results. Usually it is an INSERT/UPDATE followed by a SELECT. It would be very frustrating not to be able to send multiple commands with one -c in psql. --elein ---(end of broadcast)--- TIP 2

Re: [HACKERS] Status of Fix Domain Casting TODO

2007-01-05 Thread elein
is to convert between external and internal representation. You can fake out the input function by putting a check clause on the type definition. I agree there should be hooks allowing input/output functions to be written in pls. late to the thread, again, --elein ---(end

Re: [HACKERS] Domains and subtypes, a brief proposal

2006-09-08 Thread elein
On Thu, Sep 07, 2006 at 07:12:17PM -0700, Josh Berkus wrote: Elein, I may have missed some stuff here. Obviously.  For example how to divide and conquer the various aspects of the issues raised here. But this is a high, high level proposal at this time. I'm not quite clear on what

Re: [HACKERS] Domains and subtypes, a brief proposal

2006-09-08 Thread elein
On Fri, Sep 08, 2006 at 02:33:13PM -0400, Tom Lane wrote: elein [EMAIL PROTECTED] writes: Domains and subtypes. * Create new child type from values in parent type. * Maintain only checks for constraints * Create implicit casts from child to parent This seems a bit content

Re: [HACKERS] Domains and subtypes, a brief proposal

2006-09-08 Thread elein
On Fri, Sep 08, 2006 at 03:47:23PM -0400, Tom Lane wrote: elein [EMAIL PROTECTED] writes: a) if subtypes/domains can have constraints then the model should not be different for domains only but for all types. Constraint checking would only occur at check constraint points

Re: [HACKERS] Domains and subtypes, a brief proposal

2006-09-08 Thread elein
On Fri, Sep 08, 2006 at 05:20:18PM -0400, Tom Lane wrote: elein [EMAIL PROTECTED] writes: I think what you are saying is that the domain checking (proposed constraint existence checking) would need to be done in more places and I'm not sure I understand this. What I'm complaining about

[HACKERS] Domains and subtypes, a brief proposal

2006-09-07 Thread elein
. No special type checking for simple subtypes was necessary. I may have missed some stuff here. Obviously. For example how to divide and conquer the various aspects of the issues raised here. But this is a high, high level proposal at this time. Comments, volunteers are welcome. --elein

Re: [HACKERS] gBorg status?

2006-08-31 Thread elein
Also people trying to download slony have to do some hunting to find things. The source only tar is not available on pgfoundry. one of them, elein On Thu, Aug 31, 2006 at 10:33:36AM -0400, Chris Browne wrote: What's up there? It has been down all week. We're trying to get the Slony-I 1.2

Re: [HACKERS] User-defined typle similar to char(length) varchar(length)

2006-08-03 Thread elein
. The value would be a type itself and the datatype must do the right thing regarding it. This may not be practical for short-term, but would open up initialization parameters for user-defined typed. --elein regards, tom lane ---(end of broadcast

Re: [HACKERS] feature request: pg_dump --view

2006-07-18 Thread elein
this as a way to dump the CONTENTS of a view not the DEFINITION of a view. I thought someone sneaked in pg_dump of a query in there. --elein ---(end of broadcast)--- TIP 6: explain analyze is your friend ---(end of broadcast

Re: [HACKERS] Three weeks left until feature freeze

2006-07-12 Thread elein
include me on the discussion and I can try to provide information regarding the other implementation. --elein The Postgres hacker community is small. I am not sure there is an adequate pool of people who will maintain the momentum of each sub-project that we might choose to orphan. If we

Re: [HACKERS] Inheritance, CREATE TABLE LIKE, and partitioned tables

2006-06-26 Thread elein
. Has anyone looked at applying the ADD INHERITS patch yet? Would it be more or less likely to be accepted if it were a bigger patch that refactored all this stuff like I'm talking about? -- greg ---elein [EMAIL PROTECTED] ---(end of broadcast

Re: [HACKERS] [pgsql-advocacy] Toward A Positive Marketing Approach.

2006-05-18 Thread elein
more loudly than words. For the most part Josh Berkus has been leading the marketing effort. It would behoove you to discuss how you can help him in that effort. Carry on! Elein -- PostgreSQL Consulting, Support Training

Re: [HACKERS] bug? non working casts for domain

2006-05-08 Thread elein
I'll see what I can do about expanding my requirements/test cases. Casting was not in my original test cases. What else have I missed? Copy domain gripes to [EMAIL PROTECTED] --elein [EMAIL PROTECTED] On Sat, May 06, 2006 at 10:19:39PM -0400, Tom Lane wrote: Bruce Momjian pgman

Re: [HACKERS] Is a SERIAL column a black box, or not?

2006-05-03 Thread elein
On Wed, May 03, 2006 at 10:12:28AM -0500, Jim C. Nasby wrote: On Tue, May 02, 2006 at 07:45:13PM -0700, elein wrote: On Tue, May 02, 2006 at 12:00:42PM -0500, Jim C. Nasby wrote: On Mon, May 01, 2006 at 06:43:00PM -0700, elein wrote: On Mon, May 01, 2006 at 07:47:06PM -0400, Tom Lane

Re: [HACKERS] Is a SERIAL column a black box, or not?

2006-05-02 Thread elein
On Tue, May 02, 2006 at 12:00:42PM -0500, Jim C. Nasby wrote: On Mon, May 01, 2006 at 06:43:00PM -0700, elein wrote: On Mon, May 01, 2006 at 07:47:06PM -0400, Tom Lane wrote: Jim C. Nasby [EMAIL PROTECTED] writes: I think a big point that's being missed here is that SERIAL *is* trying

Re: [HACKERS] Is a SERIAL column a black box, or not?

2006-05-01 Thread elein
and the sequence when it is declared as a SERIAL. --elein ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings ---(end of broadcast)--- TIP 2: Don't 'kill -9

Re: [HACKERS] Is a SERIAL column a black box, or not?

2006-04-30 Thread elein
on that issue. --elein On Sat, Apr 29, 2006 at 05:54:19PM -0400, Tom Lane wrote: In some recent activity on the patches list about responding to bug #2073, http://archives.postgresql.org/pgsql-bugs/2005-11/msg00303.php we've been discussing various possible tweaks to the behavior of dropping

Re: [HACKERS] Domains as Subtypes

2006-03-27 Thread elein
On Mon, Mar 27, 2006 at 11:41:30AM -0500, Tom Lane wrote: elein [EMAIL PROTECTED] writes: But I like the idea of centralizing the check in the input/output functions. It seems clearer and cleaner. I remembered the problem with doing it that way: an input function can't enforce a domain

Re: [HACKERS] Domains as Subtypes

2006-03-25 Thread elein
of the input/output checks issues. But I like the idea of centralizing the check in the input/output functions. It seems clearer and cleaner. The procedural language checks are harder, but may be easier to implement if there were a centralized check domain functionality. --elein -- Jim C. Nasby

[HACKERS] Domains as Subtypes

2006-03-24 Thread elein
not covered by regression and my tests? 3) Should I add my test case to the regression tests? 4) Eventually this feature should be added to the docs. Should I wait until all of the pieces are in place or go ahead and document the feature as it stands? elein

Re: [HACKERS] Domains as Subtypes

2006-03-24 Thread elein
On Fri, Mar 24, 2006 at 03:47:13PM -0500, Tom Lane wrote: elein [EMAIL PROTECTED] writes: Attached is a patch to parse_oper.c which essentially does the following. The major change is in binary_oper_exact(). Instead of checking only one level of the basetype it checks all possible

Re: [HACKERS] Domains as Subtypes

2006-03-24 Thread elein
On Fri, Mar 24, 2006 at 08:33:51PM +0100, Peter Eisentraut wrote: elein wrote: Domains lay the groundwork for inherited basetypes or subtypes. Semantically, a domain and a subtype are completely different things. A domain restricts the possible values of a type but behaves exactly like

Re: [HACKERS] Domains as Subtypes

2006-03-24 Thread elein
On Fri, Mar 24, 2006 at 06:27:13PM -0500, Tom Lane wrote: elein [EMAIL PROTECTED] writes: Operators have the single distinction from functions in that when one argument has an unknown type, then an exact match is tried with the unknown arg type set to the known type. This code has

Re: [HACKERS] Proposal for SYNONYMS

2006-03-09 Thread elein
the use of synonyms alone. If/when updatable views are implemented, I wouldn't have a problem switching create synonym to actually create a view. Since updateable views are relatively easy to construct using rules I'm not sure an entire new syntax is necessary. --elein [EMAIL PROTECTED

Re: [HACKERS] Foreign keys for non-default datatypes

2006-03-03 Thread elein
On Thu, Mar 02, 2006 at 08:41:20PM -0500, Tom Lane wrote: elein [EMAIL PROTECTED] writes: ... What I'm saying is that the opclass needs to be an option to PRIMARY KEY and FOREIGN KEY-- PRIMARY KEY and UNIQUE, you mean. This was brought up before, but I remain less than excited about

Re: [HACKERS] Foreign keys for non-default datatypes

2006-03-02 Thread elein
implicitly in the code or explicitly in the grammar. But as I said I'm thinking about it. Perhaps there are other alternatives. --elein [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http

Re: [HACKERS] Domains and supporting functions

2006-02-20 Thread elein
On Mon, Feb 20, 2006 at 09:03:29AM +0100, Michael Paesold wrote: Elein wrote: http://www.varlena.com/GeneralBits/128.php Known Problems and Issues: * Creating the table with an email PRIMARY KEY did not use our comparison function. It was necessary to create a unique index which

Re: [HACKERS] Domains and supporting functions

2006-02-19 Thread elein
On Sun, Feb 19, 2006 at 01:26:31AM -0500, Tom Lane wrote: elein [EMAIL PROTECTED] writes: I've got a domain based on a text type. I've overridden the equal operator with lower(text) = lower(text). This won't work, you need to make a type instead. Actually I can do and have done

Re: [HACKERS] Domains and supporting functions

2006-02-19 Thread elein
On Sun, Feb 19, 2006 at 07:57:42PM +0100, Martijn van Oosterhout wrote: On Sun, Feb 19, 2006 at 10:34:02AM -0800, elein wrote: Actually I can do and have done this. It is being tested now. I did create an opclass. It creates a UNIQUE index just fine for the type using the lower

Re: [HACKERS] Domains and supporting functions

2006-02-19 Thread elein
On Sun, Feb 19, 2006 at 10:29:35PM +0100, Martijn van Oosterhout wrote: On Sun, Feb 19, 2006 at 12:59:35PM -0800, elein wrote: On Sun, Feb 19, 2006 at 07:57:42PM +0100, Martijn van Oosterhout wrote: ORDER BY x ASC is a synonym for ORDER BY x USING . That's the way it is currently. To use

Re: [HACKERS] Domains and supporting functions

2006-02-19 Thread elein
On Sun, Feb 19, 2006 at 11:34:21PM +0100, Martijn van Oosterhout wrote: On Sun, Feb 19, 2006 at 01:36:41PM -0800, elein wrote: On Sun, Feb 19, 2006 at 10:29:35PM +0100, Martijn van Oosterhout wrote: On Sun, Feb 19, 2006 at 12:59:35PM -0800, elein wrote: On Sun, Feb 19, 2006 at 07:57:42PM

Re: [HACKERS] Domains and supporting functions

2006-02-19 Thread elein
On Sun, Feb 19, 2006 at 10:34:02AM -0800, elein wrote: On Sun, Feb 19, 2006 at 01:26:31AM -0500, Tom Lane wrote: elein [EMAIL PROTECTED] writes: I've got a domain based on a text type. I've overridden the equal operator with lower(text) = lower(text). This won't work, you need

[HACKERS] Domains and supporting functions

2006-02-18 Thread elein
domains really are, I would strongly suggest expanding create domain to merge with create type (under) and allow us to list the basic functions. --elein [EMAIL PROTECTED] Example; -- -- check constraint isemail for email base type -- create or replace function isemail(text) returns boolean

Re: [HACKERS] Why don't we allow DNS names in pg_hba.conf?

2006-01-01 Thread elein
pg_hba.conf when these changes occur. elein [EMAIL PROTECTED] On Sun, Jan 01, 2006 at 01:30:46PM -0500, Tom Lane wrote: I was reminded of $subject by http://archives.postgresql.org/pgsql-admin/2006-01/msg2.php While I haven't tried it, I suspect that allowing a DNS host name would take

Re: [HACKERS] relfilenode

2005-10-27 Thread elein
On Thu, Oct 27, 2005 at 09:12:15PM -0400, Andrew Dunstan wrote: The docs have this description for pg_class::relfilenode: Name of the on-disk file of this relation; 0 if none. However, Elein just pointed out to me that there are no entries with 0, so this description seems incorrect. What

Re: [Slony1-general] Re: [HACKERS] Slony RPM issue

2005-10-05 Thread elein
like to install things in lib64. The @@PGBINDIR@@ is also unset in these cases. Generally a short sed (or perl if you like) script will fix these up. But it is really pretty obscure trail for people to find the exact problem. --elein Hrrm. It seems that I've installed wrong file

Re: Procedural language definitions (was Re: [HACKERS] 8.1 and syntax checking at create time)

2005-09-02 Thread elein
. --elein regards, tom lane ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org ---(end of broadcast

[HACKERS]

2005-08-10 Thread elein
programs to access SQL data is the inability of object databases to handle nulls [Melton 95]. Elein -- [EMAIL PROTECTED]Varlena, LLCwww.varlena.com (510)655-2584(o) (510)543-6079(c

Re: [HACKERS] The Contrib Roundup (long)

2005-06-07 Thread elein
a few comments scattered inline... On Tue, Jun 07, 2005 at 02:53:32PM -0300, Josh Berkus wrote: Folks, I had a lot of time to kill on airplanes recently so I've gone digging through /contrib in an effort to sort out what's in there and try to apply some consistent rules to it. Before

Re: [HACKERS] Views, views, views: Summary of Arguments

2005-05-12 Thread elein
the system catalogs. elein = [EMAIL PROTECTED]Varlena, LLCwww.varlena.com (510)655-2584(o) (510)543-6079(c) PostgreSQL Consulting, Support Training PostgreSQL General Bits http

Re: [HACKERS] Views, views, views: Summary of Arguments

2005-05-12 Thread elein
On Thu, May 12, 2005 at 03:30:59PM -0400, Tom Lane wrote: [EMAIL PROTECTED] (elein) writes: Also, if you do not trust the newsysview team to develop good views (with input for hackers), how can you possibly expect every dba and tool maker to access the system catalog in a consistent

Re: [HACKERS] Oracle Style packages on postgres

2005-05-11 Thread elein
Adding to the ambiguity is the dot notation used for composite columns. Don't forget the other end ignoring those required parens. is foo.bar.zap a database.schema.table a schema.table.column a table.column.column --elein On Wed, May 11, 2005 at 03:21:42PM -0400, Tom

Re: [HACKERS] Views, views, views! (long)

2005-05-06 Thread elein
On Fri, May 06, 2005 at 01:20:09AM -0500, Jim C. Nasby wrote: On Fri, May 06, 2005 at 02:43:19AM -, Andrew - Supernews wrote: On 2005-05-06, Christopher Kings-Lynne [EMAIL PROTECTED] wrote: Hmmm ... we argued about this. I was in favor of hiding the OIDs because OIDs are not

Re: [HACKERS] Views, views, views! (long)

2005-05-06 Thread elein
of SQL is also imperative for interfaces that want to create scripts and/or do operations on the data found in the system catalog. e.g. drop all foreign keys linked to table foo. Elein [EMAIL PROTECTED] On Thu, May 05, 2005 at 09:22:40PM -0700, Josh Berkus wrote: Tom, Andrew, Robert, More

Re: [HACKERS] pl/pgsql enabled by default

2005-05-06 Thread elein
with and any other small gotchas. A large gotcha might be a reason to not do it, but I have not seen mention of any. --elein [EMAIL PROTECTED] On Fri, May 06, 2005 at 12:19:12PM -0400, Andrew Sullivan wrote: On Fri, May 06, 2005 at 03:37:21PM +1000, Neil Conway wrote: But I agree security

Re: [HACKERS] Views, views, views! (long)

2005-05-05 Thread elein
is a feature we don't put enough emphasis on, ever. New system views would help people be more productive with PostgreSQL, enable new interfaces to have better packaged information and help all of the people required to support a PostgreSQL database. Elein

Re: [HACKERS] Views, views, views! (long)

2005-05-05 Thread elein
it. This is the bulk of what we are working on. Some is duplicated work with the information schema but it usually has more information or context. --elein [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:pgsql-hackers- [EMAIL PROTECTED] On Behalf Of elein Sent: Thursday, May 05

Re: [HACKERS] Output functions with multiple arguments considered harmful

2005-04-30 Thread elein
On Sat, Apr 30, 2005 at 04:17:59PM -0400, Tom Lane wrote: An example that Elein put up yesterday: http://archives.postgresql.org/pgsql-general/2005-04/msg01384.php caused me to realize that type output functions that depend on additional arguments to determine what they are dealing

Re: [HACKERS] Output functions with multiple arguments considered harmful

2005-04-30 Thread elein
On Sat, Apr 30, 2005 at 05:31:28PM -0400, Tom Lane wrote: [EMAIL PROTECTED] (elein) writes: On Sat, Apr 30, 2005 at 04:17:59PM -0400, Tom Lane wrote: It is trivial to crash 8.0's record_out by lying to it about the rowtype of its first argument. Is it not as trivial to crash it if one

Re: [HACKERS] slides on the optimizer

2005-04-22 Thread elein
If it is ok with you, I'll review these for a General Bits article and then link them up at varlena.com/GeneralBits/Tidbits with some of the other talks I've collected. --elein On Fri, Apr 22, 2005 at 06:33:49PM +1000, Neil Conway wrote: A few hours ago, I gave a talk at linux.conf.au

Re: [HACKERS] argtype_inherit() is dead code

2005-04-17 Thread elein
suggest putting it on the bug list to fold into the replacement arguement marshalling code. That way we won't (ideally) forget the intended behaviour and may even fix it at some point. --elein On Sat, Apr 16, 2005 at 03:39:55PM -0400, Tom Lane wrote: [EMAIL PROTECTED] (elein) writes: Are you

Re: [HACKERS] argtype_inherit() is dead code

2005-04-16 Thread elein
Are you saying that the code was supposed unflatten the arguments of a function into a possible composite type taking into consideration the possible inheritance information of the composite type? elein On Fri, Apr 15, 2005 at 08:04:36PM -0400, Tom Lane wrote: In parse_func.c there are routines

Re: [HACKERS] HEAD \df doesn't show functions with no arguments

2005-03-31 Thread elein
I use df to see what functions are available. I want to see them all. --elein On Fri, Apr 01, 2005 at 12:59:43PM +0800, Christopher Kings-Lynne wrote: Uh, who exactly agreed to that? I know when I do \df it's generally to check out built-in functions not my own. I don't see

Re: [HACKERS] Work on Table Inheritance

2005-02-16 Thread elein
of table inheritance. --elein [EMAIL PROTECTED] On Wed, Feb 16, 2005 at 07:22:39AM -0800, Eliot Simcoe wrote: Hello everyone, I'm working on a project which makes extensive use of the PostgreSQL table inheritance features and am interested in fixing some bugs I have come across. To my

Re: [HACKERS] how to make table inherits another ?

2005-02-16 Thread elein
You specify the inheritance on the creation of the child table. See CREATE TABLE --elein On Wed, Feb 16, 2005 at 11:48:54PM +0300, Oleg Bartunov wrote: Hi there, is't possible to make table to be inherited from another table in case both tables already exist. I tried to insert record

Re: [HACKERS] Interpretation of TRUSTED

2005-02-08 Thread elein
written in a trusted/untrusted language. --elein On Tue, Feb 08, 2005 at 11:12:07PM +0100, Thomas Hallgren wrote: Hi, A TRUSTED language specifies that ordinary users can use the language. It also implies that access to the file system should be prevented. In essence, ordinary users can never

[HACKERS] Vacuum Looping 7.4

2005-01-25 Thread elein
and goes ideally quickly once through. --elein [EMAIL PROTECTED] INFO: vacuuming public.NCA_log_head INFO: index NCA_log_head_pkey now contains 2795382 row versions in 8178 pages DETAIL: 0 index row versions were removed. 83 index pages have been deleted, 83 are currently reusable

Re: [HACKERS] IBM releases 500 patents

2005-01-13 Thread Elein Mustain
They probaly released the informix database patents. This is pertinent to us as several of them were interesting implementations of things like the function manager. --elein On Tue, Jan 11, 2005 at 08:04:48AM -0800, Darcy Buskermolen wrote: IBM has just announced they are waving all rights

Re: [HACKERS] rules, triggers and views

2004-12-05 Thread elein
. We'll see how it goes. This was suggested over on irc. Thank you...More news as it happens. --elein On Sun, Dec 05, 2004 at 06:02:00PM -0500, Tom Lane wrote: elein [EMAIL PROTECTED] writes: Also, what are the reasons for forbidding triggers on views? The fact that they'd never fire

[HACKERS] rules, triggers and views

2004-12-05 Thread elein
for forbidding triggers on views? It is to prevent *possible* mayhem or will it cause real problems? Thanks, elein - End forwarded message - ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [HACKERS] Beta Leader?

2004-08-09 Thread elein
This is the kind of thing I can usually help with. However, right now I'm a little swamped with customer work. I can back someone up, though. --elein On Mon, Aug 09, 2004 at 06:28:33PM -0400, Bruce Momjian wrote: Marc G. Fournier wrote: On Mon, 9 Aug 2004, Josh Berkus wrote: Folks

Re: [DOCS] [HACKERS] Tutorial

2004-07-23 Thread elein
Double postings are a PITB - Forwarded message from elein [EMAIL PROTECTED] - Date: Thu, 22 Jul 2004 21:31:37 -0700 From: elein [EMAIL PROTECTED] To: Robert Treat [EMAIL PROTECTED] Cc: Joe Conway [EMAIL PROTECTED], elein [EMAIL PROTECTED], David Fetter [EMAIL PROTECTED], [EMAIL

Re: [HACKERS] Tutorial

2004-07-22 Thread elein
that the usefulness of our implementation is limited and so the documentation should focus on other areas. elein On Thu, Jul 22, 2004 at 03:21:04PM -0700, David Fetter wrote: Kind people, I am writing a document patch for the tutorials section, and would like to change the section

Re: [HACKERS] Is trust really a good default?

2004-07-12 Thread elein
and configure as necessary. --elein On Mon, Jul 12, 2004 at 05:27:23PM -0400, Tom Lane wrote: Merlin Moncure [EMAIL PROTECTED] writes: IMO, forcing su password at initdb time (allowing blank password with a very stern warning) and bumping localhost to auth is the right way to go. This isn't

Re: [HACKERS] plperl (7.5)

2004-07-11 Thread elein
in reality? Obviously these comments are not for 7.5 nor are they make or break issues. --elein On Sun, Jul 11, 2004 at 11:17:19AM -0400, Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: On Sat, Jul 10, 2004 at 09:18:28PM -0700, elein wrote: The new plperl returns sets by having

[HACKERS] plperl (7.5)

2004-07-10 Thread elein
implementation both techniques would be possible since returning the array is kind of cool ;-) --elein [EMAIL PROTECTED]Varlena, LLCwww.varlena.com PostgreSQL Consulting, Support Training PostgreSQL General Bits

Re: [HACKERS] [BUGS] BUG #1118: Misleading Commit message

2004-07-09 Thread elein
While Alvarro, et al are messing with transaction syntax this would be a good time to clarify this message. --elein On Fri, Jul 09, 2004 at 10:16:29AM -0400, Bruce Momjian wrote: Do we want to add this to TODO: * Issue an extra message when COMMIT completes a failed transaction

Re: [HACKERS] strange bug in plperl

2004-07-05 Thread elein
on #postgresql. --elein On Mon, Jul 05, 2004 at 12:28:32PM -0400, Andrew Dunstan wrote: Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Can anyone suggest why I might be seeing this effect (each notice comes out once per row plus once per function call) It looks like

[HACKERS] Bug in PL/Perl CVS head w/spi patch

2004-07-04 Thread elein
-- -- An SQL error causes subsequent function creation of an otherwise -- healthy function to fail WHEN RUN with: --ERROR: creation of function failed: --(in cleanup) Undefined subroutine PLPerl::mksafefunc called at (eval 4) line 4. -- -- Workaround is to close and reopen the connection

Re: [HACKERS] I/O support for composite types

2004-06-05 Thread elein
YourEmailAddressHere to [EMAIL PROTECTED]) --elein [EMAIL PROTECTED]Varlena, LLCwww.varlena.com PostgreSQL Consulting, Support Training PostgreSQL General Bits http://www.varlena.com/GeneralBits

Re: [HACKERS] I/O support for composite types

2004-06-05 Thread elein
Good reason. Now I'm excited. I'll download and run tests and try to do a write up in general bits next week. cheers, elein On Sat, Jun 05, 2004 at 05:00:24PM -0400, Tom Lane wrote: I wrote: regression=# insert into bar values (row(row(1.1, 2.2), row(3.3, 4.4))); BTW, I forgot to mention

[HACKERS]

2004-05-08 Thread elein
Bcc: Subject: Adding MERGE to the TODO list Reply-To: Can we add the MERGE command to the TODO list? Is anyone actively examining this issue? And yes, I realize it is not for 7.5. It would be good to be able to say it is on the list for some future release, however. Thanks, elein

[HACKERS] Adding MERGE to the TODO list (resend with subject)

2004-05-08 Thread elein
Can we add the MERGE command to the TODO list? Is anyone actively examining this issue? And yes, I realize it is not for 7.5. It would be good to be able to say it is on the list for some future release, however. Thanks, elein [EMAIL

[HACKERS] Analysis/Overview of PostgreSQL and SQL2003

2004-04-14 Thread elein
is publication on General Bits and techdocs. There is also the possibility of publishing a version in other more marketing oriented venues. Contact me if you are interested in working on this or have work you are willing to share on this. elein PS: Sorry for the cross posting

[HACKERS] hacking data directories

2004-03-29 Thread elein
if that is what is necessary. All advice is greatly appreciated. Thanks, elein [EMAIL PROTECTED] ---(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] [pgsql-www] Collaboration Tool Proposal

2004-02-28 Thread elein
enables people to track the status of their issues. But as it is now, a resident python person would be extremely helpful to wrap up any customization (yes we'll want customization). --elein [EMAIL PROTECTED] On Fri, Feb 27, 2004 at 03:31:14PM -0800, Josh Berkus wrote: Mikhail

[HACKERS] [Resend: Domains and function]

2004-02-07 Thread elein
. However, I suspect that there is no underlying support for type checks in the general system. Elein - Forwarded message from elein [EMAIL PROTECTED] - I can create a function with a domain and define it to return a domain. The parameter is checked to see if it qualifies

Re: [HACKERS] Named arguments in function calls

2004-01-31 Thread elein
I agree with Tom on this. Good operator combinations are hard to find when you are creating new operators. = is a particularly good one. Barring any override from the SQL200x standard, I would strongly suggest AS, too. elein [EMAIL PROTECTED] On Sun, Jan 25, 2004 at 02:54:12PM -0500, Tom Lane

[HACKERS] [fwd: [GENERAL] Domains and function]

2003-12-05 Thread elein
I did not get any response to this question on general so I am forwarding it to hackers. Thanks, elein - Forwarded message from elein [EMAIL PROTECTED] - Date: Sat, 29 Nov 2003 14:11:20 -0800 From: elein [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: elein [EMAIL PROTECTED] Subject

Re: [HACKERS] Release cycle length

2003-11-18 Thread elein
group to participate as well as prepare for conversion is something I can help promote. (Just contact me to submit articles for publication--the invitation is always open.) --elein = [EMAIL PROTECTED] Varlena, LLC

[HACKERS] cvs head? initdb?

2003-11-13 Thread elein
What is the status of CVS head? Isn't it in sync with 7.4.RC2? I just upgraded from CVS and rebuilt clean and initdb now gives this lovely informative initdb failed message. I haven't had trouble previously with cvs head or other versions. $ sudo make install ... PostgreSQL installation

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

2003-11-09 Thread elein
emeritus is a perfectly good latin word. No need to dumb things down. --elein On Wed, Nov 05, 2003 at 05:26:29PM -0500, Bruce Momjian wrote: Tom Lane wrote: Josh Berkus [EMAIL PROTECTED] writes: B) What contributors are listed under Major Developers who haven't contributed any code

Re: [HACKERS] [DOCS] Annotated release notes

2003-11-01 Thread elein
format. But maybe there is some clarification text you can use. http://cookie.varlena.com:8080/varlena/GeneralBits/48.php elein On Thu, Oct 30, 2003 at 11:59:05PM -0500, Bruce Momjian wrote: OK, I have committed changes to release.sgml so most complex entries have a paragraph describing

Re: [HACKERS] plpython

2003-09-06 Thread elein
The key value of having both SD vs. GB is scope. We *do* want to be able to have dictionaries with scope that is function specific, statement specific and global (available to all functions). I do use plpython primarily for running aggregates. Having the different scopes (if they all worked

Re: [HACKERS] [GENERAL] Needed function IF(expr, expr, expr)

2003-09-06 Thread elein
If the function is defined with ANY* and you defer typing the arguments until the first reference then I think you will get what you want with the CASE statement. If the function is called if( xy, x+1, y), the first reference is in the argument list and so should be typed there. But if you

Re: [HACKERS] plpython

2003-09-05 Thread elein
NO!!! Don't remove SD and GD!!! They are useful. I use them in several applications, primarily for running aggregates. What needs to be fixed is that the SD needs to be initialized at the start of each statement. Joe Conway just implemented this in Pl/R and Tom Lane had an idea about it too. See

Re: [HACKERS] Windows on SuSE? 7.4

2003-08-14 Thread elein
Yes, I actually have a libwsock32 because my system has wine on it. Wine is a windows emulator. So the assumption that any system with that file is a windows system will break on systems with windows emulators. It sounds like Joe's guess on this was right. --elein On Mon, Aug 11, 2003

Re: [HACKERS] statement level trigger causes pltcl, plpython SIGSEGV

2003-08-14 Thread elein
I thought that statement level triggers did not work yet. Are they supposed to work in 7.4? (But even if they don't work they shouldn't crash...) elein On Sun, Aug 03, 2003 at 08:04:11PM -0700, Joe Conway wrote: I was working on trigger support for PL/R and ran across this bug in my own code

Re: [HACKERS] Windows on SuSE? 7.4

2003-08-14 Thread elein
I blame SuSE. Thank you for the fix and confirmation of the problem. elein On Mon, Aug 11, 2003 at 01:53:31PM -0400, Tom Lane wrote: elein [EMAIL PROTECTED] writes: Yes, I actually have a libwsock32 because my system has wine on it. Wine is a windows emulator. And they drop

Re: [HACKERS] Windows on SuSE? 7.4

2003-08-14 Thread elein
cassert was on. Now debug is on, too. I updated from cvs-head just now. configure knows it is a linux box. Should it be trying to link to libwsock32.so or not? If this is a legitimate link, then the problem is different than if it is trying to link it in erroneously. --elein The is the top

[HACKERS] Windows on SuSE? 7.4

2003-08-10 Thread elein
SuSE 7.3, PostgreSQL cvshead (7.4) This is as far as I've gotten with 7.4. It is built and configured like my 7.3 installation on the same machine. I have built from CVS previously. And the production sources always builds very nice and clean. Nothing runs. gbd output is below. It is

  1   2   >