sanjeev kumar wrote:
Hi,
I am using EnterpriseDB(8.1) here is my individual procedure code
[snip]
Now my question is from DB side there's no error, But from UI (java) side
while calling the procedure
they are getting the null refcursor and as well as "op_errormessage" out
parameter getting th
Sam Mason ha scritto:
On Fri, Feb 13, 2009 at 10:31:49PM +0100, Edoardo Panfili wrote:
SELECT idSpecie,nome FROM specienomi
WHERE idspecie=37026 and nome='X Agropogon littoralis (Sm.) C.E. Hubb.';
idspecie | nome
--+-
37026 |
Hi,
I want to do a full text search on a document. I have created table to store
the document. I am getting the following error while creating a trigger
jistest=> CREATE TRIGGER resumes_tsv_update_title_tsvector BEFORE INSERT OR
UPDATE ON resumes FOR EACH ROW EXECUTE PROCEDURE
tsvector_update_tri
Dear all,
Benetl, a free ETL tool for files using postgreSQL, is out in version
2.5 !!!
You can freely download it at : www.benetl.net
This new version brings several improvements that you see it in the
forum section.
Thanks for your interest.
Regards,
--
Benoît Carpentier
www.benetl.net
Dear All
i gave this kind of query
select max(foo) from (select some statement) as foo
but it gave me this error
ERROR: function max(record) does not exist
any help how i can select max value from suqbuery in main query
thanks
--
View this message in context:
http://www.nabble.com/select-
On 14/02/2009 11:05, searchelite wrote:
> select max(foo) from (select some statement) as foo
Can you post the full query? It's very hard to tell from this.
Also, I think you may need to give the subquery an alias, thus:
select max(foo) from ( ) s as foo
Ray.
--
select max(foo.record) from ...
?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
I recently upgraded a database from 8.1.11 to 8.3.6, and I noticed the
following statement stopped working:
insert into test (b) select currval('test_a_seq'::regclass)
given the following table:
create table test (a serial, b int)
The error I'm getting is: "ERROR: currval of sequence
nextval.
currval only has value, when sequence wwas used in the session before,
you would use it to obtain last value returened by nextval. read the
manual .
On Sat, Feb 14, 2009 at 11:25 AM, Onno Molenkamp wrote:
> Hi,
>
> I recently upgraded a database from 8.1.11 to 8.3.6, and I noticed the
>
Hi,
I know that, and nextval -is- being called because it's the default value of
column "a". The problem is that apparently the order in which it's called has
changed for the form with a select, not that I don't know the difference
between currval and nextval.
Onno
Op Saturday 14 February 200
yOn Sat, 14 Feb 2009, searchelite wrote:
Dear All
i gave this kind of query
select max(foo) from (select some statement) as foo
but it gave me this error
ERROR: function max(record) does not exist
any help how i can select max value from suqbuery in main query
like this:
select max(fo
On 14/02/2009 11:25, Onno Molenkamp wrote:
> I recently upgraded a database from 8.1.11 to 8.3.6, and I noticed the
> following statement stopped working:
>
> insert into test (b) select currval('test_a_seq'::regclass)
I don't think this was ever guaranteed to work - the docs say pretty
clearl
dhanunjaya naidu yandrapu writes:
> I am getting the following error while creating a trigger
> jistest=> CREATE TRIGGER resumes_tsv_update_title_tsvector BEFORE INSERT OR
> UPDATE ON resumes FOR EACH ROW EXECUTE PROCEDURE
> tsvector_update_trigger(title_tsvector, 'pg_catalog.english', title);
>
Onno Molenkamp writes:
> I recently upgraded a database from 8.1.11 to 8.3.6, and I noticed the
> following statement stopped working:
> insert into test (b) select currval('test_a_seq'::regclass)
It doesn't work in 8.1 either:
Welcome to psql 8.1.16, the PostgreSQL interactive terminal.
Typ
Hi,
I've a plpgsql function that when called never ends and I would like
to trace the internal function commands and see where is the problem.
How can I trace what the function is doing?
Thank you!
Carlos
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make cha
Carlos Henrique Reimer schrieb:
> Hi,
>
> I've a plpgsql function that when called never ends and I would like to
> trace the internal function commands and see where is the problem.
>
> How can I trace what the function is doing?
You can use RAISE NOTICE 'i'm here %', variable;
to display whe
On 14/02/2009 16:34, Carlos Henrique Reimer wrote:
> I've a plpgsql function that when called never ends and I would like to
> trace the internal function commands and see where is the problem.
>
> How can I trace what the function is doing?
You could insert RAISE NOTICE statements into your cod
The following query against my PostgreSQL 8.0.x 'public' schema:
SELECT
fkc.table_name as fk_table_name,
fkc.constraint_name AS fk_constraint_name
FROM information_schema.table_constraints fkc
WHERE fkc.constraint_schema = 'public'
AND fkc.constraint_type = 'FOREIGN KEY'
AND (
I think your two alternatives are to either make sure no constraint
names are duplicated, or add a unique key for conname to
pg_constraint. I didn;t know constraint name was a SQL requirement.
I can see how the information_schema would be designed to assume they
were unique if it was.
--
Sent vi
"Ken Winter" writes:
> Since constraint name uniqueness is a SQL standard, I was surprised that
> PostgreSQL doesn't enforce it. I found one thread (from 2002) in the
> archive that discusses this, but the thread ended inconclusively.
I think our position is pretty clear: we aren't going to enfo
Bob Pawley wrote:
I am attempting to load postmaster.
pg_ctl reload
I don't understand what is needed for [-D DATADIR]. I have tried the
path to Postgresql with no luck.
I've also leftoff [-s] since it doesn't appear to be needed.
Help would be appreciated.
unclear from your description w
I'm trying to look up the columns in a constraint in pg_catalog (of
PostgreSQL 8.0.x). I can't figure out how to "join" the elements of the
array that lists the 'attnum's of the columns in the table to the 'conkey'
array in the constraint definition (see
http://www.postgresql.org/docs/8.0/static/c
Hi,
The swithc -d is for the directory that is populated when running initdb, it
contains logging, configuration and databases
Hope this helps
Regards,
Serge Fonville
On Sat, Feb 14, 2009 at 11:10 PM, Bob Pawley wrote:
> I am attempting to load postmaster.
>
> pg_ctl reload
>
> I don't unders
export PGDATA=/path/to/data
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I am attempting to load postmaster.
pg_ctl reload
I don't understand what is needed for [-D DATADIR]. I have tried the path to
Postgresql with no luck.
I've also leftoff [-s] since it doesn't appear to be needed.
Help would be appreciated.
Bob.
--
Sent via pgsql-general mailing list (pgs
On Sat, Feb 14, 2009 at 3:10 PM, Bob Pawley wrote:
> I am attempting to load postmaster.
>
> pg_ctl reload
>
> I don't understand what is needed for [-D DATADIR]. I have tried the path to
> Postgresql with no luck.
>
> I've also leftoff [-s] since it doesn't appear to be needed.
-D points to the
I'm running 8.3 on Windows XP.
I input > pg_ctl reload -D c:\program files\postgresql\8.3\data- or any
combination thereof, with or without brackets and the server is running.
The return is - 'pg_ctl: too many command-line arguments'.
Bob
- Original Message -
From: "John R Pierce
Use quotes, there is a space between program and files
pg_ctl reload -D "c:\program files\postgresql\8.3\data"
On Sat, 2009-02-14 at 15:31 -0800, Bob Pawley wrote:
> I'm running 8.3 on Windows XP.
>
> I input > pg_ctl reload -D c:\program files\postgresql\8.3\data- or any
> combination ther
On Fri, 13 Feb 2009, Sam Mason wrote:
I was hoping for a function I could call, or maybe some variable I write
to, that would cause the contents to be invalidated.
For most people, just restarting the server is acceptable overhead, which
is why nobody has bothered to write such a thing. It w
Bob Pawley wrote:
I'm running 8.3 on Windows XP.
I input > pg_ctl reload -D c:\program files\postgresql\8.3\data-
or any combination thereof, with or without brackets and the server is
running.
The return is - 'pg_ctl: too many command-line arguments'.
you need to put " " around any pa
What error are you getting?
I tried your query and I had to add an explicit cast to smallint[] to
make it work. Like this:
... a.attnum = any ((select conkey FROM pg_catalog.pg_constraint WHERE
> oid = 3708025)::smallint[]);
It seems strange to me, I didn't expect the ANY clause to need that
cas
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
You do not want to use the keyword encrypted.
To get in, go to your pg_hba file and set the security level to trust
for your account. Then go in as postgres without a password and change
it by:
alter role postgres with password 'welcome';
> ALTER USE
32 matches
Mail list logo
