Hi
I suggest reading this document:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
then trying to post your question again with a bit more information,
exact error messages, etc. Since it sounds like you're working with
PostGIS you might be better off on the PostGIS mailing lists
Hi every1 how are u all??? Members i am new in postgres and want to
work on pgrouting but i am facing some issue will u please help me???
I have loaded my line shapefile in pgadmin environment but when i made
a query at it it will show that ur table (Route dont have
relation)..wht is this???I ha
This message has been digitally signed by the sender.
_GENERAL__Restoring_default_privileges_on_a_table.eml
Description: Binary data
-
Hi-Tech Gears Ltd, Gurgaon, India
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
Hi all,
I just ran into a long-standing issue with the Pg privileges system.
It seems there is no way to restore a table's default privileges to what
they were directly after creating the table.
`REVOKE ALL ON table …` revokes not only privileges that were explicitly
granted using GRANT but also
karthikeyan writes:
> I am trying to increase size of the column which was/is part of the Primary.
> ...
> Error message:
> ERROR: xdb-83016: cannot alter scatter column
> relation "test_dim_store" column "store_nbr"
There is no such error text in the postgresql source code. I am
guess
Hi,
I am trying to increase size of the column which was/is part of the Primary.
Exiting table
CREATE TABLE test_dim_store
(
storek integer NOT NULL DEFAULT
nextval('dim_store_storek_seq1'::regclass),
retailerk character varying(10) NOT NULL,
store_nbr character varying(5) NOT NULL,
store
Hi
> As I'm sure many people know, check_postgres.pl has a wonderful (if rather
> arcane) query to check table bloat, which has been copied all over the
> intarwebz. When I try to use this query one one of my databases I'm told my
> table (which has had no deletes) is wasting a whole lot of bytes,
As I'm sure many people know, check_postgres.pl has a wonderful (if rather
arcane) query to check table bloat, which has been copied all over the
intarwebz. When I try to use this query one one of my databases I'm told my
table (which has had no deletes) is wasting a whole lot of bytes, but no a
On Wednesday, December 28, 2011 1:02:39 pm Greg Donald wrote:
> On Wed, Dec 28, 2011 at 1:00 PM, Tom Lane wrote:
> > Greg Donald writes:
> >>> Are you
> >>> sure that the sequence is being used to insert those values into the
> >>> table?
> >>
> >> When I insert a new row into either of the tabl
Greg Donald writes:
> My pg_dump backups from before 9.1.1 were correct, now they are not:
> diff backup_20111212031701.sql backup_20111223013539.sql | grep setval
> | grep state_id
> < SELECT pg_catalog.setval('cp_state_id_seq', 52, true);
> > SELECT pg_catalog.setval('cp_state_id_seq', 1, fals
On Wed, Dec 28, 2011 at 1:00 PM, Tom Lane wrote:
> Greg Donald writes:
>>> Are you
>>> sure that the sequence is being used to insert those values into the
>>> table?
>
>> When I insert a new row into either of the tables I previously
>> described, the sequence 'Current value' increments by one.
Adrian Klaver writes:
> On Wednesday, December 28, 2011 7:51:24 am Greg Donald wrote:
>> None of my sequences are named 'new'. What do you mean?
> I was thinking of the more generic case. The problem with 'new' in the above
> bug
> is that it is a reserved word and the list of reserved words r
Greg Donald writes:
>> Are you
>> sure that the sequence is being used to insert those values into the
>> table?
> When I insert a new row into either of the tables I previously
> described, the sequence 'Current value' increments by one.
According to what? If you look directly at a sequence (e
On Wed, Dec 28, 2011 at 12:34 PM, Adrian Klaver wrote:
> On Wed, Dec 28, 2011 at 8:38 AM, Merlin Moncure wrote:
>>
>> On Wed, Dec 28, 2011 at 10:20 AM, Adrian Klaver
>> wrote:
>>
>> >
>> > I was thinking of the more generic case. The problem with 'new' in the
>> > above bug
>> > is that it is a
On Wed, Dec 28, 2011 at 8:38 AM, Merlin Moncure wrote:
> On Wed, Dec 28, 2011 at 10:20 AM, Adrian Klaver
> wrote:
>
> >
> > I was thinking of the more generic case. The problem with 'new' in the
> above bug
> > is that it is a reserved word and the list of reserved words recognized
> by
> > pg_d
hosuresh writes:
> and for $ ldd $(which psql) command it displaying like
> -bash-4.1$ ldd $(which psql)
> linux-gate.so.1 => (0x00112000)
> libpq.so.5 => /usr/lib/libpq.so.5 (0x005b5000)
Yeah, so it's linking to the libpq in /usr/lib, which is presumably the
one supplie
On Wed, Dec 28, 2011 at 10:20 AM, Adrian Klaver wrote:
> On Wednesday, December 28, 2011 7:51:24 am Greg Donald wrote:
>> On Wed, Dec 28, 2011 at 9:30 AM, Adrian Klaver
> wrote:
>> > Wonder if it is related to this:
>> > http://archives.postgresql.org/pgsql-bugs/2011-11/msg00098.php
>>
>> None of
On Wednesday, December 28, 2011 8:03:34 am Greg Donald wrote:
> On Wed, Dec 28, 2011 at 9:30 AM, Adrian Klaver
wrote:
> > Might want to file bug report:
> > http://www.postgresql.org/support/submitbug/
>
> Can't, not at the moment anyway.
>
> > psql --version
>
> psql (PostgreSQL) 9.1.1
>
> I
On Wednesday, December 28, 2011 7:51:24 am Greg Donald wrote:
> On Wed, Dec 28, 2011 at 9:30 AM, Adrian Klaver
wrote:
> > Wonder if it is related to this:
> > http://archives.postgresql.org/pgsql-bugs/2011-11/msg00098.php
>
> None of my sequences are named 'new'. What do you mean?
I was thinki
On Wed, Dec 28, 2011 at 9:30 AM, Adrian Klaver wrote:
> Might want to file bug report:
> http://www.postgresql.org/support/submitbug/
Can't, not at the moment anyway.
> psql --version
psql (PostgreSQL) 9.1.1
I'm not running the latest 9.1.2 version as required by that
particular bug report form
On Wed, Dec 28, 2011 at 9:30 AM, Adrian Klaver wrote:
> Wonder if it is related to this:
> http://archives.postgresql.org/pgsql-bugs/2011-11/msg00098.php
None of my sequences are named 'new'. What do you mean?
> Might want to file bug report:
> http://www.postgresql.org/support/submitbug/
>
> I
On Wednesday, December 28, 2011 7:18:01 am Greg Donald wrote:
> On Wed, Dec 28, 2011 at 9:07 AM, Adrian Klaver
wrote:
> > So how are the sequences being tied to the tables? In your previous post
> > the table definitions did not show a SERIAL type or a default of
> > nextval().
>
> The id column
On Wed, Dec 28, 2011 at 9:07 AM, Adrian Klaver wrote:
> So how are the sequences being tied to the tables? In your previous post the
> table definitions did not show a SERIAL type or a default of nextval().
The id columns were created using "id serial NOT NULL".
I've gone back this morning and p
On Wednesday, December 28, 2011 6:54:54 am Greg Donald wrote:
> > Are you
> > sure that the sequence is being used to insert those values into the
> > table?
>
> When I insert a new row into either of the tables I previously
> described, the sequence 'Current value' increments by one. When I use
> Are you
> sure that the sequence is being used to insert those values into the
> table?
When I insert a new row into either of the tables I previously
described, the sequence 'Current value' increments by one. When I use
pg_dump to backup the database most of the setval() calls in my SQL
file h
Hello John R Pierce,
When i run the
$su - postgres
#which psql
Its dispalying like:
[root@CentOS-60-32-minimal ]# su - postgres
-bash-4.1$ which psql
/usr/bin/psql
and for $ ldd $(which psql) command it displaying like
-bash-4.1$ ldd $(which psql)
linux-gate.so.1 =>
Hello Devrim,
ya when i run its dispalying like
[root@CentOS-60-32-minimal lib]# rpm -qa | grep postgresql
postgresql90-docs-9.0.6-1PGDG.rhel6.i686
postgresql84-libs-8.4.9-1PGDG.rhel6.i686
postgresql90-libs-9.0.6-1PGDG.rhel6.i686
postgresql90-contrib-9.0.6-1PGDG.rhel6.i686
postgresql90-server-9.0
Here is a partial solution to the problem I encountered (the full solution
uses a UNION ALL and the same statement four times):
SELECT
xmlelement( name "bakeware",
xmlconcat(
array_to_string( array_agg(
xmlelement( name "object",
xmlattributes( e.abridge AS "alias" ),
On 12/28/11 1:54 AM, hosuresh wrote:
I have installed postgresql-9.0 on my CentOS 6.0 server in the directory
/usr/pgsql-9.0/.
Its data directory resides in /var/lib/pgsql/9.0/
unable to run $psql dbname command
when i run the commands its showing the error like:
[root@CentOS-60-32-minimal ~]#
This message has been digitally signed by the sender.
Re___GENERAL__Re__psql_error__psql__symbol_lookup_error__psql__undefined_symbol__PQconnectdbParams.eml
Description: Binary data
-
Hi-Tech Gears Ltd, Gurgaon, India
--
Sent via pgsql-general mailing list (pgs
On Wed, 2011-12-28 at 02:30 -0800, hosuresh wrote:
>
> when i run the command
> rpm -qa | grep postgresql-9.0
>
> Its not dispalying anything...
I did not say postgresql-9.0 -- I said
rpm -qa|grep postgresql
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.en
Hi devrim,
Thanks for the responce
when i run the command
rpm -qa | grep postgresql-9.0
Its not dispalying anything...
-
Regards,
Suresh Hosur
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/psql-error-psql-symbol-lookup-error-psql-undefined-symbol-PQconnectd
This message has been digitally signed by the sender.
Re___GENERAL__psql_error__psql__symbol_lookup_error__psql__undefined_symbol__PQconnectdbParams.eml
Description: Binary data
-
Hi-Tech Gears Ltd, Gurgaon, India
--
Sent via pgsql-general mailing list (pgsql-g
On Wed, 2011-12-28 at 01:54 -0800, hosuresh wrote:
>
> I have installed postgresql-9.0 on my CentOS 6.0 server in the
> directory
> /usr/pgsql-9.0/.
> Its data directory resides in /var/lib/pgsql/9.0/
>
> unable to run $psql dbname command
>
> when i run the commands its showing the error like:
Hi,
I have installed postgresql-9.0 on my CentOS 6.0 server in the directory
/usr/pgsql-9.0/.
Its data directory resides in /var/lib/pgsql/9.0/
unable to run $psql dbname command
when i run the commands its showing the error like:
[root@CentOS-60-32-minimal ~]# su - postgres
-bash-4.1$ psql ms
Tom Lane wrote on 28.12.2011 01:41:
Thomas Kellerer writes:
Tom Lane wrote on 27.12.2011 20:22:
More specifically, look to see if the current transaction has assigned
itself a transaction ID. I think the easiest place to see this is in
pg_locks --- it will be holding exclusive lock on a Trans
Check below link:-
http://wiki.postgresql.org/wiki/XML_Support
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Wed, Dec 28, 2011 at 1:41 PM, Thangalin wrote:
> Hi,
>
> Data in a table called 'equipment_group' (eg) contains various equipment
> categor
On Tue, Dec 27, 2011 at 10:19 PM, Greg Donald wrote:
> But then I have another table:
>
> CREATE TABLE company (
> id integer NOT NULL,
> name character varying(64) NOT NULL,
> [...]
> );
>
> The max(id) in that table is 33, but my sequence is NOT dumped correctly:
>
> SELECT pg_catalog.s
Hi,
Data in a table called 'equipment_group' (eg) contains various equipment
categories:
bakeware
cookware
kitchenware
utensils
I would like to use these values as elements within an XML document.
Something like:
xmlelement( name eg.label )
Each of these data element can have multiple objects
39 matches
Mail list logo
