On 19.04.2005 02:33 Kris Jurka wrote:
Is this a problem with the JDBC interface that I'm using, or is this a
general Postgres problem?
>>>
>
> This is an open todo item for the JDBC driver. It could be done by
> automatically wrapping all statements in savepoints behind the scenes.
>
unsubscribe
Lorenzo Thurman <[EMAIL PROTECTED]> writes:
> I'm trying that right now. I think there may be mis-match in the build
> settings between upgrades of postgresql. The "USE" settings may be at
> fault:
> - - pg-hier: Enables recursive queries like Oracle's 'CONNECT
> BY' feature.
[ rolls
I'm trying that right now. I think there may be mis-match in the build settings between upgrades of postgresql. The "USE" settings may be at fault:
- - pg-hier: Enables recursive queries like Oracle's 'CONNECT BY' feature.
- - pg-vacuumdelay : Adds in the vacuum inter-page delay feature.
-
Lorenzo Thurman <[EMAIL PROTECTED]> writes:
>>> ERROR: did not find '}' at end of input node
> I installed this from Gento's portage repository.
Gentoo has a history of supplying broken compilers, software, etc
... bleeding edge stuff tends to cut you occasionally :-(
You might try updating you
On Apr 18, 2005, at 4:46 p, Tom Lane wrote:
Also, does "select * from pg_user" provoke the same error in every
database of your installation, or only this one? If the latter,
it could be a data-corruption kind of problem.
I only have one database right now. When I try "select * from pg_user", I
On Mon, Apr 18, 2005 at 12:01:58PM +0530, Dinesh Pandey wrote:
>
> What is error in this statement of "pltcl" function.
>
> set var 'SENDING EMAIL TO: '||$mailto||' from: '||$mailfrom||' with:
> '||$emailserver
>
> I am getting this error:
>
> ERROR: wrong # args: should be "set varName ?newV
On Mon, Apr 18, 2005 at 10:36:27AM +0530, Dinesh Pandey wrote:
>
> How to include "EXCEPTION" handling block in PL/TCL function.
As I mentioned in a previous message, "catch" is the Tcl mechanism
for trapping runtime errors (e.g., a failed socket connection).
See a Tcl reference for details.
htt
Edit "postgres.conf" and "pg_hba.conf" to access database from a remote
machine
Edit "postgres.conf":
--
listen_addresse='*'
Edit "pg_hba.conf":
--
hostall all 10.10.0.76 255.255.255.0
trust
On 4/18/05, Christopher Nelson <[EMAIL PROTECTED]> wrote:
>
> This isn't a high-priority question.
>
and if I can latch on to this non-priority question with another in a
similar vain: what sort of RDBMS do huge transactional systems like
Tandy's use? I've read that everything is a database, s
On Monday 18 April 2005 01:42 pm, Christopher Nelson wrote:
> This isn't a high-priority question.
>
>
>
> I'm developing a hobby OS and I'm looking into file systems. I've
> thought about writing my own, and that appeals, but I'm also very
> interested in the database-as-a-filesystem paradigm. I
"Christopher Nelson" <[EMAIL PROTECTED]> writes:
I'm developing a hobby OS and I'm looking into file systems. I've
thought about writing my own, and that appeals, but I'm also very
interested in the database-as-a-filesystem paradigm. It would be
You may want to take a look at SQLLite. It would pr
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
This is the tsearch website. There is lots of documentation, additional
language dictionaries, patches, and utilities there.
Andy
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tobias Heise
Sent:
Sorry for the misnomer. :-D Thanks for answering my question so
quickly!
> "Christopher Nelson" <[EMAIL PROTECTED]> writes:
> > I'm developing a hobby OS and I'm looking into file systems. I've
> > thought about writing my own, and that appeals, but I'm also very
> > interested in the database-
You don't have to cast it as anything, just return a refcursor from your
function.
Say you return a refcursor called return_cursor
select myfunction(your_in_array);
fetch all from return_cursor;
If you are calling from a development environment, you put the return
value of the fuction (the refcu
I accidentally posted this to win32-hackers first, instead of here
originally as I meant to.
Just when everything looked good, it went to crap again. I was able to
successfully install pltclu into one database with the command
"createlang -U postgres pltclu dbname". Upon hitting enter, I was promp
On Tue, 19 Apr 2005, Thomas Kellerer wrote:
> Joshua D. Drake wrote on 19.04.2005 00:21:
> >> I'm having a bit of trouble with the error message from the subject.
> >> Is there a way to simply go on with my commands if I hit this error?
> >
> > Only if you are using savepoints (nested transact
On Mon, Apr 18, 2005 at 12:25:33PM -0700, [EMAIL PROTECTED] wrote:
> I was wondering if anyone could explain how to get the Query Analyzer
> to use an Index that is defined for the table instead of doing a table
> scan? I have a table with some indexes on it that seem NOT to get used
> when I thin
Scott Marlowe wrote on 19.04.2005 00:26:
One example would be when I drop a table (and it doesn't exist) I still
want to run the following CREATE TABLE. But due to the error even the
following valid command will fail.
This problem is not limited to DDL. When I try to write the result sets for
se
Joshua D. Drake wrote on 19.04.2005 00:21:
I'm having a bit of trouble with the error message from the subject.
Is there a way to simply go on with my commands if I hit this error?
Only if you are using savepoints (nested transactions) otherwise you
must rollback.
Is this a problem with the JDBC
Thomas Kellerer wrote:
Hello,
I'm having a bit of trouble with the error message from the subject. Is
there a way to simply go on with my commands if I hit this error?
Only if you are using savepoints (nested transactions) otherwise you
must rollback.
Is this a problem with the JDBC interface th
On Mon, 2005-04-18 at 17:09, Thomas Kellerer wrote:
> Hello,
>
> I'm having a bit of trouble with the error message from the subject. Is
> there a way to simply go on with my commands if I hit this error?
>
> One example would be when I drop a table (and it doesn't exist) I still
> want to run
Joshua D. Drake wrote:
> Hrishikesh Deshmukh wrote:
> > Hi All,
> >
> > I have a db in postgresql (Win, 8.0). Is there any software that i can
> > use to connect to DB and get ER diagram(pictures) of the DB!
>
> Case studio, MS Access?
Dia?
--
Bruce Momjian| http://c
Mario Weilguni wrote:
> Am Freitag, 15. April 2005 17:57 schrieb Peter Eisentraut:
> > Mario Weilguni wrote:
> > > Is it possible to have a database cluster with one database being
> > > UNICODE/de_AT.utf and another having UNICODE/koi8.utf8 (or whatever)?
> >
> > No, sorry.
>
> Thanks for the rep
Hello,
I'm having a bit of trouble with the error message from the subject. Is
there a way to simply go on with my commands if I hit this error?
One example would be when I drop a table (and it doesn't exist) I still
want to run the following CREATE TABLE. But due to the error even the
followin
"Relyea, Mike" <[EMAIL PROTECTED]> writes:
> Thanks for the input. This looks very promising. I have one further
> question. My SQL statement is going to pull data from more than one
> table in a relatively complex query. How do I cast the RETURNS portion
> of the function?
In current releases
Lorenzo Thurman <[EMAIL PROTECTED]> writes:
> pg_dump: Error message from server: ERROR: did not find '}' at end of
> input node
> pg_dump: The command was: SELECT (SELECT usename FROM pg_user WHERE
> usesysid = datdba) as dba, pg_encoding_to_char(encoding) as encoding,
> datpath FROM pg_databa
"Christopher Nelson" <[EMAIL PROTECTED]> writes:
> I'm developing a hobby OS and I'm looking into file systems. I've
> thought about writing my own, and that appeals, but I'm also very
> interested in the database-as-a-filesystem paradigm. It would be nice
> to not have to write all of the stuff
On Sun, 2005-04-17 at 09:17, Todd Underwood wrote:
> howdy,
>
> i'm by no means a postgres expert, so i'm probably making a dumb
> mistake, but this is v. troubling.
>
> we have a script that bulk-uploads about 45K rows. we do this via
> perl DBI using the COPY functionality.
>
> the problem is
Todd Underwood <[EMAIL PROTECTED]> writes:
> $dbh->do("LOCK TABLE $table IN SHARE UPDATE EXCLUSIVE MODE")
> or die "Cannot lock $table...\n";
> $dbh->do("ALTER TABLE $table DROP CONSTRAINT ${table}_pkey")
> or die "Cannot drop constraint ${table}_pkey...\n";
> $dbh->do("DELETE FROM $table
I'm running postgresql 7.4.7 on x86 and have run into a problem trying
to export my database. When I use pg_dump --file=stats.out --format=t
printstats, (and I may have the syntax wrong), I get this error:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: did not find '}' a
Thanks for the input. This looks very promising. I have one further
question. My SQL statement is going to pull data from more than one
table in a relatively complex query. How do I cast the RETURNS portion
of the function? Again, I can't find what I'm looking for in the docs.
I've included an
This isn’t a high-priority question.
I’m developing a hobby OS and I’m looking into
file systems. I’ve thought about writing my own, and that appeals, but I’m
also very interested in the database-as-a-filesystem paradigm. It would be
nice to not have to write all of the stuff that goe
http://www.google.com/search?q=tsearch2
The first link contains info and links to what I used... worked all right
for me.
good luck!
On Sun, 17 Apr 2005, Tobias Heise wrote:
HI Everybody!
Could everyone give me a short instruction how to use tsearch2,
please?
Tobias
---(e
Try turning the fsync off in your configuration file.
Joe,
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Todd Underwood
Sent: Sunday, April 17, 2005 9:18 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] increasingly slow insert/copy performance
HI Everybody!
Could everyone give me a short instruction how to use tsearch2,
please?
Tobias
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTEC
I was wondering if anyone could explain how to get the Query Analyzer
to use an Index that is defined for the table instead of doing a table
scan? I have a table with some indexes on it that seem NOT to get used
when I think they should. :-) Not that I KNOW more than the Query
Analyzer - but a Tab
howdy,
i'm by no means a postgres expert, so i'm probably making a dumb
mistake, but this is v. troubling.
we have a script that bulk-uploads about 45K rows. we do this via
perl DBI using the COPY functionality.
the problem is that we do this about once per 5 minutes and the time
it takes to do
"Leif B. Kristensen" <[EMAIL PROTECTED]> writes:
> There's one thing I've been wondering about: Why isn't the postgresql
> config file in /etc, with all the rest?
Because (a) that would mean you couldn't run Postgres without root
privileges (to set up the config files), and (b) you couldn't run m
On Monday 18 April 2005 12:16, Leif B. Kristensen wrote:
> On Monday 18 April 2005 21:07, Gavin M. Roy wrote:
> > Thank you for posting to a better list for these questions. Check
> > your postgresql.conf file and make sure it's accepting TCP/IP
> > connections on the IP you're looking for. If yo
"Uwe C. Schroeder" <[EMAIL PROTECTED]> writes:
> have you enabled tcp in postgresql.conf ?
> the parameter in question is pretty much on top of the file and should read
> tcpip_socket = true
And if you have set that, look at the system's packet filtering rules
--- recent Red Hat releases tend to d
you coud pass in criteria as a delimted string, then
pull out each arg something like this
CREATE or REPLACE FUNCTION test_func( varchar)
RETURNS pg_catalog.void AS
$BODY$
DECLARE
IN_ARRAY text[] ;
arg1 varchar;
arg2 varchar;
arg3 varchar
begin
IN_ARRAY = string_to_array($1,'~^~');
arg1= IN_ARR
In article <[EMAIL PROTECTED]>,
"Relyea, Mike" <[EMAIL PROTECTED]> writes:
> I need to create my very first function. I'm using 8.0.2 and I need a
> function that I can call (from my client app) with an unknown number of
> criteria for a select query. The function will then return the results
>
Hi,
I am using Redhat linux 9. i had configure in pg_hba.conf as
hostpostgres postgres 10.10.0.76 255.255.255.0 password
If i try to connect with postgresql admin i am getting excpetion as
An erro has occured:
Error connecting to the server: could not connect to server:
Connection ref
On Mon, 2005-04-18 at 14:23, ElayaRaja S wrote:
> Hi,
> I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
> i have to install postgresql 7.4.5. Plz let me know how to uninstall
> completely - postgesql 7.3.2
>
> I am getting as [EMAIL PROTECTED] root]# rpm -e postgresql
> error:
On Mon, 2005-04-18 at 14:16, Leif B. Kristensen wrote:
> On Monday 18 April 2005 21:07, Gavin M. Roy wrote:
> > Thank you for posting to a better list for these questions. Check
> > your postgresql.conf file and make sure it's accepting TCP/IP
> > connections on the IP you're looking for. If you
In article <[EMAIL PROTECTED]>,
Alex <[EMAIL PROTECTED]> writes:
> Hi,
> i am having a problem with a plperl function. bellow function always
> returns me an error saying "elements of Perl result array must be
> reference to hash"
> Can anyone point me out what i am doing wrong here?
> Basically
Hi,
I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
i have to install postgresql 7.4.5. Plz let me know how to uninstall
completely - postgesql 7.3.2
I am getting as [EMAIL PROTECTED] root]# rpm -e postgresql
error: package postgresql is not installed
if i try to check the ve
On Tue, Apr 19, 2005 at 03:00:07AM +1000, Alex wrote:
>
> i am having a problem with a plperl function. bellow function always
> returns me an error saying "elements of Perl result array must be
> reference to hash"
[snip]
>my $row = $rv->{rows}[$rn];
>my @record;
>
>$rec
On Monday 18 April 2005 21:07, Gavin M. Roy wrote:
> Thank you for posting to a better list for these questions. Check
> your postgresql.conf file and make sure it's accepting TCP/IP
> connections on the IP you're looking for. If you look in your PGDATA
> directory you should find the config file
have you enabled tcp in postgresql.conf ?
the parameter in question is pretty much on top of the file and should read
tcpip_socket = true
usually postgresql.conf is in /var/lib/pgsql/data/
on a RH system
UC
On Monday 18 April 2005 11:55, ElayaRaja S wrote:
> Hi,
> I am using Redhat linux 9. i
Thank you for posting to a better list for these questions. Check your
postgresql.conf file and make sure it's accepting TCP/IP connections on
the IP you're looking for. If you look in your PGDATA directory you
should find the config file, and if you open it and read it, it's well
commented s
I need to create my very first function. I'm using 8.0.2 and I need a
function that I can call (from my client app) with an unknown number of
criteria for a select query. The function will then return the results
of the query. In my mind, it would go something like what I've outlined
below. I r
"Dinesh Pandey" <[EMAIL PROTECTED]> writes:
> What's wrong with this code (ERROR: syntax error at or near "INTO" at
> character 8)?
You can't use plpgsql's SELECT INTO in an EXECUTE'd command, because
SELECT INTO means something entirely different to the main SQL engine.
The usual workaround is
> cd /usr/ports/databases/postgresql-contrib
> make && make install && make clean
>
doh! Yet another obvious answer that escaped me, thanks. It is worth
noting however, that this only applies to FreeBSD I don't see anything
like it in OpenBSD. Free has a more comprehensive ports collection
than
Well, I thought this should indicate it: "And if there are 0 rows with stoptype
= 1,
my select should return 1 row." but maybe I was a bit unclear...
The problem is that the log_stop table stores log values for x different kind
of logs
separated with the stoptype field... And I am trying to des
But that doesn't make a log of sense to me. And which row do you want?
I'm thinking your data /layout /logic might need some rethinking, or at
least re-stating. Your original post didn't seem to indicate this need.
On Mon, 2005-04-18 at 12:05, BjÃrn T Johansen wrote:
> Nope, I have already tri
En un mensaje anterior, Matt Van Mater escribió:
> I there a way to specify that I want the contribs directory (and its
> children) compiled and installed during the build process in the
> various BSD ports systems? Of course I understand that what works on
> one BSD may not work on the others, bu
Nope, I have already tried that one... But this one returns 0 rows when eg.
stoptype
= 2.. (it works ok when stoptype = 1 or null...) But I should get one row when
stoptype = 2 as well, but then with null values from fields in the log_stop
table...
I am not sure if this is possible, without writ
If that doesn't work, you'll need a subselect:
select * from
(select ordre.id, ordre.desc, log_stop.stoptype from ordre left outer
join log_stop on
ordre.id = log_stop.ordreid where ordre.id = 22) as a
were a.stoptype=1 or a.stoptype IS NULL
On Mon, 2005-04-18 at 11:58, Scott Marlowe wrote:
> Th
Hi,
i am having a problem with a plperl function. bellow function always
returns me an error saying "elements of Perl result array must be
reference to hash"
Can anyone point me out what i am doing wrong here?
Basically i try to return data from a select in a specific record format.
(i know that
Nope... It returns 0 rows when there are no rows in log_stop with stoptype =
1...
BTJ
Scott Marlowe wrote:
> On Mon, 2005-04-18 at 11:24, BjÃrn T Johansen wrote:
>
>>I need a select like this..:
>>
>>select ordre.id, ordre.desc, log_stop.stoptype from ordre left outer join
>>log_stop on
>>ordr
I there a way to specify that I want the contribs directory (and its
children) compiled and installed during the build process in the
various BSD ports systems? Of course I understand that what works on
one BSD may not work on the others, but I don't see any FLAVORs or
make options that would sugg
Then maybe:
AND (log_stop.stoptype=1 OR log_stop.stoptype IS NULL)
??
On Mon, 2005-04-18 at 11:55, BjÃrn T Johansen wrote:
> Nope... It returns 0 rows when there are no rows in log_stop with stoptype =
> 1...
>
> BTJ
>
> Scott Marlowe wrote:
> > On Mon, 2005-04-18 at 11:24, BjÃrn T Johansen w
On Mon, 2005-04-18 at 11:24, BjÃrn T Johansen wrote:
> I need a select like this..:
>
> select ordre.id, ordre.desc, log_stop.stoptype from ordre left outer join
> log_stop on
> ordre.id = log_stop.ordreid where ordre.id = 22
>
> The problem is that I need to include "where log_stop.stoptype = 1
I need a select like this..:
select ordre.id, ordre.desc, log_stop.stoptype from ordre left outer join
log_stop on
ordre.id = log_stop.ordreid where ordre.id = 22
The problem is that I need to include "where log_stop.stoptype = 1". So if
log_stop
includes 3 rows with stoptype = 1 and ordreid =
Hi
What’s wrong with this code (ERROR: syntax error at or near
"INTO" at character 8)?
Problem: I want to put A1, A2 values in two variables
vara, varb.
CREATE OR REPLACE FUNCTION test(text)
RETURNS VARCHAR AS $$
Declare
vara
VARCHAR(10) :='';
varb
"Zlatko Matiæ" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello.
>
> While I was working with Access Projects (Access front-end with MSDE) I
> was able to call stored procedures by using ADO command and parameters
> object.
> Now I am trying to migrate my database from MSDE t
O Dinesh Pandey έγραψε στις Apr 18, 2005 :
>
>
> How to add 1 hour in a date or time stamp?
# SELECT now() + '1 hour'::interval;
>
> Regards
> Dinesh Pandey
>
>
>
> --
>
>
>
>
>
>
--
-Achilleus
---
On Monday 18 April 2005 08:38 am, Dinesh Pandey wrote:
> How to add 1 hour in a date or time stamp?
timestamp + '1 hour'::interval
is one way.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-351-4152 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Dri
Dinesh,
The documentation is very helpful for this
topic. Typing 'add 1 hour timestamp' into the search box at:
http://www.postgresql.org/docs/8.0/interactive/index.html
yields the following page as the first
hit:
http://www.postgresql.org/docs/8.0/static/functions-datetime.html
Sea
How to add 1 hour in a date or time stamp?
Regards
Dinesh Pandey
--
Greetings,
I have a problem with one of my databases. When I try to connect to
one of my 3 databases using psql it's just hangs and I can't connect.
The other databases are still ok even after I get a hangup from the
damaged one.
I'm sorry but I couldn't collect too much information. It simpl
æê®7}nS×YYØ:4(æ¿Wy‹ÈSÞVÜþðhË?
zO„Çž\
òÇïRLçW9Ô‰è*Ó_ß÷[!'«ìëøó±H.l\¦rãÈí!ÆAš«x{<Ÿ!õuƒžªGÛ8dù?à~q÷ô•ûÕ×VMPf‘ÂÒTb
¶¢Ì¾?nl
v̇œ“í…Z§Oƒ™3bÅ×éwß? LK;Ó!çC";tÑa,F`Û?ˆ,<Õ.Z3òÞ&ÛZ8Ó(œ¢ÕOi¤mÇó·Ò¹¹”é„JÅ)Å?Á
ì\2a·Ðw(©ôî™Á^¼e褟à1ÕÑÝSÎïM?ù°e#ôw…ï%G
‹©ö´Ì͆0·afÙDRnŒ
¦“:S5_ÅþìwkŸë n„²t^óGåÊ1!‰pAPè}ã?NùÖ¨®•:,q#”º
74 matches
Mail list logo
