This is really a scattershot question because I have little exposure to ORMs
and only vaguely formulated requirements.
Some background...I like postgresql a lot and also use sql server and
oracle. I/we are usually responsible for all of the parts of an app, from
the rdbms to the user interface. W
The error went away; I updated the admin tool I use (pg lightning admin) and
that seemed to help.
Thanks everyone.
Julius Tuskenis-2 wrote:
>
> Raymond O'Donnell rašė:
>> A lot of previously automatic casts were removed in the 8.3 series -
>> this is possibly one of them.
>>
>> You now need t
I have restored a postgres 8.2.4-1 db onto a postgres 8.3.1-1 server, and
when I try to work with a table I get this error:
Error: Operator does not exist: "char" = integer
Hopefully that is enough of a clue to be useful. Maybe this is the first
time I've tried moving one of my non-trivial pg pr
My project is currently SQL_ASCII encoded. I will need to accomodate both
French and Spanish in addition to English. I don't anticipate needing Far
East languages. Reading here on the forums I come up with Latin9 as perhaps
adequate. But others recommend unicode for relatively simple needs like my
interested in seeing someone's
mature system for returning the user's local time based their tz as stored
in their profile.
But since no one has agreed with my positing of that approach so far I'm not
sure. I'll see what I can figure out with a bit of testing etc.
Thanks ever
now() and localtime() is good...but localtime() to
postgres acting as a web app db, wouldn't it just return the local time as
far as the server is concerned?
Martijn van Oosterhout wrote:
>
> On Mon, Sep 10, 2007 at 07:46:17AM -0700, novnov wrote:
>> But 'apps all know to
-----
> Hash: SHA1
>
> On 09/09/07 22:29, novnov wrote:
> [snip]
>>
>> But it doesn't particularly make sense to set the server's clock to UTC.
>> It'd seem to skew a lot of server functionality which I'd think should
>> normally be geared a
Time zones are a new issue for me. I have read around a bit and learned some.
I have a bunch of questions still because I've not found a really good
overview of how all of the factors tie in together.
At this time my app will be hosted on a server at a single location. Users
will be updating and
eplication system he's
referencing, maybe Slony-I?
Trevor Talbot-2 wrote:
>
> On 9/8/07, novnov <[EMAIL PROTECTED]> wrote:
>
>> But basically, it seems that the answer to one of my questions is that
>> there
>> is currently no way with postgres to spread a si
here
is currently no way with postgres to spread a single database over multiple
servers, ala a loadbalanced apache cluster, where requests are forwarded to
different boxes.
It's not going to be an issue for me soon, maybe ever, I just wanted to see
what the score is.
Scott Marlowe-2 wrot
the data
can be partitioned to different servers, it must mean that at least under
some cirucumstances, postgres can do this. If you or anyone can tell me more
about that or point me to some resources, it'd be great.
Thanks for the info
Scott Marlowe-2 wrote:
>
> On 9/8/07, novno
egular
databases.
If I have a database that records 100 trx a second, I'm pretty sure postgres
would support splitting off aggregation services to another box. But what if
the 'main' database has to keep scaling? Can the 'main' database be
supported by multiple boxes?
What happens when a database needs to scale beyond a single server? Is this
something PostgreSQL can do?
Further, does a database need to be designed differently if it's going to be
used on more than one server? I know there are many issues that might effect
a database's ability to scale; but sp
, and schedule all show as enabled. But it never runs. I've
even restarted postgres...what else could be involved?
Dave Page-3 wrote:
>
>
>
>> --- Original Message ---
>> From: novnov <[EMAIL PROTECTED]>
>> To: pgsql-general@postgresql.org
>&
a
different manner.
I really appreciate you postgres pros taking the time to respond to the
varous newb questions that get posed here.
Tom Lane-2 wrote:
>
> novnov <[EMAIL PROTECTED]> writes:
>> The function is meant to find a value via the internal sql, and then
>> u
that a non-workable scenario? IE, an after insert trigger can't modify a
column in the same table that was updated?
Martijn van Oosterhout wrote:
>
> On Wed, Aug 08, 2007 at 03:20:00PM -0700, novnov wrote:
>>
>> I know that would be best but it'd be a major undertaking to
ion, thus order
matters, and the name is relatively light duty property? Maybe too hard to
explain it in simple terms.
Decibel! wrote:
>
> On Tue, Aug 07, 2007 at 02:28:20PM -0500, Tony Caduto wrote:
>> Gregory Stark wrote:
>> >"novnov" <[EMAIL PROTECTED]> wr
Can someone give me a simple example of the way in which I might be able to
call a stored procedure or query using pgagent? I have never scripted a
postgres .sql etc to run via cron or pgagent and an example of the syntax
would be helpful. In pgagent terms, the Step is set up as SQL, and it's the
I know that would be best but it'd be a major undertaking to try to repro
this situation. I was hoping for some hints, 'it sounds like xyz', because
I'm pretty sure I'm just tripping over a commonplace issue.
Rodrigo De León-2 wrote:
>
> On Aug 8, 3:20 pm, [
I have a trigger function that updates a field in the update/insert table
which uses a not so simple sql statement to find the value to update with. I
am not getting the results I expect. I expect I'm falling into some classic
trigger gotcha.
The table being updated is for 'bids'; 'bids has a fke
engine, in
this case. Views don't help solve the basic issue. It's not a fatal issue,
just one that would help streamline postgres, IMO.
Josh Trutwin wrote:
>
> On Tue, 7 Aug 2007 11:07:39 -0700 (PDT)
> novnov <[EMAIL PROTECTED]> wrote:
>
>
>
>> Is th
One of the few problems I have with postgres is that one is stuck with
columns ordered by time of creation, unless one resorts to dropping the
table and rebuilding from ddl. If you have data and a bunch of contraints,
it's not simple. It's not a critical capability either, but reordering
columns i
contrib-8.2
was installed by synaptic.
李彦 Ian Li wrote:
>
> You may import the adminpack.sql come with the -contrib-8.2 package
> to create those administrative functions.
>
> Regards
>
> novnov wrote:
>> I installed 8.2 on ubuntu 6.10 using the backport a while ago. In
hat would bring
the extended server status functionality with it?
novnov wrote:
>
> Thanks all of you. It does seem like the backport is the way to go.
>
> So now I have 8.2 and some new postgres/linux newb questions.
>
> I can safely remove 8.1 after moving data usin
The answer may or many not be very postgres specific but...what are some
possible routes that I could take to allows users to upload data from excel
into a postgres via a website? I've never tried anything like this before.
Are there standard modules that might help with this or will I have to
cre
e now that it's a link to a file
called postgresql-8.2-main.log), which seems to have been created by the
installer, and the new one that is being written to pg_log.
Thanks
Tom Lane-2 wrote:
>
> novnov <[EMAIL PROTECTED]> writes:
>> * Error: Could not create log file
>&
file
that was already there and the one that I'm trying to create via the conf
file mods?
novnov wrote:
>
> I am rather unsure of postgres logging, but I think the way to go is to
> unrem some of the lines in postgresql.conf, restart the db. Now I get
> this:
>
> * Starti
I am rather unsure of postgres logging, but I think the way to go is to unrem
some of the lines in postgresql.conf, restart the db. Now I get this:
* Starting PostgreSQL 8.2 database server
* Error: Could not create log file
/var/lib/postgresql/8.2/main/pg_l
Thanks all of you. It does seem like the backport is the way to go.
So now I have 8.2 and some new postgres/linux newb questions.
I can safely remove 8.1 after moving data using synaptic, ie 8.2 shouldn't
be dependent on 8.1 at all?
I don't understand how postgres is installed with these packa
I have postgres 8.1 installed on ubuntu 6.10 via synapic package manager. I
would like to install 8.2, but it's not offered in the list. I think 8.2 is
offered on 7.x ubuntu, and I wonder if 8.2 will be offered on 6.10? Probably
the recommondation will be to compile 8.2 on 6.10, but I've only used
Perfect, thanks
Michael Fuhr wrote:
>
> On Mon, Jun 18, 2007 at 06:07:37PM -0700, novnov wrote:
>> First, when a record is being deleted, OLD refers to the rec just deleted
>> (or about to be deleted)?
>
> Correct.
>
>> Second, while I could write two tr
Most of the trigger fuctions I've written work on new and updated records
referencing NEW. etc. I will need some of the trigger functions to work with
record deletions too.
First, when a record is being deleted, OLD refers to the rec just deleted
(or about to be deleted)?
Second, while I could
7; || "pint_org_id" || ' and item_active = ' ||
strActive ||
' ORDER BY ' || "pstr_orderby";
OPEN ref FOR EXECUTE strSQL;
RETURN ref;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
Alvaro Herrera-7 wrote:
>
> novnov escribió:
While a hard coded order by clause works; passing the order by as a param is
ignored as I've implemented below. The order by value is being passed as
expected (tested by outputing the value in a column). I've called like so:
ups=# begin;
BEGIN
ups=# select proc_item_list(1,true,'item_id');
pr
Right...I see I'd left BEGIN; off after the first couple of trys.
Thanks
Alvaro Herrera-7 wrote:
>
> novnov escribió:
>>
>> I have been able to run a test like you have in a query (if that's the
>> right
>> term), and ORDER BY does work. When trying t
--
(1 row)
ups=# fetch all from "";
ERROR: cursor "" does not exist
ups=#
Michael Fuhr wrote:
>
> On Tue, May 29, 2007 at 05:18:42PM -0700, novnov wrote:
>> It seems that at least in the way I've written the function below, ORDER
>> BY
>> i
s with executing the
proc in postgres directly. I think the example you've provided here may help
me.
Thanks to both of you.
Michael Fuhr wrote:
>
> On Tue, May 29, 2007 at 05:18:42PM -0700, novnov wrote:
>> It seems that at least in the way I've written the function be
It seems that at least in the way I've written the function below, ORDER BY
is ignored. I've seen hints that one can declare the refcursor as a specific
query and that apparently the order by clause there is respected. But I
don't find much by way of examples in the docs or on this list. I will
ev
I've written many stored procedures in ms sql and a good many functions in
postgres, but I'm rather unsure of how to get a list back from a postgres
function which is not based on a table. Example from sql server:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[procPatient]
oastatus_id)=3)
> AND ((t_item.item_org_id)=int_org_id)
> AND (t_koaitem.koaitem_item_id IS NULL AND
> koaitem_item_id
> IS NULL)
> );
>end if;
>return null;
>
> END;
> $BODY$
> LANGUAGE '
o this
kind of thing with other databases; essentially instruct the routine to
ignore errors silently, commit what it can commit.
Raymond O'Donnell wrote:
>
> On 21/05/2007 05:26, novnov wrote:
>
>> OK, but, how do I set this up to do what I need? I want an insert that
>>
OK, but, how do I set this up to do what I need? I want an insert that would
create a dupe key to be rolled back, and inserts that would not create dupe
keys to be committed.
Tom Lane-2 wrote:
>
> novnov <[EMAIL PROTECTED]> writes:
>> Any clue re my question?
>
>
It's an after trigger.
Any clue re my question?
Alvaro Herrera-7 wrote:
>
> novnov escribió:
>>
>> Inching closer; the following handles the dupe key error but doesn't
>> insert
>> the rows it should either. So, the exception is ending the insert, and
Inching closer; the following handles the dupe key error but doesn't insert
the rows it should either. So, the exception is ending the insert, and not
continuing to insert for rows that don't violate the unique key restraint.
Is there a way around this or will I need to take a different approach?
So, I may have hammered out the basic trigger function. The error trapping
part is a complete mystery to me. I'll post the trigger function below in
the hopes that someone will at least comment on the error handling part.
The error, as expected is 'duplicate key violates unique contraint blah
bla
Not sure it the title of this post gives a clear message...I need to have a
trigger function insert records into a table under certain conditions, where
the values inserted are partially based on the results of a select query.
table t_item
item_id (pk)
item_name
item_org_id
item_active
table
It wasn't a vista failing or complication - I should have used the machine
name for Account name, not localhost...sorry for cluttering up the list.
--
View this message in context:
http://www.nabble.com/Installation-fails-on-windows-vista-tf3724831.html#a10424989
Sent from the PostgreSQL - gene
Note I'm accepting all other defaults for the postgres installation, cluster
etc. There is no existing postgres install on the machine, though there was
before. I have noticed that when the postgres user is created by the
installer, it's not a member of any group. Even if I add it to the admins
gr
For some reason a fresh install of python made a difference...now at least
the plpython checkbox is enabled. But per my other post today I can't get it
to install on vista at all now.
--
View this message in context:
http://www.nabble.com/Windows-installation--why-is-PL-python-shown-but-disabled
I needed to reinstall postgres on a box and so far have had no success. I
have UAC disabled. I enter localhost, password, ask it to create the
postgres user when prompted. The user I'm installing as has admin rights on
the notebook (same user as postgres was originally installed under). I get
vari
I have python 2.4 installed; python24\lib in the path; why is the PL\python
option presented but disabled in 8.2 postgres installer? There must be some
conditions under which it (and the other langs) are enabled. The only one of
the 7 show that is enabled is PL/pgsql. I've found this to be true fo
I see...well, that's excellent. Thanks to all who responded.
Reece Hart wrote:
>
> On Tue, 2007-05-01 at 07:38 -0700, novnov wrote:
>> I didn't express myself clearly. Is there an IIF type function one can
>> use
>> inline in a view?
>>
>> SEL
David Fetter wrote:
>
> On Mon, Apr 30, 2007 at 10:51:36PM -0700, novnov wrote:
>>
>> Does postgresql have a built in IF function that allows one to eval a
>> condition and return one or another value? Like:
>>
>> IIF(mybooleanfield = true, "It'
Does postgresql have a built in IF function that allows one to eval a
condition and return one or another value? Like:
IIF(mybooleanfield = true, "It's true", "It's not true")
--
View this message in context:
http://www.nabble.com/IF-function--tf3673523.html#a10264910
Sent from the PostgreSQL
Wonderful, that solved it...THANK YOU!
Douglas McNaught wrote:
>
> novnov <[EMAIL PROTECTED]> writes:
>
>> I am trying to connect to a postgres 8.1 installation on a ubuntu box
>> from
>> windows xp. I get this error: FATAL: missing or erroneous pg_hba.conf
&
I am trying to connect to a postgres 8.1 installation on a ubuntu box from
windows xp. I get this error: FATAL: missing or erroneous pg_hba.conf file
HINT see server log for details.
The server ip address is 192.168.1.10. The workstation ip address is
192.168.2.100. The server firewall allows con
l me to hang it up I will...I figured that informing the
community re these articles might be a minor contribution.
novnov wrote:
>
> In an interview "An interview with Adam Machanic" at
>
> http://www.simple-talk.com/sql/sql-server-2005/sql-server,-postgressql-and-fish-curry
Thanks, that did it, and I'd not seen that set of docs yet, should be
helpful.
--
View this message in context:
http://www.nabble.com/Generic-timestamp-function-for-updates-where-field-names-vary-tf2899327.html#a8155138
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Adrian Klaver wrote:
>
> On Wednesday 03 January 2007 12:13 am, novnov wrote:
>> Adrian Klaver wrote:
>> > On Sunday 31 December 2006 8:48 am, novnov wrote:
>> >> OK. python would be the preference, if anyone is interested in showing
>> >> me how
Adrian Klaver wrote:
>
> On Sunday 31 December 2006 8:48 am, novnov wrote:
>> OK. python would be the preference, if anyone is interested in showing me
>> how it would be done, I've never used one of the dynamic languages with
>> postgres.
>>
>> Why
ian Klaver wrote:
>
> On Monday 01 January 2007 6:24 pm, novnov wrote:
>> Thanks, the depends tools looks very handy, surprising I'd not heard of
>> it
>> before.
>>
>> I found that the postgresql\bin dir must be added to the path.
>>
>> Also, I
???
Adrian Klaver wrote:
>
> On Monday 01 January 2007 3:39 pm, novnov wrote:
>> It should be easy enough - just run "depends plpython.dll" in the
>> directory where plpython is.
>>
>> Two things to verify first:
>> 1) Verify that you added the directori
It should be easy enough - just run "depends plpython.dll" in the
directory where plpython is.
Two things to verify first:
1) Verify that you added the directories to the system path, and not
your personal path
2) Did you restart the server after adding it? Needs to be done for
windows to pick u
Adrian Klaver wrote:
>
> On Monday 01 January 2007 11:14 am, Magnus Hagander wrote:
>> novnov wrote:
>> > This is so much more difficult than I imagined it could be. I've added
>> > the main python dir and the lib dir to my path and nothing has changed.
>
u for trying to help.
Magnus Hagander-2 wrote:
>
> novnov wrote:
>> Then I tried something like what Adrian had suggested:
>>
>> D:\postgresql\bin>createlang -U sauser -d mydb plpythonu
>> Password:
>> createlang: language installation failed: ERROR: could n
Thanks to both of you. I tried the following and got an error that
plpython.dll couldn't be found:
D:\postgresql\bin>createlang -U sauser plpythonu mydb
Password:
createlang: language installation failed: ERROR: could not load library
"D:/pos
tgresql/lib/plpython.dll": The specified module could
I've spent a couple of hours on this and would like to ask for an assist at
this point. I need to install python support on windows. The postgresql
install is the windows 8.2.0-1 binary, and pl/pgsql was included in the
initial installation. I have python 2.5 installed. The workstation's path
does
Thanks Adrian, I'll see what I can do with that, I'll learn a lot by going
through what you've done.
Adrian Klaver wrote:
>
> On Sunday 31 December 2006 8:48 am, novnov wrote:
>> OK. python would be the preference, if anyone is interested in showing me
>> how
Yes thanks that does make it clear.
Martijn van Oosterhout wrote:
>
> On Sun, Dec 31, 2006 at 08:48:07AM -0800, novnov wrote:
>> Why would not be possible in plpgsql? It has loop etc, the only part I'm
>> not
>> sure it can do it use the variable as field name.
When responding just now I mentioned loops because another issue I'm working
on involves those, loops wouldn't be involved here.
novnov wrote:
>
> OK. python would be the preference, if anyone is interested in showing me
> how it would be done, I've never used one of th
e.
David Fetter wrote:
>
> On Sat, Dec 30, 2006 at 10:33:01AM -0800, novnov wrote:
>>
>> The pagila database has generic trigger function called last_updated()
>> (shown
>> below) which is used to update timestamp columns in various tables. The
>> reason I can
The pagila database has generic trigger function called last_updated() (shown
below) which is used to update timestamp columns in various tables. The
reason I can't use the function 'as is' for my own purposes is that in my
app the timestamp fields are not all named alike. The field names do follo
s on slashdot
continues to be "use postgresql if you need advanced features, but use mysql
if all you care about is speed," despite all the head-to-head benchmarks
I've seen by third parties showing PostgreSQL to be faster under load.
Josh Rovero wrote:
>
> _
>
&g
I was wrong from the get-go, I apparently selected the cube contrib, because
on reinstall it's not automatically selected, at least in 8.1.5.
Richard Huxton wrote:
>
> novnov wrote:
>> I'm sure I didn't do something properly but the point is, as a newbie,
r I will try to find and execute the contrib module uninstall scripts.
It's all a lot of work.
Joshua D. Drake wrote:
>
> On Tue, 2006-11-28 at 09:38 -0800, novnov wrote:
>> I imagine that there is a step in the windows install that allows one to
>> select contrib modul
Anyway, it's pretty simple to add plpgsql back in using CREATE LANGUAGE.
>
> On Nov 25, 2006, at 5:16 PM, novnov wrote:
>
>>
>> I hadn't checked and the page you pointed to here was different
>> from the one
>> you pointed to on the other list
>>
, your pointers have helped.
novnov wrote:
>
> Hi Ray - yes I read and checked in to your advice on the other list but I
> posted here because the procedure looked a little complex and possibly
> risky for a newbie like me. Rather than ask you for a simpler way to go, I
> figure
that you'd
probably be on this list too. I'm just hoping that there is a way to clear
those spurious (to me) entries without the level of hacking that the article
you pointed me to entailed.
Raymond O wrote:
>
> On 25 Nov 2006 at 14:24, novnov wrote:
>
>> In all of post
In all of postgres 8.1.4 (windows) databases I create there are a bunch of
cube and g_cube functions added to the db. If these are not needed, is there
a simple way to make sure that they are not added to new databases?
--
View this message in context:
http://www.nabble.com/Editing-contrib-modul
Thanks to the three of you for your thoughts, those are very very helpful
perspectives that are going to help me design this. One note, I won't have
to worry about multiple currencies on the internal bookeeping side of
things, which is a major plus.
Jorge Godoy-2 wrote:
>
> Alban Hertroys <[EMA
Bumping this in hopes that someone can give me a bit of input?
novnov wrote:
>
> I'm working on an application that will eventually need to support various
> currencies. I've never touched this area before, have dealt with dollars
> till now. I'm not sure what t
the major
difference between the two with more complicated queries. I am puzzled by
the commentor's post to the article, it could be FUD of course but didn't
particularly sound like the commentor was anti pgsql.
Merlin Moncure-2 wrote:
>
> On 11/11/06, novnov <[EMAIL PROTECTE
nes and "_" that do not invoke the double
quoting of names. Are there any? If there were others, it'd be nice to know,
for possible use as namespace markers ("_" is most commonly used for this,
maybe it's the only real candidate).
Dawid Kuroczko wrote:
>
> On
Thank you I'd not seen that page.
Robert Treat wrote:
>
> On Saturday 11 November 2006 01:26, novnov wrote:
>> Any recommondations for a util that helps with conversion of MS SQL
>> Server
>> databases to Postgres? Constraints, triggers, etc?
>>
>> Than
Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
>
> On 11/12/06, Robert Treat <[EMAIL PROTECTED]> wrote:
>>
>> On Saturday 11 November 2006 01:26, novnov wrote:
>> > Any recommondations for a util that helps with conversion of MS SQL
>> Server
>> > databases to Po
estyle practice...probably only seasoned devs can understand how weird
that is to consider.
Alexander Staubo wrote:
>
> On Nov 8, 2006, at 18:49 , novnov wrote:
>
>> I've been using namestyles with mixed case like OrgID. That is much
>> more
>> readable
it seems odd that ms sql
would be faster than pgsql. The actual test, what was use to benchmark,
would make a difference of course.
I'm hoping someone with a good handle on both databases has direct
experience can chime in here.
Tom Lane-2 wrote:
>
> novnov <[EMAIL PROTECTED]>
In an interview "An interview with Adam Machanic" at
http://www.simple-talk.com/sql/sql-server-2005/sql-server,-postgressql-and-fish-curry/
at the bottom of the page is a post by Andrew Clarke that says pgsql is much
slower in comparison to ms sql. I've read a fair number of posts recently
debun
Any recommondations for a util that helps with conversion of MS SQL Server
databases to Postgres? Constraints, triggers, etc?
Thanks
--
View this message in context:
http://www.nabble.com/Utility-to-Convert-MS-SQL-Server-to-Postgres-tf2611970.html#a7289969
Sent from the PostgreSQL - general mai
I'm working on an application that will eventually need to support various
currencies. I've never touched this area before, have dealt with dollars
till now. I'm not sure what the regular practices are re mulitple currencies
in the same application.
The app includes calculations like price per un
Alexander Staubo wrote:
>
> On Nov 8, 2006, at 18:49 , novnov wrote:
>
>> I've been using namestyles with mixed case like OrgID. That is much
>> more
>> readable than orgid. Probably a good convention to adopt would be
>> to use
>> namestyles
Yes, I've already pretty much decided to use lowercase for all namestyles, I
mentioned that in the first post. Using lowercase invokes a set of other
issues, which I'm asking for options on...namely, conventions like org_id,
and emp_org_id, or simply using org_id as the fk pointer.
Richard Broe
I'm new to pgsql, mostly coming from MSSQL. It sounds like it's simplest to
keep field names lowercase with pgsql, so I will have to change some habits
I've developed over the years. I would like to glean whatever collective
wisdom I can here from experienced pgsql devs.
I've been using namestyle
take the seemingly uneccessary step of double quoting
names like Item?
Any suggestions for a db admin tool that does not introduce this error?
Martijn van Oosterhout wrote:
>
> On Sat, Nov 04, 2006 at 08:35:28AM -0800, novnov wrote:
>> So pgSQL is case sensitive and that include
- DROP FUNCTION "proc_UpdateItemName"();
CREATE OR REPLACE FUNCTION "proc_UpdateItemName"()
RETURNS void AS
$BODY$UPDATE "Item" SET "ItemName" = 'fox';$BODY$
LANGUAGE 'sql' VOLATILE;
ALTER FUNCTION "proc_UpdateItemName"() OWNER TO p
OR relation "item" does not exist". Not using the
param, but it doesn't help to remove it.
novnov wrote:
>
> Thanks to both of you for responding. I should have included the code for
> my own attempt, at #1 which is just as you suggest:
>
> update item set it
> update tablename set itemname = 'testing' where itemid = :var1;
>
> Hope this helps...
>
> Thanks,
> ---
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
>
>
> On 11/4/06, novnov <[EMAIL PROTECTED]> wrote:
>>
>>
>> I'm com
I'm completely new to pgsql, using 8.1 and pgAdmin III. I'm not finding a lot
of bare bones simple example stored procs that I can learn from. It would be
very helpful if someone could show me some simple code.
In the pgAdmin interface I've been picking SQL as the language, that's the
default it
98 matches
Mail list logo