A desperate newbie question:
I have a _lot_ of tables, where a crc checksum needs to be calculated after every
insert/update on all fields (but OID and CRC). I have no problems writing my external
crc function, but:
What would be the most elegant way to achieve that? Could I use inheritance i
Tom Lane wrote:
> lec <[EMAIL PROTECTED]> writes:
> > Under 7.0.2, there are no Hash Join or Hash
>
> So, then, what *does* it do? Without the explain for 7.0.2 it's
> impossible to tell what's happening.
The following is the query/explai
A few months ago I posted to either the hackers or interfaces list
instructions on how to get MSSQL7 to talk to PostgreSQL (using the ODBC
driver) and to use the DTS (Data Transform Services) to transfer data
between them.
It should be on the archives or in the docs.
Peter
On Sat, 9 Sep 2000, R
Thanks Brian, thats actually good to know
Does anyone know if the libpq++ pools connections?
Thanks
Gary
- Original Message -
From: "Brian Baquiran" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 11, 2000 4:22 AM
Subject: Re: [GENERAL] Transaction Manager
>
> [EMAIL
subscribe
hello!
I'm a devloper now using the postgresql. I have some
questions about postgresql when
use it. Please help me.
1. Dose postgresql support the nested transaction
?
2. In my project, I used postgresql and my program need
keepping a long time
connection
Tom Lane wrote:
> lec <[EMAIL PROTECTED]> writes:
> > Under 7.0.2, there are no Hash Join or Hash
>
> So, then, what *does* it do? Without the explain for 7.0.2 it's
> impossible to tell what's happening.
I'll re-install 7.0.2 later & run the explain.
>
>
> > Are there any way to optimize this
Jim Jennis wrote:
> Hi Postgres colleagues,
>
> Sorry if this is a re-post, but it did not show up on the list (at least in
> my mailbox) so I am posting it again.
>
> I am running a 3rd party development tool on Linux (Verastream from WRQ)
> that has an open C API for multi-database connectiv
I have a small database which has been working fine. I just converted
from 6.5.3 to 7.0.2 (Debian/Linux). Used pg_dumpall to restore the contents.
What is strange now is that I can't create new tables without causing
vacuum problems. For example:
CREATE TABLE test_table (
test_id
Hi Postgres colleagues,
Sorry if this is a re-post, but it did not show up on the list (at least in
my mailbox) so I am posting it again.
I am running a 3rd party development tool on Linux (Verastream from WRQ)
that has an open C API for multi-database connectivity. It transparently
supports
That was it! Thanks alot.
Wade Oberpriller
StorageTek
[EMAIL PROTECTED]
>
> [EMAIL PROTECTED] (Wade D. Oberpriller) writes:
> > Once I attempt to install, I get errors that look like:
>
> > gmake[2]: Entering directory
>`/home/anubis22/oberpwd/postgresql-7.0.2/src/backend/access'
> > gmake -
>
> [EMAIL PROTECTED] (Wade D. Oberpriller) writes:
> > Once I attempt to install, I get errors that look like:
>
> > gmake[2]: Entering directory
>`/home/anubis22/oberpwd/postgresql-7.0.2/src/backend/access'
> > gmake -C common postgres/usr/X11R6
>
> Oh my, it looks like gmake is finding a
> can anyone recommend a windows ui tool for viewing data in postgres?
> essentially i want to use something other than the command line for
looking
> at results. as an emample, i'm looking for the equivalent of TOAD for
> Oracle. is the easiest approach to connect in MS Access via odbc?
Wel
lec <[EMAIL PROTECTED]> writes:
> Under 7.0.2, there are no Hash Join or Hash
So, then, what *does* it do? Without the explain for 7.0.2 it's
impossible to tell what's happening.
> Are there any way to optimize this type of query?
Um, have you vacuum analyzed the tables involved?
[EMAIL PROTECTED] (Wade D. Oberpriller) writes:
> Once I attempt to install, I get errors that look like:
> gmake[2]: Entering directory
>`/home/anubis22/oberpwd/postgresql-7.0.2/src/backend/access'
> gmake -C common postgres/usr/X11R6
Oh my, it looks like gmake is finding a value of $(X) fro
Where, in the backend code, is the authentication handled? And at what
stage is it handled?
Thanks.
--
Matt Barringer
Adversary
WireX, Inc.
You might also try pg_access which comes with postgres. You will have to
install Tcl/Tk on the windows machine but that is available on the Net. As
far as ACCESS goes, I think ODBC is the ONLY way you are going to connect to
Postgres but it DOES work just fine. There are some things you have to
Try PgAdmin: http://www.pgadmin.freeserve.co.uk/
Poul L. Christiansen
chris markiewicz wrote:
> hello.
>
> can anyone recommend a windows ui tool for viewing data in postgres?
> essentially i want to use something other than the command line for looking
> at results. as an emample, i'm looking
hello.
can anyone recommend a windows ui tool for viewing data in postgres?
essentially i want to use something other than the command line for looking
at results. as an emample, i'm looking for the equivalent of TOAD for
Oracle. is the easiest approach to connect in MS Access via odbc?
thanks
After upgrading to 7.0.2, one of my queries ran much slower on 7.0.2:
7.0.2 took 17 minutes (After 'optimization' by SET ENABLE_SEQSCAN=OFF)
6.5.3 took 2 minutes
The following is the query/explain under 6.5.3:
super=> select version();
version
Yes
>= Original Message From [EMAIL PROTECTED] (Wade D. Oberpriller)
=
>Hello,
>
>Are my questions being posted? If so, could someone just reply so I have
peace
>of mind.
>
>Wade Oberpriller
>StorageTek
>[EMAIL PROTECTED]
> > By the way, I keep receiving mails from the 'pgsql-hackers'
> > list, to which
> > I'm not subscribed.
> >
>
> as am I.
>
> -Jim
I think just about everyone in general is. (at least i know i am) It's
only been the past few days though. Same time frame of which everyone is
complaining
Hey, it worked!
--
Scott Holdren
[EMAIL PROTECTED]
22 matches
Mail list logo
