Messed up - I mean when going "up" and scrolling command history it
shows long queries (eg 2 line long) in single line and the exceeding
part overwrites the beginning of the query), or when writing long SQL
at some point I'm starting to overwriting it from the beginning of the
line.
Sometimes whe
Johan Nel wrote:
>Did an installation of PostgreSQL on a new laptop and I just cannot
>remember which .sql script to run to have the above schemas showing in
>pgAdmin or is it something to do with a checkbox/setting during
>installation?
File > Options... > Display > [x] Show System Objects in
Mike Hall wrote:
> I'm currently converting an MS Access database to PostgreSQL
> (version 8.1 as it is the vesion that ships with CentOS 5).
>
> I'm having trouble with an INSERT statement attempting to
> insert an empty value ('') into a field with data type DATE.
> This produces the followin
Mike Hall wrote:
> I'm currently converting an MS Access database to PostgreSQL (version 8.1 as
> it is the vesion that ships with CentOS 5).
What version of Microsoft Access are you using? I haven't seen this
issue with Access 2007, which I've been forced to use in a recent
project. It actually
Hi list,
I am searching for function which creates or appends to array content of cursor.
I found that it is possible to get select result as array so it is
probably logical to have something similar for cursors.
I mean, there is copy-paste from documentation for 8.3 version:
-
SELECT ARRAY(SEL
what you want in case of the table that gets read a lot, is partition +
cluster.
For table that changes a lot, I don't really know myself either. It is
usually trial and error type of scenario for me. (partitioning too, but that
depends on what parts are updated and under what conditions, etc).
In article <[EMAIL PROTECTED]>,
Brian714 <[EMAIL PROTECTED]> writes:
> Currently, the database contains thousands of records in the Customers and
> Creditcards tables. I would like to re-define the Customers table to follow
> the following schema:
> Customers Table
> id:integer -- primary key
> f
Hello
2008/11/3 alebu <[EMAIL PROTECTED]>:
> Hi list,
> I am searching for function which creates or appends to array content of
> cursor.
> I found that it is possible to get select result as array so it is
> probably logical to have something similar for cursors.
> I mean, there is copy-paste f
[Forgot to send this to the list first time]
On Fri, Oct 31, 2008 at 12:27:27PM -0600, Scott Marlowe wrote:
> On Fri, Oct 31, 2008 at 9:36 AM, Chris Butler <[EMAIL PROTECTED]> wrote:
> > I've been having intermittent problems with our DB server (running
> > postgresql 8.3.3) reaching its connectio
Hi,
I've got a database with massive tables which fall into 2 categories:
Tables which don't change often but get read a LOT, and tables which
are heavily added to continuously and sometimes read.
Would there be any advantage in moving the latter logging tables to a
separate tablespace, bearing i
I just have some batch work in scripts that I pass through:
psql < script.sql &>script.log &
or may be run by cron.
In sql raise notice is not available. Is there any other way to send
messages to the logs without polluting them too much with -a?
--
Ivan Sergio Borgonovo
http://www.webthatwork
Tom Lane wrote:
> "Scott Marlowe" <[EMAIL PROTECTED]> writes:
>> Note that, at least in older versions, MySQL completely materialized a
>> temporary table from a view, then used that for the view. This is
>> horribly inefficient, and results in a lot of people thinking views
>> are slow. Not sure
On Mon, Nov 03, 2008 at 03:14:14PM +0100, Ivan Sergio Borgonovo wrote:
> I just have some batch work in scripts that I pass through:
>
> psql < script.sql &>script.log &
>
> or may be run by cron.
>
> In sql raise notice is not available. Is there any other way to send
> messages to the logs wit
Peter Eisentraut wrote:
> Craig Ringer wrote:
>> So - it's potentially even worth compressing the wire protocol for use
>> on a 100 megabit LAN if a lightweight scheme like LZO can be used.
>
> LZO is under the GPL though.
Good point. I'm so used to libraries being under more appropriate
licenses
Hi list,
This question is general for any database JDBC but I think it's ok if
I post it here.
Lets say I have s stored procedure which gets an array of objects like
one of it IN parameters.
How can I pass an array of my objects into JDBC PreparedStatement object?
The only recomendation I saw was t
alebu <[EMAIL PROTECTED]> writes:
> How can I pass an array of my objects into JDBC PreparedStatement object?
The folks who would know this are more likely to notice your question
if you ask on pgsql-jdbc ...
regards, tom lane
--
Sent via pgsql-general mailing list (pgsq
I'm looking for a bit more guidance on gin index creation.
The process:
- vaccum analyze.
- start a transaction that:
- drop the triggers to update a tsvector
- drop the index on the tsvector
- fill several tables
- update the tsvector in a table with ~800K records
- recreate the gin index
- commi
On Mon, 3 Nov 2008 16:45:35 +0100
Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote:
Forgot to add that top say postgresql is using 100% CPU and 15%
memory.
> I'm looking for a bit more guidance on gin index creation.
>
> The process:
> - vaccum analyze.
> - start a transaction that:
> - drop the
On Mon, 3 Nov 2008, Ivan Sergio Borgonovo wrote:
I'm looking for a bit more guidance on gin index creation.
The process:
- vaccum analyze.
- start a transaction that:
- drop the triggers to update a tsvector
- drop the index on the tsvector
- fill several tables
- update the tsvector in a table
Ivan Sergio Borgonovo <[EMAIL PROTECTED]> writes:
> maintenance_work_mem is still untouched. What would be a good value
> to start from?
GIN index build time is *very* sensitive to maintenance_work_mem.
Try cranking it up to a couple hundred megabytes and see if that
helps.
Also, if you're on 8.2
Hi,
I have installed PostgreSQL 8.3.4 on Windows Vista Business Edition.
My currently logged on user is the only user that does not need to specify a
password when running psql -U postgres
I used the following guide:
PostgreSQL on Windows with SSL
--
--All variables
Craig Ringer wrote:
So - it's potentially even worth compressing the wire protocol for use
on a 100 megabit LAN if a lightweight scheme like LZO can be used.
LZO is under the GPL though.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Hi Thom,
table spaces are not in the first place related with addressing usage pattern
of individual tables.
They are a mechanism for putting up a *logical* layout of persistent storage.
As such they are describing segments of persistence storage that will (or
"might from the point of view of th
Hola He instalado el:
Porgressql 8.3 en /usr/local/postgres_8.3
Postgis 1.3 en /usr/local/ postgis_13
geos 3 en /usr/local/geos_3
proj46 en /usr/local/proj_46
creo la base de datos
pero al momento de incorporar la parte espacial con el siguiente comedo:
-bash-3.2$ ./psql -f /usr/local/postgis_13/s
The 'real' problem was the database had not been re-indexed in a long
while (it is a test system). After re-indexing the db, the query below
ran fairly quicky:
metadata=# SELECT * FROM viewspace.siap AS t WHERE
t."startDate"='2008-10-27%' AND t.prop_id LIKE '%' LIMIT 1000;
The 'startDate' i
Eduardo Arévalo escribió:
> Hola He instalado el:
> Porgressql 8.3 en /usr/local/postgres_8.3
> Postgis 1.3 en /usr/local/ postgis_13
> geos 3 en /usr/local/geos_3
> proj46 en /usr/local/proj_46
> creo la base de datos
> pero al momento de incorporar la parte espacial con el siguiente comedo:
> -b
I am running PostgreSQL 8.3.4 on Centos 5.2 with a single Xeon 5472,
1600 MHz, 12 MB cache, 3.0 GHz quad core, and 4 GB RAM.
My database is only about 50 MB and there are only about 20 users.
For some reason Postgres is pegging my CPU and I can barely log on to
reboot the machine. After reboo
I'm trying to test the time in a time column to see if it's the same
minute as the current time. I wouldn't have thought this would be
difficult:
WHERE TO_CHAR(now(), 'HH24MI') = TO_CHAR(time_column, 'HH24MI')
Doesn't work, though:
ERROR: function to_char(time with time zone, unknown) does not
On 03/11/2008 19:01, Bill Moran wrote:
> It seems as if EXTRACT() will work, but it sure feels hacky
> to do:
>
> (extract(hours from now()) = extract(hours from time_column)
> AND
> (extract(minutes from now()) = extract(minutes from time_column)
I'd have thought that this was the correct way
On Mon, Nov 3, 2008 at 12:01 PM, Bill Moran
<[EMAIL PROTECTED]> wrote:
>
> I'm trying to test the time in a time column to see if it's the same
> minute as the current time. I wouldn't have thought this would be
> difficult:
>
> WHERE TO_CHAR(now(), 'HH24MI') = TO_CHAR(time_column, 'HH24MI')
Use
On Monday 03 November 2008, Jason Long <[EMAIL PROTECTED]>
wrote:
> I would greatly appreciate any advice on debugging this problem. While
> there are relatively live few users the data is extremely important and
> the users will not wait for me to see what is wrong. They demand
> immediate reso
Jason Long <[EMAIL PROTECTED]> writes:
> For some reason Postgres is pegging my CPU and I can barely log on to
> reboot the machine.
Well, you need to find out why. Turning on query logging (see
log_statement) would probably be a good first step --- it'd help
you determine if there's a specific
On Mon, Nov 3, 2008 at 11:30 AM, Jason Long
<[EMAIL PROTECTED]> wrote:
> I am running PostgreSQL 8.3.4 on Centos 5.2 with a single Xeon 5472, 1600
> MHz, 12 MB cache, 3.0 GHz quad core, and 4 GB RAM.
>
> My database is only about 50 MB and there are only about 20 users.
>
> For some reason Postgres
In response to "Scott Marlowe" <[EMAIL PROTECTED]>:
> On Mon, Nov 3, 2008 at 12:01 PM, Bill Moran
> <[EMAIL PROTECTED]> wrote:
> >
> > I'm trying to test the time in a time column to see if it's the same
> > minute as the current time. I wouldn't have thought this would be
> > difficult:
> >
> >
On Mon, Nov 3, 2008 at 12:25 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Mon, Nov 3, 2008 at 11:30 AM, Jason Long
> <[EMAIL PROTECTED]> wrote:
>> I am running PostgreSQL 8.3.4 on Centos 5.2 with a single Xeon 5472, 1600
>> MHz, 12 MB cache, 3.0 GHz quad core, and 4 GB RAM.
>>
>> My database i
On Mon, Nov 3, 2008 at 12:25 PM, Bill Moran
<[EMAIL PROTECTED]> wrote:
> In response to "Scott Marlowe" <[EMAIL PROTECTED]>:
>
>> On Mon, Nov 3, 2008 at 12:01 PM, Bill Moran
>> <[EMAIL PROTECTED]> wrote:
>> >
>> > I'm trying to test the time in a time column to see if it's the same
>> > minute as t
On 03/11/2008 16:21, Serge Fonville wrote:
> Hi,
>
> I have installed PostgreSQL 8.3.4 on Windows Vista Business Edition.
> My currently logged on user is the only user that does not need to
> specify a password when running psql -U postgres
What happens if you log in as a different user and then
On Mon, Nov 3, 2008 at 12:31 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Mon, Nov 3, 2008 at 12:25 PM, Bill Moran
> <[EMAIL PROTECTED]> wrote:
>> In response to "Scott Marlowe" <[EMAIL PROTECTED]>:
>>
>>> On Mon, Nov 3, 2008 at 12:01 PM, Bill Moran
>>> <[EMAIL PROTECTED]> wrote:
>>> >
>>> > I
In response to "Scott Marlowe" <[EMAIL PROTECTED]>:
> On Mon, Nov 3, 2008 at 12:25 PM, Bill Moran
> <[EMAIL PROTECTED]> wrote:
> > In response to "Scott Marlowe" <[EMAIL PROTECTED]>:
> >
> >> On Mon, Nov 3, 2008 at 12:01 PM, Bill Moran
> >> <[EMAIL PROTECTED]> wrote:
> >> >
> >> > I'm trying to te
Bill Moran <[EMAIL PROTECTED]> writes:
> Not quite. As shown in the examples, date_trunc() works fine on
> TIME WITHOUT TIME ZONE, but there's no such function for TIME WITH
> TIME ZONE.
Well, actually there's no date_trunc for time either:
regression=# \df date_trunc
Scott Marlowe wrote:
On Mon, Nov 3, 2008 at 12:25 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
On Mon, Nov 3, 2008 at 11:30 AM, Jason Long
<[EMAIL PROTECTED]> wrote:
I am running PostgreSQL 8.3.4 on Centos 5.2 with a single Xeon 5472, 1600
MHz, 12 MB cache, 3.0 GHz quad core, and 4 GB R
Tom Lane escribió:
> However, the interval version of the function can capture the time case
> because there's an implicit cast from time to interval:
>
> regression=# select casttarget::regtype,castcontext,castfunc::regprocedure
> from pg_cast where castsource = 'time'::regtype;
>castta
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Tom Lane escribió:
>> regression=# select casttarget::regtype,castcontext,castfunc::regprocedure
>> from pg_cast where castsource = 'time'::regtype;
> BTW it very much looks like we should have a pg_casts view that displays
> these things in a human-re
Tom Lane escribió:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > Tom Lane escribi�:
> >> regression=# select casttarget::regtype,castcontext,castfunc::regprocedure
> >> from pg_cast where castsource = 'time'::regtype;
>
> > BTW it very much looks like we should have a pg_casts view that displa
Hi all,
I'm re-writing some functions and migrating bussines logic from a
client application to PostgreSQL.
I expected something like this to work, but it doesn't:
-- simple table
CREATE TABLE sometable (
id SERIAL PRIMARY KEY,
text1 text,
text2 text
);
CREATE OR REPLACE FUNCTION add_s
Forgot to mention: using 8.3.3 on FreeBSD.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Jason Long wrote:
Scott Marlowe wrote:
On Mon, Nov 3, 2008 at 12:25 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
On Mon, Nov 3, 2008 at 11:30 AM, Jason Long
<[EMAIL PROTECTED]> wrote:
I am running PostgreSQL 8.3.4 on Centos 5.2 with a single Xeon 5472, 1600
MHz, 12 MB cache, 3.0 GHz qu
> It doesn't matter that much, anyway, in that deflate would also do the
> job quite well for any sort of site-to-site or user-to-site WAN link.
I used to use that, then switched to bzip. Thing is, if your client is
really just issuing SQL, how much does it matter? Compression can't help
with late
"Diego Schulz" <[EMAIL PROTECTED]> writes:
> I expected something like this to work, but it doesn't:
> CREATE OR REPLACE FUNCTION add_something(text, text) RETURNS INTEGER AS $$
>INSERT INTO sometable (id, foo, bar ) VALUES (DEFAULT, $1, $2 )
> RETURNING id ;
> $$ LANGUAGE SQL ;
This case was
In order to keep my application from freezing up when a query pegs my
CPU I set statement_timeout=12, but I read in the manual
"Setting statement_timeout in postgresql.conf is not recommended because
it affects all sessions."
I am used JDBC exclusively for the applicatoin and I read here
On Mon, 3 Nov 2008, Jason Long wrote:
*Would someone please comment on the status of setQueryTimeout in the JDBC
driver? Is there any workaround if this is still not implemented?*
setQueryTimeout is not implemented, the workaround is to manually issue
SET statement_timeout = xxx calls via
On 04/11/2008 01:20, Diego Schulz wrote:
> I also tried this (somewhat silly) syntax to circumvent the issue
> without resorting in currval:
Just curious - what have you got against currval()? It seems to me that
it would make your life easier
Ray.
-
On Mon, 03 Nov 2008 11:04:45 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> Ivan Sergio Borgonovo <[EMAIL PROTECTED]> writes:
> > maintenance_work_mem is still untouched. What would be a good
> > value to start from?
> GIN index build time is *very* sensitive to maintenance_work_mem.
> Try cranking
Scott Ribe wrote:
>> It doesn't matter that much, anyway, in that deflate would also do the
>> job quite well for any sort of site-to-site or user-to-site WAN link.
>
> I used to use that, then switched to bzip. Thing is, if your client is
> really just issuing SQL, how much does it matter?
It de
I've been tearing my hair out over this one issue and I'm hoping that
someone on this list will have an insight on the matter that will shed
some light on why the system is doing what it's doing.
I have a database with a number of tables, two of which are projects and
resources. We also have a us
On Mon, Nov 3, 2008 at 10:24 PM, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
> On 04/11/2008 01:20, Diego Schulz wrote:
>
>> I also tried this (somewhat silly) syntax to circumvent the issue
>> without resorting in currval:
>
> Just curious - what have you got against currval()? It seems to me tha
Jonathan Guthrie wrote:
> The stored procedures (250 or so of them) have
> been converted into Postgres functions using a tool called SQLWays. I'm
> using named prepared procedures for each of the Postgres functions that
> are called, plus three, "BEGIN", "COMMIT", and "ROLLBACK", which consist
On Mon, Nov 3, 2008 at 8:51 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Diego Schulz" <[EMAIL PROTECTED]> writes:
>> I expected something like this to work, but it doesn't:
>
>> CREATE OR REPLACE FUNCTION add_something(text, text) RETURNS INTEGER AS $$
>>INSERT INTO sometable (id, foo, bar ) VAL
"Diego Schulz" <[EMAIL PROTECTED]> writes:
> On Mon, Nov 3, 2008 at 10:24 PM, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
>> Just curious - what have you got against currval()? It seems to me that
>> it would make your life easier
> I simply don't like having to cast from BIGINT to INTEGER,
Jonathan Guthrie wrote:
> When I create a project, entries in the project table and the resource
> table are created in a single function. Then, separate functions are
> called to set the owner's access to the new project. These other
> functions are failing because of the resourceid foreign key
60 matches
Mail list logo