Ralph Smith <[EMAIL PROTECTED]> writes:
> When I:
> [EMAIL PROTECTED]:/usr/lib/postgresql/7.4/bin$ psql -U
> airburst airburst -p 5433
> I get:
> psql: FATAL: IDENT authentication failed for user "airburst"
This is not surprising, seeing that you're evidently logged in as
postgres not
On Oct 19, 2007, at 16:42 , Richard Broersma Jr wrote:
Is it possible to constraint both the LEFT and RIGHT fields of a
record to use the same index? I am looking for a way to ensure for
all LEFTs and RIGHTs in a table, that is it is impossible for any
LEFT or RIGHT to have to same value.
--- On Fri, 10/19/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> > Is it possible to constraint both the LEFT and RIGHT
> > fields of a record to use the same index? I am looking for
> > a way to ensure for all LEFTs and RIGHTs in a table, that is
> > it is impossible for any LEFT or RIGHT to have
On Oct 19, 2007, at 7:37 PM, Scott Marlowe wrote:
On 10/19/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
Is it possible to constraint both the LEFT and RIGHT fields of a
record to use the same index? I am looking for a way to ensure
for all LEFTs and RIGHTs in a table, that is it is i
On 10/19/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> Is it possible to constraint both the LEFT and RIGHT fields of a record to
> use the same index? I am looking for a way to ensure for all LEFTs and
> RIGHTs in a table, that is it is impossible for any LEFT or RIGHT to have to
> same
On 10/19/07, Ralph Smith <[EMAIL PROTECTED]> wrote:
> > On 10/19/07, Ralph Smith <[EMAIL PROTECTED]> wrote:
> >> Thank you Scott!
> >>
> >> I'm away from my desk and will dive back into it.
> >> Fortunately I have two machines, each w/ 7.4 & 8.2 on them. New
> >> installs on Ubuntu 7.4.
> >>
> >>
Valerie Cole wrote:
> I have a problem and am pretty sure Hibernate is the culprit but was
> wondering if anybody knew of a fix. We are working on legacy code and
> converted a class from Hibernate 2 xml mappings to Hibernate 3 with
> annotations. On one of the One To Many attributes we have use
On Fri, 19 Oct 2007 18:19:55 -0500
Michael Glaesemann <[EMAIL PROTECTED]> wrote:
>
> On Oct 19, 2007, at 16:03 , Josh Trutwin wrote:
>
> > SELECT * FROM table WHERE foo="bar" ORDER BY abc LIMIT x OFFSET y;
>
> The server will have to generate at most OFFSET + LIMIT rows,
> returning LIMIT row
I have both 7.4 & 8.2 on this box.
Everything below is WRT v7.4
User postgres connects fine.
When I:
[EMAIL PROTECTED]:/usr/lib/postgresql/7.4/bin$ psql -U
airburst airburst -p 5433
I get:
psql: FATAL: IDENT authentication failed for user "airburst"
REFERRING TO /etc/postgresql/7.4/m
On Oct 19, 2007, at 16:03 , Josh Trutwin wrote:
SELECT * FROM table WHERE foo="bar" ORDER BY abc LIMIT x OFFSET y;
The server will have to generate at most OFFSET + LIMIT rows,
returning LIMIT rows or fewer.
SELECT * FROM table WHERE foo="bar" ORDER BY abc;
This will return all of the
Hello,
Thanks to everyone who registered, the numbers are quite a bit above
what we expected but alas, all good things come to an end (temporarily).
Registration for the conference is now closed!
See you all tomorrow morning!
And of course, we can't but say at least one more final thank you to
Hello
I have a problem and am pretty sure Hibernate is the culprit but was
wondering if anybody knew of a fix. We are working on legacy code and
converted a class from Hibernate 2 xml mappings to Hibernate 3 with
annotations. On one of the One To Many attributes we have used the
@OrderBy("dis
On 10/19/07, Ralph Smith <[EMAIL PROTECTED]> wrote:
Thank you Scott!
I'm away from my desk and will dive back into it.
Fortunately I have two machines, each w/ 7.4 & 8.2 on them. New
installs on Ubuntu 7.4.
As to why I had 'no role or database' errors yesterday, am I right
that it was either:
Is it possible to constraint both the LEFT and RIGHT fields of a record to use
the same index? I am looking for a way to ensure for all LEFTs and RIGHTs in a
table, that is it is impossible for any LEFT or RIGHT to have to same value.
---(end of broadcast)---
Hi,
I'm trying to install a Postgresql 8.1.10 in one external drive (Lacie
150GB, USB connection) attached into a Windows XP SP2 system. The
installation was interrupted with the message:
"PostgreSQL data directory must be on NTFS formatted volume".
The HD Lacie is new and formatted in NTFS.
NTF
"Kynn Jones" <[EMAIL PROTECTED]> writes:
> CREATE OR REPLACE FUNCTION canonicalize( anyelement, anyelement )
> RETURNS anyarray AS
> $$
> BEGIN
> IF $1 < $2 THEN RETURN ARRAY[ $1, $2 ];
> ELSERETURN ARRAY[ $2, $1 ];
> END IF;
> END;
> $$ LANGUAGE plpgsql;
You need to add IMMUT
On 10/19/07, Ralph Smith <[EMAIL PROTECTED]> wrote:
> Thank you Scott!
>
> I'm away from my desk and will dive back into it.
> Fortunately I have two machines, each w/ 7.4 & 8.2 on them. New
> installs on Ubuntu 7.4.
>
> As to why I had 'no role or database' errors yesterday, am I right
> that it
I'm going to be using a smarty plugin to paginate some result sets
for display in smarty templates. I was reading that using LIMIT/OFFSET
generates multiple query plans so I'm curious if it would be better
to do a:
SELECT * FROM table WHERE foo="bar" ORDER BY abc LIMIT x OFFSET y;
or just:
SELEC
Hi,
Le Friday 19 October 2007 22:29:37 Steve Crawford, vous avez écrit :
> > Do we use that term? Normally for us it's "large objects".
>
> Perhaps we should add "LO" but the documentation does refer to the term
> BLOB though typically in the context of "The SQL standard defines a
> different bin
Thank you Scott!
I'm away from my desk and will dive back into it.
Fortunately I have two machines, each w/ 7.4 & 8.2 on them. New
installs on Ubuntu 7.4.
As to why I had 'no role or database' errors yesterday, am I right
that it was either:
A) I accidentally did a pg_dump when I thought
On 10/19/07, Ralph Smith <[EMAIL PROTECTED]> wrote:
> I'm using 7.4 in preparation for an overdue upgrade.
>
> Yesterday I posted 2 questions that were ignored, so I'll try a third now.
>
> When doing a query I get same error as below, which are the results of
> vacuumdb.
>
> vacuumdb: vacuuming o
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/19/07 14:36, Alvaro Herrera wrote:
> Steve Crawford wrote:
>> Bruce Momjian wrote:
>>> Tom Lane wrote:
Steve Crawford <[EMAIL PROTECTED]> writes:
> My vote is to add "Appendix I. Abbreviations".
It seems more like FAQ material than
Alvaro Herrera wrote:
> Steve Crawford wrote:
>> Bruce Momjian wrote:
>>> Tom Lane wrote:
Steve Crawford <[EMAIL PROTECTED]> writes:
> My vote is to add "Appendix I. Abbreviations".
It seems more like FAQ material than something for the manual.
>>> I prefer the manual. I would think
On Thu, Oct 18, 2007 at 10:50:02AM -0500,
Scott Marlowe <[EMAIL PROTECTED]> wrote
a message of 18 lines which said:
> Personally, I found it quite easy.
>
> apt-get install postgresqlp8.2
> sudo /etc/init.d/postgres-8.2 start
> sudo su - postgres
> psql
>
> 4 whole steps.
Although I regard
I'm using 7.4 in preparation for an overdue upgrade.
Yesterday I posted 2 questions that were ignored, so I'll try a third
now.
When doing a query I get same error as below, which are the results
of vacuumdb.
vacuumdb: vacuuming of database "airburst" failed: ERROR: could not
access st
On Oct 19, 2007, at 1:20 PM, Steve Crawford wrote:
Bruce Momjian wrote:
Tom Lane wrote:
Steve Crawford <[EMAIL PROTECTED]> writes:
My vote is to add "Appendix I. Abbreviations".
It seems more like FAQ material than something for the manual.
I prefer the manual. I would think the list wou
On Wed, 17 Oct 2007 09:22:11 +0200
Magnus Hagander <[EMAIL PROTECTED]> wrote:
> > Maybe we should put an #ifdef WIN32 into guc.c to limit
> > max_connections to something we know the platform can stand? It'd
> > be more comfortable if we understood exactly where the limit was,
> > but I think I'd
Steve Crawford wrote:
> Bruce Momjian wrote:
> > Tom Lane wrote:
> >> Steve Crawford <[EMAIL PROTECTED]> writes:
> >>> My vote is to add "Appendix I. Abbreviations".
> >> It seems more like FAQ material than something for the manual.
> >
> > I prefer the manual. I would think the list would be pr
Michael Glaesemann wrote:
On Oct 19, 2007, at 13:50 , brian wrote:
Michael Glaesemann wrote:
On Oct 20, 2000, at 13:05 , Martin Gainty wrote:
Martin, it continues to amaze me how you're able to predict and
contribute to the discussion 7 years in advance!
Michael Glaesemann
grzm seespotco
On 10/19/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
>
> On Oct 19, 2007, at 13:50 , brian wrote:
>
> > Michael Glaesemann wrote:
> >> On Oct 20, 2000, at 13:05 , Martin Gainty wrote:
> >> Martin, it continues to amaze me how you're able to predict and
> >> contribute to the discussion 7 year
On Oct 19, 2007, at 13:50 , brian wrote:
Michael Glaesemann wrote:
On Oct 20, 2000, at 13:05 , Martin Gainty wrote:
Martin, it continues to amaze me how you're able to predict and
contribute to the discussion 7 years in advance!
Michael Glaesemann
grzm seespotcode net
But temporal causal
Michael Glaesemann wrote:
On Oct 20, 2000, at 13:05 , Martin Gainty wrote:
Martin, it continues to amaze me how you're able to predict and
contribute to the discussion 7 years in advance!
Michael Glaesemann
grzm seespotcode net
But temporal causality is preserved, as we only get to see h
Kynn Jones wrote:
I have a table used to store information about pairs of items. This
information is independent of the order of the two items in the pair,
so having two records
X Y
Y X
in the table would be redundant. But as far as I can tell, this
situation would n
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/19/07 11:39, Bob Pawley wrote:
> When I fetch a row, as in the following, how do I copy the row's data into a
> temporary table so that I can process it??
>
> begin work;
> Declare loop_set Cursor
>for Select one, two, three,
Bruce Momjian wrote:
> Tom Lane wrote:
>> Steve Crawford <[EMAIL PROTECTED]> writes:
>>> My vote is to add "Appendix I. Abbreviations".
>> It seems more like FAQ material than something for the manual.
>
> I prefer the manual. I would think the list would be pretty long and
> deal with lots of in
On Oct 20, 2000, at 13:05 , Martin Gainty wrote:
Martin, it continues to amaze me how you're able to predict and
contribute to the discussion 7 years in advance!
Michael Glaesemann
grzm seespotcode net
---(end of broadcast)---
TIP 9: In vers
On Fri, 19 Oct 2007 20:04:27 +0200
Michael Meskes <[EMAIL PROTECTED]> wrote:
> On Thu, Oct 18, 2007 at 04:46:00PM -0700, Steve Crawford wrote:
> > ECPG - Embedded SQL in C ??
>
> Correct. And the PG part should be obvious. :-)
Pretty Good?
>
> Michael
--
=== The PostgreSQL Company: C
On Thu, Oct 18, 2007 at 04:46:00PM -0700, Steve Crawford wrote:
> ECPG - Embedded SQL in C ??
Correct. And the PG part should be obvious. :-)
Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: [EMAIL PROTECTED]
Go SF 49ers! Go Rhein Fi
assume the tablename you want to determine privs and access is called
'TABLENAME'
SELECT priv, access_lvl FROM TABLENAME WHERE user = 'pgsql'
M--
- Original Message -
From: [EMAIL PROTECTED]
To: Shane Ambler
Cc: pgsql-general@postgresql.org
Sent: Friday, October 19, 2007 12:
I have a table used to store information about pairs of items. This
information is independent of the order of the two items in the pair,
so having two records
X Y
Y X
in the table would be redundant. But as far as I can tell, this
situation would not violate a uniquen
THANK YOU BOTH ON YOUR REPLIES...THIS IS WHAT I WAS LOOKING FOR...
--
View this message in context:
http://www.nabble.com/Generating-sql-to-capture-fully-qualified-table-namestf4654460.html#a13299646
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
On Fri, 19 Oct 2007 14:28:30 -0300
Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Joshua D. Drake wrote:
> > On Fri, 19 Oct 2007 10:59:20 -0300
> > Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> >
> > > Thomas Pundt wrote:
> > > > Alban Hertroys schrieb:
> > >
> > > >> Isn't this just what the ABBR ta
Joshua D. Drake wrote:
> On Fri, 19 Oct 2007 10:59:20 -0300
> Alvaro Herrera <[EMAIL PROTECTED]> wrote:
>
> > Thomas Pundt wrote:
> > > Alban Hertroys schrieb:
> >
> > >> Isn't this just what the ABBR tag in html is for?
> > >
> > > Well, yes; according w3.org its purpose is to describe the
> > >
smiley2211 escreveu:
Hello all,
I am using the query below to generate SQL code to grant access to objects -
how do I get this statement to PULL the fully qualified name
(schema.tablename)???
*
SELECT 'GRANT SELECT, INSERT, UPDATE, DELETE ON ' || relname ||
' TO newuser
On Fri, 19 Oct 2007 10:59:20 -0300
Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Thomas Pundt wrote:
> > Alban Hertroys schrieb:
>
> >> Isn't this just what the ABBR tag in html is for?
> >
> > Well, yes; according w3.org its purpose is to describe the
> > abbreviation/acronym inline in a document
On Oct 19, 2007, at 11:44 AM, smiley2211 wrote:
Hello all,
I am using the query below to generate SQL code to grant access to
objects -
how do I get this statement to PULL the fully qualified name
(schema.tablename)???
*
SELECT 'GRANT SELECT, INSERT, UPDATE, DELETE ON ' |
Hello all,
I am using the query below to generate SQL code to grant access to objects -
how do I get this statement to PULL the fully qualified name
(schema.tablename)???
*
SELECT 'GRANT SELECT, INSERT, UPDATE, DELETE ON ' || relname ||
' TO newuser;'
FROM pg_c
When I fetch a row, as in the following, how do I copy the row's data into a
temporary table so that I can process it??
begin work;
Declare loop_set Cursor
for Select one, two, three, four, five, six, seven from loop_import
order by loop_id ;
fetch next From loop_set
If I understand correctly, the user "pgsql", besides having its own file
system not related to others, is the administrator of the postgresql db
administrator. Only "pgsql" can modify the db, but the other users can
query the db but not modify it. Am I rigth? What I should do, if other
users ne
[EMAIL PROTECTED] wrote:
Thank you very much Shane. It fixed my problem, at least now :-).
I installed the pgsql 8.2.5 from source. The user "postgres" has a
shortname of "pgsql".
Another question, what's the purpose/advantage to create a user of
postgres? May I just create the database unde
Alvaro Herrera wrote:
> Steve Crawford wrote:
>> Raymond O'Donnell wrote:
>>> On 18/10/2007 22:26, Laurent ROCHE wrote:
>>>
No idea what GUC is, though !
>>> Grand Unified Contraption? ;-)
>>>
>>> Ray (who's just been reading Jules Verne).
>> It's Global User Configuration. But the confusion d
> From: Richard Huxton [mailto:[EMAIL PROTECTED]
> Relyea, Mike wrote:
> > This seems to be a problem with the ODBC driver? How can I narrow
> > that down further?
>
> Well, first make 100% certain the query being executed is the
> one you see being sent from Access.
I did by setting log_stat
Thomas Pundt wrote:
> Alban Hertroys schrieb:
>> Isn't this just what the ABBR tag in html is for?
>
> Well, yes; according w3.org its purpose is to describe the
> abbreviation/acronym inline in a document using a title attribute:
Can you do that from a SGML DocBook source?
--
Alvaro Herrera
Alban Hertroys schrieb:
Steve Crawford wrote:
My vote is to add "Appendix I. Abbreviations". Don't know if it's
practical for 8.3 documentation but it would be nice to add even if it
only has a few entries as additional ones could be collected via the
user notes.
I suggest as a discussion start
Hi,
if anybody needs something like this here is the request to produce the code to
resynch SEQUENCEs with the data in tha tables:
SELECT 'SELECT SETVAL(\'' ||S.relname|| '\', MAX(' ||C.attname|| ') ) FROM '
||T.relname|| ' ;'
FROM pg_class AS S, pg_depend AS D, pg_class AS T, pg_attribute AS
Thanks! I thought that my bug was ignored...
It would be nice to have RETURNING used in PL/SQL functions...
Without named parameters I can live -- they are just syntactic sugar
-- but RETURNING can not be worked around...
Ciprian.
On 10/19/07, Pavel Stehule <[EMAIL PROTECTED]> wrote
Hello
it's feature :(. And it isn't supported in 8.3 too
all info about unsupported features you can find in ToDo list
http://www.postgresql.org/docs/faqs.TODO.html
# Allow SQL-language functions to return results from RETURNING queries
http://archives.postgresql.org/pgsql-hackers/2006-10/msg00
"Tom Lane" <[EMAIL PROTECTED]> writes:
> 3. Throw a NOTICE or WARNING (hopefully only one message not repeated
> ones) if NULL rowid is seen, then ignore the row.
>From my experience with OLTP I don't like this one. A warning for DML is
effectively the same as an error if you're running thousands
Steve Crawford wrote:
> My vote is to add "Appendix I. Abbreviations". Don't know if it's
> practical for 8.3 documentation but it would be nice to add even if it
> only has a few entries as additional ones could be collected via the
> user notes.
>
> I suggest as a discussion starting-point the f
Hello all!
Almost two months ago I have posted a bug on the bug reporting
form that is available on the web page... (I forward here the email I
got in response.) It was related about the RETURNING feature available
for INSERT, UPDATE and DELETE, and the fact that I can not use it as
last s
But when re-doing the query now without the JOIN, it works (almost):
SELECT
*
FROM
crosstab(
'SELECT
id_country AS id,
year_start AS year,
value
FROM
agri_area AS d
WHERE
year_start = 2003 OR year_start = 2
Adrian Klaver wrote:
>> I doing a simple insert into a table re Perl/DBI
>> "INSERT INTO party (party_id, party_type_id, description, status_id)
>> VALUES ($partyId, 'PERSON', 'Initial
Import','PARTY_ENABLED')
>>
>> and I'm getting a
>> "ERROR: relations "party" does n
62 matches
Mail list logo
