Nick wrote:
Still having problems installing the geos file when trying to install
postgis...have a printout of errors we are still getting
computer/compiler/postgis info
rhel 5,
gcc-4.1.2-46el14.4.1
postgis1.4.0
below is our process and the errors we are getting, can anyone tell us
where th
Dmitry Koterov writes:
> Is there a GUI utility to visually edit Postgres DATA (not a database
> schema!), which allows at least:
> - insert/update rows using screen windowed forms (possibly ugly
> auto-generated forms, but - still forms)
> - insert foreign key references by selecting them from
Ivan Sergio Borgonovo writes:
> It seems that you have to actually restore the 2 backup separately.
>
> pg_restore -1 -d mydb < nearly_full.bak
> pg_restore -1 -d mydb < schema_only.bak
>
> I can't think of any other way to restore both in one transaction
> unless I backup in plain text. But that
# da...@fetter.org / 2009-12-31 08:04:58 -0800:
> On Thu, Dec 31, 2009 at 10:52:20AM +0100,
> neuhauser+pgsql-general#postgresql@sigpipe.cz wrote:
> > Hello,
> >
> > this fails with "duplicate key value":
> >
> > CREATE TABLE x (
> > i INT NOT NULL UNIQUE
> > );
> > INSERT
On Sat, Jan 2, 2010 at 1:40 AM, Roman Neuhauser wrote:
> # da...@fetter.org / 2009-12-31 08:04:58 -0800:
>> On Thu, Dec 31, 2009 at 10:52:20AM +0100,
>> neuhauser+pgsql-general#postgresql@sigpipe.cz wrote:
>> > Hello,
>> >
>> > this fails with "duplicate key value":
>> >
>> > CREATE TABLE
Dear sir,
I need to install postgresql in unix solaris, can you please help with the
config file set up and more detail set up instructions.
thanks
Sue
_
Your E-mail and More On-the-Go
On 02/01/2010 19:35, Shu Ho wrote:
> Dear sir,
> I need to install postgresql in unix solaris, can you please help with
> the config file set up and more detail set up instructions.
The first place to start is with the documentation - there are very
detailed instructions on installation and the co
On Saturday 02 January 2010 11:35:42 am Shu Ho wrote:
> Dear sir,
>
> I need to install postgresql in unix solaris, can you please help with the
> config file set up and more detail set up instructions.
>
>
>
> thanks
>
> Sue
>
> _
> Y
The free, open-source SchemaCrawler for SQL Server tool is desinged to
do just this. You can take human-readable snapshots of the schema and
data, for later comparison. Comparisons are done using a standard diff
tool such as WinMerge. SchemaCrawler outputs details of your schema
(tables, views, pro
I need to have members of a particular user
group insert rows into a table and then determine the
recently inserted statement's primary key that was
created from a sequence with the currval() function:
select currval('bla_bla_id_seq');
I have been unable to set these permissions.
I am using 8
Shu Ho wrote:
Dear sir,
I need to install postgresql in unix solaris, can you please help with
the config file set up and more detail set up instructions.
Solaris 10 comes with several versions of PostgreSQL. if you have a
reasonably recent release of sol10, you should have 8.3.x, and you ne
On Saturday 02 January 2010 2:44:34 pm Ivan K wrote:
> I need to have members of a particular user
> group insert rows into a table and then determine the
> recently inserted statement's primary key that was
> created from a sequence with the currval() function:
>
>select currval('bla_bla_id_se
Ivan K writes:
> test=# GRANT USAGE ON SEQUENCE bla_bla_id_seq TO GROUP test_group_01;
> ERROR: syntax error at or near "bla_bla_id_seq" at character 25
> LINE 1: GRANT USAGE ON SEQUENCE bla_bla_id_seq TO GROUP
> test_group_0...
> Why is the "GRANT USAGE ON SEQUENCE" statement failing?
On Saturday 02 January 2010 3:57:40 pm Ivan K wrote:
> Yes, that was the ticket; the commands I needed to
> execute are as follows:
>
> GRANT UPDATE ON bla_bla_id_seq TO GROUP test_group_01;
> GRANT SELECT ON bla_bla_id_seq TO GROUP test_group_01;
> GRANT INSERT ON bla_bla_id_seq TO GROUP test_g
Folks,
I'm working on some SQL intended to expose lock conditions (deadlock,
etc.), but to do this, I need to be able to create such conditions at
will. Rather than build an entire infrastructure from scratch, I'd
like to know if there are any frameworks people are using to create
such conditions
I need a function like regexp_split_to_table where I can split a string to a
table by a space delimiter.
so:
Please Help Me
would convert to:
Please
Help
Me
However I'm stuck working w/ version 8.2.9, so I don't have the
regexp_split_to_table function. Is there any good functions that can hand
Yes, that was the ticket; the commands I needed to
execute are as follows:
GRANT UPDATE ON bla_bla_id_seq TO GROUP test_group_01;
GRANT SELECT ON bla_bla_id_seq TO GROUP test_group_01;
GRANT INSERT ON bla_bla_id_seq TO GROUP test_group_01;
Thanks!
--- On Sat, 1/2/10, Adrian Klaver wrote:
>
>
2010/1/3 Jamie Kahgee :
> I need a function like regexp_split_to_table where I can split a string to a
> table by a space delimiter.
> so:
> Please Help Me
> would convert to:
> Please
> Help
> Me
> However I'm stuck working w/ version 8.2.9, so I don't have the
> regexp_split_to_table function. Is
On Sun, Jan 3, 2010 at 9:30 AM, Brian Modra wrote:
> 2010/1/3 Jamie Kahgee :
>> I need a function like regexp_split_to_table where I can split a string to a
>> table by a space delimiter.
>> so:
>> Please Help Me
>> would convert to:
>> Please
>> Help
>> Me
>> However I'm stuck working w/ version
On Sun, Jan 3, 2010 at 9:37 AM, Allan Kamau wrote:
> On Sun, Jan 3, 2010 at 9:30 AM, Brian Modra wrote:
>> 2010/1/3 Jamie Kahgee :
>>> I need a function like regexp_split_to_table where I can split a string to a
>>> table by a space delimiter.
>>> so:
>>> Please Help Me
>>> would convert to:
>>>
20 matches
Mail list logo
