Re: [HACKERS] Tech details - psql wraps at window width

2008-04-26 Thread Bryce Nesbitt

Bruce Momjian wrote:
Hey, I can work with this idea. First, there really is no 'off' mode 
for wrapped because that is aligned...
Well, come to think of it, wrapped is not really a new output format 
in the sense of html or latex.  It could build on aligned:


\pset format aligned [autowrap|nowrap|nnn]

But there's still the issue of wanting separate defaults for tty and 
stream outputs.  The last thing you want is an admin deciding on 
wrapping, and then subtly breaking scripts.  My personal desired 
defaults are:


* Terminals autowrap.
* Streams don't wrap, except in the rare case when I want to force a 
specific width (e.g. 79 for a newsgroup posting).


 -Bryce



--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


[HACKERS] Compiling trigger function with MinGW

2008-04-26 Thread Anton Burkun

Hello All.

Now I try to link dll with MinGW from Example in Postgres Help.
Linker show me this error:

D:\users\anthony\kursor\abzcrm\c\foogcc -shared foo.o -o foo.dll -L 
d:/files/local/PostgreSQL/8.3/lib -l postgres

Cannot export ⌂postgres_NULL_THUNK_DATA: symbol not found
collect2: ld returned 1 exit status

What should I do?

--
Anton Burkun
+380 66 757 70 27

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


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

2008-04-26 Thread Andrew Dunstan



Raphaël Jacquot wrote:

would seem like a good idea, no ?

http://www.murrayc.com/blog/permalink/2008/04/25/postgresql-has-no-bugzilla/ 



Before you come trolling on this (or any other) subject, please read the 
voluminous debates that have taken place about it. Apparently you think 
it's something we have never considered, which in light of the product 
we maintain would be more than remarkable.


Having done that, please endeavour to make an actual contribution to the 
discussion.


cheers

andrew

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


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

2008-04-26 Thread Brendan Jurd
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Sat, Apr 26, 2008 at 4:13 PM, Andrew Dunstan  wrote:

  Before you come trolling on this (or any other) subject, please read the
 voluminous debates that have taken place about it. Apparently you think it's
 something we have never considered, which in light of the product we
 maintain would be more than remarkable.

  Having done that, please endeavour to make an actual contribution to the
 discussion.


Hi Andrew,

Let's be fair.  It would be an almost impossible task to make any
sense of the archives on this topic without dedicating tens of hours
to the task, and having access to a better way of reading the archives
than is offered at archives.postgresql.org.

Raphaël, there have indeed been vast debates about this.  My version
of the executive summary would be that some people want a tracker,
some people think email is good enough, and the people who do want a
tracker have different opinions about which tracker would be best for
the project.  There's a wiki page about the (daunting) set of features
which would be required in a tracker to make everybody happy[1].

We are currently experimenting with using a wiki page to organise our
queue of patches[2], and there has been some effort to set up a test
bugzilla installation[3] but as yet there has been no viable consensus
as to adopting a particular tracker.

Cheers,
BJ

[1] http://wiki.postgresql.org/wiki/TrackerDiscussion
[2] http://wiki.postgresql.org/wiki/CommitFest:May
[3] http://wiki.postgresql.org/wiki/Tracker:BugzillaTest

-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.7 (GNU/Linux)
Comment: http://getfiregpg.org

iD8DBQFIEsya5YBsbHkuyV0RAnOyAKDI7Ygcb8m689IJtMcGQtmMq+5CPwCeMIsk
/+eXsTtGNVVWIfsvNsEyW7A=
=6DTB
-END PGP SIGNATURE-

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] Tech details - psql wraps at window width

2008-04-26 Thread Brendan Jurd
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Sat, Apr 26, 2008 at 5:08 PM, Bryce Nesbitt
 wrote:
  Well, come to think of it, wrapped is not really a new output format in
 the sense of html or latex.  It could build on aligned:

  \pset format aligned [autowrap|nowrap|nnn]


