"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
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
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
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
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
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
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
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
> 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
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
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
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
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'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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
hello sir,
plz mail me how to copy format command from h.d.d.
to f.d.d.
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
> 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
-
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
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
"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 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
