Hi,
Am 11/26/03 16:29 schrieb [EMAIL PROTECTED]:
Hi All
I am using postgresql 7.2 on Linux. It does not start when i am trying this
/etc/rc.d/init.d/postgresql restart.
It give an error saying "postmaster already running".
I have done
rm -f /var/lib/pgsql/data/postmaster.pid
and
rm -f /var/run/pos
On Wednesday 26 November 2003 16:20, [EMAIL PROTECTED] wrote:
> Hi All
> I am using postgres database. Users of the DB include Web users thro tomcat
> and internal user thr'o MS Access. The problem is the users of Access
> sometimes do not close these connections and postgres fails saying too
> man
On Wednesday 26 November 2003 15:40, Andreas Tille wrote:
> Hi,
>
> I want to write a function of the following type
>
>CREATE FUNCTION test ( )
> RETURNS setof MyTable
> AS
> 'SELECT * FROM MyTable WHERE id IN $1'
> LANGUAGE 'SQL' ;
Not as you've done it.
Hi All
I am using postgres database. Users of the DB include Web users thro tomcat
and internal user thr'o MS Access. The problem is the users of Access
sometimes do not close these connections and postgres fails saying too
many connections for the web users. Is there a way i can resolve this by
un
Thanks for the advice Tom. I figured out why my create trigger statement
wouldn't compile. Postgres expects a FOR EACH ROW or FOR EACH STATEMENT
clause before the EXECUTE portion. Oracle assumes a statement level trigger
unless you specify it to be for each row. In addition Oracle allows for
sp
Startup scripts for linux hanging around are sometimes
broken.
You better write your own.
O kyrios [EMAIL PROTECTED] egrapse stis Nov 26, 2003 :
> Hi All
> I am using postgresql 7.2 on Linux. It does not start when i am trying this
> /etc/rc.d/init.d/postgresql restart.
> It give an error sayin
Hi,
I want to write a function of the following type
CREATE FUNCTION test ( )
RETURNS setof MyTable
AS
'SELECT * FROM MyTable WHERE id IN $1'
LANGUAGE 'SQL' ;
I was not able to find a reference whether this is possible and if yes
how to specify the argumen
"Clint Stotesbery" <[EMAIL PROTECTED]> writes:
> I'm working on converting a simple trigger from Oracle to Postgres and I
> have a couple ofl questions that I need some help on please. First here's
> the Oracle trigger:
> CREATE OR REPLACE TRIGGER t_ship_date
> AFTER UPDATE OR INSERT OF order_da
Hi All
I am using postgresql 7.2 on Linux. It does not start when i am trying this
/etc/rc.d/init.d/postgresql restart.
It give an error saying "postmaster already running".
I have done
rm -f /var/lib/pgsql/data/postmaster.pid
and
rm -f /var/run/postmaster.pid
But it still says the same. whenever
I'm working on converting a simple trigger from Oracle to Postgres and I
have a couple ofl questions that I need some help on please. First here's
the Oracle trigger:
CREATE OR REPLACE TRIGGER t_ship_date
AFTER UPDATE OR INSERT OF order_date ON orders
BEGIN
UPDATE orders
SET ship_date = work
On Wednesday 26 November 2003 11:10, Kaloyan Iliev Iliev wrote:
> Hello Friends,
>
> I have the following questions.
> I have a lot of fields in my database that are int or float.
> The problem is that I need them to be only positive (unsigned) and the
> users try to insert sometimes negative.
[sni
Hello Friends,
I have the following questions.
I have a lot of fields in my database that are int or float.
The problem is that I need them to be only positive (unsigned) and the
users try to insert sometimes negative.
I know that I can make this with CHECK CONSTRAINT but for some reasons
this i
Thanks a lot. It worked.
- Original Message -
From: "Richard Huxton" <[EMAIL PROTECTED]>
To: "Kumar" <[EMAIL PROTECTED]>; "psql" <[EMAIL PROTECTED]>
Sent: Tuesday, November 25, 2003 9:44 PM
Subject: Re: [SQL] ::text problem
> On Tuesday 25 November 2003 12:37, Kumar wrote:
> >
> > SELEC
13 matches
Mail list logo
