Dear hackers,
Please find attached a preliminary patch to fix schema ownership on first
connection. It is for comments and advices as I still have doubts about
various how-and-where issues, thus it is not submitted to the patch list.
(1) It adds a new datisinit attribute to pg_database, which
Dear Peter,
The functionality of the ACL system is to answer questions like does
user X have privilege Y on object Z.
ONE OF the functionality, and THE functionality from the backend point
of view.
As I'm developing slowly a pg_advisor schema to check for various
consistency issues. For
CREATE UNIQUE INDEX activation_code_code_key ON
public.activation_code
USING btree (code, id_code_pool);
or
ALTER TABLE activation_code ADD UNIQUE ( code, id_code_pool );
with \d command there is no difference but is different because the
first command
create an index deleteable with a drop
Hi all,
about you is it ok for you if I write the email built in type ?
I know of course that I can do it with a DOMAIN.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 6: Have you searched our list archives?
Christopher Kings-Lynne wrote:
CREATE UNIQUE INDEX activation_code_code_key ON
public.activation_code
USING btree (code, id_code_pool);
or
ALTER TABLE activation_code ADD UNIQUE ( code, id_code_pool );
with \d command there is no difference but is different because the
first command
create
Gaetano Mendola [EMAIL PROTECTED] writes:
about you is it ok for you if I write the email built in type ?
You're going to have to explain why it has to be a built-in type.
Can't you do what you want as a local add-on? Is it likely that
the functionality you have in mind would be exactly what
I've been having an off-list discussion with Neil Conway about the
handling of lists in the backend's nodeToString and stringToNode
routines (outfuncs.c and readfuncs.c). Currently, the same string
representation
(1 2 3 4)
is used for a List of integer-flavor Value nodes, a List
Tom Lane wrote:
Gaetano Mendola [EMAIL PROTECTED] writes:
about you is it ok for you if I write the email built in type ?
You're going to have to explain why it has to be a built-in type.
Can't you do what you want as a local add-on? Is it likely that
the functionality you have in mind would
Hi,
Is there any reason I shouldn't submit a patch that makes it so that we
have comments on 100% of the catalog objects? I don't see any reason
why we shouldn't do it...
Chris
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
Gaetano Mendola [EMAIL PROTECTED] writes:
Tom Lane wrote:
Can't you do what you want as a local add-on?
I guess that for manage efficiently million of email addresses I need
to have a built in type instead of a domain with a regex as validator,
You probably ought to do some measurements
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Is there any reason I shouldn't submit a patch that makes it so that we
have comments on 100% of the catalog objects?
Bulk? Redundancy with the SGML documentation?
There are already more than enough places to have to edit documentation
when
Christopher Kings-Lynne wrote:
Is there any reason I shouldn't submit a patch that makes it so that
we have comments on 100% of the catalog objects?
The ability to comment on all types of catalog objects or actual
comments on all predefined catalog objects? Both are more or less
reasonable.
Tom Lane wrote:
Gaetano Mendola [EMAIL PROTECTED] writes:
Tom Lane wrote:
Can't you do what you want as a local add-on?
I guess that for manage efficiently million of email addresses I need
to have a built in type instead of a domain with a regex as validator,
You probably ought to do some
Win32 is going to need relocatable installs, and Unix packagers have
asked for this too.
A relocatable install is one where you can do 'gmake install', tar up
the directory where you installed it, then untar it on to another
machine with the same operating system, but into a different directory
--On Samstag, Mai 08, 2004 14:14:10 +0200 Gaetano Mendola
[EMAIL PROTECTED] wrote:
Hi all,
about you is it ok for you if I write the email built in type ?
I know of course that I can do it with a DOMAIN.
Regards
Gaetano Mendola
Funny, I had the idea some time ago, too. The problem was that I
if you want to put 1000 columns into one table, your data structure
needs some further investigation. you are trying to solve the wrong problem.
Regards,
Hans
Dilip Angal wrote:
Hi
I have a situation that I need flexible number columns to model the
business requirements. It could go up
Bruce Momjian [EMAIL PROTECTED] writes:
My idea is to write a /port function that uses various methods to find
the needed files. We could look in the relative location first, and if
the needed file is not found, look in the hardcoded directory.
I think a search until you find something
On Sat, 7 Feb 2004, [ISO-8859-1] Hans-J?rgen Sch?nig wrote:
if you want to put 1000 columns into one table, your data structure
needs some further investigation. you are trying to solve the wrong problem.
Dilip,
you may try our contrib/hstore from http://www.sai.msu.su/~megera/postgres/gist/
On Sat, 8 May 2004, Bruce Momjian wrote:
Win32 is going to need relocatable installs, and Unix packagers have
asked for this too.
A relocatable install is one where you can do 'gmake install', tar up
the directory where you installed it, then untar it on to another
machine with the same
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
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
Marc G. Fournier wrote:
However, right now, if you try to move /usr/local/pgsql to /var/pgsql,
the database will not work because there are hard-coded directory
dependencies in the binaries:
initdb has to find its *.bki files in /share
initdb has to find the postgres binary in
elein wrote:
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.
What does the MERGE command do? I have never heard of it, so
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
My idea is to write a /port function that uses various methods to find
the needed files. We could look in the relative location first, and if
the needed file is not found, look in the hardcoded directory.
I think a search until you
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
My idea is to write a /port function that uses various methods to find
the needed files. We could look in the relative location first, and if
the needed file is not found, look in the hardcoded directory.
I think a search until you
Bruce Momjian [EMAIL PROTECTED] writes:
Marc G. Fournier wrote:
Is there a reason why we can't use a PGSQL_PREFIX ENV variable or
something like that? If not defined, use compiled in default?
Win32 isn't going to be able to define that.
And this idea is even worse than the other one as far
Andrew Dunstan wrote:
I think we should use the relative-path method *unless* the configure
command called out specific installation directories (that is, not
just --prefix but --datadir and/or related options). If you use one of
those then that absolute path should be used always, ie, you
Andrew Dunstan [EMAIL PROTECTED] writes:
Tom Lane wrote:
I think we should use the relative-path method *unless* the configure
command called out specific installation directories (that is, not
just --prefix but --datadir and/or related options).
I think we could adopt a simple rule: if you
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Ah, got it. Makes sense. We do searches for finding our own path, but
you can argue that this predictable --- we know we are running so the
binary must be somewhere. :-) However, the version checking we do now
is a little
Bruce Momjian [EMAIL PROTECTED] writes:
Ah, got it. Makes sense. We do searches for finding our own path, but
you can argue that this predictable --- we know we are running so the
binary must be somewhere. :-) However, the version checking we do now
is a little non-predictable because if
What does the MERGE command do? I have never heard of it, so I doubt
someone is working on it.
It is basically the SQL standard version of MySQL's REPLACE syntax. It
does an update-else-insert set. However, the trick is that it uses some
sort of next key locking to ensure that it cannot fail.
The ability to comment on all types of catalog objects or actual
comments on all predefined catalog objects? Both are more or less
reasonable. But I think we should have some sort of
internationalization mechanism for the actual comments.
One of my first commits for 7.5 was the format, I
On Sun, May 09, 2004 at 09:50:00AM +0800, Christopher Kings-Lynne wrote:
What does the MERGE command do? I have never heard of it, so I doubt
someone is working on it.
It is basically the SQL standard version of MySQL's REPLACE syntax. It
does an update-else-insert set. However, the
I intend to release locks on subtransaction abort, so if the update
fails there's room for another transaction to insert the key (which I
understand should fail?). I guess there's a different locking mechanism
needed; I believe nested transactions will not be enough.
Except you can keep trying
Shachar Shemesh wrote:
Bruce Momjian wrote:
Comments?
What's wrong with the way it's done by everybody else?
Have hardcoded paths (determined at configure time), and allow override
using a config file. Have a command line option for saying where the
config file should be.
Where
Bruce Momjian wrote:
Comments?
What's wrong with the way it's done by everybody else?
Have hardcoded paths (determined at configure time), and allow override
using a config file. Have a command line option for saying where the
config file should be.
For Windows, replace config file with
Bruce Momjian wrote:
Shachar Shemesh wrote:
Bruce Momjian wrote:
Comments?
What's wrong with the way it's done by everybody else?
Have hardcoded paths (determined at configure time), and allow override
using a config file. Have a command line option for saying where the
config
On Sun, 9 May 2004, Bruce Momjian wrote:
Shachar Shemesh wrote:
Bruce Momjian wrote:
Comments?
What's wrong with the way it's done by everybody else?
Have hardcoded paths (determined at configure time), and allow override
using a config file. Have a command line option for
On Sun, May 09, 2004 at 12:13:31PM +0800, Christopher Kings-Lynne wrote:
I intend to release locks on subtransaction abort, so if the update
fails there's room for another transaction to insert the key (which I
understand should fail?). I guess there's a different locking mechanism
needed; I
39 matches
Mail list logo