In linux, given the linux based uid of the user, how might someone implement
column level update restrictions on a uid basis? For example...
create table foo (strcol varchar(256), intcol integer);
Now, I want linux processes runing under uid "joesmith" to be able to update
strcol but not intco
Does anyone know if the Postgres DBD for the Perl DBI supports the array
datatype?
Thanks in Advance !
rray when using something like fetchall_arrayref(). Is there a
doc for this somewhere? I googled around for a while and didn't see anything.
Thanks
-dave
-Original Message-
From: Vick Khera [mailto:vi...@khera.org]
Sent: Thursday, September 10, 2009 12:19 PM
To: Gauthier, Dave
Cc
Hi:
Is it possible to define a constraint that checks all elements of an array type
column?
Example...
create table foo (asset text, owner_uids text[]);
I also have a plperlu function that checks to see if a given uid is valid
(returns a 0/1). It's called validate_uid(text), This function
create table templates
(
template text,
constraint template_not_null_check (template is nit null) deferrable
initially deferred);
ERROR syntax error at or near "DEFERRABLE"
LINE 4: ...nt template_not_null_check (template is not null) DEFERRABLE...
Without the "deferrable initially deferred"
al Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Monday, September 14, 2009 7:19 PM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] syntax troubles using "deferrable initially deferred"
"Gauthier, Dave" writes:
> create table
Hi:
How could I define a constraint on a colum who's value I want to restrict to a
static list of strings? For example, a column colled "gender" which cannot be
NULL and must be either 'M' or 'F'. I can do it with a "check" constraint, but
I can't defer those constraints (the reason I'm askin
operations need to occur, the file needs to be read sequentially
anyway.
Any amount of help would be gladly excepted, even if it's pointing me to
another thread or somewhere in the manual. Thanks,
Dave Huber
This electronic mail message is intended excl
le is the same as
the buffer in PQputCopyData, including the header. If I am wrong, could someone
please let me know? Thanks,
Dave
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sam Mason
Sent: Monday, September 28, 2009
at my prelim testing is
showing me. I will have to let it run for a while with a larger table to see
how it performs in the longrun, but initially this is very positive.
Thanks, guys!
Dave
This electronic mail message is intended exclusively for the individual(
many rows are in
the table and delete the oldest rows manually?
Thanks,
Dave
This electronic mail message is intended exclusively for the individual(s) or
entity to which it is addressed. This message, together with any attachment, is
confidential and may
ation information, please see the website at:
http://2009.pgday.eu/
Regards, Dave
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
help us out.
Regards,
Dave
Original Post:
I am inserting 250 rows of data (~2kbytes/row) every 5 seconds into a table
(the primary key is a big serial). I need to be able to limit the size of the
table to prevent filling up the disk. Is there a way to setup the table to do
this automatically or
27;ll look into this
partitioned table bit.
Thanks,
Dave
-Original Message-
From: John R Pierce [mailto:pie...@hogranch.com]
Sent: Wednesday, October 07, 2009 12:01 PM
To: Dave Huber
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] automated row deletion
Dave Huber wrote:
>
> A
Is it possible to execute a CREATE OR REPLACE FUNCTION with another function or
even have a function modify itself?
Dave
This electronic mail message is intended exclusively for the individual(s) or
entity to which it is addressed. This message, together with
eric value? I want to be able to name the partitions log_1, log_2, ...,
log_x, where x is the record ID / 10. I would also have to be able to
truncate the same way, by dynamically specifying the name of the table to be
deleted.
Well, I appreciate the help, anyway.
Thanks,
Dave
This electronic
e and hotels in the local area can also be found on
the conference website. If you have yet to book your accommodation, I
would suggest doing so as soon as possible as Paris is quite busy at
this time of year.
See you in Paris!
--
Dave Page
PGDay.EU 2009 Conference: http://2009.pgday.eu/
27;on the door' price.
This is possible thanks to the generous support of our sponsors:
http://2009.pgday.eu/sponsors
For more information on the conference, including the talk schedule
and registration and travel information, please visit the website at:
http://2009.pgday.eu/
See you in Pa
u General Leclerc, Paris, France, 75014
33 (1) 43278020
Hotel Sophie Germaine
12 rue Sophie Germain, Paris, France
33-1-43-21-43-75
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
PGDay.EU 2009 Conference: http://2009.pgday.eu/start
--
Sent via pgsql-general mailing list (pgsql-ge
.
If I used different schemas, it resolves data protection issues, but
doing a backup might become a nightmare
In general which is the fast access method?
regards
Dave.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
pgadmin uses multi line queries and copy from 'cvslogs' cannot read them.
Does anyone have a work around or other solution ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
id = i.page_id
WHERE
r.timestamp >= '2012-09-01' AND r.timestamp <= '2013-08-31'
GROUP BY
""Month Name"",
""Target""",367,,"pgAdmin III - Query Tool"
Dave Cramer
dave.cramer(at)credativ(dot)ca
htt
text,
PRIMARY KEY (session_id, session_line_num)
);
2) The exact error message is ERROR: extra data after last expected column
considering ~39000 lines go in before this line I am fairly certain it
is the line.
Dave
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On
OK,
I have a little more information.
Yes, in isolation I can import these lines, however something happens after
69000 lines. These lines cause an error.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Fri, Sep 20, 2013 at 9:59 AM, Adrian Klaver wrote:
> On 09
I tried copying 500 lines above it and it still works :(
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Sep 23, 2013 at 4:15 PM, Alvaro Herrera wrote:
> Dave Cramer escribió:
> > OK,
> >
> > I have a little more information.
> >
> &g
Ok, I found the offending line. It was not the pgadmin line. There was a
line with a large binary insert.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Sep 23, 2013 at 6:31 PM, Adrian Klaver wrote:
> On 09/23/2013 12:46 PM, Dave Cramer wrote:
>
>> OK,
Hi:
Longshot, but here goes
Someone is asking me for a way to architect a model which will store basic
table data (columns with names and rows), but the number and name of the
columns are both variables. I'll call these "data-tables" here.
Example, Store this "data-table"
'col1'
Yes, please check the server logs. There should be no reason whatsoever
that JDBC would effect the results if the query is the same
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Fri, Jan 3, 2014 at 3:42 PM, Igor Neyman wrote:
> > -Original Message-
&g
You said they upgraded the driver but the versions you stated are the same
???
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Wed, Feb 5, 2014 at 12:23 PM, CS DBA wrote:
> Hi All;
>
> We have a client running Pentaho to migrate data.
>
> They recently u
What about a regexp match ?
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tom Lane
Sent: Thursday, February 06, 2014 10:32 AM
To: alexandros_e
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgresql GROUP BY
In theory, you could write a script that opens both DBs, then systematically
inserts or updates records in the destination DB table based on what's in the
source DB table. Brute force, but automatable.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Beh
Ya, they probably don't like that we use server side prepared statements
Might be possible to just mess with classpath's to get it done.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 11 April 2014 17:39, Rob Sargent wrote:
> On 04/11/2014 03:31 PM, Tecn
itter to help with his
efforts. He's one of the project's webmasters and sysadmins and also
contributes to related projects such as pgAdmin. In his spare time, he
serves as President of the Board of PostgreSQL Europe.
Regards, Dave.
--
Dave Page
PostgreSQL Core Team
http://www.postgresql
Hi,
I'm not sure what you mean by without result set ? There is no real
way to get information back from the driver except using a result set.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Wed, May 11, 2011 at 3:19 AM, mephysto wrote:
> Hi,
> I would use c
Hi:
Does...
insert into mytbl (col1) values ('a'),('b'),('c');
... insert records 'a','b','c' in that order while...
insert into mytbl (col1) values ('c'),('b'),('a');
... insert the records in the opposite order?
The order matters because there are triggers on t
t statements in the order I desire.
Thanks
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Thursday, May 12, 2011 4:06 PM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] insert order question
"Gauthier, Dave" writes:
> Does...
Hi:
Is there a way to suppress the "INSERT x x" and "DELETE y" (etc...) messages
in psql?
Thanks in advance
Hi:
>From within a perl/DBI script, I want to be able to make a copy of a record in
>a table, changing only the value of the primary key. I don't know in advance
>what all the columns are, just the table name.
I suppose I could pull the column names for the table from the metadata, query
the
;
insert into maintable (select * from foo);
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gauthier, Dave
Sent: Thursday, May 26, 2011 4:24 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] copy record?
Hi:
>From within a perl/DBI scr
Hi:
I'd like to pass a parameter into an inline psql call that itself calls an sql
script, something like...
psql mydb -c "\i thesqlscript foo"
Where"foo" is the value I want to pass in.
Just as good would be the ability to sniff out an environment variable from
within the sql script ("thesql
I've dealt with something similar by using a check constraint and a stored
procedure. The check constraint calls a stored procedure, passing it (in your
case) the key you want to make sure doesn't exist in some other table. The
stored procedures queries that other table for the key and passes
is static.
-Original Message-
From: Peter Geoghegan [mailto:pe...@2ndquadrant.com]
Sent: Thursday, June 16, 2011 9:56 AM
To: Gauthier, Dave
Cc: Igor Neyman; Mike Christensen; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Constraint to ensure value does NOT exist in another
table?
On 16 Ju
UPDATE uses HOT?
thanks
-Dave
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
, helpfully and
with a great deal of patience, in stark contrast to MySQL lists which
tend to veer towards the sarcastic, the minimal and the obscure.
Kind Regards,
Dave Coventry
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
ons on port 5432? in lock_may_be_available()
(line 164 of /var/www/includes/lock.inc).
The Site is under minimal load with possibly two or three people on it at once.
Can anyone tell me why I get the error every hour or so?
And what steps I could take to remedy this?
Many thanks,
Dave Coventry
--
Sent via pgsql-
Thank you very much for your responses.
On 26 June 2011 21:54, Peter Bex wrote:
> Do you get the error in the logs or do you see it while going to the
> site manually and does it show this instead of rendering a page?
The log don't really give much indication of anything untoward
happening. It's
Apologies, I didn't notice that I was replying off-list.
On 27 June 2011 00:29, Dave Coventry wrote:
> On 26 June 2011 23:37, John R Pierce wrote:
>> I didn't read the whole thread, but is this a Linux server? Linux has a
>> horrible feature, the "Out of M
super user.
I have tried to grant the drupal user (drupaluser) privileges to the table with:
GRANT ALL ON currentTest to drupaluser;
but this fails to resolve the issue.
Can anyone suggest a way forward?
Dave Coventry
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Hi Rick,
Thanks for the response.
What is "the sequence"? and how do I grant the privileges needed to
insert data into the database?
Is it a postgres issue?
~ Dave
On 7 July 2011 19:05, Rick Genter wrote:
>
>
> On Thu, Jul 7, 2011 at 10:03 AM, Dave Coventry wrote:
>
e drupal
> approach is to define a new content type with the fields you need, then
> populate it via create content, choosing that new type, or use the various
> drupal APIs from your custom PHP modules.
Yes, I'm finding that out.
Thanks very much for your input.
Regards,
http://gigaom.com/cloud/facebook-trapped-in-mysql-fate-worse-than-death/
How would PG stack up in a usage situation like this?
Is there a way to get the linux idsid of a user, even for a remote network
connection?
If not, is there a way to capture this somehow when the original connection is
made and maybe stuff it in a temp table or something using whatever means (a
trigger-like mechanism? ) ? Is there a script/func
M
To: Alan Hodgson
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Need linux uid in pg-psql
Alan Hodgson writes:
> On August 19, 2011 07:01:33 AM Gauthier, Dave wrote:
>> Is there a way to get the linux idsid of a user, even for a remote network
>> connection?
> There&#
The only difference JDBC has over psql is that it has to connect via
tcpip. Not sure about pgadmin.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Tue, Aug 23, 2011 at 6:47 PM, Sam Nelson wrote:
> Hi list,
>
> A client is hitting an issue
Does PG support the use of an init script or procedure? I'm looking for
something that'll run unconditionally every time someone makes a DB connection.
This script will create a temp table and stuff some data in it for general use
within that session.
Thanks in Advance for any help!
Hi:
If I have a table that has 2 records which are identical with regard to all
their column values, is there a way to delete one of them, leaving one
remaining? Is there some unique record_id key of some sort I can use for
somethign like this?
Thanks in Advance!
The identification and deleting of the records using ctids seems to have worked
fine.
Thanks !
-Original Message-
From: Andy Colson [mailto:a...@squeakycode.net]
Sent: Tuesday, September 06, 2011 1:55 PM
To: Thom Brown
Cc: Gauthier, Dave; pgsql-general@postgresql.org
Subject: Re
I looked at the link.
Where is the code ? What license ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Tue, Sep 13, 2011 at 4:18 AM, Jimmy K. wrote:
> Hello,
>
> I asked this question on JDBC list, but it seems "dead".
>
> I found alternat
Jimmy,
What was your question ? The JDBC list is not dead.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
2011/9/18 Jimmy K. :
> Thanks for answer, we will try this driver, because it's more
> promising, if we will found some bugs or suggestion, You will be
&g
Hi:
How does one make a metadata change to a DB that's actively being used.
Specifically, I want to drop a view, drop some columns from a table that's used
in the view, recreate the view without those columns.
In the past, I've resorted to connecting as a super user, running "select
procpid f
l about your disk configuration? I know this
doesn't happen on any of the installations of Windows 7 that we use
for testing (which tend to be the MSDN builds, running on local NTFS
disks), so I wonder if there's an icacls bug in a specific build or
rev of Windows, or when used on a certain
ia
> image. To the best of my knowledge there have been no OEM
> modifications of any kind. It describes itself as "Windows 7
> Enterprise", and says it is 32-bit. That's it.
>
> Anything else you'd want me to check?
>
> Karl
>
>
> On Mon, Oct 3,
On Mon, Oct 3, 2011 at 9:42 AM, Thomas Kellerer wrote:
> Dave Page wrote on 03.10.2011 10:11:
>>
>> Karl; can you please provide precise details of your Windows version,
>> and anything unusual about your disk configuration? I know this
>> doesn't happen on any o
ete
> correctly.
> The database cluster initialisation failed.
>
I very much doubt that s the issue being discussed here. I'd suggest
starting a new thread on pgsql-bugs and including your installation logs
from %TEMP%.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @p
seDB who will
discuss PostgreSQL's role in the post-Oracle era.
So, if you haven't done so already, head on over to the website at
http://2011.pgconf.eu/registration/ to register as an attendee to
avoid missing out on what promises to be an outstanding conference in
an fantastic location. See
On Mon, Oct 3, 2011 at 2:15 PM, Dave Page wrote:
> On Mon, Oct 3, 2011 at 9:42 AM, Thomas Kellerer wrote:
>> Dave Page wrote on 03.10.2011 10:11:
>>>
>>> Karl; can you please provide precise details of your Windows version,
>>> and anything unusual about
On Wednesday, October 5, 2011, Craig Ringer wrote:
> On 10/05/2011 03:46 AM, Dave Page wrote:
>>
>> Oh, the joys of supporting Windows :-)
>
> It's funny: for an OS with so relatively few "flavours" and versions, the
number of quirks and bizarre behaviors i
On Wednesday, October 5, 2011, Thomas Kellerer wrote:
> Dave Page, 04.10.2011 21:46:
>>
>> We updated our build system to use BitRock 7 today (for unrelated
>> reasons) which has new features for ACL management. We're going to
>> investigate replacing cacls/icacls
Does 9.2 support an array of ranges? For example, I have the following
int4ranges => [0,5999) and [7000, 7999) which needs to be associated with
the same record.
Thanks,
Dave
are
> necessary. The curly-braces surround the whole array and elements are
> separated by commas.
>
> David J.
>
> On May 30, 2012, at 14:59, Dave Bettin wrote:
>
> > Does 9.2 support an array of ranges? For example, I have the following
> int4ranges => [0
Hi: I think I know the answer to this, but the desire/need is great enough to
get confirmation here.
Is there a way to alias a db name for purposes of redirecting connections?
For example, you have 2 DBs, DBX and DBY. The users always connect to a DB
alias called "USEDB". USEDB points to D
Hi:
Inside a perl/dbi script, I want to determine which privs (select, insert,
update, delete, ...) user 'foo' has on table 'footable'. There must be
metadata tables or a view that has this.
Here's the problem...
Five sites, one DB, all 5 sites have read/write to the DB. If one site goes
down, the other 4 should be able to continue to work with the DB (read and
write). When the dead site comes back on line, it ought to be able to rejoin
the group. If one site become isolated (n
terprisedb.com/ba/foss-licenses
>
> Now, this doesn't directly mention the installer, which is gone at the
> time this is installed. I know it has the same license as Postgres, but
> where is that documented. Dave, any ideas?
The installer code uses the PostgreSQL licence.
emember it is pretty tricky to call pg_ctl from a Windows batch
> file. I know the Windows installers do it somehow --- you might want to
> downlaod it and see if you can find the shell script they use. Dave
> Page might know more --- CC'ing him.
You shouldn't try to start/stop
[Please keep the mailing list CC'd]
On Fri, Aug 17, 2012 at 11:52 AM, Loughrey, Hugh
wrote:
> Hi Dave,
>
> Thanks for the message below. The script you forwarded looks to be for an
> instance in which the DB is running of a windows box, apologies I should have
> mention
Here's the problem
I have a table with a column called "last_name". I have one customer who likes
to articulate queries and updates for this using column name "last_name" (no
problem there) but another who likes to call it "lname" and yet another who
likes to call it "surname".So 3 dif
Thanks for all the replies !
The real problem has nothing to do with names. I just used that as a vehicle
for articulating the problem.
The view approach for queries is workable, at least for queries. Thanks for
the input on that and the idea to replicate the various aliases in the view!
I
..@ringerc.id.au]
Sent: Thursday, August 23, 2012 9:52 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Can column name aliases be supported?
On 08/23/2012 09:32 PM, Gauthier, Dave wrote:
> The view approach for queries is workable, at least for queries. Thanks fo
With \timing set on, I run an update statement and it reports
Time: 0.524 ms
Is that really 0.524 ms? As in 524 nanoseconds?
Also, is this wallclock time or some sort of indication of how much cpu it took?
Thanks for any answers !
Hi:
I want to create a string from the first 3 elements of a csv (for example).
The csv is longer than 3 elements. Example...
aaa,bbb,ccc,ddd,eee,fff,ggg
I want the string "aaa,bbb,ccc".
Tried splitting this to an array (precursor to appending elements 1,2,3), but
failed to be able to ref
Hi:
v9.0.1 on linux.
Trying (failing) a test to see if I can run ddl in a procedure where elements
of the ddl are vars. Consider...
create or replace function newcol (text) returns integer as $$
declare
newcol alias for $1;
begin
alter table target add column newcol text;
return(0);
end
Yup, works like a charm.
Thanks Salah and Tom for the advise !
-dave
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Wednesday, August 29, 2012 11:18 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] using vars in ddl in procedure call
I googled around and found that adding/dropping columns from views is not
available. (if not true, I'm all ears).
Given that, what's the best way to do this? I was thinking along the lines of
a stored procedure that reads the view's definition, modifies it, drops the
view, recreates the view.
Is there a way to determine when a DB was created (create database...)?
Thanks in advance.
If its not too much work, swap them around and retest to see if its really the
DB/version or the machine.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Scott Marlowe
Sent: Friday, September 21, 2012 3:01 PM
To: salah
One thing I sometimes forget to do after loading up an empty DB with data is to
run "analyze". I usually "remember" once I see poor query performance, run the
analyze, and its fixed.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org]
Here's the deal...
Instead of architecting and loading a table like...
create teble foo (col1 text, col2 text, col3 text, col4 text, col5 text);
insert into foo (col1,col2,col3,col4,col5) values ('c1',null,'c3','c4',null);
They did this instead...
create table foo (property text, value text);
in
Thanks for the answers. But I also have a predicate...
select col1,col2 from foo where col4='c4' and col5 <> 'xxx';
How is that done?
From: Richard Broersma [mailto:richard.broer...@gmail.com]
Sent: Tuesday, October 23, 2012 3:24 PM
To: ch...@chriscurvey.com
Cc: Gau
ctually works before running the
> initdb script, and if it doesn't, check %COMSPEC% to see if it really
> points to cmd.exe .
Interesting - thanks for the info Craig. Sandeep; can you please look
into adding such a check to the installer. We already test the
VBscript interpreter, so th
Also for PGAdmin and database drivers?
No, there are no plans to do so.
> Aparantly there are major issues with sideloading in windows 8.
We've seen no problems in our testing, and I haven't seen anything on
the -bugs list. If you see any specific issues, please report th
V9.1.5 on linux
User "select" created (yup, that's right, they want the user name to be
"select". Guess what ptivs it is to have! Don't kill the messanger :-) )
postgres=# grant select on all tables in schema sde to "select";
ERROR: schema "sde" does not exist
postgres=# \l
ubject: Re: [GENERAL] how do I grant select to one user for all tables in a DB?
On Wed, Dec 5, 2012 at 2:12 PM, Gauthier, Dave
mailto:dave.gauth...@intel.com>> wrote:
> V9.1.5 on linux
> User "select" created (yup, that's right, they want the user name to
> be "s
psql (9.1.5)
Type "help" for help.
sde=> select * from foo;
ERROR: permission denied for relation foo
sde=>
.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gauthier, Dave
Sent: Wednesday, December 05, 2012 8:00 AM
To: Chri
If you're from the US and are planning to come to FOSDEM in February,
can you ping me please?
Thanks.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-general mailing list (
What's wrong with this picture. Trying (failing) to create a user called
"select" with default select privs and nothing else. Demo below. Comments in
red...
fcadsql7> psql sde
psql (9.1.5)
Type "help" for help.
sde=# \du
List of roles
Role name |
ministrator, and an empty dialog box
>> appears. This is as far as I can go. Any suggestions?
>
> Does this dialog appear *after* the UAC run-as-admin prompt? Or before?
Also, is a log created in %TEMP%?
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company
byte(s)
> Diff to previous 2840
> adding UTF-8 BOM
No, that's a BOM being added to a multi-language source file.
pgAdmin's Unicode support has always written an appropriate BOM to
Unicode files. See
http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/trunk/pgadmin3/pgadmin/utils/utffile.cpp
-
ll need for
the pre-flight checks, such as the VC++ runtimes. They should be
fairly easy to spot - a directory called postgresql_installer for
example.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company
--
Sent via pgsql-general mailing list (pgsql-general@post
Retype new password:
gator:~ dpage$ su - postgres
Password:
gator:~ postgres$
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.po
401 - 500 of 1235 matches
Mail list logo