I agree that wrapped is more a variant of aligned mode than a format
mode in its own right.  Expressing it that way with \pset has the nice
bonus that you don't lose your preference for wrapped mode when
switching between aligned and unaligned with \a.

  But there's still the issue of wanting separate defaults for tty and stream
 outputs.  The last thing you want is an admin deciding on wrapping, and then
 subtly breaking scripts.  My personal desired defaults are:


Well, if we pursue Peter's suggestion that psql abstain from reading
the startup file in noninteractive mode, then this problem goes away.
An admin could opt to wrap in his interactive sessions without it ever
affecting the behaviour of scripts ... which is exactly what you would
want.

Cheers,
BJ
-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.7 (GNU/Linux)
Comment: http://getfiregpg.org

iD8DBQFIEs3x5YBsbHkuyV0RAiPsAJ0QIhWmq4s622dTZNP4MknxWTm30wCfaMTP
kY9qEW0GB3rJb3Xq5F92geY=
=GbOb
-END PGP SIGNATURE-

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] MERGE Specification

2008-04-26 Thread Hannes Dorbath

Simon Riggs wrote:

On Fri, 2008-04-25 at 10:03 +0300, Hannu Krosing wrote:

On Tue, 2008-04-22 at 00:24 +0100, Simon Riggs wrote:

On Mon, 2008-04-21 at 16:38 -0400, A.M. wrote:

MERGE will not invoke Rules. Does this imply that MERGE cannot be  
used on views or that the resulting INSERTs or UPDATEs do not work on  
views?

Yes, that's right. Just like COPY. That seems fine to me because you're
likely to be doing a MERGE immediately after a COPY anyway, so the
restriction just continues.

May be the bulk data merging variant of MERGE to be used after initial
COPY should be a variant of COPY with special keyword(s) instead of
MERGE ?


That does sound like a good way of differentiating between the OLTP and
bulk loading cases.

I'll bear that in mind as we develop.


To me, a simple user, it'd be important that MERGE implementation does 
not place any unpredictable restrictions. For example in Oracle you can 
break any MERGE statement by placing a full text index on the table. So 
I'd really expect a MERGE in PostgreSQL to be fine with views, rules, 
tsearch, etc.


Just my 2 cent.


--
Best regards,
Hannes Dorbath

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] Tech details - psql wraps at window width

2008-04-26 Thread Bruce Momjian
Bruce Momjian wrote:
 Hey, I can work with this idea.  First, there really is no 'off' mode
 for wrapped because that is aligned.  What we could do is to have:
 
   \pset format wrapped display
 
 affect only output to the screen, using the screen width, and:
 
   \pset format wrapped nnn
 
 affect output to the screen and file/pipes.

A new idea would be for a wrap value of zero to be special:

\pset format wrapped 0
 
to wrap to screen width for terminal and file/pipe output.

-- 
  Bruce Momjian  [EMAIL PROTECTED]http://momjian.us
  EnterpriseDB http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] Proposed patch - psql wraps at window width

2008-04-26 Thread Bruce Momjian
Bruce Momjian wrote:
 Gregory Stark wrote:
 I don't see that behavior here on Ubuntu 7.10:
 
   $ COLUMNNS=120 ls -C |cat
   archive   cdinitrd  lost+found  proc  srv  usr
   basement.usr  dev   initrd.img  media   root  sys  var
   bin   etc   laptop  mnt rtmp  tmp  vmlinuz
   boot  home  lib opt sbin  uwin
   $ ls --version
   ls (GNU coreutils) 5.97
 
 That is not a 120 width.  'ls' seems to ignore columns for pipe output.

Oops, Alvaro pointed out I typo'ed the variable name COLUMNS as
COLUMNNS. I see now that 'ls -C' does honor columns.  See my later
posting about '\pset wrapped 0' as a special case where we could honor
the ioctl/COLUMNS case.

