Dirk Riehle <[EMAIL PROTECTED]> writes:
> I have a short CVS question please: How do I go from a particular file
> revision like
> pgsql/cvs/pgsql/src/backend/parser/parse_relation.c.1.3
> to the complete commit? I.e. I would like to navigate back from this
> particular file to the commit and see a
Hi,
thanks for answers!
I tried to rename the function
ALTER TRIGGER td_y ON child RENAME TO "BTD_Y";
with no help.
Also according to the manual BEFORE DELETE trigger should launch before
casading delete, so I changed the trigger
CREATE TRIGGER "BTD_Y" BEFORE DELETE ON chlid FOR EACH ROW
At 7:51 PM -0500 11/7/08, Tom Allison wrote:
adam_pgsql wrote:
When I do the install script in contrib it says I have no rights
to the directory. It was in /usr/local/pgsql/data/log and I
changed it to /usr/local/pgsql/log. It was set as root.wheel with
755 permissions so I suspect it's mad
"Teemu Juntunen" <[EMAIL PROTECTED]> writes:
> Also according to the manual BEFORE DELETE trigger should launch before
> casading delete, so I changed the trigger
> CREATE TRIGGER "BTD_Y" BEFORE DELETE ON chlid FOR EACH ROW EXECUTE
> PROCEDURE fn_td_y();
> with no help.
In that case your prob
Dirk Riehle wrote:
> Hi,
>
> I have a short CVS question please: How do I go from a particular file
> revision like
>
> pgsql/cvs/pgsql/src/backend/parser/parse_relation.c.1.3
>
> to the complete commit? I.e. I would like to navigate back from this
> particular file to the commit and see all the
Brent Wood <[EMAIL PROTECTED]> schrieb:
>
> Hi,
>
> I can specify the text used to represent a null value in output from copy,
> but I'd like to do something similar is select output, eg: all NULL values
> are represented by NA or NaN.
COALESCE:
test=*# select coalesce(NULL, 'NaN');
coalesce
Hello again,
my previous post wasn't answered. I think i told my question wrong :-).
I have a table like
a| b
'de' | Hallo welt
'en' | Hello world
How can I create a full text index over b?
CREATE INDEX idx ON table USING gin(
to_tsvector(
case
w
Hello,
I want to get an interval in months from two dates:
SELECT '2008-02-01'::timestamp - '2008-01-01'::timestamp AS '1 month'
Here I want '1 month' and not '31 days' as answer.
How can I do this?
Regards,
Gerhard
signature.asc
Description: Digital signature
On Sat, 8 Nov 2008 11:36:06 +0200
"Asko Oja" <[EMAIL PROTECTED]> wrote:
> Whenever asynchronous execution or batch processing is needed PgQ
> in SkyTools should be one option to be evaluated. It has PhP
> interfaces as well as tens of useful Python scripts.
Nice to know and really nice tool but i
Hi,
here is a complete example. With my Windows PostgreSQL 8.3.3 installation
this example leads to exception, because master has been deleted before the
child.
Teemu
--DROP TABLE master;
--DROP TABLE child;
--DROP FUNCTION fn_checkmaster()
-- The master table
CREATE TABLE master
(
foo sm
Garry Saddington <[EMAIL PROTECTED]> schrieb:
> Is there a way to grant all priveleges on all tables and sequences in a
> database at the same time?
No, but there are several solutions for that:
14:00 < akretschmer> ??grantall
14:00 < pg_docbot_adz> For information about 'grantall' see:
14:00 <
On Sat, Nov 8, 2008 at 12:40 PM, Ivan Sergio Borgonovo <[EMAIL PROTECTED]
> wrote:
> On Sat, 8 Nov 2008 11:36:06 +0200
> "Asko Oja" <[EMAIL PROTECTED]> wrote:
>
> > Whenever asynchronous execution or batch processing is needed PgQ
> > in SkyTools should be one option to be evaluated. It has PhP
>
Is there a way to grant all priveleges on all tables and sequences in a
database at the same time?
regards
Garry
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Gerhard,
Check out:
http://www.postgresql.org/docs/8.3/interactive/functions-datetime.html
In particular, look at 'age()' or 'justify_days()', but I think age() is
the one you want.
SELECT age('2008-02-01'::timestamp, '2008-01-01'::timestamp) AS "1 month"
Produces: "1 mon"
SELECT justify_d
Gerhard Heift <[EMAIL PROTECTED]> schrieb:
> Hello,
>
> I want to get an interval in months from two dates:
>
> SELECT '2008-02-01'::timestamp - '2008-01-01'::timestamp AS '1 month'
>
> Here I want '1 month' and not '31 days' as answer.
How long is a month? 28 days? 31 days? But okay, i will t
On 08/11/2008 12:29, Garry Saddington wrote:
> Is there a way to grant all priveleges on all tables and sequences in a
> database at the same time?
Not easily, AFAIK - this question comes up from time to time, and you'll
find in the archives examples of scripts that pull object names from the
sys
On Sep 29, 2008, at 4:59 AM, Chris wrote:
Matthew Wilson wrote:
I'm trying to comprehend how NULL values interact with unique
indexes.
It seems like I can insert two rows with NULL values in a column
with a
unique constraint just fine.
Is there something special about NULL? Can anyone post
On Sat, 08 Nov 2008 09:44:17 +0100
Andreas Kraftl <[EMAIL PROTECTED]> wrote:
> Hello again,
> my previous post wasn't answered. I think i told my question
> wrong :-).
>
> I have a table like
> a| b
>
> 'de' | Hallo welt
> 'en' | Hello world
>
> How can I create a full
Whenever asynchronous execution or batch processing is needed PgQ in
SkyTools should be one option to be evaluated. It has PhP interfaces as well
as tens of useful Python scripts.
On Sat, Nov 8, 2008 at 3:49 AM, Nikolas Everett <[EMAIL PROTECTED]> wrote:
> Authenticate in web app and drop a scrip
On Saturday 08 November 2008 13:01, Andreas Kretschmer wrote:
> Garry Saddington <[EMAIL PROTECTED]> schrieb:
> > Is there a way to grant all priveleges on all tables and sequences in a
> > database at the same time?
>
Thanks I've just installed pgAdmin and that has done the trick.
Regards
Garry
-
Good Morning Garry-
if you dont mind command line you can categorise your GRANTS into ROLES e.g.
CREATE role Name Identified BY OBAMA
then grant the necessary privs to that specific role
grant to role
then pass the granted tole to the user
grant role to user
WITH ADMIN OPTION allows the user
On Sat, 8 Nov 2008, Andreas Kraftl wrote:
Hello again,
my previous post wasn't answered. I think i told my question wrong :-).
I have a table like
a| b
'de' | Hallo welt
'en' | Hello world
How can I create a full text index over b?
use concatenation operator: tsvect
"Teemu Juntunen" <[EMAIL PROTECTED]> writes:
> -- Trigger at the child table
> CREATE TRIGGER "AFTER_DELETE_CHILD"
> AFTER DELETE
> ON child
> FOR EACH ROW
> EXECUTE PROCEDURE fn_checkmaster();
> -- This example leads to an exception
> INSERT INTO master (foo) VALUES (1);
> INSERT INTO chi
Andreas Kraftl <[EMAIL PROTECTED]> writes:
> CREATE INDEX idx ON table USING gin(
> to_tsvector(
> case
> when a = 'de' then 'german'
> when a = 'en' then 'english'
> else 'english'
> end
> ), b);
> This doesn't work. Error Message in german:
I'm glad to inform on completion of implementation of the SART system
in one of Polish banks.
The SART (System for Transaction Registry and Analysis) is a
Anti-money laundering (AML) system, used in data-gathering and
advanced analysis of bank transactions (including cash-flow chains),
in terms of
Am 2008-11-07 17:22:22, schrieb Andrei Kovalevski:
> Try to avoid storing any card and card holder info, and you definitely
> shouldn't keep in DB the whole data required to authorize transaction.
> Just take in mind how dangerous this info could be in case of security leak.
Yeah, at the German
Am 2008-11-07 07:51:37, schrieb Scott Marlowe:
> On Thu, Nov 6, 2008 at 2:27 PM, Michelle Konzack
> <[EMAIL PROTECTED]> wrote:
> >
> > * Do not Cc: me, because I READ THIS LIST, if I write here *
> > *Keine Cc:
Am 2008-11-07 09:53:07, schrieb Scott Marlowe:
> Oh, btw, the wikipedia page on the PCI standard I mentioned
>
> http://en.wikipedia.org/wiki/PCI_DSS
I know already...
But my question was about the Database Design to store the infos...
Thanks, Greetings and nice Day/Evening
Michelle Konzack
On Saturday 08 November 2008 4:37:57 pm Michelle Konzack wrote:
> Am 2008-11-07 07:51:37, schrieb Scott Marlowe:
> > On Thu, Nov 6, 2008 at 2:27 PM, Michelle Konzack
> >
> > <[EMAIL PROTECTED]> wrote:
> > > ***
> > >* * Do no
Am 2008-11-07 07:48:25, schrieb Scott Marlowe:
> On Thu, Nov 6, 2008 at 2:43 PM, Michelle Konzack
> <[EMAIL PROTECTED]> wrote:
> >
> > * Do not Cc: me, because I READ THIS LIST, if I write here *
> > *Keine Cc:
On Sat, Nov 8, 2008 at 6:14 PM, Michelle Konzack
<[EMAIL PROTECTED]> wrote:
> Am 2008-11-07 09:53:07, schrieb Scott Marlowe:
>> Oh, btw, the wikipedia page on the PCI standard I mentioned
>>
>> http://en.wikipedia.org/wiki/PCI_DSS
>
> I know already...
>
> But my question was about the Database Des
Am 2008-11-08 19:07:35, schrieb Scott Marlowe:
> No, your histrionics aside, it's the way this list works by default,
> and for good reason. If you need it to work differently, there's a
> setting which has been pointed out to you at two times now. Please
> take responsibility for your own life a
On Nov 8, 2008, at 8:10 PM, Michelle Konzack wrote:
Am 2008-11-08 17:03:39, schrieb Adrian Klaver:
See:
http://www.postgresql.org/docs/faqs.FAQ.html#item1.15
And what does this have to do with CC? The CCs come in without
passing the listserver and I do not want this mail!
I want only PM if
On Saturday 08 November 2008, Michelle Konzack wrote:
> Am 2008-11-08 19:07:35, schrieb Scott Marlowe:
> > No, your histrionics aside, it's the way this list works by default,
> > and for good reason. If you need it to work differently, there's a
> > setting which has been pointed out to you at t
Am 2008-11-08 17:03:39, schrieb Adrian Klaver:
> See:
> http://www.postgresql.org/docs/faqs.FAQ.html#item1.15
And what does this have to do with CC? The CCs come in without
passing the listserver and I do not want this mail!
I want only PM if I request it OR, in case of urgence!
So I add the ba
The only way to launch an ~asynchronous~ request from a web app is using
XMLHTTPRequest. That would be answered by a web server of
some sort. The server can launch any app you want - to run a sql
script, say. Authentication can be done with passwords, as usual.
Security may be an issue - you sh
On Sat, Nov 8, 2008 at 5:37 PM, Michelle Konzack
<[EMAIL PROTECTED]> wrote:
> Am 2008-11-07 07:51:37, schrieb Scott Marlowe:
>> On Thu, Nov 6, 2008 at 2:27 PM, Michelle Konzack
>> <[EMAIL PROTECTED]> wrote:
>> >
>> > * D
37 matches
Mail list logo
