On 31.08.2005 05:00, Greg Stark wrote:
> My understanding is that PDO is the way and the light. Use PDO.
Maybe you could provide some arguments on why it should be that?
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
Hmmm. I was thinking of a more comprehensive solution
or document resource. I would like to know what does
what. Why tweak that or why not to ya know?
Searching gets me such fragmented results I chose to
ask the ones whom are more familiar with this fabulous
piece of software and used it in real w
On Tue, Aug 30, 2005 at 09:39:40AM -0400,
Guy Doune <[EMAIL PROTECTED]> wrote
a message of 28 lines which said:
> for getting postgresql accepting my entry with accent an all the
> what the french poeple put over there caracter while they write...
I use PostgreSQL with French data (names, addr
On Tue, Aug 30, 2005 at 06:07:24PM +0200, Michael Fuhr wrote:
> tables, and a VACUUM might start or complete immediately after you
> issue the query but before you read the results). This method is
> therefore unreliable.
I intend to do the VACUUM FULL during quiet hours, thus the chance of
fitti
What version would you recommend to use for a new installation: 8.0.x or
7.4.x
TIA
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
philip johnson wrote:
What version would you recommend to use for a new installation: 8.0.x or
7.4.x
8.0.x - always go for the most recent stable series unless you need to
maintain backwards compatibility.
If you are just entering development, it might be worth looking at 8.1
which has just
8.0.3
On 31.08.2005 10:43, philip johnson wrote:
What version would you recommend to use for a new installation: 8.0.x or
7.4.x
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Hi there,
I've choosen pgsql-general, cause I'm new to postgres community and I'm
looking for a actually (4 days ago?) vanished website from Teodor Sigaev
and Oleg Bartunov (ex: http://www.sai.msu.su/~megera/postgres)
Bside tsearch2 they have worked on LTree (googlecache:
http://64.233.183.1
Hi,
I want to copy several columns of a source table from db1 to db2, and
create the target table and rename the columns in the process.
Is that possible in PostgresQL? If so, an example or url for such a
command /script would be appreciated...
TIA
Joost
---(end of b
Bohdan Linda wrote:
On Tue, Aug 30, 2005 at 06:07:24PM +0200, Michael Fuhr wrote:
tables, and a VACUUM might start or complete immediately after you
issue the query but before you read the results). This method is
therefore unreliable.
I intend to do the VACUUM FULL during quiet hours, thus
Hello List,
I'm trying to delete all the users from a group and it seems as though there isn't sufficient array functionality to do it.
The pg_group columns:
http://www.postgresql.org/docs/8.0/interactive/catalog-pg-group.html
The pg_user columns:
http://www.postgresql.org/docs/8.0/interactive/v
# [EMAIL PROTECTED] / 2005-08-31 12:00:30 +0200:
> I want to copy several columns of a source table from db1 to db2, and
> create the target table and rename the columns in the process.
>
> Is that possible in PostgresQL? If so, an example or url for such a
> command /script would be appreciated.
Peter,
we have problem with mb on our server (it's Supermicro for dual ppro :),
but you use mirror at my desktop machine
http://mira.sai.msu.su/~megera/postgres
Oleg
On Wed, 31 Aug 2005, Peter Arwanitis wrote:
Hi there,
I've choosen pgsql-general, cause I'm new to postgres community a
On Wed, 2005-08-31 at 12:40 +0200, Roman Neuhauser wrote:
> check these man pages: pg_dump(1), pg_restore(1), alter_table(7)
I am afraid that the problem is more complex. The original database (which is
created with SQL_ASCII) contains invalid byte sequences in some columns (target
database
>
> From the postgresql manual
> http://www.postgresql.org/docs/8.0/interactive/maintenance.html :
> " The standard form of VACUUM is best used with the goal of maintaining
> a fairly level steady-state usage of disk space. If you need to return
> disk space to the operating system you can use
On Wednesday 31 August 2005 14:00, Joost Kraaijeveld wrote:
| So I cannot dump/restore/alter table. I was hoping that piping the text
| from stdout to psql that a valid conversion to unicode would take place
| but apparently that is not the case.
|
| Any other ideas?
maybe the "recode" utility can
On Wednesday 31 August 2005 14:09, Thomas Pundt wrote:
| maybe the "recode" utility can help then? Something like
|
| pg_dump -t artik munttest | recode latin1..utf | psql muntfinal
sorry to follow up on myself, but that command should read
pg_dump -t artik munttest | recode latin1..utf8 | ps
Hi
David,
The
correct syntax would probably be :
DELETE
FROM pg_user
WHERE usesysid = ANY
(pg_group.grolist) AND pg_group.groname =
'somegroupname'
However, you won't be allowed to delete users this
way.
The
only recommended methods is to use the DROP USER command to remove
u
Your table size should stabilize to the size you currently get before VACUUM
FULL
If you're afraid about having too many "deleted" rows, you just have to run
VACUUM more often...
I think that you have to test how often you have to run VACUUM so that your
performance is not impacted
Or perh
Jim Nasby asked:
What do people think about the Oracle method where bulk data operations
can only occur in a specified directory? Making that restriction mightaddress some of the security concerns. I don't think we should changeCOPY in such a way that you *have* to use a specified directory, but i
Joost Kraaijeveld schrieb:
On Wed, 2005-08-31 at 12:40 +0200, Roman Neuhauser wrote:
check these man pages: pg_dump(1), pg_restore(1), alter_table(7)
I am afraid that the problem is more complex. The original database (which is
created with SQL_ASCII) contains invalid byte sequences in s
Hi,
let's say one has an user defined data type
CREATE TYPE foobar_t AS ( va varchar(25), vb varchar(4), vc varchar(20), ia
integer, ib integer );
and a stored procedure in plgpsql (stripped and sample only):
CREATE OR REPLACE FUNCTION foobar(int, foobar_t, int, varchar) RETURNS INT AS'
DECLAR
Sim Zacks <[EMAIL PROTECTED]> writes:
> The parenthesis are correct:
> where a.batchid=382 and e.stock>0 and e.ownerid=1 and
> (
> (d.leadfree and leadstateid in (1,3) )
> or
> (not d.leadfree and leadstateid in (2,3,4) )
> )
[ goes back and looks more closely ] The row count estima
Joost Kraaijeveld <[EMAIL PROTECTED]> writes:
> I am afraid that the problem is more complex. The original database
> (which is created with SQL_ASCII) contains invalid byte sequences in
> some columns (target database created with UNICODE):
There is no magic bullet to make bad data better. If th
In article <[EMAIL PROTECTED]>,
Guy Doune <[EMAIL PROTECTED]> writes:
> Hi,
> I would know how to set the encoding (unicode, ASCII,
> etc.) for getting postgresql accepting my entry with
> accent an all the what the french poeple put over
> there caracter while they write...
French is covered bot
On Wed, 2005-08-31 at 14:14 +0200, Thomas Pundt wrote:
> pg_dump -t artik munttest | recode latin1..utf8 | psql muntfinal
Because the source encoding is unknown (the actual source database was
an ODBC source without known encoding that was copied with a C++ written
to a SQL_ASCII PostgreSQL data
On Wed, 2005-08-31 at 10:29 -0400, Tom Lane wrote:
> Joost Kraaijeveld <[EMAIL PROTECTED]> writes:
> If, as seems more likely, there's a mishmash of different encodings then
> you are in for some pain. At the minimum you'll have to separate out
Yep. The original database (which is copied to an SQL
Bohdan Linda wrote:
From the postgresql manual
http://www.postgresql.org/docs/8.0/interactive/maintenance.html :
" The standard form of VACUUM is best used with the goal of maintaining
a fairly level steady-state usage of disk space. If you need to return
disk space to the operating system you
On Wed, 2005-08-31 at 07:18, Bohdan Linda wrote:
> >
> > From the postgresql manual
> > http://www.postgresql.org/docs/8.0/interactive/maintenance.html :
> > " The standard form of VACUUM is best used with the goal of maintaining
> > a fairly level steady-state usage of disk space. If you need t
Why do i have to be the one doing such a silly mistake ...
thanks for your help and yes you were right ...
this fixed my problem ...
thanks,
vishOn 8/30/05, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Tue, Aug 30, 2005 at 10:40:26AM -0700, vishal saberwal wrote:> Root user:> /root/.postgressql:Is th
Hello,
I would like to try postgresql and was wondering what benefits it
has over MySql.
I am using navicat to manage my MySQL databases.
Thanks for the help.
Frank
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Wed, Aug 31, 2005 at 11:50:55AM -0400, Frank wrote:
> I would like to try postgresql and was wondering what benefits it
> has over MySql.
Search the list archives to see past discussion, or use a search
engine like Google with words like "postgresql mysql comparison."
A couple of links you mi
Hi,
Problem Description:
We need to insert binary data to tables and retrieve the
Same-(data type is bytea).
We are using PQExecParams for inserting and retrieving
Data.
Table contains other than binary data also.
When we tried to fetch the integer data (type-int2)
We are not able to get anyt
Frank wrote:
Hello,
I would like to try postgresql and was wondering what benefits it has
over MySql.
I am using navicat to manage my MySQL databases.
Hi Frank. You don't say what you want to use your RDBMS for, so it's a
bit difficult to point out what about PostgreSQL would be best for
Hello Frank,
I believe that PostgreSQL is a proper RDBMS adhering to the ACID
principles, as well as has similar functions to Oracle, in terms of having
procedural language support with pg/plsql and the ability to also use
other languages such as perl, java (pl/perl and pl/java) to do the sam
"Mavinakuli, Prasanna (STSD)" <[EMAIL PROTECTED]> writes:
> Here is the code snapshot:
> string query="select intval from dummy where intval=7;";
> res1=PQexecParams(conn,query.c_str(),0,NULL,NULL,NULL,NULL,1);
> for(unsigned char i=0;i<4;i++)
> {
> printf(
Hi,
I´m trying to post messages in the performance list but they don´t appear in the list.
Whan can be wrong?
Reimer__Converse com seus amigos em tempo real com o Yahoo! Messenger http://br.download.yahoo.com/messenger/
On Tue, 2005-30-08 at 21:00 -0700, Chris Travers wrote:
> Antimon wrote:
>
> >Hi,
> >I'm working on a new web project based on php and i decided to use
> >PostgreSQL 8.x as
> >dbms. For triggers, views, stored procedures etc. I was going to write
> >a simple wrapper class and use pg_* functions. B
I wrote a wrapper class based on pg_ functions. Added some logging and
exception throwing capabilities etc.
I'm planning to use only prepared statements and pg_query_params
function when using user submitted data in queries to avoid
sql-injection. I believe it is enough but gonna do some tests.
Thi
On Wed, Aug 31, 2005 at 00:50:20 -0700,
Matthew Peter <[EMAIL PROTECTED]> wrote:
>
> Is 8.1 to early to use in a production environment?
> With just the regular old 8.0.3 stuff?
8.1 is still in early beta and you definitely don't want to use it in
production. It has some nice improvements, so
On Wed, Aug 31, 2005 at 12:30:14 +0200,
David Sankel <[EMAIL PROTECTED]> wrote:
>
> DELETE FROM pg_user
> WHERE usesysid = ANY ( SELECT grolist
> FROM pg_group
> WHERE groname = 'somegroupname' )
>
> But, alas, it doesn't. Neither does any combination of IN and ANY. It seems
> to me like this
Thanks for the feedback, sorry I was not more specific.
We are a non-profit hospital and have been using MySQL for about 4 years.
I wanted to convert some apps over to use postgresql and cannot find
a good tool to import and auto create the tables.
MySQL syntax is not compatible with postgresql
Hi,
one of our programs went haywire and created around 200,000 temp
tables. In the end, I restarted the db, but the temporary tables are
still around
the query
SELECT n.nspname, c.relname, c.relkind, c.relpages, c.reltuples FROM
pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHE
On Wed, 2005-08-31 at 13:50, Frank wrote:
> Thanks for the feedback, sorry I was not more specific.
> We are a non-profit hospital and have been using MySQL for about 4 years.
>
> I wanted to convert some apps over to use postgresql and cannot find
> a good tool to import and auto create the tabl
Thanks for clearing up some confusion.
>>Look in the contrib/mysql directory in the source file (or install the
contrib packages for your system, assuming they come with that contrib
package<<
I do not have that, where can I download it?
This fails to insert records
> insert into category va
MySQL has a nasty habit of ignoring standards; in every other database
I've used, if you want to quote an identifier (such as a field name),
you use ", not `.
The fields are also incompatable. int() is non-standard, for starters.
There are MySQL to PostgreSQL conversion tools out there that shoul
Hari Bhaskaran <[EMAIL PROTECTED]> writes:
> one of our programs went haywire and created around 200,000 temp
> tables. In the end, I restarted the db, but the temporary tables are
> still around
What did you do, the old "kill -9 some random process" approach to
database management? The recommend
On Wed, Aug 31, 2005 at 03:17:29PM -0400, Frank wrote:
> Thanks for clearing up some confusion.
>
> >>Look in the contrib/mysql directory in the source file (or install the
> contrib packages for your system, assuming they come with that contrib
> package<<
>
> I do not have that, where can I dow
> What did you do, the old "kill -9 some random process" approach to
> database management? The recommended ways of cancelling a session
> wouldn't have caused this.
I never said I kill -9 . I do pg_ctl stop
BTW, drop cascade on the namespace seems to be working.
create temp queries failed with
Frank <[EMAIL PROTECTED]> writes:
>> Look in the contrib/mysql directory in the source file (or install the
>> contrib packages for your system, assuming they come with that contrib
>> package<<
> I do not have that, where can I download it?
The best place to get it would be
http://gborg.postgres
On Wed, Aug 31, 2005 at 03:17:29PM -0400, Frank wrote:
> This fails to insert records
>
> >> insert into category values
> >> (4, 'Hardware - Monitor', 2, '2004-10-12 10:50:01'),
> >> (5, 'Hardware - Printer', 2, '2004-10-12 10:50:02'),
> >> (6, 'Hardware - Terminal', 2, '2004-10-12 10:50:02'),
On 8/31/05, Frank <[EMAIL PROTECTED]> wrote:
> I wanted to convert some apps over to use postgresql and cannot find
> a good tool to import and auto create the tables.
> MySQL syntax is not compatible with postgresql.
> I get:
> ERROR: syntax error at or near "`" at character 14
> from the MySQL o
On Wed, 2005-08-31 at 14:17, Frank wrote:
> Thanks for clearing up some confusion.
>
> >>Look in the contrib/mysql directory in the source file (or install the
> contrib packages for your system, assuming they come with that contrib
> package<<
It comes with the postgresql tar ball. just downlo
If the inserts are all a bunch of data statements like that, a SED
script could turn them into something for bulk load via COPY easily
enough.
Might be an even better solution, depending on what the OP is trying to
accomplish.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-g
""John Surnow"" <[EMAIL PROTECTED]> wrote
> Does this mean that read access is not concurrent, or write access, or
> both?
For old GiST, you can have several connections read-*only* at the same time,
but write/write or read/write is unsafe. GiST in 8.1 is concurrent safe
already.
Regards,
Qing
Perhaps another possible feature request! I've looked
through the docs and it doesn't appear that it's
possible to create deferred triggers - i.e. they don't
get called unless the current transaction commits. (My
understanding is that they currently get called
immediately whether or not there is a
The Open Source Database Conference 2005 finally has a web site:
http://www.opendbcon.net/
Although it's not yet visible, there's quite a lineup of PostgreSQL
talks, and I imagine that even some of the other talks will be of
interest to people here. This could become the main event for
exchan
Hi,
I'm currently using PostgreSQL 8.0.3 and would like to have a load-
balancing and failover solution over LAN.
>From reading the mailing list, it seems that pgpool and slony1
combination has been recommended for LAN replication. But seems that
pgcluster is still actively maintained? Which on
I am using autovacuum, and I assumed it was working correctly. Is there a way
to tell if it is not doing what it is supposed to?
This is the result of ps for the autovacuum PID.
The docs say that it should automatically analyze.
PID TTY STAT TIME COMMAND
10184 ?Ss 0:32 /usr/bi
I am trying to start postgresql via webmin, but not having success. I
get a message in the syslog "su:(to postgres) root on none"
This is suse 9.3. Could someone tell what that message means?
I was working until I added the -i to the postmaster.opts file so I
could access it via pgadmin.
Art
60 matches
Mail list logo
