I have a stored proc in which I want to retur the primary key of an insert
statement that the stored proc just ran. How can I do that?
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe
I have the following store dproc but when I run it I am
getting the error
ERROR: invalid input syntax for integer: "(1)"
CONTEXT: PL/pgSQL function "irispermissionget"
line 9 at return next
What am I doing wrong?
CREATE OR REPLACE FUNCTION
"public"."irispermissionget" (usern
: Thursday, June 30, 2005 5:20 PM
To: Jason Tesser
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] COnsidering a move away from Postgres
"Jason Tesser" <[EMAIL PROTECTED]> writes:
> Problem I ran your test and I am getting as error see below
This is an 8.1 feature not somet
OK I am an idiot you are running a cvs build I guess. Which at least
answers the problem.
---(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
ROR: CREATE FUNCTION / OUT parameters are not implemented
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 30, 2005 3:57 PM
To: Jason Tesser
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] COnsidering a move away from Postgres
Jason Tesser <
blo Baena
[mailto:[EMAIL PROTECTED]
Sent: Thursday, June 30, 2005
12:30 PM
To: Jason Tesser
Cc: Pgsql
Subject: Re: [GENERAL] Possible
move away from PG
If found this article of
help: http://www.onjava.com/pub/a/onjava/2003/08/13/stored_procedures.html?page=2
On 6/30/05, Jason
Tesser <
I understand the docs
> correctly you can even:
> CREATE FUNCTION foo(IN i int, OUT x anyelement, OUT y anyelement, OUT z
> anyelement) AS ...
>
> No custom type needed .. you specify how the output format in the
> argument section itself.
>
> Sven
--
Jason Tesser
D
HI
On Thursday 30 June 2005 9:20 am, Tom Lane wrote:
> Jason Tesser <[EMAIL PROTECTED]> writes:
> > 1. Our dev plan involves alot of stored procedures to be used and we have
> > found the way this is done in PG to be painful. (ie. To return multiple
> > record from d
I am not familar with how to do this. Could you give me an example of how
this could help?
>
> Have you considered returing refcursors instead of setof some type.
>
> Kris Jurka
--
Jason Tesser
Developer for NMI
[EMAIL PROTECTED]
Eph 2:8-10
---(end
un in Linux and the Linux version is pretty bad.
Thank you for any input and help,
--
Jason Tesser
Developer for NMI
[EMAIL PROTECTED]
Eph 2:8-10
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(s
x and the Linux version is pretty bad.
Thank you for any input and help,
Jason Tesser
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
HI
>
> Are you sure the issue is the change from PG7.4=>PG8.0, or have you
> upgraded your jdbc package at the same time?
I have upgraded the driver to the version that matched pg 8.0
> > Here is my prepared statment in my java class
> >
> > private static final String MANUALINSERT =
> >
nt(DATEOUTUPDATE);
stmt.setString(1, dateout);
stmt.setString(2, comment);
stmt.setString(3, pactimeid);
On Tue, 2005-06-21 at 09:07 +0100, Richard Huxton wrote:
> Jason Tesser wrote:
> > I just upgraded 7.4 to 8.0 and I have noticed that i am getting alot
> >
I just upgraded 7.4 to 8.0 and I have noticed that i am getting alot of error
that are saying i have a type problem. For example it is saying big int
expected but it was sent character varying. These same queries use to work in
7.4 I am using java and jboss. My queries are all dynamic sql in
>
> There's an example in the manuals - chapter "7.2.1.4. Table Functions"
>
> SELECT *
> FROM dblink('dbname=mydb', 'select proname, prosrc from pg_proc')
>AS t1(proname name, prosrc text)
> WHERE proname LIKE 'bytea%';
>
> So basically, you need to supply the type definition
rn next returnRec;
end loop;
return;
end;
'LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;
On Wed, 2005-03-16 at 13:51 +, Richard Huxton wrote:
> Jason Tesser wrote:
> > 1. i have a few funcions that depend on a type. i don't want t
Thank you,
Jason Tesser
---(end of broadcast)---
TIP 8: explain analyze is your friend
Can you insert and update data in views in 8.0 I know you cannot in 7.4. I
am asking because I want to make new structure for my backend but for legacy
apps I need to keep the old sturcture also. I was hoping to use views to
accomplish this by making the new structure and give the old apps v
I am new to postgres stored procedures and would like a
little help. My function basically takes 2 arguments and inserts data into a table
from a select statement. I want it to return the number of records inserted.
I am not sure what the best way to do this is. Here is my function
has no one been able to solve this problem?
-Original Message-
From: [EMAIL PROTECTED] on behalf of Jason Tesser
Sent: Thu 12/30/2004 9:30 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] pgodbc error
In my postgresql.conf I set it to log the query durations and this seems to
In my postgresql.conf I set it to log the query durations and this seems to
goof up odbc. I know this sounds stupid but I did a search and actually found
taht others have had the problem though I found no solution. I am running 7.4
on a suse 9.2 box. I have noticed that it appears to work on
e else had some options.
Our main platform is j2ee but we do flirt with php as well. all and all though
I liked pqa. Can it be run from windows?
-Original Message-
From: Lonni J Friedman [mailto:[EMAIL PROTECTED]
Sent: Thu 12/23/2004 10:39 AM
To: Jason Tesser
Cc: pgsql-general@post
/23/2004 8:50 AM
To: Jason Tesser
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] monitoring tools
Checkout pqa
On Thu, 23 Dec 2004 08:14:41 -0600, Jason Tesser <[EMAIL PROTECTED]> wrote:
> But that will just st in a huge tet sticks all data in text filess. I need a
> tool th
:-)
-Original Message-
From: Lonni J Friedman [mailto:[EMAIL PROTECTED]
Sent: Thu 12/23/2004 8:11 AM
To: Jason Tesser
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] monitoring tools
Sure, in postgresql.conf uncomment log_min_duration_statement and set
it to whatever value you
I am looking for a tool in postgres to monitor present and past activity. Foe
example in SQLServer there is a tool that reports on all queries run in the
past say 2 weeks and tells you how long they took etc.. I know I can use
explain in postgres but I want to be able to track my queries in a
PROTECTED]
Sent: Fri 10/15/2004 8:25 AM
To: Jason Tesser
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] converting database to unicode
On Fri, Oct 15, 2004 at 07:59:19AM -0500, Jason Tesser wrote:
> Some help please?? :-) Any
Some help please?? :-) Anyone?
-Original Message-
From: [EMAIL PROTECTED] on behalf of Jason Tesser
Sent: Wed 10/13/2004 10:00 AM
To: [EMAIL PROTECTED]
Cc:
Subject:[GENERAL] converting database to unicode
I have a database in sql_ascii that I need to convert to
I have a database in sql_ascii that I need to convert to Unicode. I tried using
pg_dump -Fc .. but it fails on certain characters. like this one "è"
How can I get the data transferred?
---(end of broadcast)---
TIP 8: explain analyze is your fri
1]
set database [lindex $argv 2]
set time [timestamp -format %M%H%d%m%Y]
spawn {pg_dump} -Fc --username=dbdevel
--file=/var/lib/pgsql/backups/$database.$time $database # expect
"Username:"
# send "$username\r"
expect "Password:"
send "$password\r"
expect eof
how
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: Thu 7/29/2004 7:56 PM
To: Jason Tesser
Cc: [EMAIL PROTECTED]
Subject:Re: [GENERAL] Wal logs
Jason Tesser wrote:
> This question may seem trivial but how do I rebuild a database with the
&g
This question may seem trivial but how do I rebuild a database with the
wal logs?
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
there something
in the background that Postgres is hanging on to after I renamed the
fields that is preventing me from restoring? How can I work around
this?
Thank you
Jason Tesser
Software Development
NMI 715-324-6900 x5273
---(end of broadcast
restore. Is there something
in the background that Postgres is hanging on to after I renamed the
fields that is preventing me from restoring? How can I work around
this?
Thank you
Jason Tesser
Software Development
NMI 715-324-6900 x5273
---(end of broadcast
> You didn't answer my question about whether they are the same types.
Are
> they?
Yes but testclass is a view. But the field it is referencing is of the
same type.
---(end of broadcast)---
TIP 7: don't forget to increase your free space map set
Hi
> > I have the below query written. I have removed a lot from the
select
> > Statement for simplicity sake. The query takes way too long.
> > I am moving from an Access backend to a Postgres back with
> > Access in the front. The below query is taking like 14-20 seconds.
> > Is their a bette
I have the below query written. I have removed a lot from the select
Statement for simplicity sake. The query takes way too long.
I am moving from an Access backend to a Postgres back with
Access in the front. The below query is taking like 14-20 seconds.
Is their a better way I can write the j
I am converting data from Access into Postgres and ran into
an issue with case sensitivity. Can I write queries in Access that will be case
insensitive without rewriting the queries.
So I would like to know if this be handled in Postgres or even if
someone knows in Access. Thank you.
> Anyone know of an open source (BSD, GPL) Content Managment System written in
> PHP that will use PostgreSQL, or at least use PEAR::DB or any other DB
> abstraction layer API?
I am currently writing one for use with Python and Postgres as I feel this
is the best way to go. I am using mod_pyhto
hi,
> Maybe there's not such a need for the advanced features of PostgreSQL
> amongst PHP programmers as you seem to believe. Most of the PHP stuff I've
> seen is read-only content display stuff and that doesn't really require a
> top-notch RDBMS; a more limited database should also be up to
> Please post a comprehensive description of what you're trying to do
> together with the configuration files you use.
I thought I did that sorry. I am trying to get Postgres to authenticate through Pam
so I can authenticate to Active
Directory on our network. All the steps I took are posted b
logging but I don't know if it is the same. Where can I find info about
disaster recovery in Postgres. Thank you in advance
for any info given.
Jason Tesser
Web/Multimedia Programmer
Northland Ministries Inc.
(715)324-6900 x3050
---(end of broa
sorry for teh double posting I forgot the steps at the end
OK I am still trying to get pam working
here is the messages I have is the log from trying to log in
Nov 26 08:55:16 localhost postgresql(pam_unix)[22693]: authentication failure;
logname= uid=26 euid=26 tty= ruser= rhost= user=cherrin
OK I am still trying to get pam working
here is the messages I have is the log from trying to log in
Nov 26 08:55:16 localhost postgresql(pam_unix)[22693]: authentication failure;
logname= uid=26 euid=26 tty= ruser= rhost= user=cherring
Nov 26 08:55:16 localhost pam_winbind[22693]: user 'cher
I am trying to authenticate POstgres using Pam. How do I do this. I tried using
webmin on RH9 and telling it
to use Pam for authentication but it doesn't seem to work.
Jason Tesser
Web/Multimedia Programmer
Northland Ministries Inc.
(715)324-6900 x3050
---(e
Hi,
On Fri, Nov 21, 2003 at 06:27:01AM -0600, Jason Tesser wrote:
> I am looking into using PostgreSQL on the backend here. I work for a Bible College.
> We are putting together a
> new software package. The database would be on a LInux box but our domain is M$ so
> w
applications that will both be
standalone and web what is teh best way for me to authenticate to active directory. C
Is there a Postgre function that will allow me to do this?
Does anyone have any other ideas that will work?
Thank you in advance for any feedback.
Jason Tesser
Web/Multimedia
I am looking at PostgreSQL as a possible option for our backend database. I am also
evaluating Oracle. What kind of paid
support does PostgreSQL offer?
Jason Tesser
Web/Multimedia Programmer
Northland Ministries Inc.
(715)324-6900 x3050
---(end of broadcast
47 matches
Mail list logo