My real confusion is this:

$ echo $COLUMNS
146

$ ls -C|less
archive   cdinitrd  lost+found  proc  srv  usr
basement.usr  dev   initrd.img  media   root  sys  var
bin   etc   laptop  mnt rtmp  tmp  vmlinuz
boot  home  lib opt sbin  uwin

$ COLUMNS=120 ls -C|less
archive   bin   cd   etc   initrd  laptop  lost+found  mnt  
proc rtmp  srv  tmp  usr  vmlinuz
basement.usr  boot  dev  home  initrd.img  lib media   opt  
root sbin  sys  uvar  win

Why does the first 'ls' not honor columns while the second does?  How
does 'ls' detect that the COLUMNS=120 is somehow different from the
default COLUMNS value?

-- 
  Bruce Momjian  [EMAIL PROTECTED]http://momjian.us
  EnterpriseDB http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] Re: [COMMITTERS] pgsql: Update: * Allow adding enumerated values to an existing

2008-04-26 Thread Alvaro Herrera
Andrew Dunstan escribió:

 Tom Dunstan wrote:
 So two alternative proposals, both with a 2 byte enum id and a 2 byte 
 value:

 1 - We space the values out as evenly as we can across the 65000ish
 range and allow people to delete, insert and append, but not reorder.
 If they do the above gratuitously we might have to do a rewrite, but
 they'll have to get fairly busy to do it. Rewrite would be required
 for reorderings.

 Or else we just error out in such cases. As Tom Lane suggests, rewriting  
 has some nasty deadlock possibilities.

 You always have the option of creating a new enum type and moving each  
 affected column to that type.

Another alternative would be internally creating a different temporary
enum, rewriting the tables one by one each on its own transaction, and
finish by dropping the original enum and renaming the temporary one.
This solves the deadlock problem.

-- 
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] Proposed patch - psql wraps at window width

2008-04-26 Thread Aidan Van Dyk
* Bruce Momjian [EMAIL PROTECTED] [080426 09:44]:

 Why does the first 'ls' not honor columns while the second does?  How
 does 'ls' detect that the COLUMNS=120 is somehow different from the
 default COLUMNS value?

I would hazard a guess that COLUMNS isn't exported from your
shell environment in the first case.   In the other cases, the explicit:
VAR=... command
the shell is told to set VAR explicitly before starting command, in
addition to any exported vars.

a.

-- 
Aidan Van Dyk Create like a god,
[EMAIL PROTECTED]   command like a king,
http://www.highrise.ca/   work like a slave.


signature.asc
Description: Digital signature


Re: [HACKERS] Proposed patch - psql wraps at window width

2008-04-26 Thread Bruce Momjian
Bruce Momjian wrote:
 Oops, Alvaro pointed out I typo'ed the variable name COLUMNS as
 COLUMNNS. I see now that 'ls -C' does honor columns.  See my later
 posting about '\pset wrapped 0' as a special case where we could honor
 the ioctl/COLUMNS case.
 
 My real confusion is this:
 
   $ echo $COLUMNS
   146
 
   $ ls -C|less
   archive   cdinitrd  lost+found  proc  srv  usr
   basement.usr  dev   initrd.img  media   root  sys  var
   bin   etc   laptop  mnt rtmp  tmp  vmlinuz
   boot  home  lib opt sbin  uwin
 
   $ COLUMNS=120 ls -C|less
   archive   bin   cd   etc   initrd  laptop  lost+found  mnt  
 proc rtmp  srv  tmp  usr  vmlinuz
   basement.usr  boot  dev  home  initrd.img  lib media   opt  
 root sbin  sys  uvar  win
 
 Why does the first 'ls' not honor columns while the second does?  How
 does 'ls' detect that the COLUMNS=120 is somehow different from the
 default COLUMNS value?

