[GENERAL] trigger functions with arguments

2009-06-05 Thread Kev
($a, $b) = @{$_TD-{args}}; # $a and/or $b may be null, depending on how CREATE TRIGGER was used ... I hope someone finds that helpful, Kev -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] indirect membership in group roles

2009-04-02 Thread Kev
ROLE statement, and worse, probably have to SELECT pg_has_role() first or be ready to do some error handling. All because the membership is indirect. Could someone explain the reasoning to me? Thanks, Kev -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

[GENERAL] [win32] 8.3.5 - 8.3.7 install trouble

2009-03-24 Thread Kev
I went to upgrade an installation and was stopped with (approximately) the following message after clicking Next on the step where I told it to use the same data directory: The existing data directory (date time: floating-point numbers) is not compatible with this server (date time: 64-bit

[GENERAL] array_cat null reasoning

2008-10-30 Thread Kev
inconsistent? If it does seem inconsistent, should I be careful how to code because this might change in the future? Thanks, Kev -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] boolean short-circuiting in plpgsql

2008-07-31 Thread Kev
'perform' statements? Is there no short-circuit option in plpgsql? Thanks, Kev -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Re: Upgreade 8.3.0 to 8.3.1 on windows: insufficient privileges to install system service

2008-05-15 Thread Kev
was on Terminal Services or not. Running TS using mstsc.exe /console (even within a session) worked for me. Peace, Kev -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] plperlu and perl 5.10

2008-04-09 Thread Kev
On Apr 8, 11:08 am, [EMAIL PROTECTED] (Alvaro Herrera) wrote: Kev escribió: Recompile PG? Even if I'm running 8.3.1, released well after that? Oh, sorry, do you mean, it's ready for 5.10 but still compiled with 5.8 for now? If so, is there a timeline for compiling with 5.10

Re: [GENERAL] plperlu and perl 5.10

2008-04-09 Thread Kev
On Apr 8, 11:48 am, [EMAIL PROTECTED] (Richard Huxton) wrote: Kev wrote: Recompile PG? Even if I'm running 8.3.1, released well after that? Oh, sorry, do you mean, it's ready for 5.10 but still compiled with 5.8 for now? If so, is there a timeline for compiling with 5.10 by default

Re: [GENERAL] drop database regardless of connections

2008-04-08 Thread Kev
); system('c:\program files\postgresql\8.3\bin\pg_ctl.exe kill TERM ' . $data[0]) == 0 or die(Couldn't kill process $data[0].); } $sth-finish; $r-print(All done.); Kev -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] plperlu and perl 5.10

2008-04-08 Thread Kev
On Apr 7, 10:37 am, [EMAIL PROTECTED] (Tom Lane) wrote: Kev [EMAIL PROTECTED] writes: I'm trying to upgrade to perl 5.10, and realized that plperlu is still using 5.8. How exactly does pgsql determine where to look/what version to use for plperlu? You need to recompile. You also need

Re: [GENERAL] plperlu and perl 5.10

2008-04-08 Thread Kev
Recompile PG? Even if I'm running 8.3.1, released well after that? Thanks, Kev Oh, sorry, do you mean, it's ready for 5.10 but still compiled with 5.8 for now? If so, is there a timeline for compiling with 5.10 by default in the production releases of pgsql? Thanks, Kev -- Sent via pgsql

Re: [GENERAL] drop database regardless of connections

2008-04-07 Thread Kev
On Apr 6, 1:34 pm, [EMAIL PROTECTED] (Craig Ringer) wrote: Kev wrote: So I tried to do this in Perl, but for some reason neither kill() nor Win32::Process::KillProcess() actually terminate the threads. Threads? Each backend is a distinct process. I haven't the foggiest why they might

[GENERAL] plperlu and perl 5.10

2008-04-07 Thread Kev
I'm trying to upgrade to perl 5.10, and realized that plperlu is still using 5.8. How exactly does pgsql determine where to look/what version to use for plperlu? Thanks, Kev -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

[GENERAL] drop database regardless of connections

2008-04-05 Thread Kev
like a basic thing to be able to drop a database unconditionally without restarting the service for people who are using other databases on the same service. Maybe I'm missing something that everyone else who asked about this eventually realized? Thanks, Kev -- Sent via pgsql-general mailing list

Re: [GENERAL] DML value format

2007-08-17 Thread Kev
properly for you. At least that's how it works with Perl and DBI. Kev ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] Using function like where clause

2007-08-09 Thread Kev
a function that will return a string to return the list of columns that I want to show like below? select my_function_making_list_of_columns() from table where field_test = 'mydatum' Thanks Look up the quote_ident() function in the docs, you'll likely need that for both cases. Kev

Re: [GENERAL] varchar(n) VS text

2007-06-29 Thread Kev
the client and pgsql? Kev ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] Incremental backups

2007-04-19 Thread Kev
entries. There's another thread starting about audit trails, you might want to check there. Kev ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Incremental backups

2007-04-19 Thread Kev
On Apr 19, 9:41 am, Kev [EMAIL PROTECTED] wrote: On Apr 17, 10:27 am, [EMAIL PROTECTED] (Mageshwaran) wrote: hi everyone, please any one give any methods to do incremental backups. it is urgent .. help me Regards J Mageshwaran Sorry, I don't have anything implemented, but I've been

Re: [GENERAL] pg_live

2007-04-09 Thread Kev
on a neighbouring computer and start creating tables and such. Very cool! Still not sure why my home PC doesn't like it though... Kev ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] pg_live

2007-04-02 Thread Kev
, Kev ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] cutting out the middleperl

2007-03-29 Thread Kev
Or SQL-on-rails http://www.sqlonrails.org/ LOL! merlin Heh heh...insufficiently AJAX-y ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED]

Re: [GENERAL] cutting out the middleperl

2007-03-29 Thread Kev
On Mar 27, 10:34 am, [EMAIL PROTECTED] (Aidan Van Dyk) wrote: Sounds something like mod_libpq: http://asmith.id.au/mod_libpq.html Thanks, I appreciate the link...also looks promising. Kev ---(end of broadcast)--- TIP 6: explain analyze

[GENERAL] database-wide triggers

2007-03-26 Thread Kev
Hi everyone, I heard Firebird has database-wide triggers, and I've seen mention of them on this newsgroup here and there. Is that on the map for implementation in pgsql? Thanks, Kev ---(end of broadcast)--- TIP 3: Have you checked our extensive

[GENERAL] cutting out the middleperl

2007-03-26 Thread Kev
publicly accessible on some port. Is that just asking for trouble? I appreciate any comments or thoughts anyone might have on this. Thanks, Kev ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http