Hi,
I have 2 versions of Postgres server 7.2 7.3.4 installed
on Linux server 7.3. I have not started the Postgres Server 7.2 which is located
at /var/library/pgsql.
I am running and using only 7.3.4 located at
/usr/local/pgsql.
After I login, I come to the /usr/local/pgsql/bin and then
On Sat, 20 Sep 2003 18:55:34 -0400, Kevin Houle [EMAIL PROTECTED]
wrote:
SELECT INTO result * FROM table_rates WHERE
effective_date = NEW.effective_date AND
expiry_date = NEW.expiry_date AND
cost = NEW.cost;
IF FOUND THEN
RAISE EXCEPTION ''record overlaps
On Monday 22 September 2003 10:01, Kumar wrote:
Hi,
I have 2 versions of Postgres server 7.2 7.3.4 installed on Linux server
7.3. I have not started the Postgres Server 7.2 which is located at
/var/library/pgsql.
RedHat 7.3 I guess you mean?
I am running and using only 7.3.4 located at
All
Hello, Now I'm upgrade postgresql from 7.2.1 to 7.3.3.
But It'can't use zero-length string . It raised error patoi zero-length
string.
I use redhat linux 7.3.
How to solve this problem.
Thanks
Chris.Wu
---(end of
While I issue
which pg_dump it is showed me
/usr/local/pg_dump
But how to run the backup utility pg_dump to backup my database.
- Original Message -
From: Richard Huxton [EMAIL PROTECTED]
To: Kumar [EMAIL PROTECTED]; psql [EMAIL PROTECTED]
Sent: Monday, September 22, 2003 3:20 PM
Dear Friend,
I understood what you are saying. But could you pls tell me how to change
the path of the pg_dump so that it should point to
/usr/local/pgsql/bin/pg_dump
Please help
- Original Message -
From: Kumar [EMAIL PROTECTED]
To: Richard Huxton [EMAIL PROTECTED]; psql [EMAIL
On Monday 22 September 2003 13:15, Kumar wrote:
Dear Friend,
I understood what you are saying. But could you pls tell me how to change
the path of the pg_dump so that it should point to
/usr/local/pgsql/bin/pg_dump
There's a guide on the Linux Documentation Project here:
Hi,
I have 2 versions of Postgres server 7.2 7.3.4 installed
on Linux server 7.3. I have not started the Postgres Server 7.2 which is located
at /var/library/pgsql.
I am running and using only 7.3.4 located at
/usr/local/pgsql.
After I login, I come to the /usr/local/pgsql/bin and then
1. How to select duplicate records only from a single table using a
select
query.
e.g.
select sid,count(sid) from location group by sid having count(sid)1;
Do you get the idea?
Your request is pretty unspecific, so if this is not what you're asking
for,
try again.
Regards, Christoph
On Mon, Sep 22, 2003 at 09:15:04 +0400,
sad [EMAIL PROTECTED] wrote:
On Saturday 20 September 2003 10:23, you wrote:
On Sat, 2003-09-20 at 06:10, Muhyiddin A.M Hayat wrote:
How to Create auto_increment field in PostreSQL.
Can I create them using Trigger.
Use the SERIAL datatype.
Hi all.
I have been doing a little research on how to do full text search under
postgresql, and GiST seems to be the way to go. But the documentation on
this is pretty lacking and I wonder if there are better sources that
describe the details on how to implement full text search with GiST.
On Monday 22 September 2003 16:02, Wei Weng wrote:
Hi all.
I have been doing a little research on how to do full text search under
postgresql, and GiST seems to be the way to go. But the documentation on
this is pretty lacking and I wonder if there are better sources that
describe the
The production server uses PostgreSQL 7.3.1 right now, so I am only
looking at contrib/tsearch.
I read through the README file. It only seems to offer a way to FTS
through one 'text' column in the table. How do I create a 'txtidx' column
that combines two or even more 'text' columns in the
Hi,
I would like to do the following using files:
1. put create database, create
tables sql statements in a file and execute through prompt
2. insert or update data that is
put in a file
Please let me know if there are any examples that lists how sql
statements can be
put in a
try psql -f filename
On Mon, 22 Sep 2003, Suresh Basandra wrote:
Hi,
I would like to do the following using files:
1. put create database, create tables sql statements in a file and
execute through prompt
2. insert or update data that is put in a file
Please let me know if there
Hi,
I would like to do the following using files:
1. put create database, create
tables sql statements in a file and execute through prompt
2. insert or update data that is
put in a file
Please let me know if there are any examples that lists how
sql statements can be put
in a
On Monday 22 September 2003 16:41, Wei Weng wrote:
The production server uses PostgreSQL 7.3.1 right now, so I am only
looking at contrib/tsearch.
I read through the README file. It only seems to offer a way to FTS
through one 'text' column in the table. How do I create a 'txtidx' column
On Monday 22 September 2003 09:41, Wei Weng wrote:
The production server uses PostgreSQL 7.3.1 right now, so I am only
looking at contrib/tsearch.
tsearch2 is compatible, and available for any version of PosgreSQL 7.3. It is
not included in the contrib directory. It is available in CVS head
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 19 September 2003 17:38, Tom Lane wrote:
Andreas Joseph Krogh [EMAIL PROTECTED] writes:
I usually backup my database with pg_backup without the -t option. But
now I need to only backup certain tables(say tab1 and tab2), is this
On 23 Sep 2003 at 0:34, Andreas Joseph Krogh wrote:
On Friday 19 September 2003 17:38, Tom Lane wrote:
pg_dump can only handle one -t option at a time. It'd make sense to
allow multiple -t options (likewise -n) but no one's got round to
improving the code in that particular direction. I
On Tue, Sep 23, 2003 at 12:34:00AM +0200, Andreas Joseph Krogh wrote:
I've never looked at the code-base of pgsql before, but I'll give it a try.
Don't expect anything real soon tho.
If you acheive to add the selection of tables to dump, you may
at the same time try to add a similar
I'll start by admitting that I've not looked at it myself yet but I'm
just wondering if any others have looked at this yet. A while ago we
migrated a complex web-app from Oracle to postgres. It went very well
when it came to replace 'connect by prior'. Because we were time poor
we couldn't spend
unsubscribe
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Merrall, Graeme wrote:
Am I right in thinking that recursive procedures and procs returning row
sets would allow us to better emulate this behaviour? As anyone looked
at it yet?
See connectby() in contrib/tablefunc. Someone was working on SQL99
recursive queries but it didn't get done for 7.4 --
1. put create database, create tables sql statements in a file and
execute through prompt
2. insert or update data that is put in a file
Place your commands in a file execute them either from the prompt or
from psql. Remember to create your file in the below order:
1) create database
2)
On Mon, 22 Sep 2003, Wei Weng wrote:
The production server uses PostgreSQL 7.3.1 right now, so I am only
looking at contrib/tsearch.
you may download tsearch2 for 7.3.X from
http://www.sai.msu.su/~megera/postgres/gist/tsearc/V2
I read through the README file. It only seems to offer a way to
26 matches
Mail list logo