Tom Lane wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>> Michael Louie Loria wrote:
>>> How do I run PostgreSQL with Administrator account in Windows?
>
>> You can't. It is a security issue and we don't allow it.
>
> FYI, there is code in CVS HEAD to allow starting the postmaster from
>
xia_pw wrote:
> Hi,I have read the source codes of pgsql these days,and I want to know
> which part of the source codes deal with the function of executing the
> sql(select,alter,and so on),and which function deal with the query
> operation. Thank!
Why?
If you want to add functionality you'll
Hi,I have read the source codes of pgsql these days,and I
want to know which part of the source codes deal with the function of executing
the sql(select,alter,and so on),and which function deal with the query
operation. Thank!
On Thu, 9 Mar 2006, Tony Smith wrote:
> I have two tables action and group:
>
> action
>
> id,
> name
>
> group:
>
> action_id
> rank
>
> I what to select from action table by order by the
> rank in the group table.
>
> If I use
>
> select * from a
Tony Smith wrote:
I have two tables action and group:
action
id,
name
group:
action_id
rank
I what to select from action table by order by the
rank in the group table.
If I use
select * from action where id in (select action_id
from group o
Tony Smith wrote on
Thursday, March 09, 2006 6:33 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] select where in and order
>
>
> I have two tables action and group:
>
> action
>
> id,
> name
>
> group:
>
> action_id
> rank
>
> I wh
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Michael Louie Loria wrote:
>> How do I run PostgreSQL with Administrator account in Windows?
> You can't. It is a security issue and we don't allow it.
FYI, there is code in CVS HEAD to allow starting the postmaster from
an admin account via pg_ctl:
Joshua D. Drake wrote:
> You can't. It is a security issue and we don't allow it.
>
> Joshua D. Drake
>
Thanks Joshua. that was a quick response.
Michael Louie Loria
LoRz Technology Solutions
http://www.lorztech.com
signature.asc
Description: OpenPGP digital signature
I have two tables action and group:
action
id,
name
group:
action_id
rank
I what to select from action table by order by the
rank in the group table.
If I use
select * from action where id in (select action_id
from group order by rank)
The ac
Michael Louie Loria wrote:
Hello,
How do I run PostgreSQL with Administrator account in Windows?
I know this is a security issue but I just want to test it in my
Administrator account.
You can't. It is a security issue and we don't allow it.
Joshua D. Drake
Thanks,
Michael Louie Loria
L
Hello,
How do I run PostgreSQL with Administrator account in Windows?
I know this is a security issue but I just want to test it in my
Administrator account.
Thanks,
Michael Louie Loria
LoRz Technology Solutions
http://www.lorztech.com
signature.asc
Description: OpenPGP digital signature
Noel Faux <[EMAIL PROTECTED]> writes:
> To clarify, when set on, every time it hits this error, postgres will
> rezero that block?
It'll only "re" zero if the page gets dropped from shared memory without
there having been any occasion to write it out. Otherwise, the first
write will clobber the
On Thursday 09 March 2006 11:31, Mongi LASSOUED wrote:
> Hello
> I have the postgresql installed on Fedora Core 4. I have set
> tcpip_socket=true
> in posgresql.conf file and specified the host ip adress in pg_hba.conf
> file. When i start the postmaster i have this error:
> FATAL: unrecognized con
"Mongi LASSOUED" <[EMAIL PROTECTED]> writes:
> I have the postgresql installed on Fedora Core 4. I have set
> tcpip_socket=true
> in posgresql.conf file and specified the host ip adress in pg_hba.conf file.
> When i start the postmaster i have this error:
> FATAL: unrecognized configuration parame
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I stopped getting any mail from postgresql.org last fall. Repeated
> attempts to subscribe have all been met with silence. Something
> appears to have changed.
You are still subscribed, but your address was set to "nomail". I've
flipped it back to
Ycrux <[EMAIL PROTECTED]> writes:
> # SELECT grantAccess('sara', 'sarapass');
> ERROR: set-valued function called in context that cannot accept a set
You need to do "SELECT * FROM grantAccess(...)". This is a plpgsql
implementation restriction that we'll probably try to fix someday,
although the
I made a restore from a database without tsearch2 installed, installed
tsearch2 executing tsearch2.sql and than used it successfully. One day after
this i obtained that error as if a database corruption occurred...however
noone has touched the database...
Thanks for the answers
John slave
--
View
Hello
I have the postgresql installed on Fedora Core 4. I have set
tcpip_socket=true
in posgresql.conf file and specified the host ip adress in pg_hba.conf file.
When i start the postmaster i have this error:
FATAL: unrecognized configuration parameter "tcpip_socket"
can you help me??!!
thanks a
Hi,
this is to inform you that I just downloaded and build PostgresSQL
8.1.3 on Mac OS X 10.4 Intel without any problems.
No surprise for you perhaps, but a big surprise for me.
Since make and compilers on Mac OS X are always GNU, I expected to be
able to build PostgresSQL with some effort.
Is there any documentation or literature on storage estimation for
PostgreSQL 8.1 on Windows?
If I am given raw data file structure and frequency, I want to be able
to calculate the amount of storage necessary to store one day, one
month, six months, one year, or two years worth of data. So I am
l
Yes, I was indeed out of memory. That is the problem: the postgres.exe
process corresponding to the pg_restore continuously consumes more and
more memory until it runs out and fails with the mentioned error. Since
I already have 4Gb of RAM, throwing more hardware at it is not a
feasible solution, s
Tom was exactly right.
I was trying to restore the dump file into an already created table
structure that did have three foreign key constraints. I removed the
primary key constraint to speed up the load, but was not aware of the
memory usage of the foreign keys.
I dropped the table and ran the p
To clarify, when set on, every time it hits this error, postgres will
rezero that block?
Michael Fuhr wrote:
On Thu, Mar 09, 2006 at 03:57:46PM +1100, Noel Faux wrote:
Given that this seems problem has occurred a number of times for a
number I've written a small step by step proc
In article <[EMAIL PROTECTED]>,
Marc G. Fournier <[EMAIL PROTECTED]> wrote:
>So how did you get this message? :(
Via Usenet.
--
http://yosemitephotos.net/
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hi All!
I'm trying to get working the below PL/pgSQL function without sucess.
The function is correctly created, but when I tested it i got:
# SELECT grantAccess('sara', 'sarapass');
ERROR: set-valued function called in context that cannot accept a set
CONTEXT: PL/pgSQL function "grantaccess" l
On Thu, 9 Mar 2006, Rick Ellis wrote:
In article <[EMAIL PROTECTED]>,
Roman Neuhauser <[EMAIL PROTECTED]> wrote:
I've been waiting five months for the majordomo moderators to approve
my subscription requests to several @postgresql.org mailing lists.
I stopped getting any mail from postgresql
On Thu, Mar 09, 2006 at 12:56:21 -0500,
Chris Kratz <[EMAIL PROTECTED]> wrote:
> Hello All,
>
> Is there any way in postgres to have an aggregate that uses input from two
> columns without using composite types? The example we are working on is a
> first or last aggregate which requires a dat
In article <[EMAIL PROTECTED]>,
Roman Neuhauser <[EMAIL PROTECTED]> wrote:
>I've been waiting five months for the majordomo moderators to approve
>my subscription requests to several @postgresql.org mailing lists.
I stopped getting any mail from postgresql.org last fall. Repeated
attempts to subs
I may not fully understand your situation but
SELECT distinct grouping,
(SELECT integer_column FROM test.test_agg_last WHERE
grouping=t1.grouping ORDER BY cur_date DESC LIMIT 1) AS last_int,
(SELECT integer_column FROM test.test_agg_last WHERE
grouping=t1.grouping ORDER BY cur_date ASC LIMIT 1)
Richard Huxton wrote:
Larry White wrote:
SELECT * FROM Tasks
UNION ALL
SELECT * FROM Issues;
In case you care about where a record originated from:
SELECT *, 'Tasks' AS source FROM Tasks
UNION ALL
SELECT *, 'Issues' AS source FROM Issues;
Regards,
--
Alban Hertroys
[EMAIL PROTECTED]
magprod
I'll try it.
Thanks for your help.
Bob
- Original Message -
From:
Daniel
Blaisdell
To: Bob Pawley
Cc: Postgresql
Sent: Thursday, March 09, 2006 11:58
AM
Subject: Re: [GENERAL] JDBC
-BEGIN PGP SIGNED MESSAGE-Hash: SHA1I'm
assuming that your rea
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'm assuming that your real postgres version is 8.1 and that what
you're reporting is just 8.1.2-1 release for windows. Thebest place to
get JDBC drivers for postgres is http://jdbc.postgresql.org
I would recommend downloading the JDBC3 driver for 8.1
OK. the error was that: postgress didn't recognize which was the
NULLstring, because the format file was: value1*value2**value4, where the
delimiter is: * .
I learnd the default NULL string is '\N', but as you told me, you can
specify this in the command definition.
Thanks Michael.
Fro
I am attempting to connect Postgresql (Windows XP, Version
1.2.1 March 28, 2005 (in the PG Admin 3 about ) to Java Studio Creator
2.
Of the four selections presented can someone point to the
driver I should use for PG Version 1.2.1???
Bob
On Thu, Mar 09, 2006 at 03:57:46PM +1100, Noel Faux wrote:
> Given that this seems problem has occurred a number of times for a
> number I've written a small step by step procedure to address this
> issue. Is there any other comments you which to add. I was thinking
> that this should be added
On Thu, Mar 09, 2006 at 12:49:14PM -0600, Enrique Sánchez wrote:
> I nedd to fill a database table x from a file With the COPY command an the
> delimiter '*'.
> This table has a timestamp null column (I declared like: ' birthday
> timestamp NULL' ).
>
> But when I try to insert NULL values(spe
Chris Kratz wrote:
> Well for anyone else who may be interested in doing something similar, here is
> what we did. It does require typecasting going into the functions, composite
> types and using the dot notation to get the value back out of the composite
> object returned. But it works.
>
> Thi
Thanks Tom,
Well for anyone else who may be interested in doing something similar, here is
what we did. It does require typecasting going into the functions, composite
types and using the dot notation to get the value back out of the composite
object returned. But it works.
This is what we w
Hi! I'm new in Postgres.
I nedd to fill a database table x from a file With the COPY command an the
delimiter '*'.
This table has a timestamp null column (I declared like: ' birthday
timestamp NULL' ).
But when I try to insert NULL values(specified in the file), postgres throw
an error.
Chris Kratz <[EMAIL PROTECTED]> writes:
> Is there any way in postgres to have an aggregate that uses input from two
> columns without using composite types?
No.
regards, tom lane
---(end of broadcast)---
TIP 9: In versions
Hello All,
Is there any way in postgres to have an aggregate that uses input from two
columns without using composite types? The example we are working on is a
first or last aggregate which requires a data value and a date column. The
result would be to find the latest date within the group a
Hi All,
Does anyone here have any experience with ExtenDB? We were
looking into this as a solution for a database server cluster that our company
will be putting online this fall and would appreciate any feedback anyone can
give concerning this, or any of the other open source cluster
In addition to the other replies (regarding UNION), are you aware that
you can use inheritance in postgres to factor out common fields ? Then
you could use the parent table to access the common denominator of the
children. I'm not sure though if this fits your needs, just worth
mentioning.
See also
Larry White wrote:
I need a read only view that concatenates data from two tables. Basically
both tables would need a simple query like
Select name, description, date from Tasks;
Select name, description, date from Issues;
Is there some way to wrap these two independent queries in a "CREATE VI
On Mar 10, 2006, at 0:55 , Larry White wrote:
Is there some way to wrap these two independent queries in a
"CREATE VIEW myview AS" statement?
CREATE VIEW myview AS
Select name, description, date from Tasks
UNION
Select name, description, date from Issues;
Michael Glaesemann
grzm myrealbox c
On Thu, Mar 09, 2006 at 10:55:12AM -0500, Larry White wrote:
> I need a read only view that concatenates data from two tables. Basically
> both tables would need a simple query like
>
> Select name, description, date from Tasks;
>
> Select name, description, date from Issues;
>
> Is there some w
I need a read only view that concatenates data from two tables. Basically both tables would need a simple query like
Select name, description, date from Tasks;
Select name, description, date from Issues;
Is there some way to wrap these two independent queries in a "CREATE VIEW myview AS" statem
> > Background:
> > 1. I read people were using PostGreSQL with TeraBytes of data
> > sometimes, or thousands of users. These are things that could easily
> > break SQL Server. - So I thought PostGreSQL might be similar fast to
> > SQL Server. 2. I did some tests: Windows XP SP2
> > Several GIGs fr
On 3/7/06, Ken Johanson <[EMAIL PROTECTED]> wrote:
> Just a quick thought, and an possibly over-optimistic forecast:
> I'm am SOOO looking forward to hearing the beta announcement for 8.2...
> hopefully that version's still on target for the standard string escape
> option.. This *one* roadblock wi
On 3/9/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> Steve Atkins <[EMAIL PROTECTED]> writes:
> >>> make it happy by inserting a dummy row into the toast table (chunk ID
> >>> as specified in the error, chunk sequence 0, any old data value).
>
> > Any attempt to touch the toast table gives me:
> > ERRO
Thanks for the info, everyone.Tomislav
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of levi godinez
> Sent: 09 March 2006 07:39
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] double-quoted field names in pgadmin
>
> Hi,
>
> How to turn off the double-quoted field names in
subscribe
end
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
xia_pw wrote:
> Hi,guys.Who knows the structure of the pgsql source codes.What I
> means is that the content of the source codes and its function.
The source code is downloadable from the website at
http://www.postgresql.org/ and there are details at
http://www.postgresql.org/developer/
You may
Tom Lane wrote:
Richard Huxton writes:
Matroska80 wrote:
Hi i have a problem using tsearch2 with postgresql. Executing:
SELECT to_tsquery('default','kj');
return a
cache lookup failed for function 141542.
Try the following:
SELECT oid,* FROM pg_proc WHERE proname='to_tsquery';
That should
55 matches
Mail list logo