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
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,
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.
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's
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
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_mem were
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
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 memory,
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
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]
bare ass guess do these headers assume
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
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]
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
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
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
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
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
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
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 seems very
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 proposing
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
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 bear
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
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 character
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
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
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 be
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. Once
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
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 think
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
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 (n16) + m + 4 or maybe
(m16) + n + 4, don't remember right now.
Be sure to check that your data is in a
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 catalog
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
---(end of
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
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
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
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 signals. If
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 for
I took a quick glance at this.
It boils down to essentially an:
1) ALTER TABLE .. ADD COLUMN column DEFAULT default constraints
2) UPDATE .. SET column = default IF default IS NOT NULL;
3) Add constraints including NOT NULL, CHECK, Foreign Key, etc. each
of which will do it's own confirmation
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 solved in
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
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?
Yes, you can
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
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 added
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
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 regards to
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 I get
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
49 matches
Mail list logo