=?iso-8859-1?Q?g=FCnter_strubinsky?= <[EMAIL PROTECTED]> writes:
> Sorry, wrong copy!
Okay, looking more closely, you've got two problems here:
> CREATE OR REPLACE FUNCTION public.norm(int8, record)
> RETURNS int8 AS
> ...
> LANGUAGE 'plpgsql' VOLATILE;
plpgsql functions don't support inputs
Hi all,
I have a question regarding psql. As I am more familiar with oracle I
can write the following select and make it rather flexible:
select name
from name_table
where person_id = &id;
The &id portion is what I am looking for in PostgreSQL. Basically when
running this query, the person runni
That sounds like a great solution...thank you! My win API knowledge is
weak, but I'll give it a try. Thanks again.
-Pete
-Original Message-
From: Shelby Cain [mailto:[EMAIL PROTECTED]
Sent: March 24, 2004 4:30 PM
To: Anony Mous; 'Dustin Sallings'
Cc: [EMAIL PROTECTED]
Subject: Re: [GEN
You could spawn pg_dump via CreateProcess and call
WaitForSingleObject() on the handle that CreateProcess
returns in a worker thread. When the Wait() function
returns, you can then call GetExitCodeProcess() on the
same handle to get the process exit code.
Just a thought.
Regards,
Shelby Cain
This is an example of what I mean :
1) Fill out form to get data.
2) Server responds with java and set of records.
3) Java applet displays one of the records and with out further
intervention from the
server, tha java applet can be used to scroll back and forth through the
other records.
Becaus
On Thu, 25 Mar 2004, Grace C. Unson wrote:
> Hello.
>
> How is it possible that ResultSetObjInstance in this statement
>
> ResultSetObjInstance = PreparedObjInstance.executeQuery()
>
> contains this column and value respectively:
>
> TRANSACTION ISOLATION LEVEL , READ_COMMITTED ?
>
> ---
>
> -Original Message-
> From: Shachar Shemesh [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 25 March 2004 05:39
> To: Grant Allen
> Cc: [EMAIL PROTECTED]; PostgreSQL OLE DB development;
> [EMAIL PROTECTED]
> Subject: Re: [GENERAL] ole db
>
>
> Grant Allen wrote:
>
> >It's a dead project ...
Sorry, wrong copy!
-- Function: public.norm(int8, record)
-- DROP FUNCTION public.norm(int8, record);
CREATE OR REPLACE FUNCTION public.norm(int8, record)
RETURNS int8 AS
'
declare
prim alias for $1;
catrec alias for
=?iso-8859-1?Q?g=FCnter_strubinsky?= <[EMAIL PROTECTED]> writes:
> currrec record;
^^^
> select * into currec from denorm where theKey=catrec.cat1;
^^
> Where am I going wrong;
Count the "r"s ...
regards, tom lane
--
Is there anyone using object table in Oracle? How does it differ from
table inheritance in PG (aside from the declaration syntax).
I actually just found out about table inheritance today, and absolutely
love it! However, it's a shame if this feature is totally unportable.
Are there any other po
Andrew Dunstan wrote:
(btw, if you want to work offline, which i saw referred to a couple of
times, wouldn't cvsup do most of the job?).
From what I understand, a "distributed" source control means each
developer gets his own _repository_, not just a working copy. This means
you can commit to yo
The example does not make a lot of sense; it has been created for
demonstration purposes only:
-
-- One Table:
-- Table: public.denorm
-- DROP TABLE public.denorm;
CREATE TABLE public.denorm
(
thekey int8 NOT NULL DEFAULT nextval('publ
Thanks, but I’m calling a win32
compiled version of pg_dump, which runs asynchronously to the rest of my code
(sorry I was vague in my first message). As such, I don’t see how I
can use the return value. My only other thought was to check for the
existence of the file, which would be usel
On Fri, 19 Mar 2004, Carmen Gloria Sepulveda Dedes wrote:
> Hi.
>
> I want to install postgres 7.4.2 on solaris 9.
>
> I configure with: ./configure --enable-thread-safety
> and it works fine (no error).
>
> When I do "gmake", I get this error:
>
> thread.c: In function `pqGetpwuid':
> thre
On Mar 24, 2004, at 11:42, Anony Mous wrote:
I’m running pg_dump 7.3.4. I have a nightly process that dumps a database via pg_dump, and then checks for the existence of the dumped file afterwards to confirm that the dump actually occurred. Just wondering, however, if a corrupt disk prevented pg
Hi,
I’m running pg_dump
7.3.4. I have a nightly process that dumps a database via pg_dump, and then
checks for the existence of the dumped file afterwards to confirm that the dump
actually occurred. Just wondering, however, if a corrupt disk prevented pg_dump
from executing fully, wou
> > Is there any way to treat it like an inline function so that I could write
> > something like the following (highly simplified):
>
> I think 7.4 will inline simple SQL functions. Your CASE looks like a good
> candidate.
>
> >select case when A=1 then 1 when B=1 then 2 else null end
> >
Bill Harris <[EMAIL PROTECTED]> writes:
> I asked on cygwin but no answer yet; maybe someone here knows.
>
> I've been running PostgreSQL 7.4.1 successfully for a few weeks under an
> updated cygwin, but it stopped working over the weekend. That happened
> to be the time XP Pro decided my postgr
Grant Allen wrote:
It's a dead project ...
Used to be dead. Not any more.
I couldn't find any useable output (that's more an indictment of my coding skills than anything else).
Then you haven't tried over the past month or two. The version released
there already has some results support. The
You have to update the credentials stored in the
service configuration.
Start->Run->services.msc->[service name]->Logon
Regards,
Shelby Cain
--- Bill Harris <[EMAIL PROTECTED]>
wrote:
> I asked on cygwin but no answer yet; maybe someone
> here knows.
>
> I've been running PostgreSQL 7.4.1 suc
On Wednesday 24 March 2004 16:33, Mike Nolan wrote:
>
> Is there any way to treat it like an inline function so that I could write
> something like the following (highly simplified):
I think 7.4 will inline simple SQL functions. Your CASE looks like a good
candidate.
>select case when A=1 th
Hello.
How is it possible that ResultSetObjInstance in this statement
ResultSetObjInstance = PreparedObjInstance.executeQuery()
contains this column and value respectively:
TRANSACTION ISOLATION LEVEL , READ_COMMITTED ?
---
Note:
During the query operation, lots of write operations are going
scott.marlowe wrote:
On Tue, 23 Mar 2004, Tom Lane wrote:
Bill Moran <[EMAIL PROTECTED]> writes:
Was this true for some previous version? I could have swore I read somewhere
that vacuum_mem had to be set high enough or vacuum wouldn't be able to clean
everything up (aside from anything locked in
Thisa is probably the wrong forum for this question. But perhaps I could
be pointed to the correct forum.
I am in the final stages of converting an Oracle database to
PostgreSQL. I have just received the Perl script which will drive the
application and call my stored functions.
When the store
Hi,
I just discovered that perl module: DBIx::SearchBuilder 0.97
has a LoadByCols() method that builds a generic SELECT
query that seems to assume '' is a valid value to test on
any field. (The code is :
--
sub LoadByCols {
my $
I asked on cygwin but no answer yet; maybe someone here knows.
I've been running PostgreSQL 7.4.1 successfully for a few weeks under an
updated cygwin, but it stopped working over the weekend. That happened
to be the time XP Pro decided my postgres password should expire. I
gave it a new passwor
On Wednesday 24 March 2004 14:15, Tatsuo Ishii wrote:
> > I received a unicode CSV file from someone (the file was created on a
> > windows system) and I'm trying to import it into postgresql. When it gets
> > to a line that isn't ascii it prints the following error and aborts:
> > "ERROR: copy:
Periodically I need to write a complex case statement that I'd like to
be able to refer to in more than one place in a SQL command without having
to make sure that each copy of the case statement remains the same as
the query (to produce a mailing) is tailored.
Is there any way to treat it like an
It's a dead project ... I couldn't find any useable output (that's more an indictment of my coding skills than anything else). I signed up and contacted the other two developers listed, but never got a response. If you're keen on the OLE DB / ADO play ground, you'll need to use the OLEDB-ODBC br
On Tue, 23 Mar 2004, Tom Lane wrote:
> Bill Moran <[EMAIL PROTECTED]> writes:
> > Was this true for some previous version? I could have swore I read somewhere
> > that vacuum_mem had to be set high enough or vacuum wouldn't be able to clean
> > everything up (aside from anything locked in transac
> El Mié 24 Mar 2004 10:25, [EMAIL PROTECTED] escribió:
>> But still is this considered secure?
Why would you think it's any less secure than your localhost (TCP)
entry?
It's fairly easy to configure a Unix-domain socket to be *more* secure
than TCP, because you can use file permissions to li
> I received a unicode CSV file from someone (the file was created on a
> windows system) and I'm trying to import it into postgresql. When it gets to
> a line that isn't ascii it prints the following error and aborts: "ERROR:
> copy: line 33, Invalid UNICODE character sequence found (0xd956)". W
32 matches
Mail list logo
