On Thu, Jun 12, 2003 at 06:23:12PM -0400, Tom Lane wrote:
Jim C. Nasby [EMAIL PROTECTED] writes:
Is there any ALTER that would require blocking selects?
DROP INDEX, for certain.
Sure, but that's usually trivially fast.
Even stuff like
drop and rename should be protected by versioning,
On Mon, Jun 16, 2003 at 01:17:38 -0500,
Jim C. Nasby [EMAIL PROTECTED] wrote:
Yeah, so the catalog changes shouldn't be visible to anyone until after
the ALTER is complete, right? Even if a transaction is set to read
uncommitted, I assume it will always read only committed data from the
Christopher Kings-Lynne wrote:
1. Do we want to someday allow groups to have groups as members? (Seems
reasonable to me.)
I agree.
I think the other requirement of roles is that they are able to own objects.
ie. we need to allow groups to own objects.
This would also solve the
Dennis Björklund writes:
Why do we have SQL_ASCII?
It gives a simple default behavior for people who don't want to deal with
character set issues.
I could understand it if we only could store 7-bit strings there. But
SQL_ASCII lets you store 8-bit values. Should I understand SQL_ASCII
Dennis Björklund writes:
However, if you want to produce a utf-8 file, how should that work with
respect to gettext()? If the message catalog is in latin1 then we need to
know that and convert that into utf-8.
I don't think all gettext implementations support automatic character set
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
MySQL made up ENUMs out of whole cloth...they
should copy our way, not us theirs...
ENUMs do seem to have some advantages in convenience though. And
providing them or something closely comparable would ease porting
from MySQL ... which is an
Jim C. Nasby [EMAIL PROTECTED] writes:
On Thu, Jun 12, 2003 at 06:23:12PM -0400, Tom Lane wrote:
Even stuff like
drop and rename should be protected by versioning, no?
No. System-catalog changes are always READ COMMITTED mode.
Yeah, so the catalog changes shouldn't be visible to anyone
Where did getopt_long() come from and why is there no header file to go
along with it?
Larry Rosenman writes:
--On Saturday, June 07, 2003 10:42:31 -0500 Larry Rosenman [EMAIL PROTECTED]
wrote:
cc -O -g -I../../../src/interfaces/libpq -I../../../src/include
-I/usr/local/include
--On Monday, June 16, 2003 16:51:04 +0200 Peter Eisentraut
[EMAIL PROTECTED] wrote:
Where did getopt_long() come from and why is there no header file to go
along with it?
I haven't had a chance to find this, I'll try tonight. You are welcom to
use
your peter_e account on lerami.lerctr.org if
Peter Eisentraut [EMAIL PROTECTED] writes:
In the old protocol there used to be support for more then one error
arriving, in which case they were concatenated. What is happening with
that?
That still works with respect to libpq's internally-generated errors,
which is as far as I know the only
Greetings Hackers-
I have an interest in developing better OO support in PostgreSQL, and have
done some preliminary research in the archives and TODO list. It appears
that this topic hasn't gotten much traffic in a while, so I thought I'd test
the waters. What do the gurus here think of
On Thu, Jun 12, 2003 at 10:10:02PM -0400, Bruce Momjian wrote:
Tom Lane wrote:
It is bad to hang the system, but if it reports swap failure, at least
the admin knows why it failed, rather than killing random processes.
I wonder if it might be better to suspend whatever process is trying to
On Fri, Jun 13, 2003 at 12:41:28PM -0400, Bruce Momjian wrote:
Of course, if you exceed swap, your system hangs.
Are you sure? I ran out of swap once or came damn close, due to a cron
job gone amuck. My clue was starting to see lots of memory allocation
errors. After I fixed what was blocking
We have a similar question about upcoming Windows native release:
Is it going to be multithreaded or one process per connection like on
cygwin?
-Original Message-
From: P.M [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 11:10 PM
To: PostGreSQL mailing list
Subject: [HACKERS]
Yurgis Baykshtis wrote:
We have a similar question about upcoming Windows native release:
Is it going to be multithreaded or one process per connection like on
cygwin?
One connection per process. The only multithreaded Win32 is SRA's
commercial product.
--
Bruce Momjian
I get the errors below when compiling on a RH 6.1 system.
I used the following config paramters:
./configure --prefix=/usr/local/pgsql --enable-integer-datetimes --with-pgport=5433
hba.c: In function `parse_hba':
hba.c:590: structure has no member named `ss_family'
hba.c:659: structure has no
On Friday 13 June 2003 17:28, Roland Glenn McIntosh wrote:
This is my solution / bug report / RFC cross-posted from [GENERAL]
regarding insertion of hexadecimal characters from the command line.
---
Okay. I have NO IDEA why this works. If someone could
Greetings Hackers-
I have an interest in developing better OO support in PostgreSQL, and have
done some preliminary research in the archives and TODO list. It appears
that this topic hasn't gotten much traffic in a while, so I thought I'd test
the waters. What do the gurus here think of
Currently I am able to do ...
SELECT dblink_oraconnect('scott/[EMAIL PROTECTED]');
SELECT * FROM dblink_ora('SELECT ename, sal FROM emp')
AS (ename text, sal text);
The problem is: If I wanted to do a
SELECT * FROM dblink_ora('SELECT * FROM emp');
It won't work because dblink_ora
Seems multi-table indexes are the only solution for various inheritance
problems, and I seem to remember even a non-inheritance case that could
use it, but I can't remember what it was.
---
Benjamin Minshall wrote:
On Sun, Jun 15, 2003 at 04:54:21PM +0100, deststar wrote:
On cygwin sa_family_t was undeclared, adding the following line:
typedef unsigned short sa_family_t;
to both:
src/port/getaddrinfo.c
src/include/libpq/pqcomm.h
Isn't the attached or fixing Cygwin itself a better approach?
seemed to
Tatsuo,
recently I tried to understand why I can't get sorting works properly
with cyrillic characters in UTF8 datbase. I figure out the
reason of my confusion - I thought I could specify different encodings
for different databases and these encodings will be used in text operations
(sort,
Tom Lane writes:
ENUMs do seem to have some advantages in convenience though. And
providing them or something closely comparable would ease porting
from MySQL ... which is an important consideration in our plan for
world domination ;-)
Now that domains have check constraints, I think
It seems that there are still a few problems with the resolution of
functions that have domains as arguments.
Take these two domains:
create domain testdomain1 as int;
create domain testdomain2 as int;
Take these two functions:
create function foofunc(testdomain1) returns int as 'select 1'
Larry Rosenman writes:
Where did getopt_long() come from and why is there no header file to go
along with it?
I haven't had a chance to find this, I'll try tonight. You are welcom to
use
your peter_e account on lerami.lerctr.org if you'd like.
I'm more interested to know how you got
I just did an upgrade of Unixware to 7.1.3 up1 with the upgrade pack, to
the best of
my knowledge.
I need to look further at it.
--On Monday, June 16, 2003 21:00:44 +0200 Peter Eisentraut
[EMAIL PROTECTED] wrote:
Larry Rosenman writes:
Where did getopt_long() come from and why is there no
On Mon, Jun 16, 2003 at 11:47:58 -0500,
Bruno Wolff III [EMAIL PROTECTED] wrote:
I get the errors below when compiling on a RH 6.1 system.
I used the following config paramters:
./configure --prefix=/usr/local/pgsql --enable-integer-datetimes --with-pgport=5433
hba.c: In function
Don't break BeOS support.
A new version of BeOS will be released very soon.
http://www.yellowtab.com
http://www.yellowtab.com/board/
http://www.yellowtab.com/support/
Regards,
Yves
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Palle Girgensohn [EMAIL PROTECTED]
Cc: [EMAIL
I am working on this now. The missing typedef for sa_family_t is really
just used for structure alignment, so I am working on a fix to define a
char array and #define to be the same length as the native ss_family,
because on my system sa_family_t is:
sys/sockettypes.h:11:typedef u_char
Peter Eisentraut [EMAIL PROTECTED] writes:
The SQL standard does not allow functions to have domains as arguments.
Semantically, they have a point.
I don't think they do. Declaring a domain as the input type seems a
very natural way of asserting that the function only works over a subset
of
Bruce, thank you for the information.
May I ask you one more question?
Will it be feasible to run the native Windows version of Postgres
in-process (that is in client's process)?
Thanks.
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: Monday, June 16, 2003 9:37
No, it will not run in the client process, and probably never will.
---
Yurgis Baykshtis wrote:
Bruce, thank you for the information.
May I ask you one more question?
Will it be feasible to run the native Windows
On Mon, Jun 16, 2003 at 03:36:55PM -0400, Bruce Momjian wrote:
I am working on this now. The missing typedef for sa_family_t is really
just used for structure alignment, so I am working on a fix to define a
char array and #define to be the same length as the native ss_family,
because on my
On Mon, Jun 16, 2003 at 02:23:31PM -0500, Bruno Wolff III wrote:
On Mon, Jun 16, 2003 at 11:47:58 -0500,
Bruno Wolff III [EMAIL PROTECTED] wrote:
I get the errors below when compiling on a RH 6.1 system.
I used the following config paramters:
./configure --prefix=/usr/local/pgsql
Does the following patch fix the problem? It doesn't use sa_family_t
anymore.
---
Kurt Roeckx wrote:
On Mon, Jun 16, 2003 at 02:23:31PM -0500, Bruno Wolff III wrote:
On Mon, Jun 16, 2003 at 11:47:58 -0500,
Bruno
Fernando Nasser of Red Hat pointed out to me that we are not quite
spec-compliant on the FLOAT(p) datatype notation. We interpret P as
the number of decimal digits of precision, and hence translate
P = 1..6 = float4 (a/k/a REAL)
P = 7..15 = float8 (a/k/a DOUBLE PRECISION)
Folks,
I've re-ordered postgresql.conf.sample per our discussions here.
However, the changes in postgresql.conf.sample need to be reflected in the
initdb script's generation of the LC_* variables.
Can someone help me with the requisite modification to initdb?
Thanks.
--
-Josh Berkus
Aglio
Tatsuo,
recently I tried to understand why I can't get sorting works properly
with cyrillic characters in UTF8 datbase. I figure out the
reason of my confusion - I thought I could specify different encodings
for different databases and these encodings will be used in text operations
Is there any point using pg_get_triggerdef in pg_dump to generate trigger
definitions? We'd still have to keep the old code so that we can dump pre
7.4, but it might mean we don't have to touch that code again if we add
triggers on columns or something...
Also, it doesn't format them as nicely
Tom Lane wrote:
Is it worth trying to provide some sort of backwards-compatibility mode?
We could imagine adding a GUC variable to select binary or decimal
precision, but I really don't want to. It would increase the amount of
work needed by more than an order of magnitude, and this problem
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Is there any point using pg_get_triggerdef in pg_dump to generate trigger
definitions? We'd still have to keep the old code so that we can dump pre
7.4, but it might mean we don't have to touch that code again if we add
triggers on columns or
Seems like a good idea to me --- we've been trying to reduce pg_dump's
knowledge of backend nitty-gritty, and this would be another small step
in the right direction.
Also, it doesn't format them as nicely as the current pg_dump code...
That's fixable no? I guess you might want to
On Mon, 16 Jun 2003, Oleg Bartunov wrote:
I thought I could specify different encodings
for different databases and these encodings will be used in text operations
(sort, upper,lower), not just for conversion.
En encoding does not imply any sort order. UTF-8 can be used to store
strings in
43 matches
Mail list logo