# [EMAIL PROTECTED] / 2005-05-19 12:14:58 -0400:
> lister <[EMAIL PROTECTED]> writes:
> > This was the topic of 20 minutes of conversation in 2 tutorials
> > at BSDCan.
>
> Well, if the BSD people are so concerned about it, why don't they fix
> their bleedin' OS? It's inexcusable to have a "jail
You will need to modify your shared memory settings or change your
shared_buffers parameter in the postgresql.conf file. (Most likely need to
increase SHMMAX as the default for OSX is quite low as I recall)
Take a look here:
http://www.postgresql.org/docs/8.0/static/kernel-resources.html
There
On Wed, 2005-06-01 at 00:27 -0400, Alvaro Herrera wrote:
> On Wed, Jun 01, 2005 at 01:21:28AM +0100, Simon Riggs wrote:
> > On Tue, 2005-05-31 at 18:28 +0200, Harald Fuchs wrote:
>
> > > SELECT g.num
> > > FROM generate_series ((SELECT min(doc_numero) FROM bdocs),
> > > (SELE
In article <[EMAIL PROTECTED]>,
Simon Riggs <[EMAIL PROTECTED]> writes:
> If the WHERE clause said bdocs.doc_numero > 7 we would hope that this
> was applied before the join.
Stating this would change the OUTER into an INNER JOIN, and this would
imply that the order of the restrictions is irrelev
Robert Treat wrote:
> On Tuesday 24 May 2005 23:49, Tom Lane wrote:
> > Bruno Wolff III <[EMAIL PROTECTED]> writes:
> > > "Marc G. Fournier" <[EMAIL PROTECTED]> wrote:
> > >> Estimate right now for going beta on 8.1 is July 1st ... aiming for a
> > >
> > > Isn't that feature freeze? Typically the
Hi
I'm a new user to Postgresql.
I've installed it as an application in Windows. My intent is to gain
experience in using sql to build a database.
I'm having problems understanding how to begin.
When I start the database is there any indicator that it is actually
running?
Do I need t
Is it possible to prevent a user from changing their password?
I have a database with a 'Guest' account, that will have limited
access. I don't want any of my guests to change the Guest account
password.
tia
Richard
---(end of broadcast)---
TIP 2:
Bob,
On May 31, 2005, at 3:24 PM, Bob Pawley wrote:
I'm a new user to Postgresql.
I've installed it as an application in Windows. My intent is to gain
experience in using sql to build a database.
I'm having problems understanding how to begin.
When I start the database is there any indi
Simon Riggs wrote:
You could use something like that:
SELECT g.num
FROM generate_series ((SELECT min(doc_numero) FROM bdocs),
(SELECT max(doc_numero) FROM bdocs)) AS g(num)
LEFT JOIN bdocs ON bdocs.doc_numero = g.num
WHERE bdocs.doc_numero IS NULL
SELECT g.num
FROM gener
Hello SQL Aces !
I want to do a select on a table distinct on linkid and sorted by
date. I have try this
SELECT DISTINCT ON (linkid) * FROM all_links
WHERE uid='2' AND DATE_TRUNC('day',read_date) = DATE_TRUNC('day',
TIMESTAMP '2005-06-01') ORDER BY linkid, read_date;
With this req
you can also try this =)
select
o1.doc_numero+1 as first,
((select doc_numero from bdocs where id > o1.doc_numero+1 order by doc_numero limit 1))-1 as last
from bdocs as o1
where o1.doc_numero+1 not in (select o2.doc_numero from bdocs as o2)
order by doc_numero2005/5/31, josue <[EMAIL PR
Hello
Everybody, somebody knows if its possible to catch one sentences in full SQL
using the triggers, or maybe somebody have any idea about to how do
it?
I am
using postgreSQL 7.3 on fedora core 1
Thanks in
advancedManuel
how about (untested)
select *
from
(
SELECT DISTINCT ON (linkid) *
FROM all_links
WHERE uid='2' AND DATE_TRUNC('day',read_date) = DATE_TRUNC('day',TIMESTAMP
'2005-06-01')
ORDER BY linkid
) A
ORDER BY read_date DESC limit 100
-- Original Message ---
From: FC <[EMAIL PROTECTED
Simon Riggs <[EMAIL PROTECTED]> writes:
> On Wed, 2005-06-01 at 00:27 -0400, Alvaro Herrera wrote:
>>> SELECT g.num
>>> FROM generate_series ((SELECT min(doc_numero) FROM bdocs),
>>> (SELECT max(doc_numero) FROM bdocs)) AS g(num)
>>> LEFT JOIN bdocs ON bdocs.doc_numero = g.num
>>> WHERE bdocs.doc_n
Greetings!
At some point, I'm not even sure when, I apparently had a bad upgrade on
one of my production databases. I'm in a situation now where I've got
my back up against a wall and not sure what to do. The problem is, I'm
receiving this message frequently:
did not find '}' at end of inp
On Wed, Jun 01, 2005 at 04:40:48PM +0200, FC wrote:
>
> Hello SQL Aces !
>
> I want to do a select on a table distinct on linkid and sorted by
> date. I have try this
How about a subquery?:
SELECT * FROM
( SELECT DISTINCT ON (linkid) * FROM all_links
WHERE uid='2' AND DATE_TRUNC('day',rea
I'm looking for a way to enable a function to commit a unit of work that
does not affect the caller's transaction. I'm coming from the Oracle
world where I've used the "autonomous_transaction" pragma of PL/SQL to
do this. I'm new to Postgres, but I'm hopeful that I can move our
systems from Oracl
Richard Hayward <[EMAIL PROTECTED]> writes:
> Is it possible to prevent a user from changing their password?
No.
> I have a database with a 'Guest' account, that will have limited
> access. I don't want any of my guests to change the Guest account
> password.
Perhaps you should use something oth
Manuel García wrote:
Hello Everybody, somebody knows if its possible to catch one
sentences in full SQL using the triggers, or maybe somebody have any
idea about to how do it?
I am using postgreSQL 7.3 on fedora core 1
If I understand, you want to access the query, e.g. "SELECT * FROM
my_tabl
I'm cross posting this because it is an excellent opportunity for students.
I was a paid intern (studying pterodactyls), and my company employs paid
interns to perform well bounded summer projects. The intern gains
invaluable industry experience and a semester's worth of tuition (or beer).
One mor
Gerald D. Anderson wrote:
Greetings!
At some point, I'm not even sure when, I apparently had a bad upgrade on
one of my production databases. I'm in a situation now where I've got
my back up against a wall and not sure what to do. The problem is, I'm
receiving this message frequently:
did
Hi,
Can pg_dump be used to backup a selected number of tables, (rather than
All or One)?
We have a case where we need to backup tables of the form sale_2001xx,
or sale_2002xx, etc.
Our current solution is the following:
pg_dump -d dbname -t sale_200101 > sales_2001_dump
pg_dump -d dbn
data # pg_dump -Fc -f blah.txt -tforums_auth forums22 -u
User name: postgres
Password:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: did not find '}' at end of
input node
pg_dump: The command was: SELECT (SELECT usename FROM pg_user WHERE
usesysid = datdba) as d
Ok. Richard, that is that I need to do, I need to create a log table with
all the information that is changed on every row that was update, delete or
insert, additionally I must be record the user that do that. At this point I
don't have troubles I can do that, but I need to get the full sentenc
On Wed, Jun 01, 2005 at 10:24:25AM -0500, Gerald D. Anderson wrote:
> Greetings!
>
> At some point, I'm not even sure when, I apparently had a bad upgrade on
> one of my production databases. I'm in a situation now where I've got
> my back up against a wall and not sure what to do. The problem
On Wed, Jun 01, 2005 at 03:38:01PM +, Matt Miller wrote:
> I'm looking for a way to enable a function to commit a unit of work that
> does not affect the caller's transaction. I'm coming from the Oracle
> world where I've used the "autonomous_transaction" pragma of PL/SQL to
> do this. I'm ne
I need to remember to keep things simple...
Works fine, thanks.
Fred
On Jun 1, 2005, at 5:20 PM, Jim Buttafuoco wrote:
how about (untested)
select *
from
(
SELECT DISTINCT ON (linkid) *
FROM all_links
WHERE uid='2' AND DATE_TRUNC('day',read_date) = DATE_TRUNC
('day',TIMESTAMP '2005-06-01'
On Jun 1, 2005, at 11:52 AM, Bob Pawley wrote:
Dear Mr. DeSoi
Thank you for responding.
I originally installed it as a service. However, I wasn't able to make
the connection to the server. (I am assuming the red X next to the
server name means that it is off.)
Thinking there might be a bu
On Wed, 2005-06-01 at 10:52, Alvaro Herrera wrote:
> On Wed, Jun 01, 2005 at 03:38:01PM +, Matt Miller wrote:
> > I'm willing to use a different language, or even the libpq API if
> > necessary.
>
> If you really need autonomous transactions, you can establish an
> independent connection with
"Scott Marlowe" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Fri, 2005-05-27 at 09:57, [EMAIL PROTECTED] wrote:
>
>>
>> Thanks for answer Tom
>>
>> "Consider what happens when the user leaves for lunch"
>>
>> Well, I've already thought about it.But I'm working with
>> VS2003 an
On Tue, May 31, 2005 at 18:03:04 +0100,
Richard Hayward <[EMAIL PROTECTED]> wrote:
> Is it possible to prevent a user from changing their password?
>
> I have a database with a 'Guest' account, that will have limited
> access. I don't want any of my guests to change the Guest account
> password.
Tom Lane wrote:
Gary Horton <[EMAIL PROTECTED]> writes:
[ assorted startup problems ]
You did not say what platform this is on, nor which Postgres version
you are running. Tsk tsk.
Actually I did mention 7.3.4 Postgres but obviously I didn't do it
clearly. I really
Gerald D. Anderson wrote:
data # pg_dump -Fc -f blah.txt -tforums_auth forums22 -uUser
name: postgres
Password:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: did not find '}' at end of
input node
pg_dump: The command was: SELECT (SELECT usename FROM pg_user WHE
Gary Horton <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> The -w-doesn't-wait-long-enough bit needs investigation.
> No messages, no smoking gun. If you mean running the sh script with -x,
> it's really not complicated enough to warrant that - I've added echo
> statements to confirm that it's
Manuel García wrote:
Ok. Richard, that is that I need to do, I need to create a log table
with all the information that is changed on every row that was update,
delete or insert, additionally I must be record the user that do that.
At this point I don't have troubles I can do that, but I need t
Tom Lane wrote:
Yeah ... in fact, if you read the script, what it does is loop until a
psql -l succeeds ... so why wouldn't your following instance also
succeed?
regards, tom lane
Ah, I think that you mean to run pg_ctl with a -x option (not my own sh
script). I didn't realize I cou
Richard Huxton writes:
> Yep - I'm guessing it's an issue with an array (group membership?) in
> pg_user.
No, I'll bet lunch that Alvaro fingered the correct culprit: either
addition or subtraction of that darn hierarchical-query patch. It
changes the on-disk representation of view rules in a w
What's the current status on psql handling typos and interrupts more usefully
by automatically encapsulating every statement in a savepoint? I'm just
curious whether it's already in for 8.1 or if it got stalled.
I ask because I just got bit again by a typo where I accidently deleted the
wrong dat
Hello,
I have a table, structure like this:
create table product(
sku, int4 not null,
category int4 null,
display_name varchar(100) null,
rank int4 null
)
let say example data:
sku, category, display_name
===
10001, 5, postgresql, 132
10002, 5, mysql, 243
10003, 5, oracl
Hello!
I have a view that I'm putting into a report in my application. I'd
like to get several blank lines returned by the view as well as the
legitimate data (to leave room in the report for manual entries). I
thought I could make a SRF that would return the data from the view and
then spit out
Greg Stark wrote:
>
> What's the current status on psql handling typos and interrupts more usefully
> by automatically encapsulating every statement in a savepoint? I'm just
> curious whether it's already in for 8.1 or if it got stalled.
>
> I ask because I just got bit again by a typo where I ac
[EMAIL PROTECTED] wrote:
Hello!
I have a view that I'm putting into a report in my application. I'd
like to get several blank lines returned by the view as well as the
legitimate data (to leave room in the report for manual entries). I
thought I could make a SRF that would return the data from
> Original Message
> Subject: Re: [GENERAL] SRFs returning records from a view
> From: "Joshua D. Drake" <[EMAIL PROTECTED]>
> Date: Wed, June 01, 2005 4:39 pm
> To: [EMAIL PROTECTED]
> Cc: pgsql-general@postgresql.org
>
> [EMAIL PROTECTED] wrote:
> > Hello!
> >
> > I have a v
thanks for your reply,
I did not presume that it is a bug, I am interested to know how can I
setup a "hot standby" (if is some more documentation available).
===QUOTE FROM DOCS===
If we continuously feed the series of WAL files to another machine that
has been loaded with the same base backu
On Thu, 2005-06-02 at 01:13 +0300, [EMAIL PROTECTED] wrote:
> In this case do you know what is the timeout on the "restore_command"
> command (or where I can find it in documentation).
There isn't one. You decide when restore_command returns.
> What will happen if I make the restore command wait
On Wed, 2005-06-01 at 16:16 -0500, Yudie Pg wrote:
> Hello,
> I have a table, structure like this:
[...]
> Expected query result:
>
> sku, category, display_name, category_count
>
> 10001, 5, postgresql, 3
> 10006, 7, photoshop, 2
> 10008, 9, Windows XP, 2
Thank you Tom.
It was a bit confusing because my WHERE clause looked something like this:
... WHERE date_field - current_date < '21 days'::interval;
And then I got records, whose with date_field's year was 2010. :-o
Now I am using this formula:
... WHERE date_field < current_date + '21 days'::i
I have several large tables (10 million to 200 million rows) that have
foreign keys with each other by *convention*, but no actual FOREIGN KEY
constraints.
Over the course of years, orphaned records (children with no parent) have
accumulated and now I want to clean them up. I can't just create th
On Thu, Jun 02, 2005 at 01:54:12 +0200,
Havasvölgyi Ottó <[EMAIL PROTECTED]> wrote:
> Thank you Tom.
>
> It was a bit confusing because my WHERE clause looked something like this:
>
> ... WHERE date_field - current_date < '21 days'::interval;
>
> And then I got records, whose with date_field's
"Roman F" <[EMAIL PROTECTED]> writes:
> ... Executing something like
> the following statement would work, but even with indexes it takes an
> insane amount of time to execute for each of the tables:
> DELETE FROM child_table WHERE parentid NOT IN
> (SELECT parentid FROM parent_table)
Uh, what
50 matches
Mail list logo
