Stephan Szabo <[EMAIL PROTECTED]> writes:
> For union, queries that want to do something like use a temporary
> sequence to act sort of like rownum and do row limiting. Admittedly
> that's already pretty much unspecified behavior, but it does change
> the behavior in the place of duplicate remova
On Wed, Jul 31, 2002 at 11:20:35PM -0400, Bruce Momjian wrote:
>
> I am wondering why we even want to specify the WAL location anywhere
> except as a flag to initdb. If you specify a location at initdb time,
> it creates the /xlog directory, then symlinks it into /data.
I thought the whole poin
On Wednesday 31 July 2002 09:38 pm, Marc G. Fournier wrote:
> Okay ... since this is pretty much going to be 'one camp for, one camp
> against' without anything to really back up either camps perspectives /
> arguments, I did some research on CVS in order to find a nice, effective
> middle ground
On Thu, Aug 01, 2002 at 10:44:23AM -0400, Neil Conway wrote:
> On Thu, Aug 01, 2002 at 12:01:52PM +0200, Karel Zak wrote:
> > Is there some common convention of names?
>
> No, there isn't (for example, pg_stat_backend_id() versus
I know -- for this I asked. IMHO for large project like PostgreS
On Thu, 1 Aug 2002, Stephan Szabo wrote:
> On 1 Aug 2002, Hannu Krosing wrote:
>
> > On Thu, 2002-08-01 at 12:29, Curt Sampson wrote:
> > > On Thu, 1 Aug 2002, Zeugswetter Andreas SB SD wrote:
> > >
> > > > I had a "union all" view, which is actually a quite different animal than
> > > > a "unio
On Thu, 2002-08-01 at 10:44, Neil Conway wrote:
> On Thu, Aug 01, 2002 at 12:01:52PM +0200, Karel Zak wrote:
> > Is there some common convention of names?
> functions. However, establishing a naming convention without
> breaking backwards compatibility might be tricky.
Supporting both names for
On Thu, Aug 01, 2002 at 12:01:52PM +0200, Karel Zak wrote:
> Is there some common convention of names?
No, there isn't (for example, pg_stat_backend_id() versus
current_schema() -- or pg_get_viewdef() versus obj_description() ).
Now that we have table functions, we might be using more built-in
f
On 1 Aug 2002, Hannu Krosing wrote:
> On Thu, 2002-08-01 at 12:29, Curt Sampson wrote:
> > On Thu, 1 Aug 2002, Zeugswetter Andreas SB SD wrote:
> >
> > > I had a "union all" view, which is actually a quite different animal than
> > > a "union" view which needs to eliminate duplicates before furth
Hannu Krosing <[EMAIL PROTECTED]> writes:
> This name mangling should be done at connect time and kept out of
> database, where each users name should always be fully resolved
> ([EMAIL PROTECTED]).
I really like Hannu's approach to this. It seems to solve Marc's
problem with a very simple, eas
On Thu, 1 Aug 2002, Tom Lane wrote:
> "Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> >> I realize that Marc wasn't proposing splitting off any
> >> server-side code, but I still want to tread carefully about breaking
> >> up the codebase.
>
> > Okay, well, the way I'm working it through right n
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
>> I realize that Marc wasn't proposing splitting off any
>> server-side code, but I still want to tread carefully about breaking
>> up the codebase.
> Okay, well, the way I'm working it through right now, I'm doing it in such
> a way that unless you
... is once more 'normal' ...
there are three modules right now setup:
earthdistance
libpqxx
pgsql-server
pgsql combines all three of the above to transparently give the equivalent
of the whole distribution from its component parts ...
---(end of broadcast)-
On Thu, 2002-08-01 at 12:29, Curt Sampson wrote:
> On Thu, 1 Aug 2002, Zeugswetter Andreas SB SD wrote:
>
> > I had a "union all" view, which is actually a quite different animal than
> > a "union" view which needs to eliminate duplicates before further processing.
>
> I had the same problem wit
On Thu, 1 Aug 2002, Zeugswetter Andreas SB SD wrote:
> I had a "union all" view, which is actually a quite different animal than
> a "union" view which needs to eliminate duplicates before further processing.
I had the same problem with UNION ALL.
cjs
--
Curt Sampson <[EMAIL PROTECTED]> +81
> But the message I was replying to was a similar union query, and I was
> thinking that that person might be having a similar initial intuitive
> reaction, "well, it looks kinda the same." I just wanted to note that
> you need to check this stuff with explain, rather than
> blindly assuming
> y
On Tue, Jul 30, 2002 at 09:48:42PM -0400, Bruce Momjian wrote:
>
> OK, renamed to backend_pid() to match the libpq name. I was unsure
> about merging it into the stats stuff myself.
>
> setest=> select backend_pid();
>backend_pid
> -
> 12996
>
Le Mercredi 31 Juillet 2002 05:50, Bruce Momjian a écrit :
> Here are the open items for 7.3. We have one more month to address them
> before beta.
Is CREATE OR REPLACE VIEW on the list?
---(end of broadcast)---
TIP 3: if posting/reading through U
> > > NAMEDATALEN - disk/performance penalty for increase, 64, 128?
> > > FUNC_MAX_ARGS - disk/performance penalty for increase, 24, 32?
> >
> > At the moment I don't see a lot of solid evidence that increasing
> > NAMEDATALEN has any performance penalty. Someone reported about
> > a 10% slowdo
Bruce Momjian dijo:
> Here are the open items for 7.3. We have one more month to address them
> before beta.
> CLUSTER - ready?
I'm just back. I'll have a look at the problem with the patch and
resubmit.
--
Alvaro Herrera ()
"Es filosofo el que disfruta con los enigmas" (G. Coli)
---
> -Original Message-
> From: Iavor Raytchev [mailto:[EMAIL PROTECTED]]
> Sent: 31 July 2002 22:12
> To: pgsql-hackers
> Cc: pgaccess - developers
> Subject: Re: [HACKERS] Open 7.3 items
>
>
>
> > > psql is very definitely not ready, nor is pgaccess.
>
> I could not really trace who
On Thu, 2002-08-01 at 06:48, Marc G. Fournier wrote:
> On Wed, 31 Jul 2002, Bruce Momjian wrote:
>
> > One idea I had was to look for a colon in the username, and if I see
> > one, I assume everything after the colon is a password. Would that work
> > for you?
>
> That would definitely work ...
On Thu, 2002-08-01 at 02:05, Bruce Momjian wrote:
> Marc G. Fournier wrote:
> > On Wed, 31 Jul 2002, Neil Conway wrote:
> >
> > > On Wed, Jul 31, 2002 at 02:01:43AM -0300, Marc G. Fournier wrote:
> > > > add in 'fix pg_hba.conf / password issues' to that too :)
> > >
> > > I doubt that will make
101 - 122 of 122 matches
Mail list logo