Ah, I see now.  $COLUMNS isn't exported to subshells, hence the previous
comment that readline needs to be called before it has a value.  It
seems psql does have COLUMNS set if readline is defined, which means we
can't detect of $COLUMNS was passed to psql or was detected.  More
interesting, it doesn't seem psql sets $COLUMNS in batch mode:

psql -c '\echo `echo $COLUMNS`' test
{blank line}

COLUMNS=120 sql -c '\echo `echo $COLUMNS`' test
120

so we could argue that COLUMNS should be honored but again this would
affect \g filename.  The issue with 'ls' is that it knows it isn't going
to be getting new commands from the user that change where its output is
going, while psql can.

-- 
  Bruce Momjian  [EMAIL PROTECTED]http://momjian.us
  EnterpriseDB http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] FSM fill ratio

2008-04-26 Thread Alvaro Herrera
Jacques Caron wrote:
 Hi all,

 Quick question: is there currently a way to see how many slot are used in 
 the FSM (i.e. how many free pages are stored there), or how many are 
 free? If not, wouldn't it be a good idea to add this somewhere? (Don't 
 quite know where... is it possible to have very dynamic values in show 
 xxx?) This would help a lot finding out whether the current fsm settings 
 are fine or not...

There's contrib/pg_freespacemap

-- 
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] Proposed patch - psql wraps at window width

2008-04-26 Thread Bruce Momjian
Gregory Stark wrote:
 
 [Just when I thought I was out, they pull me back in -- argh, I'm weak]
 
 Bruce Momjian [EMAIL PROTECTED] writes:
 
  FYI, ls -C actually wraps to 72(?) unless you specify another width, 
 
 I told you exactly what ls did, at least GNU ls. It uses -w if specified, if
 not then it uses the ioctl if that succeeds, if it fails it uses COLUMNS, and
 if that's unavailable it uses a constant.

 $ COLUMNS=40 ls -C | cat
 distmp3.rh3280  purpleNMN49T
 gconfd-starkssh-WdHPsk4277
 orbit-stark

I don't see that behavior here on Ubuntu 7.10:

$ COLUMNNS=120 ls -C |cat
archive   cdinitrd  lost+found  proc  srv  usr
basement.usr  dev   initrd.img  media   root  sys  var
bin   etc   laptop  mnt rtmp  tmp  vmlinuz
boot  home  lib opt sbin  uwin
$ ls --version
ls (GNU coreutils) 5.97

That is not a 120 width.  'ls' seems to ignore columns for pipe output.

  That might make the I want it always to wrap group happier, but not the
  wrapped shouldn't affect file/pipe. I have not heard anyone explain why
  the later behavior is bad, especially if we default to a width of 72 rather
  than the screen width.
 
 Presumably they're concerned that scripts which dump out data and then try to
 parse it will have trouble parsing wrapped output. In any case that should be
 based on whether isatty() is true, which is related to but not the same as
 whether the window size ioctl succeeds.

Right now we honor $COLUMNS only when isatty() is true.

-- 
  Bruce Momjian  [EMAIL PROTECTED]http://momjian.us
  EnterpriseDB http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


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

2008-04-26 Thread Joshua D. Drake

Brendan Jurd wrote:


 Having done that, please endeavour to make an actual contribution to the
discussion.



Hi Andrew,

Let's be fair.  It would be an almost impossible task to make any
sense of the archives on this topic without dedicating tens of hours
to the task, and having access to a better way of reading the archives
than is offered at archives.postgresql.org.


+1

The idea that anyone would waste their time (and yes it is a complete 
waste of time) reviewing the archives which are almost impossible to 
search unless you know exactly what you are looking for is ridiculous.
Andrew, I am frankly surprised that you would have that response for the 
individual.


How do you know he was trolling? Perhaps he is just surprised (which is 
the impression that I got) that considering we are such a mature project 
that we don't have a bugzilla or other such beast.


Sincerely,

Joshua D. Drake

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] Re: [COMMITTERS] pgsql: Update: * Allow adding enumerated values to an existing

