Quoting Doug McNaught <[EMAIL PROTECTED]>:
> "Chris Stokes" <[EMAIL PROTECTED]> writes:
>
> > >The REINDEX is needed because VACUUM doesn't free up index space in
> > >some circumstances. 7.4 (currently in late beta) will fix this.
> >
> > Sorry Doug,
> >
> > Yes I am doing a vacuum regularly
Quoting David Busby <[EMAIL PROTECTED]>:
> List,
> Which of the may Perl Modules on CPAN should I use for PostgreSQL. I'd
> prefer the fastest/most up to date module. Which is it or do I have to dig
> through them all?
>
>
> David Busby
> Systems Engineer
> [EMAIL PROTECTED]
>
>
> --
I was just helped with this last week (see threat "Interfaces that support
cursors" that started on 10/10 if its in the archives". The two ways to do it-
either issuing a selects with limit/offset modifiers or with a cursor. On the
above thread today, it was posted that large datasets are going t
Quoting Dennis Gearon <[EMAIL PROTECTED]>:
> I've been using PG very lightly for quite awhile, (although I"ve read
> through all but the programmer's manual once or twice). I loved when I
> got to PG and it had Oracle like features, "A real database!". This is
> after using MySQL, which I first
Quoting Jonathan Bartlett <[EMAIL PROTECTED]>:
> > Ok, I did see the autocommit flag setting in DBD:Pg when I starting reading
> up
> > on the DBI/DBD interfacing methods so I guess I could recode for that.
> However,
> > how do you "maintain" the current transaction open if your script is
> writ
Quoting Doug McNaught <[EMAIL PROTECTED]>:
> Network Administrator <[EMAIL PROTECTED]> writes:
>
> > Ok, I did see the autocommit flag setting in DBD:Pg when I starting
> > reading up on the DBI/DBD interfacing methods so I guess I could
> > recode for that.
Quoting Doug McNaught <[EMAIL PROTECTED]>:
> Network Administrator <[EMAIL PROTECTED]> writes:
>
> > I've got a Pg 7.1.3 release that I'm going to upgrade to 7.4 but in the
> meantime
> > I wanted to know if Pg.pm (or DBD:Pg) supported using cursors
Quoting Ron Johnson <[EMAIL PROTECTED]>:
> On Fri, 2003-10-03 at 14:37, Network Administrator wrote:
> > Quoting Ron Johnson <[EMAIL PROTECTED]>:
> >
> > > On Fri, 2003-10-03 at 13:32, Network Administrator wrote:
> > > > Quoting Richard Huxton <
Quoting Bruno BAGUETTE <[EMAIL PROTECTED]>:
> > I'm personally using mod_auth_pgsql against a user table with
> > encrypted passwords. To properly encrypt them I am using the
> > contrib pgcrypto module and something like
>
> Hello,
>
> Can you tell me what version of mod_auth_pgsql do you us
Quoting Tom Lane <[EMAIL PROTECTED]>:
> Network Administrator <[EMAIL PROTECTED]> writes:
> >>> PANIC: read of clog file 5, offset 16384 failed: Success
>
> >> Hm, not good :-(. What files actually exist in $PGDATA/pg_clog/ (names
> >> a
Quoting Tom Lane <[EMAIL PROTECTED]>:
> Network Administrator <[EMAIL PROTECTED]> writes:
> > ..if I using the psql client, and issue a "select * from name>
> > limit 5" if get this...
>
> > PANIC: read of clog file 5, offset 16384 failed: Su
Hmmm, ok, I can't retask any of my people or reallocation funds for this year
but I can personally do 5 to 10% of that monthly cost.
Some more people and project plan- then the ball could roll :)
Quoting "Joshua D. Drake" <[EMAIL PROTECTED]>:
>
> >
> > And that has nothing to do with user need
Quoting Tom Lane <[EMAIL PROTECTED]>:
> Network Administrator <[EMAIL PROTECTED]> writes:
> > The abstraction I am talking about would be a logical layer that would
> handle
> > disk I/O including the format of that data (lets call this the ADH).
>
> This soun
Not that I know anything about the internal workings of PG but it seems like a
big part of the issue is the on disk representation of database. I've never had
a problem with the whole dump/restore process and in fact anyone that has been
doing this long enough will remember when that process was g
I thought "bytea" was PG's version of BLOBs. I don't see a "blob" type in the
current docs.
Also, I saw your example code as well. I use Perl as well but I use the native
Pg.pm module. There doesn't seem to be a way to switch the input to binary data
but there is support for what is called "lar
Quoting Andrew Ayers <[EMAIL PROTECTED]>:
> Network Administrator wrote:
> > I'd actually like to get some comments on this too because for
> compatibility and
> > throughput issues, I would think that storing the file path in the
> database
> > instead
look at uuencoding / base-64 encoding as a way of storing
> things in the database.
>
> It's more easily ported than either bytea or large objects.
>
> On Wed, 10 Sep 2003, Network Administrator wrote:
>
> > I'd actually like to get some comments on this too be
h, I use this on an ecommunities type site- I haven't seen any errors. This
is also a pg 7.1.3
As an example, something like this might be executed:
select date_trunc('year',age(to_date(dob,'MM/DD/'))) as age from members
where memid=101;
Quoting Ben <[EMAIL PROTECTED]>:
> It must be
I'm working on pgSQL integration with Domino6 (DECS, LCLSX) (there will be
documentation in the coming weeks).
I have a question a couple of questions for you:
1) Are you using Domino 6 or 5.x
2) In your DSN setup on (NT?) do you have the valid
account information to connect to Pg?
3) If you a
19 matches
Mail list logo
