"Andrew Snow" <[EMAIL PROTECTED]> writes:
> I am pretty sure there are some bugs in v7.1.x PL/PGSQL, they are difficult
> to produce and nail down though.
Especially if you don't even specify exactly which version you're using
;-)
Are you aware of the empty-SELECT-result-dumps-core bug in 7.1.1?
On Fri, 18 May 2001, R Talbot wrote:
> Why does there exist a binary rpm for Caldera eServer
> 2.3 but not for
> Caldera 2.3 edesktop or 2.4 edesktop. I want to install
> on edesktop.
> What are the differences and problems.
> I had read on the PostgreSQL site not to install eserver
> rpm on the
Lincoln Yeoh <[EMAIL PROTECTED]> writes:
> So what happens typically is:
> 1) open DB connection.
> 2) wait for http request.
> 3) rollback (to implicitly begin a new transaction so that 'now' isn't
> years ago :) ).
> 4) do DB stuff
> 5) rollback/commit.
> Would we get massive WAL growth if the
Why does there exist a binary rpm for Caldera eServer
2.3 but not for
Caldera 2.3 edesktop or 2.4 edesktop. I want to install
on edesktop.
What are the differences and problems.
I had read on the PostgreSQL site not to install eserver
rpm on the
edesktop,
"as there are differences"
I called Cal
> Puzzling
I am pretty sure there are some bugs in v7.1.x PL/PGSQL, they are difficult
to produce and nail down though. A few of my functions that were working
fine in v7.0.x broke completely. I am doing more testing and will submit
some bug reports...
- Andrew
-
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Is there a TODO item I can add here folks?
Hash-based aggregation. Isn't it on the list already?
regards, tom lane
---(end of broadcast)---
TIP 5: Have you checked our extensive
On Tue, 15 May 2001, Laurent Duperval wrote:
> Hi,
>
> I updated my source code from CVS and it looks like it creates a problem
> because now, the server won't come up because of this error:
>
> Starting postgresql service: + su -l postgres -c
> '/usr/local/bin/pg_ctl -D /usr/local/var/lib/pgsq
In article <989996977.1109.0.camel@tonux>, "Tony Grant"
<[EMAIL PROTECTED]> wrote:
>
> Funny thing is that SGI have rpms for RedHat XFS install... XFS is a
> server file system is it not?
>
I believe the XFS you are speaking of is the X Font Server. Not a file
system. Redhat does use ext2, th
hello sir,
plz mail me how to copy format command from h.d.d.
to f.d.d.
I had been using Postgres database version 6.5.3. Initially, I had the
problem of the data files growing very huge and thereby affecting the
performance of the database. However, on employing vacuum regularly, I
found that the size of files occupied on the disk would reduce except
for the INDEX
Greetings,
I'm quite new to news groups. I don't know how to visit some great
newsgroups as follows.
comp.unix.bsd.freebsd.misc
comp.unix.bsd.freebsd.announce
...
I'm quite interested in FreeBSD and PostgreSQL. Any more suggestions?
I just wonder where those news groups are situated. Please h
Thank you. It's better now.
"Tom Lane" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> "Ligia Pimentel" <[EMAIL PROTECTED]> writes:
> > I get the following error after 3 minutes...
> > FATAL 1: Memory exhausted in AllocSetAlloc()
> > What can I do?
>
> Update
hiroko wrote:
> from a DB table, I'd like to SELECT out the date of 3months before.
> the command should be
>
> => select * from MYTBL where time =XX ;
>
> what whould it like to be at X ?
Try this:
SELECT * FROM mytbl WHERE create_date > (now() - '3 month'::interval) ;
See date/time
On Wed, 16 May 2001 15:24:00 + (UTC), [EMAIL PROTECTED]
("Keith G. Murphy") wrote:
>Now, if we're talking clients, rather than a server, there'd be a better
>case for RH, though I'd probably not be persuaded. ;-)
>
My users want to keep their Windows workstations. They like Office,
god kno
I have the following structure:
create table _base (
abbreviation varchar(10),
short_name varchar(30),
full_name varchar(60)
);
create table tome ( id serial ) inherits ( _base );
create table book ( id serial ) inherits ( _base );
create table chapter ( id serial ) inherits ( _base );
cre
If a make a very simple query from the psql shell:
nuovo_mercato=> SELECT * FROM prezzi;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to th
Hello everyone:
I am a novice in postgreSQL.So i want to get ODBC driver
to connect with my program.Is there somebody can tell me
where the driver can download.Or how to connect postgreSQL
with PHP page in linux.Thanks.
--
JACKY HSU
Mail:[EMAIL PROTECTED]
Stu
IMN1=# explain select count(*) from grls WHERE active = 10;
NOTICE: QUERY PLAN:
Aggregate (cost=993.21..993.21 rows=1 width=0)
-> Seq Scan on grls (cost=0.00..992.44 rows=307 width=0)
IMN1=# explain select count(*) from grls WHERE popularity = 10;
NOTICE: QUERY PLAN:
Aggregate (cost=23.2
"Laurent Duperval" <[EMAIL PROTECTED]> writes:
> So does that mean that every time I update the CVS code I have to trash
> my existing data?
Anytime someone changes the system catalogs (which is frequently), yes.
Don't try to track CVS tip in a production installation, unless you
enjoy frequent d
This is a puzzle: I'm creating a small table that will have a single
column primary key, and a foreign key referencing another table. Here's
the SQL:
CREATE TABLE dogs
(
dog_id SERIAL CONSTRAINT ix_dogs_pk PRIMARY KEY,
owner_idSERIAL CONSTRAINT ix_dogs_1 REFEREN
agi_db=# create table analytics_budget
agi_db-# (
agi_db(# analytics_budget_id serial not null primary key,
agi_db(# triangulation int2,
agi_db(# sales_order_id int4 not null references
sales_order(sales_order_id) default
atoi(currval('sales_order_sales_order_id'))
agi_db(# );
NOTICE: CREATE TABL
Being new to postresql, I'm looking in to different ways of accessing the
database from java.
I'm interested in accessing postgres through a jdbc driver. The
driver from postgres does not seem to be fully implemented
(ie: Updatable ResultSets).
I've also tried configuring an odbc datasource an
I have been struggling with the use of cfinsert in some of the cf apps that
I am moving to linux... Does it work with postgresql? how?
Thanks!
--
Shannon Peevey
UNT-Central Web Support
[EMAIL PROTECTED]
940-369-7786
---(end of broadcast)---
TIP
Hi!
Here is a perl script that I stole from Henry Churchyard and a shell script
that I wrote to rewrite every file in a directory and replace a specified
string, etc. I am in the process of moving coldfusion apps to linux, and
am finding this invaluable. (I will post the shell script again
John Aughey wrote:
> I'm stress testing my application by creating large data sets. This
> particular query selects rows from the schedule table that have a specific
> owner_id. (I'll show you the results of explain)
>
> calendar=# explain select * from schedule where schedule.owner_id=101 or
I'v encountered a strange (to me) problem when running a 'select * from table' on a
table with approx 1/2 million rows from psql.
When I run the select *, I get the following message to stdout:
Backend message type 0x44 arrived while idle
Backend message type 0x44 arrived while idle
We have lost
INM1=# explain select ref_num from grls where ag_id in (24);
Index Scan using grls_ag_id on grls (cost=0.00..597.87 rows=849 width=12)
IMN1=# explain select ref_num from grls where ag_id in (select 24);
Seq Scan on grls (cost=0.00..992.44 rows=30195 width=12)
SubPlan
-> Materialize (cos
I'm stress testing my application by creating large data sets. This
particular query selects rows from the schedule table that have a specific
owner_id. (I'll show you the results of explain)
calendar=# explain select * from schedule where schedule.owner_id=101 or
schedule.owner_id=102;
Index S
Title: plperl in 7.1
I recently upgraded from 7.0.3 to 7.1. Everything went fine until I went to install plperl using createlang. It throws the following error message:
ERROR: Load of file /usr/local/pgsql/lib/plperl.so failed: /usr/lib/perl5/5.6.0/i686-linux/auto/Opcode/Opcode.so: undefine
In article <[EMAIL PROTECTED]>, Al Frick wrote:
> On Wed, 16 May 2001 15:24:00 + (UTC), [EMAIL PROTECTED]
> ("Keith G. Murphy") wrote:
>
>
>>Now, if we're talking clients, rather than a server, there'd be a better
>>case for RH, though I'd probably not be persuaded. ;-)
>>
> My users want t
Hello:
Is there a builtin mechanism for detecting trigger recursion or more
specifically
one trigger , causing another tables trigger to fire.
Example:
Table A is updated
Table A's update trigger executes
{
Updates the B table - (maintaining special RI etc.)
Table B's update trigger ex
> Inside a transaction,
>
> I insert a row into the table, with an autonumber id.
> Now I want to return the id of the newly inserted row. How can I do
> that?
>
> It seems that the first insert statement is not committed, and so the
> second statement couldn't return the newly id.
SELECT currva
Alex wrote:
> I've just install PostgreSQL 7.1.1 and noticed that timestamp have changed
> in this release.
> for example:
> CREATE TABLE "foo" ( test timestamp );
> if you "\d foo" you will notice the column test is not a timestamp, it's a
> "timestamp with time zone"
> anyway, how can I make a t
I have a function written in C that works well in PostgreSQL under Linux
but I have to move it into PostgreSQL under Windows NT.
I made dll with it by doing followed steps :
1) I added new function at the end of file
int WINAPI mydll_init(HANDLE h, DWORD reason, void *foo)
{
return 1;
}
2) I
hi all.
I'm here again.
to PostgreSQL DB, I'm using "vacuum" command in a file which
is executed at certain time
in a day by cron
the file is like follows;
psql inmsr <
delete from "TBL1" where "atime" <
'now';
commit;
delete from "TBL2" where "atime" < 'now';
commit;
delete
Al Frick wrote:
> I may try FreeBSD as the server. But I am a little confused. My
> clients want Windows on the work stations. Can this be done?
>
The PostgreSQL ODBC driver for win32 works fine. With packages like
MS-Access, Delphi, VB etc. you can write a client application and
connect t
On Tue, May 15, 2001 at 07:19:01AM -0400, D'Arcy J.M. Cain wrote:
> > Everybody is asking "What is the equivalent of Linux in SQL databases
> > ??"
> > The answer is "PostgreSQL" RDBMS server.
>
> Oh please. Can we stop trying to tie everything to the current front
> runner. I mean, PostgreSQL
37 matches
Mail list logo