2008-04-26 Thread Andrew Dunstan



Alvaro Herrera wrote:

Andrew Dunstan escribió:

  

Tom Dunstan wrote:


So two alternative proposals, both with a 2 byte enum id and a 2 byte value:

1 - We space the values out as evenly as we can across the 65000ish
range and allow people to delete, insert and append, but not reorder.
If they do the above gratuitously we might have to do a rewrite, but
they'll have to get fairly busy to do it. Rewrite would be required
for reorderings.
  
Or else we just error out in such cases. As Tom Lane suggests, rewriting  
has some nasty deadlock possibilities.


You always have the option of creating a new enum type and moving each  
affected column to that type.



Another alternative would be internally creating a different temporary
enum, rewriting the tables one by one each on its own transaction, and
finish by dropping the original enum and renaming the temporary one.
This solves the deadlock problem.

  


What happens when someone tries to join two of the tables, one that has 
been converted and one that hasn't? You might not have deadlock, but you 
won't have type integrity either, ISTM.


cheers

andrew

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


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

2008-04-26 Thread Andrew Dunstan



Joshua D. Drake wrote:

Brendan Jurd wrote:

 Having done that, please endeavour to make an actual contribution 
to the

discussion.



Hi Andrew,

Let's be fair.  It would be an almost impossible task to make any
sense of the archives on this topic without dedicating tens of hours
to the task, and having access to a better way of reading the archives
than is offered at archives.postgresql.org.


+1

The idea that anyone would waste their time (and yes it is a complete 
waste of time) reviewing the archives which are almost impossible to 
search unless you know exactly what you are looking for is ridiculous.
Andrew, I am frankly surprised that you would have that response for 
the individual.



I entered bugzilla on the archives search page and got this link, 
right out of the recent discussion, at the top of the list:


http://archives.postgresql.org/pgsql-hackers/2008-04/msg00764.php

That and a few similar results might have given the OP some hints about 
what people are thinking and why.


So your suggestion that the search engine is useless is just plain wrong 
in this case.


How do you know he was trolling? Perhaps he is just surprised (which 
is the impression that I got) that considering we are such a mature 
project that we don't have a bugzilla or other such beast.





Well, his post added precisely nothing to the debate. Personally, when I 
find something surprising my first reaction is to go looking for a 
reason, and only to ask about it if I can't find answers. As I have 
demonstrated, finding clues would have been absurdly simple, despite 
your assertion to the contrary. I just don't see any point at all in 
posting a link to some random blog where mostly anonymous posters 
comment on our lack of a bug tracker. A reasoned contribution to the 
debate on the other hand will be welcome.


Perhaps it wasn't a troll. If it wasn't I apologise. My other points 
remain, however.


(BTW, I have long been on the record as being in favor of using a 
tracker for both bugs and features, and I did work some years ago on 
making mainline Bugzilla fully support Postgres.)



cheers

andrew

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


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

2008-04-26 Thread Joshua D. Drake

Andrew Dunstan wrote:


I entered bugzilla on the archives search page and got this link, 
right out of the recent discussion, at the top of the list:


http://archives.postgresql.org/pgsql-hackers/2008-04/msg00764.php

That and a few similar results might have given the OP some hints about 
what people are thinking and why.




How would he know to search at the archives?

 * There is no archives signature at the bottom of -hackers lists

 * The mail-pref link when followed doesn't provide a link to the archives

 * The website? Hmm I guess I click support and then a link called 
mailing lists, oh and then there is a link somewhere down the middle of 
the page that says, archives.


Lastly, why would I search the archives?

There is this vast assumption that anyone (I do this too) will just 
know to do something in this community. I think that assumption is far 
off base.


IMO, a more appropriate response would have been something like:

Thanks for the discussion, this is something our community is currently 
considering. You can view these two links if you are interested.


link
link

All we did with our response is say...

