In a real application that uses a client/server type database you should
NEVER construct queries that return a million rows.
You have to keep in mind that each record has to be sent accross the
wire via TCP/IP and it is going to take a lot of time to bring back 1
million rows and I am sure your
I know two ways:
1) Use DbVisualizer, very handy, but a bit slow. For a give table go to
the indexes tab and it's show you the cardinality
2) Use this sql
SELECT relname, relkind, reltuples as cardinality, relpages
FROM pg_class
WHERE relname LIKE 'mytablename%';
David
- Original message
[EMAIL PROTECTED] (Andreas Seltenreich) wrote in message news:<[EMAIL
PROTECTED]>...
> Fritz Bayer schrob:
>
> > The problem is that alls the "ü" characters get displayed as "".
> >
> > Why is that so?
>
> This could happen when your locale isn't properly set up. If, for
> example, LC_CTYPE is s
I just got done comparing SPECMarks (on spec.org) between Sun's AMD entry
level servers versus similarly configured UltraSPARCs versus desktop AMD
based machines. Sun's AMD machines are twice as fast as their UItraSPARCs,
for approximately the same price. What a hoot.
Rick
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> I wasn't able to find where this is spelled out in the documentation,
> but I believe all DDL commands except DROP DATABASE can be rolled back now.
I don't think there's any all-in-one-place statement about it, but
anything that doesn't explicitly obje
The only linux app I can find that does the job is SugarCRM.
However, they use mysql as their backend. Might it be relatively
easy for me to change the code so it will work with
postgres? What's involved?
Rich, what's wrong with the app as it is? Why change anything?
---(en
On Fri, 2005-04-22 at 09:48, [EMAIL PROTECTED] wrote:
> I just got done comparing SPECMarks (on spec.org) between Sun's AMD entry
> level servers versus similarly configured UltraSPARCs versus desktop AMD
> based machines. Sun's AMD machines are twice as fast as their UItraSPARCs,
> for approximat
JM <[EMAIL PROTECTED]> writes:
> i need help on this.. i'm experiencing this problem too often and i
> need a
> permanent solution.
> WARNING: ShmemAlloc: out of memory
> ERROR: FreeSpaceMap hashtable out of memory
You probably need to increase max_locks_per_transaction some more.
It wo
It was something of a struggle to get Access to talk to PostgresSQL using
ODBC.
It was even more of a struggle, since I know nothing about Access or VBA,
to create a "Form" in Access, and a Button on the Form, to execute the VBA code,
below.
If it were not for the Internet, and Google, I
On 4/22/2005 2:08 PM, Tom Lane wrote:
Sven Willenberger <[EMAIL PROTECTED]> writes:
We have a replication set up between 2 servers using Slony; both are
runnind PostgreSQL 8.0.1. The issue is that when updates/inserts are
made to a replicated table, the replication does not occur; apparently
this i
On Fri, 22 Apr 2005, Scott Marlowe wrote:
I like Python, but it's felt half-finished for quite some time now. So, I
use PHP and / or Java (just learning it really) for most stuff.
PHP, for all it's warts and blemishes, has been a stable language (not
the definition, the VM / implementation) with us
Guess now's the time. I'm trying to find a copy of pygresql to use, but
it's not easy (www.pygresql.org leads to druid.net and there's nothing
on the
page about pygresql). I'm learning python to use on a major project here
Use pyscopg instead of pygresql.
Sincerely,
Joshua D. Drake
--
Your Po
On Fri, 22 Apr 2005, Scott Marlowe wrote:
Unfortunately, there is no use of an abstraction layer in SugarCRM, and the
few comments I found in their forum about alternate databases indicated a
current focus on feature enhancements and sales / services, not supporting
alternate databases.
Scott,
Th
[EMAIL PROTECTED] wrote:
I just got done comparing SPECMarks (on spec.org) between Sun's AMD entry
level servers versus similarly configured UltraSPARCs versus desktop AMD
based machines. Sun's AMD machines are twice as fast as their UItraSPARCs,
for approximately the same price. What a hoot.
Not
Rich Shepard wrote:
I need (and want) contact managment software for marketing/sales tracking
in my business. The only linux app I can find that does the job is
SugarCRM.
However, they use mysql as their backend.
Might it be relatively easy for me to change the code so it will work
with
post
On Fri, 2005-04-22 at 11:51, Joshua D. Drake wrote:
> Rich Shepard wrote:
> > I need (and want) contact managment software for marketing/sales tracking
> > in my business. The only linux app I can find that does the job is
> > SugarCRM.
> > However, they use mysql as their backend.
> >
> > Mi
I need (and want) contact managment software for marketing/sales tracking
in my business. The only linux app I can find that does the job is SugarCRM.
However, they use mysql as their backend.
Might it be relatively easy for me to change the code so it will work with
postgres? What's involved?
Wondering if libpq lib support unicode?
Ale.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailin
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, April 22, 2005 5:07
AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Postgresql
Windows ODBC
Tonight I shall install the Postgresql
ODBC driver which I downloaded, and
Ale Raza wrote:
> Tom, Thanks for reply. I want to pass UTF-16 data. Is there any special
> build of libpq for UTF-16. I did not build libpq locally.
We do not support UTF-16 at this time. Hopefully we will in 8.1.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@ca
Tom Lane wrote:
> Bruce Momjian writes:
> > We do not support UTF-16 at this time. Hopefully we will in 8.1.
>
> Oh? Who's working on it, or even interested? Was there discussion
> of adding it to TODO?
>
> I think it would be an extremely nontrivial change, which is why
> I am not pleased wi
I searched on goolge and found my answer, I think.
From what I see (below), all I need to do is a WAMP install from one of the CDs in the back of the PHP books I bought, and then un-comment the extension=php_pgsql.dll
http://www.sitepoint.com/article/use-postgresql-php-windows/3
Connect t
Bruce Momjian writes:
> Tom Lane wrote:
>> Oh? Who's working on it, or even interested? Was there discussion
>> of adding it to TODO?
> TODO has:
> o Add support for Unicode
> To fix this, the data needs to be converted to/from UTF16/UTF8
> so the Win32 wcscoll() c
On Fri, 2005-04-22 at 12:27, Rich Shepard wrote:
> On Fri, 22 Apr 2005, Scott Marlowe wrote:
>
> > Unfortunately, there is no use of an abstraction layer in SugarCRM, and the
> > few comments I found in their forum about alternate databases indicated a
> > current focus on feature enhancements and
On Fri, 2005-04-22 at 00:30, Dinesh Pandey wrote:
> How to install Postgres 8.0.1 that supports 64-bit integer/date-time.
>
>
>
> # ./configure --prefix=/usr/local/pgsql
> --with-tclconfig=/usr/local/lib --with-tcl
>
> checking build system type... sparc-sun-solaris2.8
>
> checking host syst
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 22 Apr 2005, David Roussel wrote:
Rich, what's wrong with the app as it is? Why change anything?
David,
Because I don't have MySQL installed, have no need for it, and have used
postgres for about eight years so I know it well.
Rich
- --
Dr.
On Fri, 22 Apr 2005, Joshua D. Drake wrote:
Depends on how it was written. If they used Pear it shouldn't be "too"
difficult. It will take work no matter what.
Thanks, Josh. I should have mentioned that it's written using php as the
middleware.
Rich
--
Dr. Richard B. Shepard, President
Applied Ec
Take a look at the tod() function at the very end of
http://svn.rrs.decibel.org/viewcvs.cgi/trunk/rrs_functions.sql?rev=61&view=markup
On Wed, Apr 20, 2005 at 04:17:05PM -0500, Christopher J. Bottaro wrote:
> Hi,
> I understand that CURRENT_TIMESTAMP marks the beginning of the current
> transactio
Ale Raza <[EMAIL PROTECTED]> writes:
> Tom, Thanks for reply. I want to pass UTF-16 data. Is there any special
> build of libpq for UTF-16. I did not build libpq locally.
Nope, you're out of luck on UTF-16.
regards, tom lane
---(end of broadcast)-
http://www.postgresql.org/docs/8.0/static/catalog-pg-class.html
On Thu, Apr 21, 2005 at 08:11:09AM -0700, Bill Chandler wrote:
> All,
>
> Is there a way to determine cardinality (size) of an
> index? In general how to you query the 'attributes'
> (for lack of a better word) of an index.
>
> tha
[EMAIL PROTECTED] wrote on 04/22/2005 10:08:46 AM:
> On Fri, 2005-04-22 at 09:48, [EMAIL PROTECTED] wrote:
> > I just got done comparing SPECMarks (on spec.org) between Sun's AMD
entry
> > level servers versus similarly configured UltraSPARCs versus desktop
AMD
> > based machines. Sun's AMD mac
Tom Lane wrote:
> To make libpq UTF-16 capable, we'd have to change its API for all
> strings; either make the strings counted rather than null-terminated,
> or make the string elements wchar instead of char. After that we'd
> have to hack the FE/BE protocol too (or more likely, require libpq
> to
Guy Fraser wrote:
One of my associates swears SMARTY is the best thing since sliced
bread. I think it uses PHP an PEAR, but is more abstract. I looked
at it and it did some cool things with only a few lines of code.
Smarty is nice. However unless you run an optimizer it is slower than
snot. PEAR
One of my associates swears SMARTY is the best thing since sliced
bread. I think it uses PHP an PEAR, but is more abstract. I looked
at it and it did some cool things with only a few lines of code.
Being an old dog, I have built many different "libraries" in C
and PHP and prefer to use them. Th
On Fri, 22 Apr 2005, Chris Browne wrote:
It generally starts with seeing if the code has nonportable bits, such
as queries that are "MySQL SQL" that aren't really SQL.
Thanks, Chris.
I learned of AnteilCRM and will be using that just as soon as I figure out
a php error so I can restart httpd.
Karsten Hilbert <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> To make libpq UTF-16 capable, we'd have to change its API for all
>> strings; either make the strings counted rather than null-terminated,
>> or make the string elements wchar instead of char. After that we'd
>> have to hack the FE/B
Hello, I'm a fairly new user of PostgreSQL 8.0.2 and I'm creating a table like
this:
CREATE TABLE cases (
id serial PRIMARY KEY,
Works fine, but when I pg_dump the database, what shows up in the dump is:
CREATE TABLE cases (
id serial NOT NULL,
The documentation seems to say that 'serial
Karsten Hilbert wrote:
> Tom Lane wrote:
> > To make libpq UTF-16 capable, we'd have to change its API for all
> > strings; either make the strings counted rather than null-terminated,
> > or make the string elements wchar instead of char. After that we'd
> > have to hack the FE/BE protocol too (o
On Fri, Apr 22, 2005 at 04:44:05PM -0500, Michael Hipp wrote:
>
> Hello, I'm a fairly new user of PostgreSQL 8.0.2 and I'm creating a table
> like this:
>
> CREATE TABLE cases (
> id serial PRIMARY KEY,
>
> Works fine, but when I pg_dump the database, what shows up in the dump is:
>
> CREAT
[EMAIL PROTECTED] (Rich Shepard) writes:
>I need (and want) contact managment software for marketing/sales
> tracking in my business. The only linux app I can find that does the
> job is SugarCRM. However, they use mysql as their backend.
>
>Might it be relatively easy for me to change the
Do other databases support both UTf8 and UTF16?
Oracle supports UTF-8, UTF-16 an some other special UFT encodings. I
think some of them are pre UTF-8 becoming ratified, hence they are
partially compatible.
It's an install time option for an Oracle database. ASCII databases
can be upgraded to
We have a replication set up between 2 servers using Slony; both are
runnind PostgreSQL 8.0.1. The issue is that when updates/inserts are
made to a replicated table, the replication does not occur; apparently
this is due to spi_exec somehow not allowing/causing the slony trigger
function to fire. T
Why would you? UTF-16 and UTF-8 are just different representations for the
same domain of characters.
On Fri, 22 Apr 2005, Ale Raza wrote:
> Are we not going to lose some characters if we are putting a UTF-16 to UTF-8
> translation in front of libpq?
>
> Ale.
>
> -Original Message-
> F
On Fri, Apr 22, 2005 at 11:14:35 -0300,
Leandro Repolho <[EMAIL PROTECTED]> wrote:
> Hello guys, i installed my postgresql 8.0.2 successfuly and its
> working fine, but my postgres user works with any password, how can i
> solve ?
> I already tryed to change the password trough the pgAdmin3 but d
[EMAIL PROTECTED] writes:
> I just got done comparing SPECMarks (on spec.org) between Sun's AMD entry
> level servers versus similarly configured UltraSPARCs versus desktop AMD
> based machines. Sun's AMD machines are twice as fast as their UItraSPARCs,
> for approximately the same price. What a
On Fri, Apr 22, 2005 at 11:34:29 +0100,
David Roussel <[EMAIL PROTECTED]> wrote:
>
> > I usually put DDL statements in a transaction, for a couple of
> > reasons: so that a mistake doesn't leave me with half-done work
> > (any error will cause the entire transaction to roll back), and to
> > mak
On Fri, 22 Apr 2005, Guy Fraser wrote:
One of my associates swears SMARTY is the best thing since sliced bread. I
think it uses PHP an PEAR, but is more abstract. I looked at it and it did
some cool things with only a few lines of code.
Thanks, Guy. I'll use Anteil OpenCMS and see how I like it.
On Apr 22, 2005, at 2:09 AM, Sebastian Böck wrote:
Multiple rules on the same table and same event type are
applied in alphabetical name order.
Ah, I'd missed that. Curious that it worked for me, then, since my
rules were named insert_one, promote_one, and nothing_one, as
nothing_one comes after
On Fri, Apr 22, 2005 at 05:28:28PM -0400, Bruce Momjian wrote:
> > UTF-16 ? If so *should* it be supported in, say, 9.0 ? If not,
> > should there be a FAQ item saying why not ?
>
> Is there a reason you have to use UTF16?
No. I don't currently use either one (that is I am using a
"unicode" datab
On Fri, Apr 22, 2005 at 03:09:13PM -0400, Sven Willenberger wrote:
> On Fri, 2005-04-22 at 14:43 -0400, Alvaro Herrera wrote:
> > On Fri, Apr 22, 2005 at 02:24:57PM -0400, Jan Wieck wrote:
> > > On 4/22/2005 2:08 PM, Tom Lane wrote:
> > >
> > > >Sven Willenberger <[EMAIL PROTECTED]> writes:
> > >
What would I need to do to make PHP, installed on my desktop, talk to Postgresql. I have several CDS with WAMP installs (Windows Apache Mysgl PHP). Would I use some special driver to allow PHP to connect to Postgresql? I am going to search on google as soon as I post, but just curious if someon
Michael Hipp <[EMAIL PROTECTED]> writes:
> Hello, I'm a fairly new user of PostgreSQL 8.0.2 and I'm creating a table
> like
> this:
> CREATE TABLE cases (
> id serial PRIMARY KEY,
> Works fine, but when I pg_dump the database, what shows up in the dump is:
> CREATE TABLE cases (
> id
Tom, Thanks for reply. I want to pass UTF-16 data. Is there any special
build of libpq for UTF-16. I did not build libpq locally.
Ale
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Friday, April 22, 2005 11:10 AM
To: Ale Raza
Cc: pgsql-general@postgresql.org
Subject: R
Tom Lane wrote:
> Bruce Momjian writes:
> > Tom Lane wrote:
> >> Oh? Who's working on it, or even interested? Was there discussion
> >> of adding it to TODO?
>
> > TODO has:
>
> > o Add support for Unicode
>
> > To fix this, the data needs to be converted to/from UTF16/UTF8
Sven Willenberger <[EMAIL PROTECTED]> writes:
> We have a replication set up between 2 servers using Slony; both are
> runnind PostgreSQL 8.0.1. The issue is that when updates/inserts are
> made to a replicated table, the replication does not occur; apparently
> this is due to spi_exec somehow not
I successfully installed the PostgreSQL ODBC driver, and got Access to link
to a table as external data.
It took me a while to figure out what the proper parameters might be in
configuring the ODBC
in the control panel in Administrative Tools, and then to fill in the
proper fields in Acc
On Fri, 2005-04-22 at 14:43 -0400, Alvaro Herrera wrote:
> On Fri, Apr 22, 2005 at 02:24:57PM -0400, Jan Wieck wrote:
> > On 4/22/2005 2:08 PM, Tom Lane wrote:
> >
> > >Sven Willenberger <[EMAIL PROTECTED]> writes:
> > >>We have a replication set up between 2 servers using Slony; both are
> > >>ru
Karsten Hilbert wrote:
> On Fri, Apr 22, 2005 at 05:28:28PM -0400, Bruce Momjian wrote:
>
> > > UTF-16 ? If so *should* it be supported in, say, 9.0 ? If not,
> > > should there be a FAQ item saying why not ?
> >
> > Is there a reason you have to use UTF16?
> No. I don't currently use either one
<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
> Tonight I shall install the Postgresql ODBC driver which I downloaded, and
> experiment.
>
> Is anyone using ODBC? I was looking at Realbasic standard edition (not
> professional), and thinking of downloading the demo and trying it wi
On Fri, Apr 22, 2005 at 02:24:57PM -0400, Jan Wieck wrote:
> On 4/22/2005 2:08 PM, Tom Lane wrote:
>
> >Sven Willenberger <[EMAIL PROTECTED]> writes:
> >>We have a replication set up between 2 servers using Slony; both are
> >>runnind PostgreSQL 8.0.1. The issue is that when updates/inserts are
>
Chris Browne wrote:
[EMAIL PROTECTED] writes:
I just got done comparing SPECMarks (on spec.org) between Sun's AMD entry
level servers versus similarly configured UltraSPARCs versus desktop AMD
based machines. Sun's AMD machines are twice as fast as their UItraSPARCs,
for approximately the same pri
Are we not going to lose some characters if we are putting a UTF-16 to UTF-8
translation in front of libpq?
Ale.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Friday, April 22, 2005 12:14 PM
To: Bruce Momjian
Cc: Ale Raza; pgsql-general@postgresql.org
Subject: Re: [GEN
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Michael Fuhr wrote:
| On Fri, Apr 22, 2005 at 03:31:59AM +0100, Carlos Correia wrote:
|
|>Michael Fuhr wrote:
|>| On Fri, Apr 22, 2005 at 01:44:24AM +0100, Carlos Correia wrote:
|>|
|>|>carlos=# insert into test (c1) values( 'test');
|>|>ERROR: NEW use
Try PEAR DB.
http://pear.php.net/package/DB
It's a database abstraction layer, which means that you can change DB
later, with less hasle.
Have a look at how phpPgAdmin works. Download the source and have a
look.
http://phppgadmin.sourceforge.net/
On 22 Apr 2005, at 20:04, [EMAIL PROTECTED] wro
On Fri, 2005-04-22 at 05:51, Dinesh Pandey wrote:
> How to create this table (with partition) in Postgres.
>
>
>
> --ORACLE
>
> CREATE TABLE A (col1 NUMBER NOT NULL,
>
>col2 DATENOT NULL,
>
>col3
> ..so the only question is:
>
> drop the the serials as PKs and just use short text handles? our
> database size is arround 290 mb. there shouldn't be speed issues as long
> as proper indexes exit, right? some of the conditions are dynamic
> though, so there can't be an proper index in any case.
Ale Raza wrote:
> Are we not going to lose some characters if we are putting a UTF-16
> to UTF-8 translation in front of libpq?
No, they are just different encodings of the same character set.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadc
Ale Raza <[EMAIL PROTECTED]> writes:
> Wondering if libpq lib support unicode?
What sort of "support" have you got in mind? It passes UTF-8 data
through just fine.
regards, tom lane
---(end of broadcast)---
TIP 1: subscrib
Bruce Momjian writes:
> We do not support UTF-16 at this time. Hopefully we will in 8.1.
Oh? Who's working on it, or even interested? Was there discussion
of adding it to TODO?
I think it would be an extremely nontrivial change, which is why
I am not pleased with making casual promises that i
Hello guys, i installed my postgresql 8.0.2 successfuly and its
working fine, but my postgres user works with any password, how can i
solve ?
I already tryed to change the password trough the pgAdmin3 but didn´t worked!
---(end of broadcast)---
TIP 2
<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
> Thanks for the help with /dt... Mike, your post helped me to discover psql
> command window, I had been trying out the pgAdmin ...
>
> I found an interesting article regarding MSAccess as a front end to
> Postgresql, so I downloaded the
In my opinion the easiest language for any database development is
Borland Delphi bar NONE.
You can get the pro version for for 499.99 as a upgrade or a personal
editon is also available for free or little cost.
You might even be able to get a copy of Delphi 7 on ebay for much less.
For Postgres
On Apr 21, 2005, at 7:27 PM, Mark Miller wrote:
How do I install the headers and libraries for extending postgreSql?
They are not installed by the windows installer (see the following
post:
http://archives.postgresql.org/pgsql-hackers-win32/2005-03/
msg00169.php ).
Install MinGW and then co
Hi,
I am working on a
project where we have to define database tables and data in XML, have it
validated by an XML Schema and have it loaded into the database. We are
using our EJBs to load the data into the database so I am not so concerned with
that. What I am concerned with is generating
On Apr 22, 2005, at 8:07 AM, [EMAIL PROTECTED] wrote:
Tonight I shall install the Postgresql ODBC driver which I downloaded,
and experiment.
Is anyone using ODBC? I was looking at Realbasic standard edition
(not professional), and thinking of downloading the demo and trying it
with the ODBC.
On 4/22/05, Rob Kirkbride <[EMAIL PROTECTED]> wrote:
> I've got a query that takes quite some time to complete. I'm not an SQL
> expert so I'm not sure how to improve things.
> I've done a explain analyze and as I expected the database has to check
> every row in each of the three tables below but
I'm currently building an
Access FE to my PostgreSQL BE. So far it works great. If you're
going to be deploying this to multiple users, I'd suggest using a DSN-less
connection. That way you don't have to set up a DSN on each user's
PC.
Mike
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROT
Hi,
I've got a query that takes quite some time to complete. I'm not an SQL
expert so I'm not sure how to improve things.
I've done a explain analyze and as I expected the database has to check
every row in each of the three tables below but I'm wondering if I can
do it much quicker by a use of
Tonight I shall install the Postgresql ODBC driver which I downloaded, and
experiment.
Is anyone using ODBC? I was looking at Realbasic standard edition
(not professional), and thinking of downloading the demo and trying it with the
ODBC. Anyone here use Realbasic at all?
In Windows, wh
On Fri, Apr 22, 2005 at 03:31:59AM +0100, Carlos Correia wrote:
> Michael Fuhr wrote:
> | On Fri, Apr 22, 2005 at 01:44:24AM +0100, Carlos Correia wrote:
> |
> |>carlos=# insert into test (c1) values( 'test');
> |>ERROR: NEW used in query that is not in a rule
> |>CONTEXT: PL/pgSQL function "tfte
On Fri, Apr 22, 2005 at 11:34:29AM +0100, David Roussel wrote:
>
> > I usually put DDL statements in a transaction, for a couple of
> > reasons: so that a mistake doesn't leave me with half-done work
> > (any error will cause the entire transaction to roll back), and to
> > make the changes atomic
How to create this table (with
partition) in Postgres.
--ORACLE
CREATE TABLE A (col1 NUMBER NOT NULL,
col2 DATE NOT
NULL,
col3 VARCHAR2(500)
)
PARTITION BY RANGE (col2)
> I usually put DDL statements in a transaction, for a couple of
> reasons: so that a mistake doesn't leave me with half-done work
> (any error will cause the entire transaction to roll back), and to
> make the changes atomic for the benefit of other transactions.
Can you do that in postgres? Wi
http://www.postgresql.org/docs/8.0/interactive/kernel-resources.html#SYSVIPC
Thanks
Dinesh Pandey
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of JM
Sent: Friday, April 22, 2005 2:49 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] ShmemAlloc:
hi all,
i need help on this.. i'm experiencing this problem too often and i
need a
permanent solution.
im using 7.3.4
config file
tcpip_socket = true
max_connections = 150
superuser_reserved_connections = 2
port = 5432
#shared_buffers = 45800
shared_buffers = 47900
sort
David Wheeler wrote:
[...]
Well, I didn't have an unconditional update rule, so I added one without
removing the other two:
CREATE RULE nothing_one AS
ON INSERT TO one DO INSTEAD NOTHING;
And it worked! Now I can have an insert do an INSERT or UPDATE on
another table magically.
But my question
we have lots of small relations that only consist of a few attributes.
like in an ecommerce app we have relations like:
payment_methods
payment_methods_lang
delivery_types
delivery_types_lang
basket_states
basket_states_lang
payment_methods, delivery_types, basket_states mostly just consist of
fo
On Apr 22, 2005, at 2:51, Steve - DND wrote:
I was under the impression that using timezone('UTC',
now())::timestamptz
would give me the current UTC time, with timezone offset. Instead I am
getting the UTC time, but with an offset of -07(my local time). How do
I get
UTC time, with the 0 offset th
Continued…..
I solved this
problem by myself.
A.
For 64 bit development you need these packages installed on
Solaris server:
SUNWarcx, SUNWbtoox, SUNWdplx,
SUNWscpux, SUNWsprox,
SUNWtoox, SUNWlmsx, SUNWlmx, SUNWlibCx
Pls confirm these using the
following command.
pkginfo S
My
Postgresql version was 7.2.3.
I
guess that this was fixed in a more recent version but I could not find it in
the version history...
Could
anybody confirm that this was fixed.
Patrick
---
Patrick
90 matches
Mail list logo
