Hi list,
I plan to write an ERP program using Postgresql (with embedded
procédures) & Tcl/Tk for the GUI.
My question is: how can I recover each column value from an
embedded procedure that return a RECORD type?
Thanks in advance,
Jean-Yves
---(end of
hello, i found this ERROR msg at our postgresql log
file at one of my client.
what i did is i
1) kill -9 (postmaster process id).
2) remove the postmaster.pid file under
/usr/local/pgsql/data/
3) restart the postmaster process.
then no more error msg in the postgresql log
file.
problem c
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hey,
What ways are there to limit the sizes of a database?
Thx
Q Beukes
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iQEVAwUBRF8oErEDZDQ16UzTAQJbsAf+L8+RijP+DFuVWwlH
am 08.05.2006, um 13:14:26 +0200 mailte Q Beukes folgendes:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hey,
>
> What ways are there to limit the sizes of a database?
You can use filesystem-quotas for your data-partition and/or you can ask
the information_schema about the size of your
Hi Tzahi
Since you seem to know about full disjunctions, I was wondering if you
could answer this question:
Can full disjunction be implemented as a binary operator?
The algorithms I've seen for computing it seem to require that all
input relations be supplied at once. Even in your message above
Estoy programando en vb utilizo ado para conectarme
a la bd postgre, lo
q necesito hacer es
Grabar un registro y una vez grabado recuperar el autonumerico para grabarlo en otra tabla
Utilizando dao con mdb lo hacia asi:
Rs.update
Rs.movelast
Variable = Rs(“campo”)
Y ya
Thanks for the response, but changing to 127.0.0.1 didn't help.
Changing this line sets the db wide open:
hostall all 127.0.0.1/32 trust
>From there, another non-root login can access it with any user /
password.
What I really need is this command to work with a non
hi
i down loaded the postgre sql source code and compile it, can any body
plz tell that how to debug it in windows platform
regards
srinivasa
_
NRIs Zero balance Account. FREE Money Transfers with FREE DVD
https://www.online.citib
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Version 1.49 of DBD::Pg has been released. This version adds support
for the ParamTypes statment handle attribute, and fixes a small bug in
ParamValues. It strips the final newline (as it did before) from error
messages, so that Perl's die will repor
> > >
> > > # "local" is for Unix domain socket connections only
> > > local all all ident sameuser
> > > # IPv4 local connections:
> > > hostall all 127.0.0.1/32 md5
> > > # IPv6 local connections:
> > > hostall all
"Chun Yit\(Chronos\)" <[EMAIL PROTECTED]> writes:
> what i did is i=20
> 1) kill -9 (postmaster process id).
> 2) remove the postmaster.pid file under /usr/local/pgsql/data/
> 3) restart the postmaster process.
The *first* thing you ought to do is learn not to do that. You
deliberately broke the
Hi Lee,
First, i have no knowledge of anyone that have implemented full
disjunctions(ever) aside
from the theoretical works of my colleagues.
With the exception of a corner case of it, that I believe was a simulation in
96.
(A. Rajaman and J.D. Ullman Integrating information by outerjoins and
f
Please keep replies copied to the list so that others can learn from and
contribute to the discussion. I don't remember where this was, but it looks
like general is probably reasonable.
On Mon, May 08, 2006 at 15:02:20 +0100,
Joao Miguel Ferreira <[EMAIL PROTECTED]> wrote:
> Bruno and all,
>
>
On Mon, 2006-05-08 at 18:07, Bruno Wolff III wrote:
> Please keep replies copied to the list so that others can learn from and
> contribute to the discussion. I don't remember where this was, but it looks
> like general is probably reasonable.
Sorry. I didn't notice. I'll keep that in mind.
> >
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> In the long run, you should upgrade. 7.2 is essentially without support. I
> beleive there is still a RHEL version using it that is in support, so a
> critical fix might get back ported.
No, Red Hat never shipped a RHEL version using 7.2.* (they went s
Is there any requirement that you have to use REPLACE? Another (possibly
better) way to do the same is by doing:
select translate(your_string,'aeiou','') from your_table;
In my experience that performs much better than regexp. I just ran it on
a table of about 100K random U.S addresses and TRA
Hi,
[I'm trying to share some of my thoughts about intarray contrib module.
If this is the wrong way to achieve this, please warn me. (Should I
first get in touch with Teodor Sigaev and Oleg Bartunov?)]
[6]
_int_same() in _int_op.c looks like making some redundant sorting and
not taking advantage
Hello,
PostgreSQL 8.1.3, Centos 4.2
I'm having trouble with a dump and restore:
$ pg_dump --format=t --schema=babase --data-only --user babase_admin
babase_test | pg_restore --data-only --disable-triggers --user
babase_admin --dbname=babase
pg_restore: ERROR: duplicate key violates unique
Is there a way to export the output of an arbitrary SQL query to a
quoted CSV file?
It seems that the COPY command can do that for regular tables (COPY foo
TO STDOUT WITH CSV QUOTE AS '"') but not for a query result. I could
create temp tables in a script but it seems that there should be a
simpl
Volkan YAZICI <[EMAIL PROTECTED]> writes:
> [I'm trying to share some of my thoughts about intarray contrib module.
> If this is the wrong way to achieve this, please warn me. (Should I
> first get in touch with Teodor Sigaev and Oleg Bartunov?)]
Well, they're definitely the people most qualified
On Mon, May 08, 2006 at 23:10:31 +0900,
kmh496 <[EMAIL PROTECTED]> wrote:
> doesn't that user have to exist since you are using ident method? that
> means unix username == postgres username.
> do you have a user named maragato_test on the system?
> did you create that user in postgres and on t
Hi,
I have had this problem for a while, and have not been able to find
anything in the archives or on search engines:
If I want to back up a client's database on our shared web server, I
would type:
pg_dump
Since we are running a shared server, and since crappy (only because of
this problem)
On Mon, 08 May 2006 15:47:13 -0600
Blair Lowe <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have had this problem for a while, and have not been able to find
> anything in the archives or on search engines:
>
> If I want to back up a client's database on our shared web server, I
> would type:
>
> pg_d
On Mon, May 08, 2006 at 03:47:13PM -0600, Blair Lowe wrote:
> If I want to back up a client's database on our shared web server, I
> would type:
>
> pg_dump
>
> Since we are running a shared server, and since crappy (only because of
> this problem) off the shelf database open source software suc
On Tue, 2006-09-05 at 00:09 +0200, Martijn van Oosterhout wrote:
> On Mon, May 08, 2006 at 03:47:13PM -0600, Blair Lowe wrote:
> > If I want to back up a client's database on our shared web server, I
> > would type:
> >
> > pg_dump
> >
> > Since we are running a shared server, and since crappy (
What is your favorite front end for end users to interact with your
postgresql db? Is it java, .net, web apache + php, MS-Access, ruby on
rails? Why is it your favorite? Which would you recommend for end
users on multiple OSes?
Also, what do you think of having the database management system do
Not sure how else to describe this: basically if you type in pg_dump
then all databases on the system that have table grants
to public are also in the backup .sql file with connect commands to the
other database users.
Do you mean pg_dumpall? Because pg_dump will ONLY dump the database you
s
Karen Hill wrote:
What is your favorite front end for end users to interact with your
postgresql db? Is it java, .net, web apache + php, MS-Access, ruby on
rails? Why is it your favorite? Which would you recommend for end
users on multiple OSes?
I use PHP for the same reason I use Postgre
On May 8, 2006, at 3:33 PM, Karen Hill wrote:
What is your favorite front end for end users to interact with your
postgresql db? Is it java, .net, web apache + php, MS-Access, ruby on
rails? Why is it your favorite? Which would you recommend for end
users on multiple OSes?
This is totally d
On Mon, 2006-08-05 at 15:54 -0700, Joshua D. Drake wrote:
> > Not sure how else to describe this: basically if you type in pg_dump
> > then all databases on the system that have table grants
> > to public are also in the backup .sql file with connect commands to the
> > other database users.
>
>
Blair Lowe <[EMAIL PROTECTED]> writes:
> On Mon, 2006-08-05 at 15:54 -0700, Joshua D. Drake wrote:
>> Do you mean pg_dumpall? Because pg_dump will ONLY dump the database you
>> specify, nothing else.
> That would be nice, but it is not true.
Joshua is 100% correct about this; I do not know what
Hello,
What version of PostgreSQL is this that you are using? Because it
behaves like no other postgresql I have ever seen. Please see below:
[EMAIL PROTECTED]:~$ bin/initdb -D data2
The files belonging to this database system will be owned by user
"postgres".
This user must also own the se
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> I'm having trouble with a dump and restore:
> $ pg_dump --format=t --schema=babase --data-only --user babase_admin
> babase_test | pg_restore --data-only --disable-triggers --user
> babase_admin --dbname=babase
> pg_restore: ERROR: duplicate key vi
I agonized over this decision when I migrated my application to
PostgreSQL. I know Tony Caduto likes Delphi and he can give some good
reasons for this (are you out there, Tony?). There has also been a good
article recently about Ruby on Rails. For my purposes, I wanted to
maximize cross-p
Michael Schmidt wrote:
I agonized over this decision when I migrated my application to
PostgreSQL. I know Tony Caduto likes Delphi and he can give some good
reasons for this (are you out there, Tony?). There has also been a good
article recently about Ruby on Rails.
Well it depends on your
On Mon, May 08, 2006 at 12:26:48PM -0700, George Pavlov wrote:
> Is there a way to export the output of an arbitrary SQL query to a
> quoted CSV file?
For now, you can do it with a temp table, as in:
BEGIN;
CREATE TEMP TABLE my_temp AS SELECT ...;
COPY my_temp ... ;
ROLLBACK;
HTH :)
Cheers,
D
Hi
I downloded postgresql source code, and compile it in windows platform, can
any body plz tell me that how can i debug the sourcecode in windows
platform,
what are the steps are i should go through..
Regards
Srinivasa
_
Spice u
On 09.05.2006, at 0:33 Uhr, Karen Hill wrote:
What is your favorite front end for end users to interact with your
postgresql db? Is it java, .net, web apache + php, MS-Access, ruby on
rails? Why is it your favorite? Which would you recommend for end
users on multiple OSes?
You mean what tec
38 matches
Mail list logo