Hey, you are a troll, go away. When in fact he likely wasn't.

Well, his post added precisely nothing to the debate. Personally, when I 
find something surprising my first reaction is to go looking for a 
reason, and only to ask about it if I can't find answers. As I have 


As my wife often tells me, you are not like everyone else.

The first natural response from most people that I encounter, is to ask 
not to research.


demonstrated, finding clues would have been absurdly simple, despite 
your assertion to the contrary. I just don't see any point at all in 
posting a link to some random blog where mostly anonymous posters 
comment on our lack of a bug tracker.


Well I won't disagree that the post was offtopic for the list.


(BTW, I have long been on the record as being in favor of using a 
tracker for both bugs and features, and I did work some years ago on 
making mainline Bugzilla fully support Postgres.)


Right, which is also why I was surprised by your reply.

Sincerely,

Joshua D. Drake


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] Proposed patch - psql wraps at window width

2008-04-26 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes:
 I don't see that behavior here on Ubuntu 7.10:

   $ COLUMNNS=120 ls -C |cat
   archive   cdinitrd  lost+found  proc  srv  usr
   basement.usr  dev   initrd.img  media   root  sys  var
   bin   etc   laptop  mnt rtmp  tmp  vmlinuz
   boot  home  lib opt sbin  uwin
   $ ls --version
   ls (GNU coreutils) 5.97

 That is not a 120 width.  'ls' seems to ignore columns for pipe output.

Well, it's *certainly* gonna ignore COLUMNNS.

regards, tom lane

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] Re: [COMMITTERS] pgsql: Update: * Allow adding enumerated values to an existing

2008-04-26 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes:
 Alvaro Herrera wrote:
 Another alternative would be internally creating a different temporary
 enum, rewriting the tables one by one each on its own transaction, and
 finish by dropping the original enum and renaming the temporary one.
 This solves the deadlock problem.

 What happens when someone tries to join two of the tables, one that has 
 been converted and one that hasn't? You might not have deadlock, but you 
 won't have type integrity either, ISTM.

Not to mention the mess you'll be left with if the process fails after
converting some of the tables.

regards, tom lane

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


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

2008-04-26 Thread Tom Lane
Joshua D. Drake [EMAIL PROTECTED] writes:
 How would he know to search at the archives?

If he knew enough about the community to post in -hackers (as opposed
to, say, -general or -novice) he should certainly have heard of the
mailing list archives.  *You* might find 'em useless but I don't.

regards, tom lane

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


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

2008-04-26 Thread Joshua D. Drake

Tom Lane wrote:

Joshua D. Drake [EMAIL PROTECTED] writes:

How would he know to search at the archives?


If he knew enough about the community to post in -hackers (as opposed
to, say, -general or -novice) he should certainly have heard of the


You think so? (not being sarcastic).


mailing list archives.  *You* might find 'em useless but I don't.


I didn't say I found them useless. I said they are useless unless you 
know what you are looking for. I am pretty sure that when it comes to 
PostgreSQL, you always know what you are looking for.


Anyway, now I am off-topic, so I am done with this thread.

Sincerely,

Joshua D. Drake



--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


[HACKERS] Traveling this week

2008-04-26 Thread Bruce Momjian
I am leaving tomorrow/Sunday for a one-week trip for EnterpriseDB to
Mineapolis and Los Angeles.  I will be offline most of the trip so I
will miss the start of the May commit fest.

-- 
  Bruce Momjian  [EMAIL PROTECTED]http://momjian.us
  EnterpriseDB http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


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

2008-04-26 Thread Andrew Sullivan
On Sat, Apr 26, 2008 at 08:54:46AM -0700, Joshua D. Drake wrote:

 How would he know to search at the archives?

  * There is no archives signature at the bottom of -hackers lists

Maybe because there's a perfectly functional archive link in the mail
headers?  And because there's an RFC that tells us how such headers
are supposed to work?

A

-- 
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers