Reason: I want to know if any of these features are scheduled.
1. Calculated fields in table definitions . eg.
Create table test (
A Integer,
B integer,
the_sum As (A+B),
);
This is currently easily done with a procedure that takes a tabletype
At 18:00 23/11/00 +1300, John Huttley wrote:
1. Calculated fields in table definitions . eg.
Can't really do this - you might want to consider a view with an insert
update rule. I'm not sure how flexible rules are and you may not be able to
write rules to make views functions like tables, but
We lack a syntax that would enable us to write an on update/delete do instead rule
that would efficiently map an update/delete to a table that is referenced by a view.
Currently the only rule you can implement is one that uses a primary key.
This has the disadvantage of needing a self join to
We lack a syntax that would enable us to write an on update/delete do instead rule
that would efficiently map an update/delete to a table that is referenced by a
view.
Currently the only rule you can implement is one that uses a primary key.
This has the disadvantage of needing a self
At 12:28 PM 11/23/00 +0100, Zeugswetter Andreas SB wrote:
Reason: I want to know if any of these features are scheduled.
1. Calculated fields in table definitions . eg.
Create table test (
A Integer,
B integer,
the_sum As (A+B),
);
This is
At 06:00 PM 11/23/00 +1300, John Huttley wrote:
1. Calculated fields in table definitions . eg.
Create table test (
A Integer,
B integer,
the_sum As (A+B),
);
...
These are _extraordinarily_ useful for application development.
If anyone has a way of
Hi:
I have a MS Access database with tables containing TEXT fields.
I need import that info in a postgres 7 table.
How to do it?
If I use copy from, dont work.
tia
Carlos Jacobs
Title: Hung backends
Hi,
I'm new to PostgreSQL and have been asked to determine the cause of what appear to be hung processes on FreeBSD after one or more frontend apps crash. I did alot of searching through the msg lists and found a few discussions that seem related, but I was unable to find
I backed up my database from Postgres 6.5.3 and migrated to 7.0.2
several a few months ago. For some reason, data was lost in the
transition. I've finally pinned it down to the attached file (abridged
to point out the problem).
It looks like two things happened in the backup. First, when I move
Tom Lane writes:
Pete Forman wrote:
The basic problem is that netinet/tcp.h is a BSD header. The
correct header for TCP internals such as TCP_NODELAY on a UNIX
system is xti.h. By UNIX I mean UNIX95 (aka XPG4v2 or SUSv1)
or later. The 2 files which conditionally include
Hi:
Wonder if any of you know how to setup a postgreSQL server as a windows 2000 service
or have a URL or document on how to do it.
Thank you
--
Luis Magaña
Gnovus Networks Software
www.gnovus.com
Tel. +52 (7) 4422425
[EMAIL PROTECTED]
I sent this to the general list and got no response so I figure I can take
it to the people who actually make the decisions.
Is this a security bug or is it by design?
- Original Message -
From: "Dan Wilson" [EMAIL PROTECTED]
To: "pgsql general" [EMAIL PROTECTED]
Sent: Sunday, November
Christopher Kings-Lynne wrote:
Speaking of - I simply cannot find a standard SQL specification anywhere on
the net, without buying one from ANSI. I'm forced to rely on
vendor-specific docs - which are not standard in any way. Is anyone able to
mail me such a thing?
You may want to take a
xuyifeng ([EMAIL PROTECTED]) wrote:
it's obviously there is a query plan optimizer bug, if int2 type used
in fields, the plan generator just use sequence scan, it's stupid, i
am using PG7.03, this is my log file:
-
stock# drop table a;
DROP
stock# create table a(i int2, j
* Larry Rosenman [EMAIL PROTECTED] [001123 01:10]:
* Tom Lane [EMAIL PROTECTED] [001122 22:44]:
Makes sense. Here's a new patch, now the output even looks better:
Nov 23 00:58:04 lerami pg-test[9914]: [2-1] NOTICE: QUERY PLAN:
Nov 23 00:58:04 lerami pg-test[9914]: [2-2]
Nov 23 00:58:04
At 11:27 24/11/00 +0800, Christopher Kings-Lynne wrote:
SELECT datlastsysoid from pg_database where datname = 'dbname'
But as far as I can tell, the datlastsysoid field does not exist in
pg_database.
If you build from CVS and do an initdb, you will find datlastsysoid should
exist...
There's bound to be a better way, but in the NT resource kit there was a
tool you can use to make any .exe a service.
I have a bash script running under Cygwin as a service here using it.
Peter
--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: [EMAIL PROTECTED]
WWW:
Guys, hello.
Here is a problem.
--
-- Creating 2 new functions and new type
--
BEGIN;
CREATE FUNCTION enum_week_in (opaque)
RETURNS int2
AS '
DECLARE
invalue ALIAS for $1;
BEGIN
IF invalue= OR invalue=''0'' THEN RETURN 0; END IF;
18 matches
Mail list logo
