On 10/25/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> hello group
> i want to create a shell script in that i want to create postgresql
> user and database.both this task are created properly and executed
> properly but after user and DB creation i am there on ( -bash-3.00$ )
> and i wann
Great, super thanks!
Sebastjan
On 10/29/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> I wrote:
> > "Sebastjan Trepca" <[EMAIL PROTECTED]> writes:
> >> This is how to reproduce this issue:
> >> ...
> >> inh_test=# alter table capitals inherit cities;
>
> > Fascinating. pg_dump is almost smart enough
Johnson Jesse wrote:
I am trying to install postgreSQL v8.2.5 as a prerequisite for Firefox
Bugzilla application on one of our network servers (Microsoft Server
2000).
The logfile reads:
fixing permissions on existing directory C:/Program
Files/PostgreSQL/8.2/data ... ok
creating subdirect
Eva Elizalde wrote:
> quiero saber que version de sql maneja postgres
I am afraid that there is no reasonable way to version
PostgreSQL's SQL dialect other than the PostgreSQL
version (currently at 8.2.5).
There is the SQL standard, which is versioned in
with the year of the publication, but alth
> i want to create a shell script in that i want to create postgresql
> user and database.both this task are created properly and executed
> properly but after user and DB creation i am there on ( -bash-3.00$ )
> and i wanna come back to [EMAIL PROTECTED]:localdomain ~]# and my
> script is
> #
Martin Peckham wrote:
> I recently installed the latest non-beta version 8.2 of postgresql.
>
> I get the following warning and hint in the server status GUI:
>
> WARNING:nonstandard use of \\ in a string literal at characters 64
> HINT: Use the excape string syntax for backslashes, e.g
http://archives.postgresql.org/pgsql-general/
--
Troy Rasiah
---(end of broadcast)---
TIP 6: explain analyze is your friend
--- On Mon, 10/29/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> (Raid1 = No Fault tolerance since 3 drives)
Raid1 with three drives will have fault tolerance. You will have three disks
with the same image. This is triple redundancy. This could greatly improve
select performance.
Having said th
Brian Wipf <[EMAIL PROTECTED]> writes:
> The process I use that leads to the warnings is simple:
> I use pg_controldata to determine the current checkpoint WAL location
> of the standby server. I ensure I have this WAL file and all newer
> WALs. I backup all files under the standby's database
"Dot Yet" <[EMAIL PROTECTED]> writes:
> I am seeing this "Connection reset by peer" message in the
> postmaster.logfile, but the connection between the client and server
> does get established
> and works fine too...
What pg_hba.conf setup are you using? I'm thinking that this might be
expected b
James Gates <[EMAIL PROTECTED]> writes:
> I'm working with a issue where it seems the PostgreSQL server collation
> sequence for certain locales don't match the operating system's
> collation sequence for the same locale (set during initdb).
> I can reproduce this on both 8.1.9 & 8.2.5 on Solaris
On 10/29/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> On Tue, 30 Oct 2007 09:42:37 +0800
> Ow Mun Heng <[EMAIL PROTECTED]> wrote:
>
> > It's not an optimal setup but since I only have 3x500G drives to play
> > with, I can't build a Raid10, so I'm going for Raid5 to test out
> > capability befor
On 10/25/07, Joanne Salerno <[EMAIL PROTECTED]> wrote:
> I recently went from Postgres 7.4 to 8.24 (Linux Platform).
>
> In 7.4 I relied on forms created locally within the utility Pgaccess to
> perform various database changes. Upon conversion to 8.24 I have not
> been able to get Pgaccess to rea
On 10/25/07, Evandro Andersen <[EMAIL PROTECTED]> wrote:
> In Oracle you can use this:
>
> DELETE FROM A WHERE A1 = 10 ORDER BY A2
>
> There is something in the Postgresql ?
That doesn't work in Oracle 9i, I tried it.
No, there's nothing exactly like it in pgsql.
---(end
--- On Thu, 10/25/07, Andy <[EMAIL PROTECTED]> wrote:
> >> Is there any way of converting text from an
> AutoCad (.dwg ot .dxf) file into
> >> a PostgreSQL Database??
> Do you want AutoCad to edit the drawings right out of the
> database? How
> would you want to put them in/get them out, of the
Hello Everyone,
I have configured SSL for my postgreSQL setup. The environment is
PostgreSQL 8.2.5 (64-bit) built using Sun tools with ssl flag
OpenSSL 0.9.8d 28 Sep 2006
OpenSolaris 5.11 snv_73
I have configured the server key and certificate file using openssl. The
connection between a remote
some other question I dont like to make a new topic so I will add it
here.
I ve modified my function to
CREATE OR REPLACE FUNCTION bookid(_tabela varchar) RETURNS integer AS $
$
DECLARE
_id integer := 0;
BEGIN
--insert bez id wyzwala nextwal na tabela_columna_seq
EXECUTE 'inser
> SELECT INTO _id id FROM _tabela order by id desc limit 1;
ok I ve found that
EXECUTE 'SELECT id FROM ' || quote_ident(_tabela) ||' order by id desc
limit 1' INTO _id;
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please
On 25 Okt, 17:36, [EMAIL PROTECTED] wrote:
>
> The design is based on access patterns, i.e. one partition represents a
> group of data along a discrete axis, so the partitions are the perfect for
> modeling that. Only the last partition will be used on normal cases. The
> previous partitions only n
ok so my probelm is I have a simple function like this
CREATE OR REPLACE FUNCTION bookid(_tabela varchar) RETURNS integer AS $
$
DECLARE
_id integer := 0;
BEGIN
SELECT INTO _id id FROM _tabela order by id desc limit 1;
RETURN _id+1;
END;
$$ LANGUAGE plpgsql;
and the problem is i can r
Hi,
Can anyone tell me how rewrite rules are applied in
pg_analyze_and_rewrite?
regs,
bharat.
In article <[EMAIL PROTECTED]>, cluster <[EMAIL PROTECTED]> wrote:
% > How important is true randomness?
%
% The goal is an even distribution but currently I have not seen any way
% to produce any kind of random sampling efficiently. Notice the word
How about generating the ctid randomly? You
[EMAIL PROTECTED] wrote:
When I try to add or update a postgresql field from php, even though I
escape it, when I
try to include a single quote in a varchar field, the result is the
quote and everything following
is missing after being INSERTed or UPDATEd. Anybody have any ideas
what is going on
Hi..
I want to do index in postgresql & python.
My table:
id(int) | id2(int) | w(int) | d(int)
My query:
select id, w where id=x and id2=y (sometimes and d=z)
I have too many insert and select operation on this table.
And which index type can i use ? Btree, Rtree, Gist or Hash ?
Also I want to un
Hi,
I have some problems supporting "translatable columns" in a way that
is both efficient and comfortable for the programmer who has to write
SQL-Queries (we use iBatis)
Suppose I have a simple table that contains an id field and (amongst
others) a name field. Let's call this table foo. The name
Hai all again.
Maybe I've solved the problem, but would like to have some hint on "why".
In the second query I've substituted the last join (natural join tt_rice)
with an additional "where condition". I can do this as I am sure that
the tt_rice table will always contain just one row with one fiel
I recently installed the latest non-beta version 8.2 of postgresql.
I get the following warning and hint in the server status GUI:
WARNING:nonstandard use of \\ in a string literal at characters 64
HINT: Use the excape string syntax for backslashes, e.g, E'\\'.
The "raw" stri
In Oracle you can use this:
DELETE FROM A WHERE A1 = 10 ORDER BY A2
There is something in the Postgresql ?
Evandro Andersen
Brazil
Postgresql 8.2
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Em Tuesday 23 October 2007 07:17:53 Goboxe escreveu:
> Hi,
>
> What is the equivalent MSSQL 'print' command in pg sproc?
What does the MSSQL 'print' command "prints"?
--
Jorge Godoy <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 5: don't f
Chris Travers wrote:
Hi all;
I know -hackers is the preferred place to discuss beta releases, but I
suspect that this is a further-reaching wuestion among the general
community than is typical so I am posting it here.
I have been looking at the changes expected for 8.3 and have noticed
that
I'm investigating a problem reported by a customer where it seems the
PostgreSQL server collation sequence for certain locales don't match the
operating system's collation sequence (for the same locale set during
initdb).
I can reproduce this on both 8.1.9 & 8.2.5. I'm using Solaris Nevada,
b
Em Tuesday 23 October 2007 09:03:23 yogesh escreveu:
> Hello Frnds,
>
> I have installed postgres on Suse Linux using the YAST-->Software.
> I have to check and Manipulate the tables and check the data..is
> there are any client application to work on the Suse
> Linux.
Sure!
A
Garry Saddington wrote:
I am using zope on windows with an external python method to backup my
database. I am struggling to run the following command:
pg_dump.exe database > file
I have tried using os.popen - no luck
and also subprocess.Popen.
eg:
import subprocess
subprocess.Popen([
I am trying to install postgreSQL v8.2.5 as a prerequisite for Firefox
Bugzilla application on one of our network servers (Microsoft Server
2000). It goes through the install and everything runs ok to a point
where it is "Initializing Database Cluster (this may take a minute or
two) and it pops up
hello group
i want to create a shell script in that i want to create postgresql
user and database.both this task are created properly and executed
properly but after user and DB creation i am there on ( -bash-3.00$ )
and i wanna come back to [EMAIL PROTECTED]:localdomain ~]# and my
script is
#
Hi,
What is the equivalent MSSQL 'print' command in pg sproc?
Thanks,
G
---(end of broadcast)---
TIP 6: explain analyze is your friend
When I try to add or update a postgresql field from php, even though I
escape it, when I
try to include a single quote in a varchar field, the result is the
quote and everything following
is missing after being INSERTed or UPDATEd. Anybody have any ideas
what is going on?
Thanks in advance!
Dave
I've installed postgres v. 8.2.4 on ubuntu with 2.6.18.1 kernel with plperl
support (--with-perl option with configure).But when I try to create plperl
languge (createlang plperl) i've got an error
createlang: language installation failed: ERROR: could not load library
"/usr/ocal/pgsql/lib/plperl
Hello Frnds,
I have installed postgres on Suse Linux using the YAST-->Software.
I have to check and Manipulate the tables and check the data..is
there are any client application to work on the Suse
Linux.
Regards,
Yogesh Arora.
---(end of broadcast)
On Wednesday 24 October 2007 21:10, Chris Travers wrote:
> Hi all;
>
> I know -hackers is the preferred place to discuss beta releases, but I
> suspect that this is a further-reaching wuestion among the general
> community than is typical so I am posting it here.
>
> I have been looking at the chan
Postgres starts separate process for each connection and you can just `kill`
(not `kill -9`) the unwanted process. Or you can do `select
pg_cancel_backend(pid)` from another session.
I recently went from Postgres 7.4 to 8.24 (Linux Platform).
In 7.4 I relied on forms created locally within the utility Pgaccess to
perform various database changes. Upon conversion to 8.24 I have not
been able to get Pgaccess to read Postgres pga_forms table contents.
Pgaccess recognizes th
Hi All,
I need to make certain changes to cube.c file which comes with cube contrib
( http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/cube/). I am not
sure how to compile it so that I can use those changes in postgresql. Could
you help me?
Thanks
Gowrishankar L
On 10/19/07, Gowrishanka
hola
quiero saber que version de sql maneja postgres
gracias
mi correo es
[EMAIL PROTECTED]
Josh Tolley wrote:
On 10/24/07, Bob Pawley <[EMAIL PROTECTED]> wrote:
Is there any way of converting text from an AutoCad (.dwg ot .dxf) file into
a PostgreSQL Database??
Bob Pawley
I know nothing of AutoCad, but your message has been sitting for a
while without response, so I'll throw out t
Hi,
I partitioned a table "events" into 31 tables, based on "day" of event_time.
I did 3 steps to setup partition, after creating partition tables:
1. Add the constraint to the 31 partition tables like:
ALTER TABLE events_day_1
ADD CONSTRAINT events_day_1_event_time_check CHECK (date_part('da
> >
> > Why cant postgres get the RowExclusiveLock in transaction 3369000?
>
> Probably because the ExclusiveLock'ers are waiting in front
> of RowExclusiveLock. Locks are granted in order.
>
> It would help if you didn't mangle the pg_locks output so badly.
Yes, sorry about that.
I was abl
Ron Johnson wrote:
Hmmm. Is Paradox that bad?
Yes. I'm also a Delphi developer, who has already converted a paradox
program (was just before pg on windows.. bummer)
Paradox is a file share'd database (like dbase), and when the program
crashes, it'll hose up your pdox tables too. Esp
If you know the index name then:
SELECT pg_get_indexdef('your_index_name'::regclass)
will do.
In case you want a full list of indices for a certain table:
SELECT c2.relname, pg_get_indexdef(i.indexrelid, 0, true), c2.reltablespace
FROM pg_catalog.pg_class c, pg_catalog.pg_class c2, pg_catalog.pg
> > Anyways, i am trying to avoid locks now, by using my own merge
> > function to avoid update/insert race condition.
> >
> > Or what is the suggested way to avoid the update/insert
> race condition?.
>
> What update/insert race condition? Maybe you are talking
> about the subject of example
On Wednesday 24 October 2007 15:11, Roberts, Jon wrote:
> Yeah. I think having to save the function to disk and then leave pgAdmin
> to execute subversion commands is going through hoops.
>
> Also, pgAdmin should be integrated so that you are notified if the function
> in the database is different
On Tue, 30 Oct 2007 09:42:37 +0800
Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> It's not an optimal setup but since I only have 3x500G drives to play
> with, I can't build a Raid10, so I'm going for Raid5 to test out
> capability before I decide on Raid5 vs Raid1 tradeoff. (Raid1 = No
> Fault toleranc
It's not an optimal setup but since I only have 3x500G drives to play
with, I can't build a Raid10, so I'm going for Raid5 to test out
capability before I decide on Raid5 vs Raid1 tradeoff. (Raid1 = No Fault
tolerance since 3 drives)
Anyway.. I'm trying to figure out the chunk size for the raid. I
On Oct 29, 2007, at 18:59 , Frank Church wrote:
Is there a built in function for retrieving the next value of a
sequence and updating the sequence counter?
http://www.postgresql.org/docs/faqs.FAQ.html#item4.11.2
http://www.postgresql.org/docs/8.2/interactive/functions-sequence.html
Michael G
On Mon, 29 Oct 2007 23:59:59 +
"Frank Church" <[EMAIL PROTECTED]> wrote:
> Is there a built in function for retrieving the next value of a
> sequence and updating the sequence counter?
>
The docs are amazing:
http://www.postgresql.org/docs/current/static/functions-sequence.html
Sincerely,
Is there a built in function for retrieving the next value of a
sequence and updating the sequence counter?
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
I'm working with a issue where it seems the PostgreSQL server collation
sequence for certain locales don't match the operating system's
collation sequence for the same locale (set during initdb).
I can reproduce this on both 8.1.9 & 8.2.5 on Solaris (both Nevada & 10).
1) First I have a text
Samantha Atkins shaped electrons to ask:
>
> What do you consider the most logical, one database per user?
>
> - samantha
Perhaps a schema per user ? Then you can have the common tables (look up
values, whatever) in the public schema. Each user gets a schema that has all of
the tables they sha
Samantha Atkins wrote:
On Oct 29, 2007, at 10:14 AM, Richard Huxton wrote:
Samantha Atkins wrote:
First on prepared statements:
1) If I am using the libpq are prepared statements tied to a
connection? In other words can I prepare the statement once and use
it on multiple connections?
Pe
On Oct 29, 2007, at 10:14 AM, Richard Huxton wrote:
Samantha Atkins wrote:
First on prepared statements:
1) If I am using the libpq are prepared statements tied to a
connection? In other words can I prepare the statement once and
use it on multiple connections?
Per session (connection).
After bringing up a PG 8.2.5 database restored from a base backup
taken from a warm standby, the following warnings are logged:
...
[2007-10-26 19:21:22 MDT] LOG: archived transaction log file
"0001017C00E2"
WARNING: relation "category_click_history" page 250226 is
uninitialize
On Mon, 29 Oct 2007 22:33:28 +
Richard Huxton <[EMAIL PROTECTED]> wrote:
> Josh Trutwin wrote:
> > On Postgresql 8.1 I am guessing there isn't a convenient way to
> > alter a trigger to change its before/after behavior? I wrote one
> > of my first triggers using an AFTER and now I release I n
Tom Lane wrote:
Joseph S <[EMAIL PROTECTED]> writes:
On one of my servers postgres thinks that we're back on standard time
already:
What's its TimeZone setting?
On the server that is working:
=> show TimeZone;
TimeZone
US/Eastern
(1 row)
On the one that is broken:
show Tim
Josh Trutwin wrote:
On Postgresql 8.1 I am guessing there isn't a convenient way to alter
a trigger to change its before/after behavior? I wrote one of my
first triggers using an AFTER and now I release I needed to
do BEFORE. It's used on a couple tables so I was hoping to avoid
dropping it and
On Postgresql 8.1 I am guessing there isn't a convenient way to alter
a trigger to change its before/after behavior? I wrote one of my
first triggers using an AFTER and now I release I needed to
do BEFORE. It's used on a couple tables so I was hoping to avoid
dropping it and re-creating it but if
Joseph S <[EMAIL PROTECTED]> writes:
> On one of my servers postgres thinks that we're back on standard time
> already:
What's its TimeZone setting? What is the mod date of the corresponding
file in the $SHAREDIR/timezone/ directory (where $SHAREDIR means
whatever pg_config --sharedir says)?
It
"bharat u" <[EMAIL PROTECTED]> writes:
> Can anyone tell me how pg_analyze_and_rewrite works?
That's a rather broad question. Have you read the overview in the manual?
http://developer.postgresql.org/pgdocs/postgres/overview.html
pg_analyze_and_rewrite covers what that material calls the
On one of my servers postgres thinks that we're back on standard time
already:
[local]:db=# select current_timestamp;
now
---
2007-10-29 15:06:10.049795-05
(1 row)
Time: 0.807 ms
[local]:db=# select version();
I wrote:
> "Sebastjan Trepca" <[EMAIL PROTECTED]> writes:
>> This is how to reproduce this issue:
>> ...
>> inh_test=# alter table capitals inherit cities;
> Fascinating. pg_dump is almost smart enough to get this right, ...
I've fixed this --- if you need a patch right away, see here:
http://ar
Hi,
Can anyone tell me how pg_analyze_and_rewrite
works?
-bharat.
Tom Lane wrote on 29.10.2007 00:55:
Thomas Kellerer <[EMAIL PROTECTED]> writes:
Why is it, that pg_dump can use a compressed output directly but pg_dumpall is
always using a SQL (i.e. "plain text") output?
The custom and tar formats are not designed to support data from more
than one database.
On Mon, 2007-10-29 at 14:20 -0400, Tom Lane wrote:
> Jeff Davis <[EMAIL PROTECTED]> writes:
> > One minor thing: I think it's still dependent on locale though, because
> > the output of pg_controldata is locale-dependent, right? It would work
> > fine for me, but it would be nice if there was somet
Jeff Davis <[EMAIL PROTECTED]> writes:
> One minor thing: I think it's still dependent on locale though, because
> the output of pg_controldata is locale-dependent, right? It would work
> fine for me, but it would be nice if there was something that could be
> released that anyone could use, includ
>>> On Mon, Oct 29, 2007 at 11:50 AM, in message
<[EMAIL PROTECTED]>, Jeff Davis <[EMAIL PROTECTED]>
wrote:
> Also, did you publish your pg_clearxlogtail program anywhere? I think
> that would be helpful to many people, but I don't see it on pgfoundry.
So far I've just included with the email o
Samantha Atkins wrote:
First on prepared statements:
1) If I am using the libpq are prepared statements tied to a
connection? In other words can I prepare the statement once and use it
on multiple connections?
Per session (connection).
Temporary tables etc. are the same.
2) What is the lo
On Mon, Oct 29, 2007 at 09:52:55AM -0700, Samantha Atkins wrote:
> First on prepared statements:
>
> 1) If I am using the libpq are prepared statements tied to a
> connection? In other words can I prepare the statement once and use
> it on multiple connections?
Yes they are, and no, you can't.
On Mon, 29 Oct 2007 09:52:55 -0700
Samantha Atkins <[EMAIL PROTECTED]> wrote:
> First on prepared statements:
>
> 1) If I am using the libpq are prepared statements tied to a
> connection?
Yes.
> In other words can I prepare the statement once and use
> it on multiple connections?
No.
>
Bob Pawley <[EMAIL PROTECTED]> writes:
> Following the examples in the docs I've come to this.
>
> I am attempting to restore the existing sql dump using
> psql -d PDW -f aurel.sql
>
> I am then asked for a password.
>
> I try every password that the computer knows with no success.
>
> Funny thing
First on prepared statements:
1) If I am using the libpq are prepared statements tied to a
connection? In other words can I prepare the statement once and use
it on multiple connections?
2) What is the logical scope of prepared statement names? Can I use
the same name on different table
On Mon, Oct 29, 2007 at 03:44:05PM +0100, Pit M. wrote:
> I have the following problem with PostgreSQL and hope you guys can
> help me out in this matter: I try to get a remote connection to any
> database (e.g. MS-SQL or MS Access) using DBI-Link and DBD:ODBC. My
> problem is, that everything seem
Following the examples in the docs I've come to this.
I am attempting to restore the existing sql dump using
psql -d PDW -f aurel.sql
I am then asked for a password.
I try every password that the computer knows with no success.
Funny thing the password cursor doesn't move when inputting the pa
On Mon, 2007-10-29 at 09:56 -0500, Kevin Grittner wrote:
> Here's our script:
Thanks, I think that is better than what I'm doing.
One minor thing: I think it's still dependent on locale though, because
the output of pg_controldata is locale-dependent, right? It would work
fine for me, but it woul
>>> On Fri, Oct 26, 2007 at 6:28 PM, in message
<[EMAIL PROTECTED]>, Jeff Davis <[EMAIL PROTECTED]>
wrote:
> [ of course, there's no guarantee that the archive_command succeeds in
> that time ]
Which is one of the things we would want to cause an alert.
-Kevin
-
>>> On Fri, Oct 26, 2007 at 6:39 PM, in message
<[EMAIL PROTECTED]>, Jeff Davis <[EMAIL PROTECTED]>
wrote:
> On Fri, 2007-10-26 at 18:06 -0500, Kevin Grittner wrote:
>> Hmmm... We would actually prefer to get the WAL file at the
>> specified interval. We have software to ensure that the warm
>>
I have the following problem with PostgreSQL and hope you guys can help
me out in this matter: I try to get a remote connection to any database
(e.g. MS-SQL or MS Access) using DBI-Link and DBD:ODBC. My problem is,
that everything seems fine so far, however I don't know how to use the
parameter
Tom Lane wrote:
> I wouldn't recommend trying to use a standard FTS to index code:
> code is not a natural language and the kinds of searches you usually
> want to perform are a lot different. As an example, I glimpse for
> "foo" when looking for references to a function foo, but "^foo"
> when se
Harpreet Dhaliwal wrote:
> lately I have been looking at difference between a Stored
> Proc and User Defined Functions in other RDBMS like Sql
> Server / Oracle.
Nomenclature varies wildly between different Database
Management Systems. Be careful.
The SQL standard (2005) speaks of "SQL-invoked
Hi,
In our thick client application, I want to update the schema on the
user's machine automatically as normal software update process using
JNLP etc
We will be using Eclipser RCP. Is it possible?
Regards
Ashwani
This message contains information that may be privileged or confidential and
89 matches
Mail list logo
