On Jul 13 08:28, Claire McLister wrote:
Have you considered using a set instead? We had a similar need and
were using an array as a parameter. That turned out to be taking too
long. Recently we have changed it to a set and it seems to work
faster, although I must admit I haven't timed it
* Agent M.:
timestamp with time zone does not record the timezone you inserted it
with- it simply stores the GMT version and converts to whatever
timezone you like on demand.
Are you sure? This behavior is not documented, and I can't reproduce
it with PostgresQL 8.1.4.
--
Florian Weimer
Title: Re: [GENERAL] cant connect to the database, even after doing start
this is what is
happening
stop(){ echo
"Stopping ${NAME} service: " if [
"`uname`" = "Linux" ];
then /bin/sh -c
"$PGCTL stop -D $PGDATA -s -m fast" /dev/null
21
fi
ret=$? if [ $ret -eq 0
]
then
On Thu, Jul 13, 2006 at 04:35:20PM -0700, Antimon wrote:
Hi,
I'm working on a web project with pgsql, i did use mysql before and
stored epoch in database so i'm not familiar with these datatypes.
What i wanna ask is, if i don't need to display timestamps in different
timezones, shall i use
Thanks for the replies, and thanks for mentioning the DST thing.
So, i'm going to use tstz. I just don't want my data to be affected by
timezone changes and dst etc.
I had a game server which had a timer system, when i delay something it
was creating an object with timestamp now + delaytime and
Hi,
Is it possible to read cleartext user password from pgsql database? In
this link
http://www.postgresql.org/docs/8.1/interactive/view-pg-user.html
explained that password always reads as . But I need to use
pgsql login/password as authentication info for another service.
--
Hello,
I have a certain setup, so that two computers are running nearly
identical databases: identical setup, tables, users and permissions,
only the contents differ. Now I'd like to keep them in sync, WITHOUT an
extra machine, hence master-slave setup. The problem is, that either one
could fail
On Fri, Jul 14, 2006 at 03:21:01PM +0400, Eugene Prokopiev wrote:
Hi,
Is it possible to read cleartext user password from pgsql database? In
this link
http://www.postgresql.org/docs/8.1/interactive/view-pg-user.html
explained that password always reads as . But I need to use
Martijn van Oosterhout wrote:
On Fri, Jul 14, 2006 at 03:21:01PM +0400, Eugene Prokopiev wrote:
Is it possible to read cleartext user password from pgsql database? In
this link
http://www.postgresql.org/docs/8.1/interactive/view-pg-user.html
explained that password always reads as .
Hi list,
with the following archive_command (on Windows) archive_command = 'copy
%p c:\\Archiv\\DBArchiv\\%f' I constantly have entries like the
following in my log file:
2006-07-14 14:26:59 LOG: archive command copy
pg_xlog\000100020037
c:\Archiv\DBArchiv\000100020037
Hi,
Could anyone help me with this. I want to see the definition of functions triggres for a perticular table of database.
How do I do this? How do I find whether is it Postgres SQL block or implemented in C/C++?
Thanks Regards,Hiren.
Hi,
somehow my reply yesterday got lost, but nevertheless here comes the
explain analyze again. It's the explain of the operation that causes
this huge performance discrepancy. Unfortunately i had to perform the
explain analyze with an empty temp_table, because after the whole
operation is done,
My apologies if this is not the correct group, but I did not find a
'phppgadmin' specific group.
When I login to phppgadmin, the list of databases does not include any
databases that are owned by a 'group' (i.e. a role with NOLOGIN set).
Databases owned by postgres or any specific user do show
In article [EMAIL PROTECTED],
Spendius [EMAIL PROTECTED] wrote:
% (I read the pages
% http://www.postgresql.org/docs/8.1/interactive/storage.html
% and saw things regarding files and pages that are usually 8k-big
% etc. but
% saw no further info about blocks - they speak of items here: what
% is
What's happening here?
I have two tables, encounter_properties_table with about 10 rows and
xfiles with about 50 rows. The structures of these tables is as follows:
Table public.encounter_properties_table
Column | Type | Modifiers
What are the exact specific
Windows Local Security Policy RightsREAUIRED for the user created to runthe
PostgreSQL8 service? And what are the exact specific rights that this
user absolutely CANNOT have? Thanks in
advance.
Sincerely,
Arah Leonard
After a system crash, postgresql 8.1.4 restarted but reported that I
have an apparent wraparound:
2006-07-13 14:03:40 PDT [10092] LOG: database system was interrupted at
2006-07-13 13:22:19 PDT
2006-07-13 14:03:40 PDT [10092] LOG: checkpoint record is at 1DD/26283E18
2006-07-13 14:03:40 PDT
You can use 'pgpool' (http://pgpool.projects.postgresql.org/) for that purpose.Shoaib MirEnterpriseDBOn 7/14/06,
Alexander Bluem [EMAIL PROTECTED] wrote:
Hello,I have a certain setup, so that two computers are running nearlyidentical databases: identical setup, tables, users and permissions,only
Hi list,
well now i know why it doesn't work. As the copy command did not work
for a while the wal-files where gathering like mad and, as a beginner, i
thought in order to clean up some disk space i should delete them. Well,
that was probably the most stupid thing to do, because now pgsql tries
On 7/14/06, Christian Rengstl
[EMAIL PROTECTED] wrote:
Hi,
somehow my reply yesterday got lost, but nevertheless here comes the
explain analyze again. It's the explain of the operation that causes
this huge performance discrepancy. Unfortunately i had to perform the
explain analyze with an
G. Ralph Kuntz, MD wrote:
What's happening here?
I have two tables, encounter_properties_table with about 10 rows and
xfiles with about 50 rows. The structures of these tables is as follows:
file_name | character varying(255) |
Table public.xfiles
Column
Florian Weimer [EMAIL PROTECTED] writes:
* Agent M.:
timestamp with time zone does not record the timezone you inserted it
with- it simply stores the GMT version and converts to whatever
timezone you like on demand.
Are you sure? This behavior is not documented, and I can't reproduce
it
On 7/14/06, Christian Rengstl
[EMAIL PROTECTED] wrote:
Hi list,
well now i know why it doesn't work. As the copy command did not work
for a while the wal-files where gathering like mad and, as a beginner, i
thought in order to clean up some disk space i should delete them. Well,
that was
Darren [EMAIL PROTECTED] writes:
When I login to phppgadmin, the list of databases does not include any
databases that are owned by a 'group' (i.e. a role with NOLOGIN set).
I'm betting that phppgadmin is using something like an inner join of
pg_database and pg_user to produce its display. As
On Fri, Jul 14, 2006 at 03:22:43PM +0200, Christian Rengstl wrote:
Hi list,
well now i know why it doesn't work. As the copy command did not work
for a while the wal-files where gathering like mad and, as a beginner, i
thought in order to clean up some disk space i should delete them. Well,
i made a pg_dump. Maybe it would help to delete the files in the
pg_xlog/archive_status directory...anyway the server just has a sandbox
status so far.
Merlin Moncure [EMAIL PROTECTED] 14.07.06 17.18 Uhr
On 7/14/06, Christian Rengstl
[EMAIL PROTECTED] wrote:
Hi list,
well now i know why it
On 13 Jul 2006 14:32:42 -0700, Karen Hill [EMAIL PROTECTED] wrote:
Roy Souther wrote:
I would like to know if there is anyway to move a section of some tables
into RAM to work on them.
I have large table, about 700MB or so and growing. I also have a bizarre
collection of queries that run
* Tom Lane:
Florian Weimer [EMAIL PROTECTED] writes:
* Agent M.:
timestamp with time zone does not record the timezone you inserted it
with- it simply stores the GMT version and converts to whatever
timezone you like on demand.
Are you sure? This behavior is not documented, and I can't
Alban Hertroys [EMAIL PROTECTED] writes:
G. Ralph Kuntz, MD wrote:
explain select file_name from encounter_properties_table where file_name not
in (select filename from xfiles);
What about:
explain select file_name from encounter_properties_table
where not exists (
select file_name
Reece Hart [EMAIL PROTECTED] writes:
After a system crash, postgresql 8.1.4 restarted but reported that I
have an apparent wraparound:
...
2006-07-13 14:03:40 PDT [10092] LOG: next MultiXactId: 5475264; next
MultiXactOffset: 13765525
...
2006-07-13 14:03:40 PDT [10092] LOG: could not
Nice, Richard, but you use max(startdate), how about the salary? i cant use max(salary) how about if he got a pay cut?My current solution is to write the nested query on the field list, like SELECT worker.*,
(select salary FROM position where worker_id=worker.worker_id and fecha='2006-04-01'
How about if we make it simpler, only 1 tablecreate table worker( name varchar(50), position varchar(50), startdate date, salary numeric(9,2));insert into worker values ('Jon', 'boss', '2001-01-1',
1000.00);insert into worker values ('Peter', 'cleaning', '2002-01-01', 100.00);insert into worker
On Fri, 2006-07-14 at 02:48, surabhi.ahuja wrote:
this is what is happening
stop(){
echo Stopping ${NAME} service:
if [ `uname` = Linux ]; then
/bin/sh -c $PGCTL stop -D $PGDATA -s -m fast /dev/null
21
fi
ret=$?
if [ $ret -eq 0 ]
On 15/07/2006, at 2:07 AM, Sergio Duran wrote:How about if we make it simpler, only 1 tablecreate table worker( name varchar(50), position varchar(50), startdate date, salary numeric(9,2));insert into worker values ('Jon', 'boss', '2001-01-1', 1000.00);insert into worker values
create table worker(
name varchar(50),
position varchar(50),
startdate date,
salary numeric(9,2));
insert into worker values ('Jon', 'boss', '2001-01-1', 1000.00);
insert into worker values ('Peter', 'cleaning', '2002-01-01', 100.00);
insert into worker values ('Peter',
This is what I did, I used plpgsql,create or replace function first_accum(anyelement, anyelement) returns anyelement as $$BEGIN IF $1 IS NOT NULL THEN return $1; ELSE return $2; END IF; END' language plpgsql;
then I created the aggregateCREATE AGGREGATE first(sfunc = first_accum, basetype =
- Original Message -
From: Sergio Duran [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Thursday, July 13, 2006 9:20 PM
Subject: [GENERAL] I need help creating a query
Hello,
I need a little help creating a query, I have two tables, worker and
position, for simplicity sake
Ok, all the suggestions were good.I think I'll stick with Marcin Mank's query for now, I'll also try to work further with Richard Broersma's query later.Thank you guys, you were really helpful.
On 7/14/06, Marcin Mank [EMAIL PROTECTED] wrote:
- Original Message -From: Sergio Duran [EMAIL
On Wed, Jul 12, 2006 at 13:38:34 -0700,
[EMAIL PROTECTED] wrote:
Hi,
Thanks again.
One more question. Will crosstab function work if i will not know the
number/names of columns before hand? Or I need to supply colum
headings?
I checked a bit into this, and the actual contrib name is
Tom Lane wrote:
I'd ask you the same question I asked Thomas: do you continue to get those
log messages
during subsequent checkpoints?
No, I don't. The error did not reappear during ~2h of continuous
inserts since my report, didn't reappear after a forced checkpoint
(i.e., via psql), and did
Reece --
The number of slots needed exceeds messages are telling you that the current
FSM (Free Space Map) does not have enough space allocated to track all of the
old tuples that are to be reused. I suspect that having such a situation would
effect the wraparound issue, since you'd have dead
Hai all,
I have 2
databases namee PAO and CAS.
PAO contains
3 schemas named Public,pao,sts
CAS contains
4 schemas named Public,cao,sts,reports
Now i
am in PAO database..now i want access table 'activity' in schema 'cas'
inCAS database.
How it is
posible.
2nd thing
is...
i have 2
On Sat, 15 Jul 2006 10:26:55 +0530
VivekanandaSwamy R. [EMAIL PROTECTED] wrote:
Hai all,
I have 2 databases namee PAO and CAS.
PAO contains 3 schemas named Public,pao,sts
CAS contains 4 schemas named Public,cao,sts,reports
Now i am in PAO database..now i want access table 'activity'
VivekanandaSwamy R. wrote:
Hai all,
I have 2 databases namee PAO and CAS.
PAO contains 3 schemas named Public,pao,sts
CAS contains 4 schemas named Public,cao,sts,reports
Now i am in PAO database..now i want access table 'activity' in
schema 'cas' in CAS database.
How it is posible.
2nd
Possible dblink, in the ./contrib directory would help ? I have never had to
use it but it seems like it might be what you need.
HTH,
Greg Williamson
DBA
GlobeXplorer LLC
-Original Message-
From: [EMAIL PROTECTED] on behalf of VivekanandaSwamy R.
Sent: Fri 7/14/2006 9:56 PM
To:
45 matches
Mail list logo
