[HACKERS] Translation

2003-06-18 Thread P.M
Hi, Ok so if i can't help you in the code, maybe i can help you translating installation comments into several languages ? I know, french, slovak, spanish.. ;-) __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com --

Re: [HACKERS] Two weeks to feature freeze

2003-06-18 Thread Oleg Bartunov
On Thu, 19 Jun 2003, Christopher Kings-Lynne wrote: > > We have less than two weeks to feature freeze. Win32 is still in an > > uncompleted state, and I haven't been able to return to it recently. > > Jan is working on getting exec() working, and hopefully someone can help > > me on signals. If

Re: [HACKERS] add column .. default

2003-06-18 Thread Tom Lane
Rod Taylor <[EMAIL PROTECTED]> writes: > For the update I intend to use double space, as if the user did those > items as individual commands within the same transaction. There is no alternative, unless you want the command to be non-roll-back-able. > Someone can > make it more efficient in regar

Re: [HACKERS] allowed user/db variables

2003-06-18 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > SHOW ALL; > Will help, but won't tell the whole story... See my followup. Which bits of info would you like to see added that SHOW doesn't reveal? regards, tom lane ---(end of broadcast)

Re: [HACKERS] Two weeks to feature freeze

2003-06-18 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > What about the nested transaction stuff? With all due respect to Alvaro et al, I can't imagine that that will make it into 7.4. (I have no confidence that PITR or Win32 native port will make it either...) > Do we have any "killer" features

Re: [HACKERS] src/bin/scripts seems a bit of a misnomer now

2003-06-18 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > Does anyone care about contrib/reindexdb anymore? I'd think it's still at least as useful as clusterdb. Why, are you thinking of doing some work on it? regards, tom lane ---(end of broadcast)

Re: [HACKERS] pg_get_triggerdef in pg_dump

2003-06-18 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: >> There might be other cases of legal direct change of system catalog >> entries, e,g. varchar to text, if they all are only names for internally >> identical data structures. Can you tell which datatypes may be legally >> interchanged? > Y

Re: [HACKERS] Two weeks to feature freeze

2003-06-18 Thread Alvaro Herrera
On Thu, Jun 19, 2003 at 09:27:22AM +0800, Christopher Kings-Lynne wrote: > > We have less than two weeks to feature freeze. > > What about the nested transaction stuff? I don't know if it will be completed before feature freeze... we can and will try, of course. Sadly, like most other people, I

Re: [HACKERS] Two weeks to feature freeze

2003-06-18 Thread Alvaro Herrera
On Wed, Jun 18, 2003 at 09:59:17PM -0400, Matthew T. O'Connor wrote: > On Wed, 2003-06-18 at 21:27, Christopher Kings-Lynne wrote: > > Do we have any "killer" features added to 7.4 that we can shout about? > > There's usually been one or two in the past...? > > Isn't the index growth problem solve

[HACKERS] add column .. default

2003-06-18 Thread Rod Taylor
I took a quick glance at this. It boils down to essentially an: 1) ALTER TABLE .. ADD COLUMN DEFAULT 2) UPDATE .. SET = IF IS NOT NULL; 3) Add including NOT NULL, CHECK, Foreign Key, etc. each of which will do it's own confirmation pass on the values inserted into the table by step 2 for t

Re: [HACKERS] Two weeks to feature freeze

2003-06-18 Thread Matthew T. O'Connor
On Wed, 2003-06-18 at 21:27, Christopher Kings-Lynne wrote: > Do we have any "killer" features added to 7.4 that we can shout about? > There's usually been one or two in the past...? Isn't the index growth problem solved in this release? I think that is a killer feature that solves a big problem

Re: [HACKERS] Two weeks to feature freeze

2003-06-18 Thread Rod Taylor
On Thu, 2003-06-19 at 01:27, Christopher Kings-Lynne wrote: > > We have less than two weeks to feature freeze. Win32 is still in an > > uncompleted state, and I haven't been able to return to it recently. > > Jan is working on getting exec() working, and hopefully someone can help > > me on signal

Re: [HACKERS] allowed user/db variables

2003-06-18 Thread Christopher Kings-Lynne
> I wonder if there's a way to read all allowed user/database variables > that can be set/reset. > I'd like to have this self-configured in pgAdmin3 instead of hard-coded. You know, I was just about to ask this for phpPgAdmin3!!! SHOW ALL; Will help, but won't tell the whole story... Chris -

Re: [HACKERS] Two weeks to feature freeze

