On Wednesday 05 March 2008 06:16, raghukumar wrote:
Hai EverBody,
Can I know what is the query by which we can find the number of
sundays between two given dates in postgres
Thanks In Advance,
Raghu...
I think the easiest way is to set up a table populated with all dates and
Hi List,
I got the logs as below from log file of PGSQL 7.4.2 on Solaris-9. Can
any one please give the exact meaning of it. And I have not found the
file any where on the server 00040072.
LOG: recycled transaction log file 00040072
And I found most of the logged
Kristina Yamamoto wrote:
We decided to migrate the database to PostgreSQL, because of the
ability to still use Access as the front-end (there are forms,
queries, etc that are easier for the volunteers to use in Access than
learning SQL.) We bought the DBConvert program, which stores the
photos
Please don't start a new message by replying to someone else's message.
If you are going to, trim their message body from your message.
Suresh Gupta VG wrote:
I got the logs as below from log file of PGSQL 7.4.2 on Solaris-9. Can
any one please give the exact meaning of it. And I have not
Erwin Brandstetter wrote:
Hi!
What I want to do:
Import a file from the file system into a bytea field of a table.
Now, I could copy over from pg_largeobject:
And create a large object and export from there as above.
But that seems unnecessarily complex, and .. well .. stupid.
There
Hi,
I have a basic question about pg client. I know it is
possible to let pg complete the name of a table by pressing
the arrow key. But unfortunately I can't do it while I am
connected to pg (8.2) from a gnome terminal.
Also the history does not work for me when I press up arraow
key.
Is
Emmanuel Quevillon wrote:
Hi,
I have a basic question about pg client. I know it is possible to let pg
complete the name of a table by pressing the arrow key.
It's the Tab key by default, which might be what you're referring to. I
can't remember what (if anything) French keyboards have on
Richard Huxton wrote:
Emmanuel Quevillon wrote:
Hi,
I have a basic question about pg client. I know it is possible to let
pg complete the name of a table by pressing the arrow key.
It's the Tab key by default, which might be what you're referring to.
Yep.
But
unfortunately I can't do
The first UK PostgreSQL Conference will be held on 2nd April 2008 in
Birmingham, United Kingdom. The schedule for the day includes talks
from a variety of PostgreSQL community members, users and companies,
including:
* Simon Riggs, author of PITR and partitioning in Postgres - speaking
on
I'm trying to find a count of records based on a number of factors,
one of them being that records in different tables have been created
within 1 hour of each other.
The tables in question look like this:
character_tbl
Column |Type | Modifiers
On 3/5/08, A. Kretschmer [EMAIL PROTECTED] wrote:
With generate_series() i generate a list of dates, and later i check if
the date are a saturday. Okay, you need to know sunday - change from 6
to 0 and ou course, you can calculate the parameter for the
generate_series like
I find it
Richard Broersma wrote:
On Tue, Mar 4, 2008 at 8:44 AM, Justin [EMAIL PROTECTED] wrote:
I searched the archive of the mail list and did not find anything
Search the documentation. There are a couple great examples posted at
Apologizes if this has already been announced -
http://www.scribd.com/doc/551889/Introducing-Freebsd-70
a presentation of the SMP in FreeBSD 7.0 using PostgreSQL and MySQL to
produce benchmarks.
Notable quotes -
a) MySQL degrades after utilizing all CPUs, while PostgreSQL does not
(the
Is there a way to generate and directly execute query results within
psql? Essentially, I want eval within psql.
For example, a lot of us generate DDL commands using queries, like this:
= SELECT 'GRANT SELECT ON VIEW '||table_schema||'.'||
table_name||' TO budget_view;'
On Tue, Mar 04, 2008 at 12:02:27PM -0800, Shahaf Abileah wrote:
I'm looking for a systematic way to document the schema for the database
behind our website (www.redfin.com http://www.redfin.com/ ), so that
the developers using this database have a better idea what all the
tables and columns
I am having a table with more than 1000 records, i am not having index in
that, while executing that query it occupies the processor..
I created an index, and then executed that query., Now it is not getting
executed at all... while seeing the top the processor is busy in WA, that it
is waiting
On Wed, 5 Mar 2008, [EMAIL PROTECTED] wrote:
b) PostgreSQL is in general 35%-45% faster.
And this is using sysbench, which is an old MySQL benchmark with
rudimentary PostgreSQL support bolted on. Last time I checked it didn't
even put statements into transaction blocks correctly under
Thank you i was looking for examples and never thought to look at the
user comments. I searched the help files several times but never
thought to look at the user comment help online.
the help coming that comes with PGAdmin III does not have the user
comments. once i get the aggregate
On Mar 5, 10:20 am, [EMAIL PROTECTED] (Richard Huxton) wrote:
Erwin Brandstetter wrote:
Hi!
What I want to do:
Import a file from the file system into a bytea field of a table.
(...)
Not that I know of. It's simple enough to do from the application side
of things of course (well, in most
On 3/5/08, Erwin Brandstetter [EMAIL PROTECTED] wrote:
The whole concept behind large objects is a bit off. Since we have
TOAST tables, it is of limited use to store large objects away in a
system table. It would be useful to have (additional) functions like:
lo_import(text) RETURNS
I am having a table with more than 1000 records, i am not having index in
that, while executing that query it occupies the processor..
1000 rows is not much - I guess the index is not necessary at all, as the
traditional sequential scan is faster than index scan (due to random
access vs.
I guess I'm missing something.
Question part A)
I have smithrn in ident.conf, and he can now connect as user airburst
to same-named DB.
I tested and before he couldn't.
But when i:
ALTER ROLE airburst WITH UNENCRYPTED PASSWORD 'maxwellsmart' ;
ALTER ROLE
Even after reloading and
I guess I'm missing something.
Question part A)
I have smithrn in ident.conf, and he can now connect as user airburst
to same-named DB.
I tested and before he couldn't.
But when i:
ALTER ROLE airburst WITH UNENCRYPTED PASSWORD 'maxwellsmart' ;
ALTER ROLE
Even after reloading and
On 06/03/2008, Ralph Smith [EMAIL PROTECTED] wrote:
I guess I'm missing something.
Question part A)
Even after reloading and restarting the DB, which shouldn't be necessary,
smithrn still gets in w/o any password checks.
How come?
Impossible to answer w/o knowing any entries in your
Sorry about the earlier incomplete message, this is the complete version
I have an Access database that I have exported to PostgreSQL via ODBC, which
has worked ok the data is in PostgreSQL but some of the column names were
in mixed case e.g. AccountCode
When I look at the table definitions in
I have an Access database that I have exported to PostgreSQL via ODBC, which
has worked ok the data is in PostgreSQL but some of the column names were
in mixed case e.g. AccountCode
When I look at the table definitions in pgadmin these are shown in quotes
e.g.AccountCode and any queries made
Tony Cade wrote:
There are too many fields to issue alter table commands to rename in SQL so
my question is , is it safe to use a query such as
select relfilenode from pg_class where relname='rates'
update pg_attribute set attname=lower(attname) where attnum 0 and
attrelid= (
Andrej Ricnik-Bay [EMAIL PROTECTED] writes:
On 06/03/2008, Ralph Smith [EMAIL PROTECTED] wrote:
Even after reloading and restarting the DB, which shouldn't be necessary,
smithrn still gets in w/o any password checks.
How come?
Impossible to answer w/o knowing any entries in your pg_hba.conf
Hello Tony,
Perhaps this will help maybe not. Since the original data import
used quotes for the fields then any case was maintained in the
creation of the new table(s) fields(s). Just take your original
import file and remove all the quotes, ,. Re-import and and
PostgreSQL will use all
And should be easier to find in the manual!
I've looked in many related chapters of the 8.2 manual for a way to
find out
WHY a specific user has access to a database.
Chapter 5Data Definition
Chapter 18 Database Roles Privileges
Chapter 20 Client Authorization
postgres=# select *
Csaba Nagy wrote:
While upgrading our schema between application versions, we also had a
few constraint changes. Some of those changes were dropping NOT NULL
constraints on some columns. Our schema had a few such NOT NULL
constraints, which were created using the named variant of the column
I was wondering if anyone knows of any good ER Diagram tools for
Postgres that run on Linux.
I have been using DBDesigner by FabForce for a couple of years, but
development has stopped while MySQL workbench is being built (for
windows only). Neither of these applications will talk to Postgres and
On Wednesday 05 March 2008 20:33:43 Conor McTernan wrote:
I was wondering if anyone knows of any good ER Diagram tools for
Postgres that run on Linux.
I have been using DBDesigner by FabForce for a couple of years, but
development has stopped while MySQL workbench is being built (for
windows
People,
On Wed, 2008-03-05 at 20:56 -0700, Kevin Kempter wrote:
On Wednesday 05 March 2008 20:33:43 Conor McTernan wrote:
I was wondering if anyone knows of any good ER Diagram tools for
Postgres that run on Linux.
I have been using DBDesigner by FabForce for a couple of years, but
now it is for 500 records.
postgres 7.4
Debian
--
call_id | integer | not null default
nextval('call_log_seq'::text)
agent_id | integer |
call_id already has index.
Kevin Kempter wrote:
On Wednesday 05 March 2008 20:33:43 Conor McTernan wrote:
I was wondering if anyone knows of any good ER Diagram tools for
Postgres that run on Linux.
If you're not against paying there is dbwrench http://www.dbwrench.com/.
Java so it could be a bit of a problem because
Ralph Smith wrote:
And should be easier to find in the manual!
I've looked in many related chapters of the 8.2 manual for a way to
find out
WHY a specific user has access to a database.
Chapter 5Data Definition
Chapter 18 Database Roles Privileges
Chapter 20 Client Authorization
Dear all,
i was reading the postgres docs concerning the
Database Physical Storage. I found that the
information present there is not enough to satisfy my
curiosity.
Are there any documentation out there that describes
in more details the Database Physical Storage of
potgres ?
In the Page
38 matches
Mail list logo