On Sat, Mar 5, 2011 at 8:04 PM, Adrian Klaver wrote:
>
> How did you install Postgres?
i bet he uses one click installer from enterprisedb, i have seen those
messages he describe...
> My guess is that the database was set with trust authentication, this means
> you
> do not have to supply a pas
Godaddy virtual hosting does in fact support postgresql. You have a root
account on the virtual server and you can install whatever you want.
I run several servers with them and all have postgresql, some virtual, some
dedicated servers.
Haven't tried their shared servers though, so I can't say
Gentlemen-
Go-daddy *claims* to support postgres
http://help.godaddy.com/article/2330
YMMV
Martin--
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfa
On Mar 5, 2011, at 7:07 PM, Bret Fledderjohn wrote:
>
> On 5 March 2011 16:08, matty jones wrote:
> I already have a domain name but I am looking for a hosting company that I
> can use PG with. The few I have contacted have said that they support MySQL
> only and won't give me access to inst
On 5 March 2011 16:08, matty jones wrote:
> I already have a domain name but I am looking for a hosting company that I
> can use PG with. The few I have contacted have said that they support MySQL
> only and won't give me access to install what I need or they want way to
> much. I don't need a
matty jones wrote:
> I already have a domain name but I am looking for a hosting company that I can
> use PG with. The few I have contacted have said that they support MySQL only
> and won't give me access to install what I need or they want way to much. I
> don't need a dedicated host which so
On Saturday, March 05, 2011 12:33:50 pm hbaile...@nyc.rr.com wrote:
> Hello,
> I have no IT experience and no funding to hire a technical person or
> resources to take a training course. Also my friends who have programming
> background have not been reliable. I am willing to spend the necessary
>
On Sat, Mar 5, 2011 at 1:08 PM, matty jones wrote:
> I already have a domain name but I am looking for a hosting company that I
> can use PG with. The few I have contacted have said that they support MySQL
> only and won't give me access to install what I need or they want way to
> much. I don't
Hello,
I have no IT experience and no funding to hire a technical person or resources
to take a training course. Also my friends who have programming background have
not been reliable. I am willing to spend the necessary months in trying to
learn how to use an SQL program. I just installed Post
I already have a domain name but I am looking for a hosting company that I
can use PG with. The few I have contacted have said that they support MySQL
only and won't give me access to install what I need or they want way to
much. I don't need a dedicated host which so far seems the only way this
you might consider lowering the fillfactor a bit. It will consume more
space, but it will make updates and inserts faster.
http://www.postgresql.org/docs/8.4/interactive/sql-createtable.html :
fillfactor (integer)
The fillfactor for a table is a percentage between 10 and 100. 100 (complete
packin
Other well known dbms's do have this possibility, because they place deleted
or updated records in a separate table or file (plz correct me if i'm
wrong). But this has other, greater performance disadvantages. The count(*)
problem is a bit of a publicity problem rather than a real performance
probl
On 03/05/11 2:05 PM, Allan Kamau wrote:
Is it possible in theory to efficiently perform count the primary or
unique indices underlying data structures, regardless whether there is
a WHERE clause detailing filtration base on values from such index or
not?
indexes are not exact, due to possibly c
On 03/05/11 11:22 AM, Andre Lopes wrote:
Hi,
I need to transform an PHP array to an PlPgSQL array. The PHP array is
like this:
in a relational database, it would be far better to store that sort of
thing as a table, so you can use relational operations on it.
your example structure would fi
On Sat, Mar 5, 2011 at 8:02 PM, Raymond O'Donnell wrote:
> On 03/03/2011 13:29, obamaba...@e1.ru wrote:
>>
>> I use pgsql 9.0.3 and I know that postgresql tries to use the fields in
>> indexes instead of the original table if it possible
>>
>> But when I run
>>
>> SELECT COUNT(id) FROM tab
>>
>> o
2011/3/5 Dmitriy Igrishin :
>
>
> 2011/3/5 Pavel Stehule
>>
>> 2011/3/5 Dmitriy Igrishin :
>> >
>> >
>> > 2011/3/5 Pavel Stehule
>> >>
>> >> 2011/3/5 Andre Lopes :
>> >> > Hi Pavel,
>> >> >
>> >> > Thanks for the reply.
>> >> >
>> >> > In PlpgSQL there is possible to define arrays with "Key => Va
2011/3/5 Pavel Stehule
> 2011/3/5 Dmitriy Igrishin :
> >
> >
> > 2011/3/5 Pavel Stehule
> >>
> >> 2011/3/5 Andre Lopes :
> >> > Hi Pavel,
> >> >
> >> > Thanks for the reply.
> >> >
> >> > In PlpgSQL there is possible to define arrays with "Key => Value, Key
> =>
> >> > Value"?
> >> >
> >>
> >> N
On 03/03/2011 13:29, obamaba...@e1.ru wrote:
I use pgsql 9.0.3 and I know that postgresql tries to use the fields in
indexes instead of the original table if it possible
But when I run
SELECT COUNT(id) FROM tab
or
SELECT COUNT(*) FROM tab
where there "id" is PRIMARY KEY and there are other i
2011/3/5 Dmitriy Igrishin :
>
>
> 2011/3/5 Pavel Stehule
>>
>> 2011/3/5 Andre Lopes :
>> > Hi Pavel,
>> >
>> > Thanks for the reply.
>> >
>> > In PlpgSQL there is possible to define arrays with "Key => Value, Key =>
>> > Value"?
>> >
>>
>> No, no directly
>>
>> there are no hash array
>>
>> there
Thanks again,
I saw this tutorial on how to get Key => Value,
http://justatheory.com/computers/databases/postgresql/key-value-pairs.html
It is not possible to use hstore to me.
Best Regards,
On Sat, Mar 5, 2011 at 7:42 PM, Pavel Stehule wrote:
> 2011/3/5 Andre Lopes :
>> Hi Pavel,
>>
>> Tha
2011/3/5 Pavel Stehule
> 2011/3/5 Andre Lopes :
> > Hi Pavel,
> >
> > Thanks for the reply.
> >
> > In PlpgSQL there is possible to define arrays with "Key => Value, Key =>
> Value"?
> >
>
> No, no directly
>
> there are no hash array
>
> there is a workaround a hstore module
>
Why hstore is a wo
2011/3/5 Andre Lopes :
> Hi Pavel,
>
> Thanks for the reply.
>
> In PlpgSQL there is possible to define arrays with "Key => Value, Key =>
> Value"?
>
No, no directly
there are no hash array
there is a workaround a hstore module
http://www.postgresql.org/docs/9.0/static/hstore.html
attention -
Hi Pavel,
Thanks for the reply.
In PlpgSQL there is possible to define arrays with "Key => Value, Key => Value"?
Best Regards,
On Sat, Mar 5, 2011 at 7:28 PM, Pavel Stehule wrote:
> Hello
>
> there isn't a simple way :(
>
> the most simply way is using string_to_array function
>
> SELECT func
Hello
there isn't a simple way :(
the most simply way is using string_to_array function
SELECT func(string_to_array('1,2,3,4,5',','));
Regards
Pavel Stehule
2011/3/5 Andre Lopes :
> Hi,
>
> I need to transform an PHP array to an PlPgSQL array. The PHP array is
> like this:
>
> [quote]
> $arr
Hi,
I need to transform an PHP array to an PlPgSQL array. The PHP array is
like this:
[quote]
$arr = array(
0 => array(
"base64" => "ddfff",
"image_t
On Sat, Mar 05, 2011 at 07:38:23AM -0800, ray wrote:
> This has been a great thread! I am missing something because I do not
> know what CTAS is. WOuld someone please help me understand.
Create Table As Select.
Have a nice day,
--
Martijn van Oosterhout http://svana.org/kleptog/
> Patriot
This has been a great thread! I am missing something because I do not
know what CTAS is. WOuld someone please help me understand.
ray
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
hi
perhaps I misunderstood something from commits, but I assumed that in
9.1 this operation shouldn't rewrite the table:
CREATE TABLE test ( x varchar(16) );
insert into test select i::text from generate_series(1,100) i;
alter table test alter column x set data type varchar(32);
but it does.
28 matches
Mail list logo
