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
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
subscribe
end
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
> -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
Thanks for the info, everyone.Tomislav
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
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
> > 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
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
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
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
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
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
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
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
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
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.
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
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
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
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
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
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
-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
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
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 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)
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
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
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
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
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
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
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
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
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
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.
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
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
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
-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
"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
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
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
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
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
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
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
"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:
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
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
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
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!
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
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
>
55 matches
Mail list logo
