hi,
im currently working on a project that requires batch operations - eg. Batch
insert/update etc. The database im using is PostgreSQL. However, i cannot
find any documentation for batch opeartions on PostgreSQL. Does anyone know
how to do this, or if it is possible?
Thanx in advance
regards
rahu
> Not sure I care for the "vacuum" part of that, but how about this
> variant: DROP USER sets a flag in pg_shadow to disable login, and
> the pg_shadow entry isn't removed, ever. (We could tweak the pg_user
> view to hide dropped users, but anything looking directly at pg_shadow
> would have to be
- Original Message -
From: "Gavin Sherry" <[EMAIL PROTECTED]>
> I am still researching ways of increasing performance of yacc parsers --
> there is a very small amount of information on the Web concerning this --
I know some people who will tell you that the best way of improving
perform
Of course, I was wrong. In fact, the patch below actually said it was
the pre-POSIX version of getpwuid_r().
---
Bruce Momjian wrote:
>
> Actually, your getpwuid_r is the old, pre-POSIX format. The attached
> email has th
--On Monday, August 11, 2003 20:36:11 -0400 Tom Lane <[EMAIL PROTECTED]>
wrote:
Larry Rosenman <[EMAIL PROTECTED]> writes:
On Mon, 11 Aug 2003, Bruce Momjian wrote:
Larry Rosenman wrote:
Can we modify pg_dumpall (or pg_dump?) to include a \pset pager off
to prevent the setval() calls from halti
Bruce, I know it's a bit picky but both below should be along the
lines of "Allow thread-safe library" since they are not "threaded" per
se.
L.
Bruce Momjian writes:
> Libpq
> Allow threaded with --enable-thread-safety (Lee Kindness, Bruce)
> Miscellaneous Interfaces
> Allow threaded ecpg wit
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Does anyone mind if I remove src/interfaces/cli? It's clearly outdated
> and useless.
Looking at the CVS history, it seems that Lockhart had an idea of
building a CLI-spec-compatible interface on top of ecpg, but never
went further than an initial co
Of course, now I've just gone to some trouble to accomodate funky
characters in user and dbnames in logging I'd have to kill him ...
:-)
Seriously, I think there's a good case for banning a few characters in
at least some names - like []<>'"~#*|\ , say
andrew
Tom Lane wrote:
Andreas Pflug <[
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Bruce Momjian <[EMAIL PROTECTED]> writes:
> Seems we have a problem with pooled connections and WITH HOLD cursors.
> We have code to reset transaction state and variables via RESET ALL, but
> how do we remove WITH HOLD cursors when we p
Added to TODO:
* Prevent unneeded quoting in psql \d output using fmtId()
---
Christopher Kings-Lynne wrote:
> > I assume we don't want them always quoted.
>
> Problem with that is that someone has to move the to-
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Yes, I see those regularly too, and are related to bison issues.
The two 'defined but not used' warnings in pgc.c are a longstanding flex
(not bison) issue. (Hmm ... I wonder if they still happen in flex
2.5.31?) The other warning is not flex's fault -
Mike Mascari wrote:
> >>My participation in The Project was one of the greatest adventures in my
> >>life. Thanks to everyone!
> >
> > I know that a lot of what makes PostgreSQL what it is today is can be directly
> > atttributed to your work. Thank you. And thank you for the personal help
> >
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> So if you agree that there is a quoting problem,and you don't mind
> breaking backwards compatibility for it, I'll do a complete patch...
I don't see any backwards-compatibility issue, because usernames
containing double quotes just plain don't
On Fri, 08 Aug 2003 18:25:41 -0400, Tom Lane <[EMAIL PROTECTED]>
wrote:
> Two examples: [...]
One more example:
X Y
A A
a B
A C
b A
B B
b C
C A
c B
C C
Cor
--On Saturday, August 09, 2003 12:31:14 -0400 Tom Lane <[EMAIL PROTECTED]>
wrote:
Kurt Roeckx <[EMAIL PROTECTED]> writes:
If they don't have it defined, it's not going to do what we
expect and we might be better of using our replacement functions.
We will if we don't find struct addrinfo. See
On Fri, Aug 08, 2003 at 15:32:05 +0530,
Rahul_Iyer <[EMAIL PROTECTED]> wrote:
> hi,
> im currently working on a project that requires batch operations - eg. Batch
> insert/update etc. The database im using is PostgreSQL. However, i cannot
> find any documentation for batch opeartions on PostgreSQ
> > AFAICS (part of) the real problem is in costsize.c:cost_index() where
> > IO_cost is calculated from min_IO_cost, pages_fetched,
> > random_page_cost, and indexCorrelation. The current implementation
> > uses indexCorrelation^2 to interpolate between min_IO_cost and
> > max_IO_cost, which IMHO
Bruce Momjian <[EMAIL PROTECTED]> writes:
> TODO item?
Yeah. I'm leaning towards the idea that a protocol addition is what to
do.
>> Hm. Good thought. Maybe the same is true of held cursors.
>>
>> It would be a simple addition at either the protocol or SQL level to
>> list the names of existi
Robert Creager <[EMAIL PROTECTED]> writes:
> tassiv=# explain DELETE FROM temp_obs_i
> tassiv-# WHERE file_id IN
> tassiv-#(SELECT file_id
> tassiv(# FROM temp_obs_i NATURAL JOIN files
> tassiv(# WHERE group_id = 3
> tassiv(#AND pair_id = 25)
> tassiv-# ;
> ERROR: varia
Larry Rosenman <[EMAIL PROTECTED]> writes:
> To fix it, remove -K inline from src/port/unixware's CFLAGS.
> Dave Prosser of SCO has a fix, but this is the most expedient fix for now.
Do you think we should make that change for 7.4? Or will the workaround
be obsolete by the time 7.4 is released?
Bruce Momjian wrote:
How are statement level triggers supposed to work? Are they just
triggers deferred until the end of the statement? You mentioned access
to the affected rows, but I don't understand how that is supposed to
happen.
Statement level isn't about deferring or grouping the trigg
D'Arcy J.M. Cain wrote:
> On Monday 11 August 2003 00:36, Vadim Mikheev wrote:
>
>>FarewellIt's time for formal acknowledgement that I'm not in The Project
>>any more.
>>
>>I'm not interested in small features/fixes and have no time for big ones.
>>It was this way for very long time and I don't s
On Monday 11 August 2003 00:36, Vadim Mikheev wrote:
> FarewellIt's time for formal acknowledgement that I'm not in The Project
> any more.
>
> I'm not interested in small features/fixes and have no time for big ones.
> It was this way for very long time and I don't see how/when that could
> change
Hello:
I want to know if postgresql 7.4 beta 1 can be configured under Cygwin
with SSL support ??
If the answer is positive how can i do it ?? or where can i found
documentation about this ( under linux or cygwin :) ) ??
Thanks in advance :)
--
Best regards
Carlos Guzmán Álvarez
Vigo-Sp
> -Original Message-
> From: The Hermit Hacker [mailto:[EMAIL PROTECTED]
> Sent: 11 August 2003 14:03
> To: Vadim Mikheev
> Cc: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] Farewell
>
>
>
> I never know what to say in response to stuff like this ...
> its like having to sign a card whe
Ah OK, I must have been thinking of the database owner check. I'd vote for
(1) checking that they own no objects and by default owning all their stuff
to the database owner. Plus add an optional clause:
DROP USER foo OWNER TO bob;
Chris
- Original Message -
From: "Andrew Dunstan" <[
Good luck, Vadim !
Thanks for your work.
Oleg
On Sun, 10 Aug 2003, Vadim Mikheev wrote:
> FarewellIt's time for formal acknowledgement that I'm not in The Project any more.
>
> I'm not interested in small features/fixes and have no time for big ones.
> It was this way for very long time a
27 matches
Mail list logo
