-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
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
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
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
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
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
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
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
"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
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
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
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
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
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 (
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
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
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
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
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);
>
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
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
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
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 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
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
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.
--
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-
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
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
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 |
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
32 matches
Mail list logo
