Could someone help me and give me a basic example of
how to write a similiar functional function to the one
below that would use a dynamic table and update a
column only if it held a value.
I've been reading around and can't seem to find the
answer I'm looking for. I just need a simple examle to
Steve Crawford <[EMAIL PROTECTED]> writes:
> Is postgresql (or some parts thereof) now using relative pathing and
> has that behavior changed?
As of 8.0 we attempt to determine the libdir, sharedir etc as relative
to the location of the executable. So you can't just "cp" the PG
executables to so
On Friday 28 October 2005 19:18, you wrote:
> Try:
>
> /usr/local/pgsql/bin/initdb --no-locale -D /var/lib/pgsql/data
OK. That works (even without the --no-locale). Which makes me puzzled
and worried.The initdb I used and the one I used earlier are
identical (as verified by the fact that I copi
On Wed, Oct 19, 2005 at 16:22:29 -0400,
Chris Matheson <[EMAIL PROTECTED]> wrote:
> Hello list,
>
> I am working to format an interval in using the to_char() SQL function
> on postgresql 7.4.8. I've had nothing but disapointment so far.
> My confusion occurs when I'm trying to format using day
No problems. I am about to write a python script to cleanup the output of pg_dump. Before I do I just wanted to verify that there wasn't an already available script which I could feed directly into another ansi compliant database without modification. No sense reinventing the wheel. The output
J French <[EMAIL PROTECTED]> writes:
> I did read the page. Been there done that, ran the script. My question was
> if there was a canned script out there that I didn't have to clean up on the
> fly. This will be an cron job for a convoluted development process.
If your schema isn't using any non-
Martijn van Oosterhout schrob:
> On Sat, Oct 29, 2005 at 08:29:32PM +0100, mike dixon wrote:
>> I really love the "info" help system (don't know its name; "info
>> emacs" on cmd line if it's installed calls it up; filenames are
>> "texinfo-info*" for example); anyone know if info files are availab
J French <[EMAIL PROTECTED]> writes:
> I did read the page. Been there done that, ran the script. My question
> was if there was a canned script out there that I didn't have to clean up
> on the fly. This will be an cron job for a convoluted development
> process. Thanks though.
Yeah, that wo
I did read the page. Been there done that, ran the script. My question was if there was a canned script out there that I didn't have to clean up on the fly. This will be an cron job for a convoluted development process. Thanks though.
On 10/29/05, Douglas McNaught <[EMAIL PROTECTED]> wrote:
J
J French <[EMAIL PROTECTED]> writes:
> I need to capture the schema on a postgres database and recreate it on
> another ansi compliant platform. Is it possible to generate a file
> (perhaps from pg_dump?) as a sequence of ansi compliant SQL commands
> which can be used to recreate the structure?
I need to capture the schema on a postgres database and recreate it on another ansi compliant platform. Is it possible to generate a file (perhaps from pg_dump?) as a sequence of ansi compliant SQL commands which can be used to recreate the structure?
Thanks in advance!
On Sat, Oct 29, 2005 at 08:29:32PM +0100, mike dixon wrote:
> I really love the "info" help system (don't know its name; "info
> emacs" on cmd line if it's installed calls it up; filenames are
> "texinfo-info*" for example); anyone know if info files are available
> anywhere for pgsql? I looked at
I really love the "info" help system (don't know its name; "info emacs" on cmd
line if it's installed calls it up; filenames are "texinfo-info*" for example);
anyone know if info files are available anywhere for pgsql? I looked at what
gentoo's "emerge" installed and don't see anything...
Mike
Thanks for pointing me in the right direction. I read
about EXECUTE in the docs now.
> Most of the other PLs don't cache query plans
> at all, and so all queries are effectively EXECUTE'd
> and there's no issue.
I'm not sure what you mean...
Is there a more suitable LANGUAGE declaration you
wo
Bruno Wolff III wrote:
On Wed, Oct 19, 2005 at 14:36:46 +0200,
Marcel Gsteiger <[EMAIL PROTECTED]> wrote:
Hi all
Does anybody know how I could create a database function that accepts
an INET parameter and reverse-lookups the hostname via DNS PTR lookup?
Something like the dnsname command l
Matthew Peter <[EMAIL PROTECTED]> writes:
> Out of curiosity, I was wondering if it is possible to
> use dynamic table names in a function?
In plpgsql, you can do this by building dynamic query strings and
EXECUTE'ing them. Most of the other PLs don't cache query plans
at all, and so all queries
On Sat, Oct 29, 2005 at 10:45:21 -0700,
Matthew Peter <[EMAIL PROTECTED]> wrote:
> Out of curiosity, I was wondering if it is possible to
> use dynamic table names in a function? AND whether or
> not you can test a value prior to insert to see
> whether or not you want to update that column. Wher
Out of curiosity, I was wondering if it is possible to
use dynamic table names in a function? AND whether or
not you can test a value prior to insert to see
whether or not you want to update that column. Where
you could pass in the name of the table for it use ANY
name passed in rather than statica
On Wed, Oct 19, 2005 at 14:36:46 +0200,
Marcel Gsteiger <[EMAIL PROTECTED]> wrote:
> Hi all
>
> Does anybody know how I could create a database function that accepts
> an INET parameter and reverse-lookups the hostname via DNS PTR lookup?
> Something like the dnsname command line utility in the
Am Samstag, den 29.10.2005, 13:11 +0400 schrieb Zet:
> Hi
>
> Which charset is need to be set in database for cyrilic?
>
> I've used till now WIN, but today I found a problem
win?
>
> for example:
>
> SELECT *
> FROM table
> WHERE a = 'слово'
>
> returns me a record, where a = 'фраза'
>
> af
Hi,
I don't know where to submit enhancement requests. So I'm doing there.
I have to send error messages in several languages within PlPgSQL code.
I would like RAISE to work like that :
RAISE EXCEPTION get_my_format_string(MY_ERR_NBR,USER_LANG),a,b,a+b/c;
where the get_my_format_string returns
On Fri, Oct 28, 2005 at 06:22:43PM -, [EMAIL PROTECTED] wrote:
> This is postgresql 7.4
> I am trying to check that postgres is updating a table.
> I have a pretty large ascii table file (+- 210 Mb) which I am copying into a
> table with pgsql, but it is taking a long time, and any select quer
Please post questions to relevant lists. This question did not belong on
the patches list. I have moved the discussion to the general list.
Please don't reply to other threads to start new ones. This messes up the
archives and won't help people see your question.
On Mon, Oct 17, 2005 at 09:55:50
Zet,
there is pgsql-ru-general list (russian), btw.
see http://www.postgresql.org/community/lists/subscribe for
subscription info.
You did't get us enough info and examples (cut'n paste form psql would be
nice).
Oleg
On Sat, 29 Oct 2005, Zet wrote:
Hi
Which charset is need to be
blackwater dev wrote:
In MySQL, I can use the replace statement which either updates the
data there or inserts it. Is there a comporable syntax to use in
postgreSQL?
I need to do an insert and don't want to have to worry about if the
data is already there or not...so don't want to see if it th
Hi
Which charset is need to be set in database for cyrilic?
I've used till now WIN, but today I found a problem
for example:
SELECT *
FROM table
WHERE a = 'слово'
returns me a record, where a = 'фраза'
after I tried UNICODE
but for most of cyrilic words PG gives error like
"invalid byte seque
26 matches
Mail list logo
