Hi:
I'm using postgresql 7.1 release 1 on RH 7.1.
I need to register all the operations (INSERT/UPDATE/DELETE) that users
does.
Something like an log file for the backbone (like a /var/log/messages,
where all done is registered).
Can any help/explain me for doing this?
Thanks.
--
SAMTEK, C
On Thu, 2003-01-16 at 17:15, Tim Lynch wrote:
> from two tables both with email_addr columns, i want a distinct list of all
> email_addrs in one column. what i do now is select distinct on each and then
> sort -u the results.
You want either pgsql-sql or pgsql-novice, both of which are mailing
lis
I'd suggest something similar to, but slightly different from, what others
have:
SELECT DISTINCT email FROM (SELECT email FROM table_1 UNION SELECT
email FROM table_2) AS combined;
that way you avoid duplicates across tables.
--
On Fri, Jan 17, 2003 at 08:57:14 -0500,
Andrew Perrin <[EMAIL PROTECTED]> wrote:
> I'd suggest something similar to, but slightly different from, what others
> have:
>
> SELECT DISTINCT email FROM (SELECT email FROM table_1 UNION SELECT
> email FROM table_2) AS combined;
>
> that way you
Hey, thanks - nice to learn something.
ap
--
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
[EMAIL PROTECTED] * andrew_perrin (at) unc.edu
On Fri, 17 Jan 2003, B
On Wed, Jan 15, 2003 at 04:08:40PM +0700, Yudha Setiawan wrote:
> Somebody gimme your hand plz.
>
> Using my previous Database I used to be like that;
> " ALTER TRIGGER tr_T_DtlPO ON dbo.T_DtlPO FOR UPDATE AS
> bla..bla..bla...
> IF @OldQty <> @NewQty BEGIN
> ROLLBACK
> INSERT INTO T
On Fri, 17 Jan 2003, Bruno Wolff III wrote:
> On Fri, Jan 17, 2003 at 08:57:14 -0500,
> Andrew Perrin <[EMAIL PROTECTED]> wrote:
> >
> > that way you avoid duplicates across tables.
>
> The union operator already removes duplicates.
Right, which means everyone's UNION queries have too many DIS
"Ross J. Reedstrom" <[EMAIL PROTECTED]> writes:
> On Fri, 17 Jan 2003, Bruno Wolff III wrote:
>> The union operator already removes duplicates.
> Right, which means everyone's UNION queries have too many DISTINCTs
> in them:
Relevant to this thread: if you don't want duplicate removal, write
UNIO
Hi, I am trying to get 7.3.1 running on my Sun server. It all seemed to
install ok, but when running initdb I get this appearing
bash-2.03$ /usr/local/pgsql7.3.1/bin/initdb -D /usr/local/pgsql7.3.1/data/
The program
'/usr/local/pgsql7.3.1/bin/postgres'
needed by initdb does not belong to Pos
Look in postgresql.conf for something like debug_print_query or
something like that. 7.1 is pretty old, but I am sure it is there
somewhere.
---
SAMTEK Consultores wrote:
> Hi:
>
> I'm using postgresql 7.1 release 1 on RH
I am using PostgreSQL 7.3.1 and wanted to know if XA
datasources are supported under PostgreSQL? If yes,
where can I get the JDBC drivers?
TIA.
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-
hi guys
i have a few security concerns about postgres database and would like
to know if there is a possibility to compile postgres a way he only
accepts password athentication , and ignores the pg_hba.conf file
any ideas ?
I hope to get an answer
lg
hubert
***DISclaimer***
hiermi
hubert baumgartner <[EMAIL PROTECTED]> writes:
> i have a few security concerns about postgres database and would like
> to know if there is a possibility to compile postgres a way he only
> accepts password athentication , and ignores the pg_hba.conf file
> any ideas ?
I suppose you could
13 matches
Mail list logo