2003-06-18 Thread Christopher Kings-Lynne
> We have less than two weeks to feature freeze. Win32 is still in an > uncompleted state, and I haven't been able to return to it recently. > Jan is working on getting exec() working, and hopefully someone can help > me on signals. If I get those two done, I think I can tweek Win32 in > minor wa

Re: [HACKERS] src/bin/scripts seems a bit of a misnomer now

2003-06-18 Thread Christopher Kings-Lynne
> With Peter's latest commit, there aren't any actual scripts left in > src/bin/scripts; only C programs. Does that bother anyone? I was > wondering about renaming to something like src/bin/misc. (Not that > that name seems very compelling either...) Does anyone care about contrib/reindexdb any

Re: [HACKERS] pg_get_triggerdef in pg_dump

2003-06-18 Thread Christopher Kings-Lynne
> Right offhand I think text<->varchar and adjustment of length limits in > char, varchar, and perhaps numeric would be the only things useful > enough to worry about handling. I'd love to have adding and removing precision and timezones on timestamp* fields Chris ---(en

Re: [HACKERS] pg_get_triggerdef in pg_dump

2003-06-18 Thread Christopher Kings-Lynne
> Hm, you're right, 'thou I wouldn't recommend this to the average user, > and wonder if this will be possible for all future pgsql versions too. > I'm considering adding safe support for this type of column change to > pgAdmin3. > There might be other cases of legal direct change of system cata

Re: [HACKERS] pg_get_triggerdef in pg_dump

2003-06-18 Thread Christopher Kings-Lynne
> If that's what you need you can always change the system catalogs > manually. For CHAR(n) and VARCHAR(n) you change pg_attribute.atttypmod > to (n+4). For NUMERIC(n,m) it's something like (n<<16) + m + 4 or maybe > (m<<16) + n + 4, don't remember right now. > > Be sure to check that your data i

Re: [HACKERS] allowed user/db variables

2003-06-18 Thread Andreas Pflug
Tom Lane wrote: Look at SHOW ALL, maybe? Of course Sorry. If you're willing to think about a solution that would only exist starting in 7.4 --- some of my cohorts at Red Hat are about to submit patches that create a separate "pg_guc" executable that contains another copy of the backend's GUC

Re: [HACKERS] allowed user/db variables

2003-06-18 Thread Tom Lane
Andreas Pflug <[EMAIL PROTECTED]> writes: > I wonder if there's a way to read all allowed user/database variables > that can be set/reset. > I'd like to have this self-configured in pgAdmin3 instead of hard-coded. Look at SHOW ALL, maybe? Or the pg_settings system view? If you're willing to thi

[HACKERS] allowed user/db variables

2003-06-18 Thread Andreas Pflug
I wonder if there's a way to read all allowed user/database variables that can be set/reset. I'd like to have this self-configured in pgAdmin3 instead of hard-coded. Can you give a hint? Regards, Andreas ---(end of broadcast)--- TIP 2: you can get

Re: [HACKERS] Groups and roles

2003-06-18 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Maybe this is too radical, but why not merge "user" and "group" into one > animal? Both exist to bear privileges. The only difference is that > groups can contain other bearers of privileges, but then a user is just a > special case with zero members

Re: [HACKERS] src/bin/scripts seems a bit of a misnomer now

2003-06-18 Thread Tom Lane
Rod Taylor <[EMAIL PROTECTED]> writes: > How about just pulling them up a directory into src/bin? Nah, I don't like that. All the programs are at the same level in the src/bin tree, and I think it should stay that way. Bruce's idea of calling it "tools" seems reasonable ... although there might

Re: [HACKERS] mingw singal support (was information Windows - PostgreSQL)

