($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
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
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
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
'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
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
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
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
);
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
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
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
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
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
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
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
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
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
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
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
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
,
Kev
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
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]
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
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
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
25 matches
Mail list logo