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
> 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) c
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 -- p
The world rejoiced as [EMAIL PROTECTED] (Christoph Haller) wrote:
>> 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,
unsubscribe
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
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
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 simila
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 direct
-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 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 he
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
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 i
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
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 tabl
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 d
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.
Tha
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
> 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
---
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 the
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:
http://www.tldp.
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" <[EMA
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:2
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 broadcast)---
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
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 ove
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 th
27 matches
Mail list logo