2003-06-18 Thread Merlin Moncure
Bruce, Things are not that bad: I quickly looked at the signal support in mingw. The header file is singal.h instead of winsig.n, of course. The support for signals is incomplete, with no or erroneous support for floating point exceptions, missing support for integer violations (like microsoft's

[HACKERS] Two weeks to feature freeze

2003-06-18 Thread Bruce Momjian
We have less than two weeks to feature freeze. Win32 is still in an uncompleted state, and I haven't been able to return to it recently. Jan is working on getting exec() working, and hopefully someone can help me on signals. If I get those two done, I think I can tweek Win32 in minor ways during

[HACKERS] Escape sequences in string literals insufficient?

2003-06-18 Thread Peter Eisentraut
In recent times there has been an increasing amount of user questions that indicate that some sort of functionality is missing in the available escape sequences in string literals for "un-enterable" characters. This problem manifests itself in one of two ways: 1. A user wants to enter a characte

Re: [HACKERS] information Windows - PostgreSQL

2003-06-18 Thread Andrew Dunstan
Not sure if this is useful - I just found it on MSDN. It talks about porting issues, including specifically signal handling techniques (it seems to recommend using windows messaging instead of signals for some scenarios).. I am not sure how easy it would be to abstract this away by providing a sig

Re: [HACKERS] Groups and roles

2003-06-18 Thread Peter Eisentraut
Tom Lane writes: > Hm. That seems to be another reason to unify usesysid and grosysid into > a single unique something-id. Which probably implies unifying pg_shadow > and pg_group into one table. Maybe this is too radical, but why not merge "user" and "group" into one animal? Both exist to bea

Re: [HACKERS] Groups and roles

2003-06-18 Thread Peter Eisentraut
Oleg Bartunov writes: > Just interesting if we could inplement some kind of RBAC > (role based access control). Here is the reference: > http://csrc.nist.gov/rbac/ Apparently the authors of the SQL standard have read this document, because the role system in SQL looks exactly like what this docum

Re: [HACKERS] information Windows - PostgreSQL

2003-06-18 Thread Bruce Momjian
Merlin Moncure wrote: > Bruce, > > I assume then that the MinGW environment is missing signal emulation > that is present in the Microsoft C runtime distribution? Microsoft's is > copyrighted, of course in winsig.c (it is actually quite small, just a > couple hundred lines of code). Are you prop

Re: [HACKERS] src/bin/scripts seems a bit of a misnomer now

2003-06-18 Thread Rod Taylor
On Wed, 2003-06-18 at 17:07, Bruce Momjian wrote: > Tom Lane wrote: > > With Peter's latest commit, there aren't any actual scripts left in > > src/bin/scripts; only C programs. Does that bother anyone? I was > > wondering about renaming to something like src/bin/misc. (Not that > > that name se

Re: [HACKERS] information Windows - PostgreSQL

2003-06-18 Thread Merlin Moncure
Bruce, I assume then that the MinGW environment is missing signal emulation that is present in the Microsoft C runtime distribution? Microsoft's is copyrighted, of course in winsig.c (it is actually quite small, just a couple hundred lines of code). Are you proposing to rewrite that part of the

Re: [HACKERS] src/bin/scripts seems a bit of a misnomer now

2003-06-18 Thread Bruce Momjian
Tom Lane wrote: > With Peter's latest commit, there aren't any actual scripts left in > src/bin/scripts; only C programs. Does that bother anyone? I was > wondering about renaming to something like src/bin/misc. (Not that > that name seems very compelling either...) We could call it tools or a

[HACKERS] src/bin/scripts seems a bit of a misnomer now

2003-06-18 Thread Tom Lane
With Peter's latest commit, there aren't any actual scripts left in src/bin/scripts; only C programs. Does that bother anyone? I was wondering about renaming to something like src/bin/misc. (Not that that name seems very compelling either...) regards, tom lane -

Re: [HACKERS] information Windows - PostgreSQL

2003-06-18 Thread Bruce Momjian
Peer Directs relied on Visual C C++ code to handle it, and it didn't look pretty. I am not sure how hard it is going to be to get that working properly. --- Merlin Moncure wrote: > Outside of some quirky behavior like int/0

Re: [HACKERS] pg_get_triggerdef in pg_dump

2003-06-18 Thread Tom Lane
Andreas Pflug <[EMAIL PROTECTED]> writes: > There might be other cases of legal direct change of system catalog > entries, e,g. varchar to text, if they all are only names for internally > identical data structures. Can you tell which datatypes may be legally > interchanged? Right offhand I thi

Re: [HACKERS] Fields float4 don't return any row when selecting a

2003-06-18 Thread Francisco Figueiredo Jr.
Bruno Wolff III wrote: On Tue, Jun 17, 2003 at 23:26:07 -0300, "Francisco Figueiredo Jr." <[EMAIL PROTECTED]> wrote: Hi all, I'm using the 7.4 cvs version on cygwin and I noticed that if I have a table with a field of float4 type and try to do a simple select: select * from table where field_fl

Re: [HACKERS] pg_get_triggerdef in pg_dump

2003-06-18 Thread Rod Taylor
> There might be other cases of legal direct change of system catalog > entries, e,g. varchar to text, if they all are only names for internally > identical data structures. Can you tell which datatypes may be legally > interchanged? If pg_cast.castfunc is 0, you should might be able to do a da

Re: [HACKERS] information Windows - PostgreSQL

2003-06-18 Thread Merlin Moncure
Outside of some quirky behavior like int/0 handling, what is wrong with the peerdirect's signal handler so that it has to be redone? Win32 has signal handling, just not as robust and complete as *nix. Regards, Merlin -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent:

Re: [HACKERS] pg_get_triggerdef in pg_dump

2003-06-18 Thread Andreas Pflug
Alvaro Herrera wrote: On Wed, Jun 18, 2003 at 12:59:36PM +0200, Andreas Pflug wrote: What I need again and again, is changing the size of a column (rarely the type). For pgsql, I'd have to drop the column, and need to recreate all views. For MSSQL, it won't matter if the column is dropped/re

Re: [HACKERS] lots of configure failures on freebsd/alpha

2003-06-18 Thread Rod Taylor
On Wed, 2003-06-18 at 04:29, Tom Lane wrote: > "Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > > configure: WARNING: sys/select.h: present but cannot be compiled > > configure: WARNING: sys/select.h: check for missing prerequisite headers? > > [many similar] > > <> do these headers assume

Re: [HACKERS] pg_get_triggerdef in pg_dump

2003-06-18 Thread Alvaro Herrera
On Wed, Jun 18, 2003 at 12:59:36PM +0200, Andreas Pflug wrote: > What I need again and again, is changing the size of a column (rarely > the type). For pgsql, I'd have to drop the column, and need to recreate > all views. For MSSQL, it won't matter if the column is dropped/recreated > or just r

Re: [HACKERS] O_DIRECT in freebsd

2003-06-18 Thread Bruce Momjian
Also, keep in mind writes to O_DIRECT devices have to wait for the data to get on the platters rather than into the kernel cache. --- Tom Lane wrote: > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > >> DB2 and Oracle, from mem

Re: [HACKERS] information Windows - PostgreSQL

2003-06-18 Thread Bruce Momjian
Not sure. We are petty deep in the backend code allowing CreateProcess and then we need to add signal handling. We don't have anything running yet. --- P.M wrote: > Hi, > > I would like to participate to PostgreSQL under

Re: [HACKERS] O_DIRECT in freebsd

2003-06-18 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: >> DB2 and Oracle, from memory, allow users to pass hints to the planner to >> use/not use file system caching. > Might it make sense to do this for on-disk sorts, since sort_mem is > essentially being used as a disk cache (at least for reads)? If sort_

Re: [HACKERS] pg_get_triggerdef in pg_dump

2003-06-18 Thread Andreas Pflug
Hi Christopher, Sorry if I offended you. I wasn't offended because I wasn't sure what you wanted to say to me. You may call me the biggest fool of all, as long you do it in Sualheli, or Korean... :-) 'You what!' is what you say when you cannot believe what someone is saying... Calling 'stabl

Re: [HACKERS] Extending PostgreSQL in C or C++

2003-06-18 Thread Christof Petig
Tom Lane wrote: Sebastien Lemieux <[EMAIL PROTECTED]> writes: Then I get: ERROR: Can't find function add_one in file /[PathToTheObject]/pgsql_bio.so Hmm. I can't see anything wrong with what you did, either. It's possible that the dynamic linker has printed additional messages to the backend'

Re: [HACKERS] pg_get_triggerdef in pg_dump

2003-06-18 Thread Christopher Kings-Lynne
Hi Andreas, > I'm not natively english speaking, and so I don't understand what you > want to say with this. Maybe this is some kind of Australian slang? Do > you agree or disagree? I'm trying to explain my concerns and proposals, > and it would be kind if I'm answered seriously and understandably

Re: [HACKERS] pg_get_triggerdef in pg_dump

2003-06-18 Thread Andreas Pflug
Christopher Kings-Lynne wrote: this arguments are quite academic. You what! On one side, this could be restricted, thats what pg_depends is good for (this already happens for inherited tables). On the other side, how often do you rename columns or tables? You what! On mssql, n

Re: [HACKERS] sa_family_t in cygwin compile of cvs

2003-06-18 Thread deststar
Sorry didn't see it (& still can't in my inbox - where was it sent?) Mine was a hack based on reading that sa_family_t should be 16 bits (in RFC 2553 IIRC) to solve a cygwin specific problem. If you have a general solution then that is much better than mine thank you, - Stuart Bruce Momjian wrote