2009/10/2 Dmitry Samokhin :
> When any server configuration parameters (or variables) are set on a
> per-function basis, the script displayed in the pgAdmin SQL pane looks like
> this:
>
> CREATE OR REPLACE FUNCTION ... ;
> ALTER FUNCTION ... SET ...;
>
> If then I edit the function body and save m
2009/10/4 Thom Brown :
> I've noticed (at least in pgAdmin III v1.8.4) that I can't create a foreign
> key constraint pointing to the table I'm in the process of creating. I can
> do it manually though. Here's an example:
> CREATE TABLE testtable
> (
> id serial NOT NULL,
> parent_id intege
Hi,
Whenever i export a query to CSV that contains booleans, writing the
data is exceptionally slow.
I'm using pgAdmin 1.8.4 on ubuntu, it also occurs in several (all?)
versions on windows.
Cheers,
WBL
--
"Patriotism is the conviction that your country is superior to all
others because you wer
could it be that there is a lot of data (including whitespaces) in the column?
A text record can contain up to 1GB of text AFAIK (the manual says "no
specific upper limit").
WBL
--
"Patriotism is the conviction that your country is superior to all
others because you were born in it." -- George
When a new function is created, the initial default EXECUTE privilege is
granted to PUBLIC (this is described is the documentation), and pgAdmin
generates the followng script:
CREATE OR REPLACE FUNCTION ... ;
ALTER FUNCTION ... OWNER TO ...;
The function's ACL is dispayed in the 'ACL' field in
