On Thu, 31 Aug 2000, Ian Turner wrote:
> It seems that cascading across multiple tables does not work
> correctly, when combining different action types. For example, given:
>
> CREATE TABLE a (anum Integer PRIMARY KEY);
> CREATE TABLE b (bnum Integer PRIMARY KEY,
> anum Integer RE
> -Original Message-
> From: Jules Bean
>
> On Thu, Aug 31, 2000 at 09:58:34AM +0100, Jules Bean wrote:
> > On Thu, Aug 31, 2000 at 03:28:14PM +1100, Chris wrote:
> >
> > > but it is true that this is a flaw in postgres. It has been
> > > discussed on hackers from time to time about implem
I know there's been a certain amount of buzz over the
usefulness/methodology of the tests, but Great Bridge just published a set
of tests using "Major Proprietary #1", ...#2, etc. kind of terminology.
http://www.greatbridge.com/news/p_081420001.html
-emile
On Thu, 31 Aug 2000, Ian Turner wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
It seems that cascading across multiple tables does not work
correctly, when combining different action types. For example, given:
CREATE TABLE a (anum Integer PRIMARY KEY);
CREATE TABLE b (bnum Integer PRIMARY KEY,
anum Integer REFER
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I am looking for a good head to head comparison of the latest
> rdbms's and how they match up performance scalibilty out of the
> box with POSTGRESQL.
Alas, most commercial rdbms's (i.e., oracle, informix, MS SQL, etc.) do
not allow you to publish
> "Trewern, Ben" wrote:
>
> I have just been trying out
>
> Create Table .. Inherits ( ..);
>
> Am I right in saying you create a table that inherits fields & default
> values, but not triggers.
>
> I have not tried rules or anything else yet. Where can I read more
> about inheritance and whe
Hey again
I have another question regarding using transactions with perl/dbi.
I think I have the general idea of creating and committing the transactions
etc through the DBI under control but,
My problem is that I'm connecting to the database in one perl script which
opens the transaction, a
> I have to remake PHP script (which full of Access SQL implementation)
> for PostgreSQL. I have a some of strings like this:
>
> SELECT memmod.item, memmod.oempartno, memmod.sdescr
> FROM memmod WHERE (InStr(1, [item], '".$edtPartNo."'));";
There are programs to help you move Access *tables* t
set no-mail
Can any of you running PostgreSQL on Alphas comment on the performance vs.
Intel-based servers?
steve
On Thu, 31 Aug 2000, Tom Lane wrote:
>
> Actually I think netstat only shows open connections, not processes
> listening for connections. Does anyone know a (reasonably portable)
> way of seeing which port numbers are being accept()ed on?
>
> regards, tom lane
netstat -l
I have to remake PHP script (which full of Access SQL implementation) for
PostgreSQL. I have a some of strings like this:
SELECT memmod.item, memmod.oempartno, memmod.sdescr
FROM memmod WHERE (InStr(1, [item], '".$edtPartNo."'));";
How can I convert this string for PostgreSQL?
--
I am looking for a good head to head comparison of the latest
rdbms's and how they match up performance scalibilty out of the
box with POSTGRESQL.
Thanks !!!
[EMAIL PROTECTED]
Get your own "800" number - Free
Free voicemail, fax, email, and a lo
> I solved my problem by going into the registry and deleting the
> ODBC managers keys and reinstalling PostgreSQL w/driver manager.
> I love my other ODBC datasources, but reinstalled those. It's hardly
> elegant, I'm sure they're are better ways, but, hey, it worked for
> me. Your mileage may *d
Title: INHERITANCE
I have just been trying out
Create Table .. Inherits ( ..);
Am I right in saying you create a table that inherits fields & default values, but not triggers.
I have not tried rules or anything else yet. Where can I read more about inheritance and where to use it.
Tha
Marcin Mazurek wrote:
>
> Hi,
> Is it possible to determine easily which action called triger?
> For example:
> CREATE TRIGGER log_znw BEFORE INSERT OR UPDATE ON tab
>FOR EACH ROW EXECUTE PROCEDURE log_tab();
> How to check in called function if it was INSERT or UPDATE?
Sure. Here's a snipp
At 10:15 31/08/00 -0400, Tom Lane wrote:
>Actually I think netstat only shows open connections, not processes
>listening for connections. Does anyone know a (reasonably portable)
>way of seeing which port numbers are being accept()ed on?
>
netstat -a | grep LISTEN
works on most UNIX flavours
Hoosain Madhi <[EMAIL PROTECTED]> writes:
> The fact that I request
> c.c7link in the first part of the query, it returns all c7links from
> tbl_c7links. Ideally I should set this to NULL and then request c.c7links in
> the second part of the query (line9). However the parser complains if I
> rep
On Thu, 31 Aug 2000, Tom Lane wrote:
> Actually I think netstat only shows open connections, not processes
> listening for connections. Does anyone know a (reasonably portable)
> way of seeing which port numbers are being accept()ed on?
>
> regards, tom lane
how about ls
> Hi!,
>
> I'm installing the ODBC Driver, and evrything goes right in all the
> clients (NT Workst.) except in one of them where I get this error at
> 85% of the set up process:
>
> "Unable to create ODBC Core Subkey"
>
> Sure, It's not ODBC Driver faulty (I guess), but if someone knows how
>
On Thu, Aug 31, 2000 at 10:15:50AM -0400, Tom Lane wrote:
> > netstat did not list them as using a port,
>
> Actually I think netstat only shows open connections, not processes
> listening for connections. Does anyone know a (reasonably portable)
> way of seeing which port numbers are being acce
Travis Bauer <[EMAIL PROTECTED]> writes:
> Well, there were two other copies of postgress running, and at least one
> was tying up port 5432, but . . .
> I couldn't see them with 'ps' or 'ps -a',
ps -a only lists processes that it thinks are spawned from interactive
sessions. You need ps -ax to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> Now I'm back in business, but I don't understand why they didn't show
> up in ps or ps -a.
from the 'ps' manpage:
aSelect all processes on a terminal, includ-
ing those of other users
xSelect processes without
On Thu, Aug 31, 2000 at 09:43:52AM -0300, Campbell, Scott wrote:
>
> $sth = $dbh->prepare("begin work");
> $sth->execute();
>
[snip error]
>
> after seeing this I assumed that you just can't use the begin statement
> accross the DBI but there has to be a way of opening a transaction (it even
On Thu, Aug 31, 2000 at 07:30:36AM -0500, Travis Bauer wrote:
> Well, there were two other copies of postgress running, and at least one
> was tying up port 5432, but . . .
>
> I couldn't see them with 'ps' or 'ps -a', netstat did not list them as
> using a port, but it did list something as havi
I'm having problems opening a transaction through perl DBI
When I try to execute "begin work" using the DBI prepare and execute
functions I get an error:
$sth = $dbh->prepare("begin work");
$sth->execute();
returns this error when I run the perl script from a prompt:
please use DBI functions fo
Well, there were two other copies of postgress running, and at least one
was tying up port 5432, but . . .
I couldn't see them with 'ps' or 'ps -a', netstat did not list them as
using a port, but it did list something as having "Active UNIX domain
sockets," listing the tmp files I had deleted yes
Where can I find step-by-step instructions for upgrading postgres?
Bob Kernell
Research Scientist
AS&M
email: [EMAIL PROTECTED]
Hi!,
I'm installing the ODBC Driver, and evrything goes right in all the clients
(NT Workst.) except in one of them where I get this error at 85% of the set
up process:
"Unable to create ODBC Core Subkey"
Sure, It's not ODBC Driver faulty (I guess), but if someone knows how to
work out, would b
On Thu, Aug 31, 2000 at 09:58:34AM +0100, Jules Bean wrote:
> On Thu, Aug 31, 2000 at 03:28:14PM +1100, Chris wrote:
>
> > but it is true that this is a flaw in postgres. It has been
> > discussed on hackers from time to time about implementing a "streaming"
> > interface. This means that the cli
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> how can I write function which takes text from one field, replaces
> some characters and puts it in other field? I have array with old and
> new values.
Probably best to do this as an embedded perl sql function. Then it is
about 3 lines.
Ian
-
On Thu, Aug 31, 2000 at 01:33:35AM -0400, Tom Lane wrote:
> "Travis Bauer" <[EMAIL PROTECTED]> writes:
> > I'm getting:
> > FATAL: StreamServerPort: bind() failed: Address already in use
> > Is another postmaster already running on that port?
> > If not, wait a few seconds and retr
On Thu, Aug 31, 2000 at 03:28:14PM +1100, Chris wrote:
> Jules Bean wrote:
> >
> > On Thu, Aug 31, 2000 at 12:22:36AM +1000, Andrew Snow wrote:
> > >
> > > > I believe I can work around this problem using cursors (although I
> > > > don't know how well DBD::Pg copes with cursors). However, that
33 matches
Mail list logo
