-On [20030909 00:42], Tom Lane ([EMAIL PROTECTED]) wrote:
>IIRC, Oracle does not have rollback-able DDL. That might imply that the
>reason they have MODIFY CONSTRAINT is that in Oracle you can't use the
>above way to eliminate the window. Can you put ALTERs inside
>transactions at all in Oracle?
On Wed, 2003-09-10 at 15:57, Bruce Momjian wrote:
> I assume the attached patch is what you want done to fix this. Applied.
>
> It quotes table names for vacuum and analyze, and uppercases the
> keywords for clarity.
Yeah, this is basically what I meant, sorry I didn't get to it quicker.
Howev
Andreas Pflug <[EMAIL PROTECTED]> writes:
> Bruce Momjian wrote:
>> I assume we never came to a final conclusion on how to do CREATE
>> FUNCTION without double-quoting.
> Many discussions, but no final conclusion in sight, it seems. That
> \beginliteral stuff is psql centric, where a sql syntax s
Jon Jensen <[EMAIL PROTECTED]> writes:
> On Wed, 10 Sep 2003, Alvaro Herrera wrote:
>
> > On Wed, Sep 10, 2003 at 10:35:18PM +0200, Andreas Pflug wrote:
> >
> > > I never agreed that a client solution would be satisfying. While
> > > frontends might try to hide some uglyness of the syntax to th
Bruno wrote:
> ...An interval has two parts... the number of months...and...the number of
> seconds...if both parts are nonzero it makes a difference in which part
> gets added first. For example '2003-02-28'::date + '1 month 1 day'::interval
> might be either 2003-03-29 or 2003-04-01. In 7.4 it
On Wed, 10 Sep 2003 02:39 pm, Tom Lane wrote:
> A thread-safe implementation of
> libpq is of zero value to an application unless it also has thread-safe
> implementations of the other libraries it depends on.
Not necessarily so - we've managed okay so far (several years) working on
platforms t
On Wed, Sep 10, 2003 at 15:43:56 -0700,
Ron Mayer <[EMAIL PROTECTED]> wrote:
> Bruno wrote:
> >
> > Can you document which part of a mixed interval (with both months and
> > seconds parts) gets added first to a timestamp? I haven't ever run
> > across anything which says which gets done first.
>
Andreas Pflug wrote:
I never agreed that a client solution would be satisfying. While
frontends might try to hide some uglyness of the syntax to the user
for single functions, editing large scripts with many functions is
still suffering from "massive quotes".
Yes, I agree that a psql-specifi
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Thu, Sep 11, 2003 at 01:05:47AM +0200, Andreas Pflug wrote:
>
> > A whole script containing any number of valid statements must be
> > executable without interpreting the script.
How is that relevant? It's still parseable with parameter placeholde
On Thu, Sep 11, 2003 at 01:05:47AM +0200, Andreas Pflug wrote:
> Greg Stark wrote:
>
> >Could the function bodies be shipped over using the new FE protocol as
> >parameters? That would eliminate the quoting and simplify matters for DBI
> >and other drivers as well.
> Oh no, not this discussion a
Greg Stark wrote:
Could the function bodies be shipped over using the new FE protocol as
parameters? That would eliminate the quoting and simplify matters for DBI and
other drivers as well.
Oh no, not this discussion again.
A whole script containing any number of valid statements must be
execu
Bruno wrote:
>
> Can you document which part of a mixed interval (with both months and
> seconds parts) gets added first to a timestamp? I haven't ever run
> across anything which says which gets done first.
>
In the existing code, the sql spec, or the proposed implementation?
In the existing c
Jon Jensen <[EMAIL PROTECTED]> writes:
> On Wed, 10 Sep 2003, Alvaro Herrera wrote:
>
> > On Wed, Sep 10, 2003 at 10:35:18PM +0200, Andreas Pflug wrote:
> >
> > > I never agreed that a client solution would be satisfying. While
> > > frontends might try to hide some uglyness of the syntax to th
Jeroen Ruigrok/asmodai wrote:
> -On [20030905 20:52], Tom Lane ([EMAIL PROTECTED]) wrote:
> >Alternatively, find out what symbols your compiler predeclares.
> >If my theory is right then your pg_config_os.h file is failing to
> >define HAS_TEST_AND_SET; why?
>
> Indeed, pg_config_os.h does not set
The problem with checking ownership of objects before dropping users is
that there's no way to check what objects depend on a user on another
database. But what if this information is stored in a shared relation?
Like pg_depend but only for shared objects.
--
Alvaro Herrera ()
"Someone said that
On Wed, 10 Sep 2003, Alvaro Herrera wrote:
> On Wed, Sep 10, 2003 at 10:35:18PM +0200, Andreas Pflug wrote:
>
> > I never agreed that a client solution would be satisfying. While
> > frontends might try to hide some uglyness of the syntax to the user for
> > single functions, editing large scri
Alvaro Herrera wrote:
On Wed, Sep 10, 2003 at 10:35:18PM +0200, Andreas Pflug wrote:
I never agreed that a client solution would be satisfying. While
frontends might try to hide some uglyness of the syntax to the user for
single functions, editing large scripts with many functions is still
On Wed, Sep 10, 2003 at 10:35:18PM +0200, Andreas Pflug wrote:
> I never agreed that a client solution would be satisfying. While
> frontends might try to hide some uglyness of the syntax to the user for
> single functions, editing large scripts with many functions is still
> suffering from "ma
- Original Message -
From: "Peter Eisentraut" <[EMAIL PROTECTED]>
To: "Darko Prenosil" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, September 10, 2003 7:20 PM
Subject: Re: [HACKERS] Trouble with error message encoding
> Darko Prenosil writes:
>
> > I have encoding problem
On Wed, 2003-09-10 at 20:22, "bognár, attila" wrote:
> Would it be possible to set the maximum number of connections to each
> database individually? I need this because the server will be shared
> between several users and I want to avoid that that somebody uses the
> maximum number of connect
Andrew Dunstan wrote:
Alvaro Herrera wrote:
On Wed, Sep 10, 2003 at 07:04:13PM +0200, Andreas Pflug wrote:
Bruce Momjian wrote:
I assume we never came to a final conclusion on how to do CREATE
FUNCTION without double-quoting.
Many discussions, but no final conclusion in sight, it
Peter Eisentraut wrote:
> Tom Lane writes:
>
> > If we follow Peter's recently proposed guideline, this would have to be
> > a NOTICE not a WARNING, because the command absolutely is doing what you
> > told it to do. Peter, does that make you uncomfortable?
>
> The message itself makes me a bit
On Wed, Sep 10, 2003 at 11:48:58 -0700,
Ron Mayer <[EMAIL PROTECTED]> wrote:
>
> Looks like I'll take a shot at more broadly hacking the postgresql
> time interval code. Before doing so, I wanted to ask opinions
> regarding what the "right" behavior is of various timestamp/interval
> operation
I assume the attached patch is what you want done to fix this. Applied.
It quotes table names for vacuum and analyze, and uppercases the
keywords for clarity.
---
Matthew T. O'Connor wrote:
> Ouch... sorry, my fault. I'll
I can confirm that this bug still exists in current CVS. The problem is
that "CREATE SCHEMA AUTHORIZATION test" is translated into "SET SESSION
AUTHORIZATION 'test'; CREATE SCHEMA test;".
While this does allow the schema to be owned by 'test', it assumes
'test' has permissions to create the sch
Nico King writes:
> I've notice when trying to uninstall by using the
> command
> "gmake uninstall", I still could access my database,
It only removes the files, it does not stop the server.
> and also all my directories of postgresql and bin
> files are still there!
It only removes files, not
Dear List,
I already asked my question on the admin list, but got no answer. As I
even could not find any related information anywhere, I think my
question is a wish:
Would it be possible to set the maximum number of connections to each
database individually? I need this because the server wil
On third though ignore this whole thread. I can't read.
sigh.
--
greg
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Tom wrote:
> At this point it should move to pghackers, I think.
(responding to a patch for ISO 8601 "Time Intervals" in pgsql-patches)
Looks like I'll take a shot at more broadly hacking the postgresql
time interval code. Before doing so, I wanted to ask opinions
regarding what the "right" beh
I've notice when trying to uninstall by using the
command
"gmake uninstall", I still could access my database,
and also all my directories of postgresql and bin
files are still there!
I am not sure if I should first drop my database, but
even when I did this all my postgres directoires
remain there
On second thought, it does cause a problem:
db=> create table aa (aa integer[]);
CREATE TABLE
db=> select distinct(array_length(aa)) from aa;
ERROR: function array_upper(integer[]) does not exist
HINT: No function matches the given name and argument types. You may need to add
explicit typecas
I'm not sure if this should be considered a bug or not. At least in my case it
doesn't cause a problem. I think it could always be worked around with
explicit casts in any case, it just seems... wrong:
db=> create or replace function array_length(integer[]) returns integer
as 'SELECT array_up
> >On Wed, Sep 10, 2003 at 07:04:13PM +0200, Andreas Pflug wrote:
> >
> >>>I assume we never came to a final conclusion on how to do CREATE
> >>>FUNCTION without double-quoting.
> >
> >>Many discussions, but no final conclusion in sight, it seems. That
> >>\beginliteral stuff is psql centric, wher
On Wed, Sep 10, 2003 at 12:49:31 -0400,
Tom Lane <[EMAIL PROTECTED]> wrote:
>
> The question is whether any of this is worth worrying about in PG.
> ISTM the correct solution to such a risk is to tighten your kernel's
> packet filtering, not harden one piece of one application.
On linux at leas
I wrote:
> I found a few notices and warnings that inform you that the command you
> are executing has no effect because the object is already in the state you
> want it. I think these are useless, and there is also some inconsistency.
> Does someone want to defend keeping them?
I take it that p
Philip Yarra <[EMAIL PROTECTED]> writes:
> On Wed, 10 Sep 2003 02:15 pm, Bruce Momjian wrote:
>
> This would be a pretty short list unless I count wrong! This excludes all
> releases of FreeBSD (and I'm willing to bet other BSDs), Solaris (at least
> the old version I have), OSF, Linux, and who
Alvaro Herrera wrote:
On Wed, Sep 10, 2003 at 07:04:13PM +0200, Andreas Pflug wrote:
Bruce Momjian wrote:
I assume we never came to a final conclusion on how to do CREATE
FUNCTION without double-quoting.
Many discussions, but no final conclusion in sight, it seems. That
\beginl
Darko Prenosil writes:
> I have encoding problems using translated error messages (7.4beta1).
> When database encoding is set to SQL_ASCII, all mesages arrive to client
> correctly respecting the CLIENT_ENCODING, but if I create database WITH
> ENCODING='unicode' or WITH ENCODING='latin2', m
On Wed, Sep 10, 2003 at 07:04:13PM +0200, Andreas Pflug wrote:
> Bruce Momjian wrote:
>
> >I assume we never came to a final conclusion on how to do CREATE
> >FUNCTION without double-quoting.
> Many discussions, but no final conclusion in sight, it seems. That
> \beginliteral stuff is psql centr
Bruce Momjian wrote:
I assume we never came to a final conclusion on how to do CREATE
FUNCTION without double-quoting.
---
Many discussions, but no final conclusion in sight, it seems. That
\beginliteral stuff is psql centri
Marc G. Fournier wrote:
>
> On Wed, 10 Sep 2003, Bruce Momjian wrote:
>
> > Because MinGW/Msys doesn't come with flex/bison by default, I have added
> > those derived files to the WIN32_DEV branch in CVS. It makes it easier
> > for people to install _just_ MinGW and compile PostgreSQL on Win32.
> > From our previous discussion of 2-phase commit, there was concern that
> > the failure modes of 2-phase commit were not solvable. However, I think
> > multi-master replication is going to have similar non-solvable failure
> > modes, yet people still want multi-master replication.
>
> No. Th
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Wed, Sep 10, 2003 at 07:27:02AM -0400, Andrew Dunstan wrote:
>> If someone can spoof the packet address isn't there also a possibility
>> that they can read your packets and see your random signature?
> Spoofing the packet source address is not quite
On Wed, 10 Sep 2003, Bruce Momjian wrote:
> Because MinGW/Msys doesn't come with flex/bison by default, I have added
> those derived files to the WIN32_DEV branch in CVS. It makes it easier
> for people to install _just_ MinGW and compile PostgreSQL on Win32. The
> branch will live for only 1-2
Hi,
I just checked out the current CVS-version and everything is fine now on my
SuSE 8.2-box.
I set tcpip_socket in postgresql.conf to true and was able to connect to
localhost and 127.0.0.1. I added my local IPv4-netaddress to pg_hba.conf and
was able to connect to my networkadress.
Thank yo
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Are all the IPv6 issues resolved in current CVS?
>
> AFAIK, yes ... but I don't run IPv6 here, so I might not be the best
> authority on the subject ...
Completed unless more problem reports arrive --- that's great.
--
Bruce Momj
Because MinGW/Msys doesn't come with flex/bison by default, I have added
those derived files to the WIN32_DEV branch in CVS. It makes it easier
for people to install _just_ MinGW and compile PostgreSQL on Win32. The
branch will live for only 1-2 months until we start 7.5 development.
Those files
I said:
> This doesn't seem to quite square
> with your explanation though --- surely the number should go to 8000 and
> change? The man page for top says these numbers are in kilobytes ...
> but if they were really measured in, say, 4K pages, then we'd be talking
> about 26M of shared memory touc
Jan Wieck wrote:
> > For IPv6 you could do it with a memcmp on the sin6_addr part, and
> > put it inside an #ifdef HAVE_IPV6.
> >
> > If you want to write code to compare 2 addresses, please make it
> > a general function and place it in ip.c.
> >
> > Anyway, I'm happy with the current use of rec
Manfred Koizar <[EMAIL PROTECTED]> writes:
> On Wed, 10 Sep 2003 00:18:52 -0400, Tom Lane <[EMAIL PROTECTED]>
> wrote:
>> I have a suspicion that there is no real leak, but
>> rather we are seeing some artifact of the way Linux' top(1) reports
>> memory usage.
> From my experience I can confirm th
On Wed, Sep 10, 2003 at 07:27:02AM -0400, Andrew Dunstan wrote:
> If someone can spoof the packet address isn't there also a possibility
> that they can read your packets and see your random signature?
Spoofing the packet source address is not quite the same as sniffing a
connection, which should
On Tue, Sep 09, 2003 at 08:38:41PM -0400, Bruce Momjian wrote:
>
> Yep, I assume PITR would be the solution for most failure cases --- very
> ugly of course.
Anything can be broken in some way, if bad luck is willing to work hard
enough. In at least one, ah, competing company I know of, employee
On Wed, 10 Sep 2003 00:18:52 -0400, Tom Lane <[EMAIL PROTECTED]>
wrote:
>I have a suspicion that there is no real leak, but
>rather we are seeing some artifact of the way Linux' top(1) reports
>memory usage.
>From my experience I can confirm that. I have looked a lot at top
output when I benchmar
Tom Lane said:
> Jan Wieck <[EMAIL PROTECTED]> writes:
>> So either we do the random signature thing, which I would favor as a
>> one time be all, end all solution - or you do the actual from-address
>> based implementation by restoring the old IPV4 behaviour and adding
>> correct IPV6 behaviour
Bruce Momjian said:
>
> Are all the IPv6 issues resolved in current CVS?
>
This one appears to be, at any rate.
cheers
andrew
> -
--
>
> Tom Lane wrote:
>> Andrew Dunstan <[EMAIL PROTECTED]> writes:
>> > OK, now we are get
I have encoding problems using translated error messages (7.4beta1).
When database encoding is set to SQL_ASCII, all mesages arrive to client
correctly respecting the CLIENT_ENCODING, but if I create database WITH
ENCODING='unicode' or WITH ENCODING='latin2', messages are displayed
corre
56 matches
Mail list logo
