Let me start this email by saying thank you to whoever fixed the
problem. I found a bunch of Welcome to... / Results from delayed
command message pairs in my mail this morning, and a batch of
messages from each of sql, performance, and hackers mailing lists.
# [EMAIL PROTECTED] /
Hi All!I want to setup a trigger capable to return more than one record.Example (table users contains 10 records):CREATE FUNCTION get_users() RETURNS SOME_TYPE AS 'BEGIN return (SELECT * FROM users);' LANGUAGE 'plpgsql';I can't figure out the correct Postgres type for SOME_TYPE (see above
On Wed, Mar 01, 2006 at 02:22:15PM +0100, [EMAIL PROTECTED] wrote:
I want to setup a trigger capable to return more than one record.
Your example doesn't show anything related to triggers so I think
you mean function instead of trigger. If the function can
return more than one row then it's a
AKHILESH GUPTA wrote:
here i have to grant permissions to that user individually for each and
every table by using:
:- grant ALL ON tab_name to user_name;
GRANT
and all the permissions are granted to that user for that particular table.
Yes. If you are annoyed by having to type too many
thank you very much sir for your valuable suggestion,but i am talking about direct database query...!On 3/1/06, Alvaro Herrera
[EMAIL PROTECTED] wrote:AKHILESH GUPTA wrote: here i have to grant permissions to that user individually for each and
every table by using: :- grant ALL ON
AKHILESH GUPTA wrote:
thank you very much sir for your valuable suggestion,
but i am talking about direct database query...!
There is none that can help you here, short of making a function in
PL/pgSQL or other language ...
On 3/1/06, Alvaro Herrera [EMAIL PROTECTED] wrote:
I made some tests with three different types:
numeric, text and a specialized type written in c.
The tests were made with 20 digit codes.
The specialized type was a struct defined as:
typdef struct mycode {
char c1;
char c2;
int32 c3;
int32 c4;
} mycode
The sizeof(mycode) returns
[EMAIL PROTECTED] writes:
I made three tables of one column using the three different data types
and checked the size in bytes of the three tables.
The results were not as expected.
You forgot to consider per-row overhead, including alignment padding.
regards, tom
[EMAIL PROTECTED] wrote onTuesday, February
28, 2006 7:13 AM We are suffering from the same issue that is described
in this email thread http://archives.postgresql.org/pgsql-general/2005-07/msg00486.php.
I don't know if this is the appropriate place to make this
request, so if not,
On Wed, Mar 01, 2006 at 05:24:03PM +0100, [EMAIL PROTECTED] wrote:
I made some tests with three different types:
numeric, text and a specialized type written in c.
The tests were made with 20 digit codes.
snip
The results were not as expected.
I was expecting these theoretical
Hi
My company wants to run Typo3, and I'd like it to run against postgresql
instead of mysql (Don't want to have to administer a mysql database ;-).
I've googled a bit now, and it seems that I need ADODB for php + some
Typo3 extension.
Does anyone know of a howto that explains what
software
Hi,
Most of the web applications I work on are nothing more than front-ends
to postgresql. I have used Perl (CGI), Java, C# and am now looking at
Django. Each generation of frameworks lessens the pain of donig
web-apps, but it still seems redundant.
Does any one know of a framework where the
On 01.03.2006, at 19:39 Uhr, falcon wrote:
Any one know of such a framework?
(I'm asking this in pgsql because such a framework will have to be
fairly closely linked to a database...and I mainly use pgsql).
Hmm. No. I don't think you can have this combined with what is often
called
falcon wrote:
Hi,
Most of the web applications I work on are nothing more than front-ends
to postgresql. I have used Perl (CGI), Java, C# and am now looking at
Django. Each generation of frameworks lessens the pain of donig
web-apps, but it still seems redundant.
Does any one know of a
As a special promotion we are offering PG Lightning Admin for the blow
out price of 5 dollars per copy.
Our goal is to reach 1000 sales by the first day of spring, and 1
dollar per sale will go to the Postgresql project, but only if we reach
the 1000 unit mark.
To get this great product for 5
Hi,
I know this isn't directly a postgres issue, but it might help a few
other users, so here goes.
I did an upgrade on my Fedora Core 4 system, and postgres (8.1.2 from
the postgres packages, not FC packages) stopped working because of
permission issues when trying to create postmaster.pid in
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tony Caduto
Sent: 01 March 2006 19:44
Cc: pgsql-general@postgresql.org
Subject: [GENERAL] Special offer with a possible dontation to
the project
Our goal is to reach 1000 sales by the first day
On Tue, Feb 28, 2006 at 10:13:14AM -0500, [EMAIL PROTECTED] wrote:
We are suffering from the same issue that is described in this email thread
http://archives.postgresql.org/pgsql-general/2005-07/msg00486.php.
I don't know if this is the appropriate place to make this request, so if
On Wed, 2006-03-01 at 13:44 -0600, Tony Caduto wrote:
As a special promotion we are offering PG Lightning Admin for the blow
out price of 5 dollars per copy.
Our goal is to reach 1000 sales by the first day of spring, and 1
dollar per sale will go to the Postgresql project, but only if we
Pete,
I agree with you about websites containing lots of complex logic. It
is an interesting excercise to extract out this logic from the day to
day business of web app development. In any case, as I think more
about various if/else claues or business specific computations, I get
even more
Sorry,
First day of spring for this promotion = March 21st
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Wed, 2006-03-01 at 13:54, Russ Brown wrote:
I know I've said it before, but I would without a shadow of a doubt buy
this if it ran natively under Linux. :(
I've tried it under Wine and it was just too slow and unstable to be
useful.
Pity...
what_he_said++;
Hi,
I am new to Postgresql, so pls be patient.
I am using npgsql with C# to insert a bytea value into a
column which will serve as an encrypted password. This works
well. However, when I retrieve the value, it is different.
In other words, select pwd from table where pwd like @pwd
does not work.
falcon schrieb:
Pete,
...
So why not attempt to use databases as more than just data stores?
P.S. I actually don't think the kind of framework I am looking for
exists (oracle has html db, but I haven't been able to study it yet).
And I should add that I realize theoretical Relational Dbs
[EMAIL PROTECTED] writes:
I am using npgsql with C# to insert a bytea value into a
column which will serve as an encrypted password. This works
well. However, when I retrieve the value, it is different.
In other words, select pwd from table where pwd like @pwd
does not work.
Why are you
On Wed, Mar 01, 2006 at 10:40:39AM -0800, [EMAIL PROTECTED] wrote:
I am using npgsql with C# to insert a bytea value into a
column which will serve as an encrypted password. This works
well. However, when I retrieve the value, it is different.
Different how? Without knowing more I'd wonder
On 3/1/06, Florian G. Pflug [EMAIL PROTECTED] wrote:
My company wants to run Typo3, and I'd like it to run against postgresql
instead of mysql (Don't want to have to administer a mysql database ;-).
I've googled a bit now, and it seems that I need ADODB for php + some
Typo3 extension.
Does
Though, it is pretty easy to do something like:
select 'GRANT ALL ON ' || table_name || ' TO public;' from
information_schema.tables where table_schema='blah';
You can feed the output of that to psql, ei:
psql -qc select 'GRANT ALL ON ' || table_name || ' TO public;' from
I love Linux, any tool you need it has it. Just try to find the most basic of tools for Windows, what a joke.
I need an Open Source SQL command line tool for Windows that will let me script queries to a database over an ODBC connection. It must use ODBC because it may or may not be
Hi to all,
I have a little problem, I am working with postgres 8.1.2 and I am
creating some store procedure, I would like to handle inside to them
the commit and rollback functionality, but If I entry commit command I
am not able to exceute the funciotn anymore.
PLease could someone help me to
On Mar 2, 2006, at 6:39 , Greg Donald wrote:
Typo uses migrations, so it should be database agnostic.
I believe Florian is referring to Typo3, a CMS
http://www.typo3.com/
Not Typo, a blogging app
http://www.typosphere.org/
Michael Glaesemann
grzm myrealbox com
Roy Souther wrote:
I love Linux, any tool you need it has it. Just try to find the most
basic of tools for Windows, what a joke.
I need an Open Source SQL command line tool for Windows that will let
me script queries to a database over an ODBC connection. It must use
ODBC because it may or
On Thu, Mar 02, 2006 at 12:34:25AM +0100, [EMAIL PROTECTED] wrote:
I have a little problem, I am working with postgres 8.1.2 and I am
creating some store procedure, I would like to handle inside to them
the commit and rollback functionality, but If I entry commit command I
am not able to
try activestate perl, I have used it a number of times on windows XP/2000 for
CLI stuff (data loading).
-- Original Message ---
From: Roy Souther [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Wed, 01 Mar 2006 16:00:21 -0700
Subject: [GENERAL] Need a GNU SQL CLI tool
I have PL/PGSQL functions that require temporary tables for storing
intermediate query output.
I used to create a temporary table with a unique name in each function
call, but that led to out of shared memory errors and bloating of
system catalogs, because temp tables are only actually dropped at
On Mar 1, 2006, at 6:00 PM, Roy Souther wrote:
I love Linux, any tool you need it has it. Just try to find the
most basic of tools for Windows, what a joke.
I need an Open Source SQL command line tool for Windows that will
let me script queries to a database over an ODBC connection. It
On Wednesday 01 March 2006 14:54, falcon wrote:
P.S. I actually don't think the kind of framework I am looking for
exists (oracle has html db, but I haven't been able to study it yet).
And I should add that I realize theoretical Relational Dbs are
different from modern implementations, but we
activestate perl works a treat and crimson editor
(http://www.crimsoneditor.com/) as an editor. If you want a gui
database manager with sql scripting try aqua data :
http://www.aquafold.com/
Cheers
Noel
Roy Souther wrote:
I love Linux, any tool you need it has it. Just try to find
Robert,
As soon as I have some time, I'll be checking out pl-python in more
detail.
Tino,
I don't know anything about zope, I'll have a look see :)
---(end of broadcast)---
TIP 6: explain analyze is your friend
Just Someone [EMAIL PROTECTED] writes:
I researched it a bit, and tried a few things, and discovered that the
problem is in the init script at /etc/init.d/postgres users runuser
instead of su on SELinux enabled systems. But for some reason it won't
work this way. I manually reveted it to use
Hi Tom,
I looked into another system I have and after updating FC4 to the
latest and installing the latest from the PGDG srpms, I didn't have
this problem.
Tomorrow I'm going to do a similar test on another server that I have
to install Postgres on. I will report back with what I find on it. But
41 matches
Mail list logo