On Thu, Apr 7, 2011 at 5:50 AM, Craig Ringer
wrote:
> On 06/04/11 18:51, tejas tank wrote:
>
>> What should I have to do.?
>
> Read this:
> http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
>
> and try again with a question that includes an example you can
> distribute to show other
I am still new to postgres. Can you please tell the exact syntax for this. I
tried different things but was not able to retun the ids of the newly
inserted rows.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/how-to-insert-multiple-rows-and-get-the-ids-back-in-a-temp-tab
On 04/06/11 7:05 PM, Yang Zhang wrote:
Is it possible to attach or detach parts of a DB (e.g. tablespaces),
such that I can flexibly move the disks containing the DB tables
around to different hosts?
The last discussion I could find on this topic is from 2007, and the
answer was "No":
http://po
On 06/04/11 18:51, tejas tank wrote:
> What should I have to do.?
Read this:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
and try again with a question that includes an example you can
distribute to show others the problem, including any required data, as a
single .sql file.
On Tue, Apr 05, 2011 at 08:41:21AM +0200, hubert depesz lubaczewski wrote:
> was pointed to the fact that security definer functions have the same
> default privileges as normal functions in the same language - i.e. if
> the language is trusted - public has the right to execute them.
That default
Is it possible to attach or detach parts of a DB (e.g. tablespaces),
such that I can flexibly move the disks containing the DB tables
around to different hosts?
The last discussion I could find on this topic is from 2007, and the
answer was "No":
http://postgresql.1045698.n5.nabble.com/Possible-t
On 7/04/2011 4:02 AM, Chris Curvey wrote:
Hmmm. I'm on Ubuntu, and running 9.0.3, so I'm getting my packages from
Martin Pitt, per the instructions at
http://www.dctrwatson.com/2010/09/installing-postgresql-9-0-on-ubuntu-10-04/.
I don't seem to see any debug packages there.
Nor I. https://l
On Wed, Apr 6, 2011 at 6:18 PM, Adrian Klaver wrote:
> On Wednesday, April 06, 2011 5:21:23 pm Yang Zhang wrote:
>
>> On Wed, Apr 6, 2011 at 4:57 PM, Scott Marlowe
>> wrote:
>
>> > On Wed, Apr 6, 2011 at 5:24 PM, Yang Zhang
>> > wrote:
>
>> >> On Wed, Apr 6, 2011 at 4:22 PM, Adrian Klaver
>> >>
On Wednesday, April 06, 2011 5:21:23 pm Yang Zhang wrote:
> On Wed, Apr 6, 2011 at 4:57 PM, Scott Marlowe wrote:
> > On Wed, Apr 6, 2011 at 5:24 PM, Yang Zhang wrote:
> >> On Wed, Apr 6, 2011 at 4:22 PM, Adrian Klaver
wrote:
> >>> On Wednesday, April 06, 2011 4:06:40 pm Yang Zhang wrote:
>
On Wed, Apr 6, 2011 at 4:57 PM, Scott Marlowe wrote:
> On Wed, Apr 6, 2011 at 5:24 PM, Yang Zhang wrote:
>> On Wed, Apr 6, 2011 at 4:22 PM, Adrian Klaver
>> wrote:
>>> On Wednesday, April 06, 2011 4:06:40 pm Yang Zhang wrote:
How do I prevent accidental non-SSL connections (at least to spe
On Wed, Apr 6, 2011 at 4:53 PM, Adrian Klaver wrote:
> On Wednesday, April 06, 2011 4:24:30 pm Yang Zhang wrote:
>
>> On Wed, Apr 6, 2011 at 4:22 PM, Adrian Klaver
>> wrote:
>
>> > On Wednesday, April 06, 2011 4:06:40 pm Yang Zhang wrote:
>
>> >> How do I prevent accidental non-SSL connections (a
On Wed, Apr 6, 2011 at 5:24 PM, Yang Zhang wrote:
> On Wed, Apr 6, 2011 at 4:22 PM, Adrian Klaver wrote:
>> On Wednesday, April 06, 2011 4:06:40 pm Yang Zhang wrote:
>>> How do I prevent accidental non-SSL connections (at least to specific
>>> hosts) when connecting via psql? Is there any configu
On Wednesday, April 06, 2011 4:24:30 pm Yang Zhang wrote:
> On Wed, Apr 6, 2011 at 4:22 PM, Adrian Klaver wrote:
> > On Wednesday, April 06, 2011 4:06:40 pm Yang Zhang wrote:
> >> How do I prevent accidental non-SSL connections (at least to specific
> >> hosts) when connecting via psql? Is there a
On Wed, Apr 6, 2011 at 4:22 PM, Adrian Klaver wrote:
> On Wednesday, April 06, 2011 4:06:40 pm Yang Zhang wrote:
>> How do I prevent accidental non-SSL connections (at least to specific
>> hosts) when connecting via psql? Is there any configuration for this?
>> Thanks.
>
> http://www.postgresql.or
On Wednesday, April 06, 2011 4:06:40 pm Yang Zhang wrote:
> How do I prevent accidental non-SSL connections (at least to specific
> hosts) when connecting via psql? Is there any configuration for this?
> Thanks.
http://www.postgresql.org/docs/9.0/interactive/auth-pg-hba-conf.html
hostssl
http://ww
How do I prevent accidental non-SSL connections (at least to specific
hosts) when connecting via psql? Is there any configuration for this?
Thanks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-
On 04/06/11 1:18 PM, Steve Crawford wrote:
select ii_purchased + your_interval_field * interval '1 year' as date
from inventory_item;
Correct. I meant ...::interval...
FWIW, '1 year'::interval implies a cast, that is a postgresql-specific
notation for cast('1 year' as interval), while in
On Wed, Apr 6, 2011 at 2:09 PM, Adrian Klaver wrote:
> On Wednesday, April 06, 2011 2:00:53 pm Yang Zhang wrote:
>> Anyone know how to set your password without having it visible in the
>> terminal, psql history, etc. (i.e. getpass(3))? Hoping there's a
>> program that already does this. Thanks.
>
On Wed, Apr 6, 2011 at 2:15 PM, Yang Zhang wrote:
> On Wed, Apr 6, 2011 at 2:09 PM, Adrian Klaver wrote:
>> On Wednesday, April 06, 2011 2:00:53 pm Yang Zhang wrote:
>>> Anyone know how to set your password without having it visible in the
>>> terminal, psql history, etc. (i.e. getpass(3))? Hopin
On Wednesday, April 06, 2011 2:00:53 pm Yang Zhang wrote:
> Anyone know how to set your password without having it visible in the
> terminal, psql history, etc. (i.e. getpass(3))? Hoping there's a
> program that already does this. Thanks.
http://www.postgresql.org/docs/9.0/interactive/libpq-pgpass
Anyone know how to set your password without having it visible in the
terminal, psql history, etc. (i.e. getpass(3))? Hoping there's a
program that already does this. Thanks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.pos
On Wed, 6 Apr 2011, Rich Shepard wrote:
Have you a URL for subscribing?
Found one.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello,
I got the following exception from dblink query:
==
sql>...
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server wa
On Wed, 6 Apr 2011, Joshua D. Drake wrote:
This seems more like a question for the adodb list.
OK, Josh.
Have you a URL for subscribing?
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pg
Hello,
I got the following exception from dblink query:
==
sql>...
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server wa
On 04/06/2011 12:28 PM, John R Pierce wrote:
On 04/06/11 9:10 AM, Steve Crawford wrote:
select ii_purchased + your_interval_field * '1 year'::date as date
from inventory_item;
that SHOULD be written as...
select ii_purchased + your_interval_field * interval '1 year' as date
from inventory_it
Hmm... Please attach your log with parameters passed to server, you said only
about statement not about passwords. As well You provieded small number of
information about your EE app (but it's starnge it works on Oracle). Is it EJB
3 or 2 app, and do you use EJB Entities or JPA ones?
My suggest
On Wed, 2011-04-06 at 12:34 -0700, Rich Shepard wrote:
> My one PHP application stopped working since I upgraded postgres to
> -9.0.3. It uses the adodb interface. I can addess the postgres back end
> using psql.
>
>How do I determine if I need to update the adodb-php capabilities? And,
> what
On Mon, Apr 4, 2011 at 11:59 PM, Craig Ringer
wrote:
> On 05/04/11 11:18, Chris Curvey wrote:
>
> > This is on Ubuntu 10.10 server, 64-bit on Intel. I'm running Postgres
> > 9.0.3, 64-bit from the ppa repository.
> >
> > What can I do to help the developers find the root cause of this? I'm
> > h
Pavel Stehule Tuesday 05 April 2011 10:11:02
> Hello
>
> 2011/4/5 Nick Raj :
> > Hi all,
> > I have defined a new data type. I have defined in and out function for
> > that data type.
> > But i want to know how to integrate this data type with postgres (how
> > postgres compile my code or know my
My one PHP application stopped working since I upgraded postgres to
-9.0.3. It uses the adodb interface. I can addess the postgres back end
using psql.
How do I determine if I need to update the adodb-php capabilities? And,
what options should I have selected when building this version so the
On 04/06/11 9:10 AM, Steve Crawford wrote:
select ii_purchased + your_interval_field * '1 year'::date as date
from inventory_item;
that SHOULD be written as...
select ii_purchased + your_interval_field * interval '1 year' as date
from inventory_item;
--
Sent via pgsql-general mailing list
On Wed, Apr 06, 2011 at 09:18:15AM -0700, Christine Penner wrote:
> This still gave me a sytax error. The other suggestion to multiply
> the interval field by 1 year also gave me a syntax error.
...
> Any other suggestions?
...
> Christine Penner
> Ingenious Software
Live up to to it ?
Karst
On Apr 6, 2011, at 9:47 AM, Davenport, Julie wrote:
> We’ve never explicitly closed the connection, it just seemed to close
> automatically when the coldfusion script ended.
My guess is you've also upgraded coldfusion, or changed its config, and now
it's caching connections.
--
Scott Ribe
sco
This worked. Thanks
Christine Penner
Ingenious Software
250-352-9495
ch...@fp2.ca
On 06/04/2011 9:23 AM, Osvaldo Kussama wrote:
SELECT ii_purchased + ii_expected_life * '1 year'::interval FROM inventory_item;
On Apr 6, 2011, at 12:18, Christine Penner wrote:
> This still gave me a sytax error. The other suggestion to multiply the
> interval field by 1 year also gave me a syntax error.
What was the error? And it's preferable to do multiply rather than do the
equivalent of an eval on some string.
s
>>On Wed, Apr 06, 2011 at 09:12:55AM -0500, Davenport, Julie wrote:
>> postgres 8.4 database). When we get the error, if we try to drop
>> the table at the command line, it says the table does not exist, yet
>> we cannot rerun the script unless we stop and restart the database.
>What if you stop
This still gave me a sytax error. The other suggestion to multiply the
interval field by 1 year also gave me a syntax error.
ii_purchased is a timestamp without time zone
ii_expected_life is a smallint
Any other suggestions?
Christine Penner
Ingenious Software
250-352-9495
ch...@fp2.ca
On 06
On 04/06/2011 08:54 AM, Christine Penner wrote:
I have to add a number of years to a date field. The years come from
another field in the table.
I know I can do this:
select (ii_purchased + interval '3 year') as date from inventory_item;
But I need to replace the 3 in 3 years with another fie
On 04/06/2011 08:54 AM, Christine Penner wrote:
I have to add a number of years to a date field. The years come from
another field in the table.
I know I can do this:
select (ii_purchased + interval '3 year') as date from inventory_item;
But I need to replace the 3 in 3 years with another field
On Wed, Apr 06, 2011 at 10:47:55AM -0500, Davenport, Julie wrote:
> We've never explicitly closed the connection, it just seemed to close
> automatically when the coldfusion script ended. Not sure how I would even do
> that from a script since this is run automatically, not from the command
> l
I have to add a number of years to a date field. The years come from
another field in the table.
I know I can do this:
select (ii_purchased + interval '3 year') as date from inventory_item;
But I need to replace the 3 in 3 years with another field from the same
table ii_expected_life but I ca
On Wed, Apr 6, 2011 at 11:24 AM, JC de Villa wrote:
> Theres also the age() function
>
> SELECT age(dob);
>
> Should give you
>
> age
> -
> 31 years 5 mons 17 days
>
> If you want to be really exact about it. :)
That worked awesome too!
ide=# SELECT age(dob
On 04/06/2011 07:41 AM, hubert depesz lubaczewski wrote:
On Wed, Apr 06, 2011 at 09:06:50AM +0200, pasman pasmański wrote:
was pointed to the fact that security definer functions have the same
default privileges as normal functions in the same language - i.e. if
the language is trusted - public
On Wed, Apr 6, 2011 at 11:20 AM, Andrew Sullivan wrote:
> Why do you have the age stored at all? When you SELECT from the table
> and want someone's age, just do
>
> SELECT [. . .], extract('years' from age(CURRENT_TIMESTAMP,dob)) as age
> . . . FROM users . . .
>
> By and large, it'
On Wed, Apr 06, 2011 at 11:15:31AM -0400, Jerry Sievers wrote:
> I'd suggest not storing age but instead wrapping with a view that calls
> date_trunc('year', now() - dob).
Or put that in the query:
SELECT
...,
date_trunc('year', now() - dob) as age
FROM
users
;
Karsten
-
On Wed, Apr 6, 2011 at 11:15 PM, Jerry Sievers wrote:
> Carlos Mennens writes:
>
>> CREATE TABLE users
>> (
>> id integer PRIMARY KEY UNIQUE NOT NULL, --ID
>> fname character varying(40) NOT NULL, --First name
>> lname character varying(40) NOT NULL, --Last name
>> email character var
On Wed, Apr 06, 2011 at 10:53:49AM -0400, Carlos Mennens wrote:
> online that shows me how to do so. I've created a table called 'users'
> and I have it configured as follows:
>
> CREATE TABLE users
> (
>id integer PRIMARY KEY UNIQUE NOT NULL, --ID
>fname character varying(40) NOT NULL, --
On 04/06/2011 08:53 AM, Carlos Mennens wrote:
I've only been using PostgreSQL since Oct 2010 and it's my first
experience with SQL or any ORDBMS. I've searched on the web and been
creating my own database users, databases, tables from scratch which
has been interesting to say the least but now
Since we upgraded from postgres 8.0 to 8.4, every script where we have queries
that use temp tables now has to have an explicit drop of the temp table at the
end of the script, or it will blow up the next time it runs, saying it cannot
create the temp table because it already exists (these are c
On 04/06/2011 08:53 AM, Carlos Mennens wrote:
I've only been using PostgreSQL since Oct 2010 and it's my first
experience with SQL or any ORDBMS. I've searched on the web and been
creating my own database users, databases, tables from scratch which
has been interesting to say the least but now
On Wed, Apr 6, 2011 at 9:10 AM, Pavel Stehule wrote:
> Hello
>
> 2011/4/6 Jon Smark :
>> Hi,
>>
>> Is there support in PL/pgSQL for treating functions as first-class values?
>> Consider the pseudo-code simple example below, which illustrates how this
>> feature can be useful. I reckon that this b
Carlos Mennens writes:
> CREATE TABLE users
> (
>id integer PRIMARY KEY UNIQUE NOT NULL, --ID
>fname character varying(40) NOT NULL, --First name
>lname character varying(40) NOT NULL, --Last name
>email character varying NOT NULL, --email address
>office integer NOT NULL, --O
On Apr 6, 2011, at 8:49, Thom Brown wrote:
> On 6 April 2011 13:15, Andrew Sullivan wrote:
>> Why do these two completely different styles of
>> interaction need to be merged anyway? I think adding forum traffic to
>> the mailing list will be yet another way to make the lists less
>> useful.)
>
On Wed, Apr 06, 2011 at 09:12:55AM -0500, Davenport, Julie wrote:
> postgres 8.4 database). When we get the error, if we try to drop
> the table at the command line, it says the table does not exist, yet
> we cannot rerun the script unless we stop and restart the database.
What if you stop your
I've only been using PostgreSQL since Oct 2010 and it's my first
experience with SQL or any ORDBMS. I've searched on the web and been
creating my own database users, databases, tables from scratch which
has been interesting to say the least but now I would like to know if
this is possible in SQL or
On 04/06/2011 08:12 AM, Davenport, Julie wrote:
Since we upgraded from postgres 8.0 to 8.4, every script where we have
queries that use temp tables now has to have an explicit drop of the
temp table at the end of the script, or it will blow up the next time it
runs, saying it cannot create the t
On Wed, Apr 06, 2011 at 09:06:50AM +0200, pasman pasmański wrote:
> > was pointed to the fact that security definer functions have the same
> > default privileges as normal functions in the same language - i.e. if
> > the language is trusted - public has the right to execute them.
> >
> > maybe i'm
Since we upgraded from postgres 8.0 to 8.4, every script where we have queries
that use temp tables now has to have an explicit drop of the temp table at the
end of the script, or it will blow up the next time it runs, saying it cannot
create the temp table because it already exists (these are c
Hello
2011/4/6 Jon Smark :
> Hi,
>
> Is there support in PL/pgSQL for treating functions as first-class values?
> Consider the pseudo-code simple example below, which illustrates how this
> feature can be useful. I reckon that this behaviour can be emulated using
> EXECUTE, but I suspect there ar
On Wed, Apr 06, 2011 at 01:49:24PM +0100, Thom Brown wrote:
> It introduces another point of entry to the community. There will be
> people who are averse to mailing lists, and find forums more familiar
> and accessible. Adding more traffic means more users involved in the
> community. Not sure
Hi,
Is there support in PL/pgSQL for treating functions as first-class values?
Consider the pseudo-code simple example below, which illustrates how this
feature can be useful. I reckon that this behaviour can be emulated using
EXECUTE, but I suspect there are serious performance penalties.
Your t
> Hello,
>
>
> I have hug postgresql database and when i going to search for a query
> with database retrieve with limit of 669 is allow
>
> If my query fetch records more over 669 records then error is comming...
>
>
> RROR: more than one row returned by a subquery used as an expression
>
> *
On Wednesday, April 06, 2011 3:51:49 am tejas tank wrote:
> Hello,
>
>
> I have hug postgresql database and when i going to search for a query
> with database retrieve with limit of 669 is allow
>
> If my query fetch records more over 669 records then error is comming...
>
>
> RROR: more than
On Apr 6, 2011, at 4:21 PM, tejas tank wrote:
> ERROR: more than one row returned by a subquery used as an expression
> ** Error **
> ERROR: more than one row returned by a subquery used as an expression
> SQL state: 21000
Error Message is showing that you are using subquery with
On 6 April 2011 11:51, tejas tank wrote:
> Hello,
>
>
> I have hug postgresql database and when i going to search for a query
> with database retrieve with limit of 669 is allow
>
> If my query fetch records more over 669 records then error is comming...
>
>
> RROR: more than one row returned by
Hello,
I have hug postgresql database and when i going to search for a query
with database retrieve with limit of 669 is allow
If my query fetch records more over 669 records then error is comming...
RROR: more than one row returned by a subquery used as an expression
** Error **
I need to generate a very large crosstab. about 50 rows x 50 columns -- for
a request for a recurring report.
Example: Column Headings = Job_IDand Row Headings = Employee_ID and
Values in the table = Hours_worked
Got the idea?
I've looked at :
http://www.postgresonline.com/journal/archi
On 6 April 2011 13:15, Andrew Sullivan wrote:
> On Wed, Apr 06, 2011 at 10:08:15PM +1000, Elliot Chance wrote:
>> Hi Everyone,
>>
>> It has been a long time since this was brought up. It's time.
>>
>> Any important concerns should be discussed at (to keep everyone looking at
>> the same place):
>
On Wed, Apr 06, 2011 at 10:08:15PM +1000, Elliot Chance wrote:
> Hi Everyone,
>
> It has been a long time since this was brought up. It's time.
>
> Any important concerns should be discussed at (to keep everyone looking at
> the same place):
> http://wiki.postgresql.org/wiki/Forums_at_postgresql
Hi Everyone,
It has been a long time since this was brought up. It's time.
Any important concerns should be discussed at (to keep everyone looking at the
same place):
http://wiki.postgresql.org/wiki/Forums_at_postgresql.com.au
But also keep general discussion on the mailing list.
-
The sc
Hi Everyone,
It has been a long time since this was brought up. It's time.
Any important concerns should be discussed at (to keep everyone looking at the
same place):
http://wiki.postgresql.org/wiki/Forums_at_postgresql.com.au
But also keep general discussion on the mailing list.
-
The sc
On Tue, Apr 5, 2011 at 3:45 PM, Tom Lane wrote:
> hubert depesz lubaczewski writes:
>> was pointed to the fact that security definer functions have the same
>> default privileges as normal functions in the same language - i.e. if
>> the language is trusted - public has the right to execute them.
Thanks for the reply. I tested the issue and found out that the row has moved
to another page, which means that the index was rebuilt.
Now the question is about the cost of such rebuild: is it the same as update
with different value or update with the same value costs less.
_
On Apr 6, 2011, at 4:45 AM, Greg Corradini wrote:
> Hello,
> Is it possible yet in 8.4 to pg_dump specific functions without having to do
> the whole pg_restore thing?
>
> If it is possible, what is the syntax to dump a specific function?
>
> If not possible, then how does one use pg_restore t
On Sun, Apr 3, 2011 at 12:49 PM, Glenn Maynard wrote:
> After dumping a database (pg_dump -F c database > dump), trying to restore
> it (pg_restore dump) gives:
>
> > pg_restore: [archiver (db)] Error from TOC entry 2463; 0 58451 TABLE DATA
> table user
> > pg_restore: [archiver (db)] COPY failed
On 04/06/11 1:09 AM, dba wrote:
Is there any provision to take incremental backup for a table in postgresql.
no, but WAL log archiving is effectively an incremental backup of the
whole database cluster. It allows you to implement Point In Time
Recovery (PITR).
See http://www.postgresq
Just a few days ago, I ran into the same thing.
As I understand it: the idea behind the whole RULE system is that rules
become added / replaced in the query tree BEFORE it is submitted to the
optimizer. So, there is no quarantee queryies will be executed in the exact
form and order as you wrote th
Is there any provision to take incremental backup for a table in postgresql.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Is-there-any-provision-to-take-incremental-backup-tp4285873p4285873.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com
> was pointed to the fact that security definer functions have the same
> default privileges as normal functions in the same language - i.e. if
> the language is trusted - public has the right to execute them.
>
> maybe i'm missing something important, but given the fact that security
> definer fun
80 matches
Mail list logo
